Re: [sqlite] LiteCLI

Hi Folks, I'm one of the authors of the litecli project. it is an OpenSource tool with BSD3 license. Home page: https://litecli.com/ I'm happy to answer any questions. We don't have support for all the dot commands but we're slowly adding things. We currently support .mode, .schema, .tables, .

[sqlite] LiteCLI

LiteCLI is a user-friendly command line client for SQLite with syntax highlighting and command-line completion. It's written in Python, and tested on Linux, MacOS and Windows. Simon. ___ sqlite-users mai

Re: [sqlite] sqlite3_open_v2 and sqlite3_prepare_v2 string lifetimes

On 1/5/19, Jesse Rittner wrote: > Is it safe to free the filename string immediately after calling > sqlite3_open_v2? What about the zSql string immediately after calling > sqlite3_prepare_v2? Will it ever cause any problems (like calling the > sqlite3_db_filename or sqlite3_sql methods)? SQLite

[sqlite] sqlite3_open_v2 and sqlite3_prepare_v2 string lifetimes

Is it safe to free the filename string immediately after calling sqlite3_open_v2? What about the zSql string immediately after calling sqlite3_prepare_v2? Will it ever cause any problems (like calling the sqlite3_db_filename or sqlite3_sql methods)? -- Sent from: http://sqlite.1065341.n5.nabble.

Re: [sqlite] Using sqlite3_interrupt with a timeout

A question was if a sort is also programmatically interruptable. With the knowledge that the command tool calls sqlite3_interrupt upon the first CONTROL-C, this is easily tested. From the timings below it appears to be so. $ sqlite3 SQLite version 3.25.2 2018-09-25 19:08:10 Enter ".help" for us