pgwhalen

28 ms·

361.
by pgwhalen 5y ago
I similarly have a “tech blog” that only a couple of non-tech friends know about (admittedly it wouldn’t be hard to find if someone searched for it, but who would want to do that). It’s good writing and thinking practice, especially becaus
362.
by pgwhalen 5y ago
Great link, thanks. At the time I looked, MicroStrategy’s market cap is lower than the amount of bitcoin it holds. That has to be awkward if you’re an employee there.
363.
by pgwhalen 5y ago
My guess would be noise. A basketball hoop across the street is an amenity, but one right outside the window might be an annoyance.
364.
by pgwhalen 5y ago
You may have misunderstood, we're not using it as a postgres replacement. I agree with this take, hence my original assertion that it isn't a drop in replacement for a DB server. We are using it as a replacement for RocksDB - we
365.
by pgwhalen 5y ago
The point is that script kiddies do not have the ability to do that.
366.
by pgwhalen 5y ago
That's true - our software does not deal with PII, which makes many of our DB practices sound strange to outsiders.
367.
by pgwhalen 5y ago
> With postgres you could set up a read-only replica or something. At least for me, the small effort is well worth not having to worry about accidentally deleting production data. We do do this, and probably should be more disciplined ab
368.
by pgwhalen 5y ago
That ought to work, but the experience we are trying to emulate is that of using DataGrip, rather than psql.
369.
by pgwhalen 5y ago
> Can't you run your queries in a copy of the data (eg.: a backup)? That's essentially what we do: copy the file locally if we need to inspect it. It's slightly more cumbersome though. > I think that'd be advisabl
370.
by pgwhalen 5y ago
> I assume because you're using a remote socket connection from the client? Yeah, it's common for all developers to connect to and query against prod postgres DBs via DataGrip or similar. dqlite definitely looks interesting, bu
371.
by pgwhalen 5y ago
> I believe you mean that you can't easily do a "psql ..." or connect using DataGrid and similars, right? Yeah. > Does this mean that devs need to copy the production database file locally to then inspect it? Or are the
372.
by pgwhalen 5y ago
SQLite is great, but it's not a more simple drop in replacement for DB servers like HN often suggests it is. My team at work has adopted it and generally likes it, but the biggest hurdle we've found is that it's not easy to i
373.
by pgwhalen 5y ago
It's not integrated with git the way you're perhaps imagining, but SQLite sessions[0] is adjacent to what you're imagining. [0] https://www.sqlite.org/sessionintro.html
374.
by pgwhalen 5y ago
Sure, but at that point I would argue you metaphor is not very useful. One convenience store would likely "bury" another if it were one block closer to its customers than the other. I wouldn't say the food store industry was
375.
by pgwhalen 5y ago
> One grocery store doesn't bury another by being humanly imperceptibly faster at returning carts than the other by a microsecond One trading strategy being faster than another does not automatically make it better. This is a commo
376.
by pgwhalen 5y ago
> Low latency trading is so crucial to the economy that the market mostly shuts down at 4pm every day and takes weekends and holidays, adding 2^47 nanosecond delays every week without much outcry. To this I would say: grocery stores (whi
377.
by pgwhalen 5y ago
No. A large majority of trading strategies don't require the low latency that FPGAs help provide. There is some truth to this statement though, if such a firm is trying to pursue a certain kind of strategy - to compete on latency, som
378.
by pgwhalen 5y ago
I agree that externalities are important to consider, but what would such a model look like? It seems that studies like this are a necessary precursor if we are to truly estimate these external costs (so kudos to those involved).
379.
by pgwhalen 5y ago
That's an interesting read, and I personally am a fan of Scott's somewhat radical views on college education in America, but surely you recognize that you are directly side-stepping the question? The problem at hand here is not a
380.
by pgwhalen 5y ago
While it's true that one can improve their standardized test scores by studying or taking a course, and the ability to do those things is correlated to a student's socio-economic situation; if you label standardized tests as subje
381.
by pgwhalen 5y ago
> Snapchat's valuation doesn't give them buying power This isn't true in practice. Sure, company stock is not as great as the almighty US dollar, but can be used to purchase other companies, and its valuation directly aff
382.
by pgwhalen 5y ago
I agree most business related coding is trivial, but all of the things that a software engineer does that surround the coding are not trivial. All of the best software engineers I know recognize this, and all of the less effective ones depe
383.
by pgwhalen 5y ago
You describe two phenomena that appear to be true of every two sided market ever, namely: - One can typically get a better price than what is displayed or quoted - The price of liquidity is higher when markets are volatile While yes, nobody
384.
by pgwhalen 5y ago
Finance allocates capital and moves risk from parties who don't want it towards parties who do want it. > Just because I have a mortgage and a credit card doesn't mean I can't survive without them. You could definitely sur
385.
by pgwhalen 5y ago
> Even all the ticks on all the exchanges fit in a few GB of binary per day. This isn’t true once you include equity options, which have several orders of magnitude more data. However your general point still stands, because most options
386.
by pgwhalen 5y ago
CBDC’s are anything but cryptocurrencies. This is a major misunderstanding of why central banks are pursuing them.
387.
by pgwhalen 5y ago
My understanding is these types of investors own less than 1% of homes in the US. Is that not true?
388.
by pgwhalen 5y ago
I see no disregarding, it’s simply another lived experience. The whole point of the comment is that it is different for different people.
389.
by pgwhalen 5y ago
This is probably a challenge unless you're in the industry, but I'm curious about how the specific details of a payment for order flow arrangement works. How does a brokerage choose which provider they route an order to (since th
390.
by pgwhalen 5y ago
HN readers might care to know that this newsletter comes recommend by HN-favorite Matt Levine: https://twitter.com/matt_levine/status/1451586620872867842

More ›