4 ms·

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 separ

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.

sgarland 3y ago
> 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).
leetharris 3y ago
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.
- sgarland 3y ago
  Until Prisma can manage JOINs [0] there is no way I can recommend it. [0]: https://github.com/prisma/prisma/discussions/12715 https://github.com/prisma/prisma/discussions/12715
  - kkarimi 3y ago
    The support for JOINs is coming, currently under a feature flag [0] [0]: https://github.com/prisma/prisma/issues/5184#issuecomment-1843505785 https://github.com/prisma/prisma/issues/5184#issuecomment-18...
- mkesper 3y ago
  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/generating-down-migrations https://www.prisma.io/docs/orm/prisma-migrate/workflows/gene...
chasd00 3y ago
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.

sgarland 3y ago

> 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).

leetharris 3y ago

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.

sgarland 3y ago
Until Prisma can manage JOINs [0] there is no way I can recommend it. [0]: https://github.com/prisma/prisma/discussions/12715 https://github.com/prisma/prisma/discussions/12715
- kkarimi 3y ago
  The support for JOINs is coming, currently under a feature flag [0] [0]: https://github.com/prisma/prisma/issues/5184#issuecomment-1843505785 https://github.com/prisma/prisma/issues/5184#issuecomment-18...
mkesper 3y ago
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/generating-down-migrations https://www.prisma.io/docs/orm/prisma-migrate/workflows/gene...

chasd00 3y ago

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.