Download Sqlite Database Editor
Natalie Martin
If the 'Synchronise' option is greyed out then the database layer in your QGIS project should already be connected to the database and there is no need to Sync. If you hover your mouse over the layer it will pop-up with it's path/host.
If the database location is showing an SQLite file stored locally as below, and the synchronise option is not available then somehow your QGIS project has 'lost' that this is an offline edit of your database.
To repair you would need to make another offline edit to an SQLite file, taking care not to overwrite the one with the edits you want to synchronise. Make a note of the long numbers that are added to the end of the database name, and which number relates to which.
It should just be an executable (exe) named sqlite3Explorer.exe. Remember to download the latest SQLite DLL (sqlite3.dll) from the SQLite website. It needs to be extracted where the program is located to work.
I have a workout tracking web app using Streamlit and have recently switched to the st.experimental_data_editor instead of a typical dataframe. I want my database to update after I make a change, but after a refresh nothing is saved. If anyone has ideas to help that would be great!
df19127ead