SQLDisplay - a simple visual database query program

February 16th, 2010, 00:06 Posted By: wraggster

News/release from Dragonminded:

So I got tired of scrolling through a flat text file to see if I had a particular game before buying it at a swap meet. A few weeks ago I buckled down and threw together a program that can load SQL dumps and display them on the DS. Included is the ability to load multiple tables and filter down based on the text of one or more columns. Since everything visual is gathered from the database it should be compatible with just about any SQL dump you throw at it.

Should support:
- CREATE, INSERT instructions
- As many entries or strings until memory runs out
- SQL style character escapes ('' not \')

Known issues:
- No scrolling for more than 9 tables in a database.
- Only handles "text" (should handle integers but I never tested it).
- Hacky UI.
- No support for multiple databases.
- "Contains" option is not implemented.

Possible additions or updates:
- Contains, group select, greater/less than support
- Better string handling to take less memory and run faster
- Your idea here!

To use this, DLDI patch with your particular card driver. Create a directory named database at the root (can be hidden if you want). Every file inside /database/ will be loaded and treated as a SQL table dump.

The file itself is available here. http://www.dragonminded.com/ndsdev/SQLDisplay.nds

There are 1 comments - Join In and Discuss Here