Alternatives to Knex.js logo

Alternatives to Knex.js

Sequelize, Slick, Spring Data, Dataform, and Liquibase are the most popular alternatives and competitors to Knex.js.
177
392
+ 1
49

What is Knex.js and what are its top alternatives?

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

Top Alternatives to Knex.js

  • Sequelize
    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
    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
    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
    DataGrip

    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases. ...

  • Microsoft SQL Server Management Studio
    Microsoft SQL Server Management Studio

    It is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides tools to configure, monitor, and administer instances of SQL Server and databases. Use it to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. ...

  • DBeaver
    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. ...

  • dbt
    dbt

    dbt is a transformation workflow that lets teams deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone who knows SQL can build production-grade data pipelines. ...

  • dbForge Studio for MySQL
    dbForge Studio for MySQL

    It is the universal MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient. This tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data. ...

Knex.js alternatives & related posts

Sequelize logo

Sequelize

786
1.4K
141
Easy-to-use multi SQL dialect ORM for Node.js
786
1.4K
+ 1
141
PROS OF SEQUELIZE
  • 42
    Good ORM for node.js
  • 31
    Easy setup
  • 20
    Support MySQL & MariaDB, PostgreSQL, MSSQL, Sqlite
  • 14
    Open source
  • 13
    Free
  • 11
    Promise Based
  • 4
    Recommend for mongoose users
  • 3
    Atrocious documentation, buggy, issues closed by bots
  • 3
    Typescript
CONS OF SEQUELIZE
  • 30
    Docs are awful
  • 9
    Relations can be confusing

related Sequelize posts

Dieudonné ALLOGNON
Junior Fullstack Developer · | 5 upvotes · 234.1K views

Hey! I am actually in internship and have an app to create for my structure. It will be an intern app which will allow crud dashboard actions with some data provided by the use of an API of one of the structure partner and make a correspondence to data contained in a private database. Since it's an intern app, I thought about Electron for a desktop app because I did a lot of web with Laravel and the structure goes more for the desktop app. But it will be my first occasion working with this tech.

Is Electron a good choice? Wich ORM should be more complete and adapted to this between Sequelize and TypeORM? (Database will be MySQL) Some charts will be displayed in the app. Is there a library (preferably without jQuery) that suits this stack?

Thank you !

See more
Vyshnav KPI
Application Developer at KPI suite tech · | 4 upvotes · 32.9K views
Shared insights
on
SequelizeSequelizePrismaPrisma

Can you help me with the following:

  1. What additional functionality is present in Prisma when compared with Sequelize?
  2. Is getter and setter method available in Prisma? If then please provide any reference or resource.
  3. Is Hooks, hierarchy present in Prisma?
See more
Slick logo

Slick

