In reply to Natta Wang. See: https://blog.jooq.org/2014/01/16/what-you-didnt-know-abou...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-291698
At 10, what the meaning of batch INSERT statement? Can you describe by example?
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-291695
In reply to lukaseder. "When you can't accept that your lovingly crafted code sucks a...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-155710
In reply to Michael Eriksson. I'm sorry for the confusion - you're right of course. Un...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-152624
In reply to lukaseder. For context, my reply was to a specific recent comment by Hick ...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-152561
In reply to Michael Eriksson. Thanks for your comments. What did you refer to when you...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-152554
In reply to Hick Kart. My best, possibly only, advice is dual: Do not be religious and...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-152532
In reply to Hick Kart. I can feel the pain. I often meet those "architects" as well, a...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-152514
I would like to get your thought on some Java guys keep saying DB agnostic design using JPA and spring data and not using any of DB features and write everything in Java. I am really facing strug...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-152510
In reply to AG. Sure, you're right. That was not the implication was not intended. The...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-151251
One thing I would like to highlight is that windows functions provide a different solution or rather solve a different requirement than aggregate functions. To just state this: "When you write a ...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-151250
In reply to Haakon. I completely agree with you. In fact, it would be nice if "ALL" wa...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-150355
I think that it would be better if UNION was not allowed, and we had to explicitly choose UNION ALL or UNION DISTINCT. That way code would be more explicit, easier to read, and since we read SQL ...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-150353
In reply to Phillip. Hah, yeah. You mean this, right? https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-97851
There is a SQL plugin for JQuery which solves most of the problems handling SQL these days. I am surprised you didn't mention it.
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-97845
In reply to Prashant.
You may want to look into GROUPING SETS
,
CUBE<...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-93467
In reply to lukaseder. Agree with most of the points but one "regarding data processing"...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-93453
In reply to Aaron Munted. You may get good answers to your question on the https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2634
How can save the database as a Java program? I have a large database consisting of dog names and sizes. I would like to export the database to save it as a Java program. I don't care if it is Jav...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2633
In reply to MarkW. That's true, of course. I guess what "autra" was trying to say is tha...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2435
In reply to autra. Oracle's SQL Developer provides compile-time checking, it is a powerf...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2433
In reply to Eduard von Feek (@EduardVonFeek). There's no golden rule to that. Surely, yo...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2323
Following some of the cures to the extreme, one could end up with an anemic Java domain model. Much business logic will take place in SQL statements, not in Java code. Is this good or bad?
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2322
In reply to Bill Karwin. Yes! I will put that in my next list of "10 Common Mistakes..."...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2321
In reply to autra. It goes both ways. There are certainly some advantages to using Java ...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2319
In reply to autra. OK, you're right. It depends, of course. But I've recently replaced h...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2304
I don't disagree with your point, but concerning this : "Simplicity. It’s probably easier to write correctly in SQL than in Java". This is just wrong. You will write better sql for things that...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2303
In reply to Michael Eriksson. Thanks for these interesting insights, Michael. I'd be ver...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2302
Many true statements. However, at least some of these problems arise partly through a wish to remain independent of the DBMS resp. the current SQL-dialekt. A prescription of ``only ANSI-SQL'' or ...
https://blog.jooq.org/10-common-mistakes-java-developers-make-when-writing-sql/#comment-2301