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

[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] 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 >

[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

[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

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 "T"ransform part. > I suppose I

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

[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 "T"ransform part. I suppose I could use flat files for that, but I'd like to have

[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] 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

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

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

[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

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