Today I was looking around what kind of helper tools a Perl
programmer might need, that is not necessarily for writing
Perl code. One of the other fields we frequently visit is databases.
We need to write SQL statements, looking into the structure and
the content of databases and checking what are the values there,
sometimes even designing a schema.
On one hand there are command line interfaces for every
database and there are specialized desktop or web based tools
to look at databases which are very powerful.
So we might not need anything else.
On the other hand we have DBI, lots of DBD packages and
a number of nice extensions of DBI for building code that
can access databases. Maybe we can build some add-ons
to Padre that will make
our life even easier.
So I'd like your ideas on the subject. What kind of SQL or
database related desktop tool would you like to have for
Just to start the list, let me write down the trivial things I could
come up with (trivial in thinking about them, not the development):
Probably the most basic feature is to provide SQL highlighting to the .sql files.
Then it would be nice to have call-tips
explaining the various language elements
Statement completion would be also
nice - once an SQL keyword is typed it should
provide a list of keywords that can be used
as the next thing (this should be either standard
SQL or one of the SQL languages e.g. SQLite
Allow the user to define a connections string
(database type, hostname, port, database_name
(or filename), username, password) and connect
to the database
Once a connection string is given, provide
a drill down view of all the elements of the
database (tables, index, stored procedures etc)
and even the data
Allow the user to type in SQL statements
(or mark one as selected text in the editor)
and execute the query printing the results set
on the output window
As extra feature somehow allow the use of this plugin for SQL statements embedded in Perl
code and the execution of SQL statements that have placeholders. Is this doable at all?