Why you should care about the JDBC fetch size

[-]

henk53@reddit

Wonder why so many people here feel the need to declare how much they don't care about JDBC.

Do you also say that in every Python article if you're, say, a Go programmer? In every MySQL article if you use Postgres etc?

Probably not, right?

So why that obsessive need when it concern Java?

[-]

csman11@reddit

Some people got out of hell and don’t want to go back. Also, interesting example with the “Go programmer.” I don’t know if you heard but we don’t like Go either around these parts.

[-]

Schmittfried@reddit

Nah, Go has earned this reputation all on its own, just like Java (and really, by making the same mistakes as Java).

[-]

Halkcyon@reddit

It even made those same mistakes in the same order! (null, generics bolted on, etc.)

[-]

I generally agree, but if you don’t include a null, everybody will just invent their own, and then you have many nulls, and likely many nulls that won’t crash/panic your process like they ought to. Option types tend not to compose well without special-cased, ugly language-level kludges.

Besides, if you have a type lattice with a supremum type like Object or interface, it makes some sense to have an infimum type, and null is the reference/pointer infimum type’s value, undef. Of course, then it also makes sense to have invert types (e.g., anything except integers), but let’s not go there.

[-]

Schmittfried@reddit

Option types tend not to compose well without special-cased, ugly language-level kludges.

Functional languages would like to have a word with you.

But regardless, this is a solved problem even without optionals. Kotlin has had a safe infimum null type 14 years ago. To be fair, Kotlin is younger than Go, and it’s hard to introduce this retroactively (C# did tho), but I can‘t imagine Google didn‘t have access to the same inspirations and lessons learned that the Kotlin designers built their system on, given that they are just 2 years apart.

[-]

nekokattt@reddit

Some languages do that kind of thing more than others.

Mostly Rust, but still. It isn't uncommon, even if it is pointless behaviour.

[-]

sweetno@reddit

The article's author is just too pretentious.

[-]

Twirrim@reddit

It's a blog post on a site by the hibernate devs, specifically for Java developers (for those not familiar, hibernate is one of the most popular ORMs for Java).

Why is it pretentious, exactly? Developers using hibernate (the target audience for the blog) very likely should be at least aware of JDBC fetch size and the potential implications.

[-]

sweetno@reddit

The topic is just too oddly specific, especially for r/programming.

[-]

nerd5code@reddit

If you work at a bank, you probably do.

[-]

Fit_Smoke8080@reddit

Hating Java is popular. Which doesn't make sense when the ship everyone in the cargo cult jumps at is Go (practically the same dev experience as Java 21+, but at least around the same ballpark) Python (WTF) or an alternate JavaScript engine to V8 like Deno if lucky (better than Python at least). For everyone that whines C# and Kotkin exist but adoption doesn't match the aforementioned hate.

[-]

ConfidentProgram2582@reddit

cos of overengineered enterprise ™️ development

[-]

daidoji70@reddit

Well for me I think its just a funny title about a small little dial on a specific db driver for a specific language that seems to be particularly relevant to a particular use case on a particular database in the context of this article.

It would be equally funny if I wrote a Why you should care about sqlalchemy's default isolation level. I think these are the kind of details that you eventually learn or figure out when you're in a job where it matters and for everyone else the defaults are probably okay. The headline is sure to attract readers but in the greater scheme of things is just weird.

full disclosure: was once in a job where the default jdbc fetch size on Oracle did matter (among other database tuning parameters) quite a bit.

[-]

combinatorial_quest@reddit

Here I was thinking for a split second it was talking about the JSBC (JavaScript Startup Bytecode Cache) and then I became sad...

[-]

ryuzaki49@reddit

the default JDBC fetch size for the Oracle driver is 10.

Ten what?

[-]

ryuzaki49@reddit

Edit: I honestly dont know what the unit of fetch size is (guessing it's rows)

And the joke replies make me wonder if it's something so trivial every knows it but me, or people dont know as well.

[-]