1.1-point SQLite (1)

1. Why use SQLite?

Because I bought a Surface Pro, only 64G hard disk, since the space is small, usually write code when you want to use a small database, without SQL Server, to several G.

2. Download and install

Go here http://www.sqlite.org/download.html, find Sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip these two compressed files, to look carefully!

Then extract out on the line, will get three files (Sqlite3.def,sqlite3.dll,sqlite3.exe), in the C packing directory to create a folder "SQLite", the extracted three files are placed in this folder.

3. Configure System Variables

If in the Windows7 environment, start-computer-right-"properties"-"Advanced system Settings"-"Advanced"-"Environment variables", find the variable "PATH" in "System variables", double-click Open, drag "variable value" to the end, if there is a semicolon then directly "C: SQLite; " Add to the end, if not the last semicolon to add a semicolon, the purpose is separated from the previous address area. This step is very important to configure, so you can enter the "sqlite3" command in any directory in the cmd window to start SQLite. After successful startup, such as:

1.1-point SQLite (1)