[sqlite] SUBSTR overload and ALTER TABLE

We just experienced the hard way that overloading certain built-in SQL function can interfere with core SQL commands if the overloaded function behaves differently from the built-in function. Not surprising, after looking at the sources: * ALTER TABLE - alter.c uses SUBSTR and LIKE. * VACUUM

Re: [sqlite] problem porting sqlite amalgamation 3.6.23.1 to vxworks 6.5 pentium3 DKM

Hi, -- Forwarded message -- From: ZhiHua Huang Date: 2009/8/26 Subject: Re: [sqlite] port sqlite to VxWorks To: General Discussion of SQLite Database Hi, use these definitions. -DOS_VXWORKS_660=660\

Re: [sqlite] SUBSTR overload and ALTER TABLE

>We just experienced the hard way that overloading certain built-in SQL >function can interfere with core SQL commands if the overloaded function >behaves differently from the built-in function. > >Not surprising, after looking at the sources: > >* ALTER TABLE - alter.c uses SUBSTR and LIKE. >*

[sqlite] 'DatabaseError: database disk image is malformed'

[I first posted this on the Trac user list. There, I was referred to the sqlite mailing lists.] I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 3.4.1, pysqlite-2.3.5. More or less simultaneously (at least within a few days) all three trac databases got corrupted. You can

Re: [sqlite] 'DatabaseError: database disk image is malformed'

On Apr 10, 2010, at 10:21 AM, Rutger Hofman wrote: > [I first posted this on the Trac user list. There, I was referred to > the > sqlite mailing lists.] > > I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 > 3.4.1, pysqlite-2.3.5. More or less simultaneously (at least

Re: [sqlite] 'DatabaseError: database disk image is malformed'

On 02:21 pm, rut...@cs.vu.nl wrote: >[I first posted this on the Trac user list. There, I was referred to >the >sqlite mailing lists.] > >I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 >3.4.1, pysqlite-2.3.5. More or less simultaneously (at least within a >few days) all

Re: [sqlite] 'DatabaseError: database disk image is malformed'

On 10 Apr 2010, at 3:32pm, D. Richard Hipp wrote: > none of that should be in the first page of the database file. Nor > does that text appear to be in a format that would appear anywhere in > a valid SQLite database. So I'm guessing that some other process has > decided to open the

[sqlite] Reduce database file size

Hello, I would like to make an SQLite database as small as possible to transfer it over a slow link. Currently I am dropping all custom indices, run VACUUM and compress the file with lzma -9. However, I noticed that if I dump the entire database into a text file with the SQLite shell and then

Re: [sqlite] Reduce database file size

On 10 Apr 2010, at 11:06pm, Nikolaus Rath wrote: > However, I noticed that if I dump the entire database into a text file > with the SQLite shell and then compress the text file, the result is > significantly smaller than the "stripped" compressed database: > > Full database: 146 MB > Without

Re: [sqlite] Reduce database file size

On 04/10/2010 03:06 PM, Nikolaus Rath wrote: > However, I noticed that if I dump the entire database into a text file > with the SQLite shell and then compress the text file, the result is > significantly smaller than the "stripped" compressed database: Have you tried different page sizes? You