Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
yarcob
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
7 ms
·
31.
▲
by
yarcob
5y ago
I have decompiled AppKit on macOS occasionally to debug issues in my app. For example, in one case I discovered that double clicking a cell sometimes only selected part of the contents. With Hopper I was able to verify that the bug is that
32.
▲
by
yarcob
5y ago
I don't think most people buy iPhones because of Apple's draconian control of software distribution, I think they buy them despite of it. If Apple sold two iPhones, one that allowed only apps from the App Store, and one that allow
33.
▲
by
yarcob
5y ago
I published an app on the App Store, which did quite well in its niche. Soon, a bunch of very similar apps popped up. One app cloned everything about my app -- even the icon. But Apple didn't care. They don't give a shit when peop
34.
▲
by
yarcob
5y ago
Why did you quote my sentence without including the first part? It completely changes my statement. Apple and Google do not automatically install or run 3rd party apps from the store. If they did, then yes, obviously it would be their fault
35.
▲
by
yarcob
5y ago
> This is not the fault of devs If you include 3rd party software in your app, and that 3rd party software does something bad, then that's totally your fault.
36.
▲
by
yarcob
5y ago
The last time I went comparison shopping I figured Wirecard was a good deal. I even got a quote from them and planned to switch to them. But I was a lazy procrastinator, so I did nothing for a couple of months, and then all of the sudden I
37.
▲
by
yarcob
5y ago
In Austria banks switched from Maestro to Mastercard Debit to make online payments easier.
38.
▲
by
yarcob
5y ago
Summary for people who don't want to click a link: Some MacBook Pros get very hot when you use the USB-C ports on the left side for charging.
39.
▲
by
yarcob
5y ago
Ibuprofen is considered safe in the first half of the pregnancy, significant risks start only after week 28 [1]. It's also considered safe when nursing. [1]: https://www.embryotox.de/arzneimittel/details/ibupr
40.
▲
by
yarcob
5y ago
As a counterpoint, embryotox says that the studies linking paracetamol to genital defects show only weak correlations and are of questionable quality [1]. The links to ADHS etc are apparently even more tenuous -- one study apparently even f
41.
▲
by
yarcob
5y ago
Tesla has a lead now, but I wonder how long it'll hold up. At some point electric drivetrains and batteries will be available in large quantities from suppliers just like gasoline motors and gearboxes are available now. As soon as that
42.
▲
by
yarcob
5y ago
Kids under 6 are free on almost all public transport in Austria. For older kids there are a lot of discounts, but many of them are only cheap if you use public transport regularly. (eg. rail card family from the ÖBB for 19€ a year, or upper
43.
▲
by
yarcob
5y ago
If you do only one trip a year, then that trip costs 140€ (37 * 2 + 66) If you do the trip 10 times a year then it costs 81€ per trip (37 * 2 + 66 / 10). So in this case the occasional rider pays 59€ more per trip than the regular ride
44.
▲
by
yarcob
5y ago
It sounds cheap, and it's probably a good deal if you ride long distances or frequently. But when I recently planned a trip from Linz to Vienna for our family it would have cost around 120€ for the train (not including tickets for bus
45.
▲
by
yarcob
5y ago
That's one way to look at it. Another way: Every sunday hundreds of people drive from all over Austria to visit the zoo in Schönbrunn. They take the car because the train is way too expensive. If taking the train was cheaper then some
46.
▲
by
yarcob
5y ago
I still think it should be cheaper. The rail card thing is just a scheme to overcharge casual riders and tourists. It's reasonable for people who regularly go by train, but for people like me who do just one or two trips a year it feel
47.
▲
by
yarcob
5y ago
I think I remember a talk where someone manually set up logical replication with triggers and postgres_fdw to upgrade from an old server with zero downtime.
48.
▲
by
yarcob
5y ago
Why would you first upgrade to PG 10?
49.
▲
by
yarcob
5y ago
Depends on whether you can shut down the server for some time or not. If you can live with some downtime, just use pg_upgrade if you install the new server on the same machine: https://www.postgresql.org/docs/current&#x
50.
▲
by
yarcob
5y ago
Now if I only could remember how to convert a JSONB string to a normal string (without quotes)...
51.
▲
by
yarcob
5y ago
You are technically correct but the quote you are replying to is taken out of context and does not represent what this article is about.
52.
▲
by
yarcob
5y ago
Yeah, that hasn't changed. You can also use the pg_upgrade script instead of a full backup/restore, or use logical replication if you want to upgrade the db server with zero downtime, but upgrading PostgreSQL is still somewhat ann
53.
▲
by
yarcob
5y ago
I've never used PostgreSQLs large objects. You have to use this awkward API to use them, they aren't stored efficiently either, and as far as I can tell it's just a legacy feature that nobody has bothered to deprecate yet. In
54.
▲
by
yarcob
5y ago
> I understand that postgres is pretty decent at storing large binary data though? Storing large files in PostgreSQL is possible, but I would advise against it. PostgreSQL uses a technique called TOAST to store large objects. If you stor
55.
▲
by
yarcob
5y ago
Wouldn't a CNC mill (or even a manually controlled milling machine) be a better tool for fabricating keys? Brass is pretty easy to machine.
56.
▲
by
yarcob
5y ago
> and how are SUVs not safer, given they have more mass and a larger crunch zone? That helps in a head on collission with a smaller car. But it's even safer if you don't collide with anything in the first place. SUVs have longe
57.
▲
by
yarcob
5y ago
I love this. There are so many people who truly believe ridiculous bullshit with regard to driving. People have been telling me that SUVs are safer cars (questionable) or that higher powered cars are safer (highly questionable) or that driv
58.
▲
by
yarcob
5y ago
> Everyone I know uses YouTube as a de facto reference. They don't read blogs, Wikipedia, news articles or company documentation, rather they look for explainer videos or tutorials. This comes as a complete surprise to me because I
59.
▲
by
yarcob
5y ago
I thought the same thing when I found out about that, but it kinda makes sense. Facebook tries to show you the most "interesting" posts. If you are a member of many groups, there are probably too many posts in your groups to show
60.
▲
by
yarcob
5y ago
Facebook might pivot towards other monetization strategies when their cross-platform web tracking ads don't work anymore. For example, Facebook offers you to pay to "increase the reach" of your posts. This happens for example
More ›