pg-promise VS Knex

Compare pg-promise vs Knex and see what are their differences.

Knex

A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use. (by knex)
Our great sponsors
  • SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
pg-promise Knex
17 94
3,410 18,622
- 0.9%
5.8 8.1
9 days ago 2 days ago
JavaScript JavaScript
MIT License MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pg-promise

Posts with mentions or reviews of pg-promise. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-01-26.

Knex

Posts with mentions or reviews of Knex. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-20.

What are some alternatives?

When comparing pg-promise and Knex you can also consider the following projects:

Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

Sequelize - Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

kysely - A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely]

slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

kysely - A type-safe typescript SQL query builder

DataStax Node.js Driver for Apache Cassandra - DataStax Node.js Driver for Apache Cassandra

strapi-db-query-demo - Demonstrating database transactions in Strapi ✨

hjson-js - Hjson for JavaScript

postgres - Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare