kiwicopple

8 ms·

61.
by kiwicopple 2y ago
yeah, migrations are generated from the Declarative files. For example, the steps are for adding a new column: 1/ Add a new column to the declarative file 2/ Generate a new migration: `supabase db diff -f my_new_migration` 3/
62.
by kiwicopple 2y ago
> there is no chance I wouldn't inspect and possibly modify the generated "diff" migration > Of course, you're generally supposed to do that with these tools this seems to be the crux of the comments - we'
63.
by kiwicopple 2y ago
> doing this but better I'm curious what makes it better than the approach in the blog? If it's this: > also maintains a schema.sql file that can be loaded as a one-off That's exactly what the declarative files provid
64.
by kiwicopple 2y ago
It is raw sql. The update here is more of a "workflow" change. In the past we only offered tools to create a sql migration to make a change to your database. Now you can write the state of your database into files, then the migrat
65.
by kiwicopple 2y ago
> db engineers approve the generated migration script yeah - this is definitely the intended flow here. We won't be recommending anyone blindly applying generated migrations. As you mention, it is expected that you generate & re
66.
by kiwicopple 2y ago
yes, you can edit the migrations. The steps are for adding a new column, for example: 1/ Add a new column to the declarative file 2/ Generate a new migration: `supabase db diff -f my_new_migration` 3/ Review/edit the gen
67.
by kiwicopple 2y ago
Combining this with the Postgres Language Server that was released this week, you can now execute statements directly within your IDE: https://x.com/psteinroe/status/1907803477939527728
68.
Declarative Schemas for simpler database management(supabase.com)
81 points by kiwicopple 2y ago|57 comments
69.
by kiwicopple 2y ago
[supabase ceo] Despite the title "UI library", this is more like a "component registry" for developers to bootstrap their applications and it will work for everything from Web & Mobile, to database scaffolding. Perha
70.
by kiwicopple 2y ago
For those who don’t read the blog post, I thought this was pretty cool: > The idea to use tree-sitter in addition to libpg_query came from feedback[0] on our previous HN post, so thank you for that https://news.ycombinator.c
71.
by kiwicopple 2y ago
> Supabase comes really close, but has been much more difficult in actual use supabase team here - can you share more about the challenges? We'd love your feedback so that we can fix any difficulties for the future
72.
by kiwicopple 2y ago
> I would just like to enable hCaptcha when registering new users, but there's no way to configure this with Supabase. this is possible, the docs are here: https://supabase.com/docs/guides/auth/auth-ca
73.
by kiwicopple 2y ago
I’ll see if I can get around to adding the SQL this week
74.
by kiwicopple 2y ago
My original goal in this article was to figure out if pgrouting would be a good tool to build a memory-layer (for AI/agents) but the article got a bit long. Early results are promising - I’ll follow up with another article soon there a
75.
by kiwicopple 2y ago
My original goal in this article was to figure out if pgrouting would be a good tool to build a memory-layer (for AI/agents) but the article got a bit long. Early results are promising - I’ll follow up with another article soon
76.
Postgres as a Graph Database: (Ab)Using PgRouting(supabase.com)
1 points by kiwicopple 2y ago|1 comments
77.
by kiwicopple 2y ago
This is a pretty clever use-case for the expanded datum. Any idea of the performance of this? I can see this would be useful in multi-tenant applications
78.
Calendars in Postgres Using Foreign Data Wrappers(supabase.com)
1 points by kiwicopple 2y ago|0 comments
79.
Running Durable Workflows in Postgres Using DBOS(supabase.com)
185 points by kiwicopple 2y ago|67 comments
80.
by kiwicopple 2y ago
Hey there, supabase ceo here. I did a cmd+f for "HIPAA" and didn't find it anywhere in your description. I don't mind whether you use supabase or not, but please make sure that you take care of patient data. Everything y
81.
by kiwicopple 2y ago
> stick a datastore behind an API saving users from needing to use SQL and offering them a higher level API instead supabase team here. Yes, we offer an auto-generated API (using PostgREST). But users can also connect directly to their P
82.
by kiwicopple 2y ago
as a supabase team member, I must say that I also found it flattering. nice work OP - i like this version of tech where we all get along. the project looks great, good luck!
83.
by kiwicopple 2y ago
Hey HN, supabase ceo here. This is a Postgres-native Queue. It's built with the PGMQ extension[0] which the Tembo team have generously licensed their extension with the OSI-compatible PostgreSQL license. PGMQ has API parity with AWS SQ
84.
by kiwicopple 2y ago
you can also find some code for "pglite in the browser" here: https://github.com/supabase-community/database-build
85.
by kiwicopple 2y ago
congrats on open sourcing i didn't try it locally yet but it looks like the cloud version can create SQLite databases inside the browser? Assuming the open source version does too, can you also "connect" to those databases so
86.
by kiwicopple 2y ago
thanks for using supabase - feel free to reach out if you have any feedback/issues
87.
by kiwicopple 2y ago
> I would have loved that big corps would have taken this approach, as it opens the doors to others to add features for different use cases EDB and Cybertech definitely made a great start with Zheap[0] although the initiative stalled f
88.
TigerBeetle Test Simulator [video](youtube.com)
5 points by kiwicopple 2y ago|1 comments
89.
by kiwicopple 2y ago
The test simulator/game starts at ~17:50 For those jumping to the comments wondering if it's worth watching: TigerBeetle[0] is a database for managing financial transactions. They extend the testing practices of FoundationDB (now
90.
by kiwicopple 2y ago
>very new and unproven, written in a new and unproven programming language while i'd generally agree with this, in the case of TigerBeetle i think it's safe to trust their tech based on their test-suite/practices - one of

More ›