Re: [sqlite] checking database file

On Feb 2, 2009, at 2:34 PM, Zaphod wrote: > Hi All, > > Let's say every time before my system starts to run, i would like to > check the > database for any kind of errors/mistakes. > Is there any API or utility for such purpose? See "PRAGMA integrity_check" here: http://www.sqlite.org/prag

[sqlite] checking database file

Hi All, Let's say every time before my system starts to run, i would like to check the database for any kind of errors/mistakes. Is there any API or utility for such purpose? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

[sqlite] onthefly Compression of SQLite database

Hi, I searched a little bit with google but I could not find any code or extensions to compress an SQLite database on the fly. Is this possible? I use SQLite to store a database engine with images and HTML code. I already use zlib to compress the data itself (i.e. the images and the HTML data)

[sqlite] Warning message in amalgamation

Hi, When building sqlite 3.6.10 amalgamation, I get a warning message saying: attention : ignoring return value of ‘write’, declared with attribute warn_unused_result This is on a small piece of code related to ticket #3260, according to the source documentation. (See the code below.) I know t