What is Knex.js?
Knex.js is a "batteries included" SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.
Knex.js is a tool in the Database Tools category of a tech stack.
Knex.js is an open source tool with GitHub stars and GitHub forks. Here’s a link to Knex.js's open source repository on GitHub
Who uses Knex.js?
Companies
38 companies reportedly use Knex.js in their tech stacks, including Voiceflow, Finema, and Backend.
Developers
140 developers on StackShare have stated that they use Knex.js.
Knex.js Integrations
MySQL, PostgreSQL, SQLite, Oracle, and IndexedDB are some of the popular tools that integrate with Knex.js. Here's a list of all 9 tools that integrate with Knex.js.
Pros of Knex.js
11
10
8
7
7
5
1
Knex.js's Features
- SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle
Knex.js Alternatives & Comparisons
What are some alternatives to Knex.js?
Sequelize
Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL,
MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and
more.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, user-defined types
and functions.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
Redis
Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.
