About SQLite Basics

1. What is SQLite? Introduction to SQLite

SQLite is an in-process library that is a lightweight, self-contained, server-free, non-configurable, transactional SQL database engine. Like his other databases, SQLite engine is not a standalone process that can be statically or dynamically connected by application requirements. SQLite can access its storage files directly.

SQLite is an open source, embedded relational database. It is characterized by its high portability, ease of use, compact structure, high efficiency and reliability. Unlike other database management systems, SQLite is very simple to install and run, in most cases-just make sure that sqlite binaries exist to start creating, connecting, and using the database. If you are looking for an embedded database project or solution, SQLite is definitely worth considering.

2. Why you should use SQLite:

Mainly by the following reasons:

1: A system that does not require a separate server to do or operate (because it does not require a server);

2: No Configuration required (no installation and management);

3: A complete SQLite database is stored in a single cross-platform disk file

The 4:sqlite is lightweight and very small (less than 400KB when fully configured, with optional features less than 250KB when configured);

5: No external dependence (self-sufficiency) is required;

6: Transactional compatibility, allowing access from multiple threads or thread-safe angles

7:sqlite Query Language Support SQL92 (SQL2) function (as long as you know the common database query statements, SQLite on the production of the statement will be no problem---> However, some features are not supported. But it is enough for use);

8: Provides a simple and easy-to-use API.

9: Run across platforms (Unix,mac Android,ios, Windows, WinCE).

3, SQLite Installation:

If the operating system is window, you can download SQLite at this address.

Download the sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip compressed files.

Unzip the above two compressed files, will get Sqlite3.def, Sqlite3.dll and Sqlite3.exe files.

1: Here we can open the SQLite execution file via the Window command line.

Enter CMD at the command line, and then run as Administrator

:

2: We can also open the SQLite3.exe file directly

:

You can get help instructions by using.

4, SQLite additions and deletions to change:

First create a database:

Create a table as follows

The following several sqlite several sites:

Http://www.sqlite.org/SQLite official website.

Http://www.php.net/manual/en/book.sqlite3.php SQLite provides a support website for PHP.

HTTPS://BITBUCKET.ORG/XERIAL/SQLITE-JDBC is a library for accessing and creating SQLite database files in Java

The https://docs.python.org/2/library/sqlite3.html sqlite3 python module, which provides a SQL interface that is compatible with the DB-API 2.0 specification.

The Http://search.cpan.org/~msergeant/DBD-SQLite-0.31/SQLite Perl driver driver is used with the Perl DBI module.

The Http://search.cpan.org/~timb/DBI/Perl DBI module provides a common interface for any database, including SQLite.

About SQLite Basics