SQLite - easy database without database server

This article describes, how to work with SQL database, if you don't have any database server. Everything you need, is installation of DatAdmin Personal (free edition). DatAdmin has support for embedded database engines SQLite and EffiProz.

Easy creating new database

You can create empty database in few steps:

• Select menu File, New
• Choose SQLite (or EffiProz)
• Choose database name
• Choose "Create new"

After these steps, you are able to create tables, edit data or run SQL queries on your database

Compare of embedded databases

Embedded database is database engine, which is delivered with DatAdmin (it doesn't need database server). You can choose SQLite or EffiProz databases. Third possibility is to choose MS Access database, but you will need Access OLE DB drivers installed on you computer in that case.

SQLite

+ Fast, reliable and easy to use. Is stored on one file.
- Small number of data types. VARCHAR limits is not supported (you could use unlimited TEXT data type instead)
+ Cross-platform
+ Good transaction support
+ Free, Opensource

EffiProz

+ Rich SQL support, lot of data types, triggers, functions, stored procedures
+/- Written in .NET, native .NET database
- Slower opening of bigger databases

MS Access

+ supported by Microsoft and many applications
- needs installed OLE DB drivers
- a bit larger database files

My favorite embedded database is SQLite, but when you like more powerful SQL and you have not large tables, you will probably choose EffiProz. I choose MS Access only where there is no other choice.