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!

Recent Entries

Into the Box 2024 Last Early Bird Days!

Into the Box 2024 Last Early Bird Days!

Time is ticking, with less than 60 days remaining until the excitement of Into the Box 2024 unfolds! Don't let this golden opportunity slip away; our exclusive Early Bird Pricing is here for a limited time only, available until March 31st. Why wait? Secure your seat now and take advantage of this steal!

Maria Jose Herrera
Maria Jose Herrera
March 20, 2024
Ortus February Newsletter 2024

Ortus February Newsletter 2024

Welcome to Ortus Solutions’ monthly roundup, where we're thrilled to showcase cutting-edge advancements, product updates, and exciting events! Join us as we delve into the latest innovations shaping the future of technology.

Maria Jose Herrera
Maria Jose Herrera
March 06, 2024
Unveiling the Future of CFML Development - 3rd Round of Sessions

Unveiling the Future of CFML Development - 3rd Round of Sessions

Welcome back to our journey into the future of CFML development! As excitement continues to build for Into the Box 2024, we're thrilled to bring you the latest updates on what promises to be a transformative event. Continuing our blog post series, let's delve deeper into the third wave of session releases and discover the key surprises awaiting attendees. Learn More

Maria Jose Herrera
Maria Jose Herrera
March 01, 2024