Published on 2021/12/1 by ilDon Anita now supports SQLite, which means you can save your data in a local database on your device from a Progressive Web App. This is achieved by using the FileSystemAccessAPI, so the user only needs … Read more
SQLite Release 3.37.0 On 2021-11-27 Small. Fast. Reliable.Choose any three. SQLite Release 3.37.0 On 2021-11-27 STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing. When adding columns that contain a CHECK … Read more
Why SQLite Does Not Use Git SQLite does not use the Git version control system. SQLite uses Fossil instead, which is a version control system that was specifically designed and written to support SQLite. People often wonder why SQLite does … Read more
SQLite Archive Files An “SQLite Archive” is a file container similar to a ZIP archive or Tarball but based on an SQLite database. An SQLite Archive is an ordinary SQLite database file that contains the following table as part of … Read more
A small, cool fact about SQLite is that its columns are flexibly typed. You can store any value in any column! Try it out: sqlite> create table t1 (v1 int, v2 varchar(10)); sqlite> insert into t1 values (“abc”, “this string … Read more
35% Faster Than The Filesystem SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite(). Furthermore, a single SQLite … Read more
Show HN: SQLite query inside a Bash function 48 points by chmaynard 1 hour ago | hide | past | favorite | 14 comments Part of the workflow for building my website is the generation of a table in tab-separated column … Read more
Vulnerabilities CVEs about SQLite probably do not apply to your use of SQLite. All historical vulnerabilities reported against SQLite require at least one of these preconditions: The attacker can submit and run arbitrary SQL statements. The attacker can submit a … Read more
SQLite Release 3.36.0 On 2021-06-18 Small. Fast. Reliable.Choose any three. SQLite Release 3.36.0 On 2021-06-18 Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand. Byte-order marks at the start of a token are skipped as if … Read more
Published on 2021-04-14. The name SQLite is a nice name, but the “lite” part is misleading, it sounds like it is only useful for tiny things – which is very wrong. SQLite should be named AwesomeSQL, because that is what … Read more