Big data is dead, analytics is alive (Practical AI #292)

Changelog Master Feed

We are on the other side of “big data” hype, but what is the future of analytics and how does AI fit in? Till and Adithya from MotherDuck join us to discuss why DuckDB is taking the analytics and AI world by storm. We dive into what makes DuckDB, a free, in-process SQL OLAP database management system, unique including its ability to execute lighting fast analytics queries against a variety of data sources, even on your laptop! Along the way we dig into the intersections with AI, such as text-to-sql, vector search, and AI-driven SQL query correction.

Join the discussion

Changelog++ members save 9 minutes on this episode because they made the ads disappear. Join today!

Sponsors:

• Fly.io – The home of Changelog.com — Deploy your apps close to your users — global Anycast load-balancing, zero-configuration private networking, hardware isolation, and instant WireGuard VPN connections. Push-button deployments that scale to thousands of instances. Check out the speedrun to get started in minutes.
• Timescale – Real-time analytics on Postgres, seriously fast. Over 3 million Timescale databases power loT, sensors, Al, dev tools, crypto, and finance apps — all on Postgres. Postgres, for everything.
• Notion – Notion is a place where any team can write, plan, organize, and rediscover the joy of play. It’s a workspace designed not just for making progress, but getting inspired. Notion is for everyone — whether you’re a Fortune 500 company or freelance designer, starting a new startup or a student juggling classes and clubs.

Featuring:

• Till Döhmen – Twitter, GitHub, LinkedIn, Website
• Adithya Krishnan – Twitter, GitHub, LinkedIn, Website
• Chris Benson – Twitter, GitHub, LinkedIn, Website
• Daniel Whitenack – Twitter, GitHub, Website

Show Notes:

• DuckDB
• MotherDuck
• Introducing FixIt: an unreasonably effective AI error fixer for SQL

Something missing or broken? PRs welcome!

Hoofdstukken

1. Welcome to Practical AI (00:00:00)

2. Sponsor: Fly.io (00:00:35)

https://fly.io/

3. Struggling with big data (00:04:19)

4. This is the way (00:08:47)

5. Introducing DuckDB (00:12:03)

6. What is in-process? (00:14:12)

7. Sponsor: Timescale (00:17:03)

https://www.timescale.com

8. Uses for DuckDB (00:19:35)

9. Embedded environments & the edge (00:22:41)

10. Standardizing fast interfaces (00:23:55)

11. Vector search (00:28:36)

12. Sponsor: Notion (00:30:55)

http://notion.com/changelog

13. Bringing MotherDuck to the cloud (00:33:05)

14. Problems solved (00:36:02)

15. Cloud & local compatibility (00:38:59)

16. What makes it appealing? (00:40:42)

17. New cool things (00:43:43)

18. Thanks for joining us! (00:48:42)

19. Outro (00:49:32)