Hacker Newsnew | past | comments | ask | show | jobs | submit | ololobus's commentslogin

Does it require core patches or I can install it into the standard upstream Postgres? Asking because, afaik, it did, but it might that something has changed already.


It still requires some patches to the Table Access Method API which have been submitted upstream:

https://www.orioledb.com/docs#patch-set


Interesting point of view, didn't know about Jevon's paradox before. To me, the outcome still depends on whether AI can get superhuman [1] (and beyond) at some point. If it can, then, well, we will likely indeed see that suitable-for-human areas of the intellectual labor are shrinking. If it cannot, then it becomes an even more philosophical question similar to the agnosticism beliefs. Is the universe completely knowable? Because if it's not, then we might as well have an infinite more hard problems, and AI just rises a bar for what we can achieve by paring a human with AI compared to just human alone.

[1] I know it's a bit hard to define, but I'd vaguely say that it's significantly better in the majority of intelligence areas than the vast majority of the population. Also it should be scalable. If we can make it slightly better than human by burning the entire Earth's energy, then it doesn't make much sense.


I'd totally agree with this point if we assume that efficiency/performance growth will flatten at some point. For example, if it gets logarithmic soon, then the progress will grow slowly over the next decades. And then, yes, it will likely look like that current software developers, engineers, scientists, etc., just got an enormously powerful tool, which knows many languages almost perfectly and _briefly_ knows the entire internet.

Yet, if we trust all these VC-backed AI startups and assume that it will continue growing rapidly, e.g., at least linearly, over the next years, I'm afraid that it may indeed reach a superhuman _intelligence_ level (let's say p99 or maybe even p999 of the population) in most of the areas. And then why do you need this top of the notch smart-ass human biologist if you can as well buy a few racks of TPUs?


Because only the biologist knows what assays to ask the super human intelligence for. And how the results affect the biomolecular process you want to look at.

If you can’t ask the right questions, like everyone without a phd in biology, you’re kind of out of luck. The superhuman intelligence will just spin forever trying to figure out what you’re talking about.


Love it. I do very occasional birdwatching, so I still don’t know most of the birds I meet. What I like about Bird ID is that when I see in binoculars a singing bird I can quickly identify it, check photos, and really confirm that it’s exactly that bird.

I’ve heard from more experienced birdwatchers that it can false identify in some cases, so I always try to confirm visually, but anyway, for my casual use it’s more than accurate enough.


The title and overall ‘take’ are very broad, it starts with

> It’s well known that video games today are disposable pieces of slop.

But then it falls mostly into multiplayer games. For the latter, I will probably agree that old multiplayer games were more decentralized and self-sufficient just because distribution was also less centralized back then.

Yet, overall, I tend to disagree because of several reasons:

1. Video games market is vastly larger than 20-30 years ago. That’s why we see more crappy games, but there many-many good games as well

2. Back then there were bad games as well. YouTube is full of videos where gamers walkthrough some old games. And many of even popular titles are literally a broken piece of crappy tech demo with broken mechanics, soft locks, bugs, etc.

3. Outside of MMMO, F2P and multiplayer there numerous great games nowadays. Indie developers are very strong. Games like Buldur’s Gate 3 have a non-imaginable quality and amount of content for 2000s game industry. It’s a matter of personal choice, but I can name dozens of titles for the past 10 years or so, that are really great.

UPD: formatting


I was wondering how cartridges are designed and I think it’s a very simple and elegant design — just wire the standard microSD card. Otherwise, I love such cozy projects. Even if they are not that efficient, they solve the problem and bring joy into someone’s life, both author’s and a small user (in this case).


I can only second this. I have an old iPhone with a second sim-card, because I need it from time to time. And Apple introduced this auto-reboot a bit earlier, iirc last year. The problem is that after rebooting it also disconnects from wifi, so e.g. SMS/handoff synchronization stops working until you enter a passcode. This is very annoying because it was very convenient for me to receive calls/SMS to my main iPhone.

It’s a good and reasonable feature, especially if for some reason you are afraid of state or security agencies in a place where you live, or maybe during travel. It’s still questionable, because in some states you can indeed go to jail if you don’t unlock. Yet, I really want to be able to turn it off for use-cases like mine.


Apple doesn’t like supporting the use case of multiple phones for one person. They even encourage their employees to use their personal devices and accounts.


That is very reasonable advice for the vast majority of people.

I have to have 3 devices: mine, work and a shared one for travel that crosses customs boundaries. It’s a massive pain in the ass.


>It’s still questionable, because in some states you can indeed go to jail if you don’t unlock. Yet, I really want to be able to turn it off for use-cases like mine.

Even if the end result is the same, anything that forces authorities to use official power over informal power is a net win.


> Parameterized queries.

Also happy to be wrong, but in Postges clients, parametrized queries are usually implemented via prepared statements, which do not work with DDL on the protocol level. This means that if you want to create a role or table which name is a user input, you have a bad time. At least I wasn’t able to find a way to escape DDL parameters with rust-postgres, for example.

And because this seems to be a protocol limitation, I guess the clients that do implement it, do it in some custom way on the client side.


Just because you can, doesn't mean you should. But if you must, abstract for good time.


I got mine at the end of 2021 and then used it till the mid-2023.

I know that it’s not a fair comparison, but I still compare it to macbooks because I’m a mac user for years.

Pros

- Linux support is amazing, basically you just install one of the popular distros and ‘it works’ (c). I used PopOS and was pretty happy. You also get all the Linux tools like eBPF out of the box, which is +1 compared to mac.

- Extensibility is a big deal. You can get 1 TB / 32 GB version for pennies compared to mac, where upgrades from the base are ridiculously expensive.

- Design and look is very neat.

- Keyboard is a classic one and also good.

Cons

- Battery life is really bad; same with cooling. At some point I started having more meetings at work and it gets extremely hot, noisy, and dies very quickly.

- Touchpad is just subpar to mac. Also chassis rigidity is meh. I know they improved the display cover design (switched to CNC), but I have the first revision.

- Display is 2K’ish. I don’t really understand, why they go with this resolution. Even their new display is around 2.5K. IMO, Linux works best either with 1080p/1K or 4K with x2 scaling (I prefer the latter) because fractional scaling is bad. I struggled a lot with external 4K monitor because it was nearly impossible to adjust all sizes so texts were good on both and especially when you disconnect and go portable. I know it’s Linux and you can DIY everything, but for me it was just too much of a headache.

I still fully support this company and wish them all the best, but since getting the MacBook Pro 14 with M2 (company’s, not personal) in the mid-2023 my Framework is waiting for two things: i) 4K display module; and ii) ARM main board. If they release these upgrades I will jump into Framework right away and give it another try.

So I recommend it if Pros are more important than Cons for you.

UPD: formatting and conclusion


I hear it all the time ‘coding interviews are useless’, ‘peer review in scientific journals is broken’ and so on and so on.

I’d say yes and no.

Yes, these are the problems that cannot be solved perfectly.

No, because in such areas any ‘reasonable’ filter is better than nothing. People say that these assignments don’t have anything with reality, but, well, we don’t have months to try to work with each other, we only have 3x1h.

I worked as individual contributor for years, but also had a chance to try a hiring manager role for the past 3 years a lot. We do standard leetcode-style interview (without hardcore) + system design. And I always consider both as a starter and bite to see how the candidate behaves; talks; do they ask questions to clarify something and how. And I always try to help if I see that candidate is stuck. By the end of all interviews you will have some signal, not a comprehensive personality profile. Do we do mistakes? I’m pretty sure, yes. But I think it just works statistically.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: