Blog

Luis Majano

August 29, 2019

Spread the word


Share your thoughts

It has been a long time coming, but we finally get a major release for DataBoss our Dynamic Administrator. This major release brings a slew of updates, new features and now Adobe 2016, 2018 and Lucee 5 Support.

What is DataBoss?

Ortus DataBoss is an application that will help you manage CFML Object Relational Mapper (ORM) objects without the need of writing administrative code for them; thus a Dynamic Administrator.  DataBoss will talk to the underlying ORM engine (Hibernate) and get all the necessary information to manage all the ORM entities and its relationships in that specific CFML application DataBoss has been deployed to.  You can watch our introductory video to get a quick overview of what DataBoss is and how it can benefit your development.  In version 3 we have added the capability to do RESTFul exports, so you now can use DataBoss as your a data API layer as well.

Capabilities

  • Download as a standalone application that can integrate with any framework or application
  • Download as a ColdBox module so it can integrate with any ColdBox 5+ application
  • Automatic Hibernate ORM entity detection and analysis
  • Ability to manage all supported Hibernate relationships: One-To-Many, Many-To-One, One-To-One, Many-To-Many in a response interface
  • Ability to manage multi-level inheritance relationships
  • RESTFul exporting built-in for all entities with pagination and multiple response formats (xml,json,jsonp,wddx,pdf)
  • Ability to control the data marshalled form the RESTFul exports
  • Internationalized and localized for: English, Spanish, German, French, Portuguese and more
  • Ability to create/edit/delete and multi-delete any managed entity and its data
  • Built-in form validation based on ColdBox Validation and ORM metadata
  • Customizable validation rules
  • Customizable HTML 5 controls for persisted properties: Checkbox, Radio Buttons, Multi-Select, Text, Email, URL, Password, Textarea, Super Lite Rich Text Editor, Date Picker
  • Ability to paginate entity records and do inline filtering/sorting of data
  • Easily interface layout overrides if ran as a ColdBox Module
  • Easily extend the custom CSS framework
  • Ability to reload the ORM engine a-la-carte
  • Application responsive design ready for phone and tablet usage
  • Database null support

RESTFul Exports

One of the major features of this release is the ability to export your ORM data via JSON, XML, WDDX or PDF.  We have included the mementifier module as part of this release which will allow you to define metadata in your entities that will be used to export the data as an API. 

There are two entry points for resource export:

  • Entity Listing
  • Entity by ID

Listing Export

The listing export uses the following RESTful route:

// With Format in URL
/databoss/entity/:entity/export/:format

// With Format as Extension (if enabled)
/databoss/entity/:entity.(json|jsonp|xml|wddx|pdf)

 

Here are some examples:

 

// With Format in URL
/databoss/entity/user/export/json
/databoss/entity/roles/export/json
/databoss/entity/roles/export/jsonp
/databoss/entity/entries/export/xml
/databoss/entity/entries/export/wddx

// With Format as Extension (if enabled)
/databoss/entity/user.json?page=4&excludes=role,permissions
/databoss/entity/user.jsonp
/databoss/entity/user.xml
/databoss/entity/user.wddx
/databoss/entity/user.pdf

You can choose pagination and even choose which columns to include/exclude in your final output representation.

Entity Export

The entity export uses the following RESTful route:

// With Format in URL
/databoss/entity/:entity/id/:id/format/:format

// With Format as Extension (if enabled)
/databoss/entity/:entity/id/:id.(json|jsonp|wddx|xml|pdf)

 

Here are some examples:
 

// With Format in URL
/databoss/entity/user/id/2/export/json
/databoss/entity/roles/id/3234/export/json
/databoss/entity/user/id/2/export/wddx
/databoss/entity/user/id/2/export/jsonp

// With Format as Extension (if enabled)
/databoss/entity/user/id/2.json
/databoss/entity/user/id/234234.xml
/databoss/entity/user/id/2234.pdf

 


Resources

Release Notes

  • Adobe ColdFusion 2016 and 2018 Support
  • Lucee 5.3+ Support
  • Boolean support for single check boxes
  • Upgrade to cborm v2
  • More dynamic entity validations on all forms
  • Full RESTFul API support for exporting entity data via mementifier.  You now also have complete control of the output of the API
  • ColdBox 5 Upgrades
  • UI library updates
  • Ability to exclude/include entities in the home page selector
  • Performance updates
  • Non-standard include path on minified CSS and JavaScript can cause some resources to not load

Add Your Comment

Recent Entries

Ortus Will be at Adobe CF Summit 2022!

Ortus Will be at Adobe CF Summit 2022!

4 of our Ortusians will be speaking at CF Summit this year from Oct 3 - 4 in Las Vegas, Nevada. Here are all the details you need to join us and enjoy valuable CFML content to modernize your projects! We are sponsoring the event and will have a booth for you to come by and have a chat with our team!

Maria Jose Herrera
Maria Jose Herrera
September 27, 2022
Prefetching in CBWIRE

Prefetching in CBWIRE

When I want to increase the perceived speed of my CBWIRE apps, one tool I reach for is prefetching. Prefetching is a built-in feature of Livewire JS that allows you to invoke an Action's results on mouseOver.

Grant Copley
Grant Copley
September 20, 2022
Into the Box 2022 - Conference Recap

Into the Box 2022 - Conference Recap

This years Into the Box has just wrapped up, but we are already preparing for 2023’s Into the Box, May, Houston Texas! The event was a huge success, we had solid attendance in person, and almost doubled our online viewership from 2021, great feedback from attendees in Houston, and online. So many attendees didn’t say goodbye at the end of the conference, they said see you next year, which, as an organizer lets you know you’ve done things right, and the hard work has paid off.

Gavin Pickin
Gavin Pickin
September 16, 2022