search

niklitt / GrocerySavior

Collaborative side project with used to scrape local grocers for coupons and best deals for specific and general foods. This will allow users to easily find the best deals so they know where to go to save the most money
0 stars 0 forks source link

Choose Databases #2

Open niklitt opened 1 year ago

niklitt commented 1 year ago

Decide to use SQL or NoSQL and which type --

Requirements:

  1. Free
  2. Vert and Horizonal Scalability
  3. Simple to use and implement
  4. Wide user base
  5. Permissions management
  6. Ease of query (Kotlin, Py, Swift?)

Desires:

  1. Cloud capability

Options SQL:

  1. SQLite - good to begin
  2. Oracle - Prob not free.??
  3. MySQL
  4. PostgreSQL

Options NoSQL:

  1. MongoDB - not sure if it's free
  2. Redis - maybe possible to use

Caching:

  1. Redis
  2. Memcached
dennism0027 commented 1 year ago

https://aws.amazon.com/compare/the-difference-between-mysql-vs-postgresql/

dennism0027 commented 1 year ago

NoSQL wins