Databases

Databases behind my applications, starting with the most recent.

DynamoDB

2015 – present

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. It is a serverless database that can automatically scale up or down to meet the needs of your application. DynamoDB offers a flexible data model, reliable performance, and automatic scaling of throughput capacity. It also provides encryption at rest, point-in-time recovery, and other features to help protect your data.

Firebase

2017 – 2021

Firebase’s Realtime Database is a cloud-hosted, NoSQL JSON data store that lets you build rich, collaborative applications by syncing data in milliseconds across all connected clients. Data is stored as a single, hierarchical JSON tree and updated in real time—any changes made by one client are immediately pushed to every other. SDKs for iOS, Android and web handle offline caching and automatic resynchronization, while granular security rules and Firebase Authentication ensure data is accessed and modified only by authorized users. With built-in scalability, sharding and integration with other Firebase services (Cloud Functions, Analytics, etc.), the Realtime Database simplifies the creation of responsive, data-driven apps without the need to manage your own backend.

BigQuery

2015 – 2021

BigQuery is a cloud-based, fully managed, serverless data warehouse that enables businesses to store, query, and analyze large datasets. It is a petabyte-scale data warehouse that can process up to 20,000 queries per second and is designed to scale with the growth of your business. BigQuery is integrated with Google Cloud Platform services, allowing users to easily access and analyze data from other Google services such as Google Ads, Google Analytics, and Google Cloud Storage. BigQuery also supports a wide range of data formats, including CSV, JSON, and Avro.

Postgres

2012 – 2014

Postgres is an open source object-relational database management system (ORDBMS) developed by the PostgreSQL Global Development Group. It is designed to be extensible, highly reliable, and standards-compliant. Postgres is used for a wide range of applications, including data warehousing, e-commerce, web applications, and more. It supports a wide range of data types, including JSON, XML, and user-defined types. It also provides powerful features such as triggers, stored procedures, and views. Postgres is highly scalable and can handle large amounts of data. It is also highly secure, with built-in authentication and access control.

SQLite

2012 – 2014

SQLite is a lightweight, self-contained, serverless, zero-configuration, transactional SQL database engine. It is the most widely deployed database in the world with over 1 trillion installations. It is used in countless applications, from web browsers to operating systems. It is fast, reliable, and requires minimal setup and maintenance. It supports most of the SQL standard, including transactions, triggers, and views. It is also highly extensible, allowing developers to create custom functions and extensions.

SQL Server

2007 – 2014

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store and manage data in a structured format, allowing users to query and manipulate the data using Structured Query Language (SQL). It is a powerful and reliable platform for data storage and management, and is used by many organizations for mission-critical applications. It is highly scalable and supports a wide range of features, including data replication, security, and high availability.

Oracle

2005 – 2009

Oracle Database is a relational database management system (RDBMS) developed by Oracle Corporation. It is the world's most popular database and is used by many of the world's largest organizations to store and manage their data. Oracle Database is a powerful, reliable, and secure platform for running applications and managing data. It provides a comprehensive set of features and tools to help organizations store, manage, and analyze their data. Oracle Database is available in a variety of editions, including Enterprise Edition, Standard Edition, and Express Edition.

Access

2007 – 2008

The Access database is a relational database management system (RDBMS) developed by Microsoft. It is used to store and manage data in a structured format, allowing users to quickly and easily access and manipulate data. It is designed to be user-friendly and can be used to create forms, reports, and queries. It also supports data import and export, as well as data validation and security.

Pervasive

1999 – 2005

Pervasive is a relational database management system (RDBMS) that is designed to provide high performance, scalability, and reliability for mission-critical applications. It is a cost-effective solution for businesses of all sizes, and is used to store and manage data in a secure and reliable manner. Pervasive is optimized for both online transaction processing (OLTP) and online analytical processing (OLAP) applications, and is compatible with a variety of operating systems, including Windows, Linux, and Mac OS X. It also supports a wide range of programming languages, including SQL, Java, and C#.

Btrieve

1999 – 2004

Btrieve is a database management system (DBMS) developed by Pervasive Software. It is a high-performance, reliable, and cost-effective database solution for small to medium-sized businesses. Btrieve is a relational database that supports multiple data types, including text, numeric, and binary. It is designed to be easy to use and provides a wide range of features, including data encryption, transaction logging, and replication. Btrieve is also highly scalable, allowing it to be used in a variety of applications, from single-user systems to large enterprise networks.