[sqlite] '.open' without args crashes shell

SQLite version 3.24.0 2018-05-09 16:32:00 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .version SQLite 3.24.0 2018-05-09 16:32:00 9f7a6ae878cd17ff4de7c55e654406773e0ea2b9fe1c4e2a9fc2b0da84d059a4 zlib ver

[sqlite] Typo in documentation for .sha3sum CLI command

Hi folks, The documentation for the .sha3sum CLI command indicates that the default variety of SHA-3 used is SHA-256, but (at least on 3.19.3) when the command is run without options, I get a 56-hex digit output, indicating SHA

[sqlite] OR statement in LIKE

I can't remember if I asked this before. Went to google and didn't find an answer. Could there be a plan put in place that would including an "OR" mask character? The reason I ask is that I've got a user input field that searches the required field in a database using % as the "AND" statement, b

Re: [sqlite] OR statement in LIKE

Insert usual comment of "the more you add, the less 'Lite' it becomes" Rather than changing LIKE, which would probably be bad, adding in something akin to Postgres's SIMILAR TO is a better idea. https://www.postgresql.org/docs/10/static/functions-matching.html I'd be of the opinion that going p

Re: [sqlite] OR statement in LIKE

On 05/10/2018 01:48 PM, David Raymond wrote: Insert usual comment of "the more you add, the less 'Lite' it becomes" Saw this and thought "brilliant". Exactly. The UNIX way is to do one thing and do it well and move on. Not seventy five things poorly. Dennis

Re: [sqlite] OR statement in LIKE

> On May 10, 2018, at 10:27 AM, Stephen Chrzanowski wrote: > > select * from SomeComments where Comment like 'Beginning%|%End' Don’t try to reinvent regular expressions! If you add a SQLite extension that defines a regexp() function, such as this one (which I’ve never used) https://g

Re: [sqlite] OR statement in LIKE

You could probably use the one in Sqlite3 as well, rather than a third party one ... https://www.sqlite.org/src/artifact/a68d25c659bd2d89 --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: