Re: [sqlite] importing csv
Dear Alan: I have implemente an application that I name as ExcelToSQLite and his counterpart SQLiteToExcel. If you want, I can sent to you. Your Ing. Héctor F. Fiandor Rosario ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Locking databases - Possibly (probably?) a dumb question
On 08/26/2016 01:20 PM, David Raymond wrote: [snip] > Many do not persist after closing your connection, including synchronous and > foreign_keys that you mentioned. In fact, I'd say that the number that do > persist is pretty small, and those that do usually require a vacuum or such > after being issued so that a new value can get put in the header, or the file > is reorganized, etc. [snip] Wow, thanks! That's a very relevant detail that doesn't seem to be documented anywhere and I probably would have continued with the misunderstanding until something went very wrong (or worse, incomprehensible system behavior led to frustration and eventual abandonment). ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Locking databases - Possibly (probably?) a dumb question
Pragmas are listed out here: http://www.sqlite.org/pragma.html Many do not persist after closing your connection, including synchronous and foreign_keys that you mentioned. In fact, I'd say that the number that do persist is pretty small, and those that do usually require a vacuum or such after being issued so that a new value can get put in the header, or the file is reorganized, etc. Another way of looking at it is to look at what's in the header here: http://www.sqlite.org/fileformat2.html If it doesn't have a spot in the header then there's no way to save the change for subsequent connections. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Adam Jensen Sent: Friday, August 26, 2016 12:55 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Locking databases - Possibly (probably?) a dumb question On 08/25/2016 04:41 PM, Adam Jensen wrote: ... And, as far as I can tell, all of these PRAGMA's seem to persist - they do not need to be reasserted in any way during subsequent database accesses. Do all PRAGMA's, once set to a specific value, stay set? Does anyone have links to the related documentation? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Locking databases - Possibly (probably?) a dumb question
On 08/25/2016 04:41 PM, Adam Jensen wrote: > On 08/20/2016 01:01 PM, Simon Slavin wrote: >> On 20 Aug 2016, at 5:56pm, Lev wrote: > [snip] >>> So this 'setting' is stored in the database file? Is it enough to do the >>> PRAGMA when the database is created? >> >> Yes and yes, but do it this way. >> >> 1) Create the database file by opening it. >> 2) Do something that makes the file non-blank, like creating a table. >> 3) Issue "PRAGMA journal_mode=WAL" >> 4) Close the file >> >> From that point onwards that database is in WAL mode and everything opening >> it automatically knows that. You do the above sequence using your own >> software or the SQLite command-line shell tool. > > > When in WAL mode, when would `PRAGMA synchronous = NORMAL` be issued and > does it persist? During database creation, this order seems to work: PRAGMA page_size = 2048; PRAGMA synchronous = NORMAL; PRAGMA foreign_keys = ON; CREATE TABLE ...; CREATE TABLE ...; PRAGMA journal_mode = WAL; .quit # https://www.sqlite.org/wal.html # https://www.sqlite.org/pragma.html#pragma_wal_checkpoint And, as far as I can tell, all of these PRAGMA's seem to persist - they do not need to be reasserted in any way during subsequent database accesses. Do all PRAGMA's, once set to a specific value, stay set? Does anyone have links to the related documentation? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] v3.14.1 Speed is real
I just wanted to say thank you for the fixes on this version. It has speed up many of my updates. I have not really found how fast, but, I have notice the increase in speed on the system with the updates. Thanks. josé ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
