RSS feed for InstantSpot site Sam Farmer's ColdFusion Blog

How to Add a Derby Database with DerbyCFC

Wed, 13 Feb 2008 13:00:00 GMT

Two simple lines to add a Derby database with DerbyCFC:

<cfset variables.derbyCFC = createObject("component","derbyCFC").init(adminPassword)> <cfset variables.success = variables.derbyCFC.createIfNotExists(name)>

That will add a database with a datasource of the same name. The createIfNotExists function also takes in all the other potential settings for a datasource (select, insert, grant, etc). I made some small changes to the code base to make the creation possible in two lines and with this comes version 1 of DerbyCFC. I hope it proves useful for open source projects, let me know if you use it and if you have any suggestions.

It has been a fun little project to work on and interesting to delve a little more into the AdminAPI. Lots of good stuff in there.

DerbyCFC: New Project with createIfNotExists function for Derby Databases

Sun, 20 Jan 2008 23:21:00 GMT

I've just released version 0.9 of DerbyCFC on RIAForge which is designed to make it easier to work with the Derby database embedded in ColdFusion 8.

DerbyCFC comes with two functions; createIfNotExists which does pretty much what it says and will create a new Derby datasource and database. getDerbyDatasources returns all Derby datasources in either raw format (a collection of structures) or as a query with a slightly smaller set of attributes.

The download zip includes example pages for creating a datasource and listing of current datasources. Go to the DerbyCFC project page.

I'm debating whether to extend this to provide a UI that would list and edit tables in a Derby database so let me know your thoughts. My hope is that this will make it easier to create Derby databases for other open source projects.

The First Post

Sun, 01 Apr 2007 18:59:53 GMT

The first post. I've decided to start a blog primarily because I like writing. And having been a programmer for the last 10 years I haven't written much during that time. I also realize I like writing about technical issues and have a fair amount on my mind at the moment so it seems like a good time to start a blog. Note, I did not say I was a grammatically correct writer. So, expect the odd typo and grammatically incorrect sentence from time to time. This is a blog and I'm not going to use the grammar corrector in Word before posting.

I am also intrigued by social networking so InstantSpot seemed a good spot (pun intended) to start my blog.

I aim to cover a bunch of topics, some tutorials and explanations of basic ColdFusion functionality, thoughts on the future of the web and ColdFusion, conferences, and anything else that comes up. I will mostly be focusing on ColdFusion (and will probably start using cf as an abbreviation real soon) though I do hope to post on other non-cf topics like JavaScript, MySQL and databases in general and who knows what else in the future.

I am not going to aim to publish on a regular basis and have pledged to keep this blog a purely non-work time activity. I'm busy enough there anyway. Good busy. I also don't believe blogs die. So if I have nothing good or interesting to say I will say nothing. I also don't think this will turn into a news blog with short entries and links to the latest news. There are enough of those, and, I rely on them for my tech-news as much as anywhere else. In short, if you like what you are reading I suggest using the RSS feeds or subscribing over email.

More to come...