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

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

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

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

[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