Experience Developing a Firewall Module for MySQL
summary
A team describes building a MySQL firewall module using the ANTLR parser generator and Kotlin. They cover when ANTLR is appropriate, how to design an ANTLR grammar for MySQL, runtime performance comparisons of ANTLR implementations (C#, Java, Kotlin, Go, Python, PyPy, C++), supporting DSLs, and a microservice architecture for the SQL firewall, plus the results obtained.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 7:40SQL parser approach
- 12:15Prototyping with ANTLR
- 16:10Runtime language tests
- 20:07Performance results
- 23:20Universal SQL tree
- 24:49Key takeaways
related talks
49mBuilding a MySQL Database Driver in Elixir
30mDriving Innovation in MySQL with Extensions
20mHardening MySQL: MySQL Security Basics - MySQL security Tutorial
27mDesign Considerations for a simple Extension Framework For MySQL- 49mBuilding a MySQL Database Driver in Elixir
47mApplication Architecture Using MySQL
37mBuilding Database Applications with Database/SQL
57mPerformance Analysis and Optimization of MySQL