CrateDB
Reviewedbyfl
📦
CrateDB
Distributed SQL database for high-volume ingest and time-series data analytics.
CrateDB is a distributed SQL database built on a NoSQL foundation that makes it easy to store and analyze massive amounts of data in real-time. CrateDB uses the PostgreSQL wire protocol, so you can use many standard PostgreSQL clients and libraries to interact with it.
Use cases
CrateDB is often used alongside a primary relational database (like the one provided by fortrabbit) to handle high-volume ingest and analytical queries (OLAP), while the primary DB handles transactional workloads (OLTP).
PHP integration
Since CrateDB implements the PostgreSQL wire protocol, you can use the pdo_pgsql driver to connect to it. This allows you to interact with CrateDB using standard PHP PDO functions and PostgreSQL-compatible libraries.
$dsn = 'pgsql:host=crate-cluster.example.com;port=5432;user=crate;password=';
$pdo = new PDO($dsn);