OceanBase is a distributed relational database with MySQL compatibility, high availability, horizontal scaling, and hybrid analytics. The post OceanBase – distributed relational database appeared first on LinuxLinks.

OceanBase is a distributed relational database with MySQL compatibility, high availability, horizontal scaling, and hybrid analytics. The post OceanBase – distributed relational database appeared first on LinuxLinks.

Database design tool for relational databases (commercial, 14-day trial)

openGauss is a relational database management system designed for enterprise transactional workloads, particularly applications requiring high concurrency, strong security and reliable data processing. The database incorporates optimisations for multicore processors, memory management and transaction execution. Its architecture includes techniques for reducing contention between concurrent operations and improving performance on systems with non-uniform memory access (NUMA) architectures. openGauss originated from Huawei’s database technology and provides facilities for high availability, transaction recovery and database administration. It also incorporates intelligent management capabilities intended to help administrators identify inefficient queries and optimise database configurations. This is free and open source software. #### Key Features * Relational database management with SQL queries, transactions and concurrency control. * Multicore optimisations reduce lock contention and improve transaction throughput. * NUMA-aware memory allocation helps reduce remote memory access on multiprocessor systems. * Memory-Optimised Table (MOT) engine supports low-latency transactional operations using in-memory data and indexes. * Parallel recovery processes transaction logs concurrently to accelerate recovery operations. * Primary-standby replication and failover capabilities support high availability. * SQL bypass optimisations reduce execution overhead for suitable database operations. * Authentication, access controls, password policies, encrypted connections and auditing protect database access. * SQL diagnostics assist with identifying queries that require performance improvements. * Intelligent parameter tuning uses collected performance information to help optimise database configuration. * SQL execution prediction estimates query execution times using historical performance information. **Website:** **github.com/opengauss-mirror/openGauss-server** **Support:** **Developer:** openGauss community **License:** Mulan Permissive Software License v2.0 openGauss is written in C++. Learn C++ with our recommended **free books** and **free tutorials**. * * * #### Related Software **Relational Databases** --- **MariaDB**| High compatibility with MySQL, ensuring drop-in replacement capability **PostgreSQL**| Award winning Object-relational database management system **MySQL**| Multithreaded, multi-user SQL database management system **SQLite**| Embeddable SQL Database Engine **TiDB**| Cloud-native, distributed SQL database **DuckDB**| In-process SQL OLAP database management system **Turso**| In-process relational database engine **YugabyteDB**| PostgreSQL-compatible distributed SQL database **rqlite**| Distributed database built on SQLite **MonetDB**| High performance relational database system for analytics **Dolt**| Version-controlled SQL database **Firebird**| Relational database offering many ANSI SQL features **H2**| Relational database management system written in Java **HSQLDB**| JDBC interface, client-server version, query tool, grid and more **CUBRID**| Database engine with built-in enterprise grade features **Apache Cloudberry**| Massively parallel processing database **Virtuoso**| Data Management with Web Application Server and Web Services **Apache Derby**| Full-featured relational database implemented entirely in Java Read our verdict in the **software roundup**. * * * LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of **recommended applications** , including alternatives to popular proprietary software. We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our **Linux resources** to discover more. Know a useful free and open source Linux application we haven't covered? **Suggest a program** for inclusion. Has your software been featured on LinuxLinks? Display one of our **Featured on LinuxLinks badges** on your website or GitHub README. ---

