Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
1500100900
searching Neon…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
1500100900
1y ago
> Your backend needs to store location because places can switch time zones. For the event, your backend only needs to store the timestamp in a timestamptz field and make sure that clients set the correct time zone on session start (this
2.
▲
by
1500100900
2y ago
The last time I checked, audio and video firmware wasn't there.
3.
▲
by
1500100900
3y ago
I'm surprised that not only is there no application firewall for any of the BSDs, there doesn't even seem to be any need for it. There is OpenSnitch, but only for Linux.
4.
▲
by
1500100900
3y ago
I'd be interested in learning which commands you have in mind and what specifically is a bit nicer about their coreutils implementation.
5.
▲
by
1500100900
3y ago
Unless you're Tom, you'll have to work on tickets assigned to you by some manager.
6.
▲
by
1500100900
3y ago
In a world where HA is key, PostgreSQL has nothing to offer.
7.
▲
by
1500100900
3y ago
Give Mastodon a threaded view and technically it's the same as reddit, but federated? Usenet, but not just for nerds.
8.
▲
by
1500100900
4y ago
While waiting for PG 16 you can upgrade to 15.
9.
▲
by
1500100900
4y ago
So you DO search for answers to mainframe questions on s**overflow?
10.
▲
by
1500100900
4y ago
Postgres actually does have thousands of engineers but it's not easy to notice because they all share the same name. https://www.citusdata.com/blog/2017/04/20/analyzing-postgres...
11.
▲
by
1500100900
4y ago
https://buildfarm.postgresql.org/cgi-bin/show_status.pl?memb...
12.
▲
by
1500100900
4y ago
Not for free (have to pay EnterpriseDB for that). Every free option here is basically "glue pieces together to build your own HA".
13.
▲
by
1500100900
4y ago
Gavin's personal project is being used in production.
14.
▲
by
1500100900
4y ago
> The BSD answer to the problems with strncpy() was to introduce a new function called strlcpy() Not BSD, it was OpenBSD specifically.
15.
▲
by
1500100900
4y ago
Have you tried auditing ZFS? That's way too much code to be secure, it's best for OpenBSD to never import it.
16.
▲
by
1500100900
4y ago
> Don't know what keeps him going. A desire to see FreeBSD fix those defaults? And when they do fix any of those things, what is his reaction going to be? So far it's been "it took them so much time to fix this, let's
17.
▲
by
1500100900
4y ago
> The flag is called in-place for a reason. What's the reason? Surprisingly, the file is never edited in place.
18.
▲
by
1500100900
4y ago
How is backup restoration any easier if your whole PostgreSQL cluster goes back in time when you only wanted to rewind that one tenant?
19.
▲
by
1500100900
4y ago
Cassandra may be great when you have to scale your database that you no longer develop significantly. The problem with this DB system is that you have to know all the queries before you can define the schema.
20.
▲
by
1500100900
4y ago
You can disable building the "whole fucking C compiler suite" using WITHOUT_CLANG as documented in https://www.freebsd.org/cgi/man.cgi?query=src.conf By the way, as an example, you can also disable IPv4 and I
21.
▲
by
1500100900
4y ago
They mean: lose one drive and have another with bit rot.
22.
▲
by
1500100900
4y ago
- "RAID is not a backup" primarily because "you could rm -rf". ZFS snapshots cover that failure mode to the same extent that synchronization with offsite does, but cheaper. ZFS snapshots obviously don't cover other
23.
▲
by
1500100900
4y ago
> we really integrated S3 into the storage Will it be possible to use something else in place of S3? I'm thinking on-premise or what some would call a private cloud.
24.
▲
by
1500100900
4y ago
They have a history of working with open source projects only to the extent that allows them to push some of their work upstream so that the burden of maintaining it is shared, while retaining the rest of it as proprietary solutions that gi
25.
▲
by
1500100900
4y ago
- "most recent" is usually best done with a max() with an adequate index or, when that's not possible, with a LATERAL JOIN, an ORDER BY and a LIMIT 1 - SELECT id FROM users WHERE EXISTS (SELECT 1 FROM story_comment WHERE stor
26.
▲
by
1500100900
4y ago
SELECT DISTINCT is rarely the best idea. In most cases it means someone is using joins to filter out rows that should have been removed with EXISTS (a semi-join).
27.
▲
by
1500100900
4y ago
It uses OpenZFS.
28.
▲
by
1500100900
4y ago
This is easy to say when you don't have to comply to some industry standards.
29.
▲
by
1500100900
4y ago
There's so much churn on hacker news that everything gets old after a couple of nanoseconds. So I think it would be best to just add a field for a 128-bit timestamp of the original submission and present it with high precision.
30.
▲
by
1500100900
5y ago
The Raspberry Pis are hostile towards non-Linux systems.
More ›