Re: [sqlite] [PATCH] Fix "Symbol not found: _OSAtomicCompareAndSwapPtrBarrier" on Mac OS X 10.4 (Tiger)

2012-08-21 Thread Dwayne Litzenberger
On Tue, Aug 21, 2012 at 5:54 PM, Dwayne Litzenberger wrote: > Please apply the attached patch against the latest trunk (45cdc32f1e), > which fixes this bug. It looks like the mailman archives stripped the patch, so here it is again, as text: commit adf442e047fcf8523b43ff975be872a36e3d5b40 Author

[sqlite] [PATCH] Fix "Symbol not found: _OSAtomicCompareAndSwapPtrBarrier" on Mac OS X 10.4 (Tiger)

2012-08-21 Thread Dwayne Litzenberger
Recent versions of SQLite fail to run on Mac OS X 10.4 (Tiger) with the following error message: $ DYLD_LIBRARY_PATH=. ./sqlite3 dyld: lazy symbol binding failed: Symbol not found: _OSAtomicCompareAndSwapPtrBarrier Referenced from: ./libsqlite3.0.dylib Expected in: /usr/lib/lib

Re: [sqlite] app-defined functions, statements and sqlite3_value

2012-08-21 Thread Igor Tandetnik
On 8/21/2012 3:11 PM, Marco Maggi wrote: Unless I overlooked it, the Python binding[1] does not even allow an app-defined function to retrieve the connection handle. [1] The last parameter to Connection.create_function is a Python

Re: [sqlite] app-defined functions, statements and sqlite3_value

2012-08-21 Thread Marco Maggi
Thanks to everyone, my mind is now more clear about this (and my documentation will be too). Jay A. Kreibich wrote: >> * Is there some simple and "known" example of such >> mechanism I can put in my test suite and documentation to >> show how it is done? > > Anything you want. Use a f

Re: [sqlite] app-defined functions, statements and sqlite3_value

2012-08-21 Thread Jay A. Kreibich
On Tue, Aug 21, 2012 at 11:02:26AM +0200, Marco Maggi scratched on the wall: > I am a True Beginner with SQLite and I am writing a > binding to it for a programming language. While wrapping > the functions accepting "sqlite3_value" arguments, I am not > sure if I understand from whe

[sqlite] ANN: SQLite PHP Generator 12.8 released

2012-08-21 Thread SQL Maestro Group
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 12.8, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite P

Re: [sqlite] VACUUM fails once in a while with status=14 (unable to open database file)

2012-08-21 Thread Dominique Pellé
Richard Hipp wrote: > On Tue, Aug 21, 2012 at 5:30 AM, Dominique Pellé > wrote: > >> Hi >> >> Once in a while, I see an error when doing a "VACUUM" operation. >> >> sqlite3_exec3(...) returns status=14 (unable to open database file). >> I suppose that it fails to open a temporary database when do

Re: [sqlite] app-defined functions, statements and sqlite3_value

2012-08-21 Thread Igor Tandetnik
Marco Maggi wrote: > I am a True Beginner with SQLite and I am writing a > binding to it for a programming language. While wrapping > the functions accepting "sqlite3_value" arguments, I am not > sure if I understand from where "sqlite3_bind_value()" (and > "sqlite3_result_value()")

Re: [sqlite] VACUUM fails once in a while with status=14 (unable to open database file)

2012-08-21 Thread Simon Slavin
On 21 Aug 2012, at 10:30am, Dominique Pellé wrote: > I wonder whether VACUUM of different databases happening > in parallel in different processes could use the same temporary > file names, causing conflicts. I don't think so. SQLite makes up a random filename for the temporary database, then

Re: [sqlite] VACUUM fails once in a while with status=14 (unable to open database file)

2012-08-21 Thread Richard Hipp
On Tue, Aug 21, 2012 at 5:30 AM, Dominique Pellé wrote: > Hi > > Once in a while, I see an error when doing a "VACUUM" operation. > > sqlite3_exec3(...) returns status=14 (unable to open database file). > I suppose that it fails to open a temporary database when doing > the VACUUM operation, but I

[sqlite] VACUUM fails once in a while with status=14 (unable to open database file)

2012-08-21 Thread Dominique Pellé
Hi Once in a while, I see an error when doing a "VACUUM" operation. sqlite3_exec3(...) returns status=14 (unable to open database file). I suppose that it fails to open a temporary database when doing the VACUUM operation, but I don't see why. sqlite3_extended_errcode(db) also returns extendedEr

[sqlite] app-defined functions, statements and sqlite3_value

2012-08-21 Thread Marco Maggi
Ciao, I am a True Beginner with SQLite and I am writing a binding to it for a programming language. While wrapping the functions accepting "sqlite3_value" arguments, I am not sure if I understand from where "sqlite3_bind_value()" (and "sqlite3_result_value()") should take their argu

Re: [sqlite] Transaction issues with WinRT build

2012-08-21 Thread Lukas
Simon Slavin writes: > Is there a chance that you simply have an UPDATE command with a bad syntax ? You say it works fine on one > implementation of 3.7.13 but not the other ? I'm mystified by what you're seeing but I hope someone else can help. Thanks Simon, the update statements are fine. I

Re: [sqlite] Transaction issues with WinRT build

2012-08-21 Thread Lukas
Joe Mistachkin writes: > Setting the sqlite3_temp_directory to the value contained in the > "Windows.Storage.ApplicationData.Current.TemporaryFolder.Path" property > should clear the issue. This can be done immediately after opening the > connection using PRAGMA temp_store_directory command on t