nullPointer Posted July 16, 2012 Share Posted July 16, 2012 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. 5 Quote Link to comment Share on other sites More sharing options...
Draco1962 Posted July 16, 2012 Share Posted July 16, 2012 Thanks for the share! There are a few HTPC frontends that use SQLite to manage their data needs so those using GameEx that are familiar should have no problems with the conversion. Quote Link to comment Share on other sites More sharing options...
nullPointer Posted July 16, 2012 Author Share Posted July 16, 2012 There are a few HTPC frontends that use SQLite to manage their data needs so those using GameEx that are familiar should have no problems with the conversion.Ha, that’s a good call! That was actually the basis of my recommendations above as I’ve used both for editing XBMC metadata (although rather infrequently as I mentioned). I’d love to hear about any other tools people are using for these purposes. Quote Link to comment Share on other sites More sharing options...
Krakerman Posted September 2, 2012 Share Posted September 2, 2012 Yes thanks I will give the SQLite PE a try. Quote Link to comment Share on other sites More sharing options...
KRC Posted September 3, 2012 Share Posted September 3, 2012 Another great post from you np, will definitely give this the once over when I get the chance, (Well im taking a couple of days off my projects so I can test all the releases that have come onto the scene, as I promised I would) Quote Link to comment Share on other sites More sharing options...
Stu1983 Posted September 3, 2012 Share Posted September 3, 2012 I use Database Browser Portable exclusively for working with GameEx SQLite Databases (based on a suggestion from Stu1983). There are a few other options available though. 2 Quote Link to comment Share on other sites More sharing options...
nullPointer Posted September 3, 2012 Author Share Posted September 3, 2012 Wow that looks great! Thanks for the share Stu! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.