Meet Gor·Sep 20, 2025SQLite dot commands: header commandThe .headers command is crucial as might effect the way the result set is displayed. The first row would be set to the name of the columns…
Meet Gor·Sep 19, 2025SQLite dot commands: Output mode separator commandUsing the separator for the output
Meet Gor·Sep 14, 2025SQLite dot commands: read command is recursive?Yesterday, while exploring the .read command I discovered a little hack.
Meet Gor·Sep 12, 2025SQLite Scalar function: 3 valued iif and if scalar functionIn the recent SQLite version specifically the 3.48.0, the support for pair of conditions was added to the iif function. And also an alias…
Meet Gor·Sep 11, 2025SQLite functions: unistr and unistr_quoteSQLite 3.50 introduced unistr and unistr_quote functions
Meet Gor·Sep 10, 2025SQLite dot commands: html tables with output and onceThe .once -w or .www was released in SQLite 3.47 release last year.