latch

16 ms·

121.
by latch 5y ago
Less important now, but they're unsafe to use prior to PG 10. As of 14.1, they still don't support unique constraints: select amname, pg_indexam_has_property(oid, 'can_unique') from pg_am amname | pg_indexam_has
122.
by latch 5y ago
GP here: Yes, thanks. Plus it should be a bit obvious that knowledge of insects with pharmaceutical properties (objective) is not, in fact, the same thing as "knowledge" of what the "tastiest leaves are" (subjective).
123.
by latch 5y ago
> how to escape characters, particularly control characters such as quotation marks, new lines and delimiters I didn't know CSV injection was a thing until it got flagged in a pen test. Then you look around and realize it's a w
124.
by latch 5y ago
Which potentially makes their knowledge, in this specific case, greater than ours.
125.
by latch 5y ago
This is exciting: > ...This log architecture is optimized for raft consensus-based replication allowing the implementation of active-active multimaster. I'm a developer but manage 2 PostgreSQL instances each with an async replica.
126.
by latch 5y ago
It's wrong to mix horizontal scaling with availability. They are two different things that solve two different problems and solving one doesn't necessarily mean you've solved the other. You can scale horizontally in a way tha
127.
by latch 5y ago
Personally I avoid it where I can and use wireguard for all internal traffic. Hopefully someone more knowledgeable here can tell me if it's a good or bad idea.
128.
by latch 5y ago
Exactly. Without a Host header, 400. With a Host header, 301 to https.
129.
by latch 5y ago
OP is correct. HTTP/1.1 requires the Host header (1). The client must send it, and the server must reject requests without it. Some implementations simply don't follow the standard. For example, you can test this on twitter.com, w
130.
by latch 5y ago
The post is a broad, and IMO, valid criticism. Though I'm not sure having a different protocol is a _huge_ problem. If Gemini ever got popular both backends and clients would add support. I think the real issue, and the OP touches on i
131.
by latch 5y ago
Isn't a more common and general solution to the first problem to index the expression lower(email) (1). I'll add some to the list 1. select count(*) from x where not exists (select 1 from y where id = http://x.id)
132.
by latch 5y ago
How does it actually compare to other industries, namely defense, aerospace and oil. These are all capital intensive, and if you want to be generous re the term "building", some of those refineries and shipyards are gigantic.
133.
by latch 5y ago
Nice post and +1 for having a small "hardening" section. I wish that every systemd example/sample/template came with _extensive_ hardening, since I find it quite confusing. I've used systemd-analyze security <SER
134.
by latch 5y ago
> ArrayList explicitly manages a contiguous region of memory, so I don't see the problem with exposing it as a slice as part of the interface. It used to be that you'd get an allocator by taking a pointer to the allocator field
135.
by latch 5y ago
Don't have access to the headers from JS. Best solution might be to generate a short-lived one-time-use ticket and pass it in the querystring.
136.
by latch 5y ago
Diving a little deeper down: 1 - A websocket "frame" has a variable-length header. Client->Server the header can be 6, 8 or 14 bytes. Server->Client it can be 2, 4 or 10. This is to support payloads < 125 bytes, < 2^16
137.
by latch 5y ago
Dupe from a few hours ago: https://news.ycombinator.com/item?id=29586740
138.
by latch 5y ago
AWS is a monopoly if you're living in a HN bubble. The vast majority of "hosting" (internet or otherwise) doesn't use AWS. Large telco's (Telefonica, AT&T, China Unicom, ...) have numerous data centers. Conglome
139.
by latch 5y ago
Something that's sustainable should scale / be reproducible. If only _some_ parties can do it, it isn't sustainable. If everyone did "sustainability" like Singapore, we'd literally all die in a few weeks. Sour
140.
by latch 5y ago
> Singapore is ranked as Asia’s most environmentally sustainable city. The provided link is dead. I find this hard to believe. Singapore imports almost all of its food and all of its energy (mostly not sustainable) and much of its water.
141.
by latch 5y ago
> I can assure you the HN mods and all of YC go above and beyond to not tip the scale in YC founders' favor. Consider [1] which was flagged dead. It was ~10 years ago, so I could be wrong, but I believe there was a follow-up meta &q
142.
by latch 5y ago
Most orgs could get away with systemd.
143.
by latch 5y ago
I guess we're limiting our discussion to digitization (so we can ignore any accessible issues with digital-only services). The obvious thing that comes to mind is getting issues resolved immediately, e.g. debit card replacement (which
144.
by latch 5y ago
Small update from their country head: https://www.youtube.com/watch?v=EuXtrtH0uKY 1 - problem identified with their access control services (or did he say servers?). (doesn't sound good) 2 - working with their 3rd part
145.
by latch 5y ago
Not a fan of their video-teller booths/machine? I was impressed and I'd be surprised if, even today, many retail banks have something similar. Obviously good cost-saving for them, but seems like a reasonable solution to banking wi
146.
by latch 5y ago
Adding my $0.02. I've had a non-trivial # of bank accounts in numerous countries, and generally speaking, DBS is good. I think people constantly complaining about DBS have no clue how awful retail banking usually is (especially interne
147.
by latch 5y ago
I matched your donation ;)
148.
by latch 5y ago
Tongue-in-cheek answer (but really what I believe): Don't use microservices. Short answer: It's extremely difficult and, there isn't always a good solution. Different approaches are used on a _per consumer_ basis. That's
149.
by latch 5y ago
FYI, depending on where you live, charitable donations can have tax-benefits (i.e. in the form of a deduction). It can be worth making sure you're donating to charities which are enrolled in such programs. For example, Singapore has a
150.
by latch 5y ago
I'm not sure I understand what you're getting at. But if changing the case didn't alter the length, you could do it in-place, without having to allocate memory. I always thought this was the point?

More ›