Awesome GitHub RepositoriesGenerated Columns

Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.

Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a

Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface inc

This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa. The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between

LanceDB is a vector database and columnar data store designed to function as a versioned dataset manager and vector search engine. It serves as a high-performance backend for indexing and retrieving high-dimensional embeddings, providing the foundation for machine learning data pipelines. The system distinguishes itself through a combination of cloud-native object storage and immutable version tracking, allowing for data time-travel and reproducible AI experiments. It integrates hybrid search capabilities, merging dense vector similarity with BM25 full-text search and SQL-like scalar filters

VisiData is a terminal-based interactive data analysis tool and browser designed for exploring, filtering, and sorting large tabular datasets. It functions as a structured data inspector that loads and flattens complex formats like JSON, XML, and PCAP into interactive sheets, as well as a terminal file manager for navigating directories and performing staged filesystem operations. The project distinguishes itself by rendering data visualizations, such as scatter plots and histograms, directly in the terminal using Unicode Braille characters. It provides a Python-based data wrangling environme

Grafana Tempo is a high-scale distributed tracing backend and columnar trace database. It serves as an observability data store that persists and queries spans and traces using OpenTelemetry standards, allowing for the analysis of request flows across microservices. The system distinguishes itself by using an object-store based backend with columnar Parquet storage. This architecture enables efficient attribute searching and large-scale data retrieval through dedicated attribute columnization and block-based data partitioning. It includes a specialized TraceQL query engine for filtering trace

H2 Java में लिखा गया एक JDBC-अनुपालन रिलेशनल डेटाबेस मैनेजमेंट सिस्टम है। यह एक एम्बेड करने योग्य SQL डेटाबेस के रूप में कार्य करता है जो नेटवर्क लेटेंसी को हटाने के लिए सीधे एप्लिकेशन प्रोसेस के भीतर चल सकता है, या उच्च-प्रदर्शन वाले वोलेटाइल स्टोरेज के लिए इन-मेमोरी डेटाबेस के रूप में कार्य कर सकता है। इसमें SQL कमांड निष्पादित करने और स्कीमा प्रबंधित करने के लिए एक वेब-आधारित कंसोल भी शामिल है। सिस्टम को इसके लचीले डिप्लॉयमेंट मोड द्वारा पहचाना जाता है, जिसमें रिमोट TCP/IP एक्सेस के लिए स्टैंडअलोन सर्वर मोड और स्थानीय व रिमोट कनेक्टिविटी के लिए मिक्स्ड मोड शामिल है। इसमें एक डायलेक्ट एमुलेशन लेयर और कम्पैटिबिलिटी मोड हैं जो इसे अन्य डेटाबेस सिस्टम के व्यवहार और सिंटैक्स की नकल करने की अनुमति देते हैं। इंजन ACID ट्रांजेक्शन (मल्टी-वर्जन कॉनकरेंसी कंट्रोल के साथ), जियोस्पेशियल और JSON डेटा सपोर्ट, और उन्नत विश्लेषणात्मक विंडो फंक्शन्स जैसी व्यापक क्षमताएं प्रदान करता है। इसमें डेटा संरक्षण के लिए कंप्रेस्ड बैकअप, SQL स्क्रिप्ट रिस्टोरेशन और बड़े डेटासेट को संभालने के लिए ऑफ-हीप मेमोरी प्रबंधन के टूल शामिल हैं।

Xan is a command-line tool and data transformation engine for processing CSV, TSV, and JSONL datasets. It functions as a processor for compressed files, enabling random access and seeking within gzipped and Zstd files, and serves as a converter for specialized bioinformatics data formats. The tool handles large datasets without requiring full memory loads by utilizing stream-based processing. It provides capabilities for merging, sorting, and deduplicating massive files, as well as converting data between various tabular formats. The project covers a broad range of data wrangling and analysi

Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries

DataFrame is a C++ tabular data library and manipulation engine designed for managing heterogeneous data in contiguous memory. It functions as a statistical analysis framework and time series analysis toolkit, providing the means to store, index, and transform multidimensional datasets. The project distinguishes itself through a high-performance execution model that utilizes column-major storage, SIMD-aligned memory allocation, and a thread-pool for parallel computations. It employs a visitor-based algorithm dispatch system and policy-driven transformations to decouple data processing logic f