Joe Redfern

Are you so keen on PythonAnywhere that you'd like to join the team? We're hiring a Senior Software Developer: blog.pythonanywhere.com/218/

GitHub - JosephRedfern/docker-mounter: Utility to mount Docker images locally without requiring container creation Utility to mount Docker images locally without requiring container creation - GitHub - JosephRedfern/docker-mounter: Utility to mount Docker images locally without requiring container creation

I wrote a utility to automate mounting of Docker images as a local filesystem, without requiring full container creation. It’s imaginatively named “docker-mounter”. It wrote it with static analysis in mind, but there might be other use cases!

Check it out: github.com/JosephRedfer...

#docker #linux

v24.12 Community Call Dec 19 - Every month we get together with the community (users, contributors, customers, those interested in learning more about ClickHouse) to discuss what is coming in the latest release.

🚀 Big news: Native JSON type for ClickHouse is now in beta in 24.12! 🎉

🔗 https://clickhou.se/3ZLmV5Y

Easier, faster JSON handling—directly in ClickHouse. Join our 24.12 release call in person to hear all the details directly!

Do you ever use the cursor to replay events? If so, have you hit any issues? I’ve seen the websocket stall for certain cursor ranges which is quite peculiar.

I’ve also seen the WS freeze (which would be fine if it weren’t for a bug in my implementation preventing resumption from working properly!)

I'm having a lot of fun playing with and writing about BlueHoover! Compare word usage over the last 24 hours:

https://altinity.com/blog/bluehoover-analyzing-bluesky-posts-with-clickhouse

#bluesky #analytics

this only seems to happen for certain cursor values - if I increase the value by a minute or so, the replay continues happily. is this something you've seen before, or is it likely that the issue is at my end?

@jaz.bsky.social hey! thank you so much for taking the time to develop jetstream. i've noticed that sometimes, for certain cursor values, the websocket seems to stall - it will deliver a handful of messages and then stop.

what's going on here then?

It's not exactly "hands-on", but they recently put out a paper describing ClickHouse's architecture - it's pretty accessible and might be useful to you: www.vldb.org/pvldb/vol17/...

I've made some updates to my BlueSky firehose analysis dashbord - notably trend analysis, but also performance improvements too.

You can view the dashboard here: bluesky.joesstuff.co.uk and find the source code here: github.com/JosephRedfer....

#clickhouse #bluesky

Oh, have just seen you're doing the very same, but better!

Bluesky has Alexey tech demo written all over it! I've started ingesting the Firehose into a ClickHouse instance. Very early days, but you can make some basic queries here: bluesky.joesstuff.co.uk if interested.

I will open source it (and improve visualisations) once I've tidied it up a bit...

hello, time traveller