Best Free Embedded Database Systems of 2024

MySQL is the most widely used open-source database in the world. MySQL is the most popular open source database for web-based applications. It has been proven to be reliable, performant, and easy-to-use. This database is used by many high-profile web properties, including Facebook, Twitter and YouTube. It is also a popular choice for embedded databases, distributed by thousands ISVs and OEMs.

SQLite is a C language library that implements a small, fast and self-contained SQL database engine. It is highly reliable, compact, efficient, and fully-featured. SQLite is the most widely used database engine in the globe. SQLite is embedded in all mobile phones and computers. It also comes with countless other applications that people use every single day. SQLite is an embedded library that implements a self contained, serverless, zero configuration, transactional SQL database engine. The code for SQLite can be used for commercial and private purposes. SQLite is the most used database in the world, with many high-profile projects and more applications than we can count.

Firebird is a relational data base that supports many ANSI SQL standards. It runs on Linux, Windows, and a range of Unix platforms. Firebird provides high concurrency, high performance and powerful language support for stored procedure and triggers. Since 1981, it has been used in production systems under many names. The Firebird Project is a commercially-independent project consisting of C and C++ programmers, technical advisers, and supporters. It develops and enhances a multi-platform relational data management system that uses the source code released by Inprise Corp (now Borland Software Corp) 25 July 2000.

InterSystems Cache®, a high-performance database, powers transaction processing applications all over the globe. It's used for everything, from mapping a million stars in the Milky Way to processing a trillion equity trades per day to managing smart energy grids. InterSystems has developed Cache, a multi-model (object-relational, key-value), DBMS and application server. InterSystems Cache offers multiple APIs that allow you to work with the same data simultaneously: key/value, relational/object, document, multidimensional, object, object, and object. Data can be managed using SQL, Java, node.js.NET, C++ and Python. Cache also offers an application server that hosts web apps (CSP, REST, SOAP and other types TCP access for Cache data).

ArcadeDB allows you to manage complex models without any compromises. Polyglot Persistence is gone. There is no need to have multiple databases. ArcadeDB Multi-Model databases can store graphs and documents, key values, time series, and key values. Each model is native to the database engine so you don't need to worry about translations slowing down your computer. ArcadeDB's engine was developed with Alien Technology. It can crunch millions upon millions of records per second. ArcadeDB's traversing speed does not depend on the size of the database. It doesn't matter if your database contains a few records or a billion. ArcadeDB can be used as an embedded database on a single server. It can scale up by using Kubernetes to connect multiple servers. It is flexible enough to run on any platform that has a small footprint. Your data is protected. Our unbreakable fully transactional engine ensures durability for mission-critical production database databases. ArcadeDB uses the Raft Consensus Algorithm in order to maintain consistency across multiple servers.

Chroma is an AI-native, open-source embedding system. Chroma provides all the tools needed to embeddings. Chroma is creating the database that learns. You can pick up an issue, create PRs, or join our Discord to let the community know your ideas.

LanceDB is an open-source database for AI that is developer-friendly. LanceDB provides the best foundation for AI applications. From hyperscalable vector searches and advanced retrieval of RAG data to streaming training datasets and interactive explorations of large AI datasets. Installs in seconds, and integrates seamlessly with your existing data and AI tools. LanceDB is an embedded database with native object storage integration (think SQLite, DuckDB), which can be deployed anywhere. It scales down to zero when it's not being used. LanceDB is a powerful tool for rapid prototyping and hyper-scale production. It delivers lightning-fast performance in search, analytics, training, and multimodal AI data. Leading AI companies have indexed petabytes and billions of vectors, as well as text, images, videos, and other data, at a fraction the cost of traditional vector databases. More than just embedding. Filter, select and stream training data straight from object storage in order to keep GPU utilization at a high level.

