Let’s face it, having to learn the ins & outs of a unique database interface for each type of database we come across is annoying. If you’re using a PostgreSQL, MySQL, or SQLite database, you’re either using the archaic command line interface each with their own syntax, a web-based interface, or a specialized GUI application. If you need to administer the MySQL database, you’ll need to either command line your way through or find an application. But if the next day you need to administer a PostgreSQL database instead, you need a new set of commands to command line your way through, or use a separate application. Now the phpMyAdmin and phpPgAdmin guys have tried to solved this, but to be blunt, web interfaces stink. In fact even if you use these two web interfaces, the GUIs are nothing alike. It is as ridiculous as it is irritating.
So, how would you like a single desktop application that would let you, your employees, and coworkers mange, maintain, and query PostgreSQL, MySQL, SQLite, Oracle, and perhaps any other database that can be connected via ODBC? What if it would work on your Mac machines, your Windows machines, and your Linux boxes? Well, I have already started on this and have the ability to read PostgreSQL and SQLite databases since those are the two that I use the most. Currently databases are readable but not editable; one step at a time.
Before I go further into development, I’m looking for your thoughts: If you were to buy such an application…
- What are the most important databases that the application supports?
- Would you want to pay more to have access to all supported databases or purchase access to databases a la cart?
- Is starting with simple query & editing enough, or would scripting, filtering, and triggers be required in a first release?
- What are the most important features for a SQL editor in your mind?