Thursday 20 August 2009

MySQL - its so touchy feely

Having been an Oracle sort of person (well and TransactSQL) I find myself banging my head against the screen with MySQL's cute traits. For example

I have a web application which is paired to a MySQL database. I've used the INNODB engine to enable transactions (ACID is a requirement) and I just managed to insert a NULL into a table with a NOT NULL constraint and it swallowed it.

perplexed I consulted the manual, this is apparently the default behavior.:

whenever you insert an “incorrect” value into a column, such as a NULL into a NOT NULL best possible value” instead of producing an error column

I'm so glad that MySQL can guess what is the best possible value for the "Library of Congress number" for the book.


It seems that you must use "strict" mode for it to behave properly ... isn't that just like kids

Sunday 16 August 2009

tale of two teles

background

Comparing two 300mm bargain basement 300mm lenses on a micro 4/3rds camera (a Panasonic G1). Both cost around US$200 on ebay.

One of the really good things about 4/3rds sized sensors is how well they work with telephoto lenses, the x2 "focal length multiplier" making a 300mm lens have the feel of a 600mm lens on a full frame camera.

300mm telephoto lenses have been a popular choice for many photographers over the years as a good compromise between weight : telephoto reach : cost.

But for many wild life photographers (particularly small wildlife like birds) 300mm is not quite enough and 600mm is more like what people would like to use.

In the past (with 35mm film) that often meant the use of teleconverters, fitted behind the lens and extending the magnification.

This wasn't without penalty however and the extra optics soon made photographers aware of the limitations of their optics. When digital cameras started to appear in SLR bodies they came at first with smaller than 35mm sized sensors. This meant that the image was captured on a smaller area of recording surface resulting in talking about so called "crop sensors" or "focal length multipliers".

What ever you call it, it means that for digital camera users that if you are using APS or 4/3rds cameras that your telephoto is more telephoto than on a full frame and without the optical penalty of a teleconverter or the weight and cost of a longer lens.

Even better, the years of AutoFocus and SLR design changes have left the market with some really great high quality manual focus mechanical camera lenses at dirt cheap prices. Making it great for hobby people (like me) to get some excellent optics at bargain prices.

Two really great candidates are these, the FD 300mm f4 and the Olympus OM series f4.5

