[sqlite] sqlite server-process-edition and begin-concurrent

I am looking for a way to increase concurrency from within cubeSQL. I am highly interested in a couple of sqlite branches: - begin-concurrent seems interesting and updated - sqlite server-process-edition branch has been updated on August 2017 Based on documentation seems like that sqlite

Re: [sqlite] SQLite server/file-locking scenario

On 19 Nov 2013, at 6:40pm, Joshua Grauman wrote: > Under what conditions would an open() create a lock that would cause problems? If you did something with it that would interfere with the processes using SQLite's own API. For instance, if you chose options which involved

Re: [sqlite] SQLite server/file-locking scenario

Right. I'll go look at the source and confirm or just write it myself using POSIX open() which would be easy. I guess I was just asking what kind of locks you are talking about since I'm not familiar with file locking. In other words, if I did a POSIX open("filename", O_RDONLY); or even

Re: [sqlite] SQLite server/file-locking scenario

On 19 Nov 2013, at 5:05pm, Joshua Grauman wrote: > Ok, thanks again for the tips, I'll change the ROLLBACK to END. > > I'm assuming if I open the file read-only it shouldn't lock, right? I'm using > Qt, but I send it a read-only parameter which I assume translates into >

Re: [sqlite] SQLite server/file-locking scenario

Ok, thanks again for the tips, I'll change the ROLLBACK to END. I'm assuming if I open the file read-only it shouldn't lock, right? I'm using Qt, but I send it a read-only parameter which I assume translates into something like a POSIX open("filename", O_RDONLY); Josh On 19 Nov 2013, at

Re: [sqlite] SQLite server/file-locking scenario

On 19 Nov 2013, at 6:00am, Joshua Grauman wrote: > sqlite3_open_v2("sqlite3.database.filename"); > sqlite3_exec("BEGIN IMMEDIATE"); > file.open("sqlite3.database.filename"); > file.readAll(); > file.close(); > sqlite3_exec("ROLLBACK"); > sqlite3_close(); > > So does this

Re: [sqlite] SQLite server/file-locking scenario

Thanks again for the responses, very helpful. Taking into account that I can't just read the database file in my program without some sort of locking as was mentioned and explained clearly by multiple people (thank you!), I tried two different implementations to see which would perform

Re: [sqlite] SQLite server/file-locking scenario

I don't have time right at this minute to carefully read and respond to all the responses to me, but I have to at least at this point say a heartfelt *thank you* to all those who have responded to me. I'm blown away by how detailed and helpful and patient all the responses are. When I have

Re: [sqlite] SQLite server/file-locking scenario

This is gonna be a long one, but I added (hopefully) some humor to make it a bit better of a read. @OP Just so I'm clear, you're pushing SQL statements from clients to your server, but then pushing raw data from the server to the client? Myself, I'd never push a "Work In Progress" database, or a

Re: [sqlite] SQLite server/file-locking scenario

On 17 Nov 2013, at 6:17am, Joshua Grauman wrote: > Thanks so much for the reply. Sorry for the ignorance, but wouldn't only the > sectors (page cache) that are being written need to be cached? If Unix did that (which it doesn't in any File System I know of) then that

Re: [sqlite] SQLite server/file-locking scenario

On Sat, 16 Nov 2013 22:17:31 -0800 (PST), Joshua Grauman wrote: >Thanks so much for the reply. Sorry for the ignorance, but wouldn't only >the sectors (page cache) that are being written need to be cached? Database pages are updated in sqlites page cache, then, being

Re: [sqlite] SQLite server/file-locking scenario

Thanks so much for the reply. Sorry for the ignorance, but wouldn't only the sectors (page cache) that are being written need to be cached? And I was trying to read up on how sqlite does atomic writes, but doesn't the way sqlite handles atomic writes guarentee that the file is *always* in a

Re: [sqlite] SQLite server/file-locking scenario

