In keeping with their policy of releasing all commercial products as BSD licensed open source within two years of development, PostgreSQL, Inc. has released a robust, scalable replication solution for PostgreSQL under the BSD license. The article quotes an statement from the company which says: “We advocate Open Source, BSD style 🙂 We will consider and develop short term (up to 24 month) proprietary applications and solutions where there is a strong business and intellectual property case to be made. *All” proprietary developments that we are involved in *will* become open source within two years of implementation, without exception.”
PostgreSQL, Inc Releases Replication Product under BSD License
Submitted by Alexandr Kovalenko 2003-08-30 Databases 6 Comments
I’ve been meaning to give PostgreSQL a try, me being mostly a MySQL user and all 😉
Now that I know a bit more about the PostgreSQL philosophy, I believe I will give it a try.
mySql is more or less only tabel store.postgres is RDBMS.
Note that this is only one of the several replication systems for PostgreSQL. Right now it is the most robust and stable one, but spend some time at http://gborg.postgresql.org/ or http://techdocs.postgresql.org/ and you will see that there are a few more in the works, with various capabilities. IMHO, the most interesting one is PGReplication (http://gborg.postgresql.org/projects/pgreplication/ ). It stems from the older replication system Postgres-R, which when fully implemented will be a technically superior to most of the commercial systems out there (http://www.cs.mcgill.ca/~kemme/papers/vldb00/html has a very interesting white paper on the origin of this system). Right now it is very much in development, and not yet available for the latest version of PostgreSQL, but they are making good progress. The intended final result of this project is “Peer-to-peer (update everywhere) with synchronous (eager) propagation”, the ultimate in scaleability and clustering. At present, I believe Oracle is the only DBMS to accomplish this.
Yeah, I’m familiar with the differences between MySQL and PostgreSQL. I just mainly use MySQL at home because it’s easy to setup, administer and develop for. I basically use it for all the things you might use Access for on a Windows machine.
I’ve used Oracle (7 & 8) and SQL Server in production environments, but I think they (even if free) would be way over-kill for the stuff I use a database for.
I’ve just been meaning to try PostgreSQL for some time and never quite managed to get “a rount to it”.
$ psql -H -c “select * from table_name;” -d db_name
Is there anything like this in MySQL? I mean, anything like -H switch which lists the table contents in HTML format.
Why do you ask?