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 3.0.0 has landed with tons of new features and updates including ForgeBox Storage and ForgeBox Lucee Provider!

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.

We are very excited to bring you a new commercial product release for the Ortus Family: Redis Lucee Extension  The Redis Lucee Extension allows you to natively connect to a Redis Server cluster and leverage it for distributed caching, session/client storage and distribution, cluster RAM file systems, and much more. It can allow your Lucee servers to scale and extend easily by leveraging Redis Server as the platform of choice for session/cluster managements, caching and virtual file-systems.

If you have ever asked yourself these questions, then our Lucee Extension can help you:

• Want to use round-robin balancing instead of sticky sessions?
• How do you deal with session/client information when you have more than 1 server in your cluster?
• How can I scale my Lucee servers when I am running out of RAM?
• Do you want your users to still be logged in even if a server in my cluster dies or is restarted?
• Do you want to have a cluster-wide file system?
• Do you want to be able to cache data in a distributed and elastic fashion?

We have been working with Redis Server for many years and it has been a true pleasure to not only build scalable farms with it, but also it is incredibly responsive when it comes down to key-value storage and caching transactions.

Capabilities

Here are some of the major features of our Redis Extension:

• Add Native Redis functionality to any Lucee CFML application
• Install at the server level (Available to all contexts)
• Create Cache connections in the Lucee administrator to connect to any network-accessible Redis cluster
• Set and get objects from Redis via standard CFML functions and tags cachePut(), cacheGet(), <cfcache action=“get|put”>
• Fully supports all built-in Lucee cache functions including wildcard filters
• Seamlessly distribute storage of the following to any bucket in a Redis cluster
  • Lucee session storage
  • Lucee client storage
  • Lucee RAM resource ram://…
• Seamlessly cache the following to any timeout-sensitive bucket in a Redis cluster
  • Results of database queries <cfquery cachedwithin>
  • Results of deterministic functions <cffunction cachedwithin>
  • Complex or simple objects in your application's code
  • Cached templates <cfcache action=“content|cache|serverCache”>
• Registers new CFML Built-In Functions (BIFs) for native Java access to Redis
• Extremely lightweight and fast

Purchase Extension

Resources

Please visit our Extension page for all the necessary resources.

• Purchase
• Capabilities
• Trial Version
• Professional Support

More than two years have passed since CFCouchbase 1.1 was released. With community support, we are happy to announce the release of CFCouchbase 2.0.0! If you are not familiar with CFCouchbase we encourage you to checkout the Documentation. The SDK has been updated to support the new functionality available in Couchbase Server 4.x, including:

• N1QL Queries
• GSI Indexes
• Replica Reads
• Document Locking
• Prepared Statements
• Improved Design Document Management
• Expanded Configuration Options
• And more…

It is finally here! ColdBox 5 RC1 has landed with force! There are so many things to talk about, but we will focus on what RC brings and all the eco-system updates we have been working on. So let's begin this adventure.

We are very excited today to announce the immediate release of our first two extensions for Microsoft Visual Studio Code Our ColdBox Extension is very similar to our Sublime extension but better! I have to admit that VSCode is absolutely great and we have been able to not only release our collection of snippets but give you typeahead and scope recognition in this extension.

We are pleased to announce the general availability of CommandBox 3.9.0.  This is a minor release of our CFML CLI, REPL, Package Manager, and portable server.  3.9 comes with a few new features as well as a nice list of bug fixes and enhancements.

We're wrapping up the release of CommandBox 3.9.0 which is available now as a release candidate.  I'd like to get as many eyes as possible to ensure everything is working good before we finalize the release. 

We have a new release of ForgeBox to walk you through today. Focused on private packages and bug fixes, this release polishes up ForgeBox to bring you a really nice user experience. Come read about the details.