Recent Developer Tools

References and Knowledge base Articles

Easy Way to Use SQLite 2.0

Posted on Feb 15, 2010 12:28:32 PM

Would you like to know how to create embedded SQL database applications using Visual C++ with SQLite? What is SQLite? SQLite is a C library that implements an embeddable SQL database engine.

It is simple, small, fast and reliable. Reliability is a consequence of simplicity. SQLite is a typeless database system. It is in the public domain. Everything about a database is stored in a single file. Databse files can so freely be shared between machines. A database can be up to 2 terabytes in size.

Situations where SQLite is good to use:

  • SLite works well for websites with fewer than 100′000 hits/day.
  • SQLite database require no administration. SQLite is a good choice for devices or services that must work unattended and without human support. SQLite is a good fit for use in cell phones or PDAs.
  • It can be used as a replacement for ad hoc disk files.
  • It is well suited for internal or temporary databases
  • Experienced SQL users can employ the command-line sqlite program to analyze miscellaneous datasets.

Add A Comment