Anyone ever use PostgreSQL?
-
Douglas Troy wrote:
the tool support is somewhat weak
Thanks for the links! There's a lot of players to choose from nowadays, it seems. 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
Yes, yes there are ... If it hadn't been for my system requirements, I would have used SQL Express over Firebird, but Firdbird is tiny compared to Express ...
-
I have used PostGRESQL quite a bit - I worked as a technical architect on a large web-based application (developed in Java) a couple of years ago and it used PostGRESQL exclusively in it's back end. Coming from a primarily SQL Server background, I was quite satisfied with PostGRESQL's performance. There were a few gotchas that caught us along the way (the 32 parameter limit for functions was one that I remember fondly). Any specific questions about PostGRES that you are interested in?
flamebrain wrote:
Any specific questions about PostGRES that you are interested in?
Mostly regarding tool support, were there any bugs you encountered, performance in general, etc.
flamebrain wrote:
the 32 parameter limit for functions was one that I remember fondly).
Does that apply to any SQL statement? Do you know if it's been addressed? 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
-
flamebrain wrote:
Any specific questions about PostGRES that you are interested in?
Mostly regarding tool support, were there any bugs you encountered, performance in general, etc.
flamebrain wrote:
the 32 parameter limit for functions was one that I remember fondly).
Does that apply to any SQL statement? Do you know if it's been addressed? 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
We used PGAdmin as our admin tool, and to run our DB scripts. We used DB scripts for doing everything (table changes, function creation, triggers, etc). As for the 32 parameter limit - that is specifically for DB fuctions (AKA stored procs). This was an issue for us as we did everything with functions (inserts, updates, and deletes) and any table that had more than 32 columns caused us issues. To get around it we had to use arrays as parameters and fill those in code before passing into the DB functions - not pleasant but it worked - and the way we architected everything it was hidden from most of the developers in our data layer. I don't recall any major bugs that we found - mostly little things mostly related to syntax in our functions and special characters. Nothing a google search couldn't fix for us.
-
We used PGAdmin as our admin tool, and to run our DB scripts. We used DB scripts for doing everything (table changes, function creation, triggers, etc). As for the 32 parameter limit - that is specifically for DB fuctions (AKA stored procs). This was an issue for us as we did everything with functions (inserts, updates, and deletes) and any table that had more than 32 columns caused us issues. To get around it we had to use arrays as parameters and fill those in code before passing into the DB functions - not pleasant but it worked - and the way we architected everything it was hidden from most of the developers in our data layer. I don't recall any major bugs that we found - mostly little things mostly related to syntax in our functions and special characters. Nothing a google search couldn't fix for us.
Thanks! One thing I just thought of, when looking at a comparison chart for SQL Express, is, can you do unattended backups with Postgre? (I noticed that SQL Express doesn't include the SQL Agent, which made me think of the question). 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
-
Thanks! One thing I just thought of, when looking at a comparison chart for SQL Express, is, can you do unattended backups with Postgre? (I noticed that SQL Express doesn't include the SQL Agent, which made me think of the question). 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
Yep - backups worked well with Postgre.
-
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
never used it, but the name sounds like it's from the language of Mordor. i like MySql, it has a nice friendly name. no stored procedures, but it makes me happy to know that it's mine. Cleek | Image Toolkits | Thumbnail maker
-
never used it, but the name sounds like it's from the language of Mordor. i like MySql, it has a nice friendly name. no stored procedures, but it makes me happy to know that it's mine. Cleek | Image Toolkits | Thumbnail maker
Chris Losinger wrote:
like MySql, it has a nice friendly name. no stored procedures...
Version 5 has sprocs, as well as a bunch of other features: http://www.mysql.com/products/database/mysql/[^] Jon Sagara Look at him. He runs like a Welshman. Doesn't he run like a Welshman? Doesn't he? I think he runs like a Welshman. My Site | My Blog | My Articles
-
Chris Losinger wrote:
like MySql, it has a nice friendly name. no stored procedures...
Version 5 has sprocs, as well as a bunch of other features: http://www.mysql.com/products/database/mysql/[^] Jon Sagara Look at him. He runs like a Welshman. Doesn't he run like a Welshman? Doesn't he? I think he runs like a Welshman. My Site | My Blog | My Articles
Jon Sagara wrote:
Version 5 has sprocs
even better! i Heart You, MySql! Cleek | Image Toolkits | Thumbnail maker
-
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