{ DreamFactory: 'Blog' }

Using Event Scripts to Filter Related Data

Posted by Drew Pearce

Tue, Sep 12, 2017

One of DreamFactory's most popular features is the ability to pull in foreign key related records in an API call, and even to create your own virtual relationships between disparate data sets. This make compiling all the data you need in one place a matter of asking the API for the related items. You can use filters and ordering to select the exact records you want to display, and their related items come along for the ride. Simple. Easy.

API Tutorials APIs API management

A RESTful introduction to Open Data APIs using the DreamFactory HTTP Service

Posted by Matthew Schaer

Tue, May 16, 2017

Dreamfactory has long touted our ability to securely generate REST APIs from a slew of different sources like SQL,NoSQL,SOAP, Files, AD/LDAP, SNS, SSO but Dreamfactory also allows you to connect existing REST services. In this short tutorial I’ll show you how to configure an HTTP service in DreamFactory using Open Data from data.gov, test it out and even infuse a little Swagger for documentation!

API HTTP Service Open Data APIs

The importance of loose coupling in REST API design

Posted by Bill Appleton

Wed, Mar 1, 2017

One of the most important ideas in the world of software engineering is the concept of loose coupling. In a loosely coupled design, components are independent, and changes in one will not affect the operation of others. This approach offers optimal flexibility and reusability when components are added, replaced, or modified. Conversely, a tightly coupled design means that components tend to be interdependent. Changes in a single component can have a system wide impact, with unanticipated and undesirable effects.

REST API DreamFactory API Enterprise Applications

Database Table Endpoint Obfuscation Through Custom Scripting

Posted by Drew Pearce

Wed, Dec 21, 2016

DreamFactory’s power lies in the automatic generation of API endpoints and its standardization. There are times however, where you need something a little more custom, and that’s why we have scripting engines included. Let’s look at a specific use case for custom scripting that we have users ask about a lot.

API Custom Scripting JavaScript Tutorials

Building a healthcare app with auto-generated APIs from legacy and modern databases

Posted by Carsten Jacobsen

Wed, Aug 3, 2016

DreamFactory can be used to turn an existing database into a REST API, as well as for a new project with fresh database. But, you can also use it to integrate multiple database types, in tandem.

NoSQL API SQL JavaScript Tutorials

DreamFactory 2.2.1 released, includes major enhancements to stored procedures

Posted by Ben Busse

Wed, Jul 13, 2016

DreamFactory version 2.2.1 has shipped. v2.2.1 includes major enhancements to stored procedures, API improvements, UI improvements, and a number of bug fixes. See all the details below and grab the latest from Bitnami or GitHub.


DreamFactory 2.2 released, includes important API changes

Posted by Ben Busse

Thu, Jun 2, 2016


We're excited to announce DreamFactory Version 2.2. There are a number of important design improvements to services, scripting, and system resources. But the biggest change is that APIs for commercial databases will no longer be open source.

NoSQL DreamFactory API SQL

Video Tutorial: Writing Node.js Scripts

Posted by Ben Busse

Thu, May 26, 2016

DreamFactory now supports four ways to write server-side scripts: Javascript (with DreamFactory's built-in Javascript V8 engine), Node.js, PHP, and Python.

This short video demonstrates how to set up your DreamFactory instance to work with Node.js and how to write event scripts and custom APIs with Node.js.

DreamFactory API Custom Scripting JavaScript Node.js Tutorials

DreamFactory 2.1.2 released, includes app packages

Posted by Ben Busse

Mon, May 2, 2016


DreamFactory version 2.1.2 just shipped. The big news in this release is application packages. The packages features makes it easy to bundle and deploy your apps, services, scripts, schema, and user roles between different DreamFactory instances. We also added virtual foreign key joins between SQL databases and MongoDB. That means you can join data between a SQL database and MongoDB with a few configuration clicks :-)

NoSQL DreamFactory API SQL

DreamFactory 2.1.1 released, includes Angular 2 and React apps

Posted by Ben Busse

Fri, Mar 25, 2016

DreamFactory version 2.1.1 has shipped with a bunch of enhancements and new example apps for Angular 2 and React.

DreamFactory API

DreamFactory 2.1 released, includes OpenAPI spec upgrade

Posted by Ben Busse

Thu, Feb 25, 2016

DreamFactory version 2.1 has shipped with some great new features. You can install DreamFactory 2.1 from Bitnami, get it on GitHub, or sign up for a free developer sandbox to try it out before installing. 

DreamFactory API

New DreamFactory 2.0 Tutorial Videos

Posted by Ben Busse

Wed, Jan 27, 2016

A lot of people like watching quick screencasts to get up to speed on the basics of a product. We just made a bunch of videos on DreamFactory 2.0 Admin Console that introduce the basics of the product. We've also made some new videos on how to use DreamFactory 2.0 for common use cases, including how to use the REST API for MySQL, SQLite, MongoDB, and remote web services. Stay tuned for more videos over the coming weeks, including how to add custom services, use event scripts, connect multiple databases with our new "data mesh" feature, connect to any SOAP service with REST, and more!

NoSQL DreamFactory API SQL

