A journey of implementing an Eclipse plugin to improve the quality of database usage

on YouTube ↗34m

" summary

Describes implementing SQLInspect, an Eclipse plugin that statically analyzes Java code to extract and inspect embedded SQL by performing string analysis with the Eclipse JDT parser. It identifies database-quality issues (SQL antipatterns, expensive queries like deeply nested subqueries, missing indexes/triggers) and was applied to thousands of Android apps on GitHub, with fixes delivered via pull requests.

AI-written summary · about

" related talks

• 26mBuilding a MongoDB Plugin With the DataGrip TeamKevin Mas Ruiz, Gaurab Aryal · JetBrains Plugin Developer Conf 2024
• 31mBuilding an IDE plugin for clean code generationRoman Kamyshnikov · droidcon London 2025
• 18mApparently, you can "debug" your SQL queriesEyal Trabelsi · Conf42 Observability 2023
• 36mSQLancer: Automatically Finding Bugs in Database Management SystemsManuel Rigger · SPLASH 2020 REBASE
• 43mPutting an 'I' in Code Review Turning Code Reviewing InteractiveOfer Maor · AppSecUSA 2016
• 21mSupercharge Android Studio: Developing Your First PluginIdan Nakav · droidcon San Francisco 2024
• 33mDeveloping Java applications using Visual Studio CodeMartin Aeschlimann · Devoxx Belgium 2017
• 36mDebug Java code like a ProMikaël Barbero · EclipseCon Europe 2017