Better yet, these lenses work very very well on 4/3rds cameras (the EOS digital can't make use of the FD lens without optical based adaptors) and in my opinion better still on micro 4/3rds where stop down metering problems do not seem to exist and digital focus zooming makes accurate focus a simple thing.

I'm sure if you're interested in one of these lenses you've searched around on the net but haven't found much to help you in making any decision. Sure you can compare specs on both but having them both in your hands is quite different. Well, here I'll try to pass on what I found by taking the plunge and buying both.

Both come with nice lens based tripod mounts (takes the weight off your delicate G1 body as well as provides greater balance and stability on the tripod), and their weights are the same (within a few grams) and sat side by side you can see there is not a lot of difference between them, the OM lens seems more compact at first, but there is a difference.

The Canon lens employs Inner
F
ocus mechanism
, where only some internal lens elements move to change focus, the Olympus on the other hand uses a more simple design of focus by extension. This means that when you focus closely that the lens must get longer as the group of elements moves out. You can see the difference in the second image of the two lenses where the Olympus is now longer than the Canon.

Ok ... this may seem trivial but it has a few effects on both the lens physical operation and on the images.

The aspect of this is perhaps only obvious when you've seen it and if you understand macro photography (and have worked with larger format cameras too). You see, as you extend the lens you are of course moving it further away from the sensor (or film). This means that it becomes longer in focal length. So when focused at 4 meters from the camera the lenses each have different magnification. See below:

The FD:


The OM


Another issue is that because the extension of the lens puts a cantilever strain on the helical thread and focus becomes more 'stiff' as the lens extends further during focusing. If you support the front of the lens (of point it straight up) this reduced and makes it clear the physical benefits of the inner focus system.


Next is the tripod collar. I really like the FD lens tripod collar, it allows smooth and precise adjustment of camera alignment (vertical and horizontal) and is very nice on a mono-pod. The tension on the clamp is adjusted by rotating a knob on the side

and can be released by pulling it out popping open the clamp to allow you to quickly remove the lens from the tripod (if you decide to go hand held or pack it away leaving the clamp on the tripod.


in case you're wondering what the green thing is its a bit of plastic I jammed in there to prop open the clip for photography ;-)

the OM one however has a more simple clamp which even has a ratcheted connection (with a ball single bearing in the clamp). I found that this made adjustment of horizontal more tricky as you had a "click" either side of perfect ...


It also means that you can't quickly remove the lens from the clamp ... if you should want to do that.

Both lenses have an integral lens hood which slides forward to operate ... seems to work nicely in both cases, although I like that the Olympus one is held back by the lens cap. The Canon has the advantage of locking down when extended with a twist of the lens hood ... so even points distribution there.

Lastly an advantage (if you wish to call it that) on the OM lens is that the Depth of Field preview is a button on the lens. You can remove the "iris coupling pin" on the adaptor and have full aperture focus advantages and press the button on the lens to stop down just as you take.

This is not something you can do on any other lenses and is something which you can do on micro4/3rds but not all cameras.

Why? well I'm not entirely sure, but I think it has something to do with the metering from the focus screens and the type of focus screens.

I've tried using different apertures with my older EOS film camera found that it worked well but that it produced unreliable metering on my 10D.

I have also read of other 4/3rds users (not micro4/3rds) experience inaccurate metering on their cameras with stop down metering at smaller apertures (like below f5.6 or f8. So based on this I guess that those using 4/3rds in live view will not have this problem.

Since I use a micro4/3rds I don't even have to think about it.. I personally like the OM lens Depth of Field button as it makes manual focus in the EVF a peach and stopping down to 5.6 or 8 (giving better image quality) quick and easy.

That about sums up the physical differences between the two lenses that I can think of.

The optical differences are so minor as to be indistinguishable.

For example here are two samples. Both are taken from RAW and processed with DCRAW (-T option) then had some curves applied in an identical fashion.

Both are taken at the fullest opening of each lens.




hard so see much there despite the contrast with the background ... and


aside form some minor differences in focus if you can pick a major winner in the optical department then that's your call.

I hope this has been useful to ya' all

me? well I'm keeping both for now ... I like the FD to use more, but I can use the OM lens on my Canon EOS camera and I can't use the FD ...

Sunday 9 August 2009

GF1 - rumor mongering

Hi

there has been a bit of a stir recently with some images and discussion starting on some websites about a more slim version of my micro 4/3rds G1 camera without a tilt screen and without an EVF. These two things transform the camera into a more 'point and shoot' looking box (not unlike the Canon G10) with the rear screen that so many seem to have come to like.



These images were posted on that bulletin board but were taken down soon after (I guess because many people started linking to them). So in the interests of preserving this I'm going to "off site backup" them here.

The camera looks more compact than my G1 does, and some small changes to cope with the different form of the camera have seen buttons move around a little. Here's the back view, I notice that the dial from the front grip seems to have moved to the back.



From the top we get a good idea on how compact the camera acutally is, the Hot Shoe flash mount is a great indicator of scale.


So with a 20mm or 17mm pancake lens (like the 20mm shown below) this would be one very nifty little compact camera.



Don't let compact fool you, these cameras produce images as good as the top professional cameras of not that long ago. Cameras such as Canon's 1D MkII had a slightly lower image resolution of 3504 x 2336 coming from a sensor 28.7 x 19.1 mm ... this is barely larger than the micro 4/3rds sensors which are 18x13.5 The figure below is a scale diagram showing the relative sizes of the 1D in the blue, the micro4/3 in the green and the common compact camera sensor in the grey.


You can see that while the micro 4/3rds is smaller than the 1D (costing several thousands when it was new) its way bigger than the compact camera sensor. Its really more or less the same size as the sensor in all typical "consumer" DSLR cameras yet this will be more like a compact camera.

But unlike any compact cameras, this camera is an interchangable lens camera, so you can swap off the regular picture taking lens like above and put in something which will be great for taking pictures of the kids at footy or even birds nesting.

I run this lens on my G1 for stuff like that:

G1 with 300mm f4

I like this one because it was very cheap (not being autofocus) but optically great! That's another great part of micro 4/3rds there's heaps of options out there ... heck just read my site if you want a starter.

I'm certainly pleased (and I'm quite demanding in my assesment of image quality) with the micro 4/3rds camera image quality. Not only are they great images but the system seems to give me much better exposure than any camera I've ever had before.

So, despite all the economic gloom, it seems there are some new toys out there to brighten our days.

Wednesday 5 August 2009

praise for my G1

having been a film user for some decades I have been 'leery' of digital in its ability to do well on people portrait situations. I've been using (and writing about) digital cameras since about 2000 and I have owned quite a number of digital cameras (read: I'm not against the idea) since I started.

The G1 however is the first camera I've owned which has passed the print test where I just can't fault it and nothing gives it away as looking digital even with a JPG straight out of the camera.

At my god daughters christening a few weekends ago I took this image of the little girl:

siiri

Now all that happened for this image was that my wife took the media card out of the camera to the local department store and got some prints made for the grandparents (nothing big, about 5x7 size). No processing at all. She showed them to me before posting them off.

Now I've done quite some testing and evaluation before I sold my 10D and other Canon gear but unexpectedly this print has really sold me on how well it really works. I just know that the print will do well at A4 size too.

So casting aside all my normal "testing criteria", I'm just so impressed with this image over and above almost everything I've had because it just works without any intervention.So for ordinary "mums and dads" I'm now sure that this little camera will do what anyone wants of it in terms of image quality.

I bet the E-P1 is just as good