The Sqliteman Handbook
		Next

The Sqliteman Handbook

Petr Vanek and Richard Parkins

<petr@scribus.info> <aleph0hpela-lqs@yahoo.co.uk>

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

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

	index.html	Next
		Chapter 1. Introduction