Systems | Development | Analytics | API | Testing

Databases

dreamfactory

How To Create A PostgreSQL Stored Procedure

Jan 9, 2024 By Kevin McGahey In DreamFactory
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.
Read Post
chaossearch

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

Dec 28, 2023 By Thomas Hazel In ChaosSearch
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.
Read Post
Featured Post
WSO2

DBA, The Key to Improving Security and CX Without Compromise

Dec 27, 2023 By Seshika Fernando, Vice President of Banking and Financial Services In WSO2
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.
Read Post
hevo

Connecting DynamoDB to S3 Using AWS Glue: 2 Easy Steps

Dec 26, 2023 By Hevo In Hevo
Are you trying to derive deeper insights from your Amazon DynamoDB by moving the data into a larger Database like Amazon S3? Well, you have landed on the right article. Now, it has become easier to replicate data from DynamoDB to S3 using AWS Glue. Table of Contents Connecting DynamoDB with S3 allows you to export NoSQL data for analysis, archival, and more.
Read Post
integrate

How to Set Up Amazon Aurora PostgreSQL

Dec 20, 2023 By Donal Tobin In Integrate
Amazon Aurora PostgreSQL represents a significant leap forward in database technology, skillfully combining the innovation of Amazon’s cloud capabilities with the reliable framework of PostgreSQL. It's not merely a database; it's a solution designed for the cloud, promising high performance, availability, and compatibility with PostgreSQL. This guide aims to walk you through the setup process comprehensively.
Read Post
Koyeb

Which Cloud Database Platform to Choose for Your Applications

Dec 13, 2023 By Alisdair Broshar In Koyeb

If your application needs persistent data, you are going to need a database. Easier said than done because managing a database can be a challenge. Not only do you need to set up, maintain, scale, and patch databases, but also you need to create strong backup policies, ensure sharding and replications. Long story short, managing a database is time-consuming and requires a dedicated and skilled team, which is why people opt for managed databases, sometimes referred to as DBaaS or Database as a Service.

Read Post
dreamfactory

How to Secure Your PostgreSQL Database | 5 Actionable Tips

Dec 11, 2023 By Spencer Nguyen In DreamFactory
If your business deals in large volumes of data, chances are that you are at least somewhat familiar with PostgreSQL, or you may use it actively in your data management strategy. PostgreSQL is a powerful relational database system, and it is completely open source. As of 2019, PostgreSQL was the second-most-common database solution for professionals. Thirty-four percent of more than 75,000 Respondents reported that it was their first choice.
Read Post
dreamfactory

Understanding the Connection Between Databases and APIs

Dec 5, 2023 By Spencer Nguyen In DreamFactory
Spencer Nguyen - December 5, 2023 Worldwide government IT spending is forecast to total $589.8 billion in 2023, an increase of 7.6% from 2022, according to Gartner, Inc. As technology integration becomes more prevalent in society, the government, organizations, and businesses must begin the process of digital transformation. When it comes to successful digital transformations, APIs and databases are at the core.
Read Post
keploy

Mongodb In Mock Mode: Acting The Server Part

Dec 4, 2023 By Ritik Jain In Keploy
In the contemporary software development landscape, unit tests have become paramount for ensuring software quality. A prevalent practice during these tests involves mocking outgoing calls to decouple the code under test from external dependencies. Imagine, for a moment, a scenario where instead of writing mocks with pre-defined behaviours, you duplicate the behaviour of a real-world server.
Read Post
Koyeb

Serverless Postgres Public Preview

Nov 30, 2023 By Édouard Bonlieu In Koyeb

We're excited to announce the Koyeb Serverless Postgres public preview - a fully managed, fault-tolerant, and scalable serverless Postgres Database Service. What do all modern applications have in common? They all have APIs, workers, and databases. Deploying APIs and workers with Koyeb has long been possible. Starting today, you can spin up databases too! Using Koyeb Serverless Postgres, you can easily start a resilient Database Service alongside your apps in a few seconds.

Read Post
Subscribe to Databases

Copyright © 2024 OpsMatters™. All rights reserved.