Re: [sqlite] remote access to sqlite db?
On Sun, 2 Sep 2007 23:23:43 -0400, you wrote: Hi, Does sqlite offer the ability to connect to a sqlite db file on a remote machine? I've been using it locally for awhile and it's great. Wanted to see if it could be used remotely for some simple tasks. It does, but there are restrictions: http://www.sqlite.org/whentouse.html For very low concurrency (one user at a time), it shouldn't be a problem, but you will notice loss of speed. There are also a few client/server drivers for SQLite: http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork http://www.sqlite.org/contrib sqlite-networked Thanks, Mark Hope this helps. Regards, -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] remote access to sqlite db?
You could always use rails and get to your database through an html connection. You can take your choice of web servers though the built in mongrel-rails server will easily handle 20-30 concurrent connections. Scott Kees Nuyt wrote: On Sun, 2 Sep 2007 23:23:43 -0400, you wrote: Hi, Does sqlite offer the ability to connect to a sqlite db file on a remote machine? I've been using it locally for awhile and it's great. Wanted to see if it could be used remotely for some simple tasks. It does, but there are restrictions: http://www.sqlite.org/whentouse.html For very low concurrency (one user at a time), it shouldn't be a problem, but you will notice loss of speed. There are also a few client/server drivers for SQLite: http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork http://www.sqlite.org/contrib sqlite-networked Thanks, Mark Hope this helps. Regards, -- - What county can preserve its liberties, if its rulers are not warned from time to time that its people preserve the spirit of resistance. Thomas Jefferson - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] remote access to sqlite db?
On 9/4/07, Scott Derrick [EMAIL PROTECTED] wrote: You could always use rails and get to your database through an html connection. You can take your choice of web servers though the built in mongrel-rails server will easily handle 20-30 concurrent connections. Scott Kees Nuyt wrote: On Sun, 2 Sep 2007 23:23:43 -0400, you wrote: Hi, Does sqlite offer the ability to connect to a sqlite db file on a remote machine? I've been using it locally for awhile and it's great. Wanted to see if it could be used remotely for some simple tasks. It does, but there are restrictions: http://www.sqlite.org/whentouse.html For very low concurrency (one user at a time), it shouldn't be a problem, but you will notice loss of speed. There are also a few client/server drivers for SQLite: http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork http://www.sqlite.org/contrib sqlite-networked Thanks, Mark Hope this helps. Regards, -- - What county can preserve its liberties, if its rulers are not warned from time to time that its people preserve the spirit of resistance. Thomas Jefferson - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] remote access to sqlite db?
Hi, Does sqlite offer the ability to connect to a sqlite db file on a remote machine? I've been using it locally for awhile and it's great. Wanted to see if it could be used remotely for some simple tasks. Thanks, Mark - To unsubscribe, send email to [EMAIL PROTECTED] -