Demystifying the inner workings of Supabase with Postgres
Postgres is, and always has been, one of the go-to databases. It has proven to be a reliable and fast partner for projects of any size. Hence, it’s no surprise that Supabase is not only using one but in fact is a Postgres database with a specific setup and specific extensions, enhanced with additional services.
Everything related to Supabase (excluding files) is stored within that exact Postgres database. That’s why we will now jump into a mix of theoretical and practical thoughts about what differentiates Supabase, at its core, from just being a regular database.
One very interesting fact is that the database within Supabase can be controlled by you and is extensible. Often, when you work with any kind of platform that provides you with a database, your access will be limited in regard to safeguarding you from making fatal changes. Supabase, however, gives you full access to its underlying Postgres database...
