Anyone ever use PostgreSQL?
-
Any pointers? Tips? Suggestions? Preferred alternatives? Thanks! Marc Pensieve Functional Entanglement vs. Code Entanglement Static Classes Make For Rigid Architectures Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
I've used it in quite a few different apps (php, .net) and i'm *very* satisfied with it! The database is excellent (but if you want to make it as fast as it can be, then you have to fiddle with it a bit - with the settings, that is) and their support is great as well. I'd recommend it for everything, except if you need an embedded db .. then I usually go with firebird. Regads, Tadej
-
I've used it in quite a few different apps (php, .net) and i'm *very* satisfied with it! The database is excellent (but if you want to make it as fast as it can be, then you have to fiddle with it a bit - with the settings, that is) and their support is great as well. I'd recommend it for everything, except if you need an embedded db .. then I usually go with firebird. Regads, Tadej
Oh, and you should also read http://searchopensource.techtarget.com/originalContent/0,289142,sid39\_gci1172668,00.html, which goes through some incorrect "facts" about postgresql.
-
Jon Sagara wrote:
Version 5 has sprocs
even better! i Heart You, MySql! Cleek | Image Toolkits | Thumbnail maker
-
Douglas Troy wrote:
but I've been using Firebird[^] for a bit now, and it's good.
What about tools similar to SQL Server's Enterprise Manager and Query Analyzer? I've heard that Firebird doesn't have very good tool support. Is that true? Marc Pensieve Functional Entanglement vs. Code Entanglement Static Classes Make For Rigid Architectures Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
I have been happy with the lite versions from EMS. I also use IBEasy+ with Firebird. http://www.sqlmanager.net[^] They have versions for several major products. "Every new day begins with possibilities. It's up to us to fill it with things that move us toward progress and peace.” (Ronald Reagan)
-
Any pointers? Tips? Suggestions? Preferred alternatives? Thanks! Marc Pensieve Functional Entanglement vs. Code Entanglement Static Classes Make For Rigid Architectures Some people believe what the bible says. Literally. At least [with Wikipedia] you have the chance to correct the wiki -- Jörgen Sigvardsson
MySQL and MaxDB (based on MySQL and used in SAP now). Keep in mind my info is a bit dated, but PostgreSQL has always been slower than MySQL. And since MySQL 5.0, it offers everything Postgre SQL does. Also, if it's good enough to run SAP on, then it's good enough for me. SAP is not a toy application. Some people have used Firebird and liked it, but I can't comment too much on it as I haven't used it. The biggest downside to MySQL (or most probably) is lack of GUI tools for the db. MySQL does have one (called MySQL Administrator), but it only handles db creation and not sql statements. Jeremy Falcon