Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
luhn
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
22 ms
·
91.
▲
by
luhn
4y ago
No way. “password” protects me from the neighbor torrenting movies or Googling bomb recipes or whatever, which is the bulk of the threat model for residential Wi-Fi.
92.
▲
by
luhn
4y ago
My solution to this is that "password" is the literal password of my guest WiFi.
93.
▲
by
luhn
4y ago
Most iCloud data is end-to-end encrypted; Apple doesn't have direct access to your data. In the end they do own the OS and could potentially backdoor your device, but if you're worried about that... well, Lockdown Mode is moot at
94.
▲
by
luhn
4y ago
To nitpick a little bit, Python does not follow semver and does not claim to follow semver. Minor versions are mostly backwards compatible, but do include breaking changes.
95.
▲
by
luhn
4y ago
That's a myth, and obviously false on the surface: What are they supposed to do when they need that capacity back for Black Friday? Kick out all their customers for a day?
96.
▲
by
luhn
4y ago
> Re data, I think egress rates are going to start disappearing over the next few years. I'm not sure why you think that. AWS hasn't budged on their egress pricing for a decade (except the recent free tier expansion), despite
97.
▲
by
luhn
4y ago
It's good practice to have a length constraint on all text fields, just to put some cap on field sizes. You don't want somebody uploading 100MB of garbage into the `first_name` field—A 1000-char max is more than enough. Constrain
98.
▲
by
luhn
4y ago
For Postgres, there's a strong case to be made VARCHAR(n) is preferable to TEXT+check constraint. As you note, they're stored the same on disk. But for a varchar, you can increase the length with just this: ALTER TABLE a A
99.
▲
by
luhn
4y ago
One big advantage not mentioned in the article particularly relevant to this audience: git diffs (or your VCS of choice). One sentence per line means diffs will operate per-sentence, rather than per-paragraph. This way the diff can captu
100.
▲
by
luhn
4y ago
iCloud Keychain is end-to-end encrypted.
101.
▲
by
luhn
4y ago
"Trees in a big hole" is a wildly reductive take. The article already mentions "dense brush on the forest floor [standing] shoulder-high," which would easily be damaged by a flock of tourists. Plus you almost certainly
102.
▲
by
luhn
4y ago
It has a feature now where you can scan your signature and pop it into any document on demand. Super useful.
103.
▲
by
luhn
4y ago
It was too much work to migrate from SQLite to PostgreSQL, so you migrated to... a NoSQL DB?
104.
▲
by
luhn
4y ago
Fundamentally they can do it because partitions are relatively small, so you'll have hundreds of partitions from hundreds of different tables on a single machine and a handful of hot partitions are only a tiny blip. (There is of cours
105.
▲
by
luhn
4y ago
One thing I've always wondered: How do pre-compiled binaries take advantage of new instructions, if they do at all? Since the compiler needs to create a binary that will work on any modern-ish machine, is there a way to use new instr
106.
▲
by
luhn
4y ago
> Poor application code maintainability: hints in queries require massive refactoring. > Interference with upgrades: today's helpful hints become anti-performance after an upgrade. > Encouraging bad DBA habits slap a hint on i
107.
▲
by
luhn
4y ago
Mind expanding on what the "nightmare" is?
108.
▲
by
luhn
4y ago
It's generally recognized that deleting data from a backup would violate the integrity of the backup, so allowances are made. Usually you have to make sure the data is deleted as part of the restore process. For example, from CCPA: &
109.
▲
by
luhn
5y ago
*parity. "Equality, as in amount, status, or value." https://www.thefreedictionary.com/parity
110.
▲
by
luhn
5y ago
Worth noting that Snap also has a commitment with AWS, they are not exclusively running on GCP.
111.
▲
by
luhn
5y ago
No, vinyl is the majority of physical sales by unit now in the US. > According to data from the MRC and Billboard, 38.3 per cent of all album sales in the country last year were in vinyl format, while it accounted over 50 per cent of all
112.
▲
by
luhn
5y ago
I think burgers are a great fine dining "hack." Many fine dining establishments have a burger on the menu and it's often really freaking good at a price point significantly less than the other entrees. The best burger in
113.
▲
by
luhn
5y ago
Polarized sunglasses block the phone's sensors, so it can't confirm you're actually looking at the screen—That someone isn't trying to unlock it e.g. while you're asleep. If you turn off "Require Attention for
114.
▲
by
luhn
5y ago
I think that paper is making an argument orthogonal to OP. OP is saying Postgres is a good enough solution, that the advantages of simplifying the stack outweigh the disadvantages of using a non-optimal database for basic use cases.
115.
▲
by
luhn
5y ago
It also has a built-in "black" profile, so it only takes one line of config to get it to play nicely with Black. https://pycqa.github.io/isort/docs/configuration/black_compa...
116.
▲
by
luhn
5y ago
> exit is not a keyword, but it is reserved so that you can get this message. `exit` is not reserved. It's a callable implemented in pure Python [1] injected into the local scope when in interactive mode. There's no special f
117.
▲
by
luhn
5y ago
> Cross site POST calls require a CORS pre-flight options request, and the response of this request is scrutinized. Not in all cases. Certain POST requests count as "simple" requests and no preflight check is performed. For e
118.
▲
by
luhn
5y ago
The heap is described in 1.3 [1] and MVCC is described in Chapter 5 [2]. I'd also recommend the Postgres docs [3], they aren't quite as accessible as this but are detailed and overall well-written. [1] https://www.inte
119.
▲
by
luhn
5y ago
Honestly your expectations are too high. Conflict resolution is row-level last-write-wins. It's not a globally distributed database, it's just a pile of regional DynamoDB tables duct taped together... They're not going to
120.
▲
by
luhn
5y ago
BRIN indexes don't affect the storage layer, so you need to make sure your table is appropriately sorted on disk through other means. CLUSTER can do this as a one-off job (pg_repack if you need to keep the table available for writes),
More ›