This is great news, and I agree with everyone in the thread - Supabase is a great product.

Does this mean that Supabase (via S3 protocol) supports file download streaming using an API now?

As far as I know, it was not achievable before and the only solution was to create a signed URL and stream using HTTP.

Yes, absolutely! You can download files as streams and make use of Range requests too.

The good news is that the Standard API is also supporting stream!

on the other hand, if you have postgres already, it may be easier to add pgvector than to add another dependency to your stack (especially if you are using something like supabase)

another benefit is that you can easily filter your embeddings by other field, so everything is kept in one place and could help with perfomance

it's a good place to start in those cases and if it is successful and you need extreme performance you can always move to other specialized tools like qdrant, pinecone or weaviate which were purpose-built for vectors

Performance-wise, both are nearly identical - fast.

Both frameworks support route groups, middleware, context, and mounting apps from other frameworks.

Both are WinterCG compliant - deployment to platforms other than your own server or Docker, such as Cloudflare or Vercel Edge, should not be an issue.

Hono appears to be very focused on serverless and edge runtimes like Fastly Compute, Lambda@Edge, Supabase Functions, etc.

Both offer their own RPC implementations:

- Hono: RPC in Hono: https://hono.dev/concepts/stacks#rpc

- Elysia has Eden—its own end-to-end type safety RPC: https://elysiajs.com/eden/overview.html

So, it's a matter of preference, I would say.

I'm personally using ElysiaJS in production and have zero complaints.

That's very helpful. I'm also using Elysia in several small projects. Considering that the official stable 1.0 release was in March, it might be mature enough for production use.

Nice, thank you!