Systems | Development | Analytics | API | Testing

Databases

A Software Engineer's Tips and Tricks #2: Template Databases in PostgreSQL

Hey there! We're back for our second edition of Tips and Tricks. As we said in our first post on Drizzle ORM, our new Tips and Tricks mini blog series is going to share some helpful insights and cool tech that we've stumbled upon while working on technical stuff. Today, we're going to talk about the template databases of PostgreSQL. Remember, these posts will be super short reads. If you don’t like the topic of one of the posts, no problem! Just skip it and check out the next one.

Resolving Database Conflicts with Centralized APIs in Microservices

Back in the 2000s, code lived in one execution thread. Database queries, user interactions, and data pipelines were all managed by the same processes. The problem? Everything was interconnected and interdependent. Fixing one thing might break another. Releases were all or nothing. We call this monolith hell. Your ticket out? Microservices.

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.