teej

In Postgres terminology, all functions have a volatility classification: IMMUTABLE (input X will always return y forever), STABLE (input x will always return y for the current statement) and VOLATILE (input x can return anything). That classification impacts how the query gets planned and optimized. All the dbs I know have some version of this.

now() should be STABLE in pretty much every db, but not every db gracefully handles STABLE function calls in predicates.

You probably know all this but figured I'd share the database jargon for everyone else.

It's certainly possible. But Parquet and Arrow are being built with each other in mind. I doubt the tradeoffs on storage, durability, and future-proofness are worth skipping the marginal overhead to load a Parquet file into memory.

These tools are very new compared to CSV+pandas. And most things you want to get data out of won’t give it to you in parquet.

The future is very promising, I am personally very excited about DuckDB. But it’s too soon to be griping about old tutorials.

For ETL out of Postgres, it is very hard to beat psql. Something as simple as this will happily saturate all your available network, CPU, and disk write. Wrapping it in Python helps you batch it out cleanly.

    psql -c "..." | pigz -c > file.tsv.gz

There are road designs that prevent driving while drunk or texting?

I’ve worked at a VC-backed social media app and currently work for a privately owned porn company.

SV has the dumbest double standards about sex and nudity. Just colossally dumb.

There’s a few forces at work that the article doesn’t dig into -

1/ VCs get their money from LPs. LPs are orgs like university trusts and pension funds. Those LPs demand “morality clauses” that limit what VCs can invest in. And VCs give it to them.

2/ Google starting 2018-ish began to cave to advertiser pressure about nudity. They passed that pressure down to their different business. Now YouTube, AdWords, Adsense, etc all must ensure ad content is never shown next to nudity. Those business teams rolled out this missive in the most bungled way possible. False positives be damned, the ad dollars must flow.

This leads to startups being squeezed on both sides - investors can’t be seen supporting sex and ad platforms salt the earth anywhere an adult word might be uttered. So as a social media platform, you pretend it doesn’t exist (Reddit, Instagram), you quarantine it (Twitch), or you mass-deplatform and cross your fingers (YouTube, Snapchat).

I don’t know what the answer is for those products, but I feel like we could do better.

I have to activate a complicated account level override to see nipples on the Reddit app. I can see gore in 2 clicks.

Seems like we haven't learned from the downfall of General Electric.

It’s clearly a supply shock.

So I can learn something new in a low risk, low pressure environment.

Redshift added a feature to create views “WITH NO SCHEMA BINDING” to solve this but the Postgres team hasn’t added an equivalent yet.

Been thinking about this sort of thing for awhile, your vision for how this should work is so much better than mine was.

One of the ideas I kicked around was “materialize-on-read” - when a query comes in but the underlying data is stale, refresh the views first then serve the query.

I’m wondering how much state you plan to put into the Hydra layer or if you plan to keep it mostly a router.

This sounds like a cool idea for a game.

The employee got cash already. Not sure they can simply “back out” without major consequences.

It's typically a good idea to know the folks you've given code access to.

Tax loss harvesting alone has more than paid the 25 bps fee that Wealthfront charges. It's a no-brainer to me. I'm very happy with Wealthfront.

Many SMS pay-per-use plans charge per message received.

“Totally free” is not a benefit. I want a transactional relationship with a company that will compel them to help me when things go wrong.

It’s very common in the online messaging I’ve seen in English, Spanish, Chinese, and Russian.

It took 10 seconds of searching to find a flat fucking image file exploit. I even skipped the recent NSO group zero-click exploit. Enjoy - https://www.bleepingcomputer.com/news/security/new-stegano-e...

> A new scientific truth does not triumph by convincing its opponents and making them see the light, but rather because its opponents eventually die and a new generation grows up that is familiar with it. . . . An important scientific innovation rarely makes its way by gradually winning over and converting its opponents: it rarely happens that Saul becomes Paul. What does happen is that its opponents gradually die out, and that the growing generation is familiarized with the ideas from the beginning: another instance of the fact that the future lies with the youth.

— Max Planck

There are some AWS services, notably STS, that are hosted in us-east-1. I don’t have anything in us-east-1 but I was completely unable to log into the console to check on the health of my services.

Felipe Hoffa did a lot of last year’s Advent Of Code in Snowflake SQL. It’s worth a look - https://towardsdatascience.com/sql-and-adventofcode-2021-on-...

I had the opportunity to experience Silbo Gomero first hand - at least the version they show off to tourists on a tour. It’s a unique language that was nearly lost.

If you visit the Canary Islands I highly recommend to check it out.

It’s actual hours streamed. Given the intense scrutiny this metric will get, including audits by EY, there’s no way they’d get away with some handwavy assumption multiplier of butts in seats.

Because it was fine. Decent popcorn flick.

It has a 75% audience score on Rotten Tomatoes, so either most folks liked it or the people who wouldn’t like it opted out of watching it.

Just beware - the expected value of the authors simulated blackjack counting is quite good. This is due in part to the crazy “spread” (the ratio of max bet to min bet) of 100-to-1. This illustrates the profitability of the model well, but it’s unrealistic.

A more typical spread of 10-to-1 ekes out an expected value of ~0.5% (see https://wizardofodds.com/games/blackjack/card-counting/high-...). When I was counting, I could barely hit $15/hr expected value. Hardly worth the effort, I found it very demanding to keep track of the count at Vegas dealer speeds and play perfect blackjack for hours on end.

It’s a special data structure that holds a 2 dimensional array and allows you to perform very efficient “vector” (all rows/all columns) operations on it.

It’s used a lot in data science applications, particularly for matrix math.

Everyone who was using WiFi to watch Netflix before bed has switched to their phone.

> It’s often forgotten, but prior to credit cards, many Main Street retailers like e.g. pharmacies maintained hundreds or thousands of credit accounts for customers individually, necessitating their own back offices, accounting, and collections headache.

This article is a great history of how the modern credit card came into being https://www.washingtonpost.com/archive/lifestyle/magazine/19...