Re: [sqlite] Direct row insert from C (without SQL) / Database speed

2009-06-09 Thread John Stanton
Use sqlite prepare and bind. Mark Flipphi wrote: > I'm new in using SQLite and have some questions before I start > implementing the SQL lite in a project. > > Is there a way to insert a row of data into a table without having to > convert the data to SQL ? > I need to store 1024 point into a

Re: [sqlite] Direct row insert from C (without SQL) / Database speed

2009-06-09 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark Flipphi wrote: > Is there a way to insert a row of data into a table without having to > convert the data to SQL ? Lookup bindings - using functions like sqlite3_bind_int: http://sqlite.org/c3ref/bind_blob.html > Can we create a object with

[sqlite] Direct row insert from C (without SQL) / Database speed

2009-06-09 Thread Mark Flipphi
I'm new in using SQLite and have some questions before I start implementing the SQL lite in a project. Is there a way to insert a row of data into a table without having to convert the data to SQL ? I need to store 1024 point into a row, but converting it first to text and then let the