Problems with database and a new vector of working #4
Description
2 days ago I started to integrate the database into the project.
I've chosen phpMyAdmin database and made a decision to perform all database queries in php script. To make it possible, I used AJAX to run php code.
The problem is in AJAX's asynchronous nature. Now it's really hard for me to consider the fact that result of the query will be taken after some time and the code will continue executing and won't wait the completion of that query.
By my architecture, I can do queries that don't return any values (INSERT, UPDATE, DELETE). But I cannot yet provide the implementation of queries that return results (SELECT). All my attempths either worked from time to time or even didn't work at all because value returned from query tried to be used before reieving from database (AJAX is new for me).
After 2 days of attempthing I've decided to postpone the database connecting at the end. Now I'm going to create a new branch where I'll remove all database using and fully complete all the desing work.
To start the implementation of execution module, first I must integrate the project with database, but it will take more time than I expected that's why I think I won't be able to start working on execution module at all.
Now my goal is to complete all the desing and interface work until the end of Internship. I'll continue working on database if I have time after that.