Community

Chat Logs

Tuesday, April 28, 2026

00:29:32* kusanagi joined #java
01:11:37* X-Scale joined #java
02:16:13* ferdna joined #java
04:04:37* Aedil joined #java
04:12:30* mitch0 joined #java
05:59:23[twisti]databases ruin you for the world
06:00:01[twisti]there isnt a UI i can walk by without wishing for free where/order by input
07:32:46LaSombraI'd kill for any website that shows a list of things to have a DSL for querying
07:34:28* MikeBux joined #java
08:04:33* Ragnor joined #java
08:18:06* yamada joined #java
09:04:14* acidjnk joined #java
09:59:09* sepult joined #java
10:01:54* leppard joined #java
10:14:56* leppard|2 joined #java
10:35:40* agnivn joined #java
10:36:26* agnivn joined #java
10:38:20dreamreali wonder what that would look like
10:40:01Para0:0:0:0 TCP/5434
10:40:06Para5432 even
10:41:16dreamrealpffft, I'm serious
10:42:24ParaAll tabular views should init themselves from list of objects -> autoinject per-column filters and sorts.
10:43:27dreamrealThat's one optio. But would humans use it?
10:43:30dreamrealLike, actual humans?
10:43:52dreamrealMaybe it doesn't even matter, hmm, maybe I'm thinking of the problem the wrong way
10:44:30ParaSolution looking for a problem.
10:45:00ParaThat would work if one could somehow indicate such lists on page.
10:45:12ParaAnd then pattern apply the filter selector thingy on it.
10:47:03dreamrealWell, the website's raison d'etre has to come into play somewhere
10:53:41* Successus joined #java
10:59:34deebojust solve paging with offset and fetch n rows only
11:00:34deebodoes any rdbms support some sort of session / cookie for this? or some sort of cursor that can be navigated both ways without holding on to a connection for the duration
11:01:06ParaIt's a query strategy.
11:01:24ParaYou need to support temporal queries for stability, apply sorts, do offsets.
11:01:44dreamrealdeebo: you kinda need state as part of the process right now
11:02:09dreamrealso you can treat a website as a db-ish thing, semweb tried it, sort of
11:02:14dreamrealhave any of you used semweb?
11:02:23dreamreal(the question is its own answer)
11:02:38deeboi meant mostly to avoid overhead from offset scrolling to nth page
11:02:49dreamrealoffset scrolling isn't expensive in a decent db
11:03:02dreamrealdunno about sqlite, but pretty much every other db is fine
11:04:23ParaSELECT * FROM article WHERE valid_from <= $timestamp AND valid_until > $timestamp ORDER BY valid_from DESC, <other clauses> LIMIT 20 OFFSET 40; -- or whatever is your pagination size and offset etc.
11:05:24ParaAnother strategy is to cut queried results based on last id from previous page set and then taking next n results based on page size.
11:06:55dreamrealThe good news about that approach is that you've limited your users to the four who understand SQL *and* your site's data model.
11:07:43ParaGood, no wasted resources on idiots,.
11:09:04dreamrealand the site better be a passion project for the author forever, because it's not going to get monetized unless it's selling something, which makes the model untenable in the first place :D
11:11:38deeboif you can get index coverage for any combination of filters to avoid table scans it's fine
11:12:00deebogimme lucene/(open|elastic)search "tables" in my postgres
11:12:11dreamrealgood news, you already have them :D
11:13:09dreamrealif you're using postgres you really don't need lucene except for the query language, if that's useful to you
11:13:12deeboi tested some text search thing with one "backoffice" solution, but a covering index ended up being better and easier to reason about
11:13:21dreamrealsure
11:14:18dreamreallucene, solr, ES are all good bridges to scanning for data; if you really wanted to query it deeply you'd use sparql and rdf, but there's a reason people know about sparql and rdf and they don't know sparql and rdf themselves
11:33:15* agnivn joined #java
11:35:56* x1bncwn joined #java
11:42:24* gustik joined #java
12:52:48* GreenResponse joined #java
13:17:37* Successus joined #java
13:27:19* jamezp joined #java
13:29:03* computerscience joined #java
13:29:14computerscienceshould I use java or node
13:30:05julemand101computerscience: For what problem?
13:30:43computersciencegetting a graduate developer job in sydney
13:31:57julemand101I mean, would it not be better you do a research into opening job offerings in your area to see what they look for?
13:48:15ParaOr if you're interested in some specific field, one might be generally favored over another.
13:48:23ParaOr if your interests match better with specific ecosystem.
13:51:45* szkl joined #java
14:16:23dreamrealcomputerscience: depends on for what, but honestly: node
14:17:46computersciencewhich node framework
14:17:53dreamrealnextjs
14:18:09computerscienceI thought express was better
14:18:18computersciencemy university taught us express
14:18:27computersciencemaybe because it's basic
14:18:38dreamrealdude, you're in #java, asking a question like that. I don't care what you use. If node is an option, the mechanics are broken. Use something else, not our stuff.
14:19:14dreamrealnode and java are not on the same playing field; it's like saying "I have the choice between an f1 and a ford truck. Which one shoudl I use?"
14:19:24dreamrealThe question itself is a category error.
14:21:58dreamrealYou wouldn't want an f1 car if you're carrying a load of cordwood. You wouldn't use an F150 on an f1 track.
14:22:48dreamrealif the f150 is an option, then gosh, make the choice and live with it. Node is easy. Asking the question makes it sound like that's a viable metric to use for you. (Java's easy, too, but in completely different ways.) Use what works for you.
14:24:01* kcomhnall joined #java
14:24:14* mixfix41 joined #java
14:52:43* stewi joined #java
15:02:46* TomyWork joined #java
15:34:58* sepult joined #java
15:49:08* stfstfm_ joined #java
15:58:59* raj joined #java
16:17:06* MikeBux joined #java
16:19:09* stfstfm joined #java
16:21:55* ferdna joined #java
16:26:49* MikeBux joined #java
16:45:08* stfstfm_ joined #java
16:49:09* stfstfm joined #java
16:50:55* stfstfm__2378 joined #java
17:04:24* mitch0 joined #java
17:20:54* stfstfm joined #java
17:31:05* stfstfm_ joined #java
17:35:34* P1RATEZ joined #java
17:35:36* pr070cal joined #java
17:48:57* stfstfm joined #java
17:49:20* stfstfm_ joined #java
18:07:00* sa02irc joined #java
19:29:02* rvalue- joined #java
19:33:46* emaczen joined #java
19:42:59* x1bncwn joined #java
19:54:33* agnivn joined #java
20:40:27* geenvoud joined #java
21:25:57* jamezp joined #java
21:31:46* pr070cal joined #java
21:51:58* mindCrime joined #java
22:08:22* IceMicha| joined #java
22:14:57* Cyp joined #java
22:22:50* agnivn joined #java
22:57:27NeXeNwhy does bytebuddy throw errors and still build properly ?
22:57:44NeXeNi mean, i see stack traces, but it's just a debug thing in hibernate, but wtf, like i always wondered about that
23:07:40NeXeNit offends my sense of ocd
23:23:32jreicherThat is curious. What's the error?
23:32:55* zorone joined #java
23:36:09* Cyp_ joined #java
23:38:45* Cyp__ joined #java
23:45:03* zorone joined #java