js-ts-csharp VS drizzle-orm

The thing is, if you're comfortable with TypeScript, it's really more or less just a small step to C#.

A small repo here: https://github.com/CharlieDigital/js-ts-csharp

And a practical example of a Playwright web scraper in C# and TypeScript: https://github.com/CharlieDigital/playwright-scrape-api

"Too many keywords" is the weirdest objection to a programming language versus actually using the language to build something practical.

[1] https://github.com/CharlieDigital/js-ts-csharp

Modern C# isn't that big of a lift from TypeScript. If you can write TypeScript, you can write C#. Much easier transition than say Go or Rust. See also: https://github.com/CharlieDigital/js-ts-csharp

> ...this project is a nice showcase how versatile C# and .NET is

C# and .NET are highly underrated/underappreciated because of some early flops and the Microsoft branding.

It's converging with TypeScript in the best way possible[0] and has some really great language features that even TS is lacking (really powerful switch expressions, for example).

It seems like the natural option for teams that want to move from TypeScript to a compiled, multi-threaded, statically typed language but it seems that there's a lot of teams that would rather use Go or Rust; neither of which are as easy to step up to from TypeScript, IMO.

[0] https://github.com/CharlieDigital/js-ts-csharp

Should it be C#? I think the transition to C# is the easiest because of how similar TypeScript and C# are at some levels (small repo here showing the similarities: https://github.com/CharlieDigital/js-ts-csharp)

I have a small repo here that shows just how similar the JS, TS, and C# are: https://github.com/CharlieDigital/js-ts-csharp

For me, I use TypeScript and C# almost interchangeably now. Most of the patterns I would implement in C# I can also implement in TypeScript. It's very easy to move between them (exhibit A and exhibit B).

Bonus: TypeScript is soooo similar to C#; completely worth your time to learn it.

Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL — you know Drizzle.

Drizzle ORM is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.

> being able to have a completely typesafe ORM such as Drizzle (https://orm.drizzle.team/) feels like a Rubicon moment, and touching anything else feels like a significant step backwards.

Alright, but there's nothing stopping you from having a completely typesafe ORM in python, is there?

Sure, there's isn't really one that everyone uses yet, but the python community tends to be a bit more cautious and slower to adopt big changes like that.

Drizzle [1] comes pretty close the last time I checked.

[1]: https://orm.drizzle.team

Each app’s front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwik’s official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).

It's just SQL so you can take it out at any moment and move to any other DB provider. The package for working with Astro DB, @astrojs/db, includes Drizzle ORM so migration to a different provider should be relatively painless

Since Vercel's analytics pricing is a bit too expensive for my use case (where I hit the limit of 2,500 requests per month), and I didn't like using Google Analytics (not a big fan of Google), I decided to build my own analytics dashboard. Databases was something I didn't work with much before directly, so I decided to use an ORM, Drizzle, which is quite lightweight and easy to use.

do yourself a favor and ditch Prisma. It's a bloody mess of a project and codebase. I recommend https://github.com/drizzle-team/drizzle-orm to anyone that'll listen.