new rule: talk about Iceberg without mentioning Hive or ACID properties. the vast majority of SQL users don't care (and shouldn't)! it's like explaining Dropbox starting w/ bringing up libfuse If you're new to iceberg lmk if you get something from this! roundup.getdbt.com/p/iceberg-gi... #databs
Anders
lots of juicy looking papers in the agenda for EDBT/ICDT 2025 happening this year in Barcelona! definitely going to be diving in more later today edbticdt2025.upc.edu?contents=det... #databs #edbc2025 #icdt2025
Anders reposted
I FINALLY asked for pronouncement on PEP 751 -- lock files for #Python : peps.python.org/pep-0751/ .
this is the clearest case for Arrow that I've ever seen. I love that it's high-level but also doesn't shy away from details when it's important. this should be a #databs canon text imho. thanks @ianmcook.bsky.social !
2025 is shaping up to be a breakout year for fast query result transfer with Apache Arrow. But what exactly makes it so fast? David Li, Matt Topol, and I break it down in this new blog post: arrow.apache.org/blog/2025/01...
TIL about relationalplayground.com makes relational algebra accessible to a SQL monkey like me. much better than in a dry textbook where it's normally found. #databs
imho, the most clear case Databricks has made in public on their Iceberg future post-Tabular acquisition. I agree with this vision of the future and it's nice to see DBRX sharing how they see themselves participating in it. worth clicking through the deck! #databs speakerdeck.com/databricksja...
8) this HN called out that smallpond abstracts supports using different query engines for different jobs (shuffling vs sorting). Very bullish on this future of right tool for right job and making it as simple as a config news.ycombinator.com/item?id=4323...
3) ray.io is the foundation of any training and inference infrastructure. I haven't had much exposure to Ray as a SQL monkey using DWHs, but it's just recently clicked for me how big of a deal it is
Anders reposted
Anders reposted
Anders reposted
Building Query Compilers by Guido Moerkotte (695 pages) Note: This is repost of @emresevinc.bsky.social's on X Link: pi3.informatik.uni-mannheim.de/~moer/queryc...
post two! The key technologies behind SQL Comprehension #databs, do not fear compiler concepts -- embrace them and the new world order they enable for us! read the great blog (& pretty diagrams!) @daveconnors3.bsky.social, truly a masterpiece docs.getdbt.com/blog/sql-com...
post one of a new series kicking off today whose larger thrust is effectively: understanding SQL, not just a job for the database! Post 1 lays out what the levels of understanding docs.getdbt.com/blog/the-lev... #databs
Look forward to these every year. Always love Andy's candor and insight on our little corner of the world. #databs
Buckle up because we're banging into the new year with my annual retrospective of the last year in databases! Highlights include license change blowback, Databricks vs. Snowflake gangwar, @duckdb.org's shotgun weddings, and buying a quarterback to impress your lover: www.cs.cmu.edu/~pavlo/blog/...
#ghostty dropping today is the GitHub equivalent of a Beyoncé album. My whole feed is everyone following it. Now I gotta at least try it right? github.com/ghostty-org/...
does anyone use the 1Password CLI? I feel it has potential to be very valuable for managing environment variables (esp for teams). but i'm hesitant to adopt bc it requires that every command you run consume the output of `op` developer.1password.com/docs/cli/get...
admittedly, I'm triggered by SFTP, but it's a good analogy! What if there was an SFTP where you didn't have to parse random-delimited text files, but could just query the tables inside?
@chris.blue writes a post-length version of “Iceberg on S3 is the new SFTP.” If you want to understand why SFTP is crucial to orgs, Chris has some great examples of how and why SFTP is used. All of his examples matched my experience in healthcare. #dataBS open.substack.com/pub/material...
Anders reposted
Great breakdown of the new S3 Tables feature that leverages Apache Iceberg. Including an explanation of the costs... which are complicated. #dataBS bigdata.2minutestreaming.com/p/meet-your-...
in AWS Glue Data Catalog, you can now read and write Iceberg tables using the Iceberg REST API. aws.amazon.com/blogs/big-da... previously platforms had to write a custom integration to read/write Glue Iceberg tables, not you can use the REST API! #databs #apacheiceberg #aws
4/ what about S3 Tables? aren't they then "bad" by not using the OSS API spec? 🤷 data teams are predominately on a single cloud, so what they need is a standard within a single provider. and, like @benesch.bsky.social said, always better to not have to think about catalogs and have it 'just work'
5/ fwiw, the S3 API is a standard of sorts, esp given that Cloudflare's equivalent service, R2, supports it. like @conormccarter.bsky.social said, if R2 (and Azure Blog, and GCP storage) support a table bucket style, we're moving towards standard interface/primitive bsky.app/profile/cono...
This also feels like something Cloudflare should do on top of R2 only with an Iceberg REST catalog implementation. To me, it actually feels more like the type of product that Cloudflare has been shipping, and would be a nice compliment to their serverless D1 database (~SQLite for up to 10GB)
in AWS Glue Data Catalog, you can now read and write Iceberg tables using the Iceberg REST API. aws.amazon.com/blogs/big-da... previously platforms had to write a custom integration to read/write Glue Iceberg tables, not you can use the REST API! #databs #apacheiceberg #aws
Anders reposted
S3 (Iceberg) Tables is everything I dreamt of, and more. I blogged some long-form thoughts: meltware.com/2024/12/04/s... I think we're about to see an explosion of data tools (@materialize.com, @clickhouse.com, @duckdb.org, et al.) learn to write Iceberg tables via S3 table buckets. #databs
Anders reposted
Need a holiday gift for the nerd in your life? How about a copy of my new book, Platform Engineering: A Guide for Technical, Product, and People Leaders! amzn.to/4eUz5zB
Anders reposted
Hey #dataBS and #datasky folks, Our new post about "how understanding Big O Notation & Execution Plans can optimize SQL queries" has just been posted. Check it out if you're interested, and we'd love to hear your thoughts! @hopefanhe.bsky.social open.substack.com/pub/pipeline...
Anders reposted
Welcome to #dataBS the creator of Apache Calcite & Mondrian, architect @ Looker, mentor to many @ ASF, and wizard of SQL: @julianhyde.bsky.social One of Julian’s most popular recent initiatives is bringing the metrics layer to SQL: hydromatic.net/hyde2024meas...
Hey #databs, I'm submitting to speak at Data Council in April, vote with a like to the reply with the talk that you think is the most interesting! www.datacouncil.ai/cfp-2025
Hey #databs, I'm submitting to speak at Data Council in April, vote with a like to the reply with the talk that you think is the most interesting! www.datacouncil.ai/cfp-2025