Thanks so much for the reply. Sorry for the ignorance, but wouldn't only the sectors (page cache) that are being written need to be cached? And I was trying to read up on how sqlite does atomic writes, but doesn't the way sqlite handles atomic writes guarentee that the file is *always* in a

Re: [sqlite] SQLite server/file-locking scenario

On 16 Nov 2013, at 11:37pm, Joshua Grauman wrote: > Or conversely, that if sqlite has the file open to write, my program will > read a cached version (if reading and writing happen at the same time, I'm > fine with the reader getting a slightly stale version). But I'm not

[sqlite] SQLite server/file-locking scenario

Hello all, I am writing a server program that reads and writes several different sqlite databases. Each client program can do one of the following at a time 1) send a file with a bunch of SQL statements that the server will run on the appropriate database, or 2) request an entire database

Re: [sqlite] SQLite server using execnet ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/21/2011 12:37 PM, Jay A. Kreibich wrote: > Yes, but in something like memcached, the database is not aware of > that structure, and can't take advantage of it. Memcached does understand some types and has atomic increment/decrement etc but

Re: [sqlite] SQLite server using execnet ?

On Feb 21, 2011, at 9:37 PM, Jay A. Kreibich wrote: > I was once forced to look at SOAP over SMTP Ah, yes... double S! The S stands for Simple http://wanderingbarque.com/nonintersecting/2006/11/15/the-s-stands-for-simple/ ___ sqlite-users mailing

Re: [sqlite] SQLite server using execnet ?

On Sun, Feb 20, 2011 at 08:37:04PM -0800, Roger Binns scratched on the wall: > On 02/20/2011 06:23 PM, Jay A. Kreibich wrote: > > On Sun, Feb 20, 2011 at 05:23:09PM -0800, Roger Binns scratched on the wall: > >> If you want to use SQL then use Postfix. > > > > I might suggest PostgreSQL

