Viewing profile — rkaveland

Author here. I will be trying out Kagi for some time. Search is worth paying money for. Thanks for the heads-up!

Author of the blog post here -- that looks like exactly what I needed, so I'm probably going to add a dependency to it to https://github.com/kaaveland/eugene/ so I can delete a ton…

This is a command line tool that can parse your SQL and look for known dangerous patterns, or it can create a temporary postgres server and actually run your migrations to look for…

A while back, I wrote a blog post that experimented with doing transactional DDL in postgres, and investigating the state of `pg_locks` to check if statements were likely to interf…

This is super cool, I love how it suggests safer ways to achieve the same goal for many common risky migrations. Definitely going to sit down and study these.

Thanks, I will fix this part. As far as I can tell, it is only the example of what can cause the table rewrite that's wrong, so it would be correct if the example was to make a var…

> Well what would be a more accurate title? "CSV format should only be for external interchange or archival; columnar formats like Parquet or Arrow better for performance"? Somethi…

I regret forgetting about it in the article. sqlite is a great solution.

sqlite is an excellent choice.

Author here. I see now that the title is too controversial, I should have toned that down. As I mention in the conclusion, if you're giving parquet files to your user and all they …