Re: [sqlite] SQLITE_CORRUPT error

Any news about this problem? galea...@korg.it ha scritto: In order to be more confidence about what I'm saying, I downloaded the precompiled sqlite console 3.6.15 (windows version), I executed the statement above and I've got the following error: sqlite3.exe malformed_db.db SQLite version

[sqlite] Order by term not in result set

Pavel Ivanov wrote: It mentions from and column_name where column name in this particular case is selected. ;-) @Igor: I thought that sql standard in this case doesn't guarantee that outer select will return rows in the same order that were enforced in inner select by order by, does

Re: [sqlite] SQLITE_CORRUPT error

On Jun 23, 2009, at 3:16 AM, Andrea Galeazzi wrote: Any news about this problem? http://www.sqlite.org/cvstrac/tktview?tn=3929 galea...@korg.it ha scritto: In order to be more confidence about what I'm saying, I downloaded the precompiled sqlite console 3.6.15 (windows version), I

Re: [sqlite] very bad performance with triggers and indexes

On Jun 23, 2009, at 1:56 AM, David Jud wrote: I did not get any answers at all, so what are my next steps? Should I submit a bug report somewhere? Try omitting the index and making ID an INTEGER PRIMARY KEY. David -Original Message- From: David Jud Sent: Friday, June 19, 2009

[sqlite] Schedule for SQLite 3.6.16. Was: SQLITE_CORRUPT error

On Jun 23, 2009, at 9:49 AM, D. Richard Hipp wrote: On Jun 23, 2009, at 3:16 AM, Andrea Galeazzi wrote: Any news about this problem? http://www.sqlite.org/cvstrac/tktview?tn=3929 We will strive to release SQLite version 3.6.16 on or about 2009-07-01 00:00 UTC for the purpose of fixing

[sqlite] concurrency differences between in-memory and on disk?

Hello, I've developed an application that has very high concurrency.  In my initial testing we used SQLite 3 from python, but we experienced too many locks and the database always fell behind.  We moved to MySQL, which handles the concurrency better, but there was a substantial increase in IO.  

[sqlite] Performance against huge datasets

Hello. I wonder if anyone used SQLite extensively with big datasets and could provide some insight into performance? In a nutshell, I am writing an ETL framework and need a good (read: performing) engine for the Transform part. I suppose I could use flat files for that, but I'd like to have some

Re: [sqlite] Interrupting sqlite

Would forking another process as a worker process be acceptable, then in your main message loop wait for some IPC signal saying it is done? Unless you are doing this on some extremely lightweight OS / monitor that doesn't implement the concept of time-sharing, I can't see how this would be hard to

Re: [sqlite] Performance against huge datasets

On Tue, 23 Jun 2009 22:01:26 +0200, Misza wrote: I wonder if anyone used SQLite extensively with big datasets and could provide some insight into performance? In a nutshell, I am writing an ETL framework and need a good (read: performing) engine for the Transform part. I suppose I could use

[sqlite] Sqlite 3.6.15 crash in Win64

All, Win64 compiled with the latest patched Visual Studio 8. I just downloaded and compiled the latest amalgamation in my project, ran it and the program died immediately. I've tracked it down to SQLITE_OMIT_TRACE. If I compile with this defined, it crashes. It's dying here Expr.c line 2173

[sqlite] help with a utf-8 error

Hi! I'm using pysqlite in Python 2.5.2 and got the following error File py, line 120, in ... cursor.execute(sqlquery) sqlite3.OperationalError: Could not decode to UTF-8 column 'j' with text '77395 149900 178104 251956 257906 290771 294739 421322 537670 565626 600208 81 1358 866671

Re: [sqlite] Sqlite 3.6.15 crash in Win64

On Jun 23, 2009, at 6:47 PM, Teg wrote: All, Win64 compiled with the latest patched Visual Studio 8. I just downloaded and compiled the latest amalgamation in my project, ran it and the program died immediately. I've tracked it down to SQLITE_OMIT_TRACE. If I compile with this defined,

[sqlite] DBD::SQLite reporting corruption sqlite3 CL program does not

From Perl, when I attempt to make a database connection using SQLite, I get the following error: [Tue Jun 23 17:10:22 2009] projectory.cgi: DBI-connect(dbname=projectory.sqlite3) failed: database disk image is malformed at ./projectory.cgi line 1577 At line 1577 it is executing this code $dbh =

Re: [sqlite] help with a utf-8 error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dinesh B Vadhia wrote: Hi! I'm using pysqlite in Python 2.5.2 and got the following error [...] sqlite3.OperationalError: Could not decode to UTF-8 column 'j' with text You should use the pysqlite mailing list