Looking for suggestions for db to use. | Discord Gophers | Page 1

trail plinth Sep 22, 2023, 11:21 PM

#

200m records is not actually that big

#

doesn't really matter tbh

#

i would recommend a SQL over NoSQL database in general though, unless you meet the requirements and use cases of a NoSQL database

sullen lichen Sep 23, 2023, 8:56 AM

#

Something like MySQL or Postgres probably

steel sand Sep 23, 2023, 10:14 AM

#

I was working on a project that rely on postgres for over 500m. It was smooth but didn't had a chance to compare with other dbs

civic herald Sep 23, 2023, 10:15 AM

#

If it's 200m records it really doens't matter. Postgres imo or Mongo if you qualify for the advantages of no sql

lapis echo Sep 23, 2023, 8:36 PM

#

It's probably more about the rate of requests, kinds of requests, kind of data

cosmic loom Sep 23, 2023, 10:37 PM

#

I prefer mangodb because it’s web scale. https://github.com/dcramer/mangodb

GitHub

GitHub - dcramer/mangodb: A database that operates at CLOUD SCALE

A database that operates at CLOUD SCALE. Contribute to dcramer/mangodb development by creating an account on GitHub.

atomic grove Sep 24, 2023, 12:36 AM

#

I've mostly used Mongo with my containerized clients running in a k8s cluster. That may be an "old habit" of mine, but it scales well and, as others have said, 200m records isn't something to be concerned with.

trail plinth Sep 24, 2023, 12:41 AM

#

20k writes per second is actually reasonably high

#

what kind of data are we talking about here

#Looking for suggestions for db to use.