Movatterモバイル変換


[0]ホーム

URL:


Skip to content
DEV Community
Log in Create account

DEV Community

Neha Sharma
Neha Sharma

Posted on • Edited on

     

How to pick your database

One of the most asked question for system design is - "Which storage mechanism/database you will pick for the problem?"

If you are going to answer that I know X database. Hence, I would like to go with X, it would be a WRONG answer.

Neither you should be talking in terms of any database brand/name. Infact the correct way is to talk about the type of the database. Eg: Relational, document, graph etc.

Now, the question comes how one can pick the database. So, here is a short summary which can help you to take decision:

SchemaSchemaless or strict Schema
TypeWhat type of problem are we solving and what type of database is it?
TransactionIs transaction integrity required or not?
PerformanceHow is the performance of the DB for Read and Write operations
ScalabilityIs the database scalable and what would be the cost of it? Eg: Mongo, MySQL or Postgres supports scalability by DB partitioning and sharding
OpensourceIs the database open-source vendor locked? MySQL is OS, and Aurora, or DynamoDB are vendor locked (AWS)
USPWhat is the unique feature of the database? Eg: Document-based DBs are easier to scale due to sharding, and Aurora is highly performant.
How you talk to DBWhich programming language a database is using. Eg: Relation MySQL uses SQL.

Top comments(2)

Subscribe
pic
Create template

Templates let you quickly answer FAQs or store snippets for re-use.

Dismiss
CollapseExpand
 
margo_hdb profile image
Margo McCabe
On the innovative team @ HarperDB. Podcast host. Tech blogger. DevRel. Women in tech.
  • Location
    Denver, CO
  • Joined

Aways an interesting topic! This article might also be useful in expanding upon the points you made:Database Architectures & Use Cases

CollapseExpand
 
hellonehha profile image
Neha Sharma
  • Location
    London
  • Pronouns
    she/her
  • Work
    Solutions Architect
  • Joined

Thank you Margo for your kind words. Loved the blog you have shared (I just give it a quick read) and saved it for for later read.

Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment'spermalink.

For further actions, you may consider blocking this person and/orreporting abuse

  • Location
    London
  • Pronouns
    she/her
  • Work
    Solutions Architect
  • Joined

More fromNeha Sharma

DEV Community

We're a place where coders share, stay up-to-date and grow their careers.

Log in Create account

[8]ページ先頭

©2009-2025 Movatter.jp