The Sqliteman Handbook

Petr Vanek and Richard Parkins

Release 1.8.1

This documentation is released under GNU Free Documentation Licence. See Credits for more.

Abstract

Sqliteman is the best developer's and/or admin's GUI tool for Sqlite3 in the world. No joking here (or just a bit only) – it contains the most complete feature set of all tools available.


Table of Contents

1. Introduction
Sqliteman Online
2. Sqlite Specific Issues
3. Start the Application
Usage in the command line
databasefile
options
4. The First Overview
5. Sqliteman Main Window
6. Sqliteman Menu Structure
The File Menu
The Context Menu
The Database Menu
The System Menu
The Help Menu
7. Features and Dialogs
Preferences
Look and Feel
Data Display
SQL Editor
Extension Manager
User defined functions
Auto Commit and Transaction Pending modes
Create Table
Alter Table
Steps to alter table
Import Table Data
Populate Table
Column Settings
Create View
Create Index
Constraint Triggers
Attaching Databases
Schema Browser
Pragma Editor
Query Builder
SQL Editor
Find Dialog
Data Viewer
Display Types
Data Editor
Multiline Editor
Fetching the data
Export Data
Supported Formats
8. Questions and Answers
Known Issues
9. Credits and Licence
Contributors
Translations
Logo and the main icon
Icons
Licences
A. Installation
How to obtain Sqliteman
MS Windows
Linux
Mac OS X
Other UNIXes
Source Code
Requirements
Compilation and Installation
Configuration
B. Default values

List of Examples

7.1. Full Alter Table Example
7.2. Date to String