Saturday, June 04, 2011

Tony Abbott supports a Carbon Tax!



Say Yes Rally 5 June 2011

Sydney: Prince Alfred Park, 11 am
Melb: Outside the State Library, 11 am
Adelaide: Victoria Square, 11 am
Brisbane: Riverstage, 1pm
Perth: Perth Cultural centre - Wetlands stage, 11am
Hobart: Franklin Square, 11am
Canberra: Regatta Point
(near the bridge), 1.30pm

Thursday, May 26, 2011

Coldfusion: Slow ImageResize problem SOLVED

Sometimes, the built in Coldfusion Image functions can take a very long time to resize a jpeg image, like 20-30 minutes.

This is caused by ICC colour profiles, which really should be supported by an Adobe Product.

The quick solution is to use Imagemagick to strip out the ICC colour profile.

It's also a good idea to force the RGB colour space, as CMYK is also not handled.

C:\Program Files (x86)\ImageMagick-6.7.0-Q16\convert.exe
src_with_icc_profile.jpeg -colorspace rgb +profile 'icc' icc_stripped.jpeg

You can also use identify.exe with the -verbose option to detect ICC profiles, although it is a bit slow, 2-3s.

Tuesday, May 03, 2011

Adobe Coldfusion Builder 2 pricing down under is a JOKE

Adobe announces they have released Coldfusion Builder 2 today, but the Australian pricing is a sick joke.

List price in the US is $299, but in Australia for download only is $407 ex GST.

Now I'm not sure if the Adobe folks realise, but our dollar is worth more than USD!

Today, via xe.com  USD $299 is actually only $274 AUD

Adobe has a loyal group of Australian CF developers, treating us like this is a sick JOKE

MapGuide 2.2 has been released

Just a quick post, Trevor announced on the MapGuide-Users mailing list that 2.2 has been released.

Release notes and download links

Builds are available for Windows 32 bit & 64 Bit, CentOS 5.4 / RedHat 5.4 / Ubuntu 9.10 32 Bit 

It was a very long release cycle, but we wanted to ensure a high quality release.

I encourage anyone using an older version of MapGuide to upgrade.

Also, please don't ask support questions on my blog, direct them to the MapGuide-Users mailing list
*AFTER SEARCHING THE ARCHIVES FIRST*

Sunday, April 17, 2011

MapGuide 2.3 optional subversion install for web tier (RFC 111)

Thanks to the 25 people who answered the MapGuide Source Control Survey Survey, the results were considered by the last Mapguide PSC meeting where RFC 111 was discussed and voted on. 

RFC 111 was adopted, a subversion checkout will be available as an option in the installer for the next major release 2.3. This allows quick deployment of new features/bug fixes for the MapGuide Viewer web apps.
This will be all managed by the user, so if you don't want to use this feature, you can either simply choose not to install it, or just install it anyway, but never do a subversion update. 

Here are the survey results:

Q1:Which versions of MapGuide are you using in production? 

2.2 (MGE 2011)



13 41.94%
2.1 (MGE 2010)



12 38.71%
Classic 6.x



3 9.68%
2.3



2 6.45%
2.0 (MGE 2009)



1 3.23%


Q2:What is you background with GIS? 
I'm a programmer who uses GIS



1664%
Other Option



416%
I studied Geomatics



416%
I'm a novice with no programing or spatial background



14%

Q3: What source control systems have you worked with? 
Subversion



1446.67%
CVS



826.67%
What is source control?



413.33%
Git



310%
Other Option



13.33%


Q4:Which MapGuide Viewer do you use? 

AJAX Viewer



1354.17%
Fusion / Flexible Layouts



625%
Other Option



520.83%
 
Q5: Have you modified the viewer code in your installation? 

Yes



1770.83%
No



729.17%


Q6:Would you like to have minor bug fixes and improvements available via Subversion?  

Yes



1979.17%
I don't care



