FreeIdeas

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.

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.

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).

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!

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.

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.

Finished the back-end files migration.
Updated the api links and removed the old api calls.

Need to fix bugs.

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).