Any chance you missed “go” that turned the function into the future?

You can already do that with pgcat (author’s second project) https://github.com/postgresml/pgcat

Maybe I worded my comment in the wrong way - but this feature is already available (although still with small issues in corner cases) in pgdog :)

After being frustrated with Diesel, I gave a try to SeaORM and I couldn’t be happier (have been using it for more than a year). It is not perfect but certainly the best ORM I have ever used myself (vs Diesel, ActiveRecord, SQLAlchemy)

How come? I’m new to the space and picked Diesel a couple weeks ago for a new project because it seemed the most recommended. What do you prefer about SeaORM?

To me, SeaORM feels like a well-designed library while many things in Diesel feel like an afterthought or a hack. Which mostly manifests itself when doing something complex and debugging it.

Also recommend reading https://www.sea-ql.org/SeaORM/docs/internal-design/diesel/

Please note that this comparison is outdated since at least 2 years, given that diesel-async exists for more than 2 years now and this page completely forgets to mention it.

I’ll check it out. Thanks!

sea-query looks a lot like jOOQ!

SeaORM is not compile time safe by their own admission so it's automatically out of the running, personally speaking.

That feels like a weird requirement to me; an ORM is by its very nature not going to be able to validate queries at compile-time.

And even if you're writing queries directly, any time you need to write something dynamic, you're not going to be able to verify those at compile-time either.

> an ORM is by its very nature not going to be able to validate queries at compile-time.

I don't see why this is by its "very nature" when libraries like diesel or Prisma already do this.

> any time you need to write something dynamic, you're not going to be able to verify those at compile-time either.

Diesel can validate dynamic queries at compile time too, sqlx too to some extent.

I've been using Astro lately and loving it. It feels dead simple, has amazing defaults, and is easily extendable.

Not exactly it but Mojo sounds closest from available options

https://www.modular.com/mojo

Astro it also great option. Would personally highly recommend it.

If you replace axe with chainsaw, you can’t expect it will perform better if you keep the same workflow of smashing the thing into the tree. To get the advantages you have to adjust your workflow, otherwise it will of course feel like an obstruction.

It's not the same because maintainable JavaScript code essentially always converts to maintainable TypeScript code. Adding type annotations to existing JavaScript code won't make it harder to maintain. However, maintainable TypeScript code will not necessarily convert to maintainable JavaScript code after removing the type annotations... Yet as well as TS can hide the tech debt and delay repayment thereof, it's still tech debt and you still have to pay interest on it.

Anti-patterns are the same in JS and TS; tight coupling and low cohesion is bad, complex interfaces are bad, unclear separation of concerns is bad, poor encapsulation is bad.

From British comedies, real gems are also IT Crowd and Black Books.

We thought the same and deployed KeyDB to production as a replacement for big Redis deployment (200+ GB memory) and we ran into many unpleasent issues with it - very high replication latency, instability, random crashes, memory leaks, etc. So I'd advise you to do thorough testing before you use it in production.

We start tests in the coming week. Current memory of Redis use is about 70gb. Thanks a lot for your comment. I hope to create a stable KeyDB environment as it would solve some of our problems we have with Redis replication. The issues you describe sound scary.

Would you be so kind as to share the results of your tests, please?

I think the key is just to find a activity that you love to do.

For me the gateway drug into being active was outdoor cycling. I've fell in love with exploring anything around me on the bike. Bike got me into the best shape of my life in my 30s and that just led me to enjoy many other activies like running, rowing, calisthenics, and yoga.