The Sqliteman Handbook

Petr Vanek

1.1

This documentation is released under GNU Free Documentation License. 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
Create Table
Alter Table
Steps to alter table
Import Table Data
Populate Table
Column Settings
View related dialogs
Create Index
Constraint Triggers
Attached Databases
Schema Browser
Pragma Editor
SQL Editor
Data Viewer
Display Types
Data Editor
Advanced Editor
Fetching the data
Export Data
Supported Formats
8. Questions and Answers
Known Issues
9. Credits and License
Contributors
Translations
Logo and the main icon
Icons
Licenses
A. Installation
How to obtain Sqliteman
MS Windows
Linux
Mac OS X
Other UNIXes
Source Code
Requirements
Compilation and Installation
Configuration

List of Examples

7.1. Full Alter Table Example
7.2. Date to String