denodb VS tsql

Compare denodb vs tsql and see what are their differences.

denodb

MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno (by eveningkid)

tsql

Transact-SQL template combinators. (by appliedblockchain)
Our great sponsors
  • SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
denodb tsql
5 3
1,906 11
- -
1.0 6.8
5 months ago 7 months ago
TypeScript TypeScript
MIT License GNU General Public License v3.0 or later
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.

denodb

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

tsql

Posts with mentions or reviews of tsql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-01-24.
  • Kysely: TypeScript SQL Query Builder
    19 projects | news.ycombinator.com | 24 Jan 2023
    We use in prod variant of no 1. [0]. Why? Because:

    * it's extremely lightweight (built on pure, functional combinators)

    * it allows us to use more complex patterns ie. convention where every json field ends with Json which is automatically parsed; which, unlike datatype alone, allows us to create composable query to fetch arbitrarily nested graphs and promoting single [$] key ie. to return list of emails as `string[]` not `{ email: string }[]` with `select email as [$] from Users` etc.

    * has convenience combinators for things like constructing where clauses from monodb like queries

    * all usual queries like CRUD, exists etc. and some more complex ie. insertIgnore, merge1n etc has convenient api

    We resort to runtime type assertions [1] which works well for this and all other i/o; runtime type assertions are necessary for cases when your running service is incorrectly attached to old or future remote schema (there are other protections against it but still happens).

    [0] https://github.com/appliedblockchain/tsql

    [1] https://github.com/appliedblockchain/assert-combinators

  • Objection to ORM Hatred
    6 projects | news.ycombinator.com | 15 Jan 2023
    Exactly. I'm happy with tsql [0] - template based, with safe sanitation, helper renderers/combinators, used in production for several years, would recommend this approach.

    [0] https://github.com/appliedblockchain/tsql

  • DenoDB
    15 projects | news.ycombinator.com | 17 Jun 2021
    Personally I prefer functional combinators like interfaces [0]. Js/ts have tagged templates which enhances those type of interfaces a lot. It gives access to full set of functionality of underlying database, not just common denominator of all used. It allows arbitrary compositions etc.

    [0] https://github.com/appliedblockchain/tsql/

What are some alternatives?

When comparing denodb and tsql you can also consider the following projects:

trpc - 🧙‍♀️ Move Fast and Break Nothing. End-to-end typesafe APIs made easy.

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

MySQL - A pure node.js JavaScript Client implementing the MySQL protocol.

typed-knex - A TypeScript wrapper for Knex.js

dndb - A Deno 🦕 persistent, embeddable and optimized NoSQL database for JS & TS

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

PostgreSQL - PostgreSQL client for node.js.

vscode-sqlite - VSCode extension to explore and query SQLite databases.

helppo - Instant admin UI for your database

js-sqlate - A tiny tagged template string function library for JavaScript to write SQL safely. Works with Mapbox's SQLite3 library, Brian Carlson's PostgreSQL library and others.

pg-promise - PostgreSQL interface for Node.js