Re: [sqlite] Port SQLite to VxWorks

I'v already tested SQLite 3.6.13 with VxWorks 6.6/6.7 in DKM mode with basic test application. It works fine for me. 2009/5/21 张世闻 > 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

Re: [sqlite] Port SQLite to VxWorks

I used the latest source code tarball http://www.sqlite.org/sqlite-amalgamation-3.6.14.1.tar.gz and compiled it in Windows-based Tornado 2.2. It uses a so-called 'SIMNT gnu' toolchain for compilation, version unknown. My problem is when compiling the shell.c file, it prompted that

[sqlite] Simplest way to delete a column

I guess experienced users have solved this one already. How do I drop a column from a table if I don't already know what columns are in the table ? The FAQ says BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; DROP TABLE t1; CREATE TABLE

Re: [sqlite] Sqlite3 on a linux/flash-based platform

Hi Edward I am using sqlite on an embedded application. I am using an SD card rather than flash, although I think you will encounter the same problems I did with the flash implementation. I had to use the following Pragma's due to some major performance problems using the SD card. //PRAGMA

Re: [sqlite] What encoding format is used in the FTS3 tokenizer? and other tokenizer questions.

On Mon, May 4, 2009 at 2:22 PM, Garry Watkins wrote: > What encoding is used on inbound insert statements into a FTS3 virtual > table?  For example I have Japanese text encoded as UTF-8 and passed > in as UTF-8 insert statement is encoded as UTF-8.  I am not using the > ICU

Re: [sqlite] Fw: Question about reading all database data into memory

You don't have to ask column name every time. As long as you know what column names are (select statement you know, right?) you can get column values by index. And this will have the same performance as requesting all values by tuple (someone will have get all values and insert into tuple anyway)

Re: [sqlite] Fw: Question about reading all database data into memory

On Thu, May 21, 2009 at 01:44:19PM -0700, rajyalakshmi bommaraju scratched on the wall: > If there are x columns in the row , now I have to keep saying > getnext columnname,get next column value for that name for x times. > instead I get values into tuple in one call. Somewhere, at some

Re: [sqlite] Fw: Question about reading all database data into memory

If there are x columns in the row , now I have to keep saying getnext columnname,get next column value for that name for x times. instead I get values into tuple in one call. -Raji --- On Thu, 5/21/09, Pavel Ivanov wrote: From: Pavel Ivanov Subject:

Re: [sqlite] Problem with Insert Statement

Thank you so much that was the problem, you really made my day hakim On May 21, 2009, at 4:22 PM, Igor Tandetnik wrote: > Hakim TAMGALT wrote: >> The goal is to insert into the Workout table about 1000 rows in one >> shot thru a loop, my problem is as soon as it reaches 250

Re: [sqlite] Problem with Insert Statement

Hakim TAMGALT wrote: > The goal is to insert into the Workout table about 1000 rows in one > shot thru a loop, my problem is as soon as it reaches 250 the > statement crashes with the following error: > > **Terminating app due to uncaught exception >

[sqlite] Problem with Insert Statement

Hi all I need some help with SQLite Insert statement, I have a table called workout which has been created with the following definition CREATE TABLE "Workout" ("workoutId" INTEGER PRIMARY KEY NOT NULL ,"historyId" INTEGER NOT NULL ,"latitude" DOUBLE,"longitude" DOUBLE,"vert_accuracy"

Re: [sqlite] Fw: Question about reading all database data into memory

Why do you expect performance improvement in your approach as opposed to implemented now? Pavel On Thu, May 21, 2009 at 1:56 PM, rajyalakshmi bommaraju wrote: > I did not get any reply so adding bit more explanation for what I need. > > In a C program, I am trying to read

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

Sam Carleton wrote: > > SNIP I take it the brain removal was necessary for the politician to attain higher office? >>> I cannot see that being the case, they get worse off as they climb >>> the ranks, not better off! >>> >> >> I meant the politician having brain

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

John Elrick wrote: Sam Carleton wrote: John Elrick wrote: John Stanton wrote: Igor Tandetnik wrote: John Stanton wrote: Shane Harrelson wrote: Additionally, it's important to note

[sqlite] Fw: Question about reading all database data into memory

I did not get any reply so adding bit more explanation for what I need. In a C program, I am trying to read data from database. I use sqlite3_prepare_v2 to execute "Select * from abc", sqlite3_step to get a row, and sqlite3_col_name,sqlite3_col_val to get column values.  I read columns one by

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

Sam Carleton wrote: > > > John Elrick wrote: >> John Stanton wrote: >> >>> Igor Tandetnik wrote: >>> John Stanton wrote: > Shane Harrelson wrote: > >> Additionally, it's important to note that the LIMIT/OFFSET clause

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

John Elrick wrote: John Stanton wrote: Igor Tandetnik wrote: John Stanton wrote: Shane Harrelson wrote: Additionally, it's important to note that the LIMIT/OFFSET clause is not standard SQL

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

John Stanton wrote: > Igor Tandetnik wrote: > >> John Stanton wrote: >> >> >>> Shane Harrelson wrote: >>> >>> Additionally, it's important to note that the LIMIT/OFFSET clause is not standard SQL >>> What makes you

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

My error. I was replying to the wrong email. Shane Harrelson wrote: > 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

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

Igor Tandetnik wrote: > 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? >> > >

[sqlite] How to use BLOB datatype???

Hi All You will have to excuse my relatively simple question but i am new to playing with Sqlite and databases in general. I have a little app that is using PHP and Sqlite. I have had no troubles getting all the basics working but have hit a wall with the BLOB datatype. What i am trying to

Re: [sqlite] Port SQLite to VxWorks

ÕÅÊÀÎÅ wrote: > > 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

Re: [sqlite] Port SQLite to VxWorks

On 21 May 2009, at 7:36am, 张世闻 wrote: > When directly > compiled the source code downloaded from the official site in > VxWorks' IDE > Tornado, Which compiler does that IDE use to compile ? GCC ? Which version ? Is the problem covered in http://www.xs4all.nl/~borkhuis/vxworks/vxw_pt1.html

[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