Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
acatton
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
91.
▲
by
acatton
3y ago
Because if you're a ruthless company going public, you want to avoid ways for your users to block the ads or "cheat the walled garden." Forcing them to use the official app is the way to go. And advertisers feel safe. I'
92.
▲
by
acatton
3y ago
> At a time when most information comes to us for free online (with strings attached, of course), it's easy to have sticker shock at the $1,199 retail price for the 2023 edition of World Book, although shoppers might occasionally fi
93.
▲
by
acatton
3y ago
Reddit's doom has been announced over and over again since they started raising the bar for what is an "acceptable" sub-reddit in 2011. The reality is that Reddit hasn't ceased growing since then. The same thing happened
94.
▲
by
acatton
3y ago
Why is basically almost all the countries in the world except the EU countries. GP comment about "bard is still not available in europe" still stands. (Snapshot of the page at the time this comment was written: https://
95.
▲
by
acatton
3y ago
It works transparently with any project using autotools/cmake/meson. (which is 95% of open source projects, and most likely most enterprise software) No need to convert your project to starlark BUILD files.
96.
▲
by
acatton
3y ago
Good point, but in the case of OP, without condition, it will do a full table scan. Also, any case of "WHERE filter ORDER BY random() LIMIT n" means "I want a tiny sample from a broad filter". So it might not be a full t
97.
▲
by
acatton
3y ago
> > If you use another SQL database, the best thing to do is to use UUIDv4 as primary key, and use "ORDER BY pk LIMIT size". > What if I want a different random order tomorrow? If your data is large, and you want differen
98.
▲
by
acatton
3y ago
But ORDER BY random() will scan the whole table and assign values. This is the plan I get: Limit (cost=56.39..56.41 rows=10 width=40) -> Sort (cost=56.39..59.79 rows=1360 width=40) Sort Key: (random()) -> Seq Scan on
99.
▲
by
acatton
3y ago
Yeah. It's odd that you got down-voted for this comment. "ORDER BY random() LIMIT 10" is known to be slow on large tables. The correct way to do get a random sample is to use "SELECT ... FROM table TABLESAMPLE SYSTEM (10
100.
▲
by
acatton
3y ago
One multi-usage phone app (chat, pay, navigate, …)
101.
▲
by
acatton
3y ago
> Mr. Lee runs Layoffs.fyi as a hobby, and he spends money on it. In addition to his time, he estimates that he spends about $200 each month on the cost of its servers. He said he has declined to run ads, though he has been approached. G
102.
▲
by
acatton
3y ago
Where I live, this is absolutely not the jaywalking of RF violations. In Germany, if it is proven that your signal was potentially interfering with emergency services, you will be liable for any damage to victims in civil courts. And if som
103.
▲
by
acatton
3y ago
There are many github alternatives, sure. But sofware is still centralized on github. I double dare you to "pip install", "cargo build", or "go get" without hitting github. Your project can be hosted on repo.or
104.
▲
by
acatton
3y ago
It was worse before MS took over. But their status page displayed live metrics, it was more transparent, so people were less frustrated. As opposed to now, where the status dashboard is updated by a human. IMHO, the issue is not the unstabi
105.
▲
by
acatton
3y ago
> small players who can’t afford to spend time or money in understanding these things Most of them can afford it, since it's part of the cost of doing business. Most European businesses were already regulated by similar rules with t
106.
▲
by
acatton
3y ago
matomo and goatcounter are nice, but there are even solutions which don't need any extra CPU or any extra client request: • https://goaccess.io/ • https://www.awstats.org/ Both of them are free/op
107.
▲
by
acatton
4y ago
To be fair, most of the scams exposed by Honest Guide are targeted at tourists, not locals. I'm not saying this is a good thing, as tourism is a big contributor to Prague's economy, and I don't like when people are getting sc
108.
▲
by
acatton
4y ago
Because Google manages the .dev TLD. https://en.wikipedia.org/wiki/.dev It's their TLD, they do whatever they want.
109.
▲
by
acatton
4y ago
> Then there's the fact that you can use a variety of AuthN+Z options, it goes over standard ports What's a standard port? AFAIK 22 is a standard port. https://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port
110.
▲
by
acatton
4y ago
$ ssh -o VerifyHostKeyDNS=yes github.com The authenticity of host 'github.com (140.82.
111.
▲
by
acatton
4y ago
Sorry to reply a day later. GP here, it's a simple separation of concern. IMHO the binary should not be aware that it is cached and/or how it's deployed. I separate "business logic" from "devops", and I co
112.
▲
by
acatton
4y ago
I'm not the author of the post, so I can't tell you what the author does. What I do in my projects is that I tell varnish-cache to cache assets in "/static/..." forever. And I have a "curl -X PURGE <var
113.
▲
by
acatton
4y ago
> Go isn't perfect either. The author isn't dealing with assets (images anyone?). From the article: "The Go web application had all files like configurations (no credentials), static css and html templates embedded with em
114.
▲
by
acatton
4y ago
Hi Vykintas, thank you for answering. I'm the GP. First of all, I want to reiterate that I purposefully used the word "allegedly" because I have no proof. I only have a smoking gun https://archive.is/bQo0O .
115.
▲
by
acatton
4y ago
Sorry, my phrasing was wrong. The second part of my comment had nothing to do with the first link. I am basing the second part on this research: https://www.docdroid.net/kOP3JAh/tesonet-web-of-lies-pdf I'm not a c
116.
▲
by
acatton
4y ago
I used to buy residential IPs from a competitor of Oxylabs in a previous life. Nothing illegal, just scraping data from websites using cloudflare. (Cloudflare has some anti-scraping-scraping protection, even if you do 1 request per 15 secon
117.
▲
by
acatton
4y ago
That's true. Good point.
118.
▲
by
acatton
4y ago
I am not related to them, I'm just a user of it. But Mullvad.net is the only decent VPN. (They're the one Mozilla chose to provide their VPN infrastructure) They've been audited https://mullvad.net/en/b
119.
▲
by
acatton
4y ago
Reminder that it looks like NordVPN does shady stuff: https://news.ycombinator.com/item?id=29285988 Allegedly, they are using their customers as botnets to resell traffic from residential IPs, mostly for scraping, through
120.
▲
by
acatton
4y ago
This is purely marketing AFAIT. I don't see how it provides any protection against the 5 eyes or having one's google account breached. The encryption/decription is done with javascript code served to your browser by google (=
More ›