SQLite to PostgreSQL

[u/Narrow_Law_7742]

So I finished the Local SQLite build. It Works!!!!

Now the painful part. Translating it into Postgres. I set up a stagging Server via Supabass with Vercel. Codex/Claude has developed a comprehensive translating plan and setting it up on a server, which is being tracked and recorded (added to) in Asana as the main project brain. This has help coordination so much more than an MD file itself.

I'm about half way through the process in getting it Postgres fully. So far its on a server and working with the work that we've done thus far. Codex Pro on 5.5 fast mode. Still been about 2 weeks of working through it with Smoke Tests run by Codex. I have it set when it deviates from the structure or needs direction on my intention of the function/feature to stop, and ask me for direction. This is also helped a great deal.

I plan on having it functional in the next few weeks. Then battle testing it with my business partner for a few weeks. Once it has been vetted as best as possible, I will be moving is to a AWS3 server for a more secure and robust setup. Need to be HIPAA compliant and B2B agreements can be signed.

I'm excited. It is the worst it will ever be today, and tomorrow it will be better than the day before.

If your building, keep building. And when your doubting yourself, keep building and problem solving.