Awesome GitHub RepositoriesFlat-File SQL Analysis

TextQL is a command line SQL query engine designed to execute relational queries directly against structured text files, such as CSV and TSV, without requiring a database import. It functions as a relational text file analyzer and a CSV processor that treats plain text files as virtual tables for filtering, joining, and aggregating data. The tool is built as a pipe-compatible data transformation utility, allowing it to process data from standard input and output formatted datasets. It enables relational joins across multiple files or directories within a single query to analyze relationships

Perfetto is a platform for system-level performance tracing and analysis on Linux and Android. It combines a high-throughput trace recorder, a SQL-based query engine, and a browser-based visualizer into a single toolchain. The platform covers CPU scheduling and call-stack profiling, native and Java heap memory allocation tracking, GPU and graphics events, and system-wide counters such as CPU frequency and power consumption. The architecture decouples trace recording from offline analysis, using a compact protobuf format for event encoding and columnar storage for efficient SQL queries. The we

Briefer est une plateforme de notebook de données interactif et un outil de tableau de bord de business intelligence utilisé pour l'analyse de données collaborative et le reporting. Il fournit un environnement conteneurisé pour construire des rapports qui combinent SQL, Python et Markdown avec des visualisations natives. La plateforme dispose d'un assistant de code intégré qui utilise de grands modèles de langage pour générer des snippets SQL et Python à partir de prompts en langage naturel. Elle est conçue comme une application de données Kubernetes, se déployant via des charts Helm pour gérer des environnements de calcul isolés et assurer des ressources séparées par page via une isolation basée sur des pods. Le système couvre un large éventail de capacités incluant la connectivité aux bases de données externes, la co-édition en temps réel et la livraison automatisée de rapports via la planification. Il s'intègre avec OpenID Connect pour le provisionnement d'identité et fournit un contrôle d'accès basé sur les rôles, une gestion sécurisée des identifiants et la mise en cache des requêtes basée sur les résultats. L'application est déployée et mise à l'échelle à travers des clusters Kubernetes en utilisant des charts Helm gérés.

Franchise is a database query tool and notebook SQL client that allows users to run queries and analyze datasets. It functions as a local data processor with a browser-based engine for executing SQL commands against CSV, JSON, and XLSX files without uploading data to a remote server. The project uses a cell-based interface to organize queries and results in an interactive, document-like layout. It supports a workflow where users can fork queries into side-by-side layouts to compare different SQL variations and their results without overwriting existing code. The system provides a unified int

dsq is a command-line interface and data engine for executing SQL queries against local structured files, such as CSV, JSON, Parquet, and Excel, without requiring a formal database import. It functions as a schema-inference engine that automatically detects data types and maps heterogeneous file structures into relational tables for analysis. The tool utilizes a lazy stream data processor and checksum-based disk caching to handle large datasets with minimal memory usage. It provides a persistent interactive shell for iterative data exploration, allowing users to inspect inferred schemas and r

qsv is a high-performance command line toolkit for querying, transforming, and analyzing comma-separated value files. It functions as a data wrangling interface and a tabular data profiler, featuring a query engine capable of executing SQL statements and joins directly on flat files without requiring a database. The project is distinguished by its ability to process massive datasets that exceed available system memory. This is achieved through disk-based external memory processing, including multithreaded merge sorting, on-disk hash tables for deduplication, and lightweight file indexing for