Posted by : Psmeg in (Development Tools)

MySQL Workbench

If like me you work with MySQL, a visual development tool can quickly become invaluable for more complex relational databases. MySQL Workbench is a visual editor that aims to make your complex database creation much easier by utilizing a simple display of the tables and there relationships.

MySQL Workbench is an ER/database modeling tool for MySQL. You can use it to design and create new database schemas, document existing databases and even perform complex migrations to MySQL.

Main features:

  • Cairo based diagramming canvas which allows output to different targets such as OpenGL, Win32, X11, Quartz, PostScript, PDF etc
  • visual representation of tables, views, stored procedure/functions and foreign keys
  • live database and SQL script file reverse-engineering
  • database/model synchronization
  • SQL script generation
  • extensible architecture
  • export as SQL CREATE script
  • import DBDesigner4 models
  • support for MySQL 5 features
  • selectable notations for diagram.

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a native GUI tool on Window, Linux and OS X.

Posted by : admin in (Personal Stuff, Photography)

A New Camera - Nikon D300

Tagged Under : , , , , , , , ,

Well, after much debating, thinking, reading reviews and generally getting bitten by the upgrade bug; I invested in a spanky new Nikon D300 dSLR yesterday, and I have to say that after an initial wave of ‘Oh crap, what have I done!!!!?’ I’m really happy with it.

The new screen and live preview are worth the upgrade alone, but the new features that I’ve actually had the opportunity to play with are certainly useful. I’m really looking forward to getting the chance to shoot some motorsports in the next few weeks (BTCC at Donington or Thruxton in May I hope!)

If all goes to plan, the extra FPS should be really useful for capturing the action, and the new 51 point 3D matrix autofocus system should prove very handy with the fast moving cars and hand held panning shots.

As you can imagine, there will be a whole new collection of photographs posted here and on the forum from the day(s).

Posted by : Psmeg in (Uncategorized)

CSS Mastery - Advanced Web Standards Solutions

Tagged Under : , , , ,

CSS Master by Andy BuddWith the increasing regularity that books based on CSS web design are being released, it’s a major task in itself to find a book that is written in plain English and actually covers real world applications, details clean code and is enjoyable to read. So, to that end we are taking a look at Andy Budd’s CSS Mastery: Advanced Web Standards Solutions by Friends of Ed.

Friends of Ed have always created books aimed at real world uses written for the designer as opposed to the techno-geek. CSS Mastery doesn’t break with that tradition; which is a good thing.

CSS Mastery takes a guided look at the most common aspects of CSS based web design and ensures that the knowledge imparted is geared towards accessibility and semantic mark-up. Andy Budd certainly knows his stuff and guides you through the topics in a logical and clearly explained fashion. Examples are plentiful as are tips, browser issues and common workarounds. That is one area that this book becomes invaluable as a reference tool that deserves a place on any designers/developers desk.

If you are new to working with CSS, then CSS Mastery will get you off to a flying start and help clear up some of the multitude of browser issues and problems you’ll no doubt run into.

If you are further down the path to CSS mastery you can still benefit from the knowledge and workarounds that fill the book.

There is one area that I think this particular book may frustrate and that is where it demonstrates a particular topic/method, explains what and why you should do it and then shows you the code to achieve the desired result. All good so far. However, when you try to implement the topic being covered only to discover that the effect doesn’t work in your main browser, obvious frustration ensues.

Why doesn’t it work you ask? Well, you would have to read the entire topic from start to finish, and once you reach the end you are then and only then informed that it doesn’t work in certain browsers (in this case IE6).

Personally, I would have preferred that little gem to have been imparted BEFORE I started trying to implement the topic covered. However, that said; it really isn’t a major issue in the book, more a case of the topics being covered being useful enough for me to want to start implementing them immediately and not finishing the whole chapter.

Speaking of the topics covered, you’ll find many useful areas of design being given plenty of coverage. For example, the book covers the following areas:

  • Setting the foundations: Useful information covering the best methods of managing and controlling your style sheets.
  • Visual Formatting Model Recap: Covers the 3 basics of CSS design: Box model, floating and positioning.
  • Image replacement and background images: Various methods of image control including rounded corners & navigation images.
  • Styling Links: An excellent chapter on many different methods for link styling.
  • Styling Lists & creating nav bars: Covers visually styling navigation elements and image maps.
  • Styling Forms and Data Tables: A comprehensive look at making tables look and work well and visually control forms.
  • Layout: One of the coolest chapters in the book covering many common layouts.
  • Hacks & Filters: Love them or hate them, hacks and filters are a CSS developers life lines when browser problems occur.
  • Bugs & Bug fixes: This chapter covers the many known bugs and how to solve them in the minefield of browsers and platforms.

Finally, the book moves on to cover 2 complete case studies and are an excellent way to see how and why a designer uses various methods covered throughout the book to achieve real world results.

Thankfully, the case studies are well designed and interesting layouts, that makes reading through them and seeing how and why various methods are used invaluable.

Conclusion

Andy Budd has written a well structured book that will be used as a source of reference for many years. The topics are concise, well thought out and have practical uses in every day development.

His use of examples elevates it above many other books on CSS that are being released almost daily and the 2 case studies should be enough to help inspire and prove that CSS design doesn’t need to look ‘boxy’

A well presented book that I would recommend to beginners and seasoned designers alike.

Posted by : Psmeg in (Lead Articles, Photography)

High Dynamic Range Images - How To

Tagged Under : , , ,

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam nec erat. Vivamus dui diam, consequat et, mattis ac, dictum quis, dolor. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Suspendisse potenti. Morbi faucibus congue magna. Phasellus id dui non dolor luctus imperdiet. Proin vehicula nisi. Sed condimentum elit faucibus ligula. Read the rest of this entry »

