I’ve completed the cloud migration! Now the front-end and the APIs are on Vercel and the database is on Turso, resulting in lowest load times and less latency. The hardest part was migrating the data from the original server to Turso, but I’ve solved that with the mysqldump command, wich created a file with ‘INSERT INTO’ commands for each row of data in the tables.
I’ve finally completed the last part of the migration: the database migration!
Now the entire FreeIdeas project is in the cloud! I’ve moved all the data from my database server (a small Raspberry Pi 5 on my desk) to Turso (integrated into Vercel). I’ve also reworked some small parts of the code that depended on the old server system, to make them compatible with the new database. Now, thanks to the migration, we have a very low latency and faster loading and upload speed.
I’ve also fixed some small general bugs and improved the application overall.
Now I’m going to do some testing and fix any remaining bugs.
Log in to leave a comment
After the project get rejected another time, I’ve fixed a bug with the color theme (now it’s loaded before the render of the page), I’ve added a red border to the required fields if you try to publish or edit an idea without filling them. I’ve fixed a lot of other minor bugs.
Log in to leave a comment
After the last ship get rejected, I’ve fixed the last little bugs (the dark theme in the feedback page, the feedback form on submit now show an alert with “Feedback sent successfully!” and I’ve added some info about the Reserved Area in the FAQ).
Log in to leave a comment
This ship is an update of the project.
FreeIdeas is a web application where anyone can post their ideas on any type of project and find inspiration for their next one.
The last thing I did was migrate the framework (from JS+PHP to Next.js+React).
It was really difficult, especially since I learned to use Next and React with it, but I’m really happy of how it works.
I hope you can post your projects on the site and have a good user experience.
Fixed session management: instead of saving all account data in a session with Redis, it only saves the account ID and username, so when the getSessionData API is called, it fetch the account data (and notifications) from the DB.
Fixed the bug with the home page link (it now prefetches for faster navigation through the pages).
Faster index loading by removing server-side rendering of the latest ideas (it’s now client-side).
Updated the server and put the last changes online!
Log in to leave a comment
Finally the back-end migration is finished.
I’ve fixed a lot of bugs, like read the data sended by the form from the api, or the session management.
I’ve tested all the features, and now the new version should be full working and without important bugs.
Log in to leave a comment
Fixed a lot of bugs.
Using formidable to get the data in the back-end.
Fixed the images (both save and load).
Fixed the files (both save and load).
Finished all the standard user api.
Need to fix the administrator api.
Log in to leave a comment
Finished the back-end files migration.
Updated the api links and removed the old api calls.
Need to fix bugs.
Log in to leave a comment
Migrated most of the PHP files of the back-end to Next.js, that is more powerfull and allow to manage all the site (front-end and back-end) in just a server (don’t need to run the front-end and the back-end in two different istances) and in only a language (JavaScript).
The image is code because is quite difficult to take a picture of a working back-end (code is better than a dev console without errors).
Log in to leave a comment
