cli
sql-examples
Our great sponsors
cli | sql-examples | |
---|---|---|
15 | 10 | |
810 | 341 | |
9.8% | 1.8% | |
9.8 | 1.1 | |
1 day ago | 10 months ago | |
Go | Vue | |
MIT License | MIT License |
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.
cli
-
Deno.land is down, which means Supabase functions are down locally
@doganugurlu Looks like Deno team implemented a fix https://denostatus.com/cllm0jzq219036bjottk03k2ac Are you still experiencing the issue?
We used to cache the modules locally, I will need to check if we made any configuration change. Can you kindly open an issue for Supabase CLI - https://github.com/supabase/cli/issues
-
Supabase Local Dev: migrations, branching, and observability
> Oh, I had no idea that the functions routes were "wild card"! I don't think that's mentioned anywhere in the documentation, btw.
Good point! will update the docs.
> Sorry, I actually mean "import-maps": https://github.com/supabase/cli/issues/1338
I'll take a look at this issue. We've improved import map resolution in the last couple of CLI releases. But it looks like there are more edge cases.
Thank you for the helpful feedback.
> Using supabase migration up would mean moving the latest migration out of the migrations folder, running supabase db reset, moving the file back in and then calling supabase migration up.
We can definitely do a better job here. I'm adding support for db reset --version flag [0]. This should allow you run migration up without moving files around directories.
> I wasn't really sure what the actual outcome would look like If I have something like this in a migration script
Agree that we can do a better job with the documentation for squash command. I will add more examples.
The current implementation does a schema only dump from the local database, created by running local migration files. Any insert statements will be excluded from the dump. I believe this is not the correct behaviour so I've filed a bug [1] to fix in the next stable release.
> We do have plans to improve the current database trigger behavior. Will share more updates on this in the coming months.
Excited to hear more! Being able to trigger functions from DB & cron triggers without having to hardcode a secret (which causes them to end up in migrations files) will be a huge improvement.
> Can you explain what do you mean by template URLs?
Oh, I had no idea that the functions routes were "wild card"! I don't think that's mentioned anywhere in the documentation, btw.
> Source maps, is it broken during local dev or when you deploy the function?
Sorry, I actually mean "import-maps": https://github.com/supabase/cli/issues/1338
"Source maps" (does deno actually use source maps?) ARE broken as well. EG: The line numbers in runtime don't line up with the function code in the IDE or even that is in the docker volume.
We’ve moved the Supabase CLI to a fortnightly stable-release cycle. Every 2 weeks, we will update the latest tag on npm, the supabase/tap for homebrew, and the supabase scoop bucket. You can find the binary downloads in our GitHub latest release.
-
Any comprehensive guide on self hosting ?
I think we've been working on that recently here: https://github.com/supabase/cli/pull/907
-
SPARTAN. Type-safe Angular full-stack development powered by Analog.
For more info see this issue on GitHub.
-
The Case for better Self-Hosted Supabase Support
Are there plans to support connections to self hosted remotes (to deploy to self-hosted instances, for example) with the cli? https://github.com/supabase/cli/issues/753
-
Can't link fresh project - problem with underlying postgrest version not supporting 15.
The errors you cite come from the https://github.com/supabase/cli not from postgREST(it does support v15).
-
Generating typescript interfaces for postgres composite types and enums?
Maybe add your voice to https://github.com/supabase/cli/issues/531
sql-examples
-
Supabase Beta April 2023
database.dev fills the same role for PostgreSQL as npm for JavaScript or pip for Python, it enables publishing libraries and applications for repeatable deployment. Our goal is to create an open ecosystem for packaging and discovering SQL.
-
SPARTAN. Type-safe Angular full-stack development powered by Analog.
Supabase just wrapped up their Launch Week 7 with a ton of incredible features. This includes an AI assistant that was added to their premium platform. It is aware of your database design and can help you when creating more complex SQL queries. I'm even more thrilled by their most recent releases of outstanding open source projects, such as the PostgreSQL package manager database.dev. dbdev serves the same purpose for PostgreSQL that npm does for JavaScript. It gives your PostgresSQL database incredibly easy access to packages that give your DB superpowers like full-text search or one-time-only-read data access à la Snapchat. The best thing is that dbdev can load any PostgreSQL instance that has the required fundamental extensions, independent of the Supabase platform. Again, the code is open source. I can't wait to see where this project goes in the future, and I have no doubt that we will soon be able to utilize a lot more fantastic libraries. Like Brandon Roberts puts it:
- The Database Package Manager for PostgreSQL Trusted Language Extensions
-
Supabase/Postgres SQL Cheatsheet - Curated List of SQL
If you - find it useful, please spare a 🌟 at the Github Repo If you - found any issue/bug, create issues is much appreciated. If you - wanted to contribute the SQL scripts, PR is even more welcomed!
What are some alternatives?
jellyfin-vue - A modern web client for Jellyfin based on Vue
objectbox-dart - Flutter database for super-fast Dart object persistence
dashibase-insert - Notion-like form builder powered by Vue, Tailwind and Supabase
ng-signal-forms
ionic-vue-crud-supabaseio-series - showing how to use supabase.io with vuejs and ionic framework
supabase-vue-user-management - supabase.io quickstart example in vuejs
Postwoman - 👽 Open source API development ecosystem - https://hoppscotch.io
supabase-on-aws - Self-hosted Supabase on AWS
supavisor - A cloud-native, multi-tenant Postgres connection pooler.
supabase - The open source Firebase alternative.
vuesion - Vuesion is a boilerplate that helps product teams build faster than ever with fewer headaches and modern best practices across engineering & design.
oak - A middleware framework for handling HTTP with Deno, Node, Bun and Cloudflare Workers 🐿️ 🦕