Urgent.News

What's breaking now, across thousands of outlets.

Tech

I Built My Own Database From Scratch — Meet CleaveDB

I Built My Own Database From Scratch — Meet CleaveDB I've been building something I've wanted to experiment with for a while: CleaveDB . CleaveDB is a hybrid relational-document graph database built with Python, Rust, and C++ SIMD , with its own query language, graph relationships, and built-in semantic search. The idea started with a simple question: What if relational data, documents, graphs,…

I've been working on an innovative database project called CleaveDB, an experiment in combining relational, document, graph, and semantic capabilities into a single system. CleaveDB is built using Python, Rust, and C++ with special optimizations for performance.

What sets CleaveDB apart is its unique query language, CleaveQL, which allows users to seamlessly work with relational data, documents, graphs, and semantic search. For example, users can insert data using a simple "POUR" command, and then query it using "SCOOP".

CleaveDB also supports graph-style relationships called "Bonds", enabling unlimited depth and multi-hop traversals with natural language queries. Additionally, semantic search is available, allowing for meaning-based searches rather than just keyword searches.

Under the hood, CleaveDB is not built on top of existing database engines. The storage layer is being created from scratch using Rust, with C++ SIMD optimizations for critical performance operations. The project also includes B+Tree storage, WAL and transactions, multi-tenant isolation, authentication, Python bindings, and various interfaces like HTTP, WebSocket, and TCP.

Although CleaveDB is still in a very early stage, building these components from scratch has been a fascinating learning experience. While there are already many excellent databases available, such as PostgreSQL, MongoDB, Redis, and Neo4j, CleaveDB aims to combine their best features in a new way. If you're interested in databases, Rust, storage engines, graph databases, or just curious about how a database is built from the ground up, I'd welcome your feedback and ideas.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in Tech

Comparing GitHub HTTPS ref discovery with HTTP/1.1

I built gitclone-doctor to compare Git's selected HTTPS transport with HTTP/1.1 for a public GitHub repository. It runs git ls-remote URL HEAD against the target with the selected settings and…

  • gitclone-doctor tool compares HTTPS transport protocols with HTTP/1.1.
  • Demonstrates controlled local environment with deliberate 403 error for target URL over HTTP/2.
  • Reports response protocols and numeric statuses, not raw stderr or trace text.

Six Backup Strategies for NoSQL Databases, and What Really Fails

Seis estrategias de respaldo para bases de datos NoSQL, y qué falla de verdad No uso MS SQL Server: el enunciado lo excluye y, además, el problema que quiero estudiar es el de los motores NoSQL, donde…

  • MongoDB uses mongodump for logical backup, creating compressed BSON files for collections.
  • Redis employs RDB dump, generating a binary file of the entire database for restoration.
  • Neo4j creates a binary dump file (.dump) containing the entire graph database for backup.

A threshold is a policy, not a number

A threshold is a policy, not a number Somewhere in a payments codebase there is a line that says: approve automatically when confidence is above 0.8. Nobody remembers the afternoon it was written.

  • The 0.8 confidence threshold in payments codebases determines automatic refunds or human review.
  • The origin of the 0.8 value is unclear, stemming from various unrelated sources.
  • Setting the threshold improperly can cause irreversible damage or hidden costs for the business.

Add an FAQ bot and appointment booking to any website with 3 API calls

Most small-business sites need the same two things: answer the five questions everyone asks ("what are your hours?", "how much is…?") and let people book.

  • Add FAQ bot and booking to website via 3 API calls
  • Use CallChatSyn API with free first 1,000 businesses
  • Implement widget with 30 lines JavaScript code

More from Sunday 4 October →