312.5%
No



28.33%

Q7:Have you ever manually deployed a bug fix for MapGuide? 


No



1458.33%
Yes



1041.67%


Q8:Have you ever upgraded Fusion using a version from the Fusion Website? 


No



1560%
Yes



728%
I wanted to, but it was too hard



28%
Fusion has a website?



14%

Q9:Finally, have you ever avoided upgrading to the latest MapGuide release because of your customised code? 

Yes



1145.83%
No



1145.83%
I have never customised any MapGuide code



28.33%

Monday, April 11, 2011

Oracle Reserved Words System Table

If you ever need to check if a column name is a reserved word in Oracle, you can get the list using this query

select keyword from v$reserved_words

Thursday, March 31, 2011

Oracle Grant Sequence Syntax

It's dead simple: GRANT select ON schema.sequence_name to schema

Amazingly, Google's results for this are shocking at the moment, dead end unanswered or confusing results

Wednesday, March 30, 2011

MapGuide End User Survey - RFC 111 Subversion

I put forward an idea for a RFC for Mapguide, which involves deploying the MapGuide web viewer apps
(Fusion and AJAX Viewers) checked out from Subversion.

The initial proposal is MapGuide RFC 111 - Deploy Viewer Code with Subversion Attributes
with the follow up discussion over on MapGuide-Internals

There have been some questions over how the end users of MapGuide would find using this
solution. Of course it's entirely optional solution for keeping your MapGuide Server running
with the latest bug fixes / improvements for the web viewers.

So I have put together this Quick Survey to get some background on our user base.

http://zackster.polldaddy.com/s/mapguide-source-control-survey
(Poll is now closed)

Wednesday, March 09, 2011

SQL Server 2008: ARITHABORT error with Spatial data

This is a nice cryptic error:


UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. 

If you get the following error with a SQL Server 2008 database when your trying to update some spatial data, the solution is to check the compatibility level for the database, I was working on an application which has been around for a while and it was set to be compatible with Sql Server 2000, hence the error.

I was a bit stumped initially, as this was my first look into spatial data with MS SQL Server, luckily Jackie Ng sits next to me and he found the solution pretty quickly.

Overall, my initial impressions of the Spatial support in SQL Server is that it's pretty basic compared to Oracle which is a much more complete implementation, but I'm glad spatial is finally a standard feature. I am rather surprised that re-projection is not part of the standard feature set.

I really loathe Oracle for it's recalcitrant attitude to Oracle Spatial licensing, but having seen what Sql Server offers, I understand why Oracle still does what it does, as SQL Server is not nearly equivalent.

Of course, IMHO anyone starting out on a new project requiring a spatial database should use PostGIS period.





Saturday, February 05, 2011

Some Android Market Improvements I'd like

I just this story Hands on: Android Market website a step forward, still lags AppBrain and it's a pretty good review.

There's a few basic design things I'd like to see changed on the Android Market.

  1. Use a different colour for the INSTALL and INSTALLED buttons, while your at it, pick another word, it's too confusing only differing by '-ED'
  2. Offer list views with more content per page,  paging 12 apps at a time is very 1990's
  3. Allow users to filter out installed from the listings
  4. Continuous scrolling rather than tired old paging
  5. The ability flag individual apps to be hidden from the listings, i.e. hide this app
Other Android observations ...

I've had a Nexus S for a while now and I'm really enjoying it as a phone, it's much smoother than my previous N1.
Battery does take ages to charge, thankfully I got two (more) chargers when I bought the phone.

Alas, the Gingerbread phone reboot bug has occurred a few times, otherwise the phone is really sweet.

The Gallery app is still a bit slow and the amount of time it takes to open a photo straight after taking it is a joke.

Tweetdeck is great, but it's started crashing all the time. The fancy scroll to the
top animation will crash it every time I jump back into the app after a few hours.

Perhaps a long press on the title bar bypass the scroll animation?