DB Browser for SQLite

DB Browser for SQLite is a free, open source tool to create, design, and edit SQLite databases. You can downloaded it from sqlitebrowser.org.

Some of its features:

  • Create databases
  • Create, define, modify and delete tables
  • Create, define and delete indexes
  • Browse, edit, add and delete records
  • Import and export tables from/to other formats

Here's what the table definition of the table Countries of database Geo.sqlite looks like:

Defining table Countries

For SQLite, the field type VARCHAR(n) means the same as the type TEXT.
But for Delphi, it's different. In a DBGrid component, Delphi displays the contents of columns of the type VARCHAR(n) as strings, while for the type TEXT it only displays the mention (Memo).
The (50) in VARCHAR(50) is used by Delphi for the length of the field-data and the width of the columns of a TDBGrid.

Table of contents

1. Intro to SQLite
2. Tutorial project
3. SQL statements
4. The WHERE clause
5. Browser for SQLite

Crash Course Delphi  Database tutorials  FAQ  Tips  Source Code  Downloads  Links