![]() And before I knew it, I ended up with these 3 bundles: one which copies tows to clipboard as wiki (in the same format as HeidiSQL does), one which copies the rows as HTML table and one which copies the rows as CSV. I’m not the best bash‘er in the world, but since Sequel Pro came already with a bundle which allows you to copy rows as JSON ( “Copy as JSON” from the Bundles -> Copy menu), I thought I’d adapt that to allow me to copy text to clipboard as wiki as well. Unfortunately Sequel Pro doesn’t support that, however, as I said, it offers the possibility of writing your own “bundle” (effectively a plugin). Redmine supports wiki text - and this is where HeidiSQL came in handy as you could select a few rows of data and it allowed you to copy that to clipboard as wiki text/table so you could then just paste it into Redmine and have the data formatted and therefore easy to read. (saves me running the same SELECT over and over again every time I need to check a campaign flag for instance). In Cognitive Match we use Redmine internally as our task tracking system, and when dealing with production investigation, I found myself quite often having to copy and paste rows of data from MySQL into Redmine - either so data can be investigated/approved by colleagues, or simply as an effective way of “saving to stack” row ID’s, campaign settings etc. ![]() Now that I found to be cool because I don’t want to learn a new scripting/programming language for each product which allows me to write my own plugins. One of the good things I found about it, is it offers a plugin framework ( bundles) which allows you to write your own bundles - and even better, these can be written in Bash script, or, any other scripting language you can shebang from bash. I have to admit it doesn’t yet rival with HeidiSQL but like all the open-source projects, they had to start somewhere so a bit of patience is required. So digging around I found this open source (hence free) client called Sequel Pro. You can of course use the MySQL Workbench but I found it clunky and not that helpful to be honest. ![]() Some of you might know that I’ve moved to Mac recently (no comment!) - as such I had to ditch the HeidiSQL client for MySQL (booo! why does it only run on Windows?) and had to figure out another handy MySQL client which works on Mac OS X. Posted August 16th, 2011 by Liv & filed under Blogroll, News, Tech. Sequel Pro Bundles: Copy As HTML, Copy As Wiki Table, Copy as CSV ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |