Viewing profile — blr246

Hi beforeolives— I like your breakdown, and I've observed similar things in my experience as an engineering focused data person! I've had many discussions with my colleagues about …

We are agreeing that NYC is not at a moment of urban collapse. The processes that drives away the tax base includes policies and social and market forces that erode the city's effe…

>Instead, what kills cities is a long period in which their leaders fail to reckon honestly with ongoing, everyday problems—how workers are treated, whether infrastructure is repai…

I had the same initial thought based on the title. Unfortunately, the answer is no. The article discusses a low-dimensional KNN problem. The curse of dimensionality guides intuitio…

At Frame.ai, we are using both PostgreSQL and faiss (and other tools) in our stack to do several different kinds of inference tasks on semantic representations of text to help comp…

It's built into the inbox view, so GMail is extracting the action from the message content and placing a button on the row element. Sorry if that wasn't clear from my initial post.…

GMail seems to have opened a vector to amplify dark patterns by placing action buttons on messages. My least favorite is the LinkedIn accept invitation button, which I've clicked n…

For query plans using a sort node, there can be a major difference in performance depending on the row width.

It's worth mentioning that it's a bad idea to invalidate refresh_token grants ever during the lifetime of an authorization. I've seen APIs do this immediately upon sending the resp…

Your response highlights a good idea to mitigate the risk I was trying to highlight in mine. They want to have a rapid response path (little to no delay using staging envs) to resp…

Appreciate the detail here. It's a great writeup. Wondering what folks think about one of the changes: 5. Changing the SOP to do staged rollouts of rules in the same manner used fo…

The other part of this story I did not see mentioned is that I suspect that password expiration also makes organizations more vulnerable to social engineering hacks because legitim…

Kinesis is not necessarily well-suited fan-out. It is very well suited for fan-in (single consumer, multiple producers). Each shard allows at most 5 GetRecords operations per secon…

Pick up some data sheets for IC parts that might be useful in a system you'd like to design. These are published by the manufacturer, and they contain a lot of design requirements …

You're correct that a table-level lock is a useful tool to ensure serializability, but it's also a drastic one since it blocks other transactions requesting a higher access level. …

To implement the serializable isolation level, the database system must track access to every single row you access, even the ones you read or filter out. (The need to track reads,…

Agree this is pretty much inexcusable. Logging request or response payloads without an explicit whitelist should raise flags for any developer. There are very few cases where you c…

Great write-up. Is the long-term vision to go completely to the vectorised query execution model, or are there cases where a row-oriented plan might be better, such as cases when t…

This is a great tool. We use it to generate an Entity Relationship Diagram from our canonical DDL file checked into our repo. Here's the basic recipe: 1. Spin up a fresh Postgres i…

This "asymmetry" is one of the reasons why having capital makes you powerful, and living paycheck-to-paycheck (maximum need for liquidity) makes you powerless.

Wholeheartedly agree. There are so many powerful development and debugging tools that are easy to configure in a standard IDE outside of a container environment. Docker is an excel…

Vault has always appeared to me to be a great technology for a larger tech org looking to implement more granular access control and increased auditability. At a smaller scale, we'…

A major problem with this is that non-expert users might interpret it to mean that the "green lock" always means everything is ok. That is dangerous advice since it's possible to p…

As a programmer and practitioner, I'm curious about what kinds of skills and training it takes to program quantum computers. Can you shed some insight into what's really different …