Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Maintaining Private Branches Of SQLite
(privatebranch.html)
3.3. Installing The SQLite Baseline In Fossil
... If you do not want to use your web browser to view the new check-in,
you can get some information from the command-line using commands like
these:
fossil timeline
fossil info
fossil status
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... The data format is "transparent" in the
sense that it is easily decoded for human viewing using
a variety of universally available, open-source tools, from multiple
vendors.
File archive and/or data container
The SQLite Archive idea shows how ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SQLITE_OMIT_VIEW
Defining this option omits support for VIEW objects. Neither the
CREATE VIEW nor the DROP VIEW
commands are available in this case, and
attempting to execute either will result in a parse error.
WARNING: If this macro is defined ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
4.1. We've never done it that way before
... Flexible typing
upsets their world-view.
Yes, flexible typing is a new way of thinking about data in an
SQL database. But new is not necessary bad. Sometimes, and I think
especially in the case of flexible typing, innovation leads ...
|
|
SQLite Older News
(oldnews.html)
... Finally, a couple of long-standing and obscure problems associated with run
UPDATE and DELETE on VIEWs were fixed.
The changes from 3.8.7 are minimal.
2014-10-17 - Release 3.8.7
SQLite version 3.8.7 is ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... A pile-of-files format can be viewed as a key/value database.
A key/value database is better than no database at all.
But without transactions or indices or a high-level query language or
a proper schema,
it ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
1. Introduction
... From the perspective of an SQL statement,
the virtual table object looks like any other table or view.
But behind the scenes, queries and updates on a virtual table
invoke callback methods of the virtual table object instead of
reading ...
|
|
SQLite FTS5 Extension
(fts5.html)
4.8. The Locale Option
... CREATE TABLE t1(val, locale);
INSERT INTO t1 VALUES('a text value', 'en_US');
-- A view to combine the string and locale from table t1.
CREATE VIEW v1 AS SELECT rowid, fts5_locale(val, locale) AS val FROM t1;
-- An FTS5 table ...
|
|
Query Planning
(queryplanner.html)
1.3. Lookup By Index
... Figure 4 gives a logical view of the Idx1 index.
The "fruit" column is the primary key used to order the elements of the
table and the "rowid" is the secondary key used to break the tie when
two or ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... But process A's view
of the database content is now obsolete because process B has
modified the database file after process A read from it. Hence
process A gets an SQLITE_BUSY_SNAPSHOT error.
(518) SQLITE_LOCKED_VTAB
The SQLITE_LOCKED_VTAB result code is ...
|
Page generated by FTS5 in about 100.49 ms.