Is ORM still an anti-pattern?

1. TypeORM

   1 167 35,108 8.7 TypeScript

   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.

   

   It is a link to a specific comment on a GitHub issue [0] where multiple users chime in and report facing the same issue.

   Someone honestly trying to refute my comment in good faith could have looked around and easily understood this.

   They would then have found another comment [1], mentioning a pull request [2] supposedly fixing this issue, that explicitly aims to fix "performance issues".

   If that was not a bug, then I don’t know what is.

   But then, I understand that this can be a lot to ask.

   Personally, I believe the only valid criticism that could stand here would be that, not having bothered to check if it still was an issue, I perhaps should have instead used the past tense, out of precaution, instead of assuming the bug had been fixed two to three years after being initially reported. And I shall try to remember that.

   So thank you, I guess.

   [0]: https://github.com/typeorm/typeorm/issues/4499

   [1]: https://github.com/typeorm/typeorm/issues/4499#issuecomment-...

   [2]: https://github.com/typeorm/typeorm/pull/8169

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. lago

   2 194 7,466 8.8 Go

   Open Source Metering and Usage Based Billing API ⭐️ Consumption tracking, Subscription management, Pricing iterations, Payment orchestration & Revenue analytics

   

4. SQLPage

   3 43 1,997 9.9 Rust

   Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.

   

   SQL is much more powerful than most people think, and taking an afternoon to learn everything you can do with it is a great investment.

   After you do that, you will probably not WANT an ORM anymore, finding that it makes your code less readable than plain sql, not simpler.

   Actually, you'll even realize that you may not need anything BUT sql to write your application, using something like (shameless plug) SQLPage [1]

   [1] https://sql.ophir.dev

5. sqlite-fast

   4 2 14 3.0 C#

   A high performance, low allocation SQLite wrapper targeting .NET Standard 2.0.

   

   I think this is the sweet spot. Last time I worked with SQLite on .NET I wrote a wrapper library along those lines: https://github.com/zmj/sqlite-fast

6. potygen

   5 4 100 2.8 TypeScript

   Postgres SQL Parser and type generator

   

7. sqlc

   6 181 14,562 9.0 Go

   Generate type-safe code from SQL

   

   Some examples for anyone else reading:

   https://github.com/kyleconroy/sqlc

   https://github.com/cornucopia-rs/cornucopia

   This is my preferred method of interacting with databases now.

   Very flexible.

8. cornucopia

   7 22 951 3.1 Rust

   Generate type-checked Rust from your PostgreSQL.

   

   Some examples for anyone else reading:

   https://github.com/kyleconroy/sqlc

   https://github.com/cornucopia-rs/cornucopia

   This is my preferred method of interacting with databases now.

   Very flexible.

9. SaaSHub

   www.saashub.com featured

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

   

10. jOOQ

    8 99 6,338 9.8 Java

    jOOQ is the best way to write SQL in Java

    

11. JDBI

    9 29 2,022 8.7 Java

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

    

12. NORM

    10 3 118 6.8 PLpgSQL

    NORM - No ORM framework (by hettie-d)

    

13. Sequel

    11 41 5,021 9.0 Ruby

    Sequel: The Database Toolkit for Ruby

    

    Ruby sequel (http://sequel.jeremyevans.net/) is the only library where you can combine classic ORM Model bases usage, with a more raw query builder "just get me all the data into plain objects". You'll never need anything again in your career life.

14. sqlx

    12 151 14,383 9.4 Rust

    🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)

    

15. postgres

    13 44 7,868 6.8 JavaScript

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

    

    Demonstrate how easily and accidentally one can make an SQL injection with these:

    https://github.com/porsager/postgres

    https://github.com/gajus/slonik

16. slonik

    14 73 4,680 9.1 TypeScript

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

    

    Demonstrate how easily and accidentally one can make an SQL injection with these:

    https://github.com/porsager/postgres

    https://github.com/gajus/slonik

17. SaaSHub

    www.saashub.com featured

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

    

Suggest a related project