Coding & Development

UnQLite is an embedded NoSQL, transactional database engine implemented as a self-contained, serverless, zero-configuration C library. It functions as both a document store, similar to MongoDB or Redis, and a standard Key/Value store, akin to BerkeleyDB or LevelDB. Unlike many other NoSQL databases, UnQLite operates without a separate server process, reading and writing directly to ordinary disk files. A complete database, including multiple collections, is stored in a single, cross-platform disk file. It supports ACID transactions, offers a simple API, and is designed for high performance with O(1) lookup. UnQLite is thread-safe, reentrant, and suitable for embedded devices due to its minimal external dependencies.

BuntDB is a low-level, in-memory key/value store written entirely in Go, designed for projects prioritizing speed over data size. It offers ACID compliance and persistence to disk through an append-only file format. A key differentiator is its robust support for custom indexing, including spatial indexing for up to 20 dimensions, which is particularly useful for geospatial applications. It also allows for indexing fields within JSON documents using GJSON and supports multi-value indexes, similar to multi-column indexes in SQL databases. BuntDB provides flexible data iteration capabilities, built-in types for common data indexing, and an option to evict old items with TTL expiration.

Graphify is a powerful data visualization tool that allows users to instantly generate a wide range of diagram types directly from JSON text input. It supports diverse diagramming needs, including class diagrams for system design, entity-relationship (ER) diagrams for database schema visualization, radial diagrams, concept maps, timeline diagrams, and network diagrams. Users can select their preferred output format between PNG and SVG, ensuring high-quality, styled images. This tool simplifies the process of visualizing complex data structures and relationships, making it accessible for various analytical and design tasks without requiring manual drawing or complex software.

SQL Translator is a free and open-source tool designed to bridge the gap between natural language and SQL. It allows users to input natural language queries and receive corresponding SQL code, or input SQL code and get a human-readable natural language translation. This makes it easier for individuals who are not SQL experts to understand and interact with relational databases. Key features include dark mode, a lowercase/uppercase toggle for SQL output, copy-to-clipboard functionality, SQL syntax highlighting, schema awareness (beta), and query history. The project is easy to set up locally using npm or Docker Compose, requiring only an OpenAI API key. It aims to simplify database management and querying for a broad audience.

SugarDB is a highly configurable, distributed, in-memory data store and cache implemented in Go. It serves as an embeddable library or an independent service, providing a rich set of data structures like Lists, Sets, Sorted Sets, and Hashes. Key features include TLS/mTLS support, replication using the RAFT algorithm for fault tolerance, and an ACL layer for authentication and authorization. SugarDB also offers a persistence layer with Append-Only files and snapshots for data recovery, along with key eviction policies and multi-database support. Its compatibility with existing Redis clients via RESP makes it a versatile solution for developers seeking a robust, in-memory data management system.

reindexer is an embeddable, in-memory, document-oriented database designed for high-performance data retrieval and manipulation. It offers a high-level query builder interface, enabling efficient and complex searches. The tool is suitable for applications requiring quick data access and robust search functionalities, making it ideal for developers and organizations focused on optimizing their data management workflows. Its in-memory nature ensures rapid response times, crucial for demanding applications.

sled is an embedded database designed for applications needing local data persistence, offering a simple API akin to a threadsafe BTreeMap. It supports serializable (ACID) transactions for atomic operations across multiple keys and keyspaces, along with fully atomic single-key operations including compare and swap. Key features include zero-copy reads, write batches, subscription to key prefix changes, and multiple keyspaces. sled utilizes modern B-tree techniques like prefix encoding and suffix truncation to optimize storage costs for long keys, making it efficient for various data structures. It's built with a CPU-scalable, lock-free implementation and flash-optimized log-structured storage, ensuring high performance and durability with automatic fsyncs.

Trilogy is a high-performance client library specifically designed for MySQL-compatible database servers, emphasizing flexibility and ease of embedding into various applications. It is currently in production use on github.com, showcasing its robustness and reliability. The library supports essential functionalities of the MySQL text protocol, including handshake, password authentication, query, ping, and quit commands. Furthermore, it offers support for prepared statements using the binary protocol. Trilogy provides a low-level protocol API that is completely decoupled from IO, alongside both non-blocking and blocking client APIs. It boasts minimal dependencies, requiring only POSIX, the C standard library, and OpenSSL, making it highly portable and efficient.

