RE: [sqlite] Client/Server approach
Hi, Yes, The server and clients are in Network. Best Regards, Sreedhar. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 6:17 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Client/Server approach You do not need a server to manage 5 clients on the same machine, only if they are on a network. Sreedhar.a wrote: > > Hi, > > I am working in sqlite 3.3.6. > I want 5 clients to browse at the same time with good performance. > I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . > I think by using test_server.c we can do 5 clients browsing with > single server. > Can any one please help me by providing some patch for implementing this. > > My doubts are: > 1.Do I need to create a thread for each client.If so it has to be > created before Sqlite3_server_start(). > > (Or) > Some thing like below has to be followed. > > Main() > { > >sqlite3_client_open() >sqlite3_client_prepare() >sqlite3_client_step() >sqlite3_client_reset() >sqlite3_client_finalize() >sqlite3_client_close() > > Sqlite3_server_start(); For starting the server. > > sqlite3_server_stop();For closing the server. > > > > } > > Kindly help me to solve this. > Thanks in advance > > Best Regards, > A.Sreedhar. > > > > > -- > --- To unsubscribe, send email to > [EMAIL PROTECTED] > -- > --- > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Client/Server approach
In that case you are best to implement a server on one machine and have the others connect to it. Since you only have 5 clients you do not need to use the shared cache approach. When we use networked clients we use a server with HTTP protocol so that penetrating firewalls is no problem. Sreedhar.a wrote: I am not using 5 clients from the same machine. In a network 5 clients and 1 server will be present. Regards, A.Sreedhar. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 6:17 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Client/Server approach You do not need a server to manage 5 clients on the same machine, only if they are on a network. Sreedhar.a wrote: Hi, I am working in sqlite 3.3.6. I want 5 clients to browse at the same time with good performance. I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . I think by using test_server.c we can do 5 clients browsing with single server. Can any one please help me by providing some patch for implementing this. My doubts are: 1.Do I need to create a thread for each client.If so it has to be created before Sqlite3_server_start(). (Or) Some thing like below has to be followed. Main() { sqlite3_client_open() sqlite3_client_prepare() sqlite3_client_step() sqlite3_client_reset() sqlite3_client_finalize() sqlite3_client_close() Sqlite3_server_start(); For starting the server. sqlite3_server_stop(); For closing the server. } Kindly help me to solve this. Thanks in advance Best Regards, A.Sreedhar. -- --- To unsubscribe, send email to [EMAIL PROTECTED] -- --- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Client/Server approach
I found one open source api for making network interface for any embedded rdbms. The problem was concurrency,for that reason i develop a small thread pool inside the open source network interface and now one rdmbs connection is shared between threads or applications in network. I implement that for SQLite in Java, i hope you can develope some similar net interface. Sending query to interface and and receiveing results from interface in application is builded with tcp sockets and streams. On 8/24/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > > I am not using 5 clients from the same machine. > In a network 5 clients and 1 server will be present. > > > Regards, > A.Sreedhar. > > > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, August 24, 2007 6:17 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Client/Server approach > > You do not need a server to manage 5 clients on the same machine, only if > they are on a network. > > Sreedhar.a wrote: > > > > Hi, > > > > I am working in sqlite 3.3.6. > > I want 5 clients to browse at the same time with good performance. > > I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . > > I think by using test_server.c we can do 5 clients browsing with > > single server. > > Can any one please help me by providing some patch for implementing > this. > > > > My doubts are: > > 1.Do I need to create a thread for each client.If so it has to be > > created before Sqlite3_server_start(). > > > > (Or) > > Some thing like below has to be followed. > > > > Main() > > { > > > >sqlite3_client_open() > >sqlite3_client_prepare() > >sqlite3_client_step() > >sqlite3_client_reset() > >sqlite3_client_finalize() > >sqlite3_client_close() > > > > Sqlite3_server_start(); For starting the server. > > > > sqlite3_server_stop();For closing the server. > > > > > > > > } > > > > Kindly help me to solve this. > > Thanks in advance > > > > Best Regards, > > A.Sreedhar. > > > > > > > > > > -- > > --- To unsubscribe, send email to > > [EMAIL PROTECTED] > > -- > > --- > > > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > > - > > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > >
RE: [sqlite] Client/Server approach
I am not using 5 clients from the same machine. In a network 5 clients and 1 server will be present. Regards, A.Sreedhar. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 6:17 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Client/Server approach You do not need a server to manage 5 clients on the same machine, only if they are on a network. Sreedhar.a wrote: > > Hi, > > I am working in sqlite 3.3.6. > I want 5 clients to browse at the same time with good performance. > I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . > I think by using test_server.c we can do 5 clients browsing with > single server. > Can any one please help me by providing some patch for implementing this. > > My doubts are: > 1.Do I need to create a thread for each client.If so it has to be > created before Sqlite3_server_start(). > > (Or) > Some thing like below has to be followed. > > Main() > { > >sqlite3_client_open() >sqlite3_client_prepare() >sqlite3_client_step() >sqlite3_client_reset() >sqlite3_client_finalize() >sqlite3_client_close() > > Sqlite3_server_start(); For starting the server. > > sqlite3_server_stop();For closing the server. > > > > } > > Kindly help me to solve this. > Thanks in advance > > Best Regards, > A.Sreedhar. > > > > > -- > --- To unsubscribe, send email to > [EMAIL PROTECTED] > -- > --- > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Client/Server approach
You do not need a server to manage 5 clients on the same machine, only if they are on a network. Sreedhar.a wrote: Hi, I am working in sqlite 3.3.6. I want 5 clients to browse at the same time with good performance. I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . I think by using test_server.c we can do 5 clients browsing with single server. Can any one please help me by providing some patch for implementing this. My doubts are: 1.Do I need to create a thread for each client.If so it has to be created before Sqlite3_server_start(). (Or) Some thing like below has to be followed. Main() { sqlite3_client_open() sqlite3_client_prepare() sqlite3_client_step() sqlite3_client_reset() sqlite3_client_finalize() sqlite3_client_close() Sqlite3_server_start(); For starting the server. sqlite3_server_stop(); For closing the server. } Kindly help me to solve this. Thanks in advance Best Regards, A.Sreedhar. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Client/Server approach
Hi, I am working in sqlite 3.3.6. I want 5 clients to browse at the same time with good performance. I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . I think by using test_server.c we can do 5 clients browsing with single server. Can any one please help me by providing some patch for implementing this. My doubts are: 1.Do I need to create a thread for each client.If so it has to be created before Sqlite3_server_start(). (Or) Some thing like below has to be followed. Main() { sqlite3_client_open() sqlite3_client_prepare() sqlite3_client_step() sqlite3_client_reset() sqlite3_client_finalize() sqlite3_client_close() Sqlite3_server_start(); For starting the server. sqlite3_server_stop(); For closing the server. } Kindly help me to solve this. Thanks in advance Best Regards, A.Sreedhar. - To unsubscribe, send email to [EMAIL PROTECTED] -