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 server
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 exclusive
opening,
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 fopen("
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
> something like a POSI
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 6:
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 look like I should alwa
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 better.
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 more
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
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
might be one approach. B
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 'dirty',
flushed to the fi
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 valid
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
val
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
> completely clear o
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 file
-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 d
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 li
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 instead.
-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.)
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 th
-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 authorization
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 consi
"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,
> sqlite3_column_double,
to: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 sockets?
> but hidden behind t
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
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
http://sq
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.
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
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 knew your IP
>address
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
>
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 Serv
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
http://sqlite.or
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 try
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 trying
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: use
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 live
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
> disc
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 t
>> 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 som
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 extensions I see most
> referred
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 wi
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 any
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 suite
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
sqlite-users@sqlite.org
http://sq
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) do your client-ap
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
http://sqlite.org:8080/cgi-bin/mailman
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.
___
sqlite-users mailing
"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"
(written in PowerBasic). Alr
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 s
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 with a commercial alternativ
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 your client-app?
"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 case, what about:
http://www.
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 :-/
>http://www.it77.de/sqlite/sqlite.htm
"28.05.
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
sq
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 in a firewalled
LAN just
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, secu
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 serve
On 5/27/07, noname <[EMAIL PROTECTED]> 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 server. so i am confused that should i use it or not i enquired on sites
also but i am getting p
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 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-
Reque
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 lo
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 proce
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 h
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 o
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 sql
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 librar
66 matches
Mail list logo
