Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Benefits of SQLite As A File Format
(aff_short.html)
... The current page is a brief summary of why SQLite makes
a good application file format. The topic is considered at greater
detail in a separate technical note.)
SQLite has been used with great success as the on-disk file ...
|
|
Using SQLite In Multi-Threaded Applications
(threadsafe.html)
1. Overview
... In this mode, all mutexes are disabled and SQLite is unsafe to use in
more than a single thread at once.
Multi-thread.
In this mode, SQLite can be safely used by multiple threads provided that
no single database connection ...
|
|
Why Is SQLite Coded In C
(whyc.html)
1. C Is Best
... Since its inception on 2000-05-29, SQLite has been implemented in generic C.
C was and continues to be the best language for implementing a software
library like SQLite. There are no plans to recode SQLite in any other ...
|
|
SQLite In 5 Minutes Or Less
(quickstart.html)
Here is what you do to start experimenting with SQLite without having
to do a lot of tedious reading and configuration:
Download The Code
Get a copy of the prebuilt binaries for your machine, or get a copy
of the ...
|
|
SQLite Keywords
(lang_keywords.html)
... This quoting mechanism
is used by MySQL and is included in SQLite for
compatibility.
For resilience when confronted with historical SQL statements, SQLite
will sometimes bend the quoting rules above:
If a keyword in single
quotes (ex: 'key' or 'glob ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
SQLite Consortium Agreement
This SQLite Consortium Agreement ("Agreement") is made and
entered into as of the _____ day of ______________, 2007 ("Effective Date")
by and between ___________________ (the "Company"), and
Hipp, Wyrick & Company, Inc., a Georgia Corporation with
headquarters at ...
|
|
Distinctive Features Of SQLite
(different.html)
Distinctive Features Of SQLite
This page highlights some of the characteristics of SQLite that are
unusual and which make SQLite different from many other SQL
database engines.
Zero-Configuration
SQLite does not need to be "installed" before it is used ...
|
|
SQLite Database Speed Comparison
(speed.html)
... Two separate time values are reported for SQLite.
The first value is for SQLite in its default configuration with
full disk synchronization turned on. With synchronization turned
on, SQLite executes
an fsync() system call (or the equivalent) at key points ...
|
|
How SQLite Works
(howitworks.html)
1. Background
... One would expect that a
high-level interface such as SQLite would impose a run-time penalty.
And, theoretically, that is correct. But in practice, SQL-based
systems such as SQLite do so many behind-the-scenes optimizations
that an ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
SQLite is not directly comparable to client/server SQL database engines such
as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to
solve a different problem.
Client/server SQL database engines strive to implement a shared repository
of ...
|
Page generated by FTS5 in about 746.10 ms.