Pulling from database and updating database at the same time
Yes, databases are designed to handle this type of concurrent access. If the database is in the middle of an update, it will wait until the update is complete before handling the Flask app's query, and it will complete the query before starting the next incoming update.
Is it possible to run a python flask app that pulls from a sql database, while also running a python script that updates the sql database every few seconds?