HNHacker News
TopNewBestAskShowJobs

phartenfeller

753 karma · joined November 10, 2020

Location: Germany

Mainly working with Databases and the Web.

Contact: contact-hn (at) hartenfeller.dev

submissionscomments
phartenfeller··on JavaScript Trademark Update
I think you underestimate the impact of their database on the world. They were a huge tech innovator in that part (and actually still are).
phartenfeller··on New EU rules on digital accessibility to come into force
It can definetly help, like with describing images that have no description. But I doubt it can deliver good and consistent results to make whole websites accessible where developer have paid no attention to this topic at all.

From an efficiency standpoint it would be way better when devs run this once and not every visitor.

phartenfeller··on Show HN: PLJS – JavaScript for Postgres
Interesting. This is now the second DB next to Oracle[1] that can do JS (that I know of). pgSQL and PL/SQL of course still stay relevant but in the Oracle spehere the argument is that you can reuse existing code from NPM. Like this blog post [2] describes how to run an GraphQL endpoint from within the DB.

[1] https://docs.oracle.com/en/database/oracle/oracle-database/2... [2] https://blogs.oracle.com/developers/post/creating-a-graphql-...

phartenfeller··on Show HN: Aberdeen – An elegant approach to reactive UIs
Not for me as I like looking at actual HTML but definetly intersting. Good job!

I also like Svelte which uses it's own language and needs transpilation. I think that's key to elegance as JS was not really designed to control layout, style and logic all at once.

phartenfeller··on All four major web browsers are about to lose 80% of their funding
I think browsers are in the best state to slow down their development rate. They have come so far, it is the most uniquitous application ecosystem nowadays. Even though there are still great developments currently, they are rather niche and it would be way more damaging if it slowed down 10 years ago. Maybe financial constraints also have a positive side. TL;DR the web ecosystem has matured a lot.
phartenfeller··on Andrej Karpathy on the State of Web Development
It's always the same. Big internet giants having really unique issues: scaling with millions of users at the same time, micro optimizations as they have a big impact because of the scale. So they need to really complicate things like distributed systems, eventual consistency, and unique UX etc.

They do a good job about it and want to share it so they publish their story. Now people from other companies read this and think that this is now state of the art and they also should do this. But they don't even have the same issues.

I work with a Low Code framework from Oracle (APEX) that literally runs in the database and serves web apps. Want a report and form on a table? Click create new app and xreate page, select the table, customize labels, maybe move things around, maybe change an item from type text field to select list with another query and done in 5 minutes. With lost update detection, easy authorization control, automatic validations for your table constraints, etc. You can still code data processing procedures but why reinvent the wheel for another web UI?

People just choose to overengineer backend apps that only 50 people use...

phartenfeller··on Rost – Rust Programming in German
That is certainly one way to look at a fun project...
phartenfeller··on Ask HN: With trust in Firefox gone, is Chrome-ish the only option?
It has since a few days : https://www.omgubuntu.co.uk/2025/03/kag-orion-web-browser-co...
phartenfeller··on I've been using Claude Code for a couple of days
I tried it too and tasked it to do a bigger migration (one web framework to another). It failed pretty bad where I stopped the experiment. It still gave me a headstart where I can take parts and continue the migration manually. But the worst thing was that it did things I didn't asked for like changing the HTML structure and CSS of pages and changing hand picked HEX color codes...

More about my experience on my blog: https://hartenfeller.dev/blog/testing-claude-code

phartenfeller··on Knowing CSS is mastery to front end development
For me TailwindCSS actually was helpful in learning CSS. You still apply the same core CSS fundamentals. If you created a complex layout in Tailwind, you can also do it in normal CSS. I look up the exact rules behind their classes frequently in their docs.

If you just copy classes and don't care to understand them, it's a different story of course.

phartenfeller··on Microsoft won't support Office apps on Windows 10 after October 14th
Good, I hope this brings companies to change their setup. Office competition is strong, MS office is a huge and costly vendor lock in. Also many ransomware attacks start with someone allowing macros or clicking on a link in Outlook.
phartenfeller··on All Garmin Connect services are down
Well, nobody needs anything 100% of the time besides oxygen. But if you pay a lot of money for a watch because it has certain features backed by services, I would definitely hope that I can actually use them when I want to.
phartenfeller··on A story on home server security
There are ton of hobby VPSes with a simple website, CMS, email server, or maybe a Plex. Do you really think that these kind of scenarios should use a bastion host?
phartenfeller··on A story on home server security
A lot of people comment about Docker firewall issues. But it still doesn't answer how an exposed postgres instance leads to arbitrary code execution.

My guess is that the attacker figured out or used the default password for the superuser. A quick lookup reveals that a pg superuser can create extension and run some system commands.

I think the takeaway here is that the pg image should autogenerate a strong password or not start unless the user defines a strong one. Currently it just runs with "postgres" as the default username and password.

phartenfeller··on Advent of Code 2024 in pure SQL
I definitely see how this happens. SQL is easy to start with but sup hard to master. And it requires good data models.

