SQLite is a lightweight database that adheres to the acid-based relational database management system, which is contained in a relatively small C library. It is the public domain project established by D.richardhipp. It is designed to be embedded, and has been used in many embedded products, it occupies a very low resource, in the embedded device, may only need hundreds of K of memory is enough. It can support Windows/linux/unix and so on mainstream operating system, and can be combined with many programming languages, such as TCL, C #, PHP, Java, and ODBC interface, also compared to MySQL, PostgreSQL, the two open source world-renowned database management system, is processing faster than they do. The first alpha version of SQLite was born in May 2000. To 2015 has been 15 years, SQLite also ushered in a version of SQLite 3 has been released.
1. Acid transaction [1] 2. 0 Configuration – No installation and management configuration required 3. A complete database stored in a single disk file 4. database files can be freely shared between machines in different byte order 5. Support database size to 2TB6. Small enough, roughly 130,000 lines C code, 4.43M7. 8 faster than some popular databases in most common database operations. Simple, easy API9. Contains TCL bindings, while supporting bindings for other languages via wrapper 10. Good annotated source code, and has more than 90% test coverage of 11. Independent: No additional Reliance 12. The source is completely open source and you can use it for any purpose, including selling it 13. Support for a variety of development languages, C, C + +, PHP, Perl, Java, C#,python, Ruby, etc. It also supports transaction processing functions and so on. Some people say that it is like Microsoft Access, which sometimes feels a bit like it, but in fact they differ greatly. For example, SQLite supports cross-platform, easy to use, and can create databases directly in many languages, rather than requiring office support like access. If you are a very small application, or if you want to do embedded development, there is no suitable database system, then you can consider using SQLite. To October 17, 2013 the latest version is 3.8.1. Source code and documentation can be obtained from the above. At the same time because the database structure is simple, the system source code is not many, also suitable for the study of database system development professionals. [1] sqlite can also be used as a desktop database, the following is a third-party SQLite GUI software [1] . For example: Sqliteman, a SQLite client developed using QT, supports multi-lingual, cross-platform. Sqlitespy Lightweight SQLite client, free, single file, compact interface design, very stable, relatively few functions, create tables and add data are required SQL statements, as a data browsing and modification tools excellent. SQLite Manager, the SQLite client [1] provided in the form of Firefox extensions. SQLite Database Browser, a graphical client to access SQLite Databases[1] sqlpro SQL client, another graphical client To work with SQLite databases.
SQLite a lightweight database