pglite-fusion is an open-source PostgreSQL extension that allows developers to embed an entire SQLite database directly into a PostgreSQL table column. This innovative approach simplifies multitenancy by providing each tenant with their own isolated SQLite database, managed within a single PostgreSQL instance. Key features include functions to create, query, execute SQL statements, and manage SQLite databases as binary objects within PostgreSQL. It supports various PostgreSQL versions and offers API functions for tasks like initializing databases with schemas, extracting data types, listing tables, and importing/exporting SQLite files. This tool is ideal for developers seeking flexible and efficient data management solutions for multi-tenant applications.

Tasting Party is a free, web-based application designed to host social blind tasting events for various categories like wine, bourbon, beer, cocktails, and even non-alcoholic items like pizza and chocolate. Users can set up a tasting in under a minute, add items, and share a party code or QR with guests. Guests then rate each item, pick flavors, and guess prices directly from their phones without needing to download an app or sign up. The platform culminates in "The Big Reveal," where identities are disclosed, winners are crowned, and themed awards like "Smooth Operator" are given. It supports 16 categories, each with tailored ratings, aromas, and awards, making it a versatile tool for any social gathering.

RediSearch is a powerful, open-source module designed to enhance Redis with advanced querying and indexing capabilities. It provides secondary indexing, full-text search, vector similarity search, and aggregations, making Redis a more robust data platform for complex search operations. Starting with Redis 8, RediSearch is an integral part of Redis, eliminating the need for separate installation. It supports incremental indexing, document ranking with BM25, complex boolean queries, prefix and fuzzy matching, and auto-complete suggestions. Additionally, RediSearch offers numeric and geospatial filtering, stemming-based query expansion, and support for Chinese-language tokenization. It also includes a distributed cluster version for large-scale deployments, available through Redis Cloud and Redis Enterprise Software.

wickdb is an open-source, pure Rust LSM-tree based embedded storage engine, currently under rapid development. It offers fundamental components necessary for building a LevelDB-like database, making it a valuable resource for developers working with embedded storage solutions. The project emphasizes a modular design, including core elements like Arena, Skiplist, Cache, Record Batch, Block Table, Version, VersionEdit, VersionSet, Storage DB, and Compaction implementation. Developers can contribute to its ongoing progress, with clear guidelines for development and testing using stable Rust. The project actively welcomes PRs and issues, indicating a collaborative environment for its evolution.

SplinterDB is an embedded key-value store specifically engineered for high performance on modern, fast storage devices like NVMe SSDs. It is provided as a library intended for integration within other programs, allowing developers to embed its capabilities directly into their applications. The project focuses on optimizing data storage and retrieval to address the bandwidth limitations often encountered with NVMe key-value stores. While currently not recommended for production use until version 1.0, it offers a robust foundation for applications requiring efficient, high-speed data handling. Developers can find comprehensive documentation and build instructions on its GitHub repository, making it accessible for experimentation and development.

EJDB2 is an embeddable JSON database engine provided as a C library, designed for applications requiring local JSON data storage and retrieval. It features a simple yet powerful XPath-like query language (JQL) for querying and updating JSON documents, inspired by Unix shell pipes. The engine supports online backups and offers HTTP REST/Websockets endpoints for network access. Built on IOWOW, a persistent key/value storage engine, EJDB2 provides native language bindings and is tested on Linux, macOS, and FreeBSD. Its JQL allows for complex filtering, projections, collection joins, and data modification using JSON patch specifications, including non-standard extensions like increment and add_create.

Speedb is a community-led, high-performance, scalable embedded key-value storage engine that is 100% compatible with RocksDB. Designed to support modern datasets, it functions as a drop-in library optimized for contemporary storage hardware and cloud environments. Key features include improved read and write performance through innovations like a sorted hash memtable, stabilized performance with an enhanced delayed write mechanism, and reduced memory consumption via a paired bloom filter. Speedb also offers ease of maintenance by allowing mutable options to be changed during runtime and simplifies the management of multiple databases. It aims to simplify the usability of complex data engines and enhance performance across various use cases.

CubDB is an embedded key-value database specifically developed for the Elixir language, prioritizing robustness and efficient resource utilization. It offers essential operations like `get`, `put`, and `delete`, alongside advanced features such as atomic, consistent, isolated, and durable (ACID) transactions. The database employs multi-version concurrency control (MVCC), allowing concurrent read operations without blocking or being blocked by writes. CubDB ensures data integrity even after unexpected shutdowns through its append-only, immutable B-tree data structure, which prevents corruption and maintains transaction atomicity. It also supports manual or automatic compaction to reclaim disk space and provides read-only snapshots for consistent, isolated reads without blocking writes.

