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