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

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

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

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

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

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

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 are just tiny and there is no room for significant improvements.

So I think trying to be better here is pointless, better focus on offering more helpful utility functions which might be missing in es-toolkit

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 preferred way is just use duckdb java API. I didn't see anything better in performance/efficiency. Also a SQL query is often easier to write

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-builder

Looking forward to your feedback!

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)"

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

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

https://apache.github.io/echarts-handbook/en/how-to/cross-pl...

also they have a very lightweight client library to add back interactive things like popups on hover when using server side rendering

Echarts has good documentation and examples so I think it should be vibe coding friendly when you reference the docs (eg with cursor)

We use Echarts on our Bluesky analytics site

https://bluefacts.app/profile/bsky.app

Really great experience, we optimized the imports to reduce bundle size.

For https://www.appbrain.com we also use it and had to optimize it even more.We render it server side and only return the SVG to the client.

Server side rendering is a very powerful feature only very few chart libraries support.

I didn't use Timefold but the predecessor Optaplanner, and I remember there were hard constraints which must always be true (eg one room can only be used for one meeting at a given time) and then there were soft constraints which were minimized (eg shorter distance is better)

so an optimization problem can then be described with a set of those hard/soft contraints

found you on Bluesky :D

How can we contact you? The support@... email is not working. I would like to report a small bug

Democratic politicians are joining Bluesky in growing numbers. This ranking tracks the most popular elected officials on the platform.