--- Leif Jensen <[EMAIL PROTECTED]> wrote: > In a larger project we are using PostgreSQL database and Embedded SQL > in C (using ECPG) in a server daemon. We would like to be able to have this > to work with > SQLite for a stand-alone application. The Embedded SQL in C standard is > as used by Oracle (and former Informix) and of course PostgreSQL. > > Does anyone know of an Embedded SQL in C (pre-compiler/interface) > that will work with SQLite ?
I am not aware of such a pre-compiler for SQLite. If your project is quite large (100,000+ lines of code) then porting PostgreSQL's embedded C compiler ECPG to SQLite may be a viable alternative. http://doxygen.postgresql.org/dir_45ac211730e8147f7f879781af2b8b2a.html The main porting effort would be in the ecpglib/ directory, mapping all PQ-prefixed postgres functions and the PG-prefixed data structures to their SQLite equivalents. http://doxygen.postgresql.org/dir_9bd0bfe8893f57601e39e3093fd54938.html A possibly simpler approach may be to construct a "fake" libpq library for use by the PostgreSQL ECPG program that does all the mappings to/from sqlite3. You'd only have to support the subset of libpq functions actually used by ECPG. But even if you did such a port using either approach, be aware that the SQL dialects of Postgres and SQLite are not the same - you'd likely have to change some of the embedded SQL statements in your code. ____________________________________________________________________________________Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. http://tv.yahoo.com/collections/222 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
