Re: [sqlite] what is the optimized way to do the vaccum?

On Wed, Dec 4, 2019, 9:28 PM Zhu, Liang [AUTOSOL/ASSY/US] < liang@emerson.com> wrote: > All Sqlite Expert, > > I have one table, I am inserting and deleting record to and from this > table very 250ms. I always maintain 1000 rows in this table. I have > another table, I am inserting and

[sqlite] what is the optimized way to do the vaccum?

All Sqlite Expert, I have one table, I am inserting and deleting record to and from this table very 250ms. I always maintain 1000 rows in this table. I have another table, I am inserting and deleting data to and from this table every 1s. The data record in this table maintains at 200,000

Re: [sqlite] PRAGMA for .load

David Raymond, on Tuesday, December 3, 2019 03:43 PM, wrote... > > I _think_ the load_extension() function is what you'll be looking for, though > I > could be wrong. > > https://www.sqlite.org/lang_corefunc.html#load_extension [clip] > I was looking into the pragmas page, and I don't see one

[sqlite] csv extension/feature requests: new options for field separator different from default ', ' and skip=N to skip first N lines

Hi everyone, would it be possible to add to the csv extension the following parameter options (with syntax along the lines of): - sep=';': field separator character (different from default ',') - skip=N: skip the first N lines Both options would be very helpful for information of fixed format