SQL or NoSQL? Why not use both (with PostgreSQL)?
The text discusses the decision between using a standard SQL database or a newer NoSQL document-based database for storing project data. Both options have trade-offs, with NoSQL being easier to get started with but more difficult when it comes to accessing and analyzing data later on. The author presents an example of tracking daily food intake, water consumption, exercise, and weight, and how this data can be stored in both SQL and NoSQL databases. They also demonstrate how to use PostgreSQL's JSON functions and operators to combine the ease-of-use of NoSQL with the power of SQL for better data analysis and presentation.
Company
Supabase
Date published
Nov. 24, 2022
Author(s)
Mark Burggraf
Word count
2431
Hacker News points
12
Language
English