SQLite ist eine relationale Datenbank.
- http://de.wikipedia.org/wiki/SQLite
- http://www.sqlite.org/download.html
- http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption
- http://www.sqlite.org/lockingv3.html#how_to_corrupt How To Corrupt Your Database Files
- http://www.sqlite.org/lang_vacuum.html
- db3-Datenbanken zwischen Windows und Linux binär kopieren
- {SQLite mit Ubuntu}?
- {Uncaught exception 'PDOException' with message 'could not find driver'}?
- {SQL error: database disk image is malformed}?
- {SQLite mit PHP}?
- {Schema einer SQLite-Datenbank}?
Browser für SQLite
Empfehlungen
- Your best defense is to not use SQLite for files on a network filesystem. (http://www.sqlite.org/lockingv3.html#how_to_corrupt)
- You should not create links to SQLite database files. (http://www.sqlite.org/lockingv3.html#how_to_corrupt)
- Keep all databases on the same disk volume and/or remount disks using exactly the same names after a power failure. (http://www.sqlite.org/lockingv3.html#how_to_corrupt)
sqlite3.exe
- Aufruf
$ sqlite3 file.db3
- Shellcommands (mit Punkt am Beginn)
.tables %
.quit oder .q
.help
.dump ?TABLE? - SQL-Commands (mit Strichpunkt am Ende)
PRAGMA integrity_check;
PRAGMA quick_check; - Commands
sqlite2 file2.db .dump | sqlite3 file3.db3
echo ".dump" | sqlite3 old.db | sqlite3 new.db
sqlite3 xx.db3 < cmd.sql
sqlite3 records.db3 .schema % > file.txt
sqlite3 newsfeed.db .dump > newsfeed.sql
sqlite3 newsfeed.db < newsfeed.sql
SQLite3-SQL
-
select count(*) from table;
- Kommentar: --
- vacuum;
Diverses
- sqlite_udf_decode_binary()
- sqlite_udf_encode_binary()
Chained queries
-
SELECT * FROM table1; SELECT * FROM table2; SELECT * FROM table3;