{ DreamFactory: 'Blog' }

Wrangling Your Data with Database Functions

Posted by Lee Hicks

Thu, Feb 2, 2017

One of the fundamental goals of the DreamFactory platform is to make it easy to get the data you want, in the format you want, from the sources you have available. Sometimes the type and/or format of the data in the database isn't easy to pass to and from a client RESTfully, particularly using JSON or XML payloads. DreamFactory's database functions support solves this problem.


How to connect to a MySQL database with JavaScript

Posted by Carsten Jacobsen

Mon, Jan 16, 2017

The DreamFactory REST API enables database connections using a wide variety of front end scenarios. This simple sample app demonstrates how DreamFactory 2.0 easily can be used as a backend for a JavaScript application. It's a simple address book, where contacts can be created, shown, updated, deleted and grouped, basically CRUD operations.

SQL Sample Apps JavaScript Tutorials

Nurse Call systems for Hospitals and Rest Homes.

Posted by Alex Bowen

Tue, Dec 27, 2016

John Gilfillan, Software Engineer from Miracle Electronicscreated Nurse Call or Care Call systems for Hospitals and Rest Homes. They wanted a REST API that could interact with their software, as well as to give users the ability to make changes to the system remotely. They run a software application called "Angel" on a P.C. which monitors call points located at the bedside of each Hospital patient or in the home of a Rest Home occupant.  

SQL User Stories healthcare

Virtual Relationships Redux

Posted by Lee Hicks

Tue, Dec 6, 2016

In the early part of 2016, we introduced a feature called DataMesh, also known as Virtual Relationships, or Virtual Foreign Keys. The idea behind this feature is to allow users to set up “virtual foreign keys” to relate data across tables in the same SQL database where foreign keys did not exist or were not desired, or across different SQL databases altogether. We even allowed relating a SQL database table to a MongoDB collection, opening up a whole new way for a client to retrieve all the data it needed, molded in a way that was easily consumable.

SQL MongoDB Related Data DataMesh Foreign Keys

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

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

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

DreamFactory 2.0 Support For SQLite

Posted by Bill Appleton

Wed, Dec 16, 2015

I have been blogging extensively about the highly scalable and enterprise class features in DreamFactory 2.0. We’ve benchmarked huge server installations and explored exciting new possibilities with Big Data. But now in a complete change of course, I want to talk about what may be the coolest new feature we have: DreamFactory 2.0 now supports SQLite. It may not be massively scalable, but SQLite is an extremely convenient way to create a database on the fly for development and testing. Production applications can also benefit from this nifty new feature.

REST API SQL DreamFactory Silver

Combining Multiple Data Sources In One API With DreamFactory

Posted by Ben Busse

Wed, Dec 9, 2015

DreamFactory 2.0 allows you to hook up any number of SQL or NoSQL databases, and then you instantly get a complete REST API for each one. This information can be combined in any way that you need on the client. But sometimes you might want to combine multiple data sources on the server and return the information in a single REST API call.

This is really easy to do with DreamFactory 2.0.

NoSQL SQL DreamFactory Silver

DreamFactory 2.0 Bundled With MongoDB

Posted by Ben Busse

Fri, Nov 6, 2015

All of the new Bitnami packages for DreamFactory 2.0 have MongoDB built into the installation. Just run the installer, open up the admin console, and MongoDB is right there as one of the available services. This blog post discusses why we bundled MongoDB in the latest version of DreamFactory and how you can to use this great NoSQL database.

NoSQL SQL DreamFactory Silver

DreamFactory 1.9.0 Has Shipped!

Posted by Todd Appleton

Thu, Feb 5, 2015

Hi folks, we've been busy cranking on the DreamFactory 1.9.0 release and after many long nights we're happy to announce....drumroll please....1.9.0 is live! Here's a quick round up of new features in the 1.9.0 release. Head on over to Bitnami to install DreamFactory 1.9.0 on your server of choice or grab it from GitHub.

DreamFactory Authentication SQL

Add a REST API to Your IBM DB2 Database in Four Easy Steps

Posted by Ben Busse

Tue, Jan 27, 2015

Got a DB2 database that needs a REST API? Now you can connect to your IBM DB2 with DreamFactory in just a few minutes. In this short blog post I'll explain how to connect to DB2 and use DreamFactory's auto-generated REST API for DB2.

REST API DreamFactory Enterprise Applications SQL

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

Weekly Digest

Recent Posts