Introduction to SQLite Database

SQLite is a file database, unlike mysql,oracle and other databases have a lot of processes, many languages bullet-in into their own modules, Python, PHP, Ruby Support, As a small app or larger software does not need to connect to the database on the network is a good choice, some Linux hosts will also initially install SQLite.

The simplest example code is given below:

Import sqlite3conn = Sqlite3.connect (' test.db ') cur = conn.cursor () cur.execute (' Select COUNT (*) from tab_test ') rs = cur.f Etchone () Count = Rs[0]print "Records count:", Count

Reference articles

http://www.sqlite.org/official website

http://www.sqlite.org/cli.html shell command

Http://blog.sina.com.cn/s/blog_3fc8570201000d6w.html

This article is from the "method is more than a problem" blog, please be sure to keep this source http://xubcing.blog.51cto.com/3502962/1537518