(2021-09-09) Udell Query Like Its2022

Jon Udell: Query like it’s 2022. Monday will be my first day as community lead for Steampipe, a young open source project that normalizes APIs by way of Postgresql foreign data wrappers.

When I was at Microsoft I was bullish on OData, an outgrowth of Pablo Castro’s wonderful Project Astoria.

For a great example of what that can feel like, jump into the middle of one of Simon Willison’s datasettes, for example <san-francisco.datasettes.com>, and start clicking clicking around.

Back then I wrote a couple of posts on this topic[1, 2]. Many years later OData still hasn’t taken the world by storm

When you install Steampipe it brings Postgres along for the ride. Imagine what you could do with data flowing into Postgres from many different APIs and filling up tables you can view, query, join, and expose to tools and systems that talk to Postgres.

now it’s SQL. For a long time I set it aside in favor of object, XML, and NoSQL stores. Coming back to it, by way of Postgres, has shown me that: – Modern SQL is more valuable as a programming language than is commonly understood https://modern-sql.com/ – So is Postgres as a programming environment