Re: [sqlite] sqlite as server queries

2007-08-07 Thread Christian Smith
Edwin Eyan Moragas uttered: On 8/6/07, Christian Smith <[EMAIL PROTECTED]> wrote: 2) anybody ever implemented something like a single process of sqlite doing queries for a lot of networked clients? A few people have implemented such a solution. It loses one of the benefits of SQLite, howeve

Re: [sqlite] sqlite as server queries

2007-08-07 Thread John Stanton
Edwin Eyan Moragas wrote: On 8/6/07, John Stanton <[EMAIL PROTECTED]> wrote: We use a single process server as an Sqlite server. It works well because it obeys certain constraints: o Transactions are always short o It has many users and many Sqlite databases, but each database does not h

Re: [sqlite] sqlite as server queries

2007-08-07 Thread Edwin Eyan Moragas
On 8/7/07, Gilles Ganault <[EMAIL PROTECTED]> wrote: > At 14:08 06/08/2007 +0100, "Edwin Eyan Moragas" wrote: > >2) anybody ever implemented something like a single process of sqlite > >doing queries for a lot of networked clients? > > Am working on this, in Classic VB5: Winsock control on the serv

Re: [sqlite] sqlite as server queries

2007-08-06 Thread Gilles Ganault
At 14:08 06/08/2007 +0100, "Edwin Eyan Moragas" wrote: 2) anybody ever implemented something like a single process of sqlite doing queries for a lot of networked clients? Am working on this, in Classic VB5: Winsock control on the server, Inet control on the client, the client thinks it's talki

Re: [sqlite] sqlite as server queries

2007-08-06 Thread Edwin Eyan Moragas
On 8/6/07, John Stanton <[EMAIL PROTECTED]> wrote: > > > We use a single process server as an Sqlite server. It works well > because it obeys certain constraints: >o Transactions are always short >o It has many users and many Sqlite databases, but each database > does not have a large nu

Re: [sqlite] sqlite as server queries

2007-08-06 Thread Edwin Eyan Moragas
On 8/6/07, Christian Smith <[EMAIL PROTECTED]> wrote: > > 2) anybody ever implemented something like a single > > process of sqlite doing queries for a lot of networked > > clients? > > > A few people have implemented such a solution. It loses one of the > benefits of SQLite, however, in that SQLi

Re: [sqlite] sqlite as server queries

2007-08-06 Thread John Stanton
Edwin Eyan Moragas wrote: hi group, i have several small questions for the group any experiences or thoughts shared would be greatly appreciated. 1) anybody used sqlite as a sql server? i'm thinking of say using the embedded sqlite in PHP5 or similar. 2) anybody ever implemented something like

Re: [sqlite] sqlite as server queries

2007-08-06 Thread Christian Smith
Edwin Eyan Moragas uttered: hi group, i have several small questions for the group any experiences or thoughts shared would be greatly appreciated. 1) anybody used sqlite as a sql server? i'm thinking of say using the embedded sqlite in PHP5 or similar. 2) anybody ever implemented something l

[sqlite] sqlite as server queries

2007-08-05 Thread Edwin Eyan Moragas
hi group, i have several small questions for the group any experiences or thoughts shared would be greatly appreciated. 1) anybody used sqlite as a sql server? i'm thinking of say using the embedded sqlite in PHP5 or similar. 2) anybody ever implemented something like a single process of sqlite