Codeistry

Archive for April, 2009

MySQL Workbench 5.1.10 beta

Friday, April 10th, 2009

The new MySQL Workbench is now in beta and is looking very good:

MySQL Workbench 5.1.10 showing a MODx 0.9.6.3 databaseYou can import create scripts (mysqldumps), build diagrams yourself, with full drag and drop etc, and export create scripts. You can also annotate with text and images and export the diagrams as SVG, PDF, PNG etc… Here’s the PDF for the MODx 0.9.6.3 diagram shown, along with the MWB (workbench) file. That diagram is just an imported mysqldump of a MODx DB – all I did was click the auto-arrange button.

It’s available for Linux (32 & 64 bit), Mac and Windows. I’ve been playing with the 64bit version in Ubuntu and it seems to work great! More info on their blog, or get it here: http://dev.mysql.com/downloads/workbench/5.1.html

gcalc: a command line version of Google Calculator

Friday, April 10th, 2009

Here’s a command line version of Google Calculator:gcalc command line tool in use

Download gcalc here: http://www.codeistry.com/assets/files/gcalc.zip

Using Google Calculator in firefox's search box.It’s a little python script that talks to Google, using it’s calculator syntax. You’ll get the same answers if you type the queries into google

To use the script, just download the zip file, extract the file inside and put it somewhere on your path; I’ve started putting these kind of things in ~/bin. I originally found the script here (http://vrai.net/page.php?block=scripts) but it didn’t work too well, so I fixed it up. I’ve tested it on Linux, but it should work anywhere Python is installed.

If you’re using that script on Linux, then chmod +x gcalc it to allow it to be executed. If you’re using Windows, you might have to add ‘.py’ to the end of the filename. Then the syntax is very simple:

gcalc “1 hour 5 minutes in seconds”
1 hour 5 minutes = 3900 seconds

gcalc “100 + 2 * 5″
100 + (2 * 5) = 110

gcalc “41000 yen in british pounds”
41,000 Japanese yen = 277.129372 British pounds

Here are complete instructions on the syntax that Google Calculator supports.

Also, in the screenshot above I’m using Fish, the Friendly Interactive SHell because it does nice syntax highlighting, amongst many other cool things. Fish is here, if you want it.

Have fun!

Bunch of updates to the Codeistry site

Friday, April 3rd, 2009

I’ve made a number of small updates to the Codeistry site today, which I’ve been queuing up on my local version for a while. I’ve made updates and corrections to my Accessibility made simple article, as well as minor updates to the 9 Steps to Improve your Small Business website and SEO for Fun and Profit ones.

Screenshot of MODx metadata field in page editor.I’ve also souped up the metadata that gets output in the page’s code, so that I’m now outputting a meta description tag – this outputs whatever I’ve typed into the page’s Description field in MODx.

Screenshot of the MODx Meta Keywords systemI’ve also started using MODx built in meta keywords system, so some pages now have some keywords set.

A little while age I also added a Creative Commons license to the page footer but forget to mention it on the blog. This means that the site’s content is now actually marked as copright of Codeistry now – which it wasn’t before. As I’ve chosen a Creative Commons Attribution Non-Commercial Share Alike license, this also means that anyone can re-use, re-mix, translate or re-purpose any of the stuff on here for whatever they want, provided it’s non-commercial and they credit the original source.

Anyway, here’s the old footer:

Screenshot of the old Codeistry page footer, before the new license

and here’s the new one:

Screenshot of the Codeistry page footer, with the new Creative Commons license

Codeistry blog is proudly powered by WordPress Entries (RSS) and Comments (RSS).