kennethreitz/records
Records
Records is a SQL database client designed for executing raw queries and managing result sets through a simplified interface. It provides a parameterized SQL executor to bind values to placeholders, ensuring safe data handling and preventing injection attacks, alongside a database transaction manager for grouping operations into atomic units.
The project includes a dedicated command-line interface for running database statements and exporting query results directly to local files. This tooling allows for the conversion of SQL result sets into multiple serialization formats, including CSV, JSON, YAML, and Excel.
The library covers a broad range of database interaction capabilities, including bulk data processing, result set manipulation through sorting and slicing, and the execution of SQL queries from files.
Features
- Raw SQL Execution - Executes database statements directly via a thin wrapper over the database driver to avoid abstraction overhead.
- SQL Query Interfaces - Provides a simplified interface for executing raw SQL queries and managing database result sets.
- Atomic Batch Commits - Groups multiple database mutations into a single atomic unit that either applies completely or rolls back entirely.
- Dynamic Object Mapping - Converts raw database rows into accessible objects with dynamic attribute access for easy data manipulation.
- Database Transaction Managers - Provides a system for grouping multiple SQL operations into atomic units to ensure data integrity.
- Database Transaction Management - Groups multiple operations into single atomic units that commit or roll back to ensure data integrity.
- Multi-Format Serializers - Transforms structured database result sets into interchangeable formats like CSV, JSON, YAML, and Excel.
- Query Result Fetching - Provides structured ways to organize, access, and manipulate record sets returned from SQL executions.
- SQL Placeholder Bindings - Binds values to placeholders in SQL statements to prevent injection attacks and ensure type safety.
- SQL Query Execution - Runs raw SQL strings or files and returns results as iterable rows with flexible attribute access.
- Parameterized Query Bindings - Implements parameterized query bindings to separate SQL logic from user-supplied values and prevent injection.
- Parameterized Bulk Processing - Executes the same SQL query multiple times with different parameters to handle large datasets efficiently.
- Query Result Exporters - Provides a command-line tool to execute queries and export results directly to local files.
- Result Set Refinements - Supports sorting, slicing, and deduplicating retrieved data before exporting or processing information.
- Bulk Executions - Processes multiple SQL statements in a single operation or loads queries from files to increase data throughput.
- CLI Query Interfaces - Allows users to execute SQL commands and interact with the database through a dedicated command-line interface.
- Database CLI Tools - Provides a command-line interface for interacting with databases, executing queries, and retrieving data.
- Database Export Pipelines - Streams query results from the database engine directly to formatted file outputs via a command line interface.
- SQL Command Line Interfaces - Includes a dedicated terminal tool for executing database statements and exporting results to files.
- SQL Data Export Utilities - Converts database query results into portable formats like CSV or JSON for reporting and sharing.
- Database Clients - Simplified SQL access.
