[sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

I have a table in my sqlite3 database that stores 1001 float numbers in 1001 columns. I wish to dump the database to ascii format for backup purposes, and I expect the ".dump" function will create a snapshot of the database. However, I didn't find any rows of data in the table after restoratio

Re: [sqlite] sqlite3_errCode and error handling

I submitted a bug with a similar problem a while back: http://www.sqlite.org/cvstrac/tktview?tn=1366 the bug was closed with this comment by drh: "SQLITE_CORRUPT gets returned when you call sqlite3_reset() or sqlite3_finalize(). This is unfortunate, I know. We should have designed the API so

Re: [sqlite] How to bind DATE and TIME values

Look at: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Alternatively, you could use the c library's time() or gettimeofday() and store the result in an INTEGER column (which in sqlite can hold 64-bit values, if you need the full resolution from gettimeofday). In either case, reme

Re: [sqlite] Maintaining a sequence that's not rowid

Alternatively, you might consider making the id_allocator table have an auto-increment primary key, and then insert null to have sqlite generate id's for you, and use last_insert_rowid() to find out the value it generated. /* Initialize system */ BEGIN; CREATE TABLE id_allocator(id INTEGER PRI

[sqlite] Tad - An Open Source Pivot Table Viewer for CSVs and sqlite

ws at SQLite to construct the pivot table, add the arguments -f --show-queries to the command line. I hope you find Tad useful. Please send feedback and bug reports to tad-feedb...@tadviewer.com. -Antony Courtney ___ sqlite-users mailing li