3 ms·
> Side by side example comparing jOOQ to SQL. A great way for me to quickly see if I like their DSL design. I'm always astounded how many times this is neglect
by lawpoop 11y ago
> Side by side example comparing jOOQ to SQL. A great way for me to quickly see if I like their DSL design.
I'm always astounded how many times this is neglected. It seems pandemic.
I live in the PHP world, and it seems that every hot new framework wants to do its own SQL re-hash. They always seem created by programmers who either hate SQL and want to avoid it as much as possible in favor of OO paradigms, or have never used it beyond its basic features.
Sooner or later, I'll find myself wanting to do something moderately complex, like delete through a join, and all of a sudden the interface breaks down. I'll scour the internet or ask a question, and it either can't be done, or relies on some arcane, poorly documented part of the API, or uses weird, unintuitive syntax that makes you wonder if the API is any improvement over plain SQL at all.
- pbowyer 11y ago> I live in the PHP world, and it seems that every hot new framework wants to do its own SQL re-hash. They always seem created by programmers who either hate SQL and want to avoid it as much as possible in favor of OO paradigms, or have never used it beyond its basic features. Agreed. I don't use PostgreSQL and haven't got my head around it fully, but have you seen http://www.pomm-project.org/ http://www.pomm-project.org/ ?