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,
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
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
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
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
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
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
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
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
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
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
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,
12 matches
Mail list logo