Systems | Development | Analytics | API | Testing

Databases

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.

How to Set Up Amazon Aurora PostgreSQL

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.

Which Cloud Database Platform to Choose for Your Applications

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.

How to Secure Your PostgreSQL Database | 5 Actionable Tips

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.

Understanding the Connection Between Databases and APIs

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.

Mongodb In Mock Mode: Acting The Server Part

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.