uwemaurer

Joined 14 years ago

Karma

276

Submissions

115

Member since

May 16

https://bsky.app/profile/uwemaurer.bsky.social

View on Hacker News

Recent submissions

Show HN: BlueFacts – Bluesky stats and feeds via MCP bluefacts.app

1 uwemaurer 19 days ago 0 comments

Comment · 4 months ago

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

Comment · 6 months ago

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

Comment · 6 months ago

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-benchmark/

Benchmarking DuckDB from Java: Fast Insert, Update, and Delete sqg.dev

2 uwemaurer 6 months ago 0 comments

Comment · 7 months ago

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 intermediate results can't be easily seen in a SQL editor. I was working on a UI to parse CTE queries and then execute them step by step to show the results of all the CTEs for easier understanding of the query (as part of this project https://github.com/sqg-dev/sqg/)

I benchmarked bulk insert into PostgreSQL from Java (also via DuckDB / Arrow) sqg.dev

3 uwemaurer 7 months ago 0 comments

Comment · 7 months ago

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 app removed from the Android market. Chuck Norris won, we took the app down

Comment · 8 months ago

Thank you for the suggestion!

SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support sqg.dev

20 uwemaurer 8 months ago 6 comments

Comment · 8 months ago

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

Comment · 9 months ago

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-dev/sqg/

Comment · 9 months ago

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

Comment · 9 months ago

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/

Comment · 9 months ago

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 block some paths with with "denyRead"