Download the source from www.sqlite.org. Untar it into a directory
sqlite and follow the instructions.
Joanne Pham wrote:
Hi All, I already had SQLite3 version 3.3.14 on my Linux box and I want to replace this version with the new version SQLite3 3.5.1and I don't know what are the steps to
Sorry for answering my own email.
I had a bit of a breakthrough. Apparently compiled selects
sqlite3_prepare_v2 that live longer than the transaction are enough to
prevent the transaction from commiting. Each thread has it's own
connection to the DB.
With multiple threads, the order was:
Hi all,
I have a multithreaded app using 3.5.1 latest on the site.
I "BEGIN EXCLUSIVE TRANSACTION;"
Add some data and then
"COMMIT;"
The COMMIT sometimes returns SQLITE_ERROR but, the error message is
"Select still in progress". I was under the impression I was supposed
to get a "SQLITE_BUSY"
On 10/18/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Hi All,
> I got a lot of email from this group but I don't remember how to post the
> question to this user group. Please help.
> Thanks,
> JP
is this a trick question? You just posted a question above quite successfully!
now, bring
Hi All, I already had SQLite3 version 3.3.14 on my Linux box and I want to
replace this version with the new version SQLite3 3.5.1and I don't know what
are the steps to apply new version to my Linux box and where to downloading
this new version. Thanks in advance, JP
Hi All,
I got a lot of email from this group but I don't remember how to post the
question to this user group. Please help.
Thanks,
JP
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
I have no idea what you downloaded or what you ran, but that's
not the output of "./configure && make" on cygwin.
> > tclsh ./tool/mksqlite3c.tcl
> > cc sqlite3.c -o sqlite3
Among other problems, the compiler would have been 'gcc', and
sqlite3 would have had an .exe suffix.
--- [EMAIL
Mark Spiegel wrote:
While working on a VFS for use in 3.5.1, I was looking at the winLock()
and have a question.
Is it possible for the lock on a winFile object to progress from
SHARED_LOCK to EXCLUSIVE_LOCK without first acquiring a RESERVED_LOCK?
I have a similar question. I, too, am
I have unsubscribed. Why Am I still receiving messages?
confirm unsubscribe from sqlite-users@sqlite.org
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 18, 2007 4:15 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: cygwin compilation
Well, I'm not looking for shell.c or main.c ... perhaps the build process
is , but not me.
I typed ./configure && make
and what you see is what I got instead. So perhaps the build process is
looking for something it shouldnt.
--
Terrence Brannon - SID W049945
614-213-2475 (office)
Thanks a lot Joe, I'll take a look at that.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Oct 18, 2007, at 7:05 PM, Joe Wilson wrote:
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
I need to create a custom function that returns
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> I need to create a custom function that returns all the value from
> that row.
> If the * syntax was supported then I don't need to save or retrieve
> all the column's name for that table.
Here's a simple workaround similar to the 'eval' function
I just tried the CVS from home. Exact same error.
--
Terrence Brannon - SID W049945
614-213-2475 (office)
614-213-3426 (fax)
818-359-0893 (cell)
Terrence X Brannon/JPMCHASE
10/18/2007 11:21 AM
To
sqlite-users@sqlite.org
cc
Subject
cygwin compilation failure, cvs tarball, mailing list
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> I need to create a custom function that returns all the value from
> that row.
> If the * syntax was supported then I don't need to save or retrieve
> all the column's name for that table.
You can, of course, change the sqlite source code to
I have problem with filtering database with LIKE statement. In query i'm doing
this:
...
WHERE [EMAIL PROTECTED] AND (ze_nazwa LIKE @ze_nazwa ESCAPE '\' OR ze_typ_el
LIKE @ze_nazwa ESCAPE '\')
and in program for @ze_nazwa i'm inserting this string:
string elementFiltr = "%" + (new
== Cygwin compilation failure ==
* this is using the 3.5.1 src on the website -
http://www.sqlite.org/sqlite-3_5_1.zip
* link error is different from what an archive search of this list shows,
so I thought i'd report it
cp ./src/alter.c ./src/analyze.c ./src/attach.c ./src/auth.c
Got it. Thanks a million
- Uma
John Stanton <[EMAIL PROTECTED]> wrote: The prepare creates a virtual machine
which can be rused. A useful way
to implement Sqlite is to use prepare to compile all the SQL in the
initialization phase of the program and then to execute the virutal
machines
I need to create a custom function that returns all the value from
that row.
If the * syntax was supported then I don't need to save or retrieve
all the column's name for that table.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
Thanks Dennis for your reply.
I would like to avoid triggers for performance reasons.
I haven't found an official solution so I am implementing my own
sqlite3_update_notify API that is executed before the operation takes
place.
---
Marco Bambini
http://www.sqlabs.net
Marco Bambini <[EMAIL PROTECTED]> wrote:
I created a custom function in sqlite, and when I try to execute it
with a statement like:
SELECT myfunction(col1, col2, col3) FROM table1 WHERE ...
then everything works fine.
The problem is that I don't know in advance the names of the columns
so I
Marco Bambini wrote:
with sqlite3_update_hook I can get the rowid of the row AFTER it has
been INSERTed, DELETEd or UPDATEd.
Is there a way to get the rowid of a row BEFORE it is DELETEd or
UPDATEd ?
If not, can someone suggest a good approach to this problem?
Marco,
You can use a "before
Vladimir Stokic wrote:
Hi there,
Is there any way to identify the change that occurred on a table from within
a trigger defined on that table?
The solution that I can think of is to create an SQL statement by using
new.Column1 or old.Column1, but I was wondering if it can be done faster, by
On 10/17/07, Uma Krishnan <[EMAIL PROTECTED]> wrote:
> Yes. Makes sense (not to cache query results for embedded apps).
> So what is cached. Just dirty pages? or are raw tables cached when
> queried?
SQLite implements a tables and indices as btrees over a pager layer.
The pager layer caches
Hello sqlite users !
I have noticed that some people (like me) want to use sqlite in a read only
environment.
Basically, we only do select commands, but we want them to be as fast as
possible.
A bit like CDB, but with SQL queries.
Is there any compilation hint or any way to hack sqlite to
> CREATE TABLE n1(a integer primary key);
> INSERT INTO "n1" VALUES(1);
> INSERT INTO "n1" VALUES(2);
> INSERT INTO "n1" VALUES(3);
> INSERT INTO "n1" VALUES(4);
> INSERT INTO "n1" VALUES(5);
> INSERT INTO "n1" VALUES(6);
> INSERT INTO "n1" VALUES(7);
> INSERT INTO "n1" VALUES(8);
> INSERT INTO
25 matches
Mail list logo