9.2K
1.2K
0
Database query and access library for Scala
9.2K
1.2K
+ 1
0
PROS OF SLICK
    Be the first to leave a pro
    CONS OF SLICK
      Be the first to leave a con

      related Slick posts

      Spring Data logo

      Spring Data

      539
      392
      0
      Provides a consistent approach to data access – relational, non-relational, map-reduce, and beyond
      539
      392
      + 1
      0
      PROS OF SPRING DATA
        Be the first to leave a pro
        CONS OF SPRING DATA
          Be the first to leave a con

          related Spring Data posts

          Остап Комплікевич

          I need some advice to choose an engine for generation web pages from the Spring Boot app. Which technology is the best solution today? 1) JSP + JSTL 2) Apache FreeMarker 3) Thymeleaf Or you can suggest even other perspective tools. I am using Spring Boot, Spring Web, Spring Data, Spring Security, PostgreSQL, Apache Tomcat in my project. I have already tried to generate pages using jsp, jstl, and it went well. However, I had huge problems via carrying already created static pages, to jsp format, because of syntax. Thanks.

          See more
          DataGrip logo

          DataGrip

          537
          617
          16
          A database IDE for professional SQL developers
          537
          617
          + 1
          16
          PROS OF DATAGRIP
          • 4
            Works on Linux, Windows and MacOS
          • 2
            Diff viewer
          • 2
            Code analysis
          • 2
            Wide range of DBMS support
          • 1
            Generate ERD
          • 1
            Quick-fixes using keyboard shortcuts
          • 1
            Database introspection on 21 different dbms
          • 1
            Export data using a variety of formats using open api
          • 1
            Import data
          • 1
            Code completion
          CONS OF DATAGRIP
            Be the first to leave a con

            related DataGrip posts

            Microsoft SQL Server Management Studio logo

            Microsoft SQL Server Management Studio

            481
            415
            0
            An integrated environment for managing any SQL infrastructure
            481
            415
            + 1
            0
            PROS OF MICROSOFT SQL SERVER MANAGEMENT STUDIO
              Be the first to leave a pro
              CONS OF MICROSOFT SQL SERVER MANAGEMENT STUDIO
                Be the first to leave a con

                related Microsoft SQL Server Management Studio posts

                Kelsey Doolittle

                We have a 138 row, 1700 column database likely to grow at least a row and a column every week. We are mostly concerned with how user-friendly the graphical management tools are. I understand MySQL has MySQL WorkBench, and Microsoft SQL Server has Microsoft SQL Server Management Studio. We have about 6 months to migrate our Excel database to one of these DBMS, and continue (hopefully manually) importing excel files from then on. Any tips appreciated!

                See more
                DBeaver logo

                DBeaver

                473
                653
                66
                A Universal Database Tool
                473
                653
                + 1
                66
                PROS OF DBEAVER
                • 21
                  Free
                • 13
                  Platform independent
                • 9
                  Automatic driver download
                • 7
                  Import-Export Data
                • 6
                  Simple to use
                • 4
                  Wide range of DBMS support
                • 4
                  Move data between databases
                • 1
                  SAP Hana DB support
                • 1
                  Themes
                CONS OF DBEAVER
                  Be the first to leave a con

                  related DBeaver posts

                  Manikandan Shanmugam
                  Software Engineer at Blitzscaletech Software Solution · | 4 upvotes · 1M views
                  Shared insights
                  on
                  AzureDataStudioAzureDataStudioDBeaverDBeaver

                  Which tools are preferred if I choose to work on more data side? Which one is good if I decide to work on web development? I'm using DBeaver and am now considering a move to AzureDataStudio to break the monotony while working. I would like to hear your opinion. Which one are you using, and what are the things you are missing in dbeaver or data studio.

                  See more
                  dbt logo

                  dbt

                  421
                  403
                  15
                  dbt helps data teams work like software engineers—to ship trusted data, faster.
                  421
                  403
                  + 1
                  15
                  PROS OF DBT
                  • 5
                    Easy for SQL programmers to learn
                  • 2
                    CI/CD
                  • 2
                    Schedule Jobs
                  • 2
                    Reusable Macro
                  • 2
                    Faster Integrated Testing
                  • 2
                    Modularity, portability, CI/CD, and documentation
                  CONS OF DBT
                  • 1
                    Only limited to SQL
                  • 1
                    Cant do complex iterations , list comprehensions etc .
                  • 1
                    People will have have only sql skill set at the end
                  • 1
                    Very bad for people from learning perspective

                  related dbt posts

                  Ankit Sobti

                  Looker , Stitch , Amazon Redshift , dbt

                  We recently moved our Data Analytics and Business Intelligence tooling to Looker . It's already helping us create a solid process for reusable SQL-based data modeling, with consistent definitions across the entire organizations. Looker allows us to collaboratively build these version-controlled models and push the limits of what we've traditionally been able to accomplish with analytics with a lean team.

                  For Data Engineering, we're in the process of moving from maintaining our own ETL pipelines on AWS to a managed ELT system on Stitch. We're also evaluating the command line tool, dbt to manage data transformations. Our hope is that Stitch + dbt will streamline the ELT bit, allowing us to focus our energies on analyzing data, rather than managing it.

                  See more
                  dbForge Studio for MySQL logo

                  dbForge Studio for MySQL

                  394
                  116
                  1.1K
                  The universal MySQL and MariaDB client for database management
                  394
                  116
                  + 1
                  1.1K
                  PROS OF DBFORGE STUDIO FOR MYSQL
                  • 66
                    Intelligent SQL Coding
                  • 65
                    Data Generator
                  • 64
                    Database Backup
                  • 64
                    Query Profiler
                  • 64
                    Database Compare and Sync
                  • 64
                    MySQL Debugger
                  • 64
                    Visual Query Builder
                  • 63
                    Import/Export Data
                  • 63
                    Database Refactoring
                  • 63
                    Database Projects
                  • 63
                    Broad Compatibility Options
                  • 62
                    Table Designer
                  • 62
                    Report and Analysis
                  • 62
                    Database Designer
                  • 62
                    Database Administration
                  • 53
                    Copy Database
                  • 53
                    Documenter
                  CONS OF DBFORGE STUDIO FOR MYSQL
                    Be the first to leave a con

                    related dbForge Studio for MySQL posts