Lightweight SQL database which doesn’t require installation [closed]

by

Depends on what you mean by lightweight. Easy on Ram? Or lighter db file? Or lighter connector to connect to db? Or fewer files over all? I’ll give a comparison of what I know:

                    no of files    cumulative size of files    db size

Firebird 2.5             5                6.82 MB               250 KB

SqlServerCe 4            7                2.08 MB               64 KB

Sqlite 3.7.11.0          1                0.83 MB               15 KB

VistaDb 4.3.3.34         1                1.04 MB               48 KB

no of files - includes the .net connector and excludes the db file

The dbs are of 1 table with 2 columns and 2 rows. Take the db size with a pinch of salt as dbs could grow differently with further use. For instance SqlServerCe though initially was at 64 KB, it didn’t grow at all after adding a few hundred records, while VistaDb grew easily from 48 to 72 to 140 KB. SQLite was the best in that regard which started from the lowest and grew linearly.

Few anecdotes: I had better performance using SqlServerCe with the factory settings which means its the easiest to get kick started without any configuration, while I found Firebird little bit harder to get it started due to lack of online materials. Firebird as I could read had widest standard sql compliance. While VistaDb is written in fully managed C# which means it can be merged with your application’s assembly to have one single file, it seemed slowest to me. Of all, considering performance, ease and size I chose SQLite. SqlServerCe would be my second choice.

In short each has its pluses and minuses. Again, take my rant with a pinch of salt, its just my personal experience.

More Related Contents:

  1. Address standardization within a database
  2. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  3. can we list all tables in msaccess database using sql?
  4. How can I implement SQL INTERSECT and MINUS operations in MS Access
  5. SQL: Using NULL values vs. default values
  6. SQL Data models
  7. How to randomly select rows in SQL?
  8. How can I get column names from a table in Oracle?
  9. single fixed table with multiple columns vs flexible abstract tables
  10. How can I send email from PostgreSQL trigger?
  11. How to design a database for User Defined Fields?
  12. MS Access (MDB) concurrency
  13. How to delete Duplicates in MySQL table
  14. SqlConnection.Close() inside using statement
  15. Row numbers in query result using Microsoft Access
  16. Why does VARCHAR need length specification?
  17. Access – compare two tables and update or insert data in first table
  18. How to Optimize Queries in a Database – The Basics
  19. Know relationships between all the tables of database in SQL Server
  20. Bulk/batch update/upsert in PostgreSQL
  21. Grant privileges for a particular database in PostgreSQL
  22. Does ‘Select’ always order by primary key?
  23. How do I create and query linked database servers in SQL Server?
  24. How do I change db schema to dbo
  25. What is the best way to implement soft deletion?
  26. PostgreSQL how to create a copy of a database or schema?
  27. Historical / auditable database
  28. Postgres: convert single row to multiple rows (unpivot)
  29. How to store a list in a db column
  30. Parameterise table name in .NET/SQL?

Leave a Comment