Download SQLiteStudio User manual

Contents
1) Installation and running
1.1) Supported platforms
1.2) Installing from sources
1.3) Installing from binaries
2) Basics
2.1) Interface introduction
2.1.a) First start
2.1.b) Main window
2.1.c) The daily routine - step by step
2.1.d) Editing data
2.2) Managing databases
2.3) Editing tables structure
2.4) Exporting data
2.5) Importing data
2.6) SQL editor
2.6.a) Writing and executing SQL query
2.6.b) Executing SQL directly from file
2.7) Indexes, triggers, views
2.8) Configuration dialog
2.8.a) Miscellaneous tab
3) Advanced topics
3.1) Built-in and custom SQL functions
3.1.a) Built-in SQLite functions
3.1.b) Built-in SQLiteStudio functions
3.1.c) Custom SQL functions dialog
3.2) Populating tables
3.3) Converting SQLite database version
3.4) Schema importing
4) Useful utilities and features
4.1) Create similar table
4.2) Select duplicated rows for new unique index
4.3) User-friendly bugs reporting
4.4) Create view from query
4.5) Good to know
4.5.a) Modifying table schema with lots of data in it
4.5.b) Triggers support for SQLite2 and SQLite3 older than 3.6.19
5) Plugins
5.1) Populating plugins
5.1.a) Built-in plugins description
5.1.b) Writing populating plugin
5.2) SQL formatting plugins
5.2.a) Built-in plugins description
5.2.b) Writing formatting plugin
5.3) Exporting plugins
2
4
4
6
7
9
9
9
10
11
18
23
24
26
27
28
28
31
32
34
34
37
37
37
37
38
40
41
42
43
43
44
45
46
47
47
47
48
49
49
50
52
52
52
53