Re: [sqlite] SQLite and Windows 95

2010-12-21 Thread Max Vlasov
On Tue, Dec 21, 2010 at 9:06 PM, 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 SQLite application, an

Re: [sqlite] SQLite server

2010-12-21 Thread Petite Abeille
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

Re: [sqlite] SQLite and Windows 95

2010-12-21 Thread Random Coder
On Tue, Dec 21, 2010 at 10:06 AM, 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 SQLite application, a

Re: [sqlite] SQLite and Windows 95

2010-12-21 Thread Simon Slavin
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 t

Re: [sqlite] SQLite and Windows 95

2010-12-21 Thread Igor Tandetnik
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

Re: [sqlite] SQLite and Windows 95

2010-12-21 Thread joel . guittet-ext
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 spec

Re: [sqlite] SQLite server

2010-12-21 Thread Max Vlasov
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

Re: [sqlite] SQLite server

2010-12-21 Thread Simon Slavin
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

Re: [sqlite] SQLite server

2010-12-21 Thread Philip Graham Willoughby
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

Re: [sqlite] SQLite server

2010-12-21 Thread Gary_Gabriel
>> 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

Re: [sqlite] TRIGGER and locking

2010-12-21 Thread Pavel Ivanov
> 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

Re: [sqlite] SQLite server

2010-12-21 Thread Max Vlasov
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

Re: [sqlite] sqlite_step fails when inserting a record [REPLY AWAITED]

2010-12-21 Thread Simon Slavin
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 t

[sqlite] sqlite_step fails when inserting a record [REPLY AWAITED]

2010-12-21 Thread megha gupta
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 someti

[sqlite] TRIGGER and locking

2010-12-21 Thread Nishtiak
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 o

Re: [sqlite] SQLite server

2010-12-21 Thread Simon Slavin
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

Re: [sqlite] Fwd: Re: Bug: Umlaut in database filename

2010-12-21 Thread Mohd Radzi Ibrahim
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 serv

Re: [sqlite] SQLite server

2010-12-21 Thread Philip Graham Willoughby
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