4:02 UTC 2017
x86_64 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
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
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 "summer",
lite> select 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-
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
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 file
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
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 := TMySqli
Thanks for answer!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 i
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 safely
Thanks :)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 "normally"
"Country" was only example, there are much other "dictionary" tables. I
finally solved this by second command which first check if record exists. I
asked this question because I thought that maybe there is some "magic"
trick to do this in one command ;) For example PostgreSQL has INSERT
command whi
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
- surnam
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 in
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
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
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
_
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 PR
he end of this year, 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` Bociurk
of this year.
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 will do)
Thanks in advance,
--
Krzysztof `ChanibaL` Bociurko
xmpp://jab..
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 get
HAVING / ORDER 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
in ORDER BY clauses like
'_aliased.country_name' ?
Thanks for your help in advance.
With regards,
--
Krzysztof Kotowicz
ield throws ambiguity error because i'm joining tables with
fields named like alias - although they never appear as result fields
directly (they are used only in expression of alias field).
If you could help me with this mater, I would be very thankful. Any
tricks, hacks...
Thanks in advance,
With regards,
Krzysztof Kotowicz
patches wouldn't get 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
27 matches
Mail list logo