[sqlite] FTS5 bug in SQLite 3.18.0

x86_64 x86_64 GNU/Linux ``` This behaviour appeared in the earlier versions of SQLite, for sure in Hope this helps, Krzysztof Małysa ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] Tags / keywords support?

Thanks Constantine! Great idea with table contains tags per record! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Tags / keywords support?

Hi, I need extra field which contain tags / keywords describing such record. Then I want to find record ID by using tags. I know that it is easy with TEXT field and LIKE condition but I have issue with update speed. Let say that you have collection of photos and you want to add tags like

Re: [sqlite] Check if file exists in SQL syntax?

elect getfileattributes('D:\source\sqlite'); > 16 > sqlite> > > You do similar on Unices just substitute the appropriate call to get the file > attributes ... > >>-Original Message- >>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >>

[sqlite] Check if file exists in SQL syntax?

Hi, I'm collecting file names (full paths) in sqlite table. Each day I need to remove non existing files from this table (thousands records). For now I'm selecting all records and then checking if file exists using C++ routine and if not then deleting it. I'm wondering if SQLite has such function

[sqlite] Merging databases

Hi, I have daemon on server which each day create new sqlite database. Client application can download and present these databases. For example: User want to see data from last week so client application download 7 files. Advantage of this defragmentation is that it don't need to download big

Re: [sqlite] SQLite - disk I/O error only on virtual machine

Problem solved. It was shared folder issue ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite - disk I/O error only on virtual machine

Hi, I noticed strange behavior when running application on virtualbox linux mint 14 64bit machine. This occur only when I attach second database to sqlite3connection and then call SQLTransaction.Commit. This is my code (this is Free Pascal / Lazarus wrapper for SQLite): try FConn :=

Re: [sqlite] Are Foreign Keys indexed?

Thanks for answer! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Are Foreign Keys indexed?

Hi, I'm reading http://www.sqlite.org/foreignkeys.html but can't find answer. Are SQLite FK indexed? For example: CREATE TABLE artists ( id_artist INTEGER PRIMARY KEY // <- PK are indexed, that I know ) CREATE TABLE songs ( id_song INTEGER PRIMARY KEY, id_artist INTEGER, // <- Is this FK

Re: [sqlite] Using sqlite in multi fork() without threads

Few days ago I posted questions about sqlite multi threading on sqlite mailing list. I could paste link to this thread but it is for members only. So here is content, maybe it wil help you in some cases: Hi, I'm reading documentation about multi threading. I just want to be sure: 1. I can

Re: [sqlite] Multi thread questions

Thanks :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Multi thread questions

Hi, I'm reading documentation about multi threading. I just want to be sure: 1. I can safely create another thread (with new handle / connection) in my application and modify SAME database at the same time 2. I want use second connection in thread for importing while main thread working

Re: [sqlite] INSERT OR IGNORE - returning new or existing rowid

Ok I have done this with two commnads where first check if record exist. I tried do this with one command because I want to speed up importing from csv. CSV has one table for example: name | surname | country. I want split repeated columns to dictionary tables like: table customers - name -

[sqlite] INSERT OR IGNORE - returning new or existing rowid

Hi, When I use INSERT OR IGNORE, if insertion fail (record exists), then sqlite3_last_insert_rowid does return nothing. Is exists similar solution which: 1. If insert success then return new rowid 2. If insert fail (record exists) then return rowid of existing record Can I get this information

Re: [sqlite] SQLite - Dropping TEMP table doesn't free allocated memory

I don't understand :/ So what is solution in my case? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite - Dropping TEMP table doesn't free allocated memory

I thought about reopen connection (this would solve my problem in simple way) but my dependencies are tricky. I'm using free pascal which have TSQLite3Connection. This class handle sqlite connection, so I can attach multiple tables in the same session, so I can share temp tables between all tables

Re: [sqlite] SQLite - Dropping TEMP table doesn't free allocated memory

Can I call vacuum on custom tables (for example only on temp tables) ? Because vacuum takes some time (my "normal" tables are big and often modified, trim of those tables are not important for me) and I would like to free up memory taken only by temp tables

[sqlite] SQLite - Dropping TEMP table doesn't free allocated memory

Hi, I'm using PRAGMA temp_store=2 so all temp tables are created in memory. I have temp table with 1 000 000 000 records. Memory used by my test application grow up to ~80 MB. If I delete all records from this table or drop table, then my application still use 80 MB of memory. I have tried also

[sqlite] On-line documentation license

this time with English docs. PS. What was used to produce the diagrams, and would it be possible to get vectorized versions of them? (if vectorized would require any extra work, please ignore, the bitmap from the website will do) Thanks in advance, Krzysztof `ChanibaL` Bociurko <sql...@chanibal.ne

[sqlite] On-line documentation license

t was used to produce the diagrams, and would it be possible to get vectorized versions of them? (if vectorized would require any extra work, please ignore, the bitmap will do) Thanks in advance, -- Krzysztof `ChanibaL` Bociurko <sql...@chanibal.net> xmpp://jab...@chanibal.net, htt

[sqlite] Update callback and REPLACE

Hi all, I have a question about an update callback. It's supposed to be called for every row that's inserted, updated and deleted and it works fine. Now there's a little thing calles INSERT OR UPDATE (and its friends) which removes conflicting rows before the INSERT. The thing is, the callback

Re: [sqlite] ORDER BY / HAVING clauses and aliased field names

BY query sections? AFAIR those two clauses are being resolved at the very end , after WHERE and JOINs handling, also all the result columns are already defined - so how come is there any ambiguity? Either way - thanks for all your suggestions, With all regards, -- Krzysztof Kotowicz

Re: [sqlite] ORDER BY / HAVING clauses and aliased field names

BY clauses like '_aliased.country_name' ? Thanks for your help in advance. With regards, -- Krzysztof Kotowicz

[sqlite] ORDER BY / HAVING clauses and aliased field names

ld help me with this mater, I would be very thankful. Any tricks, hacks... Thanks in advance, With regards, Krzysztof Kotowicz

[sqlite] Win CE support

integrated into official sources no matter how good they are) b) what's the best way to make it happen? open a bug and attach diff to it? Krzysztof Kowalczyk | http://blog.kowalczyk.info