Supabase·3yWhat's new in Postgres 15?
The Postgres community released version 15 (stable) in October 2022. The permission model is more secure permission is revoked from all users except the database owner. It makes permission assigning more tunable ( details) Sorting rows of data is a frequent operation inside the Postgres code.
Supabase·4yImplementing "seen by" functionality with Postgres
Use HyperLogLog to build a simple database for a social media site. Use hstore to create a quick & dirty prototype with integer IDs. The easiest way to do this is to maintain a counter on every post in the posts table. Scaling up is the new (and old) scaling out.
Supabase·3yNew Supabase Docs, built with Next.js
New Supabase Docs, built with Next.js, are a new version of Supabase's documentation tool. For a developer tool, documentation is more than a resource - it’s part of the product. For the past two years at Supabase, this part of our product hasn't been great.
Supabase·4ySupabase Vault
Supabase Vault is a Postgres extension for managing secrets and encryption inside your database. For self-hosting, pgsodium supports a variety of ways to place the root key into Postgres. To see the decrypted data, there is a special view created called vault. The actual raw key is not available to you in SQL, it is managed entirely outside of the SQL language in the Postgres server. If you take a backup or pause your project, that data remains encrypted.
Supabase·4ySupabase Realtime, with Multiplayer Features
Today is Supabase Realtime Day, where we announce and demo the next version of Realtime. The next and third major version introduces multi-tenancy to listen to many databases. This new version introduces a distributed cluster of nodes, which introduces better resource utilization, fault-tolerance, and lower latencies.
Supabase·4yPostgres Full Text Search vs the rest
Postgres has built-in Full Text Search which we can use instead of cobbling together our own with like. Postgres can do some basic searching using select and comparison tools like like. The LIKE operator as used in the query above will match only the term "Avengers%". For our experiments we'll use SQLite FTS5 and TypeSense TypeSense.
Supabase·4yGraphQL is now available in Supabase
GraphQL support is now in general availability on the Supabase platform via our open source PostgreSQL extension, `pg_graphql (beta)`.pg_ graphql enables you to query existing PostgreSQL databases using GraphQL. GraphQL queries are always transpiled into exactly one SQL query.
Supabase·4yEdge Functions are now available in Supabase
Edge Functions are executed on the secure-by-default Deno runtime, and deployed around the world in seconds using Deno's hosted Deno Deploy offering. As a user of Supabase Edge Functions, you don't need to know or worry about any of that; we handle all the gnarly details.
Supabase·4yFetching and caching Supabase data in Next.js 13 Server Components
The biggest announcement from Next.js Conf 2022 was the release of next.js 13, which introduces a collection of improvements, most exciting of which is Server Components. The combination of Server Components and Suspense allow for a more streamlined, reimagined way to fetch and cache data.