Today's episode is with database educator, PHP enthusiast, and all-around good guy Aaron Francis.Aaron is one of the best out there at delivering high-quality educational content. Somehow, he's managed to have three different video courses sell over $100k in wildly different fields -- a college corporate accounting class aide, video screencasting, and high-performance SQLite.In this episode, we talked about a lot of things, including:- Why (and when!) to use SQLite- What courses he's looking at next- How to stay sharp when doing educational content- His origin story as a programmer- Getting kids to be high agency- How PHP became classy.Linkshttps://www.epicweb.dev/why-you-should-probably-be-using-sqlitehttps://highperformancesqlite.com/TimestampsIntro 01:41Why SQLite 03:31When to use SQLite 09:14SQLite Creators 14:20Holy smokes 17:29jsonb Indexing? 22:07SQLite Course 23:54Vendor Specific Courses? 26:17Postgres Course Timing 30:26Nights and Weekends 30:46Getting into Databases 35:38Going back to Programming 39:22In 20 years 40:48Kids 42:08Making money is a skill? 47:52Balancing Video Creation and Programming 50:43Sustainable Business 54:23Doing SaaS 56:13Working for someone else 57:38Secret Sauce for Video Content 58:34PHP 01:05:56Taylor and Laravel 01:13:31Vue 01:18:39Warp-up 01:20:41

Dax Raad, a witty tech Twitter personality known for his sharp insights, joins the conversation to discuss SST, the infrastructure as code tool he's passionate about. He shares exciting details about their new engine, Ion, and its user benefits. The duo dives into cloud provider trustworthiness, the evolution of infrastructure management, and the marketing strategies that resonate with developers. Dax also compares code-based workflows to UI tools, emphasizing coding's efficiency in handling complexity.

Manny Silva, Head of Docs at Skyflow and creator of open-source documentation verification projects, shares insights on his innovative tools, Docs as Tests and Doc Detective. He discusses how these frameworks automate documentation testing, ensuring alignment with evolving products. Topics include the challenges of maintaining documentation freshness in fast-paced environments and the importance of collaboration between technical writers and engineering teams. Manny's approach provides a systematic method to improve documentation processes, reflecting the growing need for quality in tech.

Bill Tarr, AWS SaaS Factory expert, discusses SaaS architecture challenges, infrastructure decisions, Gen AI integration, permissioning, and security in multi-tenant setup. Insights on Amazon Bedrock, control plane vs. application plane, and quickfire questions on SaaS.

In this episode, Kyle Galbraith tells us about his company, Depot.dev, which is a way to make Docker builds and GitHub action runners complete much faster with basically no changes to your build step. Depot is growing like crazy and just surpassed *one million* builds per month. We looked at how he found the idea for Depot and some of the technology underlying the service.Kyle also shares a ton of wisdom about building a company and specifically a developer tools company. This includes his experience in YC (including how hard he worked on his YC application) and the importance of having "model companies" that are a few steps ahead of you in the process. We talk about how the funding market has change and how he thinks about hiring, fundraising, and profitability.His advice on company building and the focus on what's important is super helpful to those in a similar position.

Author Andrew Atkinson shares insights on optimizing Postgres for Rails, including schema tightness, operation handling, and performance testing. The podcast covers Andrew's journey of writing a book, indexing pitfalls, database best practices, and advanced Postgres features. Discussions range from balancing book writing with work, investing in private companies, to potential NBA trade decisions.

ParadeDB is Postgres for search and analytics. As Postgres continues to rise in popularity, the "Just Use Postgres'' movement is getting stronger and stronger. Yet there are still things that standard Postgres doesn't do well, and advanced search and analytics functionality is near the top of the list.The ParadeDB team provides a pair of Postgres extensions. The first, pg_search, brings a more performant and full-featured search experience to Postgres. It uses Tantivy (think: Lucene but Rust) as the search engine and provides advanced ranking and querying functionality. The second, pg_lakehouse, allows you to perform large analytical queries over object store data. Together, these provide compelling new features wrapped in a familiar operational package.Philippe Noël is one of the founders of ParadeDB. In this episode, we talk about why these extensions were needed, why the 'Just Use Postgres' movement exists, and where ParadeDB fits in your architecture.Follow Philippe: https://x.com/philippemnoelFollow Alex: https://x.com/alexbdebrieFollow Sean: https://x.com/seanfalconerCheck Out ParadeDB: https://www.paradedb.com/Timestamps01:50:18 Intro04:30:23 Where does seach on Postgres fall down?05:33:09 BM25 and TF-IDF07:23:03 Postgres Tipping Point10:05:08 Tantivy11:50:14 Tantivy vs Lucene13:07:06 vs ZomboDB15:35:21 Just Use Postgres for Everything?17:57:17 Developing a Postgres Extension19:26:03 Arvid's Problem20:27:08 Postgres and Log Data23:28:01 Separate OLTP and Search Instances28:32:01 Search Nodes vs OLTP Nodes30:02:12 ParadeDB Analytics35:27:05 Hosted Service39:03:15 Stumbling upon the Idea39:51:22 Community41:01:15 Getting Started with ParadeDB

Mark Huang, Co-founder of Gradient, discusses the exciting world of autonomous AI agents and extending context windows for AI models. They explore the impact of longer context windows on use cases and share insights on advancements in AI technology.

Today we have Bob van Luijt, the CEO and founder of Weaviate on the show. Bob talks about building AI native applications and what that means, the role a vector database will play in the future of AI applications, and how Weaviate works under the hood.We also get into why a specialized vector database is needed versus using vectors as a feature within conventional databases. Bob van Luijt: https://www.linkedin.com/in/bobvanluijt/Sean on X: https://x.com/seanfalconerSoftware Huddle ⤵︎X: https://twitter.com/SoftwareHuddleSubstack: https://softwarehuddle.substack.com/

Today, we have Talia Nassi on the show. Talia’s been leading Developer Advocacy at Akamai.Akamai is in a really interesting space where they've been around for a long time, as a CDN provider, as a security provider, and now they acquired Linode, and acquired a bunch of other companies which has expanded them into more of like a full fledged cloud provider.We had a really interesting discussion talking about the expansion, we also talked about her thoughts on infrastructure as code, multi cloud, and just getting into DevRel and what that experience has been like for her.