Postgres Storage Engine for MySQL, Stranger then Fiction

« previous entry | next entry »
Apr. 1st, 2007 | 07:16 am

A prompt is worth a thousand characters:

mysql> INSTALL PLUGIN postgres SONAME 'libpostgres_engine.so';
Query OK, 0 rows affected (0.02 sec)


mysql> create table april (a int , b varchar(100)) ENGINE=postgres;
Query OK, 0 rows affected (0.00 sec)

mysql> show engines;
+------------+----------+----------------------------------------------------------------+--------------+-----+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+----------+----------------------------------------------------------------+--------------+-----+------------+
| ndbcluster | DISABLED | Clustered, fault-tolerant tables | YES | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | YES | Federated MySQL storage engine | YES | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| POSTGRES | YES | Postgres storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+----------+----------------------------------------------------------------+--------------+-----+------------+
10 rows in set (0.00 sec)

mysql> select * from april;
Empty set (0.00 sec)

This is obviously a very early release, so you shouldn't expect much to work. It was also only made to work with Fedora Core 5, and there will be problems for other platforms.

http://download.tangent.org/postgres_engine-0.1.tar.gz

Link | Leave a comment | Add to Memories | Share

Comments {9}

Storage engine or 'query engine'?

from: kawad
date: Apr. 2nd, 2007 04:50 am (UTC)
Link

Will this engine (in future?) actually execute queries in PostgreSQL?
Or will it just act as a 'storage engine' converting to/from PGSQL data files?

Reply | Thread

Brian "Krow" Aker

Re: Storage engine or 'query engine'?

from: krow
date: Apr. 2nd, 2007 08:55 pm (UTC)
Link

If it was completed, it would be a "storage engine" not an execution engine. See my post about this being an April's Fool Joke, and Patrick's ODBC engine if you want an execution engine.

Reply | Parent | Thread

tx?

from: asnaps
date: Apr. 2nd, 2007 07:00 am (UTC)
Link

Since this is still work in progress, I'll avoid the flame war here, but what about transaction support and everything that makes it worthwhile, IMHO at least, to go for PostgreSQL rather than MySQL?
Are these planned to make it in the engine?
Thanks,
Alex

Reply | Thread

Brian "Krow" Aker

Re: tx?

from: krow
date: Apr. 2nd, 2007 06:27 pm (UTC)
Link

First of all I only made enough of this work so that I could have some fun on April 1 :)

At the moment this fits into the general definition of "if Brian takes and interest or gets a patch it will do X". From a few piece of email I've gotten their are enough users who want to do easy migrations or do federation (aka take advantage of other MySQL engines) that there is a need for this.

If most of the basics where done, hooking up transaction support would not be that difficult (in fact this is one of a couple of places where the design matches MySQL's well).

Reply | Parent | Thread

C.J. Adams-Collier

(no subject)

from: cjcollier
date: Apr. 3rd, 2007 04:05 pm (UTC)
Link

I so totally thought of this first... :)

Reply | Thread

Brian "Krow" Aker

(no subject)

from: krow
date: Apr. 3rd, 2007 07:56 pm (UTC)
Link

Yeah right :)

Reply | Parent | Thread

C.J. Adams-Collier

(no subject)

from: cjcollier
date: Apr. 5th, 2007 04:04 am (UTC)
Link

no, really! Ask Mårten!

Reply | Parent | Thread

mapopa

any update on this ?

from: mapopa
date: Oct. 17th, 2007 01:08 pm (UTC)
Link

nice joke :)

Reply | Thread

Brian "Krow" Aker

Re: any update on this ?

from: krow
date: Oct. 17th, 2007 03:34 pm (UTC)
Link

Just five months till the release :)

Reply | Parent | Thread