OceanBase is a distributed relational database designed to handle transactional processing and analytical queries within a single database system. Originally developed by Ant Group, OceanBase uses a shared-nothing distributed architecture that spreads data and processing across multiple servers. It combines horizontal scalability with strong consistency and fault tolerance, allowing databases to continue operating when individual nodes fail. The database supports MySQL-compatible applications and can handle online transaction processing (OLTP) and online analytical processing (OLAP) workloads without requiring separate database engines. Its architecture is particularly suited to applications that need consistent access to large datasets while supporting high transaction volumes. This is free and open source software. #### Key Features * Distributed relational database with SQL support and MySQL compatibility. * Shared-nothing architecture distributes data and processing across database nodes. * Horizontal scalability allows database capacity to expand by adding nodes to a cluster. * Paxos-based replication provides strong consistency and fault tolerance. * Hybrid transactional and analytical processing (HTAP) supports operational queries and analytical workloads in the same database. * Distributed transactions maintain consistency when operations involve data stored across multiple nodes. * Automatic partition management and data distribution help balance workloads across a cluster. * Multi-tenancy provides logical database environments with independently managed resources. * MySQL-compatible SQL interfaces simplify migration of existing database applications. * High availability and automatic recovery reduce service interruptions following node failures. **Website:** **github.com/oceanbase/oceanbase** **Support:** **Developer:** Ant Group and contributors **License:** Apache License 2.0 OceanBase is written in C++. Learn C++ with our recommended **free books** and **free tutorials**. * * * #### Related Software **Relational Databases** --- **MariaDB**| High compatibility with MySQL, ensuring drop-in replacement capability **PostgreSQL**| Award winning Object-relational database management system **MySQL**| Multithreaded, multi-user SQL database management system **SQLite**| Embeddable SQL Database Engine **TiDB**| Cloud-native, distributed SQL database **DuckDB**| In-process SQL OLAP database management system **Turso**| In-process relational database engine **YugabyteDB**| PostgreSQL-compatible distributed SQL database **rqlite**| Distributed database built on SQLite **MonetDB**| High performance relational database system for analytics **Dolt**| Version-controlled SQL database **Firebird**| Relational database offering many ANSI SQL features **H2**| Relational database management system written in Java **HSQLDB**| JDBC interface, client-server version, query tool, grid and more **CUBRID**| Database engine with built-in enterprise grade features **Apache Cloudberry**| Massively parallel processing database **Virtuoso**| Data Management with Web Application Server and Web Services **Apache Derby**| Full-featured relational database implemented entirely in Java Read our verdict in the **software roundup**. * * * LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of **recommended applications** , including alternatives to popular proprietary software. We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our **Linux resources** to discover more. Know a useful free and open source Linux application we haven't covered? **Suggest a program** for inclusion. Has your software been featured on LinuxLinks? Display one of our **Featured on LinuxLinks badges** on your website or GitHub README. ---

France Relational Database Market is Expected to Grow a Valuation of USD 9,471.00 Million by 2035, Reaching at a CAGR of 12.26% During the Forecast Period 2025 - 2035

TinyDB is a lightweight document-oriented database for applications that need straightforward local storage. It provides a compact database interface without requiring a separate server or external database infrastructure. The database stores records as documents represented by dictionaries. Documents are organised into tables, but unlike relational database tables, they do not require a fixed set of fields. TinyDB normally stores its data in JSON files. This makes the database suitable for scripts, small utilities and applications where records need to be persisted in a format that can also be inspected with a text editor. The software includes a query interface for selecting records using comparisons and logical conditions. Developers can combine queries to retrieve documents matching more complex criteria. TinyDB also supports alternative storage implementations and middleware. These allow developers to change how data is persisted or introduce additional behaviour around database operations. It is intended for relatively small workloads. Applications requiring substantial concurrent access, large datasets or complex transactions are generally better served by a more capable database engine. This is free and open source software. #### Key Features * Schemaless document storage. * JSON-based persistence. * Multiple logical tables within a database. * Document insertion, retrieval, updating and deletion. * Query expressions using field comparisons. * Logical operators for combining query conditions. * Document retrieval by identifier. * In-memory storage backend. * Custom storage implementations. * Middleware for extending storage behaviour. * Query result caching. * Bulk document operations. **Website:** **github.com/msiemens/tinydb** **Support:** **Developer:** Markus Siemens **License:** MIT License TinyDB is written in Python. Learn Python with our recommended **free books** and **free tutorials**. * * * #### Related Software **Document-Oriented Databases** --- **SurrealDB**| Scalable, distributed, collaborative, document-graph database **Couchbase**| Distributed key-value database management system **CouchDB**| Scalable, fault-tolerant, and schema-free written in Erlang **ArangoDB**| Native multi-model database **eXist-db**| Database management system entirely built on XML technology **RethinkDB**| Scalable database built for realtime applications **BaseX**| XML database engine **OrientDB**| Document Database supporting ACID Transactions, SQL and Native Queries **Aerospike**| Key-Value Store and high performance real-time NoSQL (flex-schema) database **RavenDB**| Fully-transactional NoSQL ACID database **FerretDB**| Database proxy that offers an open-source alternative to MongoDB **DocumentDB**| MongoDB-compatible document database engine **Jackrabbit**| Open-source content repository for Java **TerminusDB**| Knowledge graph and document store **Kinto**| Minimalist JSON storage service **CrateDB**| Distributed SQL database management Read our verdict in the **software roundup**. * * * LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of **recommended applications** , including alternatives to popular proprietary software. We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our **Linux resources** to discover more. Know a useful free and open source Linux application we haven't covered? **Suggest a program** for inclusion. Has your software been featured on LinuxLinks? Display one of our **Featured on LinuxLinks badges** on your website or GitHub README. ---

