/plushcap/analysis/supabase/supabase-sql-or-nosql-both-with-postgresql

SQL or NoSQL? Why not use both (with PostgreSQL)?

What's this blog post about?

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


By Matt Makai. 2021-2024.