fatal error: sqlite3.h: No such file or directory

$ sudo apt-get install libsqlite3-dev

References :
compilation - fatal error: sqlite3.h: No such file or directory - Stack Overflow 

Yii CDbConnection failed to open the DB connection.

Yii 預設使用 SQLite Database，PHP 需要安裝函式庫

PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver' in /var/www/demos/blog/protected/data/dbgen.php:7 

# apt-get install sqlite php5-sqlites
# /etc/init.d/apache2 restart

fatal error: sqlite3.h: No such file or directory

# apt-get install libsqlite3-dev

C# with SQLite

進入 網站 往下卷，下載合適的 SQLite 函式庫，安裝


Visual Studio :
開啟專案後，方案總管 -> 參考 -> 加入參考 ... -> 瀏覽 -> C:\Program Files\System.Data.SQLite\2010\bin\System.Data.SQLite.dll


程式碼參考 :
Tigran's Blog » Getting started with SQLite in C#
Using SQLite With C# - C# Tutorials | Dream.In.Code

SQLite 查詢 table name

$ sqlite3 xxx.db
$ sqlite > select * from sqlite_master;
type =
name =
tal_name =
rootpage =
sql =
$ sqlite > select * from TABLE;