Re: [sqlite] Statement is not executing

In case people are wondering. :-D 2011/7/3 Cecil Westerhof > I am not sure if it is a SQLite problem, or a Java problem. > > While filling a table I get an error "Statement is not executing". It > happens in the following code: > System.out.printf("%d,

[sqlite] False negatives from RTree

Hi, Has anybody ever seen anomalous behaviour on an R*Tree. Specifically, false negatives? I'm using Spatialite 2.4.0 RC. What I end up with is a table into which I can insert new geometry, but that geometry does not get retrieved by an appropriate RTree search. Indeed, even a search which

Re: [sqlite] Minimal SQLite

You might want to check out various compilation options at: http://www.sqlite.org/compile.html -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Monday, July 04, 2011 7:28 AM To: General Discussion of SQLite

Re: [sqlite] False negatives from RTree

On Tue, Jul 5, 2011 at 8:55 AM, Ben Harper wrote: > Hi, > Has anybody ever seen anomalous behaviour on an R*Tree. Specifically, false > negatives? > I'm using Spatialite 2.4.0 RC. > > What I end up with is a table into which I can insert new geometry, but > that geometry does

[sqlite] Very specific use of sqlite3_backup_* with main and temp tables between a real and a :memory: database

Hello, I would like more details about the functions sqlite3_backup_*. I am trying to use them in a very specific use case. I have a database with real and temporary tables. For a very specific work, I must load (for a while) the real tables only in memory because it must not affect the other

Re: [sqlite] Statement is not executing

On Tue, Jul 5, 2011 at 11:08 AM, Cecil Westerhof wrote: > The problem was a Java problem. I use a preparedStatement and for one > reason > or another this went wrong after a little more as 2.000 inserts. I now do a > new preparedStatement every 1.000 inserts. > Long Live

Re: [sqlite] False negatives from RTree

The statement << SELECT * FROM idx_elec_lv_cable_geometry EXCEPT SELECT * FROM idx_elec_lv_cable_geometry where xmax >= -9e30 AND xmin <= 9e30 AND ymax >= -9e90 AND ymin <= 9e30; >> yields an empty set. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] False negatives from RTree

I've tried stepping into the rtree code, and the right code paths all seem to get hit. Nevertheless, once the transaction completes, I open the table again, and the freshly inserted records do not appear in the idx_elec_lv_cable_geometry_rowid table. And this is especially strange, since I

[sqlite] ANN: C#-SQLite 3.7.7.1

C#-SQLite has been updated to release 3.7.7.1 and is RC1 is now ready for use. The 7/5/2011 release features: * Updated to SQLite version 3.7.7.1 * VFS is planned for RC2 * WAL is planned for RC3 * FTS is planned for RC4 It now runs 58,187 of the tcl testharness quicktests and 273,163 of

[sqlite] Windows command-line executable for sqlite 2.x

Hi, I've been using sqlite 2.8.14 through PHP since a long time and now I'm thinking of upgrading to latest version. In order to .dump my old database files, I need command-line executable for 2.8.14 (or compatible) version of sqlite. 1. Is there an equivalent method in PHP itself? 2. If

Re: [sqlite] Windows command-line executable for sqlite 2.x

On Wed, Jul 6, 2011 at 12:09 AM, Altu Faltu wrote: > Hi, > > I've been using sqlite 2.8.14 through PHP since a long time and now I'm > thinking of upgrading to latest version. In order to .dump my old database > files, I need command-line executable for 2.8.14 (or

Re: [sqlite] Windows command-line executable for sqlite 2.x

Cool! Thanks, Kevin!! - Altu - Original Message - From: Kevin Benson Sent: 07/06/11 10:21 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Windows command-line executable for sqlite 2.x On Wed, Jul 6, 2011 at 12:09 AM, Altu Faltu wrote: > Hi,