PolarDB-X is a distributed SQL database designed to support high concurrency, large datasets and complex database workloads. Developed by Alibaba, it combines relational database functionality with a distributed architecture that allows data to be partitioned across multiple storage nodes. The database separates computing from storage and uses a shared-nothing architecture. Its SQL processing layer coordinates queries and transactions across the distributed system while presenting a MySQL-compatible interface to applications. PolarDB-X supports transactional and analytical workloads through a combination of distributed transaction processing and massively parallel query execution. The system comprises several components, including compute nodes, data nodes, global metadata services and change data capture facilities. The PolarDB-X SQL repository contains the compute-node component. This is free and open source software. #### Key Features * Distributed SQL database with horizontal scalability through hash and range-based data sharding. * MySQL protocol compatibility supports existing MySQL clients, tools and much of the SQL dialect. * Distributed transactions use multiversion concurrency control (MVCC), timestamp ordering and two-phase commit. * Hybrid transactional and analytical processing (HTAP) combines OLTP operations with analytical queries. * Massively parallel processing (MPP) distributes analytical query execution across multiple nodes. * Compute nodes handle SQL parsing, optimisation, execution and distributed query routing. * Global metadata services maintain consistent schema information, statistics and transaction timestamps. * Change data capture provides MySQL-compatible binary logs and replication interfaces. * Multi-Paxos replication supports strongly consistent data storage and high availability. * Additional capabilities include global secondary indexes, SQL concurrency control, transparent data encryption and flashback queries. **Website:** **github.com/polardb/polardbx-sql** **Support:** **Developer:** Alibaba Cloud **License:** Apache License 2.0 PolarDB-X is written in Java. Learn Java with our recommended **free books** and **free tutorials**. * * * #### Related Software **Relational Databases** --- **MariaDB**| High compatibility with MySQL, ensuring drop-in replacement capability **PostgreSQL**| Award winning Object-relational database management system **MySQL**| Multithreaded, multi-user SQL database management system **SQLite**| Embeddable SQL Database Engine **TiDB**| Cloud-native, distributed SQL database **DuckDB**| In-process SQL OLAP database management system **Turso**| In-process relational database engine **YugabyteDB**| PostgreSQL-compatible distributed SQL database **rqlite**| Distributed database built on SQLite **MonetDB**| High performance relational database system for analytics **Dolt**| Version-controlled SQL database **Firebird**| Relational database offering many ANSI SQL features **H2**| Relational database management system written in Java **HSQLDB**| JDBC interface, client-server version, query tool, grid and more **CUBRID**| Database engine with built-in enterprise grade features **Apache Cloudberry**| Massively parallel processing database **Virtuoso**| Data Management with Web Application Server and Web Services **Apache Derby**| Full-featured relational database implemented entirely in Java Read our verdict in the **software roundup**. * * * LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of **recommended applications** , including alternatives to popular proprietary software. We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our **Linux resources** to discover more. Know a useful free and open source Linux application we haven't covered? **Suggest a program** for inclusion. Has your software been featured on LinuxLinks? Display one of our **Featured on LinuxLinks badges** on your website or GitHub README. ---

The building blocks of relational databases: tables, columns, rows, primary and foreign keys, and ACID transaction properties, with examples.

Solidbase is a generic migration tool for relational databases and other resources, built as an alternative to Liquibase. It provides version control and automated schema management capabilities for database changes across multiple RDBMS platforms.

Background: Medical school curricula are managed through fragmented, static tools that prevent faculty and curriculum committees from seeing a unified view of content scope, sequence, and licensing examination alignment. Governance relies on manual reporting that is neither timely nor consistent, and no widely adopted platform incorporates a generative AI agent that queries a relational curriculum database to produce tailored, on-demand reports. Objective: This study aimed to design, implement, and evaluate a 4-phase, AI-integrated relational curriculum mapping framework providing faculty self-directed curriculum search; cross-course alignment reports classifying content as redundant, complementary, or a gap, with recommendations; and alignment with United States Medical Licensing Examination (USMLE) content and accreditation requirements. Methods: We implemented the framework during academic year 2025-2026. It captures session learning objectives (SLOs) annually; maps them to program objectives, course objectives, USMLE codes, Association of American Medical Colleges keywords, and Bloom’s levels using a large language model with expert verification; centralizes verified data in a relational database (Airtable) with faculty read-only search; and uses a second AI agent via an API to generate on-demand reports on scope, sequence, redundancy, gaps, and USMLE alignment across all 16 preclerkship courses and all clinical clerkship rotations. Results: Course directors gained self-directed curriculum access through Airtable Extensions search. Cross-course vertical alignment reports identified redundant, complementary, and gap findings and generated course-level recommendations. An analysis of 2 preclerkship courses identified 50 matched SLO pairs across 3 USMLE pathology domains within minutes. A USMLE Step 1 alignment report across all 16 courses identified a curriculum-wide pathology coverage deficit (42% vs a target of 45%-55%) that was descriptively consistent with institutional performance data (not formally tested). An accreditation query identified all preclerkship and clerkship content on a specified topic and generated Data Collection Instrument-ready documentation within seconds. A medical education #mededu Program Objective coverage analysis across all 9 clinical clerkships, generated within minutes, found documented coverage for 24 of 25 (96%) program objectives and 1 objective with no matching SLO in any clerkship, a gap not previously tracked. In a blinded validation study, 3 independent course directors each coded a 30-SLO sample; agreement with the database (Fleiss κ, 3 raters plus database) was substantial at the exact-code level (κ=0.67, 95% CI 0.55-0.78) and almost perfect at the USMLE domain level (κ=0.94, 95% CI 0.88-1.00). Conclusions: An AI-integrated relational curriculum database with a faculty-facing search interface can convert curriculum governance from a periodic, retrospective activity into a continuous, self-service one, producing alignment and gap analyses within minutes rather than weeks. Workload effects have not been formally measured. Extension to assessment items and prospective correlation with licensing examination outcomes are planned. Trial Registration:

