SQL Explorer

[cbk1994]

I present to you SQL Explorer, an in-game SQL database manager for Graal.

For those of you who aren't familiar, SQLite is a "software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine". Basically, it's a really fast and efficient way to store data into tables. Data can range from logs to bank accounts to sparring stats. SQL Explorer is a multipurpose tool that makes it easy to view and manage all of this data.

Current Version: 2.2

Features:

• Create, drop, duplicate, and rename whole tables
• Create and drop indexes on tables
• Insert rows into tables
• Duplicate rows in tables
• Modify rows in tables
• Delete rows in tables
• Automatic pagination for table viewing
• "Execute SQL" tab that allows you to test and run SQL queries and view data in more advanced, customized ways
• Tables can be sorted directly from the table view by double clicking the column; double click again to toggle between ascending and descending.
• Filter tables directly from the table view using modes such as "=", "LIKE", and "contains".
• Work easily between multiple databases
• Beautiful interface for everything

Screenshots:


Instructions:
Upload to your server into a weapon script, add it to yourself, and press "n". If you want the databases tab to be fully functional, add r databases/*.db to the rights of (npcserver).

Note: Until a way is found/added to dynamically get a list of configured SQLite databases, you will have to put them into the script manually. The function, getDatabaseList(), is at the very top of the script. It should be pretty self-explanatory how to add them.

Thanks to:

• fowlplay4 for his SQL Worksheet, after which much of the "Execute SQL" tab was modeled, and for his number formatter.
• Inverness for putting up with my whiny questions about SQL
• The artists behind the graphics on the database tab. Credits are available at these links: 1 2 3

Disclaimer:
This is a tool for developers. It's not something that is completely bulletproof with security. In other words, if you're trying to mess something up or cause some kind of error, you probably can. It doesn't necessarily protect against SQL injection in all cases, so just be careful with what you do.

See also:
SQLite Database Browser - an external tool for viewing the database; it can be used in any instance where my tool fails for whatever reason


If you find any bugs/glitches, please report them; I use this tool on a daily basis, and any bugs you have will eventually effect me too. Comments, criticism, and suggestions are also welcome.

The latest version of SQL Explorer can always be found here.