Free portable database

database portability portable-applications
drizzt picture drizzt · Feb 17, 2009 · Viewed 28.2k times · Source

Hi I am developing desktop portable free application and I`m looking for portable database:

  • free
  • without install
  • up to 20K records
  • standalone application
  • supports encryption (optional)
  • SQL92 spec

thanks for advice

can you write some advantages and disadvangtages?

Answer

Adam Davis picture Adam Davis · Feb 17, 2009

SQLite:

self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

-Adam

Related questions

A step-up from TiddlyWiki that is still 100% portable?

TiddlyWiki is a great idea, brilliantly implemented. I'm using it as a portable personal "knowledge manager," and these are the prize virtues: It travels on my USB flash memory stick and runs on any computer, regardless of operating system No …

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More