examples VS unlock

Is anyone aware of a way to make a direct connection to Postgres with transaction support on Vercel Edge functions? The 'pg' package doesn't work on edge for me. The obvious answer would be @vercel/postgres but I find their lack of documentation rough and for whatever reason I can't get it to connect on my local computer using the Supabase-provided local database connection string. This is apparently a known issue (https://github.com/vercel/storage/issues/123, https://github.com/vercel/examples/issues/701) where in order to make this (or neon's package) work you need a WebSocket proxy? Is a direct Postgres connection from edge just impossible right now? Or do others have it working somehow?

I have cloned this repo: https://github.com/vercel/examples/tree/main/python/nextjs-flask. I am using the repo to make an api call from the front end to the back end. when running fetch("/api") I get an error with status 500, why is that?

Demo: Alt Text Generator GitHub: Alt Text Generator Repository

I copied the Template that they provide for the testing, you can get the template source on GitHub. I modified its page.tsx file just to set and get a value from the database.

Take a look at this example: https://github.com/vercel/examples/tree/main/solutions/subdomain-auth

So AFAIK now with Vercel Postgres is possible to have connection pooling using prisma out of the box, this means that no more bottlenecks with lots of clients connected to the web app right? Source: https://github.com/vercel/examples/blob/main/storage/postgres-prisma/prisma/schema.prisma

I have a server component that reads a database table in this new way (Vercel Next JS Postgres Example). I also have a client component that updates that calls a fetch to update the same table. How can I ensure that the data in my server component doesn't grow stale?

Additionally, Redis can be used in combination with Vercel Edge cache using: https://github.com/vercel/examples/tree/main/edge-api-routes/cache-control

Hostname rewrites example

Unlock is a great decentralized tool that doesn't require members to be familiar with web3 to get started.

This is exactly how something like Unlock Protocol works.

https://unlock-protocol.com/ nft membership

I'll name you several.

Copied from another reply I made, here's some projects to check out:

- Lens Protocol [https://lens.xyz/ (one example implementation: https://lenster.xyz/)] is an early social network built on top of Polygon.

- Farcaster [https://farcaster.xyz/] is another one, that takes a more hybrid approach of using Ethereum for trustless identity, but stores social stuff in a "sufficiently decentralized" way.

- ENS [https://ens.domains/] is a universal username system.

- Unlock Protocol [https://unlock-protocol.com/] uses NFTs for tradeable subscriptions, event tickets, etc.

- Radicle [https://radicle.xyz/] is a decentralized Github basically, that (optionally) uses Ethereum to store the Git HEAD of a "project" essentially.

- Arweave [https://www.arweave.org/] stores files permanently using a cool "endowment" mechanism. Currently, the network has secured its storage for like 1000 years in theory.

If you haven't seen it, you were not interested in looking and I doubt that any "evangelist" is going to change your mind.

Anyway, if you are honestly open to change your mind, go take a look at ENS domains [0] and unlock protocol [1]. Both of these are applications that use NFTs "properly", and allow us to do things that are currently possible only with a central authority.

[0]: https://ens.domains

[1]: https://unlock-protocol.com

If you want to go with the crypto route, that's the main goal of Unlock Protocol. It's basically one of the first use cases (beyond ENS domains) where NFTs actually make sense.

Look at Unlock Protocol (https://unlock-protocol.com/) and Lit (https://litprotocol.com/) for token gated content

All their code is public, https://github.com/unlock-protocol/unlock, you just need to follow the MIT license https://github.com/unlock-protocol/unlock/blob/master/LICENSE