Sexybiggetje🐖 on Nostr: I'm on holiday leave, so naturally I was working on semi-work related stuff. A while ...

I'm on holiday leave, so naturally I was working on semi-work related stuff. A while ago I gave a database course, because some essentials are missing. Starting colleagures usually don't know about database indexes or compound indexes.

So now I've created a tool that does some simple analysis and reference counting on a query log and a #database #schema and outputs single and compound index advisories;

Lookies here; https://github.com/martijndeb/bigdex

#mysql #php #opensource