Re: [sqlite] FTS4 + spellfix1 with multiple languages

On 10/16/13 08:48, Dan Kennedy wrote: On 10/15/2013 08:13 PM, Raf Geens wrote: Hi, I have a FTS4 table that contains entries in multiple languages (using the languageid option). I also have a spellfix1 table that I use to search with misspelled words on the FTS4 table. In the spellfix1

[sqlite] FTS4 + spellfix1 with multiple languages

then use fts4aux and fill the spellfix1 table language by language. This feels like a big hack though. Have I missed a better way to do this?   Kind regards, Raf Geens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] EXTERNAL: database is locked(5) too often - what am i doing wrong?

integrity check on a 3.4.2 database and query it but I'd like to know for sure whether or not I need to rebuild the database. It seems that they must be compatible or the 34to35.html page would have stated that they weren't. Thanks, raf > > > From: sqlite-use

[sqlite] database is locked(5) too often - what am i doing wrong?

these into a single transaction likely to help or make matters worse? Or is this just an inappropriate use of sqlite? I expect I'll have to migrate it to postgres but I thought I'd ask for opinions here first. Cheers, raf ___ sqlite-users mailing list sql

Re: [sqlite] Recipe to safely move/rename a database?

o reason why you shouldn't pursue the technique you > mentioned, but I thought I'd give you an alternative you might prefer. > > Simon. cheers, raf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Updating a database by email

ake sure that the updates are digitally signed and probably encrypted and verify the signatures at the recipient's end. and i'm only half joking :-) cheers, raf p.s. i think .forward files only forward all messages. procmail is probably what you need to invoke arbitrary commands to proces

Re: [sqlite] Recovery program

Roger Binns wrote: > raf wrote: > > i also needed the ability to restore an sqlite3 database > > after a corruption. > > What exactly are you doing that corrupts the database in the first > place? If the machine you are using is randomly corrupting data then > having

Re: [sqlite] Recovery program

tore the previous good backup, then it would run a recovery program which identifies the difference between the history table and the history log file and reapply any inserts or updates that are present in the log file but not in the history table. of course, you need all of this set up in advance,

Re: [sqlite] .dump often fails silently

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > raf wrote: > > the sqlite3 .dump command (version 3.4.2 and earlier) often fails > > silently. i.e. it produces a file containing nothing but: > > The code for the shell mostly just runs

[sqlite] .dump often fails silently

messages and no error exit code to tell me what went wrong. it happens quite often. my backup/restore script runs every 15 minutes and this happens 1-2 times a day on average. does anyone know what this does mean? or if it's any better with recent versions? cheers, raf p.s. it would be nice

Re: [sqlite] Re: seem to need write permission on db's parent directory

Igor Tandetnik wrote: > raf wrote: > >using sqlite-3.2.7 via the perl module, DBD-SQLite-1.11, > >from a cgi script via apache on linux on a local filesystem, > >i received this error: > > > > DBD::SQLite::st execute failed: unable to open databas

[sqlite] seem to need write permission on db's parent directory

le as well made the insert work and made the error message stop appearing. i don't know whether sqlite or DBD::SQLite is the cause here but i thought i should mention it on this list because i started looking at this list's archives for a solution and couldn't find one. cheers, raf