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

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

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

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

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

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

Re: [sqlite] Sqlite Server

2007-05-27 Thread John Stanton
There is no Sqlite Server unless you use a third party product. Sqlite is a library which links into your application. noname wrote: I am using SQL Server as a back end in my vb6 application i want to switch over to sqlite server but terrainformatica.com site has not provided rates for

Re: [sqlite] Sqlite Server

2007-05-27 Thread Olaf Schmidt
You can use our free XCopy-deployable dhRPCServer for this purpose (using our dhSQLite-COM-Wrapper at the server- and the clientside). Both components are designed, to work together as optimal as possible. The App-Server has a (runtime-) adjustable ThreadPool and can serve up to 1 COM-

Re: [sqlite] Re: Re: Re: COLLATE without ORDER BY?

2007-05-27 Thread Jonas Sandman
Thanks Igor, A custom function was exactly what I needed :-) Best regards, Jonas On 5/25/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Jonas Sandman <[EMAIL PROTECTED]> wrote: >> ext1 is one type of extension, in my case 'mp3'. I guess it doesn't >> make > sense when you have only one, but

Re: [sqlite] Sqlite Server

2007-05-27 Thread P Kishor
Seems like you haven't even bothered to look at the SQLite website. Here are a few hints -- - There is no such thing as a "SQLite server" - There is no such thing as a "SQLite server Developer licence" Rest of the answers are readily available on www.sqlite.org. You should spend about 30 mins

[sqlite] Sqlite Server

2007-05-27 Thread noname
I am using SQL Server as a back end in my vb6 application i want to switch over to sqlite server but terrainformatica.com site has not provided rates for server. so i am confused that should i use it or not i enquired on sites also but i am not getting proper answer from them. My application

[sqlite] Sqlite Server

2007-05-27 Thread noname
I am using SQL Server as a back end in my vb6 application i want to switch over to sqlite server but terrainformatica.com site has not provided rates for server. so i am confused that should i use it or not i enquired on sites also but i am getting proper answer from them. My application process