Tired of Slow Apps? Upgrade Your AI with pg-aiguide! PG AI Guide GitHub: https://tsdb.co/eddiej-yt Is your PostgreSQL database slowing down your app as it grows? You are not alone. In this video, I walk you through how I used the Open Source project pg-aiguide to turn my new SaaS - Picky Bun - from constantly crashing into a high-performance machine. We’ll explore why general AI coding assistants often generate outdated or inefficient SQL and how a specialised MCP Server can provide senior-level database expertise to your workflow. In this video, you will learn: The Picky Bun Story: Building a niche app for food allergy sufferers using Next.js, Prisma, and Supabase. The Scaling Problem: Why apps that work perfectly with 10 database entries often fail once they hit 10,000+. What is pg-aigude?: An introduction to the Model Context Protocol (MCP) and how it optimizes PostgreSQL schemas. The Transformation: Watch me install pg-aiguide in VS Code and implement 15+ performance-boosting index and query suggestions. The Results: See the home page load time drop from "timeout/crash" to under 1.5 seconds on a massive dataset. Tech Stack Used: - Frontend/Backend: Next.js (React) - Database: PostgreSQL via Supabase - ORM: Prisma - Styling: Tailwind CSS & shadcn/ui - AI Tools: GitHub Copilot & pg-aiguide Thank you Tiger Data for sponsoring this video. Links & Resources: - PickyBun Website: https://pickybun.com

During my recent live stream with Adam Whittingham, we had a classic "don't look at my secrets" moment. A huge thanks to the community members like @razvanmuntian who jokingly offered to close their eyes while we managed the API tokens! Spoiler alert, Adam came prepared. It's these authentic moments that make building and sharing in public so rewarding and fun - build real connections without trying. In the live stream we explored how @Cronofy handles the heavy lifting of scheduling infrastructure: ✅ One API for everything: Connecting Google, Outlook, and Apple calendars without the integration headache. ✅ Native Experience: Embedding booking UI that feels like it belongs in your app. ✅ Intelligence: Automating availability and even meeting recordings with AI agents. ...and more! Have you had a "secrets" oops moment when screen sharing? Share below 👇

Join me for an exclusive deep-dive into the power of Cronofy, the leading provider of Meeting and Scheduling Infrastructure for developers and product teams! In this livestream I am joined by Adam Whittingham VP of Engineering at Cronofy, who will be walking us through the platform, showing us how to integrate native scheduling features into any application without building everything from scratch. With Cronofy we can power all aspects of the meeting lifecycle; from scheduling calls, to provisioning conferencing links and meeting agents that record and transcribe the call. What We'll Cover: - The Cronofy Advantage: Understand how Cronofy simplifies the complexity of integrating with multiple calendar providers (Google, Outlook, Apple, etc.) using a unified platform. - Calendar API & Availability API: See how their APIs to effortlessly connect user calendars, check real-time availability, and prevent common scheduling friction like time zone issues. - Embedded Scheduler: Learn how to quickly deploy native-feeling booking and rescheduling experiences using the Embedded Scheduler. - Post-Meeting Value: A look at tools like Cronofy Meeting Agents for capturing recordings and transcripts to feed valuable insights back into your product. Bring your questions and get ready to learn the secrets to shipping powerful scheduling functionality faster than ever before! Find Cronofy Online: https://www.cronofy.com

I am going to create a website monitoring tool that will check if my website is up / or down. This will be on a scheduler (cron) every 15 minutes and the response should be a status code of 200. If not, then it will create a GitHub issue with a label "bug" on my GitHub repo. I will do this with YAML config using the Open Source project Kestra which is an orchestration tool. If you missed my video on how to contribute to Open Source with the Kestra GitHub repo watch it here: https://youtu.be/Qa0ZgJJjJVI Take a look at Kestra's GitHub repo and their good first issues: https://github.com/kestra-io/kestra If you prefer to read, I have a blog post version of this video here https://eddiejaoude.substack.com/p/monitor-your-website-with-yaml-using 0:00 Website monitoring Flow with Kestra 2:24 Kestra running with Docker Compose 3:13 Kestra Dashboard and creating first Kestra Flow 4:20 Kestra Execution walkthrough for Flow run 7:28 Kestra Dashboard with data 7:59 Kestra Flows 8:21 Kestra Execution list 8:45 Kestra Logs page 9:24 Kestra Namespaces 9:45 Kestra KV Store (Key-Value store) 11:00 Kestra Blueprints 11:41 Kestra Plugins 12:28 Kestra Administration 12:39 Kestra Flow basic config 17:30 Kestra Flow to monitor our website 33:32 Kestra Triggers 35:37 Kestra right navigation with news, docs, help etc

