The Ortus BlogBox

"Ortus: A rise, beginning, coming into being, born, the origin!"

 

qb 5.2.0 Released!

Eric Peterson
Mar 12, 2018

 

Quick announcement today about qb. We're excited to announce that starting with version 5.1.0, QB has full query and schema builder support for four major database grammars:

  • Microsoft SQL Server (MSSQLGrammar)
  • MySQL (MySQLGrammar)
  • Oracle (OracleGrammar)
  • Postgres (PostgresGrammar)

Set your preferred grammar in your moduleSettings and you are good to go:

moduleSettings = {
    qb = {
        defaultGrammar = "PostgresGrammar"
    }
};

Install or update today from ForgeBox.

Haven't heard about qb? qb is a Query and Schema Builder for CFML. With it you can write object-oriented, database agnostic SQL statements in a convenient and friendly format.

// Query Builder
query.from('posts')
    .whereNotNull('published_at')
    .whereIn('author_id', [5, 10, 27])
    .get();

// Schema Builder
schema.create( "users", function( table ) {
    table.increments( "id" );
    table.string( "email" );
    table.string( "password" );
    table.timestamp( "created_date" ).default( "CURRENT_TIMESTAMP" );
    table.timestamp( "modified_date" ).default( "CURRENT_TIMESTAMP" );
    table.timestamp( "last_logged_in" ).nullable();
} );

Want more information? Check out the comprehensive documentation.

Coming to Into the Box? Be sure to check out the session on qb while you are there!

ForgeBox, Into The Box, Modules, Releases 0

Into The Box 2018 is Only 7 Weeks Away!

Dillon Slaughter
Mar 09, 2018

 

Into The box 2018 Trailer from Luis Majano on Vimeo.

Into The Box is just a mere 7 weeks away! This is a 2-day, 2-track event with speakers from around the world presenting on topics surrounding the Ortus Solutions product stack, modern ColdFusion (CFML), Java, web technologies, development processes and software craftsmanship. The conference is on April 26-27th at the Hyatt Place, in The Woodlands, Tx and we will be having a hands-on training workshop day on April 25th were you can train with the Ortus Team.

Make your reservations today and join us in the modernization of the Coldfusion community together!
Into The Box 2018

0

New ForgeBox Features — March 2018

Eric Peterson
Mar 09, 2018

 

ForgeBox 3.0.0 has landed with tons of new features and updates including ForgeBox Storage and ForgeBox Lucee Provider!

 

Comments are currently closed
Cloud, CommandBox, ForgeBox, Lucee, Lucee Extensions, Modules, Releases

Fusion Reactor is now Sponsoring Into The Box 2018!

Dillon Slaughter
Mar 05, 2018

 

We are very excited to announce that Fusion Reactor, a silver level sponsor for Into The Box 2018, will be giving their very own lunch time #session!

Don't miss this keynote speaker April 26th at 12.30pm! FusionReactor goes beyond “just monitoring”, to actively minimize server downtime and accelerate time to resolution like no other monitoring tool on the market. Cut to the chase and get to the root of your Java production application problems in no time.

Haven't made your reservation yet? Join us in one of our 4 pre-conference workshops and 25+ speaking sessions worth of Coldfusion madness from April 25th-27th at the Hyatt Place in the Woodlands, Tx. 

–Buen Provecho!

Into The Box 2018

0

8 Weeks to Go Until Into The Box 2018 | Speaker Highlights

Dillon Slaughter
Mar 01, 2018

 

Logo Banner - Into the Box 2018 - Coldfusion and Java redefined

Into The Box is a 2-day, 2-track event with speakers from around the world presenting on topics surrounding the Ortus Solutions product stack, modern ColdFusion (CFML), Java, web technologies, development processes and software craftsmanship. The conference is on April 26-27th at the Hyatt Place, in The Woodlands, Tx and we will be having a hands-on training workshop day on April 25th were you can train with the Ortus Team.

Into The Box 2018

0

Into The Box 2018 | Go from Zero to Hero

Dillon Slaughter
Feb 23, 2018

 

Logo Banner - Into the Box 2018 - Coldfusion and Java redefined

Into The Box 2018 is going to be an extravaganza of coldfusion madness with over 25 + different speaking sessions and 4 hands on workshops April 25th-27th in The Woodlands, TX! Our speakers include our very own Ortus team and others from all around the globe that are a huge part of the CFML community. This week we wanted to inform you that one of our most popular workshops, Coldbox 0–Hero has already sold out, but we have good news! We have decided to add another assistant and make room for 5 more attendees! So get your seat before it's too late! But you might be wondering what exactly does it look like to go from Zero to Hero?

Go From Zero to Hero

0

10 Weeks Left Until Into The Box 2018! | Workshops + Group Hotel Discount Code

Dillon Slaughter
Feb 14, 2018

 

Into The box 2018 Trailer from Luis Majano on Vimeo.

Into The Box 2018 is just around the corner and our Early Bird Special is ending soon! So if you haven't made your purchase yet, the sale ends February 25th!


Our event will be hosted at the Hyatt Placein The Woodlands, Tx April 25th–27th. To receive a discounted group rate on room reservations call @ 855-312-7268 or visit their website and enter the group promo code G-ORSO! We are incredibly thankful to be hosting another year and look forward to exploring the latest advancements in the CFML community with you all!

Register Today!

0

12 Weeks Left Until ITB 2018 | Early Bird Pricing Ends Soon!

Dillon Slaughter
Feb 07, 2018

 

We are offering Into The Box Early Bird Pricing only up to the 25th of February! Hurry and purchase your seat soon as time and spots are running out! Also for this week we are continuing with more speaker highlights featuring 3 more of our awesome keynotes!

0

TestBox v2.6.0 Released!

Luis Majano
Feb 06, 2018

 

We are excited to announce the release of TestBox version 2.6.0. To install just do:

box install testbox --savedev

To upgrade your current testbox installation just run the following:

box uninstall testbox && install testbox --savedev

TestBox 2.6.0 is a minor release with some great new functionality and tons of fixes. You can find the release notes here and the major updates for this release.

ColdBox MVC, ColdFusion, Community, News, Releases, TestBox 0

More Speaker Highlights | Only 13 Weeks Until ITB 2018!

Dillon Slaughter
Feb 02, 2018

 

Get ready for Ortus' Into the Box 2018 by getting to know our speakers! With only 13 weeks to go, hurry and sign up today. The Early Bird special is endind soon, February 25th! Sign up today!

Register Early Bird!

0