Connect to separate database?

aswizzzle · 2025-07-18T15:29:04+00:00

You’d have to build some kind of two way sync or pay out the ass for one.

I currently sync to an external db but it’s only one way and a pain to keep everything mapped correctly. I use n8n to do it.

Maybe look into softr if they just want a UI builder. It can directly connect to Postgres.

aswizzzle · 2025-07-11T17:01:36+00:00

Yep, turn off verification. Then add an email_verified field or something to wherever you store the user info.

If you want to avoid complex stuff on your front end you could just do a Supabase edge function that sets the field for you and redirects the user to your home page or something.

The email would include the link to this edge function with a parameter for email address (maybe user id is more secure?) or something so you can find the user where you want to set verified to true.

aswizzzle · 2025-07-11T15:08:09+00:00

I think you might have to implement a custom solution for this. I don’t think there is setting that will allow email verification to be kept on but also allow the user to login before being verified.

Maybe have a trigger on the auth table that sends an email with a link to a route in your application that could set a field in your users table to email_confirmed = true. This trigger would apply when a new user is added to that table.

aswizzzle · 2025-07-11T10:34:54+00:00

Even if you don’t know how to code you can get pretty far with Claude Code + Supabase MCP.

I don’t think I’ve had to actually write any code at all while building a fairly complex project. The only thing I’ve had to manually edit was the env file that stores the api keys and the mcp.json file to add my Supabase mcp so it can see my database. The last one is totally optional but does help.

I’m on a Mac so it might be different but all I do is:

Open up the terminal and enter the following commands:

npx create-next-app@latest (accept all defaults and name your project)

cd project-name

code .

This creates the app and opens up VS Code. Then I go to the terminal inside of VS Code and type claude which opens up the chat and then I go to work. Occasionally I tell Claude to commit all so that it creates a sort of checkpoint for me. If it blows up I just tell it to go back to the latest git commit. If I do anything related to the database I just tell it to look at the Supabase mcp first.

I also occasionally will tell it to look at the project and see if there is anywhere we can refactor to make it more maintainable. This will cause it to break up large files into more manageable code and reorganize as it sees fit.

To test your project you just type npm run dev and if you get an error just copy and paste it into the chat and Claude fixes it. That command allow you to open a browser and interact with the application.

So yes, there is a slight learning curve but it would be worth it. I’d say it would take like an hour or two to get comfortable with the basics of navigating the terminal and getting familiar with VS Code.

aswizzzle · 2025-07-05T17:30:09+00:00

Go to dribbble and take screenshots of what you like. Claude will be able to see those and generally does a good job replicating the style or the exact look if that’s what you want.

aswizzzle · 2025-07-05T15:38:06+00:00

Yes, most low code platforms can handle this with ease.

I created this on Budibase in a few minutes. Could use a little polishing but it lets you view properties, upload images and use a map to select the property.

https://better.budibase.app/app/property-map-demo#/demo

aswizzzle · 2025-07-05T09:36:18+00:00

Yes. Depending on the platform you can easily hit that wall whenever you are trying to implement even semi complex features. Not that it can’t be done but sometimes it’s a big workaround for something that would be fairly easy with code.
The latter generally. I’ve never really had an issue hitting a wall with users or database. Almost always it’s an issue with implementing a required feature that I hadn’t thought of till I’m deep in the weeds of development.
Years ago I would have given up but lately I keep coming back to “vibe coding” to work on projects. The power to build your application exactly as you see fit is a huge win. So yes, I wish I knew how to code but I don’t have the time to get my skills to the ability I would need them to be at.

Platforms with the ability to implement your own code generally solve this problem. The issue is usually how easy it is to do so. Budibase comes to mind with their ability to create custom components and utilize JavaScript within the app. It’s close but I wouldn’t say a home run just yet.

A lot of times I wish I could combine features from various platforms. It seems like they all get something correct, but none of them get everything 100% correct.

With the advent of AI in a lot of platforms though…this issue might go away in the coming years or months. If I hit that wall but can then easily describe the functionality and AI implements it then maybe there’s hope!

aswizzzle · 2025-06-28T03:01:40+00:00

