SQLite

  • Import data into/from SQLite with ease.

    Great news Visual Importer STD supports now SQLite, more products to follow

    Lots of "app" developers out there for Android, MeeGo, iPhone, etc and many apps use the lite-weight SQLite.

    About SQLite

    SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format.

    More information about SQLite

  • We are constantly working on optimizing the performance of our ETL software. Typical ETL process is very similar to a river. Narrow parts prevent water from flowing freely. But if there is no water widening narrows parts will not help. The data flow starts with the data reader. So it is important to make it very fast. It is so important to measure performance correctly.  We always use the same table structure and the same file format for testing.  We did spend a lot of time optimizing SQLite data reader and manage to make two times faster

    Latest version Advanced ETL Processor extracts data from SQLite more than 2 times faster

    etl sqlite 

    Advanced ETL Processor Enterprise version 6.3.4.2 does 123,000 records per second and extracts 14mln records in 1 minute and 53 seconds

    transform sqlite data up to two times faster

    Advanced ETL Processor Enterprise version 6.3.4.6 does 364,000 records per second and extracts 14mln records in 38 seconds.

    Download Free Trial Learn More About Our ETL Software

We have 291 guests and 2 members online