Boston is moving to the SQLite database in version 7.0. This article explains the reasons why FactEngine believes SQLite is the right database for the job.

NB Boston can run on any database that a connector is made for. So, Boston can run on ORACLE, SQLServer, PostgreSQL etc. Please contact us to make a customer connector for you.

Boston and SQLite

The benefits of SQLite are:

1. SQLite tables can have a primary key with text based columns of variable character length.

      This means that Object Types in Boston can have a name as long as you like;

2. SQLite is open source. Some of our clients prefer open source code and databases;

3. SQLite is trusted and can handle very large data sets;

4. SQLite can be either serverless or configured as Client/Server using various tools:

      a) The standard configuration for SQLite is serverless;
      b) The following solutions make SQLite Client/Server and/or provide other server-side benefits such as replication:

            - Valentina SQLite: Turns SQLite into a Client/Server database: SQLite Database Server (valentina-db.com)
            - cubeSQL: Turns SQLite into a Client/Server database: cubeSQL: A fully featured and high performance relational database management system built on top of the sqlite database engine (sqlabs.com)
            - Lightstream: Replicates SQLite databases server-side: Litestream - Streaming SQLite Replication
            - Cloud based SQLite: An SQLite.org initiative to provide SQLite cloud storage solutions, which may be used as the back end to a Client/Server solution: Cloud Backed SQLite: Cloud Backed SQLite
            - CData Synch: Automated SQLite replication in the cloud: Automated Continuous SQLite Replication to Google Cloud SQL (cdata.com)
            - Cloudflare D1: A cloud-based SQLite: Announcing D1: our first SQL database (cloudflare.com)
            - DBHub.io: Cloud-based SQLite database management: DBHub.io - SQLite storage "in the cloud"

5. Billions of people use SQLite and millions of developers know SQLite;