Need advice about which tool to choose?Ask the StackShare community!

Knex.js

179
401
+ 1
49
phpMyAdmin

307
293
+ 1
15
Add tool

Knex.js vs phpMyAdmin: What are the differences?

Knex.js: SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle. 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; phpMyAdmin: A free software, for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.

Knex.js and phpMyAdmin belong to "Database Tools" category of the tech stack.

Knex.js is an open source tool with 10.2K GitHub stars and 1.25K GitHub forks. Here's a link to Knex.js's open source repository on GitHub.

Decision6, Intervene.me, and Zube are some of the popular companies that use Knex.js, whereas phpMyAdmin is used by Basharsoft, Rescue Digital, LLC, and Matzen Group IVS. Knex.js has a broader approval, being mentioned in 14 company stacks & 50 developers stacks; compared to phpMyAdmin, which is listed in 11 company stacks and 19 developer stacks.

Decisions about Knex.js and phpMyAdmin
Adam Taylor

We were looking a tool that would allow us to do MySQL and PostgreSQL development/administration from a single tool. We decided on Navicat Premium because it can connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases - and simultaneously. It's also compatible with Amazon RDS and Microsoft Azure, which we also use.

Moreover, we previously experienced the occasional freezing and crashing in MySQL Workbench. It also suffered from a poor design, with certain features being a bit difficult to find. Meanwhile, phpMyAdmin lacked schema visualization tools and seemed better suited to lightweight day to day transactions than some of the big jobs that we needed to do.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Knex.js
Pros of phpMyAdmin
  • 11
    Write once and then connect to almost any sql engine
  • 10
    Faster
  • 8
    Nice api, Migrations/Seeds
  • 7
    Flexibility in what engine you choose
  • 7
    Free
  • 5
    Multi support and easy to use
  • 1
    Simple query API
  • 5
    Query linter
  • 5
    Easy data access
  • 5
    User administration

Sign up to add or upvote prosMake informed product decisions

Cons of Knex.js
Cons of phpMyAdmin
    Be the first to leave a con
    • 1
      Insecure

    Sign up to add or upvote consMake informed product decisions

    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.

    What is phpMyAdmin?

    As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use Knex.js?
    What companies use phpMyAdmin?
    See which teams inside your own company are using Knex.js or phpMyAdmin.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Knex.js?
    What tools integrate with phpMyAdmin?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Knex.js and phpMyAdmin?
    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.
    Slick
    It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
    Spring Data
    It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
    DataGrip
    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
    DBeaver
    It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
    See all alternatives