First impression of SQLite3

"SQLite is not designed to replace Oracle. It is designed to replace fopen()."

What a clear signal! SQLite's target is not a "enterprise database engine" but a samll, simple but smart database for applications.

Key features

1. Embedded devices and applications
2. Zero-Configuration
3. Single Database File
4. Stable Cross-Platform Database File
5. C/C++ API
6. SQL Compatibility
7. 5 Datatypes In SQLite Version 3: NULL, INTEGER,REAL,TEXT,BLOB
8. License in public domain (total free in product)
   

References

• SQLite Documentation
• Comparison of various databases
• SQLite Datatypes
• C/C++ API Documentation