Systems | Development | Analytics | API | Testing

Databases

How to Use MongoDB and Mongoose with Node.js

Mongoose is Object Data Modeling (ODM) for MongoDB. It represents application data as JavaScript objects, mapped to the underlying MongoDB database. You can use Mongoose to model data, enforce schemas, validate models, and manipulate data in a database without familiarity with the underlying database semantics. In this tutorial, you will build an Express server with Mongoose that serves a RESTful API. Let's get started!

From zero to hero: using SQL databases in Node.js made easy

Despite the growing popularity of NoSQL databases such as MongoDB and Firebase among JavaScript developers, SQL databases remain a reliable and widely used tool for storing data. This tutorial will show you the basics of SQL databases and how to use them with Node.js.

Azure SQL vs MySQL: What are the Differences?

Here we’ll review Azure SQL vs MySQL, and what their differences are. Databases have been around for ages. From ancient paper based records to modern computerized systems, they essentially serve one purpose, which is to enable data storage in a way that is structured, permanent and easily retrievable or referenced, while maintaining its integrity. Here’s the key things to know about picking Azure SQL vs MySQL: Table of Contents.

Creating a Couchbase API in Minutes with DreamFactory

Handwriting code for database APIs can be a time consuming and expensive process that often exposes organizations to a variety of risks relating to quality, consistency, and developer effort. DreamFactory specializes in REST API generation for a range of databases that gives you the ability to generate a secure, fully documented API in minutes.

Creating a Cassandra DB API in Minutes with DreamFactory

Handwriting code for database APIs can be a time consuming and expensive process that often exposes organizations to a variety of risks relating to quality, consistency, and developer effort. DreamFactory specializes in REST API generation for a range of databases that gives you the ability to generate a secure, fully documented API in minutes.

The Benefits of Oracle DBMS for Your Organization

Oracle Database—or Oracle DBMS—consolidates, stores, and retrieves large amounts of big data. With a market value of $253,206, Oracle Corporation is one of the largest technology companies in the world. But why use Oracle DBMS in your organization? In this post, learn the benefits of Oracle DBMS and how DreamFactory makes it easier to use this relational database management system. Here are the key things to know about the benefits of Oracle DBMS: Table of Contents.

What is Database Stored Procedure Modernization?

Your organization likely relies on stored procedures based on business logic that has worked well in the past. More recent evolutions in areas like application development, automation, open-source application code, workloads, and web services could mean that you need to reassess your stored procedures to find opportunities for improvement.

Building realtime experiences with Amazon Aurora

Aurora is a managed database service from Amazon compatible with MySQL and PostgreSQL. It allows for the use of existing MySQL code, tools, and applications and can offer increased performance for certain workloads compared to MySQL and PostgreSQL. Being an AWS product, it benefits from the range of tools and services available on AWS, with simple integrations for analytics and processing. Having all of these tools available makes building larger projects easier and quicker.

Moving Data From MySQL to Redshift: 4 Ways to Replicate Your Data

MySQL is the most popular open-source and free database in the world because it is powerful, flexible, and extremely reliable. But when it comes to data analytics, many companies turn to Amazon Redshift to complement MySQL. There are several ways to replicate your MySQL data to Redshift. But first, let’s dig a little deeper into why you should replicate your MySQL database to Redshift.