Level Up Your RDBMS Productivity in Go - Streamlining Database Management

Explore advanced techniques for enhancing RDBMS productivity in Go during this 50-minute GoLab conference talk. Discover an SQL-first approach to streamline database management and simplify workflows. Learn about integrating open-source tools like dbmate for automatic migrations, sqlc for type safety, and testcontainers for integration testing. Follow along with live coding demonstrations using a PostgreSQL database to see practical applications of these techniques. Gain insights into handling common challenges such as typing issues, setting up test instances, and managing migrations. Understand the benefits of running databases in Linux containers for comprehensive testing and early issue detection. By the end of this talk, acquire valuable strategies to improve your Go coding workflow and database management skills.

Intro
Introducing myself
Disclaimer
Status
Handling the BE code
Errors in CQL
SQL Injection
Code andb
Manual sync
Automated testing
Todays topics
SQL
Other approaches
Why we dont like Orion
Why we dont like Query Builders
SQL first approach
Migrations
Test Containers
Robots
Project
Query
Questions
Twostage migration
Migrations in the CD pipeline
Testing Migrations
Docker Test