Systems | Development | Analytics | API | Testing

Databases

How to Perform Database Analysis with AI

This blog explores how DreamFactory leverages its robust features to perform database analysis with AI, ensuring secure and efficient data operations. We will discuss the platform’s ability to generate dynamic APIs, provide real-time data insights, and maintain stringent security measures to protect data integrity.

Cloudera Named a Visionary in the Gartner MQ for Cloud DBMS

We’re excited to share that Gartner has recognized Cloudera as a Visionary among all vendors evaluated in the 2023 Gartner® Magic Quadrant™ for Cloud Database Management Systems. This recognition underscores Cloudera’s commitment to continuous customer innovation and validates our ability to foresee future data and AI trends, and our strategy in shaping the future of data management.

Working with DynamoDB in Laravel

When building your Laravel applications, you may sometimes need to use a NoSQL database to store and retrieve data. One popular choice is Amazon DynamoDB, a fully managed, serverless, and highly scalable NoSQL database service provided by Amazon Web Services (AWS). In this article, we'll take a brief look at DynamoDB. We'll then delve into how to use DynamoDB as a cache store in Laravel, and how to store Laravel models in DynamoDB using the baopham/laravel-dynamodb package.

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.