Steveify

Let’s be honest – managing a database isn’t terribly exciting. But you still want to use a product that looks half-decent and is intuitive to use. SQL Buddy was designed to meet the demands of modern web developers. Oh, and did I mention that its completely open source and free for everyone to use?

The easier way to manage your database

Some applications look great in a screenshot, but deliver disappointing results when they are actually used. The driving force behind the development of SQL Buddy was not to produce a great-looking screenshot but rather to create a product that would enable developers to enjoy their work and get more done in less time.

http://sqlbuddy.com/

I listed my New Year’s resolutions on here last December.

We’ve now passed the mid point of the year so I thought I’d check them and see how I’m doing.

1. Stop procrastinating.

How am I doing? Dismally. If there was a procrastination world championship then I’d be in with a good shout. Seriously, I can dick about and put stuff off with the best of them. I have ideas for at least three new additions to my hearing aid site that I’ve only barely started. There’s some good apps that I could add to it that’d be truly useful. Why haven’t I done these? No idea. I have got into the J2EE stack and picked up Python so I haven’t spent all of my time sitting around scratching my arse. Just most of it.

2. Stop smoking.

How am I doing? Up until two weeks ago, very badly. The last two weeks: excellent. I gave up two weeks ago. Six months later than I intended but better late than never.

3. Drink less coffee.

Doing well with this. I usually have one cup in the morning to wake me up and then drink Tea in it’s stead for the rest of the day.

4. Drink more water.

The coffee cut down means I have been a lot less dehydrated and adding water has been less of a concern. Even so, I have been drinking either Tea or squash during the day.

5. Get more sleep.

How am I doing? Yawn….. Really badly. I have bags under the bags under my eyes. One I go to bed I normally sleep like a log but I just can’t bring myself to go to bed early. Seems like a waste of time even though I know full well that the extra sleep is needed and would be refreshing.

So, that’s 3 out of 5. Not bad but I really need to stop scratching my arse so much.

Any piece of development, be it a full-blown system or a small 20-line change, is measured by people on two things, and two things only:

• Was it delivered on time?
• Does it work?

Your programming peers and other tech types might be impressed that you used some design patterns to create a modular, re-usable approach. They might love that new library or widget you found and are now using. They might think your source-code is immaculate - if there was a museum of fine programming pieces then this’d be in it.

The stakeholders don’t care about that stuff. The project manager doesn’t care. The product manager doesn’t care. The users don’t care. The people managing the budget don’t care. They want your software to work and they want it when they asked for it.

Color Scheme Generator 2 is a pure-javascript colour picker.

I’m no designer and I know next to nothing about colour schemes or how to pick a good complement of colours but this tool makes it really easy.

You select your first colour on the wheel and then it automatically selects the colours for monochrome, contract, triad or tetrad schemes. It also has a analogic option which picks a tetratic scheme basic on a slider that defines the angle around the colour circle from your original selection.

So, looks like JavaFX is finally arriving.

It was first announced at JavaOne in 2007 (yes, seven) and it now looks they are ready to let it fly.

The JavaFX part of the Sun site has been somewhat barren for ages but it has been updated with some previews and stuff.

I was thinking that it might be a case of too little too late for JavaFX but now I’ve looked at their updated site and checked out the previews I’m not so sure.

The previews look nice. Not any better than Flex or Silverlight or Dojo or whatever but still very nice. It can certainly compete in terms of looks.

Integration with NetBeans will be a winner. NB is a powerful IDE and it’s gaining features all the time - there’s a preview release of NB with integrated JavaFX SDK. Not related, but NB is getting Python support soon too.

My “meh” reaction to JavaFX has suddenly turned into foaming-at-the-mouth-moist-in-the-pants anticipation.

The JavaFX scripting examples look simple enough - shouldn’t be any great shakes for existing Java devs.

Not sure what’s available for networking - presumably it’ll do web services, xml, json, etc, etc out of the box. How long do you give it before someone has created and RSS reader? Two days? Three?

The quest for a blogging client continues and the next option on the block is Scribefire.

It’s a bit different to the two I’ve tried already, BloGTK and BlogDesk, in that it’s a Firefox plugin. I like to use my browser as a browser and I don’t particularly like plug-ins that try to extend a browser to do something it wasn’t designed to do. But we’ll see.

Installation was a breeze.

• Went to Scribefire site. Installed plugin and restarted FF.
• Scribefire setup wizard was excellent. I put in my blog’s URL and it came back and told me that it’s a Wordpress blog and offered some default options. Next I just put in my user/pass and that’s that. That’s how a setup should be - nice and easy.
• Get taken to a welcome page and then I hit F8 to bring up Scribefire’s window. And I’m writing this after about 2 mins setup tine.

Editor is nice. Has all the expected options plus a few nice extras.

There’s a quote button.

There’s buttons to increase and decrease font size. That’s useful - save’s having to remeber which header tag you are supposed to be using.

