[sqlite] Fw: how are you?

Hi friend! I've read an article recently nd it reminded me of you, please read it here and tell me your thoughts Good wishes, ronny.dierckx ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] not sure

Hello friend, I'm not sure whether I should tell you that, please read it yourself See you around, ronny.dierckx ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] wow, amazing!

Yo! I've been looking for some info on the web and came across that amazing picture, just take a look Faithfully, ronny.dierckx ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] fsync/fdatasync problem on UBIFS

> >Using "PRAGMA journal_mode=truncate" made no difference, the journal >reappeared with file size > 0. > >But "PRAGMA journal_mode=persist" fixes the problem, the database is no >longer rolled back after a power cut. > FYI, The problem turned out to be a bug in the UBIFS backport we are using.

Re: [sqlite] fsync/fdatasync problem on UBIFS

blem. > >Dan. Using "PRAGMA journal_mode=truncate" made no difference, the journal reappeared with file size > 0. But "PRAGMA journal_mode=persist" fixes the problem, the database is no longer rolled back after a power cut. Thanks, Ronny Dierckx ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] fsync/fdatasync problem on UBIFS

, Ronny Dierckx ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] get the actual database size.

Hi, I think a possible solution is to calculate the difference between the database file size and the number of free pages multiplied by the page size. This is of course an approximation, but it works for me. Number of free pages: pragma freelist_count Page size: pragma page_size Ronny

Re: [sqlite] Helping with table definition?

Hi, I think you should look at "PRAGMA table_info(table-name);" instead: For each column in the named table, invoke the callback function once with information about that column, including the column name, data type, whether or not the column can be NULL, and the default value for the column.