5 tips for choosing the right database Otesanya David March 26, 2022

5 tips for choosing the right database

5 tips for choosing the right database


The database that you choose today will impact your application and development efforts far into the future. Yet a developer’s choice of a database tends to be an emotional decision, and developers often choose a database based solely on what their applications need at the outset.

If a database seems exciting, a developer may just go with their gut. And they may forego doing analysis of whether or not the database will work for their application today and in the future.

A developer may also be overwhelmed by having to choose between the many available databases. This can create paralysis followed by the selection of a database that addresses what an application starts out as. But you don’t always know what all the use cases of an application will be. Applications tend to start simple and become more complicated over time.

So, what typically happens is that a developer starts with PostgreSQL. The developer then adds MongoDB because they want to work with semi-structured data and need a flexible schema. The developer then adds Elasticsearch to do a log search or faceted search. And then they find that it isn’t fast enough, so they bring in Redis as a cache on top of that. And when they want to do analytics, they spin up a data warehouse such as Snowflake.

It all gets confusing quickly. The resulting database sprawl leaves developers to worry about moving data between databases and using costly extract, transform, and load (ETL) processes.

But it doesn’t have to be that way. Developers can get everything they need by taking a different approach. Here is how to select a database that will meet all of your needs.

Copyright © 2022 IDG Communications, Inc.


Source link

Write a comment