[sqlite] Port SQLite to VxWorks

Hi, all. I am new to SQLite database and encountered a big problem. I intend to port SQLite to VxWorks OS and don't really know how. When directly compiled the source code downloaded from the official site in VxWorks' IDE Tornado, I kept receiving messages of certain header files missing. I've hear

[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 the

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 i

[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 http://sqlite.org:8080/cgi-bin/m

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 m

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 tab

[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 p

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, May

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 your opinion? Igor Ta

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 note

[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: sqlite3_ope

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 notabl

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 wrote:

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" ?! Regards, M