Re: [sqlite] Embedded SQL in C

2007-05-27 Thread Peter Wu
> --- Leif Jensen <[EMAIL PROTECTED]> wrote: > > I thought about the "fake" library myself > > even though our project is more like 20 - 30k lines, but I'm not sure > > how bad it would be. Another easy way to embed is to use embedded C/C++ Ch. All sqlite APIs are already supported in Ch and t

Re: [sqlite] Embedded SQL in C

2007-05-27 Thread John Stanton
We have an application server which incorporates Sqlite. It implements a proprietary language to generate embedded server pages and these use regular embedded SQL compiled into the executables. It also has a remote procedure call interface which accesses a repository of SQL using embedded SQl

Re: [sqlite] Embedded SQL in C

2007-05-27 Thread Joe Wilson
--- Leif Jensen <[EMAIL PROTECTED]> wrote: > I thought about the "fake" library myself > even though our project is more like 20 - 30k lines, but I'm not sure > how bad it would be. May not be worth the hassle given the size of your project. Since you're using C, consider rewriting your code u

Re: [sqlite] Embedded SQL in C

2007-05-27 Thread Leif Jensen
That sounds very interesting. Could you please elaborate a little more on that ? Leif John Stanton wrote: The Sqlite BIND capability makes implementing an embedded SQl interface quite a simple operation. We use embedded SQL with Sqlite but do it within a proprietary language. It was alm

Re: [sqlite] Embedded SQL in C

2007-05-27 Thread John Stanton
The Sqlite BIND capability makes implementing an embedded SQl interface quite a simple operation. We use embedded SQL with Sqlite but do it within a proprietary language. It was almost trivial to implement. Leif Jensen wrote: Hi, In a larger project we are using PostgreSQL database and

Re: [sqlite] Embedded SQL in C

2007-05-27 Thread Leif Jensen
Thank you for your ideas. I thought about the "fake" library myself even though our project is more like 20 - 30k lines, but I'm not sure how bad it would be. I'm aware of the SQL dialects, but we have tried to make a point of using "standard" SQL syntax. Of course we might have to develop so

Re: [sqlite] Embedded SQL in C

2007-05-27 Thread Joe Wilson
--- 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

[sqlite] Embedded SQL in C

2007-05-27 Thread Leif Jensen
Hi, 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 Po