Supabase is the open-source Firebase alternative that features an impressive collection of tools like PostgreSQL, user authentication, serverless edge functions, and more. 

#programming #sql #100secondsofcode 

🔥 NEW! The Full Supabase Course 

https://fireship.io/courses/supabase/

💬 Chat with Me on Discord

https://discord.gg/fireship

🔗 Resources

- Supabase Docs https://supabase.com/docs
- Zack's Supabase Basics Video https://youtu.be/tUm1AlaMcMQ
- 5 Backends Compared https://youtu.be/SXmYUalHyYk

🔥 Get More Content - Upgrade to PRO

Upgrade at https://fireship.io/pro
Use code YT25 for 25% off PRO access 

🎨 My Editor Settings

- Atom One Dark 
- vscode-icons
- Fira Code Font

🔖 Topics Covered

- What is Supabase?
- Supbase vs Firebase
- Getting started with Supabase
- Supabase Basics tutorial
2024-02-04T05:16:31.051Z
nova-2
2-general-nova
2024-01-09.29447
30089e05-99d1-4376-b32e-c263170674af
2c04edaf-9bb4-43cb-a69b-e158f2c4acf8
6f435aefcb506f165341fa684774c0114f05dbdf29306f13e730fb84867c6737
67875a7f-c9c4-48a0-aa55-5bdb8a91c34a
deprecated
Supabase, a complete back end for web and mobile applications based entirely on free open source software.
The biggest challenge when building an app is not writing code, but rather architecting a complete system that works at scale.
Products like Firebase and Amplify have addressed this barrier, but there's one big problem.
They lock you into proprietary technology on a specific cloud platform.
Supabase was created in 2019 specifically as an open source is Firebase alternative.
At a high level, it provides 2 things.
On the back end, we have infrastructure, like a database, file storage, and edge functions is that run-in the cloud.
On the front end, we have client side SDKs that can easily connect this infrastructure to your favorite front end JavaScript framework, React Native, Flutter, and many other platforms.
As a developer, you could manage your Postgres database with an easy to understand UI, which automatically generates REST and Graph QL APIs, to use in your code.
The database integrates directly with user authentication, making it almost trivial to implement row level security.
And like Firebase, it can listen to data changes in real time while scaling to virtually any workload.
To get started, you can self host with Docker or sign up for a fully managed account that starts with a free tier.
On the dashboard, you can create tables in your Postgres database with the click of a button.
Insert columns to build out your schema, then add new rows to populate it with data.
By default, every project has an authentication schema to manage users within the application.
This opens the door to row level security, where you write policies to control who has access to your data.
In addition, the database supports triggers to react to changes in your data and Postgres functions to run toward procedures directly on the database server.
It's a nice interface, but it also automatically generates custom API documentation for for you.
From here, we can copy queries tailored to our database and use them in a JavaScript project, install the Supabase SDK with NPM, then connect to your project and sign a user and with a single line of code.
And now, we can listen to any changes to the authentication state in real time with on auth state change.
When it comes to the database, we don't is to write raw SQL code.
Instead, we can paste in that JavaScript code from the API docs or use the REST and GraphQL APIs is directly and that's all it takes to build an authenticated full stack application.
However, you may still want to run your own custom server side code, in which case, serverless edge functions can be developed with Deno and TypeScript, then easily distributed around the globe.
This has been Supabase in 100 seconds.
If you wanna build something awesome on this platform, we just released a brand new Supabase course on Fireship IO.
It's free to get started, so check it out to learn more.
Thanks for watching and I will see you in the Next one.

Speaker 0: Supabase, a complete back end for web and mobile applications based entirely on free open source software. The biggest challenge when building an app is not writing code, but rather architecting a complete system that works at scale. Products like Firebase and Amplify have addressed this barrier, but there's one big problem. They lock you into proprietary technology on a specific cloud platform. Supabase was created in 2019 specifically as an open source is Firebase alternative.

