Introduction to "SQLite"

Introduction to "SQLite"

I. Features: Small and lean

1. Lightweight: Low Resource usage

2. Embedded: No installation required, direct reference is available

3. Support SQL syntax, most compatible with SQL Server syntax, low learning cost

4. Performance: Enough to meet small applications

5. Open source, free

Two. Disadvantages

1. The open source version cannot encrypt the database. If you need encryption, you can only encrypt data before you go to storage, or find third-party components

Three. Download

1. Official website: http://www.sqlite.org/

2.. Net Class Library: Http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

3. Note that different system environments need to download the corresponding version of the DLL, the general download Win32 version is compatible

Four. Tools

1. SQLite database Browser Visual management tool

　

Introduction to "SQLite"