Awesome GitHub RepositoriesSQL Export Generators

cloc is a codebase metrics tool and multi-language code analyzer designed to count blank lines, comment lines, and physical lines of code. It serves as a source code line counter and report generator that identifies file types to calculate source volume across a wide variety of programming languages. The tool distinguishes itself by providing codebase version comparison to measure relative changes in source and comment lines between two versions of a directory or archive. It also supports the definition of custom languages and the extension of language recognition by loading custom comment fi

pgcli is an interactive command-line interface and database management tool for PostgreSQL. It functions as an interactive SQL shell and query editor that allows users to inspect schemas, manage connections, and run queries against PostgreSQL data sources. The tool is distinguished by its real-time, schema-aware autocompletion for keywords, tables, and columns, as well as dynamic SQL syntax highlighting. It provides safety mechanisms through transaction-aware guardrails that warn against or block destructive statements when no active transaction is detected. Broad capabilities include secure

This project is an administrative GIS toolset that provides a comprehensive dataset of China's administrative divisions, including provinces, cities, districts, and townships. It functions as a coordinate system transformer and a boundary converter for transforming geographic data into standard formats. The toolset distinguishes itself through the ability to convert administrative boundary data between CSV, GeoJSON, Shapefiles, and SQL. It includes specialized utilities for coordinate system transformation between GCJ-02, BD-09, WGS-84, and CGCS2000 standards to ensure accuracy across differe

SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

Alembic este un sistem de versionare a schemei bazei de date și un instrument de migrare pentru SQLAlchemy. Acesta gestionează actualizările incrementale ale structurilor bazei de date folosind scripturi versionate care suportă atât upgrade-ul, cât și downgrade-ul pentru a menține baza de date și codul sincronizate. Sistemul utilizează un graf aciclic direcționat pentru gestionarea migrării, ceea ce permite versionarea neliniară, inclusiv ramificarea și fuziunea pe mai multe versiuni rădăcină. Include un instrument automat de diffing al schemei care compară schemele bazei de date live cu obiectele de metadate pentru a genera programatic instrucțiuni de migrare. Instrumentul oferă capabilități pentru evoluția tranzacțională a schemei pentru a asigura actualizări atomice și a preveni coruperea parțială a bazei de date. Funcționalitatea suplimentară include traducerea directivelor de migrare în șiruri SQL brute pentru auditare și menținerea urmăririi versiunilor bazate pe scripturi printr-un tabel dedicat al bazei de date.