5 Repos
Awesome GitHub RepositoriesBatch Statement Execution
Executing multiple SQL statements sequentially from a single input string.
Distinct from Statement Executions: Distinct from Statement Executions: specifically addresses the sequential execution of multiple queries in one call
Explore 5 awesome GitHub repositories matching data & databases · Batch Statement Execution. Refine with filters or upvote what's useful.
Awesome Batch Statement Execution GitHub Repositories
Finde die besten Repos mit KI.Wir suchen mit KI nach den am besten passenden Repositories.
- felixge/node-mysql
felixge/node-mysql
18,621Auf GitHub ansehenThis project is a pure JavaScript database driver for Node.js that implements the native MySQL binary protocol. It serves as a comprehensive connector for managing persistent network links to MySQL servers, enabling applications to execute queries, manage transactions, and handle complex data operations without requiring external middleware. The driver distinguishes itself through its integrated support for connection pooling and distributed database routing. It maintains managed sets of reusable network sockets to optimize resource usage under high request volumes, while simultaneously provi
Executes multiple SQL commands within a single request to process complex data operations efficiently.
JavaScript - tryghost/node-sqlite3
TryGhost/node-sqlite3
6,417Auf GitHub ansehennode-sqlite3 is a relational database client and a set of native bindings that allow Node.js applications to interact with SQLite databases. It functions as a C++ native addon, linking JavaScript to the SQLite C library to manage data stored in local files or in-memory stores. The project includes optional support for SQLCipher, enabling page-level encryption to secure local database files. The driver covers a wide range of database management capabilities, including executing SQL queries with parameter binding, managing connections to database files, and preparing statements for repeated ex
Executes a string containing multiple SQL queries in a sequential order.
PLpgSQL - sqlpad/sqlpad
sqlpad/sqlpad
5,186Auf GitHub ansehenSqlpad is a web-based SQL client and multi-tenant workbench used for writing, executing, and saving queries across multiple relational and analytical databases. It functions as an ODBC database manager that enables users to manage database connections and explore schemas through a browser interface. The platform distinguishes itself as a collaborative environment where users can share SQL documents and coordinate data analysis. It integrates identity federation via OpenID Connect, SAML, LDAP, and OAuth, and provides a visualization system that renders query results into charts and tables. Th
Executes a sequence of SQL statements on a database connection while tracking individual status.
JavaScript - zdennis/activerecord-import
zdennis/activerecord-import
4,151Auf GitHub ansehenActiveRecord Import ist eine Bibliothek zum Einfügen großer Datensätze in eine Datenbank mittels ActiveRecord durch einzelne oder gebündelte Abfragen. Es fungiert als Bulk-Daten-Importer und SQL-Bulk-Insert-Tool, das darauf ausgelegt ist, den Abfrage-Overhead zu minimieren und die Schreibleistung zu erhöhen. Das Projekt enthält eine Upsert-Engine, um Konflikte bei eindeutigen Constraints durch das Aktualisieren bestehender Datensätze oder das Ignorieren von Duplikaten zu behandeln. Es bietet zudem einen rekursiven Assoziations-Importer, der es ermöglicht, Eltern-Datensätze und deren verschachtelte Kind-Assoziationen in einem einzigen Vorgang einzufügen. Die Bibliothek bietet eine Validierungsschicht vor dem Einfügen, um die Gültigkeit der Datensätze zu prüfen und Fehler zu melden, bevor Daten festgeschrieben werden. Sie verwaltet die groß angelegte Datenmigration durch Aufteilen der Datensätze in Batches, um den Speicherverbrauch zu kontrollieren und Limits für die Datenbank-Paketgröße zu vermeiden. Das Tool bietet Ergebniszusammenfassungen mit Erfolgszählern und Datensatz-Identifikatoren sowie eine Fortschrittsverfolgung für Daten-Batches.
Chunks large datasets into smaller groups to prevent database packet size errors and manage memory usage.
Ruby - jdorn/sql-formatter
jdorn/sql-formatter
3,857Auf GitHub ansehenThis project is a PHP library designed for parsing, beautifying, and syntax-highlighting SQL queries. It provides a set of utilities to improve the readability of database code, facilitate debugging, and assist in the maintenance of complex query structures. The library distinguishes itself by offering both aesthetic and functional processing capabilities. It can transform raw SQL strings into structured, indented formats for human review, or compress them by removing comments and unnecessary whitespace to optimize them for network transmission and logging. Additionally, it includes a syntax
Parses multi-statement SQL strings into individual commands to simplify the management of complex migration scripts.
HTML
