[Bioperl-l] Re: [BioSQL-l] PostgreSQL & lookup & insert in bioperl-db

[Elia Stupka]

> 3) Separate the look-up into PL/PgSQL code in the database. Instead of 
> issuing a direct INSERT you call a stored procedure that looks up the 
> entry and inserts it if not yet present. The advantage of this option 
> is that it keeps the bioperl-db layout largely unaffected and hence 
> treats all RDBMSs relatively equal (i.e., cares least about RDBMS 
> idiosyncrasies). The downside is that this means that the Pg version 
> of Biosql can't be fully auto-generated anymore from the MySQL version 
> (I don't want to auto-generate the PL/PgSQL procedures from a MySQL 
> schema definition). Also, people say PL/PgSQL is not the fastest thing 
> out there.

My two cents... is it a big deal not to be able to auto-generate 
Postgres? It seems to be this would be teh cleanest of the three, as 
long as Postgres people are happy to load things from scratch rather 
than from MySQL....

Elia