How To Securely Mobilize Data Using a REST API Backend

Posted by Bill Appleton

Thu, Jul 2, 2015

We get lots of inquiries about how the DreamFactory REST API platform helps secure data access, particularly from larger enterprise and government users. It's a valid concern: a growing number of web and mobile apps need to access sensitive data, and proper controls must be implemented in the services used to access that data from an expanding number of apps.

REST API DreamFactory API Authentication Enterprise Architecture Security PHP

SOA is Not a Mobile Backend

Posted by Bill Appleton

Mon, Jun 22, 2015

The rise of mobile devices finally pushed the adoption of RESTful web services into the mainstream of application development. But years before this, companies used web services to build sophisticated service-oriented architectures for application development and integration. Some of the enterprise service bus (ESB) and API management vendors have even tried to adapt SOA systems to the brave new world of mobile devices—with limited effectiveness. I'd like to examine some of the similarities and differences between SOA and mobile backend integration platforms.

REST API DreamFactory Mobile Apps API Enterprise Applications Enterprise Architecture Tutorials

A REST API Is Not Enough for Enterprise Mobile App Integration (Part 4 of 4)

Posted by Bill Appleton

Tue, Apr 21, 2015

My first three blogs in this series discussed the perils of building your own REST API, looked at some ineffective solutions that companies use to battle backend API complexity, and surveyed the advantages of a more comprehensive and reusable API strategy. Now in Part 4, I want to consider some of the additional issues that companies will need to consider if they want to build a complete backend platform for enterprise mobile, web, and IoT applications.

REST API DreamFactory API Enterprise Applications Enterprise Architecture

Band Aids Don’t Solve REST API Complexity (Part 2 of 4)

Posted by Bill Appleton

Thu, Apr 2, 2015

In my previous blog post, I examined the problem of REST API complexity in the enterprise. In short, as a company builds more and more web services, the situation server-side becomes increasingly complex, which can reduce portability, scalability, efficiency, and security. It also slows down development, just at a time when enterprises are scaling up development of mobile applications. In this blog post, I discuss some of the solutions that companies use to address this problem, and assess their effectiveness.

REST API Mobile Apps API Enterprise Applications Enterprise Architecture

Don't Build Your Own REST APIs (Part 1 of 4)

Posted by Bill Appleton

Fri, Mar 27, 2015

The engineering team at DreamFactory designed and built some of the very first applications that use web services. Over the years, we made many mistakes trying to create the perfect API backend for these applications.

In our experience working with customers, we’ve learned that many companies face the same challenges we had to think about and tackle over the years. One of the biggest challenges is figuring out a winning API strategy. This blog post lays out some of the traps and pitfalls that companies often experience when they decide to build their own REST APIs.

REST API Mobile Apps API Enterprise Applications

Tutorial: Angular + REST Made Simple

Posted by Ben Busse

Tue, Mar 18, 2014

 In this tutorial, we’ll show how to set up a simple AngularJS application that uses the angular-dreamfactory module. We wrote the angular-dreamfactory module to make it extremely simple to call REST services in your DSP from your Angular application. This tutorial explains how to get a simple trivia application up and running and showcases user registration, login, logout, reading and writing database records, and calling a third-party API.

Let’s get started!


Using OAuth with the New Portal Service (Part 2)

Posted by Jerry Ablan

Tue, Jan 14, 2014

Are we there yet?

This post picks up where part 1 left off... I apologize for the delay. My original post was too long so I split it into two parts. In reviewing the second installment, I realized that the concepts were a bit vague and would be better conveyed through an actual application.

Thus, the Portal Sandbox was born! The full source code is available on GitHub. Go ahead and clone a copy so you can follow along. I'll wait...

Remote Services API Authentication OAuth

Add a REST API to any SQL DB in Minutes

Posted by Todd Appleton

Wed, Jan 8, 2014

11/17/2015 - Originally written for DreamFactory 1.X, this post has been updated to reflect the current version, DreamFactory 2.0.

Have you got SQL data that you need to access from your mobile or web apps? If so, DreamFactory provides an easy and secure way to add a REST API to any SQL database in minutes. Supported SQL databases include SQLite, MySQL, SQL Server, Oracle, IBM DB2, Postgres, and SAP SQL Anywhere. With the free, open source DreamFactory REST API backend all you have to do is create a service for your database, then use the auto-generated REST API to access that service. Each DreamFactory instance comes with its own SQLite database that's accessible via the default 'db' service. Bitnami installs also include pre-configured MySQL and MongoDB (NoSQL) services. See the wiki for supported database types on the various host operating systems. In this blog post we'll show how to add additional services to REST-enable any SQL database. Then we'll show some simple examples of how to use the REST API to manage your SQL schema and data.

If you're a video kind of person, we have some screencasts available.

REST API DreamFactory API Enterprise Applications Enterprise Architecture SQL

Getting Started with the DreamFactory API

Posted by Jason Sykes

Fri, Aug 9, 2013

JasonSykesIn this blog post, we’ll show you how to make some simple API calls with the DreamFactory API. The API requires SSL3. If you plan on making requests from cURL, or your native SDK, make sure you are using version 3.

Weekly Digest

Recent Posts