Welcome back to the backend master class! 3 How to write & run database migration in Golang 4 Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx, sqlc 5 Write Go unit tests for db CRUD with random data 6 A clean way to implement database transaction in Golang 7 DB transaction lock & How to handle deadlock 8 How to avoid deadlock in DB transaction? Queries order matter! 9 Deeply understand Isolation levels and Read phenomena in MySQL & PostgreSQL 10 How to setup Github Actions for Go + Postgres to run automated tests 11 Implement RESTful HTTP API in Go using Gin 12 Load config from file & environment variables in Golang with Viper 13 Mock DB for testing HTTP API in Go and achieve 100% coverage 14 Implement transfer money API with a custom params validator in Go 15 Add users table with unique & foreign key constraints in PostgreSQL 16 How to handle DB errors in Golang correctly 17 How to securely store passwords? 18 How to write stronger unit tests with a custom go-mock matcher 19 Why PASETO is better than JWT for token-based authentication? 20 How to create and verify JWT & PASETO token in Golang 21 Implement login user API that returns PASETO or JWT access token in Go You can vastly extend TablePlus to fit your needs by installing plugins written by others or writing your own in JavaScript.1 Design DB schema and generate SQL code with dbdiagram.io 2 Install & use Docker + Postgres + TablePlus to create DB schema.
We help you troubleshoot your problems with TablePlus at a lightning speed. We shipped more than 1000 improvements over the past year. There's always something cool to be discovered in the new updates released weekly. With native build, we eliminate needless complexity and extraneous details that you can get it up and run in less than a second.Įvery function has a shortcut key to keep your hands always on the keyboard. We only focus on the most important features. We don't want to be an app that does many things, but masters none. We've built the best practices for SQL Editor into our default to help you boost your productivity You don't need to install any SSH client in order to connect to the server. Quickly get a snapshot of your database with multi-tab and multi-window view, as well as stay in control of what you have changed on your database with Code Review. It's also equipped with many security features to protect your database, including native libssh and TLS to encrypt your connection. Query, edit and save your database easily with a native app that can run fast like a Lambo. With native build, simple design and powerful features, it makes database management easier, faster and more efficient for you. Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL and more.
0 kommentar(er)
