Hi everyone,
I’ve built a web app that I’m really excited about, but unfortunately, since I’m not a developer, I initially used MemStorage because I didn’t plan my database needs properly. Now that I’m preparing to deploy and I want to support users, I realize I need to migrate to PostgreSQL for better scalability and performance.
However, I’ve been struggling with the migration process and keep running into issues. I’d greatly appreciate any help or guidance on how to successfully migrate from MemStorage to PostgreSQL. If anyone has experience with this kind of migration or can point me in the right direction, I would be very grateful!
Thanks in advance for your support!
Look for the routes and schema files in your app and work with the assistant to find any other calls for memstorage.
Then work with the agent listing all of these to replace them with PostgreSQL. Be explicit that you want PostgreSQL.
It will help to provide a step by step guide to the Agent. You can use the assistant to help you draft this prompt.
Converting Repls from Memstorage to PostgreSQL has been a challenge for the agent. I’ve gottent to the point where I demand that the Agent avoid Memstorage at all costs to only use PostgreSQL.
One of the reasons for this is I’ve had it completely destroy my backend. Some routes would be App → MemStorage → PostgreSQL, some would be App → PostgreSQL, and others would be stuck at App-> MemStorage. It was costing me a lot to try to find them all and get them cutover.
1 Like
I’ll add that there is extreme value in having memstorage for speed and responsiveness with postgresql behind it for persistence. The challenge with Replit is that its now two layers deep for each route to storage. You need one route to memstorage for the app and another between memstorage and postgresql. This is complex and requires attention to detail to fix. If you app grows to the point that it needs this level of speed, I recommend looking at memstorage but use it only where we need that level of speed and response.
I use redis.com and set it up through them. IDK, it’s the only way I’ve gotten auth to work.