github.com/knex/knex ↗
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
An animated visualization of knex/knex's Git history from December 2012 to December 2020, built by 409 contributors. The codebase reached 9,573 lines, mostly JavaScript. The video runs 4 minutes 45 seconds.
Render your own repo
Turn any GitHub repository into a video like this — free sample in seconds.
Open this visualization on its own page →
Language
JavaScript
Contributors
409
Lines of Code
9,573
From
2012-12-29
To
2020-12-22
About knex/knex
Knex is a SQL query builder for Node.js that supports multiple database systems including PostgreSQL, MySQL, MariaDB, CockroachDB, SQL Server, SQLite3, and Oracle. Rather than writing raw SQL strings, developers use Knex's JavaScript API to construct queries programmatically, which then generates the appropriate SQL dialect for their chosen database. The library is designed to be flexible and portable across different database backends.
The project includes a comprehensive feature set for working with databases, such as transaction support, connection pooling, streaming queries, and both promise-based and callback-based APIs. Knex comes with a thorough test suite and requires Node.js 16 or later. The library also supports TypeScript and can be used as an ES module, making it compatible with modern JavaScript development practices.
Knex serves as a foundation for higher-level database tools in the Node.js ecosystem. Several Object Relational Mappers like Objection.js and Mikro-ORM are built on top of Knex, allowing developers to choose between using Knex directly for query building or adopting a more full-featured ORM solution. The project maintains extensive documentation, a recipes wiki for common patterns, and an active community for support and discussions.