Why not start the week by contributing to Open Source? A good place to start is Kestra's Good First Issues on their GitHub repo. In this video I will tell you why you should contribute to Open Source and show you how you can get started today. We will use git, the terminal / command line (CLI), Cursor AI and GitHub. Contribute to Kestra's Open Source project on GitHub: https://github.com/kestra-io/kestra 0:00 Introduction to Open Source 2:16 How to find good Open Source projects to contribute to 3:29 How to check the Open Source project is friendly 7:31 The GitHub Issue I will fix on the Kestra Repo 16:50 Markdown tips to create better Issues, Pull Requests and Comments 25:56 Git changes, creating a git branch and pushing to our GitHub fork 32:04 Creating the GitHub Pull Request 40:56 Updating your GitHub fork using git on the command line (terminal) 46:39 How to keep contributing to Open Source: next steps #github #opensource #git #kestra #goodfirstissue

You can tune in on LinkedIn or X for live demonstrations, interviews and community spotlights! ⏰ June 24, 2025 at 10:30am PT (5:30pm UTC) 🔗 Register here not to miss out! https://www.linkedin.com/events/7340777668130312193/comments/ See you at the The Developer Show powered by @gitlab

You don't need to spend one year building an app. You can build a SaaS that is an MVP and deploy within a week to get user feedback and start generating income. I will take you from creating a new GitLab and NextJS project all the way through to deploying to Sevalla cloud hosting for the end user and all the steps in between. Take a look at Sevalla cloud hosting here: https://sevalla.com Chapters 0:00 Introduction to building a SaaS 1:19 Tools we will use to build the SaaS 1:54 GitLab - git repo and project management 2:14 CursorAI - VScode with AI 2:32 NextJS with Typescript 2:34 TailwindCSS (Tailwind) 3:08 Husky for Git commit hooks 3:14 Primsa ORM with Postgres (PostgreSQL) 3:21 Authentication with Clerk (OAuth) 3:39 Sevalla cloud hosting 4:16 GitLab project setup with Kanban issue board 11:06 Create NextJS project on the CLI 12:18 Connect local git repo to GitLab using git remote 14:30 CursorAI 20:18 Deploy SaaS to Sevalla cloud hosting (free static hosting) 27:48 Clerk setup with NextJS 33:54 CRUD monitors with NextJS, Prisma and Postgres 50:22 Scheduler / cron to make http ping to all monitors 56:49 Display ping data on monitor list 58:17 Show a list of pings for each monitor 01:01:02 Add graphs to improve visualisation of http data 01:09:51 Deploying to Sevalla cloud hosting 01:26:31 Future considerations for the SaaS 01:29:09 Conclusion

Themes like Dark and Light mode are not needed from Day 1. Ship your product and add these extra features later on

When coding, we are not always coding. We need to think, analyse, plan, probably Google, and then code! What do you think of today's office? When coding, we are not always coding #digitalnomad #devlife

Prisma ORM Typescript models #prisma #orm #database

Twitter (X) pinned post #twitter #socialmedia

STOP using SQL SELECT * #sql #orm #postgres #mysql

200k on Twitter (X) Payout 🤑 #twitter #x #socialmedia

I love experimenting with Vercel's AI v0 for new project designs

Optimization tends to be reactive rather than proactive, as most people are unsure when to optimize. In this video I look at why there are certain situations when you really should be optimizing your project as soon during the development stage to test new features and pages of your project, and how Prisma's Optimize is a game changer for this. Prisma's Optimize is an AI-Driven Query Analysis tool where you can gain deep insights and get actionable recommendations to improve your database queries, making your app run faster and cheaper. You get insightful query metrics and AI powered recommendations. Plus the AI assistant helps you understand these recommendations by asking follow up questions or reviewing your code. This is all done locally, you don’t even need to deploy your app to get the results you need to improve your app's performance. To try out Prisma's Optimize here: https://www.prisma.io/optimize --- ## MY BLOG AND NEWSLETTER For my articles on Open Source as a Contributor and Maintainer, Web Development with Javascript and Typescript, my experience as a freelancer and remote work as a Digital Nomad, Content Creation, Personal Branding and monetising these, check out my Substack: https://eddiejaoude.substack.com ## SERVICES I USE AND RECOMMEND Some of these might be affiliate links but they're no extra cost you and you might get a discount if you sign up. - Live streaming with Streamyard https://streamyard.com/pal/c/6103980796280832 - Cloud hosting with Digital Ocean, you will get $100 FREE credit https://m.do.co/c/c25882c2a61d --- #ai #postgres #sql Improve your database queries with Prisma Optimize AI