1.1. SQLite tutorial

1.1.1. Who is suitable for this tutorial? ¶

This tutorial helps beginners understand the basics and advanced concepts related to the SQLite database engine.

1.1.2. What you need to know before reading this tutorial: ¶

Before you begin to practice with the various examples provided in this tutorial, you need to understand what a database is, especially RDBMS, and what a computer programming language is.

1.1.3. Compile / execute SQLite programs ¶

If you want to compile / execute SQL programs through SQLite DBMS, but you do not have the relevant settings, you can visit the compileonline.com . You can experience real programming experience on a high-end server with a simple click. This is a completely free online tool.

1.1.4. SQLite function reference manual ¶

This tutorial provides a reference manual for all the important built-in SQLite functions.

SQLite 常用函数

1.1.5. Useful resources for SQLite ¶

This tutorial lists SQLite database websites and books.

1.1.6. Useful websites for SQLite ¶

• SQLite Home Page -the official SQLite website provides the latest SQLite installation, the latest SQLite information, and a complete SQLite tutorial.

• PHP SQLite3 -the website provides full details of PHP support for SQLite 3 databases.

• SQLite JDBC Driver: -SQLite JDBC, developed by Taro L. Saito, is a library for accessing and creating SQLite database files in Java.

• DBD-SQLite-0.31 -the SQLite Perl driver driver is used with the Perl DBI module.

• DBI-1.625 -the Perl DBI module provides a common interface for any database, including SQLite.

• SQLite Python -the sqlite3 python module is written by Gerhard Haring. It provides a SQL interface compatible with the DB-API 2.0 specification.