Systems | Development | Analytics | API | Testing

Databases

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.

Best Practices For Transferring Healthcare Data To Your Database

In the constantly changing healthcare environment, smooth data exchange is not just a luxury; it is a vital necessity. Integrating patient records from Electronic Health Records (EHRs), clinical data repositories, and other healthcare systems unlocks valuable insights, empowering providers to deliver personalized care, fuel groundbreaking research, and streamline operational efficiency.

Top PostgreSQL Database Free Tiers in 2024

Looking for a managed PostgreSQL database with a free tier? We've got you covered. In this article, we'll explore the top PostgreSQL databases with free tiers to use for your applications in 2024. These free-tier options are perfect for side projects, MVPs, and learning how to use cloud databases. All these database solutions integrate with Koyeb, enabling you to seamlessly connect databases hosted by third-party providers to your applications running on the Koyeb platform.

Top 8 MariaDB ETL Tools

MariaDB is an offshoot of the MySQL relational database management platform, designed to give users greater big data management capabilities and scalability in a fully open-source format. For everything from optimized data warehouse formatting to unified data management, a dedicated MariaDB ETL tool is the best way to move forward with analyzing and managing your data in this environment and beyond.

Snowflake Database Engineering: What Will You Create, Redefine, Become?

Dear engineers... everyone thinks they know who you are. Builders, problem solvers, creators, innovators, designers. But you can’t be labeled. You know the world runs on what you do. And you know when you’re ready for what’s next. Get rid of the bottlenecks and bureaucracy. Database engineering is where Snowflake began. Collaborate with a team, learn from the best, and join a culture defined by engineers to solve the toughest problems. Build a product no one else is.

How To Create A PostgreSQL Stored Procedure

Introduced in PostgreSQL 11, these procedures are a game-changer for database efficiency, allowing for pre-compiled and reusable SQL code. In this article, we’ll how to create PostgreSQL stored procedures, a key tool for scaling up and streamlining database operations. Whether you’re a novice or an expert in PostgreSQL, this guide offers valuable insights into maximizing the effectiveness of stored procedures in your database management.

A Deep Dive into Multi-Model Databases: Hype vs. Reality

In 2009, as the world became increasingly data-driven, organizations began to accumulate vast amounts of data — a period that would later be characterized as the Big Data revolution. While most organizations were used to handling well-structured data in relational databases, this new data was appearing more and more frequently in semi-structured and unstructured data formats.
Featured Post

DBA, The Key to Improving Security and CX Without Compromise

Today's consumers demand Amazon-like digital banking experiences. However, striking the right balance between customer experience and security remains an arduous challenge for banks. A consequence of user-driven authentication mechanisms is that a better customer experience usually comes at the expense of robust security measures. Contributing to the challenge is the fact that the majority of banks today rely on user-driven customer identity and access management (CIAM) systems. This requires customers to provide information each time verification is needed.