upscaledb is a very fast, lightweight embedded database engine written in C/C++ that includes a built-in query language. It is production-proven and designed for ease of use, offering features like a sorted B+Tree with variable length keys, basic schema support for POD types, and very fast analytical functions. The database can run as an in-memory solution, supports unlimited parallel transactions, and provides transparent AES encryption and CRC32 verification. It also includes various compression codecs, network access via TCP/Protocol Buffers, and wrappers for multiple programming languages including C++, Java, .NET, Erlang, and Python. upscaledb is open source under the Apache Public License 2.0.

Queryline is a robust and fast native database client designed for macOS, Windows, and Linux, supporting PostgreSQL, MySQL, SQLite, and Google Firestore. It offers a unified, familiar interface for managing various databases, eliminating the need for context switching. Key features include a schema browser for quick navigation, secure credential storage in the OS keychain, and multi-format export capabilities to CSV, JSON, or SQL INSERT statements. The tool is built for developers, providing a Monaco SQL editor with syntax highlighting and auto-completion. It handles large result sets efficiently through smart caching and virtual scrolling, allowing users to browse hundreds of thousands of rows without lag. Queryline is free to download and use, focusing on performance and essential features without bloat.

sqlite3-ruby offers Ruby bindings for the SQLite3 embedded database, enabling Ruby developers to seamlessly integrate and utilize the SQLite3 database engine within their applications. This library is designed for compatibility with SQLite 3.6.16 or newer, ensuring a broad range of support for existing and new projects. It facilitates database operations directly from Ruby code, making it a valuable tool for managing data in Ruby-based applications. The integration simplifies database interactions, allowing developers to focus on application logic rather than complex database setup.

SPIFFS (SPI Flash File System) is an open-source file system specifically engineered for SPI NOR flash devices in embedded systems. It prioritizes low RAM usage, operating with statically sized RAM buffers independent of the number of files. SPIFFS offers a POSIX-like API for file operations, including open, close, read, write, seek, and stat. It supports wear leveling to extend the lifespan of flash memory and includes built-in file system consistency checks. While highly configurable and capable of running multiple configurations on the same target, it currently does not support directories, creating a flat file structure. It is intended for small memory devices, typically up to 128MB, due to its design goal of minimal RAM consumption.

LittleD is a relational database specifically engineered for microprocessor devices and sensor nodes, requiring minimal RAM (as little as 1kB for most queries). It provides a SQL frontend to manage data, supporting core relational operations such as CREATE TABLE, INSERT statements, and SELECT-FROM-WHERE syntax, including inner joins, projections, and selections over arbitrary expressions. Currently, it supports integers and fixed-width strings. The system is highly configurable, allowing users to control the database's codespace footprint by dictating which features are compiled in via a simple configuration header file. LittleD is written in C and is suitable for devices with capabilities similar to the Arduino Mega2560, making it an ideal solution for embedded systems requiring robust data management.

dqlite is an open-source C library that provides an embeddable, replicated, and fault-tolerant SQL database engine. It builds upon SQLite by adding a network protocol, enabling multiple application instances to form a highly-available cluster without relying on external databases. Key design highlights include an asynchronous single-threaded implementation using libuv, a custom wire protocol optimized for SQLite data types, and data replication based on the Raft algorithm. dqlite is compatible with Linux kernels supporting native async I/O and offers a modified LGPLv3 license allowing static linking. It's ideal for developers seeking a robust, self-contained, and highly available SQL solution for their applications.

lmdbjava is a powerful open-source Java library that provides access to the Lightning Memory Database (LMDB). It functions as a low-latency, transactional, sorted, embedded key-value store, offering full ACID semantics for data integrity. A key differentiator is its use of memory-mapped files, enabling optimal OS-level memory management and a zero-copy design, which eliminates serialization or memory copy overhead. The library supports ordered keys for very fast cursor-based iteration and ensures no blocking between readers and writers. It's configuration-free, provides instant crash recovery, and supports multi-threading and multi-process operations. LmdbJava adds Java-specific features like an idiomatic API, embedded native libraries for various OS, and buffer agnosticism, making it suitable for high-performance, production workloads.

Rektor-db is presented as a conceptual vector database project, currently in its earliest stages of development. The project is explicitly described as "pre-revenue, pre-code, and pre-vision," indicating that it lacks a functional product, a defined business model, and a clear strategic direction. The primary objective stated is to attract investors to fund its future development. As of now, there are no features, pricing, or use cases available, as the project is purely a concept seeking financial backing to move forward. It is hosted on GitHub, suggesting an intention for open-source development once funding is secured.