What do you guys know about PostgresSQL?

PlatinumGold

Lifer
Aug 11, 2000
23,168
0
71
One of my primary Vendors switched over from Advantage Database (BARF) to PostGreSQL database.

what do you guys know about it? is it a full featured database? can it do site to site replication? can is it a bandwidth hog?

will PostgresSQL Apps connect to the database via wireless ok? (With advantage, my app wouldn't connect to the database via wireless, it had to have 100 mb/s bandwidth).

just curious, i won't be able to get my hands on a beta copy of this app for another couple of months.

i'm excited anyway. anything is going to be better than Advantage, and what i've read about PostgreSQL so far sounds pretty good.
 

LuckyTaxi

Diamond Member
Dec 24, 2000
6,044
23
81
I'm a mySQL fanboy and from what I've heard/read, PostgreSQL is way better than mySQL. However, that doesnt stop me from using mySQL due to its simplicity. It has some features that are lacking in mySQL, but I think mySQL may have caught up by now. Anyways, if some large corporations are using mySQL, I'm sure PostgreSQL is just as good, if not better.
 

Nothinman

Elite Member
Sep 14, 2001
30,672
0
0
There are ODBC drives for PostgreSQL, to find out the bandwidth requirements you'll probably just have to play around and see.

Overall PostgreSQL is a much more complete database solution than MySQL, but it's more complicated to setup.
 

Apathetic

Platinum Member
Dec 23, 2002
2,587
6
81
PostgreSQL is an excellent database. Version 8.0 just added Point In Time recovery and Savepoints.

linky

Dave
 

sourceninja

Diamond Member
Mar 8, 2005
8,805
65
91
PostgreSQL is a wonderful database, on par with oracle, ms sql, etc. We use oracle and mysql (for small web projects) here at work, but given the choice, I would use PostgreSQL. Its free, open-source, and efficent. I havn't found anything that I can do in oracle, that I can't do in PostgreSQL. Its a very serious large scale database solution.
 

PlatinumGold

Lifer
Aug 11, 2000
23,168
0
71
so basically, no one has anything bad to say about it. sounds wonderful. the vendor chose a great product. very nice.

makes my job (implementing solutions) for various types of offices much easier. i was tired of having to resort to terminal services / citrix for all forms of remote access. don't get me wrong there are situations where terminal services/citrix is the perfect solution but there are many more situations where i'd rather have a vpn solution with a server to server replication model.

very very exciting.
 

Apathetic

Platinum Member
Dec 23, 2002
2,587
6
81
Just make sure you give yourself LOTS of time to experiment with installation and configuration.

Dave
 

PlatinumGold

Lifer
Aug 11, 2000
23,168
0
71
Originally posted by: Apathetic
Just make sure you give yourself LOTS of time to experiment with installation and configuration.

Dave

i googled some gui utilities you can buy to configure PostgreSQL, any of them worth buying into until i get comfortable with it?