Best CRUD for i

Ok.  I’ll cut t the chase:  There *aren’t* any.  At least that I can find and that have the features I want.  I have tried the following:

Rails – It is REALLY hard to handle legacy database issues.  My particular Achilles heel are the field names with # in them.  # is a comment flag in Ruby so naturally it hoses up the code.  No way to work around it either.  Rails is fast, easy to get up and running but the # issue is a deal breaker.

EGL – Great code generation and tools for creating CRUD applications quickly.  Biggest issue for me is the ease with which you can change databases (I usually develop with MySQL or MSSQL and then deploy to DB2).  Also, the RUI requires web services in order to work and web services just add another level of complexity making *quick and easy* CRUD difficult.

jEspresso – Cool Java based framework.  Easy to develop a CRUD app but the UI is a little clunky and I had difficulty in getting things going.  This has some promise though.

Roma – Another cool Java Framework.  I just couldn’t get it all to work.  The documentation is lacking and the framework is difficult to get your head around. It does work and like jEspresso, has some promise.

ATK – A PHP framework that makes CRUD very easy.  This is a cool little framework and it has been developed with the i in mind.  But, there’s the rub.  It isn’t as friendly to rapid switching of databases like Rails or other JDBC oriented frameworks are.  This IS a cool little framework though.  It is PHP5 based and if you plan to ONLY deploy to the i, this is a great way to go.

So, I dropped back to my tried and true Freemarker/jQuery application development method.  I have even given build my own CRUD framework, using Freemarker and jQuery some thought.  But, I have LOTS of applications yet to finish. And, without a good CRUD framework to use, I have to hand roll all of them.

Gotta go!

This entry was posted in Uncategorized. Bookmark the permalink.