SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen()
And it is,
a. Single user
b. File based
c. Cross Platform (can be used across multiple platforms)
d. ANSI based C library i.e., pure C API.
SQLite tools:
- SQLite Manager
- sqlite3 command line utility
Creating the DB through command line:
$ sqlite3 Example.database
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
After successful creation of database, the sqlite prompt gets opened and we can create tables.
For the SQL queries syntax, please refer http://www.sqlite.org/
And it is,
a. Single user
b. File based
c. Cross Platform (can be used across multiple platforms)
d. ANSI based C library i.e., pure C API.
SQLite tools:
- SQLite Manager
- sqlite3 command line utility
Creating the DB through command line:
$ sqlite3 Example.database
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
.help for more commands
.quit to quit from the sqlite prompt
After successful creation of database, the sqlite prompt gets opened and we can create tables.
For the SQL queries syntax, please refer http://www.sqlite.org/