Hello folks,
I have a database of roads in a SpatiaLite database. It consist of a
road-table with ~30 columns, including a BLOB-column for the geometry
content.
The performance critical operation is a select from a table with ~2 Mio.
records, where I try to read a subset of roads from a DVD and in
Support just flagged another site. This one has a more "interesting"
corruption issue in that data intended for one table ended up across two
others.
We have no single component that would open all of those tables during it's
runtime. Probably of little consequence we also noticed that F-Secure is
Just to be sure. Could you run the application under Application
Verifier with heap checks enabled?
Best regards,
Filip Navara
On Thu, Apr 14, 2011 at 11:40 AM, James Green wrote:
> Support just flagged another site. This one has a more "interesting"
> corruption issue in that data intended for
Hello,
I have a table in a sqlite database which looks like:
RowID : Dist : X : Y
1: 1.24 : 15 : 15
2: 0.66 : 13 : 17
3: 0.82 : 8 : 12
4: 2.14 : 17 : 19
5: 1.83 : 15 : 13
I want to loop over the single entries of the database-table using Python:
1) a
On Wed, Apr 13, 2011 at 9:05 AM, Mark Hamburg wrote:
> I have a database for which I essentially want to support three streams of
> operations: writing, reading fast queries (e.g., lookup a single record), and
> reading complex queries (e.g., find all of the records matching a particular
> crit
On Thu, Apr 14, 2011 at 5:40 AM, James Green wrote:
> Support just flagged another site. This one has a more "interesting"
> corruption issue in that data intended for one table ended up across two
> others.
>
> We have no single component that would open all of those tables during it's
> runtime.
Drake,
if I do this, I get: SQL logic error or missing database.
Thanks
Gert
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Try:
import sqlite3
conn = sqlite3.connect("database")
c = conn.cursor()
c.execute('SELECT * FROM table ORDER BY X')
for row in c:
print row[2] # Where 2 is the X column
On Thu, Apr 14, 2011 at 7:06 AM, Johannes Radinger wrote:
> Hello,
>
> I have a table in a sqlite database which looks
Original-Nachricht
> Datum: Thu, 14 Apr 2011 10:34:25 -0400
> Von: Martin Gadbois
> An: General Discussion of SQLite Database
> Betreff: Re: [sqlite] Python loop over Sqlite database
> Try:
>
> import sqlite3
> conn = sqlite3.connect("database")
> c = conn.cursor()
> c.execut
Unfortunately, I am not a geek and so don't understand your response!
Can you simplify it for me?
Regards,
On Apr 11, 11:01 pm, mweiguo wrote:
> 于 2011-4-10 12:43, thoselai...@shaw.ca 写道:
>
>
>
> > % package require sqlite
> > couldn't load library "C:/Tcl/lib/sqlite3/sqlite3/.dll": this library
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/14/2011 07:39 AM, Johannes Radinger wrote:
>> c.execute('SELECT * FROM table ORDER BY X')
>
> Thank you very much, I just found that out myself :)
Incidentally the code above is somewhat brittle. If the database schema
changed at some point in
Hi!
With 3.7.6 and 3.7.6.1 on NetBSD-5.99.49/amd64, a program I'm using
started dumping core.
The sequence it is using is sqlite3_open, sqlite3_exec (with a
synchronous = off), sqlite3_exec with user_version and boom. I can
reproduce this with the command line client.
# sqlite3 new
SQLite versio
On 04/15/2011 12:27 PM, Thomas Klausner wrote:
> Hi!
>
> With 3.7.6 and 3.7.6.1 on NetBSD-5.99.49/amd64, a program I'm using
> started dumping core.
Can you post the stack-trace from the core file? With debugging
symbols if possible.
> Perhaps non-standard options used during compilation are
> -D
On Fri, Apr 15, 2011 at 01:20:11PM +0700, Dan Kennedy wrote:
> Can you post the stack-trace from the core file? With debugging
> symbols if possible.
Sorry, the backtrace is unusable:
(gdb) bt
#0 __nanosleep50 (rqtp=0x7f7fc1b0, rmtp=0x0)
at /archive/cvs/src/lib/libpthread/pthread_cancelst
On 04/15/2011 01:32 PM, Thomas Klausner wrote:
> On Fri, Apr 15, 2011 at 01:20:11PM +0700, Dan Kennedy wrote:
>> Can you post the stack-trace from the core file? With debugging
>> symbols if possible.
>
> Sorry, the backtrace is unusable:
> (gdb) bt
> #0 __nanosleep50 (rqtp=0x7f7fc1b0, rmtp=0x
15 matches
Mail list logo
