uwemaurer

4 ms·

1. 1.▲
   by uwemaurer 3mo ago

   Looks great! How does it compare to Zulip? we self host zulip and are quite happy with it
2. 2.▲
   by uwemaurer 5mo ago

   Yes, I tried it to generate a cool profile stats video for Bluesky, for example see here: https://bluefacts.app/video/bsky.app
3. 3.▲
   by uwemaurer 6mo 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/
4. 4.▲
   Benchmarking DuckDB from Java: Fast Insert, Update, and Delete(sqg.dev)

   2 points by uwemaurer 6mo ago|0 comments
5. 5.▲
   by uwemaurer 6mo 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 wa
6. 6.▲
   I benchmarked bulk insert into PostgreSQL from Java (also via DuckDB / Arrow)(sqg.dev)

   3 points by uwemaurer 6mo ago|0 comments
7. 7.▲
   by uwemaurer 7mo 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
8. 8.▲
   by uwemaurer 7mo ago

   Thank you for the suggestion!
9. 9.▲
   SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support(sqg.dev)

   20 points by uwemaurer 7mo ago|6 comments
10. 10.▲
    by uwemaurer 7mo 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
11. 11.▲
    by uwemaurer 8mo 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/
12. 12.▲
    by uwemaurer 8mo ago

    Here are some independent stats: https://bluefacts.app/bluesky-user-growth
13. 13.▲
    by uwemaurer 8mo 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/
14. 14.▲
    by uwemaurer 9mo 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"
15. 15.▲
    by uwemaurer 9mo ago

    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
16. 16.▲
    SQLite Driver Benchmark: better-sqlite3 vs. node:SQLite(sqg.dev)

    1 points by uwemaurer 9mo ago|0 comments
17. 17.▲
    Show HN: SQG – Compile SQL (SQLite,DuckDB) to TypeScript/Java Code(sqg.dev)

    2 points by uwemaurer 9mo ago|0 comments
18. 18.▲
    by uwemaurer 1y ago

    how do you like my hackernews frontend: https://news.facts.dev/
19. 19.▲
    by uwemaurer 1y ago

    Here are more detailed stats: https://bluefacts.app/bluesky-user-growth
20. 20.▲
    by uwemaurer 1y ago

    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
21. 21.▲
    by uwemaurer 1y ago

    Bluesky has still a lot to catch up: https://bluefacts.app/bluesky-user-growth
22. 22.▲
    by uwemaurer 1y ago

    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!
23. 23.▲
    Bluesky user activity has declined by 23% over the past three months(bluefacts.app)

    21 points by uwemaurer 1y ago|21 comments
24. 24.▲
    by uwemaurer 1y ago

    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 "better performance" since most helpers functions ar
25. 25.▲
    by uwemaurer 1y ago

    Always great to see efforts to make working with data frames easier. Here are some similar data frame libraries for Java: https://github.com/jtablesaw/tablesaw https://github.com/dflib/dflib My pr
26. 26.▲
    by uwemaurer 1y ago

    Our Bluesky trends and insight app is live on Uneed today. We'd appreciate an upvote. In addition to daily user and engagement rankings, we launched a new feed builder for Bluesky last week: http://bluefacts.app/feed-bu
27. 27.▲
    by uwemaurer 1y ago

    you can do it with a command line like this: duckdb -c "attach 'sqlite-database.db' as db; copy db.table_name to 'table_name.parquet' (format parquet, compression zstd)" in my test database this is
28. 28.▲
    by uwemaurer 1y ago

    Here is a chart with the number of Android Apps in Google Play (over time): https://www.appbrain.com/stats/number-of-android-apps
29. 29.▲
    by uwemaurer 1y ago

    We had this idea to use a page rank based algorithm to compute a influence score based on the score of the people who follow you. A high score usually indicates a trusted account. Check it out here: https://bluefacts.app/top
30. 30.▲
    by uwemaurer 1y ago

    Congratulations! Always good to have some competition, I created this feed builder for Bluesky: https://bluefacts.app/feed-builder My focus was on simplicity, to get started without difficult setup