slonik

A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL. (by gajus)

Slonik Alternatives

Similar projects and alternatives to slonik

  • TypeScript

    1,335 slonik VS TypeScript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • Prisma

    450 slonik VS Prisma

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

  • zod

    308 slonik VS zod

    TypeScript-first schema validation with static type inference

  • cal.com

    167 slonik VS cal.com

    Scheduling infrastructure for absolutely everyone.

  • TypeORM

    157 slonik VS 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.

  • redwood

    118 slonik VS redwood

    The App Framework for Startups

  • Knex

    99 slonik VS Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  • prisma1

    64 slonik VS prisma1

    Discontinued 💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB) [deprecated]

  • PostgreSQL

    57 slonik VS PostgreSQL

    PostgreSQL client for node.js.

  • drizzle-orm

    49 slonik VS drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

  • MikroORM

    49 slonik VS MikroORM

    TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.

  • postgres

    43 slonik VS postgres

    Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)

  • kysely

    42 slonik VS kysely

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

  • pgtyped

    34 slonik VS pgtyped

    pgTyped - Typesafe SQL in TypeScript

  • JDBI

    27 slonik VS JDBI

    The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

  • Hegel

    15 slonik VS Hegel

    Discontinued An advanced static type checker

  • kanel

    10 slonik VS kanel

    Generate Typescript types from Postgres

  • kysely-codegen

    Generate Kysely type definitions from your database.

  • Sequelize

    90 slonik VS 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.

  • node-sql-template-strings

    ES6 tagged template strings for prepared SQL statements 📋

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better slonik alternative or higher similarity.

slonik discussion

Log in or Post with

slonik reviews and mentions

Posts with mentions or reviews of slonik. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-06.
  • Sneakiest development trap: making easy easier...
    1 project | dev.to | 4 Jan 2024
    And sometimes invest instead in learning a technology rather than hide it: for example slonik encourages you to write normal SQL queries by making SQL templating easier and safer. In turn, your IDE would be able to understand those queries and give you support based on the database schemas you actually have.
  • Drizzle is just as unready for prime-time as Prisma, what else is there?
    12 projects | /r/reactjs | 6 Dec 2023
    I'd push you to consider using postgres, slonik or similar for database queries. With these libraries, you just write SQL, but they perform input sanitization for you. So you can safely write:
  • Slonik: PostgreSQL client for Node.js with runtime validation
    1 project | news.ycombinator.com | 14 Oct 2023
  • PostgresJs: The Fastest full featured PostgreSQL client for Node.js and Deno
    16 projects | news.ycombinator.com | 14 Oct 2023
    You can already use postgres with Slonik.

    https://github.com/gajus/slonik#user-content-slonik-how-are-...

    It is not going to be the default because it is way slower.

    https://github.com/gajus/slonik/actions/runs/6616647651

    Test node_version:18 test_only:postgres-integration is taking 3 minutes.

    Test node_version:18 test_only:pg-integration is taking 38 seconds.

  • Integrating Slonik with Express.js
    2 projects | dev.to | 30 Sep 2023
    For those uninitiated, Slonik is a battle-tested SQL query building and execution library for Node.js. Its primary goal is to allow you to write and compose SQL queries in a safe and convenient way. Now, let's see how it pairs with Express.js.
  • Which Postgres client are you using?
    1 project | /r/node | 29 Sep 2023
    I am the maintainer of Slonik and I am trying to understand what portion of this sub-users are using Slonik vs other libraries, and if they are using anything else – what are their reasons for it.
  • JEP Draft: String Templates (Final)
    1 project | news.ycombinator.com | 25 Sep 2023
    It's nice that they implemented string templates essentially exactly the same way Javascript template literals and tag functions work. They even give an example of using it to create a prepared statement (e.g. DB."SELECT * FROM foo WHERE bar = \{inputParam}") which is exactly what many NodeJS libraries due, e.g. Slonik https://github.com/gajus/slonik, like sql`SELECT * FROM foo WHERE bar = ${inputParam}`;
  • We use TypeScript not based on preference, but because we want to make money
    3 projects | news.ycombinator.com | 15 Sep 2023
    I've found libraries like Zod useful when interacting with external data sources like a database. Slonik[1] uses Zod to define the types expected from a SQL query and then performs runtime validation on the data to ensure that the query is yielding the expected type.

    I don't think it's necessary to use Zod/runtime validation everywhere, but it's a nice tool to have on hand.

    [1]https://github.com/gajus/slonik

  • Is ORM still an anti-pattern?
    15 projects | news.ycombinator.com | 27 Jun 2023
    Demonstrate how easily and accidentally one can make an SQL injection with these:

    https://github.com/porsager/postgres

    https://github.com/gajus/slonik

  • The Epic Stack by Kent C. Dodds
    6 projects | news.ycombinator.com | 12 May 2023
    Have you tried Slonik (https://github.com/gajus/slonik)? It won't generate types from queries automatically, but it encourages writing SQL vs. a query builder and allows type annotations of queries with Zod. Query results are validated at runtime to ensure the queries are typed correctly.
  • A note from our sponsor - SaaSHub
    www.saashub.com | 23 Jul 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic slonik repo stats
71
4,463
9.5
about 1 month ago

gajus/slonik is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.

The primary programming language of slonik is TypeScript.


Sponsored
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com

Did you konow that TypeScript is
the 2nd most popular programming language
based on number of metions?