MySQL is a relational database management system. It provides a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL is the most popular open source database, and is the database component of the LAMP software stack. LAMP consists of the Apache web server, MySQL and PHP, the essential building blocks to run a general purpose web server. MySQL is used and championed by many large organizations including Google, Facebook, the BBC, Intel, Sun, SAP, Dell, AMD, Novell, Veritas and many others. With the increasing popularity of MySQL, it is not surprising that developers have written useful tools which help users to monitor, query, administer, troubleshoot, and optimize MySQL databases. To provide an insight into the quality of software that is available, we have compiled a list of 23 useful MySQL tools. Hopefully, there will be something of interest for anyone interested in managing MySQL databases with the minimum of fuss. Here’s our verdict captured in a legendary LinuxLinks-style ratings chart. Only free and open source software is eligible for inclusion. Click the links in the table to learn more about each tool. **MySQL Tools** --- **DBeaver**| Universal database tool **phpMyAdmin**| MySQL web administration tool **NocoDB**| Build databases as spreadsheets **MySQL Workbench**| Complete visual database design tool **mycli**| Command line interface for MySQL, MariaDB, and Percona **gh-ost**| GitHub's Online Schema Migrations for MySQL **Beekeeper Studio**| Cross-platform SQL editor and database manager **usql**| Command-line database client **sqlit**| lazygit of SQL databases **Harlequin**| Easy, fast, and beautiful database client for the terminal **DbGate**| Database manager for MySQL, PostgreSQL, MongoDB **Percona Toolkit**| Essential command-line utilities for MySQL **SQuirreL SQL Client**| Graphical SQL client written in Java **Adminer**| Full-featured tool for managing content in MySQL database **dblab**| Interactive client for PostgreSQL, MySQL, SQLite3, and more **Antares**| SQL client based on Electron.js and Vue.js **XtraBackup**| Backup utility for MySQL **innotop**| Real-time, advanced investigation tool **SQLCheck**| Detects common SQL anti-patterns **Skeema**| Manage MySQL and MariaDB schema changes **Sequeler**| Native Linux SQL client built in Vala and Gtk **orchestrator**| High availability and replication management tool **OmniDB**| Collaborative environment For database management This article has been updated to reflect the changes outlined in our **recent announcement**. LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of **recommended applications** , including alternatives to popular proprietary software. We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our **Linux resources** to discover more. Know a useful free and open source Linux application we haven't covered? **Suggest a program** for inclusion. Has your software been featured on LinuxLinks? Display one of our **Featured on LinuxLinks badges** on your website or GitHub README. ---

LuraDB is a Linux-first, REST-native multi-model database: key-value, JSON documents and slim relational tables in one small process on io_uring.

Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost effectiveness of open-source databases. Aurora has a distributed architecture that replicates a shared storage volume across three Availability Zones to provide a high availability solution with no data loss and failover time measured […]

Amazon Relational Database Service (RDS) for PostgreSQL announces Amazon RDS Extended Support minor versions 13.23-rds.20260819, 12.22-rds.20260820 and 11.22-rds.20260822. Amazon RDS Extended Support provides up to three additional years of fixes for critical Common Vulnerabilities and Exposures (CVE) and bugs beyond a major version's end of standard support date, giving you more time to upgrade to a new major version. You can upgrade your database using Amazon RDS Blue/Green Deployments, in-place upgrade, or restore from a snapshot. Learn more about performing version upgrades in the Amazon RDS for PostgreSQL User Guide. Amazon RDS for PostgreSQL makes it simple to set up, operate, and scale PostgreSQL deployments in the cloud. Create or update a fully managed Amazon RDS database in the Amazon RDS Management Console or by using the AWS Command Line Interface (AWS CLI).