But if both are fine there is no way that any native code will be faster than a database. No network latency, set operations, index usage, etc. DBs have all the the info to make data access fast.

phartenfeller··on Advent of Code 2024 in pure SQL
Nicely done. I know this seems crazy at first but in my opinion big SQLs are one of the best ways to store complexity.

The problem being complex is the issue. SQL is a standard, condensed, extremely performant, actually testable, and logical language. Sure, not anybody can instantly maintain it but that would be the same as if it was a lot of lines and functions in Java. The more lines the more risk for bugs.

I also love how deep SQL goes. And that makes totally sense. It powers the world of data since 40+ years so of course people asked for niche features. One of my favorite is the model clause in Oracle with which you can implement multidimensional arrays. A friend implemented Conway's game of life with it in way less lines you expect.

phartenfeller··on Databases in 2024: A Year in Review
There is a lot about Larry Ellison, but not a single word about this year's rather big Oracle release (23ai)?
phartenfeller··on Casual Viewing – Why Netflix looks like that
Definitely not surprising. The quality of Netflix originals is on a decline for years. I see this label as a warning nowadays. There are enough good quality movies and shows. My life is too short to spend it with mediocre entertainment that leaves no lasting impression or thoughts. I don't need to pass time I want to make most out of it.
phartenfeller··on Review of Mullvad VPN
Why do you think Astrill is one of the best? And why do you think it is better than Mullvad?

I trust Mullvad because it does security audits like this. And it stores no data and has a history of police showing up without any data compromised [1].

[1] https://mullvad.net/en/blog/mullvad-vpn-was-subject-to-a-sea...

phartenfeller··on Rails is better low code than low code
> imagine they'd take the same view today to home made LLM-generated Rails apps.

Sounds like an effective solution. Even though some people might build a great application, but someday they might leave, and nobody knows how to administer this.

You can still write bad PL/SQL code, but at least everything is centralized and stored in a single database where you have an admin making sure that everything is fine. For other developers, it is straightforward to make small changes because 95% of the complexity just lies in the data model and the database code. You don't need to adapt to a specific infrastructure, frameworks and other dependencies, etc.

phartenfeller··on Rails is better low code than low code
> It also makes it so easy to create opportunities for SQL injection if you don't have careful coders.

This is not the case. If you bind values with :ITEM_NAME and use compiled statements (never dynamic string concatenated ones with "execute immediate') there is no chance of SQL injection.

phartenfeller··on Rails is better low code than low code
Yes, it similarly just builds around developers storing the code in the database layer. Forms is still around, with some giant companies relying on it, but of course, it is slowly dying. APEX is also 20 years old already, but based on the web stack. This choice aged perfectly, so it went from a niche inside Oracle to now the default application framework inside Oracle around 2020. Oracle Forums[0] is build on APEX for example.

[0]https://forums.oracle.com/ords/r/apexds/community/home

phartenfeller··on Rails is better low code than low code
Even though it is Oracle, Oracle APEX is exceptional at creating CRUD applications. The main benefit to other low code tools is that it doesn't want eliminate code but just the repetitive UI code. It still expects you to have skills in database development so you can achieve everything but generating a Report, Grid or Form from a SQL query takes as long as you need to write the query. And everything is customizable and maintainable in the end.
phartenfeller··on Show HN: It took me 5() months to build a Plausible alternative
This definitely depends on the use-case. But not having to rely on a foreign service and owning your data is huge for many people. Additionally slack is super expensive for a paid tenant that does not delete your chat history. And some day in the future Discord will surely enshittify their free options too.
phartenfeller··on Show HN: It took me 5() months to build a Plausible alternative
...and campfire, a one time fee slack alternative. Are people allowed to change their views?
phartenfeller··on Toasts are bad UX
Strongly agree. I guess toasts work better for mobile screens as they are smaller and mostly vertical, so the element spans the whole screen width. If it needs to be there and should be responsive, I would prefer it to be an alert in the upper-right corner of big screens.
phartenfeller··on Firefox Sidebar and Vertical tabs: try them out
A screenshot of how it looks would have been helpful. I guess this is in response to Arc browsers design. https://arc.net/
phartenfeller··on The US fiscal mess: Some unpleasant fiscal simulations
Money growth and inflation has no direct connection. It can impact it but doesn't have to. In europe the inflation was caused by the supply chain crisis: https://www.ecb.europa.eu/press/key/date/2023/html/ecb.sp230...

Additionally some experts say that the inflation was bigger in Europe because the governments didn't do investments with new debt.

phartenfeller··on Node.js adds experimental support for TypeScript
There is an EcmaScript proposal to go in that direction: https://github.com/tc39/proposal-type-annotations

I think this should be part of the language spec.

phartenfeller··on No More Blue Fridays
Why trust somebody else not messing up? With that in place for windows and crowdstrike billions of dollars would be saved and many lives not negatively impacted ...
← PreviousPage 2 of 5Next →