Intrusive MySql Server connection error

[majkinetor]

Describe the bug

When remote database becomes unavailable for any reason, there is this error:

Expected behavior
There should be no intrusion, especially since the error can resolve on its own. It seems that 1RM needs some form of internal Log viewer wiht marker for ciritical errors, warnings, currently erroring etc.

Additional context
This happens when VPN goes down to my company. Also when Windows is locked, after some time, I am always greeted with this message. VPN log is unremarkable but that is besides the point, the error is intrusive and constant.

[VShawn]

I only checked the MySQL connection once during startup, but it should be changed to check the connection before any data operation. Additionally, I was lazy and applied the SQLite connection program to MySQL, which now I realize is problematic. I need to redesign this part.

[majkinetor]

I only checked the MySQL connection once during startup

Wait what ?
This message happens while 1RM is already running in the background. When do you check for remote changes? On activation?

BTW, I think this should be redesigned to support "storing backend" so that new backends could be easily added later without messing with 1RM internals: PostgreSQL, JSON file, git repository (git mmmm :) ) or whatever. It makes sense that this should be apstracted via some nice Interface.

[VShawn]

I check the connected flag during startup and when database profile was changed.

while 1RM is already running in the background and VPN shutdown, 1RM do not realize it lost connect since the connected flag not changed. the 1RM can still run the SELECT / INSERT / UPDATE / DELETE from db. When executing the SQL statement, I provide a final security check. If the statement fails to execute, a prompt will pop up. That why you see the pop up while 1RM is already running in the background.

When do you check for remote changes? On activation?

I provide a periodic check.

support "storing backend"

Emm what do you mean the "storing backend"? I've never heard this word before. do you mean something like Amazon S3 / Alibaba Cloud OSS? Ann...nd git is definitely not a good storage backend :)

a good news is is that I have designed the datasource interface in 1RM and have already implemented it on SQLite and MySQL. Means as long as the interface is implemented based on PostgreSQL, PostgreSQL can be integrated into 1RM.

It makes sense that this should be apstracted via some nice Interface.

is there some nice tool for apstracted?

[majkinetor]

"storing backend"

How the connections are stored and where :)

So we can add more store backend in the future, like git (great for team sharing without hassle of installing db) or simple JSON file or whatever.

But OK, you say you already designed it that way...

[majkinetor]

OK, so we need then some internal log instead of intrusive popups? Or what are your thoughts?

[VShawn]

I designed popups as a fallback error prompt mechanism. I added it to avoid situations where the database encounters exceptions (for example, when SQLite is set to read-only while 1RM is running in the background) and users cannot detect them.You see, this time the popup also helped me discover that 1RM would encounter exceptions when 'VPN goes down' :)

Normally, popups should not be triggered。the upstream error handling should handle all of the connection exception, so there should not be any intrusive situations. As long as I handle connection errors in a more appropriate way, popups would not appear. However, considering all kinds of exceptions is difficult, so I need to take some time to refactor the error handling program for adding, deleting, updating, and selecting. Then, I need draw a flowchart to help me sort out which error situations may occur: such as when the database disconnects while the user is editing or when the user tries to delete data after the database has disconnected.

[VShawn]

I've remove the alert so you will not get the popups when 1RM is running in the background.

Adding the ability of offline database and automatic reconnection by periodic checking, testing is still needed.

It is being considered whether it is possible to detect changes in computer network and automatically reconnect after such changes occur.

[majkinetor]

Just an update.

Today I don't see the remote database.

details

I went on Edit -> Test and it said Success, on the back, it blocked here:

details

On escape it goes back with it and ALT M stopped working

details

[VShawn]

Just an update.

Today I don't see the remote database.

details

I went on Edit -> Test and it said Success, on the back, it blocked here:

details

On escape it goes back with it and ALT M stopped working

details

I think these were fixed after 930a8c0