You might use SQLite as:
- Your main (local) database
- A complement to a traditional database server, e.g. to offload work from an expensive host, and to avoid the network performance overhead
- Temporary SQL processing, e.g. to:
- Reduce memory consumption by performing a large sort using the disk backed SQLite
- Execute queries where the SQL set-based approach is a better fit (and using LINQ is not appropriate) than the dataflow row-by-row approach
actionETL wraps the official SQLite .NET provider – System.Data.SQLite. Check out the details in our SQLite documentation, as well as the full list of supported databases.