Re: [sqlite] SQLite server using execnet ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/20/2011 06:23 PM, Jay A. Kreibich wrote: > On Sun, Feb 20, 2011 at 05:23:09PM -0800, Roger Binns scratched on the wall: >> If you want to use SQL then use Postfix. > > I might suggest PostgreSQL instead. > (Sorry, Roger, I couldn't resist.)

Re: [sqlite] SQLite server using execnet ?

On Sun, Feb 20, 2011 at 05:23:09PM -0800, Roger Binns scratched on the wall: > If you want a close match to the Python object model then use MongoDB. > > If you want to use SQL then use Postfix. I might suggest PostgreSQL instead. Postgres is likely to give you much better results than

Re: [sqlite] SQLite server using execnet ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/20/2011 04:55 PM, Stef Mientki wrote: > still want to see if a simple client/server setup would solve my current > problems There is no such thing as "simple" client/server. You have to worry about issues like authentication and

[sqlite] SQLite server using execnet ?

hello, knowing that SQllite is not a client/server database, still want to see if a simple client/server setup would solve my current problems for the moment (because I love the simplicity of SQLlite, and planned to go to a client / server database in the future) Now I wonder if anyone has

Re: [sqlite] SQLite server

"Doug" schrieb im Newsbeitrag news:043201cba22a$f023df40$d06b9d...@poweradmin.com... > This is where I think the problems will crop up. > Can you imagine making a > network round trip for each row fetch, and then for each > column fetch of each row (sqlite3_column_type, >

Re: [sqlite] SQLite server

.@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Sylvain Pointeau > Sent: Wednesday, December 22, 2010 7:51 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite server > > Why not doing it with DCOM or Corba or what ever even the so

Re: [sqlite] SQLite server

Of Sylvain Pointeau Sent: Wednesday, December 22, 2010 7:51 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite server Why not doing it with DCOM or Corba or what ever even the sockets? but hidden behind the same API of SQLite. The "real" sqlite lib will be on the server. is

Re: [sqlite] SQLite server

Why not doing it with DCOM or Corba or what ever even the sockets? but hidden behind the same API of SQLite. The "real" sqlite lib will be on the server. is it called "remote procedure call"? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server

On 22 Dec 2010, at 2:41pm, Philip Graham Willoughby wrote: > You would need to reintroduce practically everything you think you can get > rid of if you wish to ensure that there is only one process and you are > intending to provide a facility for two transactions to be active > concurrently.

Re: [sqlite] SQLite server

On 22 Dec 2010, at 13:12, Simon Slavin wrote: > > You do mention something worthwhile: if you had a server/client version of > SQLite you could get rid of all the code to do with file sharing and locking. > That's quite a lot of code, if you include all the PRAGMAs and related > programming

Re: [sqlite] SQLite server

From: Simon Slavin Date: Tue, 21 Dec 2010 14:19:25 + >This was my first thought when I considered implementing an SQLite-over-IP >protocol: that there was no user model and therefore no need for passwords.  >Mounting a >database on the server would mean that anyone who

Re: [sqlite] SQLite server

On 22 Dec 2010, at 12:45am, Jeff Archer wrote: > A SQLite Server would be userful. I have considered creating this myself. I > have thought that it would need to be kept zero config and it should be > provided > in amalgamation form to keep simple to embed in applications. Wouldn't need >

Re: [sqlite] SQLite server

Just my two cents... A SQLite Server would be userful.  I have considered creating this myself.  I have thought that it would need to be kept zero config and it should be provided in amalgamation form to keep simple to embed in applications.  Wouldn't need incredible throughput as it is a 

Re: [sqlite] SQLite server

and what about using a DCOM like technology to open a distant database? the sqlite API will stay the same but behind the scene, it will access your server using a DCOM like technology? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server

Wednesday, December 22, 2010, 1:19:25 AM, you wrote: SS> On 21 Dec 2010, at 1:44pm, Philip Graham Willoughby wrote: >> Implementing an SQLite-based server does not obviously enable this in and of >> itself. If you could open a database on a remote machine using its filename >> as the OP was

Re: [sqlite] SQLite server

On 21 Dec 2010, at 14:19, Simon Slavin wrote: > > On 21 Dec 2010, at 1:44pm, Philip Graham Willoughby wrote: > >> Implementing an SQLite-based server does not obviously enable this in and of >> itself. If you could open a database on a remote machine using its filename >> as the OP was

Re: [sqlite] SQLite server

On Dec 21, 2010, at 2:44 PM, Philip Graham Willoughby wrote: > It should be significantly easier to define a new storage engine for MySQL > that uses the SQLite data format for its tables. While we are on the subject... http://dev.mysql.com/tech-resources/articles/dbixmyserver.html TL;DR:

Re: [sqlite] SQLite server

On Tue, Dec 21, 2010 at 4:44 PM, Philip Graham Willoughby < phil.willoug...@strawberrycat.com> wrote: > On 21 Dec 2010, at 12:16, Max Vlasov wrote: > > > Simon, I read both your suggestion and the Richard's good explanation > about > > network problems. I think that the idea still deserves to

Re: [sqlite] SQLite server

On 21 Dec 2010, at 1:44pm, Philip Graham Willoughby wrote: > Implementing an SQLite-based server does not obviously enable this in and of > itself. If you could open a database on a remote machine using its filename > as the OP was trying to do it would enable this, but we got into this >

Re: [sqlite] SQLite server

On 21 Dec 2010, at 12:16, Max Vlasov wrote: > Simon, I read both your suggestion and the Richard's good explanation about > network problems. I think that the idea still deserves to live in some form > :). I sometimes access sqlite db on a remote computer accessed with sqlite > shell executed in

Re: [sqlite] SQLite server

>> Thanks for that, and the analysis that preceded it. That was my guess, >> especially point 1, the most significant thing. >> Simon, I read both your suggestion and the Richard's good explanation about >> network problems. I think that the idea still deserves to live in some form >> :). I

Re: [sqlite] SQLite server

On Tue, Dec 21, 2010 at 2:24 PM, Simon Slavin wrote: > > Thanks for that, and the analysis that preceded it. That was my guess, > especially point 1, the most significant thing. It's tough to find a decent > extension for SQLite that enough people want. The two

Re: [sqlite] SQLite server

On 21 Dec 2010, at 9:24am, Philip Graham Willoughby wrote: > My hunch is that if this were done the result would be Point 1: > something no-one wants Point 2: > : not much smaller than Postgres/MySQL/etc, as complex to use as > Postgres/MySQL/etc (more so as most stuff you want to achieve

Re: [sqlite] SQLite server

On 20 Dec 2010, at 22:18, Simon Slavin wrote: > > On 20 Dec 2010, at 9:02pm, Richard Hipp wrote: > >> (2) Create your own custom mini-SQL-server using SQLite and your own >> protocol for your applications to talk to that min-server over the network. > > In your opinion (or in the opinion of

[sqlite] SQLite server

On 20 Dec 2010, at 9:02pm, Richard Hipp wrote: > (2) Create your own custom mini-SQL-server using SQLite and your own > protocol for your applications to talk to that min-server over the network. In your opinion (or in the opinion of anyone else intimately familiar with SQLite), is SQLite

Re: [sqlite] SQLite server for Windows/Linux?

On Mon, 26 Oct 2009 15:10:05 -0400, Reid Thompson wrote: >may be of interest >http://sqlrelay.sourceforge.net/ Thanks for the link. Unfortunately, it doesn't seem to support Windows yet. ___ sqlite-users mailing list

Re: [sqlite] SQLite server for Windows/Linux?

On Sat, 2009-10-24 at 16:33 +0200, Gilles Ganault wrote: > On Sat, 24 Oct 2009 00:38:20 +0200, "Olaf Schmidt" > wrote: > >Hmm in this case, what about: > >http://www.realsoftware.com/realsqlserver/ > > Thanks much for the tip :) I'll give it a shot. > > >So, on what platform(s)

Re: [sqlite] SQLite server for Windows/Linux?

On Sun, 25 Oct 2009 02:57:52 -0700 (PDT), George Black wrote: >did you try www.SQLitening.com David Morris just sent a pointer above. Thanks much for the info. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite server for Windows/Linux?

On Sat, 24 Oct 2009 17:37:31 -0700 (PDT), David Morris wrote: >Have a peek at : http://www.sqlitening.com/support/index.php >Different language and could run under Wine on *nix Thanks for the pointer. I didn't know SQLitening.

Re: [sqlite] SQLite server for Windows/Linux?

"David Morris" schrieb im Newsbeitrag news:26044356.p...@talk.nabble.com... > > Have a peek at : http://www.sqlitening.com/support/index.php > Different language and could run under Wine on *nix Ah - yes of course, I left it out here, since it currently is "win only"

Re: [sqlite] SQLite server for Windows/Linux?

did you try www.SQLitening.com Gilles Ganault-3 wrote: > > Hello > > I know that SQLite is meant as a server-less, file server-based > solution, but... since Richard Hipp has also written a single-EXE SCM > solution (www.fossil-scm.org), I wanted to check if someone had > recently written a

Re: [sqlite] SQLite server for Windows/Linux?

Have a peek at : http://www.sqlitening.com/support/index.php Different language and could run under Wine on *nix Olaf Schmidt wrote: > > > "Gilles Ganault" schrieb im > Newsbeitrag news:10h3e55s5ml6kto9rkvasvv1ejc0ao2...@4ax.com... > >> Maybe someone will come up

Re: [sqlite] SQLite server for Windows/Linux?

On Sat, 24 Oct 2009 00:38:20 +0200, "Olaf Schmidt" wrote: >Hmm in this case, what about: >http://www.realsoftware.com/realsqlserver/ Thanks much for the tip :) I'll give it a shot. >So, on what platform(s) do your client-apps need to work? >In what (main)language do you develop

Re: [sqlite] SQLite server for Windows/Linux?

"Gilles Ganault" schrieb im Newsbeitrag news:10h3e55s5ml6kto9rkvasvv1ejc0ao2...@4ax.com... > Maybe someone will come up with a commercial alternative. > I for one would gladly pay for a single-EXE, no-brainer solution > that can run on Windows and *nix. Hmm in this

Re: [sqlite] SQLite server for Windows/Linux?

Thanks for the links On Fri, 23 Oct 2009 08:48:53 -0400, "Griggs, Donald" wrote: >I know almost nothing about them, but the following may possibly be of >interest: > >http://sqlrelay.sourceforge.net/ This one looks quite a bit big for my needs :-/

Re: [sqlite] SQLite server for Windows/Linux?

Gilles, I know almost nothing about them, but the following may possibly be of interest: http://sqlrelay.sourceforge.net/ http://www.it77.de/sqlite/sqlite.htm http://www.sqlite.org/cvstrac/wiki?p=ClientServer Donald ___ sqlite-users mailing list

Re: [sqlite] SQLite server for Windows/Linux?

On Fri, 23 Oct 2009 03:25:45 -0700, Roger Binns wrote: >The problem is that the moment you have a network accessible service you >have to deal with administration. Things like authentication, security, >log files etc. In the absolute, yes, but not if SQLite is to be used

Re: [sqlite] SQLite server for Windows/Linux?

Gilles Ganault wrote: > I wanted to check if someone had > recently written a similar solution so that SQLite can be used as a > light, no-brainer DB server? The problem is that the moment you have a network accessible service you have to deal with administration. Things like authentication,

[sqlite] SQLite server for Windows/Linux?

Hello I know that SQLite is meant as a server-less, file server-based solution, but... since Richard Hipp has also written a single-EXE SCM solution (www.fossil-scm.org), I wanted to check if someone had recently written a similar solution so that SQLite can be used as a light, no-brainer DB

Re: [sqlite] Sqlite Server

There is no Sqlite Server unless you use a third party product. Sqlite is a library which links into your application. noname wrote: I am using SQL Server as a back end in my vb6 application i want to switch over to sqlite server but terrainformatica.com site has not provided rates for

Re: [sqlite] Sqlite Server

You can use our free XCopy-deployable dhRPCServer for this purpose (using our dhSQLite-COM-Wrapper at the server- and the clientside). Both components are designed, to work together as optimal as possible. The App-Server has a (runtime-) adjustable ThreadPool and can serve up to 1 COM-

Re: [sqlite] Sqlite Server

Seems like you haven't even bothered to look at the SQLite website. Here are a few hints -- - There is no such thing as a "SQLite server" - There is no such thing as a "SQLite server Developer licence" Rest of the answers are readily available on www.sqlite.org. You should spend about 30 mins

[sqlite] Sqlite Server

I am using SQL Server as a back end in my vb6 application i want to switch over to sqlite server but terrainformatica.com site has not provided rates for server. so i am confused that should i use it or not i enquired on sites also but i am not getting proper answer from them. My application

[sqlite] Sqlite Server

I am using SQL Server as a back end in my vb6 application i want to switch over to sqlite server but terrainformatica.com site has not provided rates for server. so i am confused that should i use it or not i enquired on sites also but i am getting proper answer from them. My application process

[sqlite] sqlite server

I've revived the sqlite server demo at http://www.it77.de/sqlite/sqlite.htm and updated the API to sqlite 3. This project defines a very simple sqlite server which operates local sqlite databases, and a simple client which links with a lightweight library containing a plug-compatible subset

Re: [sqlite] sqlite server

On Wed, Jun 15, 2005 at 10:47:00AM -0700, [EMAIL PROTECTED] wrote: > It would be nice to have a little server and client library which provided > access to sqlite databases. I wrote one for the purpose of serving > databases, and left the interface open so it could easily be used for > serving

[sqlite] sqlite server

It would be nice to have a little server and client library which provided access to sqlite databases. I wrote one for the purpose of serving databases, and left the interface open so it could easily be used for serving sqlite databases. When the client connects (using telnet or the client