Re: [sqlite] Client/Srever SQLite

2008-06-20 Thread Alexey Pechnikov
> I use mutexes set up as read or write locks around Sqlite to synchronize > access. In Sqlite 3.5.9 function "db timeout" work fine, I was test it. So internal mutex is enough now, I think. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Client/Srever SQLite

2008-06-18 Thread Simon Gornall
I wrote a simple client/server SQLite implementation a while ago - the tarball is at http://blog.gornall.net/assets/sqld.tar.bz2 though the network-connection to the server is a bit flaky at the moment... It's freeware, and comes with (C) server and (Objective C) client code. You'll need

Re: [sqlite] Client/Srever SQLite

2008-06-18 Thread John Stanton
Alexey Pechnikov wrote: > В сообщении от Wednesday 18 June 2008 23:40:05 John Stanton написал(а): >> Alexey Pechnikov wrote: >>> В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а): The magic potion is the ability to embed Sqlite in the application server and avoid

Re: [sqlite] Client/Srever SQLite

2008-06-18 Thread Alexey Pechnikov
В сообщении от Wednesday 18 June 2008 23:40:05 John Stanton написал(а): > Alexey Pechnikov wrote: > > В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а): > >> The magic potion is the ability to embed Sqlite in the application > >> server and avoid IPCs and multiple processes. >

Re: [sqlite] Client/Srever SQLite

2008-06-18 Thread Alexey Pechnikov
В сообщении от Wednesday 18 June 2008 18:42:25 John Stanton написал(а): > The magic potion is the ability to embed Sqlite in the application > server and avoid IPCs and multiple processes. Why not multiple processes? And what about threads? If Sqlite library is used in multi-threaded

Re: [sqlite] Client/Srever SQLite

2008-06-18 Thread John Stanton
I buffer input from a socket so that socket reads are performed in large chunks and extract characters from that buffer as needed by parsers etc. To write data to a socket I buffer the write into a memory mapped file and then use sendfile (TransmitFile on Windows) to move it out efficiently

Re: [sqlite] Client/Srever SQLite

2008-06-17 Thread Alex Katebi
Hi John, I was writing a message into the socket partially. I had done this to avoid coping. This caused many transmissions for a single message. At the other end I was doing MSG_PEEK optional flag which was wasteful. I had done this to dump the message for debugging. By building my

Re: [sqlite] Client/Srever SQLite

2008-06-17 Thread John Stanton
What did you change? What was causing the lag? Alex Katebi wrote: > slowness is fixed. Can't tell the difference between client/server speed > from library. > > On Sat, Jun 14, 2008 at 8:32 PM, Alex Katebi <[EMAIL PROTECTED]> wrote: > > >>Hi All, >> >> Looks like there is some interest. I

Re: [sqlite] Client/Srever SQLite

2008-06-16 Thread Alex Katebi
slowness is fixed. Can't tell the difference between client/server speed from library. On Sat, Jun 14, 2008 at 8:32 PM, Alex Katebi <[EMAIL PROTECTED]> wrote: > Hi All, > >Looks like there is some interest. I will announce when I release it. > Currently I am developing an interactive user

Re: [sqlite] Client/Srever SQLite

2008-06-14 Thread Alex Katebi
Hi All, Looks like there is some interest. I will announce when I release it. Currently I am developing an interactive user shell client. This shell is used for my client/server development. It can also be embedded for any clients user interface. The request/response is a little slow for some

Re: [sqlite] Client/Srever SQLite

2008-06-14 Thread Rick Langschultz
I am using SQLite for a storage backend for a phone application, the application downloads the information from an XML-RPC based host and sends information to and from a database. The data is held in the database so the phone application doesn't have to get all the information every 15

Re: [sqlite] Client/Srever SQLite

2008-06-13 Thread Alexey Pechnikov
В сообщении от Monday 02 June 2008 19:40:58 Alex Katebi написал(а): > Hi All, > > I am using remote procedure calls (RPC) for SQLite in my application. I > have implemented a few SQLite RPC functions that I needed successfully. > I am wondering if there are other people like me who need this. >