Prairie Postgres
  • About Us
  • News
  • Events
  • Learn PostgreSQL
  • Join or Sponsor
Contact Us

Learn PostgreSQL from Community Experts


Beginner

  • Build strong SQL and relational database foundations
  • Learn schema design, constraints, and data modeling
  • Get hands-on with PostgreSQL tools and workflows
๐Ÿ‘‰ Start Beginner Path โ†’

Intermediate

  • Master performance, indexing, and query optimization
  • Work with application integration, security, and APIs
  • Learn backups, monitoring, and real-world operations
๐Ÿ‘‰ Start Intermediate Path โ†’

Advanced

  • Design scalable systems with replication, HA, and PITR
  • Deep dive into internals, extensions, and architecture
  • Explore AI workloads, distributed systems, and research
๐Ÿ‘‰ Start Advanced Path โ†’

Meetup Talks


  • March 17: Building Apps on Postgres in the Claude Code Era

    Speaker: Paul Whalen Senior Staff Software Engineer @ PEAK6 Capital Management

    Abstract: Paul shares practical lessons from building Postgres-centric applications using Claude Code, highlighting strengths, limitations, and strategies for effective agentic development. The session offers actionable insights and open discussion for developers working with AI-assisted coding workflows.

    Slides: Early-Learnings-Building-Apps-on-Postgres-in-the-Claude-Code-Era

  • February 18: The New Postgres AI Ecosystem

    Speaker:  Shaun Thomas, Principal Software Engineer at pgEdge:

    Abstract: Beyond pgvector, building real AI on Postgres means integrating RAG and MCP to ground LLMs in accurate data and enable safe, actionable workflows. This talk explores how tools from pgEdge help turn Postgres into the core of a complete, production-ready AI stack.

    Slides: The-New-Postgres-AI-Ecosystem-Slides.pdf

  • January 13: Configuring PostgreSQL for Logging & Query Optimization

    Speaker: Ryan Booz Solutions Engineer pganalyze

    Abstract: This session explores practical techniques for identifying and optimizing slow PostgreSQL queries using tools like pg_stat_statements, auto_explain, and query logging. It also highlights common query patterns that benefit from rewrites, with hands-on strategies to improve performance.

    Slides: Slides-And-Query-Examples-Here

1 2 3
Next Pageยป

Bylaws

PostgreSQL Code of Conduct

Privacy Policy

About Us

  • GitHub
  • LinkedIn
  • Meetup
  • Mastodon
  • YouTube

With thanks to our sponsor

Postgres, PostgreSQL, and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.