Database

Using Supra to manage your data.

Every Supra project comes with a full Postgres database, a free and open source database which is considered one of the world's most stable and advanced databases.

Postgres or PostgreSQL?#

PostgreSQL the database was derived from the POSTGRES Project, a package written at the University of California at Berkeley in 1986. This package included a query language called "PostQUEL".

In 1994, Postgres95 was built on top of POSTGRES code, adding an SQL language interpreter as a replacement for PostQUEL. Eventually, Postgres95 was renamed to PostgreSQL to reflect the SQL query capability.

After this, many people referred to it as Postgres since it's less prone to confusion. Supra is all about simplicity, so we also refer to it as Postgres.

Supra Studio#

Postgres is known to be one of the most extensible databases available, so you can use it to build almost any application. The Supra platform makes this easier with a simple-to-use dashboard called "Supra Studio".

Table View#

You don't have to be a database expert to start using Supra. Our table view makes Postgres as easy to use as a spreadsheet.

Relationships#

Dig into the relationships within your data.

Clone tables#

You can duplicate your tables, just like you would inside a spreadsheet.

The SQL Editor#

Supra comes with a SQL Editor. You can also save your favorite queries to run later!

Additional features#

• Supra extends Postgres with realtime functionality using our Realtime Server.
• Every project is a full Postgres database, with postgres level access.
• Supra manages your database backups.
• Import data directly from a CSV or excel spreadsheet.

Extensions#

To expand the functionality of your Postgres database, you can use extensions. You can enable Postgres extensions with the click of a button within the Supra dashboard.

Learn more about all the extensions provided on Supra.

Next steps#

• Read more about Postgres
• Sign in: supra.com/dashboard