Re: [sqlite] Recommend server for Windows?

2007-06-22 Thread Asif Lodhi
Hi Gilles, On 6/20/07, Gilles Ganault <[EMAIL PROTECTED]> wrote: At 16:49 19/06/2007 -0700, Medi Montaseri wrote: The context is that, until now, our apps were almost used on stand-alone hosts with only a few customers hosting the (small) SQLite database file on a shared drive on the LAN, so

Re: [sqlite] Recommend server for Windows?

2007-06-20 Thread John Stanton
Gilles Ganault wrote: At 20:47 19/06/2007 -0500, John Stanton wrote: Such a server can be made simpler then mine by making it single threaded. Is it publicly available from http://www.viacognis.com? Thanks G. No, but I can give you some code which might help your project. The components

Re: [sqlite] Recommend server for Windows?

2007-06-19 Thread Gilles Ganault
At 20:47 19/06/2007 -0500, John Stanton wrote: Such a server can be made simpler then mine by making it single threaded. Is it publicly available from http://www.viacognis.com? Thanks G. - To unsubscribe, send email

Re: [sqlite] Recommend server for Windows?

2007-06-19 Thread John Stanton
Gilles Ganault wrote: At 11:20 19/06/2007 -0400, Clay Dowling wrote: I'm going to recommend PostgreSQL. Thanks for the idea, but if possible, we'd rather something really basic, typically a single EXE. Besides, using eg. PostgreSQL would require rewriting our application. I went

RE: [sqlite] Recommend server for Windows?

2007-06-19 Thread Gilles Ganault
At 16:49 19/06/2007 -0700, Medi Montaseri wrote: While its difficult to tell what the problem statement (or context) is, but the ingrediants like HTTP and POST spells SOAP. The context is that, until now, our apps were almost used on stand-alone hosts with only a few customers hosting the

RE: [sqlite] Recommend server for Windows?

2007-06-19 Thread Medi Montaseri
While its difficult to tell what the problem statement (or context) is, but the ingrediants like HTTP and POST spells SOAP. -Original Message- From: Gilles Ganault [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 4:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Recommend

Re: [sqlite] Recommend server for Windows?

2007-06-19 Thread Gilles Ganault
At 11:20 19/06/2007 -0400, Clay Dowling wrote: I'm going to recommend PostgreSQL. Thanks for the idea, but if possible, we'd rather something really basic, typically a single EXE. Besides, using eg. PostgreSQL would require rewriting our application. I went through the list of servers on

Re: [sqlite] Recommend server for Windows?

2007-06-19 Thread Clay Dowling
Gilles Ganault wrote: > We'd really like to stick to SQLite because it's very easy to set up, and > most of our customers don't have anyone technical around to help them set > up a DBMS server. I'm going to recommend PostgreSQL. It's very easy to install from your application's installer and

[sqlite] Recommend server for Windows?

2007-06-19 Thread Gilles Ganault
Hello Until now, our users were mostly single-hosts, and the few who did share an SQLite database through a shared drive had a small database and very low concurrency. But a couple of new ones have a DB that's about 50MB, running on a 10Mbps LAN... and an INSERT takes about 10 seconds :-/