At a high level, it provides 2 things. On the back end, we have infrastructure, like a database, file storage, and edge functions is that run-in the cloud. On the front end, we have client side SDKs that can easily connect this infrastructure to your favorite front end JavaScript framework, React Native, Flutter, and many other platforms. As a developer, you could manage your Postgres database with an easy to understand UI, which automatically generates REST and Graph QL APIs, to use in your code. The database integrates directly with user authentication, making it almost trivial to implement row level security.

And like Firebase, it can listen to data changes in real time while scaling to virtually any workload. To get started, you can self host with Docker or sign up for a fully managed account that starts with a free tier. On the dashboard, you can create tables in your Postgres database with the click of a button. Insert columns to build out your schema, then add new rows to populate it with data. By default, every project has an authentication schema to manage users within the application.

This opens the door to row level security, where you write policies to control who has access to your data. In addition, the database supports triggers to react to changes in your data and Postgres functions to run toward procedures directly on the database server. It's a nice interface, but it also automatically generates custom API documentation for for you. From here, we can copy queries tailored to our database and use them in a JavaScript project, install the Supabase SDK with NPM, then connect to your project and sign a user and with a single line of code. And now, we can listen to any changes to the authentication state in real time with on auth state change.

When it comes to the database, we don't is to write raw SQL code. Instead, we can paste in that JavaScript code from the API docs or use the REST and GraphQL APIs is directly and that's all it takes to build an authenticated full stack application. However, you may still want to run your own custom server side code, in which case, serverless edge functions can be developed with Deno and TypeScript, then easily distributed around the globe. This has been Supabase in 100 seconds. If you wanna build something awesome on this platform, we just released a brand new Supabase course on Fireship IO.

