PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. "PostgreSQL is one of the best-managed open source projects out there" a friend-in-the-know told me about 2 years ago, so today we feature a mini-interview with five members of the PostgreSQL team about their plans on the popular DB.
Permalink for comment
To read all comments associated with this story, please click here.
Well, our servers run on freebsd & redhat, but our development machines are windows(most client apps we write are pure mfc code).
Well, I've gotten the cygwin version of postgres to work but it's much too painful and is different on different versions of windows(xp vs 2000). So that's not recommended. Can't wait till they come out with a proper win32 port. However it's really cool to have the same database & code run on cygwin/freebsd/linux.
Postgres is also higher perfomance for our database needs than MySQL. We also rely on stored procs a lot, so mysql isn't even a candidate. Another nice thing about postgres is that it cares about your data. It bitches and curses at your if you enter data incorrectly. Mysql on the other hand will happily substitute your input with something else if it doesn't understand.
Postgres is also bsd licensed which means it's much cooler to work with for commercial people. Unfortunately we don't do any postgres coding, we just use it.
pgaccess is a cool tool, but it's buggy and all ofthe other postgres tools are rather crappy too, there was a commercial trial app that I used for a while. It was actually pretty quality, but the name escapes me.
Well, our servers run on freebsd & redhat, but our development machines are windows(most client apps we write are pure mfc code).
Well, I've gotten the cygwin version of postgres to work but it's much too painful and is different on different versions of windows(xp vs 2000). So that's not recommended. Can't wait till they come out with a proper win32 port. However it's really cool to have the same database & code run on cygwin/freebsd/linux.
Postgres is also higher perfomance for our database needs than MySQL. We also rely on stored procs a lot, so mysql isn't even a candidate. Another nice thing about postgres is that it cares about your data. It bitches and curses at your if you enter data incorrectly. Mysql on the other hand will happily substitute your input with something else if it doesn't understand.
Postgres is also bsd licensed which means it's much cooler to work with for commercial people. Unfortunately we don't do any postgres coding, we just use it.
pgaccess is a cool tool, but it's buggy and all ofthe other postgres tools are rather crappy too, there was a commercial trial app that I used for a while. It was actually pretty quality, but the name escapes me.