brandur

9 ms·

61.
by brandur 5y ago
Nice — I like the idea of the "9" convention. It serves to catch the eye (9s are positively _harsh_ compared to other numbers) and show that it's meant more as a ballpark rather than a precisely chosen number for this specifi
62.
by brandur 5y ago
I note pretty explicitly in there that you should pick your own numbers. The idea I was trying to get across is that of order of magnitude tiers so that you don't end up with VARCHARs of a hundred random lengths.
63.
by brandur 5y ago
With regards to the CHECK constraints, I actually used to recommend those because relaxing them seemed to be operationally safer, but re-reading the Postgres docs, it didn't seem like there was a particularly big advantage to them beca
64.
by brandur 5y ago
> _I don’t get many mails from recruiters. I wouldn’t invest time in setting up a block mechanism._ I think this is the most practical answer. I get a fair number recruiter emails. The unsolicited mass messaging can be a little irking fo
65.
Control Runaway Postgres Queries with Statement Timeout(blog.crunchydata.com)
2 points by brandur 5y ago|0 comments
66.
by brandur 5y ago
Just to clarify: I was speaking specifically about the case where you have a series of DB calls (like: auth user, retrieve account record, insert idempotency key, do more stuff), and the first one succeeds and the next ones fail. It can hap
67.
by brandur 5y ago
You might find differing philosophies depending on where you look, but a recurring theme you'll find with Stripe's is that they try to make it as easy as possible to get an integration up and running. When you're building out
68.
by brandur 5y ago
> IMHO, though, stripe should abstract away faults in banks, and figure out how to work around faults in bank's systems using e.g. automated refunds when a duplicate charge is detected, and not just bubble up a 500 to stripe's
69.
by brandur 5y ago
A nice feature of keeping the idempotency key separate from the payload is that a service like Stripe can build tools to help users with idempotency even if the user has no idea what an idempotency key is. For example, take a look at stripe
70.
by brandur 5y ago
Your parent is correct. Think of a simplified example of posting a $1 charge to a customer. POST /v1/charges `{amount: 100, currency: usd, customer: 123}` You might do that, and then later charge them another $1: PO
71.
by brandur 5y ago
> So the idempotency key protects against faults on the network between the client and stripe's idempotency layer, but not against stripe-internal faults between the idempotency layer and the application. Is that the case? Yes, in
72.
by brandur 5y ago
Totally irrelevant, but a related fact in this vein: I recently learned "尻" via WaniKani (a popular SRS system to help learn kanji), and the mnemonic they used to help you remember the reading of this kanji/vocabulary (お尻) is
73.
by brandur 5y ago
I'm going to hazard a guess as to why the downvotes are happening: There's a silent majority out there who are not happy with the way dog owners behave, which is very often badly. Most of the time they have no real power to do any
74.
Simulating Update or Delete with Limit in Postgres: CTEs to the Rescue(blog.crunchydata.com)
3 points by brandur 5y ago|0 comments
75.
by brandur 6y ago
Can't +1 this enough. Stated another way, I always think back to this slide [1] from one of Holman's old decks ("Drive-by opinions are less valuable"). For whatever reason, this is a very common phenomena in tech, and th
76.
Deep PostgreSQL Thoughts: Resistance to Containers Is Futile(info.crunchydata.com)
3 points by brandur 6y ago|0 comments
77.
Deep PostgreSQL Thoughts: The Linux Assassin(info.crunchydata.com)
3 points by brandur 6y ago|0 comments
78.
The Answer Is Postgres; the Question Is How?(info.crunchydata.com)
19 points by brandur 6y ago|4 comments
79.
R Predictive Analytics in Data Science Work Using PostgreSQL(info.crunchydata.com)
7 points by brandur 6y ago|0 comments
80.
by brandur 6y ago
Excellent points in the article about "top" (booting off top-level workers in Ractors) versus "bottom" (parallelization at the edges of the code where not as much state needs to be shared) cases, with the top likely to t
81.
by brandur 6y ago
We don't need to guess on this one. One of ISOC members who helped seal this greasy deal wrote a whole thinkpiece last year justifying it: http://www.circleid.com/posts/20191127_why_i_voted_to_sell_o... The short
82.
by brandur 6y ago
Another great win for the EFF. We shouldn't forget how much time and effort fighting this kind of thing takes, and we are very lucky to have an organization who's willing to put in the legwork from which all of us are huge benefic
83.
by brandur 6y ago
For anyone else wondering about the benefits/downsides of the various tests (why do one that takes multiple days when you can do that takes 15 minutes?), the FDA has a pretty good page on this subject: https://www.fda.gov&#x
84.
by brandur 6y ago
To be fair, I'm more referring to installations where it's been necessary to scale up beyond a single node. Things like referential integrity and transactions get harder for sure, but they're not unsolved — as noted in the ar
85.
by brandur 6y ago
(Author here.) I think you're confusing a couple different major classes of languages — declarative versus procedural. I said specifically "most expressive ever for querying and manipulating data ", and I'd stand by tha
86.
Postgres: The Batteries Included Database(info.crunchydata.com)
5 points by brandur 6y ago|0 comments
87.
by brandur 6y ago
I'm not sure that's quite fair to what the video is saying. For one, he didn't say anything about coffee, but rather cappuccino (and other milk-based espresso drinks) specifically. A quick google seems to show that this holds
88.
by brandur 6y ago
That's fascinating – I always wondered how exactly Travis was running their Mac OS builds. Based on MacStadium's public pricing, which is $150/month for the base model of the latest Mac Mini, this cannot be cheap for Travis,
89.
Crunchy Bridge: A modern, multi-cloud Postgres as a service(info.crunchydata.com)
19 points by brandur 6y ago|5 comments
90.
by brandur 6y ago
It's also worth calling out that when people make claims about lowest in the nation, they're almost certainly calculating that based off average price paid across all homes in the state. Thanks to Prop 13, many homeowners do pay q

More ›