Show HN: Writing SQL expressions using Java syntax | Hacker News Reader

Show HN: Writing SQL expressions using Java syntax

objsql.com

24 pointsobjsql13 comments

Open articleView on HN

How does it compare to JOOQ? https://github.com/jooq/jooq

Loooove this library.

That would depend on your chosen collation

`select.project(sum(orderTable.amount) / sum(orderTable.quantity) * 100)`

How does this work? I thought Java didn't have operator overloading. Are expressions represented as numbers somehow??

They use a java compiler plugin [1] (hence the need for IDE plugin). So you are writing java syntax but the code is not really java.

They are rarely used in java ecosystem and have a reputation for being fragile - I haven't tested whether this particular one for edge cases though.

[1] https://github.com/braisdom/ObjectiveSql/blob/master/core/sr...

Lombok is used in a lot of places.

A way to look at Graal is, "better Java compiler plugins."

Some stuff, like using checked exceptions as a function type system, is fragile.

Code weaving was always sort of the future. Look at the Javascript ecosystem. It's unavoidable. Not necessarily bad.

Anyway ObjectiveSQL should probably use an annotationProcessor to achieve the code weaving goals. Similar to Dagger.

    Member.execute(String.format("DELETE FROM %s WHERE name = 'Mary'", Member.TABLE_NAME));

That String.format looks dangerous, especially in a DELETE. Sure, it's a constant in this instance, but other examples use a parameterized ?, so this String.format jumps out.

This reminds me of EOF

https://en.wikipedia.org/wiki/Enterprise_Objects_Framework

It seems to use Hibernate which is the worst part of Spring/Boot/JPA. Unless it supports other persistence interfaces I wouldn't use it.

Just wondering, why use this over Spring + JPA? Does this support reactive data patterns or something? I don't see much in the way of differences. Just not sure what makes this different to what's out there

Haven't checked details. Does Spring Framework (Spring Data) binds well with this?

ObjectiveSQL is an ORM framework in Java based on ActiveRecord pattern, which encourages rapid development and clean, codes with the least, and convention over configuration.

Features:

1. With one annotation your Class has fully featured capabilities of SQL programming

2. Easy to relational(has_one, has_many and beglongs_to) query and paged query

3. Writing SQL expressions(arithmetic, comparison and logical) using Java syntax

How does performance compare to bare bones JDBC code? Specifically “select * from” a table with hundreds of rows.

Reply on news.ycombinator.com