Re: [sqlite] Bug : Tcl interface + "INSERT OR REPLACE" statement

2013-09-26 Thread James K. Lowden
On Tue, 24 Sep 2013 20:21:09 +0200 Petite Abeille wrote: > On Sep 24, 2013, at 8:05 PM, Simon Slavin > wrote: > > > Which is why you do an INSERT first, and allow it to fail, then do > > the UPDATE. > > Sure. A lot of error proce procedural code to do what one SQL > statement could do much mor

Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-26 Thread danap
Hello, I'm currently working on a feature to MyJSQLView that allows DB to DB table creation for use with creating in memory or local file data for anaylsis. The feature is really being made to facilitate the oposite of your goal of SQLite to PostgreSQL, but rather PostgreSQL/MySQL/Other to somethi

[sqlite] AUTO: Nicolas Bonte is out of the office. (returning 2013/09/27)

2013-09-26 Thread Nicolas Bonte
I am out of the office until 2013/09/27. For urgent matter, you can contact Giancarlo Mannuccia at giancarlo.mannuc...@awtce.be Note: This is an automated response to your message "Re: [sqlite] Using an sqlite db as a mutex?" sent on 2013/09/26 4:45:49 PM. This is the only notification you

Re: [sqlite] Using an sqlite db as a mutex?

2013-09-26 Thread Dan Kennedy
On 09/26/2013 10:00 PM, Simon Slavin wrote: On 26 Sep 2013, at 3:45pm, Dan Kennedy wrote: Sounds right. BEGIN EXCLUSIVE obtains an exclusive lock on the db. If this succeeds, no other connection to the same database will be able to successfully execute BEGIN EXCLUSIVE until your first connecti

Re: [sqlite] Using an sqlite db as a mutex?

2013-09-26 Thread Simon Slavin
On 26 Sep 2013, at 3:45pm, Dan Kennedy wrote: > Sounds right. BEGIN EXCLUSIVE obtains an exclusive lock on > the db. If this succeeds, no other connection to the same database > will be able to successfully execute BEGIN EXCLUSIVE until > your first connection has concluded its transaction or cl

Re: [sqlite] Using an sqlite db as a mutex?

2013-09-26 Thread Dan Kennedy
On 09/26/2013 06:35 PM, Stephan Beal wrote: Hi, all, some months ago i was tasked with writing a WWW/PHP/MySQL-based application which takes a group of meeting tables and randomly assigns them to participants (yes, this was/is a real application). One of the problems i faced is an inherent race

[sqlite] Using an sqlite db as a mutex?

2013-09-26 Thread Stephan Beal
Hi, all, some months ago i was tasked with writing a WWW/PHP/MySQL-based application which takes a group of meeting tables and randomly assigns them to participants (yes, this was/is a real application). One of the problems i faced is an inherent race condition in the selection of meeting slots. M

Re: [sqlite] fetchObject in Sqlite3

2013-09-26 Thread Simon Slavin
On 26 Sep 2013, at 4:08am, pisey phon wrote: > Would you mind if I want to ask you a question? > Could I use method fetchObject() in Sqlite3? > If Can use it, Could you give me an example, please??? What programming language and/or API are you using ? If you're talking about PHP then you shoul

[sqlite] fetchObject in Sqlite3

2013-09-26 Thread pisey phon
Dear All, Would you mind if I want to ask you a question? Could I use method fetchObject() in Sqlite3? If Can use it, Could you give me an example, please??? Thanks in advance. Pisey phon -- View this message in context: http://sqlite.1065341.n5.nabble.com/fetchObject-in-Sqlite3-tp71494.html

Re: [sqlite] Problem with method numRows() in Sqlite3

2013-09-26 Thread pisey phon
Thanks you . -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-method-numRows-in-Sqlite3-tp71420p71495.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-26 Thread a . furieri
On Thu, 26 Sep 2013 00:01:06 -0700, Alex Mandel wrote: Spatialite I think has a Virtual Postgres table tool too. (You can probably ignore that these are mostly for spatial data, should work fine on regular tables) I'm glad to confirm: SpatiaLite effectively supports a VirtualPG extension modul

Re: [sqlite] sqlite database created in PHP not readable in python becomes how do i download the correct version of the python sqlite API

2013-09-26 Thread Kees Nuyt
On Wed, 25 Sep 2013 20:58:05 -0400, Aryc wrote: >first - thanks for all the insights. >the versions are different (Ugh) but that raises a new question "how do i >correct that?" >these versions were defined by the download of PHP and Python (IE i didn't get > the choice) >below is the PHP code a

Re: [sqlite] Direct PostgreSQL to SQLite connection?

2013-09-26 Thread Alex Mandel
http://www.gaia-gis.it/OpenLite/ ogr2ogr from gdal.org can probably do it on the command line Spatialite I think has a Virtual Postgres table tool too. (You can probably ignore that these are mostly for spatial data, should work fine on regular tables) Honestly a small python script to read from s