<h1>OrioleDB: Enhancing PostgreSQL Performance and Scalability</h1>
<p>OrioleDB is a cutting-edge PostgreSQL extension designed to replace the default Heap storage, optimizing both performance and scalability. Built utilizing PostgreSQL’s pluggable storage system, OrioleDB aims to seamlessly integrate with existing PostgreSQL setups to deliver a more streamlined and efficient database experience.</p>
<h2>Key Features</h2>
<p>OrioleDB brings several sophisticated features to the table:</p>
<ul>
<li><strong>Lock-less page access</strong>: Reduces contention and increases concurrency.</li>
<li><strong>MVCC based on an undo log</strong>: Enhances multiversion concurrency control mechanisms.</li>
<li><strong>Copy-on-write checkpoints</strong>: Ensures data consistency and improves durability.</li>
<li><strong>High-performance architecture</strong>: Dramatically improves transaction throughput and reduces I/O operations.</li>
<li><strong>Combines on-disk and in-memory engines</strong>: Enhances efficiency for both disk reads and writes.</li>
</ul>
<h2>Current Status and Usage</h2>
<p>OrioleDB has undergone several development phases, with the Public Alpha and beta7 being notable releases. The Public Alpha release, while showcasing the potential of OrioleDB, comes with several limitations. It is currently restricted to Free organizations, supports only the default B-Tree index type, and does not yet support Supabase Realtime Postgres Changes. Therefore, it is not suitable for production workloads at this stage. Users and testers are encouraged to provide feedback to help refine the extension.</p>
<p>The beta7 release of OrioleDB introduces significant improvements and benchmarks indicate that OrioleDB outperforms standard PostgreSQL, particularly in high data volume scenarios. It leverages modern hardware capabilities, making it a robust choice for intensive data workloads.</p>
<h2>Installation and Contributions</h2>
<p>Users can install OrioleDB by following the detailed guidance available on GitHub and Supabase. The community is encouraged to participate actively in testing and providing feedback to the developers.</p>
<h2>Future Vision</h2>
<p>The roadmap for OrioleDB includes several ambitious goals such as:</p>
<ul>
<li><strong>Decoupled storage and compute</strong>: Aiming for greater flexibility and efficiency.</li>
<li><strong>Open-source serverless PostgreSQL</strong>: Bringing the benefits of serverless architectures to the PostgreSQL ecosystem.</li>
<li><strong>Hybrid workloads with columnar indexes</strong>: Enhancing performance for analytic workloads.</li>
<li><strong>Multi-master replication</strong>: Facilitating high availability and fault tolerance.</li>
</ul>
<p>As development continues, OrioleDB promises to be a transformative addition to the PostgreSQL toolkit, potentially ushering in a new era of database performance and scalability.</p>


Collections

OrioleDB is a PostgreSQL extension designed to optimize performance and scalability by replacing the default Heap storage. Key features include lock-less page access, MVCC based on an undo log, copy-on-write checkpoints, and a high-performance architecture. Currently in beta, it is not ready for production but shows promising benchmarks. Future goals include decoupled storage and compute, serverless PostgreSQL, hybrid workloads, and multi-master replication.