danolivo

Joined 2 years ago

Karma
9
Submissions
11
Member since
Apr 14
PostgreSQL contributor, Scientist
View on Hacker News

Recent submissions

Comment · 7 days ago
There are always bugs in the code - AI is just a little more powerful tool to detect them. For me, the main outcome of a bug is whether it is a security breach or it exposes the need to change the whole architecture. In current Postgres, AI hasn't found such significant bugs yet.
Comment · 11 days ago
Yeah, 2010: CAE Modelling; 2015: blockchain; now: AI... All these technologies need more and more energy. Given that people are conservative and switch off older, energy-consuming technologies more slowly, this looks like a major challenge.
Comment · 11 days ago
I agree to some extent, but the technology is still early-stage and doesn't scale as well as fossil fuels. The quadratic dependence of emitted energy on surface area isn't necessarily bad, though it does raise some questions.

I hope it is not a strict limitation for the technology ...

Comment · 11 days ago
Good move!

I often need an alternative interface to the mouse and keyboard. For example, when I want to sketch out an idea. Finding a whiteboard or paper every time isn't easy. So, thanks, Apple. I just hope they'll update the hinge between the monitor and keyboard so I can use it as a tablet. If they do, I'll buy it right away.

Comment · 11 days ago
Yeah, nice article that makes me think the civilisation that wants to survive longer should rely on more fundamental energy sources, like solar radiation, rather than byproducts of evolution.
Comment · 3 months ago
A while back, I noticed that using Claude all day left me feeling mentally tired. After thinking it over, I realised the problem was Claude’s complex language. I’ve used English daily for years, so that shouldn’t be an issue. To compare, I switched Claude to my native language and had the same problem the author described. The text still needed to be literally deciphered before I could understand it. After talking with Claude, I updated the settings to ask for simpler language and less dense information. Natural language works better with some entropy in the text. This change has made things easier.
Comment · 2 years ago
For me, the key idea of this paper was that relational model & SQL are successful because of the key feature: 'compact and accessible form' of a query.
Comment · 2 years ago
Hmm, I found it quite debatable. IMO, they are too bonded to the opinion that everything will remain almost the same in database UI and use cases. Looking around at how eagerly analytics employ AI-generated queries, I wonder if they have any arguments to support this standpoint.
Comment · 2 years ago
The big problem of serials is their monotonic grow. Each time adding new record you go beyond statistics boundaries and challenge PostgreSQL to guess..
Comment · 2 years ago
Having creation advice, the extension obviously must provide candidates to delete and, less obvious, candidates to merge some indexes.
Comment · 2 years ago
The term ‘slow’ is too relational and not strong. I guess, we should look up for queries, which can be potentially faster - see into estimation errors or number of data pages involved into the query.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton