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

Introducing numeric placeholders in BoxLang source!

Introducing numeric placeholders in BoxLang source!

Introducing Numeric Placeholders in BoxLang

We're excited to announce a new addition to our BoxLang parser—a feature that draws inspiration from several other languages but fits naturally within BoxLang. The conversation around which features from other languages m...

Maria Jose Herrera
Maria Jose Herrera
September 18, 2024
BoxLang 1.0.0 Beta 14 Launched

BoxLang 1.0.0 Beta 14 Launched

In this release, we are excited to introduce several new features and enhancements aimed at improving functionality and user experience. These updates include the creation of immutable query types, new server keys to aid on CLI tooling, and methods to identify runtime initiation modes.

Additionally, we've added an event announcement for dump rendering to enable better integration with external listeners. Read on to learn more about these features and how they can benefit your workflow.

Code Strong!

Luis Majano
Luis Majano
September 13, 2024
Are you attending Adobe CFSummit 2024?

Are you attending Adobe CFSummit 2024?

If you are attending the Adobe ColdFusion Summit 2024, this is what you need to know: As always, Ortus Solutions will be sponsoring this years event as Silver Sponsors, we are excited to meet all the new attendees and old friends of the community of Coldfusion developers

Maria Jose Herrera
Maria Jose Herrera
September 10, 2024