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:
Has anybody ever seen anomalous behaviour on an R*Tree. Specifically, false
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
You might want to check out various compilation options at:
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Monday, July 04, 2011 7:28 AM
To: General Discussion of SQLite
On Tue, Jul 5, 2011 at 8:55 AM, Ben Harper wrote:
> Has anybody ever seen anomalous behaviour on an R*Tree. Specifically, false
> 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
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
the real tables only in memory because it must not affect the other
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
> or another this went wrong after a little more as 2.000 inserts. I now do a
> new preparedStatement every 1.000 inserts.
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.
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,
C#-SQLite has been updated to release 188.8.131.52 and is RC1 is now ready for
The 7/5/2011 release features:
* Updated to SQLite version 184.108.40.206
* 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
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
1. Is there an equivalent method in PHP itself?
On Wed, Jul 6, 2011 at 12:09 AM, Altu Faltu wrote:
> 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
- 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,
Mail list logo