🦆 DuckDB
Recently met an interesting concept. What if you can load ANY information to memory and do SQL queries against in? With DuckDB this becomes possible:
SELECT *
FROM read_json('todos.json',
format = 'array',
columns = {userId: 'UBIGINT',
id: 'UBIGINT',
title: 'VARCHAR',
completed: 'BOOLEAN'});
Given the price of the current compute and how powerful are our private machines, it makes sense.
📈Load testing
Simplest thing you can use for the quick load test is still ab. For more complex cases I once used vegeta.
There is now new kid on the block — oha. Written in Rust it is lightweight
cli app which also has nice terminal UI. Will use.📋Lists comparison
Several weeks ago, for a quick analytics I had to compare four lists. To understand how similar are they. I quickly found and online tool which have helped me. You just post
txt of the lists there and it does all the basic math about it. What surprised me, that it also draws Venn Diagram, so you can visually see how these lists overlap. 🇺🇦🚙 Five pickup fundraiser
Last but not least. You still have a chance to donate any amount to help UAF to fight 🩸putin. We already gathered quite a sum and I'm thankful to you. Let's do another push. Please, donate.
⬛️ That was it for today.
