Slashdot Mirror
Domain: postgresql.org
Stories and comments across the archive that link to postgresql.org.
Comments · 1,107
-
And it's not that old
The GPL'd version is 3.20.32a; the version I got with Redhat 6.0 and am still using is 3.21.30. This is so recent that I'd think the logical next step would be just to put the current CVS version under GPL.
Meanwhile, the PostgreSQL team is adding new features at a truly impressive rate. The good effects of having TWO full blown database systems competing with each other in open source can't be underestimated.
-- -
Well, here's what I know (for what it's worth)The database-driven websites that I have The Houston Northwest Bar Association Website (with an attorney finder) and the The C Bookstore (plug!plug!plug!) are based on PostgreSQL rather than mySQL so I don't know how well these lessons apply, but I've learned that PostgreSQL has a considerable overhead to each query so one big query is better than lots of little queries.
Of course, neither of those sites is particularly busy and I'm more proud of the management utilities than the sites themselves, but that's par for this course.
The thing I did learn was that using perl and CGI is quite clumsy for this sort of thing. I eventually switched to PHP3 because everything goes together much faster. I don't know what it does to the performance, but since both sites are being served from the world's slowest Web server hardware (the database server is a 486dx2-80 and the database server has the HNBA website on it but the C Bookstore Web server is the 5x86-120 that I use for most of the four dozen or so domains that I host) and performance is not that big an issue, I'm not all that worried. It'd be nice if it got some hits, though.
-
SpeedI've been using MySQL to backend my web sites for about 6 months. It is fast.
However, what are the real comparison numbers? Are we talking 3-4% on 1 million rows?
If PostgreSQL is only slightly slower that MySQL, I would consider switching.
A.
--
Adam Sherman -
MySQL is another bad one
MySql is another bad one and it doesn't even attempt to follow the SQL standards!
Use PostgreSQL instead.
As for mirroring multiple machines, the best way to do this is to use rsync along with SSH 1.2.27 and the blowfish encryption which uses less CPU time. Also make sure to turn on compression in rsync, -z I believe.
--
Michael Dillon - E-mail: michael@memra.com -
What's wrong with Object-Relational DBs?What's wrong with Object-Relational DBs like Oracle or PostgreSQL?
They offer object-oriented features like inheritance but still give access to the searching power of SQL. Take your pick, buy Oracle or download the Open Source PostgreSQL.
--
Michael Dillon - E-mail: michael@memra.com -
Oracle8i free CD's license...Take care. The license is pretty restrictive. Only the user being sent the CD can use the software, and then only for development. No personal Oracle DB. Also, you cannot publish benchmarks to any third party (your buddies qualify as 3rd parties).
Of course, web-click licenses are probably on even shakier legal standing than shrink-wrap ones, but I can't afford a lawyer.
If you need something, consider the following DBs first, as they have free licenses:
On a less-free note, but still of interest, there is also MySQL, although it's more of a glorified hash engine than a RDBMS.No, these products aren't as stable or feature-full. However, you are under no restrictions to limit yourself to the features they do offer. You can add as many of your own as you like. And you're also not limited in what you can do, say, or think about these DBs.
Jason
-
WHO CARES? PostgreSQL that's who!There is an OSS alternative to MySQL and it is a darn good product too.
Try out PostgreSQL. It is an object-relational database and I have personally used it with PHP, Python, Java and through the ODBC driver on Windows machines. I have set it up on Linux machines, FreeBSD 2.1 and FreeBSD 3.0 machines. And I have used it in commercial projects and will do so again.
--
Michael Dillon - E-mail: michael@memra.com