The Ortus BlogBox

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

 

 

Category Filtering: 'forgebox'

 

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

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

The 12 Modules of (ForgeBox) Christmas — Day 12 — CFFractal

Eric Peterson
Dec 25, 2017

 

Welcome to the last day of (ForgeBox) Christmas! I hope you have enjoyed this crash course in these different modules. The ForgeBox ecosystem is vast and wonderful. Next time you have a need, open up https://www.forgebox.io and check to see what the community has already contributed. Let's end today with an introduction to CFFractal, an API marshalling module.

12 Modules of (ForgeBox) Christmas, ColdBox MVC, ForgeBox, Modules 0

The 12 Modules of (ForgeBox) Christmas — Day 11 — CommandBox Migrations

Eric Peterson
Dec 24, 2017

 

Let's tackle a powerful module today. It will take quite a bit of configuration, but hopefully you will see the usefulness of this module by the end of this post. Meet CommandBox Migrations, a tool for managing and running your database migrations with CommandBox.

12 Modules of (ForgeBox) Christmas, CommandBox, ForgeBox, Modules 0

The 12 Modules of (ForgeBox) Christmas — Day 10 — TestBox Snapshots

Eric Peterson
Dec 23, 2017

 

Today's featured module is a TestBox module that introduces snapshot testing capabilities to TestBox. If you've avoided testing your legacy applications, come see how TestBox Snapshots can get you started.

12 Modules of (ForgeBox) Christmas, ForgeBox, Modules, TestBox 0

The 12 Modules of (ForgeBox) Christmas — Day 9 — verify-csrf-interceptor

Eric Peterson
Dec 22, 2017

 

I love modules that help me do the right thing in my code, especially when I often forget to do something. Today's module is very straight-forward — verify-csrf-interceptor — an interceptor that will automatically check for CSRF tokens for all non-GET requests to help protect against cross-site request forgery.

12 Modules of (ForgeBox) Christmas, ColdBox MVC, CommandBox, ForgeBox, Modules 0

The 12 Modules of (ForgeBox) Christmas — Day 8 — CommandBox Githooks

Eric Peterson
Dec 21, 2017

 

A short one but a good one today. Let's see how we can automate tasks with CommandBox Githooks.

12 Modules of (ForgeBox) Christmas, CommandBox, ForgeBox, Modules 1

The 12 Modules of (ForgeBox) Christmas — Day 7 — cfcollection

Eric Peterson
Dec 20, 2017

 

Learn about a cross-engine. expressive, and extendible functional programming library today — cfcollection.

12 Modules of (ForgeBox) Christmas, ForgeBox, Modules 0

The 12 Modules of (ForgeBox) Christmas — Day 6 — qb

Eric Peterson
Dec 19, 2017

 

In the CFML scene, there seems to be two names when it comes to data persistance plain ole' cfquery and ORM — not much inbetween. Our module highlight today is out to change that.

Meet qb.

12 Modules of (ForgeBox) Christmas, ForgeBox, Modules, ORM 0

The 12 Modules of (ForgeBox) Christmas — Day 5 — whoops

Eric Peterson
Dec 18, 2017

 

Today let's look at a quick, fun module today. It will make your exception experience in development just a little bit nicer. It's called whoops.

12 Modules of (ForgeBox) Christmas, ForgeBox, Modules 2