Database

1. SQLite

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. 

"SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.

Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity." ----------- from "https://www.sqlite.org/whentouse.html"

2. Installation

　My system is Ubuntu 14.04

　$sudo apt-get install sqlite3 libsqlite3-dev

3. Enter/terminate SQLite from command line(a program named sqlite3 will be executed)

  $ sqlite3 hello

  $ ctrl-D

  $ Ctrl-C    will stop a long-running SQL statement

  each SQL statement should be ending with a semicolon(;)

4. dot-commands: commands that starts with a dot

    $ .help    will show all the supported dot-commands 

5. writting results to a file