Viewing profile — uwemaurer

Looks great! How does it compare to Zulip? we self host zulip and are quite happy with it

Yes, I tried it to generate a cool profile stats video for Bluesky, for example see here: https://bluefacts.app/video/bsky.app

I benchmarked DuckDB 1.5.2 with the latest Java JDBC driver which now supports user defined functions. This allows very fast modifications https://sqg.dev/blog/java-duckdb-benchmar…

Great article, I always like to structure my queries with CTEs and I was (wrongly) assuming it all gets inlined at the end. Sometimes it also gets complicated since these intermedi…

17 years ago we launched the first "Chuck Norris Facts" app for Android (March 2009). It was a big success until end of 2010 when Chuck Norris sent his lawyers after us to get the …

Thank you for the suggestion!

Great! I will give it a try. I found that using DuckDB to select from the parquet files and using the Apache Arrow API to read the results is also a very fast method

This is great! It would be a cool feature to integrate with SQG. there you currently need to provide the sequence of migration steps to get the full schema. https://github.com/sqg-…

Here are some independent stats: https://bluefacts.app/bluesky-user-growth

I recently benchmarked different SQlite implementations/driver for Node. Better-sqlite3 came out on top of this test: https://sqg.dev/blog/sqlite-driver-benchmark/

I like it. Is it also possible to block all filesystem access and only allow certain directories / files? Currently it seems to allow read access by default and only allows to bloc…

We use DuckDB to process analytics and feeds for Bluesky ( https://bluefacts.app ) To get fast access to the query results we use the Apache Arrow interface and generate the code d…

I developed SQG because I had to access a SQLite and a DuckDB database from Java and from Typescript and was unhappy about maintaining the DB access code twice. Also for larger ana…

how do you like my hackernews frontend: https://news.facts.dev/

Here are more detailed stats: https://bluefacts.app/bluesky-user-growth

Bluesky / ATProto is very open, this makes it possible to track the exact statistics how the platform is growing (or shrinking currently): https://bluefacts.app/bluesky-user-growth…

Bluesky has still a lot to catch up: https://bluefacts.app/bluesky-user-growth

This is a nice dashboard showing Bluesky User Growth and Active Users. It has trend charts and different time ranges: https://bluefacts.app/bluesky-user-growth Recently it looks li…

I use es-toolkit. It is fully in Typescript. Every function can be imported without any extra overhead, for simple functions it just adds a few bytes then to the bundle. I doubt "b…