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 downloaded and installed it last week. Haven't had a chance to work with it yet, but I was particularly interested in trying to get the PostGIS add-on to work with the ESRI mapping products I use. That, and we're getting an office-wide (all 4 of us!) DB set up to manage all the various bits and pieces of info. we've managed to accumulate. The speed comparisons I looked at suggested it was a good bet. Cheers, Drew.
-
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
-
Marc Clifton wrote:
Preferred alternatives?
Depends on what you want: open source? free database? multi platform? I assume that you have already ruled out SQL Express. If you are looking for a free multi platform database you can go with oracle express.
Rama Krishna Vavilala wrote:
I assume that you have already ruled out SQL Express.
No, not necessarily. Basically something free though, that doesn't limit client connections, and has real tools. I wasn't aware the SQL Express meets those requirements, but I'll go check right now. And Oracle Express, well, I did rule them out. Maybe I'll take another look. 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
-
Rama Krishna Vavilala wrote:
I assume that you have already ruled out SQL Express.
No, not necessarily. Basically something free though, that doesn't limit client connections, and has real tools. I wasn't aware the SQL Express meets those requirements, but I'll go check right now. And Oracle Express, well, I did rule them out. Maybe I'll take another look. 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
You can download tools for SQL Express. http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en[^] Oracle express is good. It has an awesome HTML DB tool. But given a choice between SQL Express and Oracle Express I will go with SQL Express.
My Blog -- modified at 16:21 Friday 17th March, 2006
-
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
Yes, the tool support is somewhat weak ... there is a admin project in development called Flame Robin[^], but it's a good ways off from being feature complete. I've used the following admin tools for various things: Marathon[^] and InterBase Query 4.5[^] - works with Firebird (this does have performance monitors, but I've yet to use them)
-
Yes, the tool support is somewhat weak ... there is a admin project in development called Flame Robin[^], but it's a good ways off from being feature complete. I've used the following admin tools for various things: Marathon[^] and InterBase Query 4.5[^] - works with Firebird (this does have performance monitors, but I've yet to use them)
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
-
You can download tools for SQL Express. http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en[^] Oracle express is good. It has an awesome HTML DB tool. But given a choice between SQL Express and Oracle Express I will go with SQL Express.
My Blog -- modified at 16:21 Friday 17th March, 2006
Rama Krishna Vavilala wrote:
I will go with SQL Express unless I need multi platform stuff or if I am not developing in Java.
Thanks for the link. I just looked at the comparison chart and it looks pretty good. Oracle's move to Java was rather a turnoff for me. 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
-
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 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?
-
I downloaded and installed it last week. Haven't had a chance to work with it yet, but I was particularly interested in trying to get the PostGIS add-on to work with the ESRI mapping products I use. That, and we're getting an office-wide (all 4 of us!) DB set up to manage all the various bits and pieces of info. we've managed to accumulate. The speed comparisons I looked at suggested it was a good bet. Cheers, Drew.
Drew Stainton wrote:
but I was particularly interested in trying to get the PostGIS add-on to work with the ESRI mapping products I use.
Interesting. I just have normal DB requirements though. :) If you think of it and have the time, I'd be curious what you think of it after working with it a bit. 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 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
-
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 ...
-
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