Blog

qb 5.2.0 Released!

Eric Peterson March 12, 2018

Spread the word

Eric Peterson

March 12, 2018

Spread the word


Share your thoughts

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!

Add Your Comment

Recent Entries

Ortus Content Digest for week of August 12th

Ortus Content Digest for week of August 12th

It's August 12th... what has Ortus been publishing this week? We have the CFML News Podcast, some CFCasts and YouTube Videos, lots of Ortus and ITB Blog Posts. We have a lot more planned for next week as well.

Gavin Pickin
Gavin Pickin
August 12, 2022
Want native Redis Support in Lucee/CFML? Ortus Redis Extension v2.0.0 Released!

Want native Redis Support in Lucee/CFML? Ortus Redis Extension v2.0.0 Released!

We are very excited to bring you another release for our Redis Lucee Extension. This is a major release spawning research of over 9 months. We have done great strides in this new extension to not only bring you the best scaling capabilities via Redis, but also now to introduce to the CFML world: Real-Time messaging with Redis Pub/Sub! Here is our full release notes in our brand new documentation book: What's New With 2.0.0!

Luis Majano
Luis Majano
August 05, 2022