It's free to get started, so check it out to learn more. Thanks for watching and I will see you in the Next one.
Supabase, a complete back end for web and mobile applications based entirely on free open source software. The biggest challenge when building an app is not writing code, but rather architecting a complete system that works at scale. Products like Firebase and Amplify have addressed this barrier, but there's one big problem. They lock you into proprietary technology on a specific cloud platform. Supabase was created in 2019 specifically as an open source is Firebase alternative. At a high level, it provides 2 things. On the back end, we have infrastructure, like a database, file storage, and edge functions is that run-in the cloud.
software
software development
On the front end, we have client side SDKs that can easily connect this infrastructure to your favorite front end JavaScript framework, React Native, Flutter, and many other platforms. As a developer, you could manage your Postgres database with an easy to understand UI, which automatically generates REST and Graph QL APIs, to use in your code. The database integrates directly with user authentication, making it almost trivial to implement row level security. And like Firebase, it can listen to data changes in real time while scaling to virtually any workload. To get started, you can self host with Docker or sign up for a fully managed account that starts with a free tier. On the dashboard, you can create tables in your Postgres database with the click of a button. Insert columns to build out your schema, then add new rows to populate it with data. By default, every project has an authentication schema to manage users within the application. This opens the door to row level security, where you write policies to control who has access to your data. In addition, the database supports triggers to react to changes in your data and Postgres functions to run toward procedures directly on the database server. It's a nice interface, but it also automatically generates custom API documentation for for you. From here, we can copy queries tailored to our database and use them in a JavaScript project, install the Supabase SDK with NPM, then connect to your project and sign a user and with a single line of code. And now, we can listen to any changes to the authentication state in real time with on auth state change. When it comes to the database, we don't is to write raw SQL code. Instead, we can paste in that JavaScript code from the API docs or use the REST and GraphQL APIs is directly and that's all it takes to build an authenticated full stack application.
databases
data management
programming
networking
However, you may still want to run your own custom server side code, in which case, serverless edge functions can be developed with Deno and TypeScript, then easily distributed around the globe. This has been Supabase in 100 seconds. If you wanna build something awesome on this platform, we just released a brand new Supabase course on Fireship IO.
It's free to get started, so check it out to learn more. Thanks for watching and I will see you in the Next one.
Supabase, a complete back end for web and mobile applications based entirely on free open source software. The biggest challenge when building an app is not writing code, but rather architecting a complete system that works at scale. Products like Firebase and Amplify have addressed this barrier, but there's one big problem. They lock you into proprietary technology on a specific cloud platform. Supabase was created in 2019 specifically as an open source is Firebase alternative. At a high level, it provides 2 things. On the back end, we have infrastructure, like a database, file storage, and edge functions is that run-in the cloud. On the front end, we have client side SDKs that can easily connect this infrastructure to your favorite front end JavaScript framework, React Native, Flutter, and many other platforms. As a developer, you could manage your Postgres database with an easy to understand UI, which automatically generates REST and Graph QL APIs, to use in your code. The database integrates directly with user authentication, making it almost trivial to implement row level security. And like Firebase, it can listen to data changes in real time while scaling to virtually any workload. To get started, you can self host with Docker or sign up for a fully managed account that starts with a free tier. On the dashboard, you can create tables in your Postgres database with the click of a button. Insert columns to build out your schema, then add new rows to populate it with data. By default, every project has an authentication schema to manage users within the application. This opens the door to row level security, where you write policies to control who has access to your data. In addition, the database supports triggers to react to changes in your data and Postgres functions to run toward procedures directly on the database server. It's a nice interface, but it also automatically generates custom API documentation for for you. From here, we can copy queries tailored to our database and use them in a JavaScript project, install the Supabase SDK with NPM, then connect to your project and sign a user and with a single line of code. And now, we can listen to any changes to the authentication state in real time with on auth state change. When it comes to the database, we don't is to write raw SQL code. Instead, we can paste in that JavaScript code from the API docs or use the REST and GraphQL APIs is directly and that's all it takes to build an authenticated full stack application. However, you may still want to run your own custom server side code, in which case, serverless edge functions can be developed with Deno and TypeScript, then easily distributed around the globe. This has been Supabase in 100 seconds. If you wanna build something awesome on this platform, we just released a brand new Supabase course on Fireship IO. It's free to get started, so check it out to learn more. Thanks for watching and I will see you in the Next one.
Supabase,
supabase
a
a
complete
complete
back
back
end
end
for
for
web
web
and
and
mobile
mobile
applications
applications
based
based
entirely
entirely
on
on
free
free
open
open
source
source
software.
software
The
the
biggest
biggest
challenge
challenge
when
when
building
building
an
an
app
app
is
is
not
not
writing
writing
code,
code
but
but
rather
rather
architecting
architecting
a
a
complete
complete
system
system
that
that
works
works
at
at
scale.
scale
Products
products
like
like
Firebase
firebase
and
and
Amplify
amplify
have
have
addressed
addressed
this
this
barrier,
barrier
but
but
there's
there's
one
one
big
big
problem.
problem
They
they
lock
lock
you
you
into
into
proprietary
proprietary
technology
technology
on
on
a
a
specific
specific
cloud
cloud
platform.
platform
Supabase
supabase
was
was
created
created
in
in
2019
2019
specifically
specifically
as
as
an
an
open
open
source
source
is
is
Firebase
firebase
alternative.
alternative
At
at
a
a
high
high
level,
level
it
it
provides
provides
2
2
things.
things
On
on
the
the
back
back
end,
end
we
we
have
have
infrastructure,
infrastructure
like
like
a
a
database,
database
file
file
storage,
storage
and
and
edge
edge
functions
functions
is
is
that
that
run-in
run-in
the
the
cloud.
cloud
On
on
the
the
front
front
end,
end
we
we
have
have
client
client
side
side
SDKs
sdks
that
that
can
can
easily
easily
connect
connect
this
this
infrastructure
infrastructure
to
to
your
your
favorite
favorite
front
front
end
end
JavaScript
javascript
framework,
framework
React
react
Native,
native
Flutter,
flutter
and
and
many
many
other
other
platforms.
platforms
As
as
a
a
developer,
developer
you
you
could
could
manage
manage
your
your
Postgres
postgres
database
database
with
with
an
an
easy
easy
to
to
understand
understand
UI,
ui
which
which
automatically
automatically
generates
generates
REST
rest
and
and
Graph
graph
QL
ql
APIs,
apis
to
to
use
use
in
in
your
your
code.
code
The
the
database
database
integrates
integrates
directly
directly
with
with
user
user
authentication,
authentication
making
making
it
it
almost
almost
trivial
trivial
to
to
implement
implement
row
row
level
level
security.
security
And
and
like
like
Firebase,
firebase
it
it
can
can
listen
listen
to
to
data
data
changes
changes
in
in
real
real
time
time
while
while
scaling
scaling
to
to
virtually
virtually
any
any
workload.
workload
To
to
get
get
started,
started
you
you
can
can
self
self
host
host
with
with
Docker
docker
or
or
sign
sign
up
up
for
for
a
a
fully
fully
managed
managed
account
account
that
that
starts
starts
with
with
a
a
free
free
tier.
tier
On
on
the
the
dashboard,
dashboard
you
you
can
can
create
create
tables
tables
in
in
your
your
Postgres
postgres
database
database
with
with
the
the
click
click
of
of
a
a
button.
button
Insert
insert
columns
columns
to
to
build
build
out
out
your
your
schema,
schema
then
then
add
add
new
new
rows
rows
to
to
populate
populate
it
it
with
with
data.
data
By
by
default,
default
every
every
project
project
has
has
an
an
authentication
authentication
schema
schema
to
to
manage
manage
users
users
within
within
the
the
application.
application
This
this
opens
opens
the
the
door
door
to
to
row
row
level
level
security,
security
where
where
you
you
write
write
policies
policies
to
to
control
control
who
who
has
has
access
access
to
to
your
your
data.
data
In
in
addition,
addition
the
the
database
database
supports
supports
triggers
triggers
to
to
react
react
to
to
changes
changes
in
in
your
your
data
data
and
and
Postgres
postgres
functions
functions
to
to
run
run
toward
toward
procedures
procedures
directly
directly
on
on
the
the
database
database
server.
server
It's
it's
a
a
nice
nice
interface,
interface
but
but
it
it
also
also
automatically
automatically
generates
generates
custom
custom
API
api
documentation
documentation
for
for
for
for
you.
you
From
from
here,
here
we
we
can
can
copy
copy
queries
queries
tailored
tailored
to
to
our
our
database
database
and
and
use
use
them
them
in
in
a
a
JavaScript
javascript
project,
project
install
install
the
the
Supabase
supabase
SDK
sdk
with
with
NPM,
npm
then
then
connect
connect
to
to
your
your
project
project
and
and
sign
sign
a
a
user
user
and
and
with
with
a
a
single
single
line
line
of
of
code.
code
And
and
now,
now
we
we
can
can
listen
listen
to
to
any
any
changes
changes
to
to
the
the
authentication
authentication
state
state
in
in
real
real
time
time
with
with
on
on
auth
auth
state
state
change.
change
When
when
it
it
comes
comes
to
to
the
the
database,
database
we
we
don't
don't
is
is
to
to
write
write
raw
raw
SQL
sql
code.
code
Instead,
instead
we
we
can
can
paste
paste
in
in
that
that
JavaScript
javascript
code
code
from
from
the
the
API
api
docs
docs
or
or
use
use
the
the
REST
rest
and
and
GraphQL
graphql
APIs
apis
is
is
directly
directly
and
and
that's
that's
all
all
it
it
takes
takes
to
to
build
build
an
an
authenticated
authenticated
full
full
stack
stack
application.
application
However,
however
you
you
may
may
still
still
want
want
to
to
run
run
your
your
own
own
custom
custom
server
server
side
side
code,
code
in
in
which
which
case,
case
serverless
serverless
edge
edge
functions
functions
can
can
be
be
developed
developed
with
with
Deno
deno
and
and
TypeScript,
typescript
then
then
easily
easily
distributed
distributed
around
around
the
the
globe.
globe
This
this
has
has
been
been
Supabase
supabase
in
in
100
100
seconds.
seconds
If
if
you
you
wanna
wanna
build
build
something
something
awesome
awesome
on
on
this
this
platform,
platform
we
we
just
just
released
released
a
a
brand
brand
new
new
Supabase
supabase
course
course
on
on
Fireship
fireship
IO.
io
It's
it's
free
free
to
to
get
get
started,
started
so
so
check
check
it
it
out
out
to
to
learn
learn
more.
more
Thanks
thanks
for
for
watching
watching
and
and
I
i
will
will
see
see
you
you
in
in
the
the
Next
next
one.
one
success
The speaker explains that building an app is key to solving the barrier of using open source software. Supabase is created in 2019 as an alternative to years of proprietary technology and is designed to allow developers to manage their Postgres database and create tables on the front end. The database is integrated directly with user authentication and can easily be embedded in a JavaScript project. The speaker also mentions a new course on Fireship IO for developers to learn more.
Supabase in 100 Seconds
Supabase, a complete back end for web and mobile applications based entirely on free open source software. The biggest challenge when building an app is not writing code, but rather architecting a complete system that works at scale. Products like Firebase and Amplify have addressed this barrier, but there's one big problem. They lock you into proprietary technology on a specific cloud platform. Supabase was created in 2019 specifically as an open source is Firebase alternative. At a high level, it provides 2 things. On the back end, we have infrastructure, like a database, file storage, and edge functions is that run-in the cloud. On the front end, we have client side SDKs that can easily connect this infrastructure to your favorite front end JavaScript framework, React Native, Flutter, and many other platforms. As a developer, you could manage your Postgres database with an easy to understand UI, which automatically generates REST and Graph QL APIs, to use in your code. The database integrates directly with user authentication, making it almost trivial to implement row level security. And like Firebase, it can listen to data changes in real time while scaling to virtually any workload. To get started, you can self host with Docker or sign up for a fully managed account that starts with a free tier. On the dashboard, you can create tables in your Postgres database with the click of a button. Insert columns to build out your schema, then add new rows to populate it with data. By default, every project has an authentication schema to manage users within the application. This opens the door to row level security, where you write policies to control who has access to your data. In addition, the database supports triggers to react to changes in your data and Postgres functions to run toward procedures directly on the database server. It's a nice interface, but it also automatically generates custom API documentation for for you. From here, we can copy queries tailored to our database and use them in a JavaScript project, install the Supabase SDK with NPM, then connect to your project and sign a user and with a single line of code. And now, we can listen to any changes to the authentication state in real time with on auth state change. When it comes to the database, we don't is to write raw SQL code. Instead, we can paste in that JavaScript code from the API docs or use the REST and GraphQL APIs is directly and that's all it takes to build an authenticated full stack application. However, you may still want to run your own custom server side code, in which case, serverless edge functions can be developed with Deno and TypeScript, then easily distributed around the globe. This has been Supabase in 100 seconds. If you wanna build something awesome on this platform, we just released a brand new Supabase course on Fireship IO. It's free to get started, so check it out to learn more. Thanks for watching and I will see you in the Next one.
The speaker explains that building an app is key to solving the barrier of using open source software. Supabase is created in 2019 as an alternative to years of proprietary technology and is designed to allow developers to manage their Postgres database and create tables on the front end. The database is integrated directly with user authentication and can easily be embedded in a JavaScript project. The speaker also mentions a new course on Fireship IO for developers to learn more.