Hacker News: uwemaurer

New comment by uwemaurer in "DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser"

uwemaurer — Wed, 22 Apr 2026 15:57:00 +0000

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

uwemaurer — Wed, 22 Apr 2026 10:58:24 +0000

Article URL: https://sqg.dev/blog/java-duckdb-benchmark/

Comments URL: https://news.ycombinator.com/item?id=47861770

Points: 2

# Comments: 0

New comment by uwemaurer in "Good CTE, Bad CTE"

uwemaurer — Tue, 31 Mar 2026 09:14:56 +0000

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)

uwemaurer — Thu, 26 Mar 2026 13:56:20 +0000

Article URL: https://sqg.dev/blog/java-postgres-insert-benchmark/

Comments URL: https://news.ycombinator.com/item?id=47530517

Points: 3

# Comments: 0

New comment by uwemaurer in "Chuck Norris has died"

uwemaurer — Fri, 20 Mar 2026 18:01:08 +0000

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

New comment by uwemaurer in "SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support"

uwemaurer — Sun, 08 Mar 2026 22:29:45 +0000

Thank you for the suggestion!

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

uwemaurer — Thu, 05 Mar 2026 19:08:54 +0000

Article URL: https://sqg.dev/blog/java-streams-and-list-types/

Comments URL: https://news.ycombinator.com/item?id=47265856

Points: 20

# Comments: 6

New comment by uwemaurer in "Hardwood: A New Parser for Apache Parquet"

uwemaurer — Sun, 01 Mar 2026 07:47:43 +0000

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

New comment by uwemaurer in "Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite"

uwemaurer — Thu, 05 Feb 2026 08:26:19 +0000

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/

New comment by uwemaurer in "Bluesky 2025 Transparency Report"

uwemaurer — Fri, 30 Jan 2026 21:05:46 +0000

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

New comment by uwemaurer in "Deep dive into Turso, the “SQLite rewrite in Rust”"

uwemaurer — Thu, 29 Jan 2026 16:37:18 +0000

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/

New comment by uwemaurer in "Show HN: Fence – Sandbox CLI commands with network/filesystem restrictions"

uwemaurer — Wed, 21 Jan 2026 11:33:23 +0000

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"

New comment by uwemaurer in "Why DuckDB is my first choice for data processing"

uwemaurer — Fri, 16 Jan 2026 19:41:09 +0000

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 directly from DuckDB SQL queries using the SQG tool ( https://sqg.dev/generators/java-duckdb-arrow/)

SQLite Driver Benchmark: better-sqlite3 vs. node:SQLite

uwemaurer — Fri, 16 Jan 2026 16:54:50 +0000

Article URL: https://sqg.dev/blog/sqlite-driver-benchmark/

Comments URL: https://news.ycombinator.com/item?id=46648615

Points: 1

# Comments: 0

Show HN: SQG – Compile SQL (SQLite,DuckDB) to TypeScript/Java Code

uwemaurer — Tue, 13 Jan 2026 16:26:03 +0000

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 analytics queries (DuckDB) it was annoying to copy the query out of the code into DBeaver, work on it and then copy it back into the code.

So I thought of a way of keeping the SQL queries in a separate file, compatible in DBeaver format so I can run them there, and also generate the code from it.

This works especially well with DuckDB since it has full type information of the query result, better than SQLite which has it only for fields, not for expressions.

For DuckDB it can also generate code using their Apache Arrow API for very fast access.

I hope you find it useful, I am glad to hear your feedback.

GitHub: https://github.com/sqg-dev/sqg Docs: https://sqg.dev Try it online: https://sqg.dev/playground/

Comments URL: https://news.ycombinator.com/item?id=46603165

Points: 2

# Comments: 0

New comment by uwemaurer in "Show HN: A better Hacker News front end"

uwemaurer — Sun, 19 Oct 2025 09:23:24 +0000

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

New comment by uwemaurer in "Bluesky: Updated Terms and Policies"

uwemaurer — Fri, 15 Aug 2025 05:52:44 +0000

Here are more detailed stats:

https://bluefacts.app/bluesky-user-growth

New comment by uwemaurer in "Revival: There appears to be media consensus: "Bluesky is dead.""

uwemaurer — Sat, 12 Jul 2025 11:25:31 +0000

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

New comment by uwemaurer in "Threads is nearing X's daily app users, new data shows"

uwemaurer — Tue, 08 Jul 2025 18:47:33 +0000

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

New comment by uwemaurer in "Bluesky Post Count and Author Stats"

uwemaurer — Tue, 24 Jun 2025 19:45:47 +0000

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 like it will start to grow again!