What kind of database software am I looking for?
December 5, 2012 8:31 AM Subscribe
Database question: what front-end tool is best for high-volume manual editing of content?
Background: I'm building a web/mobile flashcard app, or rather I've hired others to build it for me. Each "card" has a lot of content, let's say 15-20 fields, most of which are free text and the others are labels/categories/flags/etc.
The content is written mostly by others, in batches, then imported and extensively edited by me.
Currently I'm managing it all with a big Excel file, and my developer has made a web panel for me where I upload the latest version of this Excel file and he's got scripts that pull it into the SQL table that the app runs off of.
So far so good. But as you have probably guessed by now, it's getting to be too much to handle in Excel, even on a high end machine -- I'm at well over 3,000 records now and I'd really like to add another 5-10 internal fields per card, e.g. to keep a record of content that I've rejected and notes on why. It's not just the speed of search/sort operations, it's also the amount of content that can fit on a screen.
Obviously I need to switch to a better tool. But I have no idea exactly what I'm looking for or even what it's called. When I google "database frontend" I get stuff like PHPmySQL, which I've tried, and it seems much more like a GUI for managing the database structure than a practical way to edit content.
What I really want is something where I can add and edit records, scroll through, sort, filter and search them, just as easily as in Excel, or hopefully even more easily. Ideally I'd be able to either click on any particular field in the table and just edit it in place, like Excel, or alternatively open the whole record in a pop-up window with form elements (text boxes, check boxes, drop down menus) for each field that I can rapidly tab through and edit, then save and drop quickly back to the list view. And then export from this local database (or better yet, some defined subset of it) to a file I can upload to be pulled into the live database.