Users find current database solutions (like Supabase) can be complex or costly for personal projects. They suggest integrating or providing easier support for more lightweight and cost-effective alternatives such as Pocketbase or SQLite to simplify database management for AI-generated apps.
Yeah, I can't stress enough the whole database piece you mentioned. Making sure that is set up front would solve a huge headache in the build. That said, it'll come up again because at some point you'll want to add a feature and for whatever reason, databases are the Achilles heel for AI Coding. Also, as you mentioned, there's some great things about using supabase but there are also some important limitations if one doesn't want to pay for supabase (maybe it's a personal project) or deal with the RLS rabbithole that happens on occasion. In a lot of cases, using something like pocketbase is a much better choice.. heck, even using it with sqlite if you just need a very basic data store for site specific data. I actually built a pretty robust site that ran off sqlite (i did have to use drizzle to enable migrations between my dev and production site though). One other thing to throw out there that I find helps a lot is taking your PRD that you make, dumping it into another AI, and having that AI review it for you and do a few back and forths between the two AI's. A lot of times I'll do that not just with documents but even code, because it'll catch things that your main AI doesn't catch because it gets stuck in it's own feedback loop.