Apache Phoenix combines the best of both worlds to enable OLTP and operational analysis in Hadoop. This allows for low-latency Hadoop applications. HBase is used as the backing store for Apache Phoenix, which combines the power of SQL and JDBC with ACID transaction support and flexibility of late bound, schema-on read capabilities from the NoSQL realm. Apache Phoenix is fully compatible with other Hadoop tools such as Spark and Hive. It also integrates with Pig, Flume and Map Reduce. Become the trusted Hadoop data platform for OLTP, operational analytics and Hadoop via well-defined APIs. Apache Phoenix compiles your SQL query into a series HBase scans and orchestrates their running to produce regular JDBC results sets. Direct use of HBase API along with coprocessors, custom filters and other tools results in performance of milliseconds or seconds for small queries.

Perst, an object-oriented embedded database (ODBMS) from McObject, is open source and dual licensed. It is available as a Java-only embedded database and a C# version (for Microsoft's.NET Framework). Perst allows developers to store, sort and retrieve objects with minimal memory and storage overhead, while leveraging Java and C#'s object-oriented paradigm. Perst's performance advantage over Java or.NET embedded databases is evident in the TestIndex benchmarks and PolePosition benchmarks. Perst stores data in Java and.NET object, eliminating the need for translations required to store in relational or object-relational database. This increases performance at runtime. Perst is a core program that only has five thousand lines. The small footprint places minimal demands on the system resources.

Free to create, manage, query, and explore Valentina DB and SQLite databases. You can create business reports in Valentina Studio Pro, Valentina Server, or in an application using an Application Developer Kit. Standard backward engineering with forwarding engineering in Valentina Studio Pro Create diagrams from existing databases and reverse engineering. Add new objects to diagrams. SQL queries can be written with color syntax and auto-completion. Define, manage, save favorite queries; access recent queries. Each function has a function browser dictionary. Consoles for errors and warnings. Search, Export result records to CSV, JSON or Excel. Edit multiple properties at once. You can drill down to fields and tables; it is a fast way to search. Create diagrams from existing databases by reverse engineering. Diagrams can be updated with new objects. Manage privileges and users by adding and dropping users and groups.

SAP HANA is an in-memory database with high performance that accelerates data-driven decision-making and actions. It supports all workloads and provides the most advanced analytics on multi-model data on premise and in cloud.

Couchbase, unlike other NoSQL database, provides a multicloud to edge enterprise-class database that offers robust capabilities for business-critical apps on a highly available and scalable platform. Couchbase is a distributed cloud native database that runs on any cloud. It can be managed by the customer or fully managed. Couchbase is built using open standards and combines the best of NoSQL and SQL with the power and familiarity that mainframes and relational databases provide. Couchbase Server is an open-source, multipurpose distributed database. It combines the best of relational databases, such as SQL, ACID transactions, and JSON, with a foundation which is fast and scalable. It is used in many industries for things such as user profiles, dynamic catalogs, GenAI applications, vector search, caching at high speed, and more.

Neo4j's graph platform is designed to help you leverage data and data relationships. Developers can create intelligent applications that use Neo4j to traverse today's interconnected, large datasets in real-time. Neo4j's graph database is powered by a native graph storage engine and processing engine. It provides unique, actionable insights through an intuitive, flexible, and secure database.

Berkeley DB is a set of embedded key-value databases libraries that provide high-performance data management services for applications.

IBM Informix®, a fast and flexible database that can seamlessly integrate SQL, NoSQL/JSON and time series data, is available. Informix's versatility and ease-of-use make it a popular choice for a wide variety of environments, including enterprise data warehouses and individual application development. Informix is also well-suited for embedded data management solutions due to its small footprint and self-managing capabilities.

One tool allows you to operationalize your embeddings. A comprehensive database that provides embedding functionality previously unavailable on multiple platforms is now available to you. Embeddinghub makes it easy to accelerate your machine learning. Embeddings are dense numerical representations of real world objects and relationships. They can be expressed as vectors. They are often created by first defining an unsupervised machine learning problem, also known as a "surrogate issue". Embeddings are intended to capture the semantics from the inputs they were derived. They can then be shared and reused for better learning across machine learning models. This is possible with Embeddinghub in an intuitive and streamlined way.

It is a highly scalable, embedded SQL database that can be accessed from anywhere. It also includes commercial-grade data security, disaster recovery, change synchronization, and data security.