gajus/slonik
Slonik
Slonik is a type-safe PostgreSQL client for Node.js that uses tagged template literals to ensure parameters are bound and protected against injection attacks. It provides a framework for connecting applications to PostgreSQL with automatic type checking for queries and database schemas.
The project distinguishes itself through a specialized SQL query linter that detects invalid columns and type mismatches by verifying code against a live database schema during the development process. It also includes a high-performance binary bulk data inserter for loading large datasets using native binary serialization and a connection pool manager capable of dynamic query routing between primary and replica nodes.
The library covers a broad set of database capabilities, including atomic transaction management, dynamic SQL query building, and the processing of large result sets via async-iterable streaming. It further provides middleware interceptors for logging and benchmarking, custom type parsing, and asynchronous callback mechanisms for refreshing database authentication credentials.
Features
- Parameterized SQL Templates - Uses tagged template literals to automatically bind parameters, ensuring type safety and preventing SQL injection attacks.
- Type-Safe Integrations - Connects Node.js applications to PostgreSQL with automatic type checking for queries and database schemas.
- SQL Query Linting - Ships a specialized SQL query linter that detects invalid columns and type mismatches against a live database schema.
- PostgreSQL Pool Managers - Implements a connection pool manager specifically tailored for PostgreSQL database connections in Node.js.
- Raw SQL Execution - Enables execution of raw SQL statements using secure parameter binding via tagged templates.
- Atomic Transaction Execution - Implements mechanisms to wrap multiple queries in atomic transactions that roll back on failure.
- Database Transaction Wrappers - Wraps multiple database queries within a single transaction session to ensure atomicity and consistency.
- Connection Pool Managers - Includes a connection pool manager to optimize resource utilization and support dynamic routing between primary and replica nodes.
- Database Transaction Management - Provides tools for managing database transaction boundaries and ensuring data integrity through atomic operations.
- PostgreSQL Node.js Clients - Provides a type-safe PostgreSQL driver for Node.js using tagged template literals.
- Strongly-Typed Query Validation - Verifies the structure of database outputs using schema validation to ensure type safety at runtime.
- SQL Schema Validators - Provides build-time verification of SQL queries against a live database schema to detect type mismatches and invalid columns.
- Async Iterable Streams - Provides memory-efficient processing of large database result sets using async iterable streams.
- Database Query Builders - Offers a fluent interface for programmatically constructing complex SQL statements with conditional clauses.
- SQL Query Builders - Provides a tool for constructing composable SQL fragments with build-time and runtime schema validation.
- Result Streaming - Provides memory-efficient retrieval of large database result sets using async-iterable streaming.
- Traffic Routing - Directs database queries to primary or replica instances based on the operation type.
- Bulk Record Insertions - Implements high-speed bulk record insertion by converting nested data structures into binary formats.
- Binary Format Insertions - Offers high-speed loading of large datasets using native binary serialization for optimized PostgreSQL insertion.
- SQL Query Building - Facilitates the programmatic construction of secure SQL statements using fluent APIs and parameter binding.
- SQL Query Validators - Ships a specialized SQL query linter that verifies code against a live database schema during development.
- Databases - PostgreSQL client with strict typing and logging.
- Object Relational Mappers - PostgreSQL client with strict typing and logging.
- Database Drivers - Node.js database driver.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
