[sqlite] How to run sqlite just in memory - pragma cache_size issue

2013-10-06 Thread Kf Lee
Hi, Richard, Thanks for the advice, I have look at the link and experiment with it. The example loadOrSaveDb is pretty clear and straightforward. However I did not get it working with the following example: sqlite3 *db; char *zErrMsg = 0; void main(void) { int rc; char

Re: [sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2013-10-06 Thread Paul L Daniels
> If Undark decodes the metadata, it might be more useful to create a > new database instead of a CSV file. The new database would be a > mirror of the input, except that its tables would hold deleted rows > (or both deleted and extant, with a column signifying which). I may look in to

Re: [sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2013-10-06 Thread James K. Lowden
On Sun, 6 Oct 2013 22:58:28 +1000 Paul L Daniels wrote: > "Undark" is only at v0.2 at this time, it's still quite coarse > around some corners and it does not differentiate between > deleted and undeleted rows. It also has a limitation of only >

Re: [sqlite] SQLite4 release date and how to compile on windows platform

2013-10-06 Thread Gabriel Corneanu
Simon, I have asked several times similar questions, and got similar replies. This answer is simply NOT correct. While I understand nobody wants to commit to a release/stable version, I really wanted to evaluate how it fits my needs. Therefore I took some time to understand how could I compile

Re: [sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2013-10-06 Thread Paul L Daniels
On Sun, 6 Oct 2013 15:07:06 +0100 Simon Slavin wrote: > Quick summary, most of which you probably do right: > > Numeric fields should go unquoted and string fields in a CSV files > must be quoted: Thanks for the notes, there's a few things in there I'm not

Re: [sqlite] How to use my own python function in a SQLite WHERE clause?

2013-10-06 Thread Ryan Johnson
On 05/10/2013 6:01 AM, Clemens Ladisch wrote: Bao Niu wrote: SELECT * FROM myTable WHERE MyDate > MyModule.ChineseDate("兔年八月十五") You cannot use Python function directly in SQL. ... but you can register it with sqlite3 easily enough and use it from SQL afterward:

Re: [sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2013-10-06 Thread Simon Slavin
On 6 Oct 2013, at 1:58pm, Paul L Daniels wrote: > finally, it > doesn't decode or dump BLOB data yet, simply not sure how to > represent that sanely on a CSV dump. Quick summary, most of which you probably do right: Numeric fields should go unquoted and

[sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2013-10-06 Thread Paul L Daniels
Hello everyone, Sincerely hoping this is the appropriate place to post this announcement. A while ago a client needed some important SMSs retrieved from their iPhone that had been deleted, anyhow, long story short, I've since created a tool which I now