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 a
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:
prepar
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 on
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 P
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 writin
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)
614-213-342
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 all
There is no main() in sqlite3.c.
I'm guessing that you're looking for shell.c?
--- [EMAIL PROTECTED] wrote:
> I just tried the CVS from home. Exact same error.
...
> tclsh ./tool/mksqlite3c.tcl
> cc sqlite3.c -o sqlite3
> /usr/lib/gcc/i686-pc-cygwin/3.4.4/../../../libcygwin.a(libcmain.o):(.t
--- 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 restr
--- 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 exten
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
Regex(@"([\\%_
== 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
./src/btmute
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 using
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/
On
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
http://www.sqlabs.net/bl
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 trie
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
using
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 tried to use it with a statement like:
SE
--- Renaud HUILLET <[EMAIL PROTECTED]> wrote:
> I was surprised to see that sometimes the cache is not efficient.
SQLite uses a page cache, not a query cache.
If you want a query cache, you have to program one yourself.
Try testing against a memory database and/or with
PRAGMA temp_store = memo
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 pages.
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
using, say, a user defined fu
Not usere if it will help, but here is what I do in my C++ code:
I have a wrapper on top of sqlite API.
The prepare function in my wrapper will
-either prepare the query
or
- simply reset it if it has already been prepared
For each query, I have a static instance of my wrapper that I us
Many thanks to all of you !
I got the answers I expected.
Best regards,
Thomas
John Stanton wrote:
Think about it. A transaction does not affect SELECts, it only defers
the processing of the journal until there is a COMMIT.
According to your version of Sqlite you may get some benefit from
Sorry, forgot a column in my description of the indexes :(
So here I go again:
I was surprised to see that sometimes the cache is not efficient.
for example, if I do:SELECT A.x, B.y FROM A,BWHERE A.col1='VALUE'AND A.col2 =
B.col3; With indexes Idx1: A.col1 , A.col2, A.x Idx2: B.col3, B.y...
30 matches
Mail list logo
