rkaveland

4 ms·

1.
by rkaveland 1y ago
Author here. I will be trying out Kagi for some time. Search is worth paying money for. Thanks for the heads-up!
2.
The librarian immediately attempts to sell you a vuvuzela(kaveland.no)
478 points by rkaveland 1y ago|341 comments
3.
What if that isn't a bool?(kaveland.no)
1 points by rkaveland 2y ago|0 comments
4.
Why avoid where id in with variable number of bind parameters on Postgres(kaveland.no)
7 points by rkaveland 2y ago|0 comments
5.
Batch operations using composite keys in Postgres over JDBC(kaveland.no)
1 points by rkaveland 2y ago|0 comments
6.
by rkaveland 2y ago
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 of code. :-) That looks fan
7.
Show HN: Eugene helps you write zero downtime schema migrations(kaveland.no)
1 points by rkaveland 2y ago|0 comments
8.
by rkaveland 2y ago
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 interfere with queries. I've expanded on this idea and made a
9.
Eugene is a CLI tool for reviewing Postgres SQL migration scripts(kaveland.no)
8 points by rkaveland 2y ago|2 comments
10.
by rkaveland 2y ago
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.
11.
by rkaveland 2y ago
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 varchar shorter? Although I guess that's not a table
12.
by rkaveland 3y ago
> 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"? Something more boring, like "Consider whether oth
13.
by rkaveland 3y ago
I regret forgetting about it in the article. sqlite is a great solution.
14.
by rkaveland 3y ago
sqlite is an excellent choice.
15.
by rkaveland 3y ago
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 want to know is how to turn it into Excel/CSV, you