So with GameEx recently making the switch to SQLite, I figured it might be a good time to mention some decent SQLite database management tools. Here are two of my favorite free options (although admittedly I don’t work with SQLite very often)
SQLite Manager: This is actually a Firefox add-on, but despite that it still manages to hang with some of the more full featured free DB editors I’ve tried. I would imagine that this would be more than enough for the average GameEx user where the focus tends to be simple editing of data. If you’re already a Firefox user, this would be a pretty good fit.
SQLite Expert (Personal Edition): So maybe you’re not a Firefox user? Or maybe browser plug-ins just aren’t your bag, baby? SQLite Expert is a fairly full featured SQLite management tool. It’s going to take up 70 MB of hard drive space once installed, so you might want to consider whether you want a more heavyweight tool for the job, but it will definitely get the job done in style.
Those are the free tools I’ve used in the past for SQLite administration and management. I’d love to hear about any other suggestions and tools.
Update by T Speirs: You can also install the SQLite ODBC Driver and import/link the tables for editing within Microsoft Access.