taffer

26 ms·

241.
by taffer 7y ago
> The Apple Maps service doesn’t have a web presence It kind of has: https://maps.apple.com/place?address=San%20Francisco
242.
by taffer 7y ago
Do you use SERIALIZABLE in Postgres? If so, what's your experience?
243.
by taffer 7y ago
> Additional CPUs are $7,000 USD per core, and replication is labor intensive Probably still cheaper than trying to impement scalable transactions in higher layers.
244.
Psql and Gnuplot(okbob.blogspot.com)
2 points by taffer 7y ago|0 comments
245.
by taffer 7y ago
> Tickets cover half of operating costs in New York, but all of operating costs in London. According to Wikipedia New York has a farebox recovery ratio of 47% and London has 65%.
246.
by taffer 7y ago
Error correction also adds some latency.
247.
by taffer 7y ago
We probably disagree on definitions, because the term risk can sometimes refer to the expected damage and sometimes to the variance of the damage. So I will try to express myself more clearly: Let's say you have a house worth $100,000
248.
by taffer 7y ago
You're missing the point. Risk pools are there to reduce variance through diversification, not to reduce your expected loss.
249.
by taffer 7y ago
> So with the perfect risk profile, insurance is a zero sum game. The utility of insurance is to reduce variance, it is not a zero-sum game.
250.
by taffer 7y ago
It is a combination of land and capital and it is the land that makes up the scarce part of it.
251.
by taffer 7y ago
> This Economist article points out some of the many small academic works that quibble over details with Piketty and Saez [...] that capital is a positive feedback loop in a way that labor is not Well the article mentions that: > Matt
252.
by taffer 7y ago
This could be solved with transactions: If all processing takes place within transactions, then you can always return to a clean state after a crash.
253.
by taffer 7y ago
> Your business won't succeed if you're hacked daily. Which can be the consequence of setting the wrong isolation level: http://www.bailis.org/papers/acidrain-sigmod2017.pdf
254.
by taffer 7y ago
I wouldn't say so. Concurrency bugs, like lost updates, can be very subtle and hard to debug, and common databases don't prevent these kinds of bugs by default.
255.
by taffer 7y ago
> Here is a decent and easy starter in under an hour. > https://www.youtube.com/watch?v=bE8i-4HpKlM It should be mentioned that the video presents a fringe theory (MMT) that is highly controversial among economists. I
256.
by taffer 7y ago
> It eats a little more ram but it is more stable. It also eats a lot more cpu cycles: https://www.youtube.com/watch?v=xNDnVOCdvQ0
257.
by taffer 7y ago
> further, afaik there's no assignment nor iteration in SQL That was until CTEs were introduced in SQL:1999 > it's not a programming language at all. It's a.. query language. The two are not mutually exclusive. SQL is u
258.
by taffer 7y ago
You can, and I think you should, place your data and stored procedures in separate schemas. This way, migrations are only required for the data, and stored procedures can be deployed and version-controlled just like any other code.
259.
by taffer 7y ago
> Well, you know about triggers!!! Yes, and I also know about other nefarious things like monkey patching in some OO languages. Doing such things is antisocial behavior and something that 99% of developers don't expect. > Those w
260.
by taffer 7y ago
> Why would you be surprised[...] The statement says DELETE and that is what I want, the rdms executes it and tells me "deleted 1" (yes, it does). What am I supposed to think? > Your schema is an interface here, so read its
261.
by taffer 7y ago
see https://news.ycombinator.com/item?id=21455027
262.
by taffer 7y ago
Let's say customer 1234 wants us to delete his/her customer record, so we issue the following statement: DELETE FROM customers WHERE customer_id = 1234; The statement runs successfully and of course we would expect the cust
263.
by taffer 7y ago
> and it can have function calls you don't know about because its body could dispatch just like triggers do. Please give an example of a stored procedure that does something else than what the code says it will do. > This whole t
264.
by taffer 7y ago
> much as you call property setters or getters in OOP languages Good design is obvious and orthogonal[1]. If you write setters in an OOP language in such a way that they do surprising things, i.e. not just setting a value, then I wou
265.
by taffer 7y ago
So you think a majority of sleep researchers think we should have DST all year?
266.
by taffer 7y ago
You still have to call a method if you want it to do something. It doesn't simply happen as a side effect of something else. A method call only ever does one thing at a time, not multiple things in a random order. Read this if you stil
267.
by taffer 7y ago
Triggers are implicit, have side effects and are not deterministic. They are confusing and surprising. A procedure call is explicit, a trigger is implicit. You don't call a trigger, it just happens as a side effect of something else. P
268.
by taffer 7y ago
PostgREST performs authorization at transaction level, not at connection or session level, so a connection can be used by thousands of active users simultaneously.
269.
by taffer 7y ago
This does not explain why the opinions of sleep researchers are not in line with the general population.
270.
by taffer 7y ago
True, when I think about what I've seen, what people are building with Access and what people are building with Salesforce, there's a lot of overlap.

More ›