The insert image is OK. It lets you specify a local file or a URL. There’s an option to upload the local file using FTP or the WP XML-RPC API.

No option scale or modify the image though - that’d be nice. At the very least a “small, medium, normal or large” selector would do.

There’s a source view too, which is handy to tidy up any loose HTML created by the WYSIWYG.

Wow, just noticed the Preview pane. This rocks. It picks up my blogs theme and shows the preview using that - extremely cool.

The really nice menu options I mentioned earlier are buttons to let you drop in video or image from YouTube and Flickr respectively.

Where’s Scribefire saving my post to before I publish it?

I really liked BlogDesk - really liked it. Used it at lunchtime to write a couple of posts using my XP box at work. Was about to set it up here at home when I realised that it’s for Windows only. Bummer.

I need to find a desktop blogging app for Linux. BloGTK seems to be popular and I’m writing this with it. It’s definitely not in the same class as BlogDesk.

First of all, I went to set up a new connection. There was no Wordpress option. WTF? There was an option for a Metablog API and so I picked that - not a good start.

The editor is not so good either. The link I pasted in above appears in the editor as raw HTML - it doesn’t look like there’s a WYSIWYG editor. There is a Preview Pane that shows you what your post should like when published but it’s view only.

<blockquote>There’s an option on the editor menu to create a blockquote. Again, the raw blockquote markup is shown in the editor. Also, the blockquotes don’t look correct in the Preview Post editor pane.</blockquote>

Spell checker works OK.

I went to add an image to this post but the Insert An Image dialog is not a patch on BlogDesk’s. There’s no way to browse my local disk to pick up an image. There’s a positioning option but not styling and there’s no easy sizing options.

Eh, so, I never actually managed to post this with BloGTK - had to go to WP and post it from there. Seems that my account wasn’t set up properly as I couldn’t publish. No errors, no warnings, no hints - I don’t know what’s wrong with it and it’s not telling me.

As you can see above, the blockquote didn’t work either.

Think I’ll give Bleezer a go. Either that or I’m gonna have to boot XP at home, which I’m reluctant to do.

Since Python treats a newline as a statement terminator, and since statements are often more then is comfortable to put in one line, many people do:

if foo.bar()['first'][0] == baz.quux(1, 2)[5:9] and \
calculate_number(10, 20) != forbulate(500, 360):
pass

You should realize that this is dangerous: a stray space after the \ would make this line wrong, and stray spaces are notoriously hard to see in editors. In this case, at least it would be a syntax error, but if the code was:

value = foo.bar()['first'][0]*baz.quux(1, 2)[5:9] \
+ calculate_number(10, 20)*forbulate(500, 360)

then it would just be subtly wrong.

It is usually much better to use the implicit continuation inside parenthesis:

This version is bulletproof:

value = (foo.bar()['first'][0]*baz.quux(1, 2)[5:9]
+ calculate_number(10, 20)*forbulate(500, 360))

This post is written using Blogdesk. It’s a desktop application that lets you write blog post and then publish them without having to visit your blog through a browser.

It took roughly 5 minutes to setup, I:

• Created a new blog user with Author rights but not Admin (I’m paranoid)
• Installed BlogDesk
• Went through the “New Blog” wizard. This set the blog user to post with, downloaded the categories and checked that images could be uploaded.
• Wrote this post.

The Blogdesk GUI is nicely laid out, you can start the app up and get straight into writing a post without having to select any menus or other needles UI interactions.

The editor has all the features you expect:

• Change fonts and styles
• Change colours
• Insert lists
• Add links
• Spell checker
• Insert graphics.

The “insert graphic” option is great. It lets add styles such as the shadow on the left, position the graphic and also resize it. Very nice.

The F5 button switches the GUI editor between WYSIWYG and HTML modes so you can tweak your markup if you need to.

This is my first post using BlogDesk but it seems like a quick and easy way to blog - much quicker than using Wordpress’ own method. The image insertion functions make BlogDesk worth using on their own.

As much as I love Wordpress, and that’s a lot, I can’t bring myself to accept the state of the presentation layer.

Have a look at a Wordpress template’s index.php - it’s usually a big plate of code soup. It’s a mess, it’s difficult to read and a pain to debug. It gets particularly bad when you start to modify a standard template to introduce some site-specific behaviour - you invariably start adding if statements and case statements that bloat the PHP and lead to an even messier soup of HTML and PHP.

Why doesn’t Wordpress come with a templating engine by default?

There’s plenty about. I think there’s also a few WP plugins for the Smarty template engine doing the rounds already.

Adding something like Smarty into Wordpress would:

• Let template designers concentrate on what they do best: design beautiful templates. They wouldn’t need to know anything about the WP PHP code other than to look at the template tags they need to include.
• Make templates version independent. At the moment many templates break when a new version of WP comes out because the WP API has changed, been deprecated, had a bug fix, whatever. Templates would do away with that - assuming the tags never changes and it’s unlikely they would need to.
• De-soupify the HTML.
• Give WP a proper presentation layer!