Eric Day

New Database Command Line Client

A few weeks ago I proposed a project to students at Portland State University for their senior capstone class, and this weekend I found out it was chosen by a group! The project will be a rewrite of the command line tool (the Drizzle tool is currently based on the ‘mysql’ tool), plus a lot of new features. We’re really excited to be working with them, and they seem equally excited about the project too. I hope DBAs, developers, and other folks in the Drizzle/MySQL/MariaDB communities will work with them to help define what features should be part of this new command line client. Some new features we have in mind are background queries, piping and redirection of queries (like a normal shell), and plugin support. It will also support at least the MySQL/MariaDB protocol too since it will be built on libdrizzle, but possibly more if we end up using a common DB API (we’re pondering Python). If you have any ideas or feature requests, feel free to leave a comment. The student group will be sending plans to the Drizzle mailing list soon for feedback, as well as attending OpenSQL Camp and leading a session on what folks would like to see in a client tool. Join me in welcoming Clark, Ken, Max, Victoria, David, and Andreas!

5 Responses to "New Database Command Line Client"

1. Paul says:

   October 29, 2009 at 4:48 am

   Tab auto completion
2. George Entenman says:

   November 1, 2009 at 7:09 pm

   This sounds like a fantastic project – please keep me informed of its progress.

   I don’t have any ideas for features beyond your suggestions except that I would love it if I could pop into vi, the way I can from bash, to edit the history.
3. Eric Day - Blog – Pluggable Database Client Tool says:

   November 23, 2009 at 6:11 pm

   [...] New Database Command Line Client [...]
4. Eric Day - Blog – Boots: A Modular CLI for Databases says:

   April 8, 2010 at 11:48 pm

   [...] Back in October I wrote about a student group I was sponsoring to create a new command line tool for Drizzle. The group wrapped up their part of the project (the term ended), and we now have a new tool called Boots! A few of the developers are still active in the project, and I’m planning to get involved more as well. We also have a couple students interested in hacking on it for Drizzle’s Google Summer of Code. [...]
5. Eric Day: Boots: A Modular CLI for Databases | Weez.com says:

   April 9, 2010 at 4:08 pm

   [...] Back in October I wrote about a student group I was sponsoring to create a new command line tool for Drizzle. The group wrapped up their part of the project (the term ended), and we now have a new tool called Boots! A few of the developers are still active in the project, and I’m planning to get involved more as well. We also have a couple students interested in hacking on it for Drizzle’s Google Summer of Code. [...]

Leave a Reply