[sqlite] reset WAL log

I close connection to database. Even I calling "PRAGMA wal_checkpoint(RESTART)" frequently and no concurrent access to database. Can I flush WAL log and reduce log size without close database connection? Thank you! -- Lukas Gebauer. http://synapse.ararat.cz/ - Ararat Synapse - TCP/I

Re: [sqlite] WAL file size

on database disconnect only. On big writes WAL log grows and grows... even I commiting datas, even I have no long transactions, even I have autocheckpointing , even I do checkpointing manually. Just close and reopen database clears WAL log file. Is this correct behavior? Thank you! -- Lukas

[sqlite] Is opened transaction?

Hello! How can I detect opened transaction on my database connection from the code? When I start transaction/checkpoint, then I am missing some API or SQL command like 'IsTransactionOpen'. Thank you for your help! -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz

Re: [sqlite] Is opened transaction?

> http://www.sqlite.org/c3ref/get_autocommit.html Thanks, I missed this function for their little tricky name. Would be gread if exist one new function for getting names from savepoint transaction stack too. It would be great for nested transaction debugging. (Just idea.) -- Lukas Geba

Re: [sqlite] SQLite version 3.6.14

> durability and additional memory usage. See > http://www.sqlite.org/asyncvfs.html for additional information. Is this extension compiled in your Win32 DLL binary? Thanks! -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz/ - Ararat Sy

[sqlite] List of active savepoints names

Hello all! I am searching some API function for get list of active savepoint names. Is this possible? Thank you! -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz/ - Ararat Synapse - TCP/IP Lib. ___ sqlite-users mailing list

Re: [sqlite] List of active savepoints names

duplicate names. Never mind. It not break anything. When I got list of savepoints names sorted in same order as is inside SQlite, then I got exactly what I need. -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz/ - Ararat Synapse - TCP/IP Lib. __

Re: [sqlite] List of active savepoints names

> > I am searching some API function for get list of active savepoint > > names. Is this possible? Thank you! > > No, this is not possible. Why do you need it in the first place? It will be great for debugging, for example. -- Lukas Gebauer. E-mail: gebau...@mlp.cz http:/

Re: [sqlite] List of active savepoints names

It is simple, trivial, useful... and working right at any case. This is why I am asking for. Thanks! -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://synapse.ararat.cz/ - Ararat Synapse - TCP/IP Lib. ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] List of active savepoints names

But they cannot ask for transaction name? First is useful and many users needs it, and second not? I am surprised. But never mind, I register your response "no"! Forget it, sorry for my bothering. -- Lukas Gebauer. E-mail: gebau...@mlp.cz http://s

[sqlite] update record in contentless FTS4

Hello all! I have contentless FTS4 index for searching some my external data paired by docid. What I can do, when my existing previously indexed document was changed? I need to update existing FTS4 index too. But documentation says: "UPDATE and DELETE is not supported". Can I do new INSERT

[sqlite] Slow debugging

with DLL 3.8.0.2, it need cca 3s inside sqlite3_step. Have anyone some ideas? Thank you! -- Lukas Gebauer. http://synapse.ararat.cz/ - Ararat Synapse - TCP/IP Lib. http://geoget.ararat.cz/ - Geocaching solution ___ sqlite-users mailing list sqlite-users

[sqlite] Bug - Aborted statement by a nested savepoint

opened statement - I got SQLITE_ABORT error, even I not see any Rollback. When I omit savepoint x1, then statement working well. If I omit nested x2 savepoint, statement working fine too. Is it bug or I missed something? Thank you very much! -- Lukas Gebauer. http://synapse.ararat.cz