burggraf

6 ms·

1.
by burggraf 2y ago
> Curious to see how many of those million databases are from free users. A LOT! Probably most. But Supabase is committed to the free tier and it's not going anywhere. It's crucial to helping demonstrate all the features and t
2.
by burggraf 3y ago
Supabase developer here. It shouldn't (and doesn't) take a week to migrate 40GB, I'm sure most of that time was strategizing, analyzing, and testing things. Supabase is pure Postgres running on AWS, so migrations are pretty
3.
by burggraf 3y ago
https://supabase.com/docs/guides/platform/going-into-prod
4.
by burggraf 3y ago
Just as a note, Supabase received SOC2 Type 2 compliance last week (we've had Type 1 for a long time already) and now we're working on HIPAA.
5.
by burggraf 3y ago
Supabase developer here. We're big fans of Pocketbase here and love the stuff they're doing. I did some work with it early on and it's great, but since I'm not a Go developer, I found the customization options pretty l
6.
by burggraf 3y ago
Supabase developer here: keep in mind that, while PostgreSQL is unapologetically SQL-based, it's support for JSON and JSONB fields give it a lot of the powers of NoSQL. These days the lines are becoming more blurred. Here's an ar
7.
by burggraf 4y ago
Note this was written before edge functions were released, so it may make more sense to make these calls from edge functions, depending on what you're trying to do.
8.
by burggraf 4y ago
Here's an older repo[0] I put together to show how to do some custom auth stuff. Take a look and see if you can use some ideas from here. 0. https://github.com/burggraf/supabase-roll-your-own-auth
9.
by burggraf 4y ago
SQL or NoSQL? These days it's a religious argument (tabs vs spaces, anyone?) I've been using SQL since the late 80's, and spent several years working with NoSQL offerings. There were some really great things about using a
10.
SQL or NoSQL? Why not use both (with PostgreSQL)?(supabase.com)
12 points by burggraf 4y ago|1 comments
11.
by burggraf 4y ago
It’s a busybox shell that does quite a bit. Plus you have pg_dump which you can use to shuttle data from an external database to the local database or vice-versa.
12.
by burggraf 4y ago
This exists, but with limitations: [0][1] [0] https://medium.com/wasmer/announcing-the-first-postgres-exte... [1] https://github.com/wasmerio/wasmer-postgres
13.
by burggraf 4y ago
Yes, we can include postgis. I'm currently investigating how to include other PostgreSQL extensions as well. A fair number of standard extensions are already included, but there are more we need for a full Supabase implementation.
14.
by burggraf 4y ago
Oh, so it's not related to PostgreSQL. I'm super interested in new and different uses for WASM. This could open some new doors.
15.
by burggraf 4y ago
Why Postgres? (There's already a WASM version of SQLite [0], btw, and it's very cool.) We did this with Postgres for a number of reasons: 1. It's a slightly difficult task, and in doing this we hope to spur others to think
16.
by burggraf 4y ago
So I've been using this for a couple weeks now on my mobile phone. There's really no reason to do this, other than I'm sitting in a car waiting for my wife to come out of the grocery store and I just feel like writing some s
17.
by burggraf 4y ago
Wow, this is awesome! So as I understand it, this uses Postgres and JSON fields to emulate the features of MongoDB, sort of as an abstraction?
18.
by burggraf 4y ago
I'm curious -- what's the intended use case for this? This is something we could try to add if gives some cool new functionality.
19.
by burggraf 4y ago
I love how you guys are already pushing us to think about performance issues on this project. Hacker news really pushes technology to the next level!
20.
by burggraf 4y ago
Yes, you probably could do that. It's something I've considered. Early on before I got the networking working through the proxy I found a way to use arp to connect multiple browser tab versions of this in a pseudo-private-networ
21.
by burggraf 4y ago
You can email me at mark @ supabase dot io. (Yeah, I know there are probably robots that can parse that as valid email address, but I'm old-school :))
22.
by burggraf 4y ago
I'm not familiar with WASI but I'll take a look. We're using Buildroot now and it's nice and small, but we could make it smaller by optimizing the kernel. Now, if I only know how to optimize the kernel without breaking
23.
by burggraf 4y ago
Would love to chat! Love to get your ideas on this.
24.
by burggraf 4y ago
This is cool! It's running debian and posgres 11. It's quite a bit larger (that's why we went with Buildroot, and frankly, we could do a lot better at trimming things down even more). But it's definitely a great imple
25.
by burggraf 4y ago
You're absolutely right, you can use a local pg. This just makes it easier for me, as it's sort of a "sandbox" environment and I can easily take snapshots to do A/B testing or roll things back. I can also send a s
26.
by burggraf 4y ago
Supabase developer here. Yes we'd love to collaborate on a native WASM version. I tried this first before starting on this project and I didn't get very far. I'll have to go back to my tests on that, but it seemed like WAS
27.
by burggraf 4y ago
Supabase developer here. I've tried compiling directly to WASM, but it did not go well. As I recall, there were features used by PostgreSQL that WASM didn't support yet. This is definitely something we'll revisit though, es
28.
by burggraf 4y ago
Interestingly we can do this, sorta, but in Chrome only. Using arp you can open a network between multiple tabs of the same Chrome instance, putting each browser vm on a different private ip. I only see this useful, though, for testing cl
29.
by burggraf 4y ago
Supabase developer here. At this point, the proxy is necessary because all the major browsers block direct TCP/IP traffic. They allow websocket connections so that's how we're getting around it. There have been proposals to
30.
by burggraf 4y ago
Also, in case you're curious, PostgreSQL logical replication to the browser wasm instance DOES work. I've done it. :)

More ›