I started fiddling with SQLite way back in the middle of last year, and since then I’ve been on the lookout for a good, stable piece of software to ease development with it — mainly for building tables, entering test data and creating queries that will eventually be used in my application.
I’ve tried…well I forget exactly how many: at least half a dozen, but at best they’ve been rather cumbersome, most have been buggy, the worst have been totally unusable. For some reason it seems like the sort of project that people start but never properly finish: heck, I even thought about writing one myself.
Anyway today, while looking for something else, I stumbled across SQLite2007 Pro by osen-soft. It’s a very slick product with all the features you could wish for, and it’s free too.