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 anyone else
On 21-Dec-2010, at 5:02 AM, 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.
The key here is to define your own app-specific protocol for communication
between client and
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 with
Hi,
I was wondering about the lock state when one the TRIGGER are getting
invoked? I would like to apologize, if I missed the explanation in the
documentation or in previous thread.
For example: the INSERT inserts a row into table and invokes
registered ON INSERT (AFTER) trigger.Would the state
Hi All,
There is a strange problem I am observing.
I need to use 10 databases in my application and need to keep all of them
open.
Earlier I was using only 9 databases and had a working code.
As soon as I introduced a new database, the insert calls for other databases
start to fail after
On 21 Dec 2010, at 6:58am, megha gupta wrote:
I need to use 10 databases in my application and need to keep all of them
open.
Earlier I was using only 9 databases and had a working code.
Are you opening ten independent connections (i.e. 10 uses of sqlite3_open()) or
are you attaching ten
On Tue, Dec 21, 2010 at 2:24 PM, Simon Slavin slav...@bigfraud.org 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
For example: the INSERT inserts a row into table and invokes
registered ON INSERT (AFTER) trigger.Would the state of database lock
be RESERVED (presuming there is space in cache)?
Trigger is always executed inside the same transaction as the
statement causing trigger to execute. So, yes the
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 sometimes
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
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
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 in some
Hi Max and Richard,
Thanks for reply.
To Max: I agree, I do not have unicode support. The call to
GetFileAttributesExW is in if( isNT() ), which returns FALSE under
Win95, so I removed the call to GetFileAttributesExW (It is not a problem
if I considered that the software is build for a
On 12/21/2010 1:06 PM,
joel.guittet-...@transport.alstom.com wrote:
I wonder about something : those functions are in kernel32.dll on a XP
computer. Is it possible (I never do that before), to take the file
kernel32.dll on my XP computer, to put it on the Win95 computer in the
directory of my
On 21 Dec 2010, at 6:06pm, joel.guittet-...@transport.alstom.com wrote:
Is it possible (I never do that before), to take the file
kernel32.dll on my XP computer, to put it on the Win95 computer in the
directory of my SQLite application
This will not work. The kernel /is/ pretty-much the
On Tue, Dec 21, 2010 at 10:06 AM,
joel.guittet-...@transport.alstom.com wrote:
I wonder about something : those functions are in kernel32.dll on a XP
computer. Is it possible (I never do that before), to take the file
kernel32.dll on my XP computer, to put it on the Win95 computer in the
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 9:06 PM, joel.guittet-...@transport.alstom.comwrote:
I wonder about something : those functions are in kernel32.dll on a XP
computer. Is it possible (I never do that before), to take the file
kernel32.dll on my XP computer, to put it on the Win95 computer in the
18 matches
Mail list logo