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, %s, %s\n", line, citation,
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 spans
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 D
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 not get retrieved by
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 us
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 Garbage Collection.
Did
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 [mailto:sqlite-users-boun
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 debug-s
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 t
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 no
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 compatible) version of
> sqlite
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,
> > I've been using s
12 matches
Mail list logo