Bit the bullet and it shows up fine in substack app. 🤷‍♂️ Super weird.

This is at the bottom of the post looks like for me. Refreshed many times. The title of the post isn’t tappable either which I thought might take me to the whole post.

Materialized View | Chris | Substack Software infrastructure hot takes, projects, papers, developer interviews, and deep dives. Brought to you by Chris Riccomini. Click to read Materialized View, by Chris, a Substack publication with tho...

I only see the first 3 paragraphs of this post on materializedview.io but seems like there should be more?

Very cool! But no geo type! ducklake.select/docs/stable/...

@bcantrill.bsky.social @ahl.bsky.social Do you know if anyone has deployed RFD infrastructure outside of Oxide? Looking to pull it off but curious if anyone else has.

My original thinking was just showing the list of column names and their parquet types vertically rather than showing the full table contents.

Pretty cool. Any way to view parquet metadata rather than the table?

They have this in Mass and many towns have refused to comply. Curious how these laws will really play out.

I bought some Third Wave Water packets and made some side by side cups… I could barely taste the difference. Either tap is fine by me or I’m just not refined enough.

Same!

I’ve written a fair amount of sql the past few years but the recursive kdtree query @paleolimbot.bsky.social references here is probably my favorite query I’ve ever come up with.

@davidfrenchjag.bsky.social Thanks for making my commutes interesting… twice per week.

source.coop?

I’d be happy to share how Overture does it using Spark and Sedona.

I find it super annoying whenever I have to do this. Are there performance implications to either approach?

Since you’re copying the foursquare data you could include a geometry column rather than individual lat/lons

This is cool. This is inspiring me look into setting up something similar for Overture Maps data just with with views over our s3 parquet files. Even that is much nicer than read_parquet() with a super long s3 path.

YouTube video by Crunchy Data Getting Started With Overture Maps with Dana Bauer and Jake Wasserman

Had fun talking about Overture Maps and Geoparquet at PostGIS Day. youtu.be/i1jVvVG_Y48?...

Add Bandle to the list!