Hacker News: naranha

New comment by naranha in "PgAdmin 4 9.13 with AI Assistant Panel"

naranha — Tue, 10 Mar 2026 15:12:06 +0000

The only interface that works for me efficiently with LLMs is the chatbot interface. I rather copy and paste snippets into the chat box than have IDEs and other tools guess what I might want to ask AI.

The first thing I do with these integration is look how I can remove them.

New comment by naranha in "Kerberoasting"

naranha — Wed, 10 Sep 2025 14:44:15 +0000

It's still common in IT departments to enter the domain administrator password to join a computer to a domain or install software on a client machine. This seems insane to me, you can just fake the windows gui in a Fullscreen application and keylog the password - even using a web browser. I think AD is a relic of the 90s that should be retired

New comment by naranha in "New 16GB Raspberry Pi 5 on sale now at $120"

naranha — Thu, 09 Jan 2025 09:36:17 +0000

Now do one with ECC!

New comment by naranha in "Every V4 UUID"

naranha — Sat, 07 Dec 2024 07:01:10 +0000

If the browser has 1080 vertical pixels, the scrollbars has max say 1000 possible positions. According to my napkin math* if you scroll over 100 uuids per second it would take up to ~1.7 septillion or ~1 700 000 000 000 000 000 000 000 years to scroll to an uuid of which you know the position if you hit the spot exactly on the scrollbar.

* https://www.wolframalpha.com/input?i=ROUND%5B2%5E122%2F1000%...

Edit: Use 122 bit instead of 128 due to UUIDv4

New comment by naranha in "Writing Composable SQL Using Knex and Pipelines"

naranha — Thu, 28 Nov 2024 16:41:11 +0000

Not OP, but I have converted a couple of projects from knex to kysely recently. With Typescript kysely is much better. With kysely-codegen you can generate typescript types for a pre existing schema too.

New comment by naranha in "PHP Is Legacy, in 2024"

naranha — Sun, 24 Nov 2024 12:35:10 +0000

Stuff becomes legacy not because of the language, but because of outdated libraries or frameworks or unavailable/uninterested developers. For me PHP is legacy, because I refused to work on PHP codebases, except I find someone who's willing to do the job for me.

New comment by naranha in "MVCC – the part of PostgreSQL we hate the most (2023)"

naranha — Sun, 20 Oct 2024 20:14:03 +0000

At least couchdb is also append only with vacuum. So it's maybe not completely outdated.

New comment by naranha in "CouchDB 3.4.1 Released"

naranha — Fri, 27 Sep 2024 13:02:45 +0000

I build an internal project using CouchDB2 as a backend in 2017 and it's still used today. CouchDB definitely surpassed my expectations in what has been possible to do with it. Its biggest advantages are that data sync is effortless and that it uses HTTP as a protocol, so you can communicate directly with it from a web application.

New comment by naranha in "ULIDs and Primary Keys (2022)"

naranha — Fri, 12 Apr 2024 21:19:35 +0000

uuidv7 will be supported in PostgreSQL 17, at which point generation should be as fast as uuidv4, or if you implement it in pgsql now it will be as fast as the proposed ULID algorithm.

Insert performance could be even better, iirc for BTree Indexes monotonic increasing values are better than random ones, but feel free to correct me on that ;)

New comment by naranha in "My PHP Problems"

naranha — Mon, 19 Feb 2024 13:36:34 +0000

idk, when I want productivity I go with nodejs these days. lodash for some quick data crunching and pg or mariadb for db access using promises simply beats native php functions. with express you can spawn a http server in under 10 lines, while with php you need to setup apache/nginx or docker.

at some point in the past PHP was the most productive tool for some quick & dirty coding, but not anymore for me.

New comment by naranha in "AMD Ryzen 5 8500G: A surprisingly fascinating sub-$200 CPU"

naranha — Wed, 07 Feb 2024 19:04:01 +0000

In the graphics benchmarks it performs mostly worse than the 5600g/5700g. That's pretty disappointing 3 years later.

New comment by naranha in "UUID v7"

naranha — Mon, 05 Feb 2024 13:35:07 +0000

Does this stay compatible with the old uuid column type, as uuidv7() uses the same 128 bit format as gen_random_uuid()?

That would mean it's easy to update old apps, as we would only have to change the default value for the columns.

New comment by naranha in "Red Hat Enterprise Linux 10 Plans for Wayland and Xorg Server"

naranha — Wed, 29 Nov 2023 16:20:22 +0000

Awesome, this might be just what I needed! I need to run vscode and it seems to be possible if you launch it with --enable-features=UseOzonePlatform --ozone-platform=wayland . I'll play around with it the next days, thanks!

New comment by naranha in "Red Hat Enterprise Linux 10 Plans for Wayland and Xorg Server"

naranha — Tue, 28 Nov 2023 15:54:32 +0000

Remote desktop is not quite there yet it feels. It's the only reason to still use X imho.

New comment by naranha in "German Autobahn speed limit would bring €1bn in benefits"

naranha — Mon, 27 Nov 2023 13:42:02 +0000

Thanks for the statistics, that's interesting. It can also be misleading, from what I could find, less than 10% of traffic deaths occur on motorways vs. rural/city roads and motorway deaths have actually been decreasing in France steadily since 1990 (this is only from a quick Google search).

Edit: According to the OECD itf (random source I found on the internet ;)) Germany had 317 deaths on motorways vs 201 in France in 2022.

https://www.itf-oecd.org/sites/default/files/germany-road-sa... https://www.itf-oecd.org/sites/default/files/france-road-saf...

New comment by naranha in "German Autobahn speed limit would bring €1bn in benefits"

naranha — Mon, 27 Nov 2023 13:01:15 +0000

I'd take the French highway over the Autobahn any day. Yes it costs money, but people are driving in a much more civilized manner and they are well maintained.

New comment by naranha in "German Autobahn speed limit would bring €1bn in benefits"

naranha — Mon, 27 Nov 2023 12:41:57 +0000

I did similar trips through Germany when I was just old enough to drive. One time I was driving 200 in the left lane and a truck changed lanes just in front of me, because the driver didn't expect me to drive this fast.

I had to do an emergency break maneuver and almost crashed into the truck. Only then it dawned on me that driving this much faster than the other vehicles is very dangerous. To me it is completely nuts that this is allowed. If you want to drive fast, you can always drive on race tracks...

I rarely went over 130kmh since then, nowadays I mostly cruise at 100-110kmh, because it is the ecological sweet spot of my car and in general it's less stressful.

New comment by naranha in "Coordinated Disclosure: 1-Click RCE on Gnome (CVE-2023-43641)"

naranha — Wed, 11 Oct 2023 11:40:24 +0000

I guess it's fine as long as it isn't running in untrusted durectories. I'd take downloads out and documents in by default.

New comment by naranha in "Some Pixel owners still can't dial 911 during an emergency"

naranha — Sat, 30 Sep 2023 13:35:29 +0000

Thanks, I disabled it! I'm on the A52. I use the double tap feature often enough, but I guess I can live with the lack of convenience, thanks ;)

New comment by naranha in "Some Pixel owners still can't dial 911 during an emergency"

naranha — Sat, 30 Sep 2023 13:23:07 +0000

Well I have to now, because the screen also stopped working 90% of the time, except when I put it in the freezer for 15 minutes. Just 2 months that the phone is conveniently out of warranty. I guess it's the last Samsung Phone I'll ever buy.