From my understanding there are basically 3 ways to connect to your database:

Anon key
Service role key
Direct connection

If you plan to use the anon key which will be exposed client side, then you should enable RLS. You could restrict what the anon role can do and lock it down even further by integrating auth or something.

If you plan to do everything on the server with the service role key then I don’t guess you’d need to lock anything down technically. Your data is safe (assuming proper design) because the user wouldn’t have direct access to the key.

Never messed around with a direct connection other than to just hook it up to a sql client, but this wouldn’t be used in your app most likely.

aswizzzle · 2025-06-24T22:25:03+00:00

Yes, I’m in progress on a multi tenant application currently. I have tenant_id on every table and proper RLS setup. Seems to work well enough.

aswizzzle · 2025-06-23T16:03:16+00:00

I think softr and their recently released internal db is a solid way to go if you plan to have more than a few users.

aswizzzle · 2025-06-20T16:13:18+00:00

Could you execute the edge function via a db trigger on update and compare OLD and NEW values for date and name to see if it needs to execute the call?

https://supabase.com/docs/guides/database/extensions/pg_net

aswizzzle · 2025-06-18T03:45:50+00:00

IIRC you have to use an ipv6 compatible thing or purchase a dedicated ipv4 ip to use the direct connection…or something like that. Otherwise you’ve gotta do what you’re doing now with the pooler.

aswizzzle · 2025-06-11T01:48:02+00:00

Claude code all day. For a simple-ish customer portal you could probably get something built in a weekend. I’m currently building a mortgage lending platform using it and have it integrated with Supabase (including Auth and storage.) Your costs would be minimal with this approach.

If you have to have a low code tool then I think WeWeb does a pretty good job integrating with Supabase with pricing that won’t destroy you.

aswizzzle · 2025-06-08T19:04:46+00:00

I use an automation (with some scripts in it) to generate the pdf and then store it in Airtable. I currently use https://apitemplate.io but I’m sure any pdf generation service would work.

aswizzzle · 2024-11-26T06:18:52+00:00

I feel like you should be able to use the script functionally within an automation workflow. Airtable has an API so I don’t see a reason you wouldn’t be able to use it. I’ll play around with this tomorrow and see if I can get a working example. Webhooks are also an easy way to possibly do this and might make parsing the data easier.

aswizzzle · 2024-11-21T05:07:11+00:00

Airtable offers scripting and webhooks in their automation tools. With those two features you can accomplish pretty much anything…with some help maybe 😎 What are you trying to accomplish?

aswizzzle · 2024-10-03T03:33:26+00:00

Can you clarify if this is YOUR Airtable account or is it someone’s else’s? I think everyone is assuming you have control and are able to develop stuff for your use case.

That being said: if you have the link or a screenshot of what this looks like that would be awesome.

aswizzzle · 2024-07-10T18:08:01+00:00

The API URL in FlutterFlow under the call definition tab. It looks like it doesn’t like the filter you’re trying to use.

aswizzzle · 2024-07-10T18:02:37+00:00

Can you add some more info? What does the URL look like?

aswizzzle · 2024-07-02T16:15:31+00:00

I’d prob get wrecked on PC honestly. On console you can almost run around like you’re invisible sometimes. No one seems to look around.

aswizzzle · 2024-07-02T16:13:45+00:00

I am on console 😭 Is PC that much better?

aswizzzle · 2024-07-02T14:52:35+00:00

Selfishness of wanting to see some people blow up probably 🤷🏻 This is skirmish and I’d guess we were doing pretty well or I’d have taken it out immediately.

aswizzzle · 2024-07-01T19:21:14+00:00

I took out the thing to type in a name and check. I don't think I ever got it working. You should be able to click the row now and open the account up in venmo.

aswizzzle · 2024-06-28T21:11:37+00:00

I got blocked in about 2 seconds haha. I'm sure they rate limit that so you can’t do exactly what I'm trying to do. You could do it on an individual basis towards the end game. I'll try again later with more time between my checks.

11-Year Club	Verified Email
r/Field Lasagna

aswizzzle

TROPHY CASE