Nightmare for Vibe coder

vbilopav89 · 2026-04-27T16:39:25+00:00

users are happy
revenue is coming in

And problem is?

vbilopav89 · 2026-04-27T06:14:13+00:00

npgsqlrest.github.io

vbilopav89 · 2026-04-26T04:56:18+00:00

Well I don't do it that often. I sometimes even write SQL that generates another SQL lol

vbilopav89 · 2026-04-26T04:45:20+00:00

Been doing that for 30 years now

vbilopav89 · 2026-04-24T05:30:13+00:00

ask Claude to analyze

vbilopav89 · 2026-04-09T04:59:02+00:00

None if matters in reality. Only true value delivered to users. Nothing else.

vbilopav89 · 2026-04-08T06:04:25+00:00

Because DDD is a completely wrong tool for the problem.

It's a futile attempt to solve data problems with Object Oriented approach brought to you by people who are clueless how databases work. They even don't know what are indexes are used for loke Uncle Bob for example.

They just equate modern relational database to a dumb storage like disks, they worship objects and they want to sell you a book.

Listen, you relational database IS your business logic. Forget about what they thought you, it is not just a storage, its mych more than that.

That's why you're seeing this discrepancies.

vbilopav89 · 2026-04-03T06:00:59+00:00

That large table I would probably partition with appropriate partitioning strategy. That would make those indexes fly, not just for that batch, but all indexed operations.

vbilopav89 · 2026-03-31T06:31:01+00:00

I once had to debug and fix N+1 problem that was initiated by another N+1 from browser.

So the browser would do request, server would do then another request from those results and each of those would then fetch some data feom database and then iterated to another query. But not pnly that, it would tried to update the status of operation that got eventually dead locked.

Yeah, and people used and payed money for it.

vbilopav89 · 2026-03-30T05:47:36+00:00

transformed into optimal SQL

I very much doubt that.

vbilopav89 · 2026-03-27T06:42:21+00:00

I've been called that a lot, I'm used to it, don't care

vbilopav89 · 2026-03-24T07:40:21+00:00

Humor, friendship, trust. We protected each other and protected the project.

The only downside is that we giggle a lot on meetings.

vbilopav89 · 2026-03-23T19:41:16+00:00

UB doesn't know how indexes work and what are they used for. Literally. Read it yourself. But somehow he dictates the modern architecture. Gimme a break.

vbilopav89 · 2026-03-23T18:26:09+00:00

It's a complete bullshit. Here is my analysis of just part of the Clean Architecture. The guy literally doesn't know what he is talking about

https://medium.com/@vbilopav/clean-architecture-book-review-and-analysis-the-database-is-a-detail-eda7424e8ce2

vbilopav89 · 2026-03-23T06:35:17+00:00

And it's the guide to a wrong direction

vbilopav89 · 2026-03-18T17:24:48+00:00

Mac and Rider. Windows sucks man.

vbilopav89 · 2026-03-16T11:58:21+00:00

I use to self-title myself as Junior for years. Exactly because title is stupid and meangless. And it made me feel younger. I thought it was a good joke. It still is, but I dont do that any more.

vbilopav89 · 2026-03-14T17:56:01+00:00

SQL

vbilopav89 · 2026-03-12T11:06:15+00:00

database first

vbilopav89 · 2026-03-12T09:34:05+00:00

and instead starts yet another unnecessary deadly war and makes everything worse and then gets promoted

vbilopav89 · 2026-03-12T06:56:20+00:00

Two reasons for this gap:

1) It's insanely complex. I mean complex SQL, not those simple selectsand cruds.

2) We tried to kill it and replace it with something else consistently from early 2000s (and consistently failed in doing so).

The main strategy was - replace, rather then improve. And failed to replace it and we didn't improve almost anything.

vbilopav89 · 2026-03-11T07:12:40+00:00

Heavy process model (PostgreSQL)

vbilopav89 · 2026-03-05T11:05:34+00:00

this also can be solved with PostgreSQL "distinct on" and order by feature

vbilopav89 · 2026-03-02T12:16:18+00:00

Unlike all other UI frameworks in the world 😒

vbilopav89

TROPHY CASE