kiwicopple

9 ms·

91.
by kiwicopple 2y ago
> I am not sure if they're literally reading all the HN comments or doing that in some automated i use f5bot[0] and have notifications set up for "supabase". it helps that supabase is a unique word so I don't get many
92.
by kiwicopple 2y ago
(I’m on the Supabase team) Oriole has joined us at supabase now and it’s being worked on full time by Alexander and his team. Here is the patch set: https://www.orioledb.com/docs#patch-set It will be available to try on the
93.
by kiwicopple 2y ago
congrats on shipping michel - it's very cool that you've wrapped this into a PG extension. The breadth-first search looks interesting. Do you have some more docs or a simple example with table data? One request for the "todos
94.
by kiwicopple 2y ago
“it depends”. Some considerations for mssql: - If the foreign server is close (latency) that’s great - if your query is complex then it helps if the postgres planner can “push down” to mssql. That will usually happen if you aren’t doing joi
95.
by kiwicopple 2y ago
in supabase we have a “vault” utility for this (for example: https://fdw.dev/catalog/clickhouse/#connecting-to-clickhouse ). Sorry I can’t make recommendations for other platforms because i don’t want to suggest an
96.
by kiwicopple 2y ago
Another amazing release, congrats to all the contributors. There are simply too many things to call out - just a few highlights: Massive improvements to vacuum operations: "PostgreSQL 17 introduces a new internal memory structure
97.
by kiwicopple 2y ago
You can still use all the Authentication features of supabase Auth if you disable the data APIs (you just don’t need to use RLS for managing Authorization to your data) Supabase is designed to work like LEGO, you add the blocks you want, an
98.
by kiwicopple 2y ago
Yes, we have plenty of customers doing just that. You can connect to the pg instance directly or using the connection pooler. You can also disable the Data API (PostgREST) if you want so that you have less security surface area to manage (e
99.
by kiwicopple 2y ago
You are not dependent if you just use the database. You can just pg_dump and and take your data to any other postgres service
100.
by kiwicopple 2y ago
Nice work! I’m curious why you went with first change wins instead of last write wins?
101.
by kiwicopple 2y ago
(supabase ceo) our postgres offering costs roughly equivalent of RDS so if you use it with Django I don’t think you will come close to 20-40x a VPS, ymmv, depending on your workload We have an Auth service, but since you use Django you woul
102.
by kiwicopple 2y ago
pgroonga is a good Postgres option in these cases https://supabase.com/docs/guides/database/extensions/pgroong...
103.
Show HN: Write Postgres Foreign Data Wrappers in WASM(fdw.dev)
3 points by kiwicopple 2y ago|1 comments
104.
by kiwicopple 2y ago
This is a framework/guide for creating Postgres FDW's in WASM. This makes it easy for anyone to create a Foreign Data Wrapper and share it with the community. We have released 2 examples: one for Snowflake[0] and one for Paddle[1]
105.
by kiwicopple 2y ago
it's also worth noting here that a big benefit of supabase-js is that you can use it from the browser (assuming you have sufficient RLS policies). PostgREST is hosted on the same server as Postgres, so essentially you remove an entire
106.
by kiwicopple 2y ago
great list Jake - we're working on a few of these already (and will have an update on the LSP next month)
107.
Postgres Foreign Data Wrappers with WASM(supabase.com)
7 points by kiwicopple 2y ago|1 comments
108.
by kiwicopple 2y ago
Hey HN, Supabase CEO here. This release makes it easy for anyone to create a Foreign Data Wrapper and share it with the community. Usually FDWs need to be "pre-installed" on Postgres which makes it harder for platforms like Supaba
109.
by kiwicopple 2y ago
sure - I'll jump in next week (after we've wrapped up Launch Week). What is your discord?
110.
by kiwicopple 2y ago
This one isn’t available in that format, but it looks like this open source tool could help: https://github.com/KarnerTh/mermerd
111.
by kiwicopple 2y ago
we're hosted on AWS (and so is Vercel) - it could have been the region that your database was hosted?
112.
by kiwicopple 2y ago
I'm also surprised. Here is a 3rd-party benchmark published last month using various ORMs: https://www.prisma.io/blog/performance-benchmarks-comparing-...
113.
by kiwicopple 2y ago
Here is a real-world comparison for 3 startups on Supabase, showing how our Auth pricing compares to Firebase: https://x.com/kiwicopple/status/1656746963277340672
114.
by kiwicopple 2y ago
1. You can see the relevant code block here[0]. To summarise, instead of storing the embeddings "next to" the data that you provide, we create a table that can be referenced. This is because often we need to send the LLM some data
115.
by kiwicopple 2y ago
> take an existing database schema, developed either in the Supabase migrations ... and draw the diagram? It might not be so obvious, but this diagram tool is already built into the Supabase Dashboard (under "Database") I can
116.
by kiwicopple 2y ago
if your session is completely broken you might need to clear your localstorage (in the browser devtools) I'll flag this with the team but we can't actually access your "db id oy6g6g6o5qbt78fo" as it's run directly i
117.
by kiwicopple 2y ago
we have something like that from an earlier launch: https://wasm.supabase.com/ Be aware that the WASM file is 30Mb, but i think it fits what you're describing. details here: https://supabase.com/blog&#x
118.
by kiwicopple 2y ago
There are a lot of reasons that you might want Postgres in the browser, but one of my favorite possibilities is to use it as a local data store (similar to mobx or redux) The Electric team have built this extension which will fit that use-c
119.
by kiwicopple 2y ago
at this stage there is not, but you can just write SQL and the LLM is smart enough to run it directly on the database. I can see some situations you might want direct access to postgres, so we'll jot that done as something to look at t
120.
by kiwicopple 2y ago
we're working on this right now - I don't know if we'll get it out for today, but it will certainly be available this week

More ›