Posted by : admin in (Featured Articles)

URL Parameters - Creating Master/Detail Pages

Tagged Under : , , , ,

Something that pops up from time to time on the WZ2K Forums is how to create your own master/detail pages in Dreamweaver. I know for many people, myself included; this was a source of much head scratching and frustration.

So, I’ve put together this little guide to show you how easy it really is. And with a little experimentation you’ll be surprised how sophisticated the whole process can make your web pages.

To start off with you’ll need to create a master page that will show the basic information required and allow us to create the link that will pass the relevant search string to the detail page via the URL.

Create a new page in Dreamweaver and ensure it is a dynamic page (e.g. php or ASP) and save your file as master.php or master.asp.

Open the Bindings tab on the Applications panel (right side of Dreamweaver) and click the arrow in the top left of the panel – choose Recordset (Query) and you will be presented with the Recordset dialogue box (see image 1).

What we need to do is create a list of information that will be used as our overview and later we will create a link to show us the full information based upon which record we choose.

For this example I am going to create a list of articles (showing title and date added) that the user can browse and when they spot an article that looks interesting they can click to view it. Read the rest of this entry »

Posted by : admin in (Commercial Work)

Abergavenny & District Tourist Association Web Site - Now LIVE

Tagged Under :

Well, the new ADTA web site went live on Friday 14th March 2008, hopefully to the satisfaction of the ADTA and to the thousands of visitors and potential visitors in the near future. I guess it’s one of those ‘only time will tell’ scenarios as to the success of the project.

As I’ve mentioned previously, securing the ADTA web site was a major achievement for me and I-Pixel in general; as it marks a level of acceptance and confidence, not only in me but also in the ability of I-Pixel to create and maintain a professional web presence for the entire area.

So far, the design has met with positive feedback, and I hope it will make site visitors confident in using it, as well as local businesses wanting to be listed on it. Personally I feel it will achieve this and will help promote the area, businesses and everything else it has to offer. Read the rest of this entry »

Posted by : admin in (Personal Stuff)

2007 revisited…..

Well, 2007 is almost over and the new year is just around the corner; so now seems like a fitting time to take stock of where I-Pixel is and where it may be going!

November and December have been like a commercial roller coaster, with hectic workloads, short timescales and tight deadlines and it looks set to continue in to 2008! Without wanting to jinx things, the last few weeks have proved a fantastic time for Duffy and I in relation to work. We have seen us winning the contract to develop the new Abergavenny & District Tourist Association web site, which for me personally is a pretty cool achievement.

I-Pixel was recommended by a client along with a couple of other recommendation from various other committee members, and we were shortlisted to 2 based upon our estimate. The 2 remaining companies had to meet the committee and discuss the requirements, answer questions and deliver the pitch. Well, to cut a long story short, we were informed the following morning that we had been successful with a unanimous vote in our favour! Whoohoo!!!! Read the rest of this entry »

Posted by : admin in (Useful & Cool)

Avactis 1.8.0 Released - Many cool improvements!

Tagged Under :

I’ve been using Avactis as my shopping solution of choice over the last few weeks because it offers an extensive tag based integrtation system and has proved very easy and user friendly from a buyers and developers point of view.The techies over at Avactis have released the latest upgrade with a host of much need additions. Listed below are all the new features, etc.

Avactis Shopping Cart 1.8.0 has been released.
November 16, 2007

Avactis Cart ver1.8.0 online demo:
http://www.avactis.com/demo.php

In this version we have implemented one of the most wanted features of Avactis Cart – support for Customer Accounts. Now customers can shop your online store in two ways: via Quick Checkout, with no registration needed, or via their personal customer account. Having a Customer Account lets your shoppers place repeat orders without entering the same personal information twice. Customer Accounts also enable your customers to view their order history online.

Version 1.8.0 includes a number of bug-fixes, improvements and added features. See below for a detailed list.

Current customers can download the fresh version 1.8.0 using this link: http://www.avactis.com/support.php
Select User Type “I’m a current customer and I want fresh version”, and enter all the required data. The download link will be sent to your e-mail address.
Read the rest of this entry »

Posted by : admin in (Personal Stuff)

Imperium CMS gets its own domain and forum

Tagged Under :

With interest in Imperium growing and the commercial projects it’s being used on grows, it only seems fitting that the project gets its own domain and support forum. To that end I’ve purchased and set up www.imperiumcms.co.uk and the linked support forum at www.imperiumcms.co.uk/forum/ to allow interested parties to contribute to the project and its future development.

With the addition of the skinning feature where admins can upload a css file and then activate it to change the look of the site. Obviously, the beauty of this is that 3rd parties can develop new looks for the site and make them available to other users.

Finally, I’ll be making a demo admin available via a sub-domain in the near future so interested parties can log in and take a look around at how various features work and offer feedback on suggestions, etc.

So why not pop over to the site and forums and offer your support and feedback for Imperium CMS.

Posted by : admin in (Imperium CMS)

No more KTML?

Tagged Under :

While Interakt were bought out by Adobe some time ago, I’ve still continued to use KTML as my rich text editor of choice in commercial projects and in the development of Imperium CMS. However, with a major problem with the way the file upload facility works with IE and my current hosting company, I’ve been forced to look elsewhere for the required functionality.

Because of this issue, I’ve spent the last 2 days searching, downloading, installing and configuring a range of RTE’s with various levels of success. However, I think I’ve finally settled on the popular TinyMCE editor in conjunction with the Image Manager plug in to handle all the image uploading functions.

Read the rest of this entry »