Hi, all,
i'm porting some code from one sqlite3-using project (Fossil SCM) to
another sqlite3-using project (a prototype for Fossil v2) and i came across
this code snippet:
while( rc==SQLITE_OK && z[0] ){
pStmt = 0; // < type=(sqlite3_stmt*)
rc = sqlite3_prepare_v2(g.db, z, -1, &pSt
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 not to free
(if the
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 preprocess
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 contacting the database file
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 debugge
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 there a way to somehow set a connection life-ti
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 number of rows,
> and are created
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 as
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
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 wo
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*/
> const char *zObjectN
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
sqlite
12 matches
Mail list logo