Re: [sqlite] how to restore the column values into the structure.

HI Dinesh, You just given the classes. You didn't give actual work the functions do. Can you tell me how i can do in C. Regards, Bhaskar. Dinesh Behl wrote: > > Hi Bhaskar, > > I wrote the code to store the result of SELECT query. > > I treated the resultset as a table where e

Re: [sqlite] Minimum RAM requirements (Richard Hipp)

Thanks for the tip which seems to do the trick. When using MEMSYS3 I was able to create a table with a primary key but inserting rows ran out of memory after 170 rows. Now, with MEMSYS5, I inserted 5000 rows, no problem. ___ sqlite-users mailing list sq

[sqlite] ANN: SQLiteSync

Hello, SQLabs is proud to announce SQLiteSync: a very powerful and easy to use application to compare, merge and keep in sync two sqlite databases. http://www.sqlabs.com/sqlitesync.php Thanks to its underline technology it is able to visualize the differences between millions of rows in few mill

Re: [sqlite] Some pieces of the puzzle are coming together

I may not have been clear that these two separate tests both used the Delphi bridge (as you refer to it). What they point to is an unusual interaction between our full application and SQLite is triggering the increase in malloc calls. On Sat, Jan 21, 2012 at 6:48 PM, Simon Slavin wrote: > > On

Re: [sqlite] Linking a "C" program with SQlite3.DLL

Just add sqlite3.c to your compilation. You likely have no reason to use the DLL. This should work: gcc -O -o test test.c sqlite3.c -ldl -lpthread Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Syst

Re: [sqlite] ftruncate implementation

On 22 Jan 2012, at 3:36pm, David Henry wrote: > According to the posix definition of "ftruncate" , a file is made larger by > writing zeroes up to the size desired. > > My implementation of Fat File System can quickly extend a file by allocating > more sectors, but will take a long time to write

[sqlite] ftruncate implementation

According to the posix definition of "ftruncate" , a file is made larger by writing zeroes up to the size desired. My implementation of Fat File System can quickly extend a file by allocating more sectors, but will take a long time to write all those new sectors with zeroes. So, is zero filling a