News for hackers. Stuff that matters.

A comment on /story/39313623. Parent comment

Re: by calvinmorrison on Friday February 09, 2024 @08:46PM (#39322710)
It's because I hate databases and programming separately. I would rather slow code then have to dig into some database procdure. Its just another level of separation thats too mentally hard to manage. Its like... my queries go into a VM and now I have to worry about how the VM is performing.

I wish and maybe there is a programming language with first class database support. I mean really first class not just let me run queries but almost like embedded into the language in a primal way where I can both deal with my database programming fancyness and my general development together.

Sincerely someone who inherited a project from a DBA.

[ Parent | on HN ]
Re: by sgarland on Friday February 09, 2024 @09:05PM (#39322830)
> I mean really first class not just let me run queries but almost like embedded into the language

Not quite embedded into the OS, but Django is a damn good ORM. I say that as a DBRE, and someone obsessed with performance (inherent issues with interpreted languages aside).

[ Parent | on HN ]
Re: by leetharris on Friday February 09, 2024 @10:15PM (#39323223)
The closest thing to what you're describing is Prisma in Node. It generates a Typescript file from your schema so you get code completion on your data. And it exists somewhere between a query builder and a traditional ORM.

I have worked in many languages with many ORMs and this has been my personal favorite.

[ Parent | on HN ]
Re: by sgarland on Saturday February 10, 2024 @12:01AM (#39323741)
Until Prisma can manage JOINs [0] there is no way I can recommend it.

[0]: https://github.com/prisma/prisma/discussions/12715

[ Parent | on HN ]
Re: by kkarimi on Saturday February 10, 2024 @01:38AM (#39324124)
The support for JOINs is coming, currently under a feature flag [0]

[0]: https://github.com/prisma/prisma/issues/5184#issuecomment-18...

[ Parent | on HN ]
Re: by mkesper on Saturday February 10, 2024 @08:00AM (#39325870)
But the migration stuff is a horrible joke. No way to just rollback a broken migration. https://www.prisma.io/docs/orm/prisma-migrate/workflows/gene...
[ Parent | on HN ]
Re: by chasd00 on Friday February 09, 2024 @10:36PM (#39323333)
The language you’re talking about is APEX. I believe it comes from Oracle and is the backend language for Salesforce development. You’ll like the first class database support but that’s about it.
[ Parent | on HN ]