SQLite - envobi

The new 0.38.0 release brings enhanced database support across all database providers, for both on-premises and cloud deployments.

Improved GetTableColumnsAsync(String) and GetTableTypeAsync(String), which also helps AdbInsertTarget<TInputError> and AdbTableNonQueryWorker:
- MariaDB™ and MySql™:
  - Fixed quoting bug.
- MySql™:
  - Fixed table metadata bug for 4GB column types longblob and longtext.
- PostgreSQL®:
  - Added support for temporary tables and PostgreSQL schema search_path.
  - Added support for BitArray to bit varying type mapping (in addition to the existing varbit mapping).
  - Fixed bug in GetTableColumnsAsync(String) overloads when no schema specified.
- SQLite: Added support for views.
- SQL Server®: Improved Precision, Scale, LengthInBytes, and LengthInCharacters column metadata from GetTableColumnsAsync(String) overloads.
AdbExecuteScalarWorker<TResult> converts (with ChangeType(Object, Type)) the worker result if casting fails, thereby handling more data type mismatches.
Verified actionETL on Azure for MariaDB, MySql, PostgreSQL, and Azure SQL Database.

Check out all the actionETL features and try it out today with the Free 30-day Trial!

SQLite is the most used database engine in the world and is now supported by actionETL. With SQLite being a fast and installation free local database in the public domain, it can be a great tool to combine with actionETL.

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.

Category: SQLite

Enhanced Database Support with New actionETL Release

SQLite Support Now Added to actionETL