Am 23.02.2011 03:28, schrieb Phil Oertel: > Hi sqliters, > > After a recent failed attempt to use SQLite as an in-memory fake Oracle for > some of my tests, I'm curious whether anyone has attempted an Oracle > compatibility mode for SQLite. H2 and others have this tremendously useful > feature, but there doesn't seem to be anything available for those not > running on a JVM.
Why is it 'tremendously useful'? If you want an Oracle for testing you can always simply setup an Oracle XE somewhere to have the real syntax and features available without any incomplete 'compatibility mode' that always fails to catch the important little nuances that Oracle does differently. And if it is too slow you can throw money at their Times-Ten product too, which is kinda in memory database. The complexity depends on how shallow the 'compatibility' shall be (e.g. do you want the braindead '' = NULL feature of Oracle, or all of their TO_DATE/TO_CHAR stuff, or Stored Procedures, UPDATE RETURNING, the NLS_LANG crazyness, CREATE SEQUENCE, etc. etc.). In general i would say its not worth the trouble. If you need that kind of portability you should probably use some kind of higher level mapper (for example some ORM like sqlalchemy). Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
