SQLite Forum

Typos in the documentation
Login

Typos in the documentation

(1) By natskvi on 2022-01-20 20:19:32 [link] [source]

I've been involved in an effort to port a PostgreSQL-based API to SQLite, and so have been going over the documentation and noting various typos. If the documentation is generated from source I'm happy to create a branch and open the Fossil equivalent of a PR/MR (although I haven't found anything relevant in /doc). Otherwise (HTML maintained manually), here is a list of all typos I found:

https://www.sqlite.org/whentouse.html
SQLite will handle more write concurrency that than many people suspect.

https://www.sqlite.org/different.html
bypassing the filesystem all together altogether.
defines APIs that allows APIs that allow the user

https://www.sqlite.org/quirks.html
bugging buggy behavior
(the names of tables or columns)

https://www.sqlite.org/testing.html
would not have been possible without the availability of full-coverage testing.

https://www.sqlite.org/famous.html
uses SQLite in their in the Android cell-phone operating system,

https://www.sqlite.org/cli.html
today there are over 60.
So you will need to repeat Unspecified columns column widths become zero.
resets all columns column widths
to be determine determined automatically. depending of if on whether the database file is read-only or read-write.
And there might be a fourth result column
The --hexdb option causes the database to be content to be read from
The CLI has another build-in built-in SQL
First, convert the extension in to a DLL or shared library
To generates generate tests to verify
a subset of the tables are is unchanged
as it is insert inserted and extracted from an SQLite Archive.
Database schema schemas which incorporate
Thus, change changing the output mode in one connection will change it in them all.
and are support supported by the SQLite CLI for compatibility.
requires a one or two of the features

https://www.sqlite.org/loadext.html
Windows use uses ".dll", Mac uses ".dylib",
(which explains why SQLite commonly need needs to be linked against

https://www.sqlite.org/series.html
omitted or has an a self-referential

https://www.sqlite.org/errlog.html
has been used to prepared prepare the statements originally,
by deliberately ignore ignoring certain classes of error messages
obscure problems that occurs occur with applications
catching errors occasional errors that the application misses

https://www.sqlite.org/intern-v-extern-blob.html
a database was created that contains contained 100MB of BLOB content.

https://www.sqlite.org/limits.html
different database databases can have page sizes

https://www.sqlite.org/threadsafe.html
Use the SQLITE_THREADSAFE compile-time parameter to selected select the threading mode.

https://www.sqlite.org/nulls.html
Older versions of firebird omits omit all NULLs from
the information gather gathered from this script
What happens when you multiple multiply a NULL by zero?

https://www.sqlite.org/inmemorydb.html
that database always has a private cache and is this that is only visible to
so that just like as with the special ":memory:" string,
hence there is very little difference
if the database becomes large

https://www.sqlite.org/isolation.html
If two database connections shared share the same cache
SQLite uses locks to serialization of serialize the writes automatically;
appear in the same directory in as the database file.
Readers can be be active
all readers must be (temporally) (temporarily) expelled
is completely written and synced to disk and commits committed
then X must ends end its read transaction and start a new one

https://www.sqlite.org/arch.html
private to the virtual machine itself.
In order to provide portability between across operating systems,
SQLite uses an abstract object called the VFS.
opening, read, reading, writing, and closing files on disk,
other OS-specific task tasks such as

https://www.sqlite.org/mmap.html
content does not need to be copied between kernel space and user space.

https://www.sqlite.org/datatype3.html
Applications can chose choose to store dates and times
interpreting the binary BLOB context content as a text string
are handled is as if the comparison were really
All of the result results in the example are the same
collating sequence or collating function (two words terms for the same thing)
comparision comparison expression,

https://www.sqlite.org/stricttables.html
facilitate recover recovery of database files with corrupt schemas.

https://www.sqlite.org/lang_aggfunc.html
as long as at there is at least
return the sum of all non-NULL values in the group.
neither an integer or nor a NULL

https://www.sqlite.org/withoutrowid.html
Storing content in intermediate nodes mean means that

https://www.sqlite.org/partialindex.html
because there are usually multiple people

https://www.sqlite.org/foreignkeys.html
neither SQLITE_OMIT_FOREIGN_KEY or nor SQLITE_OMIT_TRIGGER defined.

https://www.sqlite.org/expridx.html
The acctchng_magnitude index index

https://www.sqlite.org/gencol.html
The only way to change the value of a generated columns column
It is not necessary to put generated columns

https://www.sqlite.org/uri.html
If these this query parameter

https://www.sqlite.org/lang_corefunc.html
For security reasons, extension loaded loading is turned off by default
the BINARY collating function is used.

https://www.sqlite.org/json1.html
those arguments is are usually understood to be a literal strings that are quoted and becomes become JSON string values
if a value argument come comes directly from the result
if there are two or more PATH argument arguments
one of the following an SQL text values:
throws an error if any of its arguments are is not well-formed or is a BLOB.
array or object or or just the top-level element
object container the that holds the current row,

(2) By Larry Brasfield (larrybr) on 2022-01-20 21:40:16 in reply to 1 [source]

Thanks. These flaws are fixed, most as you suggest.