Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Isolation In SQLite
(isolation.html)
... Isolation Between Database Connections
If the same database is being read and written using two different
database connections (two different sqlite3 objects returned by
separate calls to sqlite3_open()) and the two database connections
do not have a shared cache, then ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... Add in an open web browser or two and a few other
desktop apps, and suddenly the disk is whirling and the machine is swapping.
And even having just a single document is a problem when working
on an inexpensive ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... DOC - Word Perfect and Microsoft Office documents
DWG - AutoCAD drawings
PDF - Portable Document Format from Adobe
XLS - Microsoft Excel Spreadsheet
GIT - Git source code repository
EPUB - The Electronic Publication format used by non-Kindle eBooks
ODT - The Open Document format ...
|
|
C API: Create Or Redefine SQL Functions
(c3ref/create_function.html)
sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()
... Without this flag, an attacker might be able to modify the schema of
a database file to include invocations of the function with parameters
chosen by the attacker, which the application will then execute when
the database file is opened ...
|
|
Application-Defined SQL Functions
(appfunc.html)
3. Security Implications
... ALTER TABLE tab1 RENAME TO tab1_real;
CREATE VIEW tab1 AS SELECT * FROM tab1 WHERE system('rm -rf *') IS NOT NULL;
Then, when the application attempts to open the database, register the
system() function, then run an innocent query against the ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1. Recovering (Some) Data From A Corrupt SQLite Database
... For example, hardware malfunctions can damage the database file, or a
rogue process can open the database and overwrite parts of it.
Given a corrupt database file, it is sometimes desirable to try to
salvage as much data from the ...
|
|
Why Is SQLite Coded In C
(whyc.html)
1.3. Low-Dependency
... memcmp()
memcpy()
memmove()
memset()
strcmp()
strlen()
strncmp()
In a more complete build, SQLite also uses library routines like
malloc() and free() and operating system interfaces for opening, reading,
writing, and closing files. But even then, the number ...
|
|
C API: Application Defined Page Cache.
(c3ref/pcache_methods2.html)
struct sqlite3_pcache_methods2
... SQLite will typically create one cache instance for each open database file,
though this is not guaranteed. The
first parameter, szPage, is the size in bytes of the pages that must
be allocated by the cache. szPage will always a ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... 10 Close 0 0
The instruction Close closes a
cursor previously opened as P1 (0, the only open cursor). If P1 ...
|
|
Memory-Mapped I/O
(mmap.html)
... The
mmap_size applies separately to each database file, so the total amount
of process address space that could potentially be used is the mmap_size
times the number of open database files.
To activate memory-mapped I/O, an application can ...
|
Page generated by FTS5 in about 145.16 ms.