On 8 Mar 2011, at 11:09am, liran ritkop wrote: > I am really new to SQLite, and i want to do the next thing: > > save a 100k binary data every 1 second, with its time stamp. > to do it every second i can use a loop in C.
Can your hard disk cope with writing 100k a second for however long you need to do it ? Someone remind me of typical writing speeds for plaintext files and SQLite databases again. > So i define one column as a date/time INTEGER. > The next column is for binary data which i don't know how to define and how > to use it. > I mean, i heard about blob variable but i really don't know how to save the > data in it, and if blob variable is the direction i need to go to. > > can you give me some sqlite statements example to do it. > or some code in C? I googled 'sqlite write blob c example' and came up with <http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html> (which has reading blobs) <http://old.nabble.com/Simple-example-for-dummy-user-writing-C-code-td22840833.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
