[sqlite] Feature request

I welcome discussion of a feature request I intend to make. Please suggest better function names, more considerations, or anything else interesting. int sqlite3_change_count(sqlite3*) Returns an integer which is incremented whenn a change is made to any table in the database. May be

Re: [sqlite] about insert into select

On May 21, 2009, at 8:43 AM, Wenton Thomas wrote: > What's the execution sequence about " insert ino A select > from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first, then insert all the result > into table A; > (2) select a row

[sqlite] Question about reading all database data into memory

HI,   .  If I have to read all the database data into memory, I needed to execute sqlite3_prepare_v2 statement,and then sqlite3_step to access the rows, and processing each row to get the rows content.  This does not look efficient. Is there any other way to do this?   Thanks Raji

Re: [sqlite] Importing Data into a SQLite database from a MySQL SQL Dump File

On 21 May 2009, at 4:43am, Debjit Saha wrote: > I have a SQL Dump created from a database in MySQL. This is a text file that looks like a lot of SQL commands, right ? And I assume this is a one-off thing you need to do, not something you're going to need to do repeatedly. > Now I want to

[sqlite] Importing Data into a SQLite database from a MySQL SQL Dump File

I have a SQL Dump created from a database in MySQL. Now I want to import that dump into an SqLite database. Is thatpossible? If yes, please tell me how. Cheers, Debjit ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] about insert into select

On 21/05/2009 11:43 AM, Wenton Thomas wrote: > What's the execution sequence about " insert ino A select from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first, meanwhile this product (frequently chosen for use on devices with minimal

Re: [sqlite] about insert into select

Wenton Thomas wrote: > What's the execution sequence about " insert ino A select from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first, then insert all the result into > table A; > (2) select a row from B ,then insert the row into

[sqlite] about insert into select

What's the execution sequence about " insert ino A select from B "? I means,which is correct prescription in the following: (1) select all rows from B at first, then insert all the result into table A; (2) select a row from B ,then insert the row into table A immediately, repeat the

Re: [sqlite] most efficient way to get 1st row

We're not talking about transaction control - we're talking about limiting the size of the result set. And LIMIT/OFFSET clauses are not supported by the SQL-92 standard. LIMIT is listed as a reserved word, but that's it. http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt On Wed,

Re: [sqlite] most efficient way to get 1st row

John Stanton wrote: > Shane Harrelson wrote: >> Additionally, it's important to note that the LIMIT/OFFSET clause is >> not standard SQL > > What makes you think that transaction control is not part of SQL-92? What does LIMIT clause have to do with transaction control, in

Re: [sqlite] most efficient way to get 1st row

What makes you think that transaction control is not part of SQL-92? If a database engine does not support transaction control it is not a full implementation. Transaction control is at the very heart of effective data management. Shane Harrelson wrote: > Additionally, it's important to

[sqlite] multiple connections by multiple threads

Hello, I like to know if is recommended to do multiple connections from multiple threads in Sqlite or the best approach is create just one connection to multiple threads. Each thread has a hight concurrence level. I already try to open one connection per thread with that arguments:

Re: [sqlite] most efficient way to get 1st row

I just learned today that Interbase 7.5 does not support it either. Shane Harrelson wrote: Additionally, it's important to note that the LIMIT/OFFSET clause is not standard SQL, and although it is supported by SQLite, and many other SQL engines, there are some that do NOT support it, most

Re: [sqlite] most efficient way to get 1st row

Additionally, it's important to note that the LIMIT/OFFSET clause is not standard SQL, and although it is supported by SQLite, and many other SQL engines, there are some that do NOT support it, most notably Microsoft SQL Server. HTH. -Shane On Tue, May 19, 2009 at 2:23 PM, Sam Carleton

Re: [sqlite] Accessing sqlite using javascript

On 20 May 2009, at 5:14am, Saurabh Pawar wrote: > This is the best link i have found out till now which will give a > very clear view. > > https://developer.mozilla.org/en/Storage Actually, for my own use I wrote a WebKit Plugin which provides an interface to some of the calls to sqlite3 --

Re: [sqlite] SQLite version 3.6.14.1

D. Richard Hipp writes: > > SQLite version 3.6.14.1 is now available on the sqlite website: http://www.sqlite.org/ > ...snip... > > As always, please let me know if you encounter any difficulties. > > D. Richard Hipp > d...@... Version 3.6.14 ... "*Countless* minor bug fixes" ?!