Re: [sqlite] How to create connection life-time object?

On Fri, Jul 26, 2013 at 9:56 PM, Dušan Paulovič wrote: > Thanks for suggestion, but: > 1.) one object is not linked to one connection > If you have your own memory management, it's not a problem since the scheme I described is basically just a storage of pointers. To free or

Re: [sqlite] Any way to debug database is locked?

They're all being accessed from multiple threads within a single process app, with no external sources/connections. This happens on both OSX and Win32. Always on a local disk. I'm using the release amalg straight off the website (3.7.17), with SQLITE_ENABLE_FTS3/FTS3_PARENTHESIS as

Re: [sqlite] Any way to debug database is locked?

On 27 Jul 2013, at 1:20am, David de Regt wrote: > Is there any chance that the OS is still flushing the WAL changes to disk > post-closing the database in another connection, when another connection > tries to get an exclusive lock? How are your various processes

[sqlite] Any way to debug database is locked?

We have a fairly complicated system of OS mutexes and using exclusive DB transactions to attempt to avoid database locking issues with SQLite. It works great most of the time, but every few days one of our testers randomly runs into a database is locked error. Every time it's been in a

Re: [sqlite] How to create connection life-time object?

Thanks for suggestion, but: 1.) one object is not linked to one connection 2.) object is not destroyed together with connection Dusan 2013/7/26 Max Vlasov > Hi, Dušan > > > On Thu, Jul 25, 2013 at 2:39 PM, Dušan Paulovič > wrote: > > > Hello, is

Re: [sqlite] Using SQLITE to build database from tab delimited file

On 26 Jul 2013, at 9:25am, Rob Slater wrote: > I have an iPad app that uses several (4) different SQLITE databases and I > currently build these databases using Mozilla Firefox SQLite Manager utility > (on a Mac). The databases are simple (single table) with a

Re: [sqlite] Using SQLITE to build database from tab delimited file

You can write your sql commands in a txt file (say mycmd.txt), and then sqlite3 your.databasefile < mycmd.txt Or I have a simple API that lets you import / export csv (not necessarly CSV inderd, any kind of delimited file) files into SQLite, so you can do it via your own C/C++ application

[sqlite] SQL logic error or missing database with Python sqlite

This appears to have been asked many times online, but none of the threads I've seen help me fix my issue. I am using SQLite through Python 2.5 or 2.7, which is the sqlite3 module. In a desktop application, every now and then, and in a fairly irreproducible way, when committing to the database I

[sqlite] Using SQLITE to build database from tab delimited file

I have an iPad app that uses several (4) different SQLITE databases and I currently build these databases using Mozilla Firefox SQLite Manager utility (on a Mac). The databases are simple (single table) with a number of rows, and are created from a text file with tab delimited fields. This all

Re: [sqlite] How to create connection life-time object?

Hi, Dušan On Thu, Jul 25, 2013 at 2:39 PM, Dušan Paulovič wrote: > Hello, is there a way to somehow set a connection life-time object? > ... > > > It would be fine to have something like: > int sqlite3_set_lifetime_object( > sqlite3 *db, /*db connection*/ >

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.88.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to next Friday, August 2nd. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list