Databases

Good Database Migration Practices for Your Ruby on Rails App using Strong Migrations

One great feature that comes with modern web frameworks is the ability to manage database schema migrations. However, schema migrations are not 100% safe and remain a recurring cause of issues within projects I have encountered over the last 15 years. This article will review the issues surrounding poorly managed schema migrations and then look into Strong Migrations, a gem that can help you avoid most problems. Finally, we will discuss a few good practices around database management. Let's get started!

Oracle vs MySQL: An In-Depth Comparison of Database Titans

Both MySQL and Oracle provide the same architecture and use the relational model, and both offer many standard features such as indexing, vertical scalability, and support for popular operating systems. However, there are some critical differences between the two tools. Deciding between them can shape an enterprise’s data management and directly impact its success.

How to dockerize a Django, Preact, and PostgreSQL Application

During my recent deep dive into new technologies, I found the classic issues of integrating numerous tech tools effectively. I've written about my experiences to save you the trouble I had. One essential component I've looked into is using Docker to implement containerization. While the initial setup takes a little longer, it significantly simplifies and optimizes your technological stack.

Creating a Microsoft SQL Server API in Less Than 5 minutes with DreamFactory

Do you have a ton of data sources and do not know how to expose them? Do you know you need a Microsoft SQL Server API but don’t know where to begin to build it? Look no further, DreamFactory can take any database and generate a fully documented and secure REST API faster than making a sandwich. All you need is your database credentials and DreamFactory will handle the rest, instantly generating Swagger API documentation and securing your API by way of API keys.

Complete Guide to Database Schema Design

Experts predict that the global enterprise data management market will grow at a compound annual growth rate of 12.1% until 2030. Your organization’s database management system (DBMS) stores all the enterprise data you need for software applications, systems, and IT environments, helping you make smarter data-driven business decisions. Here are the key things to know about database schema design.

High Availability (Multi-AZ) for Cloudera Operational Database

In the previous blog post we covered the high availability feature of Cloudera Operational Database (COD) in Amazon AWS. Cloudera recently released a new version of COD, which adds HA support to Microsoft Azure-based databases in the Cloud. In this post, we’ll perform a similar test to validate that the feature works as expected in Azure, too.

Database Table Source in Astera Data Stack

In this video, we will see how a Database Table Source object works in Astera. The Database Table Source object is used to retrieve data from a database table. It offers incremental reads via change data capture, supports multi-way partitioning for enhanced performance, and allows customization with WHERE clauses and sorting options.