postgres
supabase
postgres | supabase | |
---|---|---|
15 | 770 | |
1,280 | 66,966 | |
2.4% | 3.3% | |
9.5 | 10.0 | |
5 days ago | 13 minutes ago | |
Shell | TypeScript | |
PostgreSQL License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
postgres
-
Supabase – General Availability Week
- Now, the connection between our API servers and the database was slow (a few hundred ms per query), so we moved to self-hosting Postgres which was pretty painful. We tried to use https://github.com/supabase/postgres, but the documentation was very lacking and we had to make a bunch of modifications to get it to work. After we got it working, it was pretty smooth though - pretty easy to implement backups, etc.
- Any comprehensive guide on self hosting ?
-
Vector support in PostgreSQL services to power AI-enabled applications
I think Supabase generally does good work, but I don't think they can be given credit for pgvector, if that's what you're indicating (I might have misread).
As I understand, Andrew Kane is the principal author of pgvector, and has worked on it for almost two years before Supabase added support for it.
See also https://github.com/pgvector/pgvector/issues/54 and https://github.com/supabase/postgres/pull/472.
-
Storing OpenAI embeddings in Postgres with pgvector
we merged the pgvector PR about 2 weeks ago (https://github.com/supabase/postgres/pull/472). If you're missing anything for your CLI don't hesitate to reach out and we'll see if we can integrate it into the product (my email is in my profile)
as an aside, Pinecone looks great
-
Given an ansible playbook, how do I "execute" it on a server?
One of the things they recommend is separating the PostgreSQL DB from the rest of the stack. And they also provide an ansible playbook to set up a postgres DB: https://github.com/supabase/postgres/blob/625899e687047a9da658f3f8cc6dd91ac9769694/ansible/playbook.yml
-
GraphQL is now available on Supabase
> entire solution from docker
We PR'd this into our docker-compose today [0]. We're always a bit slammed during Launch Week, so if you spot any problems let use know and we'll patch it up asap.
The extension is also deployed directly into our PG bundle [1] which is available in docker [2]
> The Gui for adding roles and tying them to postgres access is very slick with hasura. Is this done manually via SQL commands with supabase?
I haven't tried Hasura so I don't know if this is a direct comparison. pg_graphql works with Postgres Row Level Security - we provide a GUI for this in our Dashboard, but they are also just native PG Policies, so you can write them in raw SQL
[0] https://github.com/supabase/supabase/pull/6138/files#diff-41...
[1] https://github.com/supabase/postgres
[2] https://hub.docker.com/r/supabase/postgres
-
PG 14 now available in Supabase
and can also PR if it's something useful for everyone: https://github.com/supabase/postgres
- GitHub - supabase/postgres: Unmodified Postgres with some useful plugins
-
Hacker News top posts: Sep 6, 2021
Show HN: Postgres Docker image with common extensions\ (23 comments)
-
Show HN: Postgres Docker image with common extensions
Hi! I'm one of the contributors to the repo. Just to clarify, our Docker image [0] only contains the latest version of Postgres (13) and the common extensions listed out here [1]. All the other features such as this [2] and this [3] are only available in the AWS EC2 or DO droplet images. We've since updated our README to make that clearer :-)
You can still connect the DB with a PgBouncer image spun up in another container however. Unfortunately, I can't really recommend you which one since there doesn't seem to be an official Docker image for PgBouncer and I myself have never tried any of the existing ones out there. If you're looking to use PostgREST however, they do have an official Docker image that you can use over here [4].
[0]: https://hub.docker.com/r/supabase/postgres
[1]: https://github.com/supabase/postgres#extensions
[2]: https://github.com/supabase/postgres#enhanced-security
[3]: https://github.com/supabase/postgres#additional-goodies
[4]: https://hub.docker.com/r/postgrest/postgrest/
supabase
-
Wasp x Supabase: Smokin’ Hot Full-Stack Combo 🌶️ 🔥
It was a great experience using Supabase’s rock-solid PostgreSQL database for this app. The DX around that product is phenomenal: viewing and managing the DB data was a lifesaver when you don’t want to craft your own admin panel from scratch.
-
How I migrated from Firebase to Supabase
I didn't really give much thought as to which backend I would use. I already had 2 projects in Supabase (BOXCUT & MineWork), but also a few projects in Firebase too. I was more concerned at the time at actually building the product.
-
How to get free Postgres
Sign up for SupaBase: Head over to SupaBase and sign up. Create a new workspace and project with your preferred names.
-
Creating a Pokémon guessing game using Supabase, Drizzle, and Next.js in just 2 hours!
Setting up Supabase Create a new Supabase project, and get the connection string for the database from settings > database.
-
How To Make An Insanely Fast AI App (Supabase, LLAMA 3 and Groq)
Supabase (start for free)
-
Building a self-creating website with Supabase and AI
Built with Supabase, Astro, Unreal Speech, Stable Diffusion, Replicate, Metropolitan Museum of Art
-
How I built a Markdown Rendered Blog using Supabase and Chakra UI
Supabase will be used for storing article data in the database and the cover image of the article in storage. Chakra UI will be used to provide style to the elements. By using both, we can build the blog with ease.
-
I got #1 Product of the Day on Product Hunt without Spending a Dollar
For AutoRepurpose, I opted for Supabase as the backbone of the backend. It has reliably supported Penelope AI, which garnered over 15k users in 2022 without any issues.
-
AI Inference now available in Supabase Edge Functions
Semantic search demo
-
Creating an OG image using React and Netlify Edge Functions
1. Create a new Supabase project: Visit Supabase and create a new project.
What are some alternatives?
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
Appwrite - Your backend, minus the hassle.
faiss - A library for efficient similarity search and clustering of dense vectors.
pocketbase - Open Source realtime backend in 1 file
DBngin - DB Engine
nhost - The Open Source Firebase Alternative with GraphQL.
http-proxy - A full-featured http proxy for node.js
neon - Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
postgres-operator - Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
next-auth - Authentication for the Web.
edgedb - A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.