mariadb-playground

From https://github.com/peter-evans/docker-compose-actions-workflow

Prerequisites

• Unzip tool
• MariaDB client
  • DBeaver, or
  • HeidiSQL x64 Portable, or
• Download MariaDB Server - MariaDB.org
• MYSQL
  • https://cdn.mysql.com/Downloads/MySQL-8.0/mysql-8.0.33-winx64.zip

How to use

1. Download / git clone this repo
2. Unzip
3. Run local-dev.cmd or local-docker-dev.cmd for initialization
4. Run mariadb-playground.exe --database=default --docker=true or ./mariadb-playground --database=default --docker=true in docker every time to (re)create DATABASE (database name "EIE3112")
5. Connection string "root:@tcp(localhost:3306)/?charset=utf8&parseTime=True"

TODOs

• test cases
• database name as mariadb-playground.exe's argument
• Performance tuning (Query explain)
  • MySQL :: MySQL Workbench Manual :: 7.1 Performance Dashboard
  • DBeaver Documentation
  • Ctrl + Shift + E to explain current query
• Indexing
• full text search
• Faking
  • pioz/faker: Random fake data and struct generator for Go.
• SQL Injection
  • Hacking Websites with SQL Injection - Computerphile - YouTube
• GORM
  • Join without raw string (Preloads)
    • 预加载 | GORM - The fantastic ORM library for Golang, aims to be developer friendly.
  • db.Joins("Company", DB.Where(&Company{Alive: true})).Find(&users)
  • gorm package - gorm.io/gorm - Go Packages