starred/1Remote

Fork 0

mirror of https://github.com/1Remote/1Remote.git synced 2026-04-25 13:36:03 +03:00

[GH-ISSUE #245] mysql database For securitY -to secure the connections/entries #215

New issue

Closed

opened 2026-02-26 11:57:15 +03:00 by kerem · 4 comments

kerem commented

2026-02-26 11:57:15 +03:00

Owner

Originally created by @msebastian100 on GitHub (May 27, 2022).
Original GitHub issue: https://github.com/1Remote/1Remote/issues/245

Originally assigned to: @VShawn on GitHub.

Hello,
I love the software
Would it be possible to add a function to connect to a mysql database?
That would be very practical for security.
Of course you can also save a backup file (Exempel.prma) but still Mysql would be great :)

Greetings Sebastian Mallach

Originally created by @msebastian100 on GitHub (May 27, 2022). Original GitHub issue: https://github.com/1Remote/1Remote/issues/245 Originally assigned to: @VShawn on GitHub. Hello, I love the software Would it be possible to add a function to connect to a mysql database? That would be very practical for security. Of course you can also save a backup file (Exempel.prma) but still Mysql would be great :) Greetings Sebastian Mallach

kerem

2026-02-26 11:57:15 +03:00

closed this issue
added the
meta-feature

priority-low
labels

kerem commented

2026-02-26 11:57:16 +03:00

Author

Owner

@VShawn commented on GitHub (May 29, 2022):

Hi thanks for the advice. AND YES I have been thinking about multi data source for years, MySQL of course is under consideration.
But I don't need a MySQL database in my daily use. And any demand I personally don't need is a low priority demand I think, and low priority demand will be delayed since I am the only developer in this project.

But it will be implemented one day, I have created the folder structure for this :)

https://github.com/1Remote/PRemoteM/tree/dev_net6/Ui/Model/DAO

@VShawn commented on GitHub (May 29, 2022): Hi thanks for the advice. AND YES I have been thinking about multi data source for years, MySQL of course is under consideration. But I don't need a MySQL database in my daily use. And any demand I personally don't need is a low priority demand I think, and low priority demand will be delayed since I am the only developer in this project. But it will be implemented one day, I have created the folder structure for this :) https://github.com/1Remote/PRemoteM/tree/dev_net6/Ui/Model/DAO

kerem commented

2026-02-26 11:57:16 +03:00

Author

Owner

@majkinetor commented on GitHub (May 29, 2022):

I think this is overkill. This makes sense only for hard core corporate use and as such I would totally give it low priority. You would also have to make a migration from sqlite to mysql. And why MySql? PostgreSQL seems like better fit TBH given that its not owned by Oracle overlords. I don't see how this relates to security either.

@majkinetor commented on GitHub (May 29, 2022): I think this is overkill. This makes sense only for hard core corporate use and as such I would totally give it low priority. You would also have to make a migration from sqlite to mysql. And why MySql? PostgreSQL seems like better fit TBH given that its not owned by Oracle overlords. I don't see how this relates to security either.

kerem commented

2026-02-26 11:57:16 +03:00

Author

Owner

@VShawn commented on GitHub (May 30, 2022):

IMO this has nothing to do with security, it just giving you an alternative.

With mysql we can share servers in a team: sending json file to share servers just annoying us in my ofice.

BTW I never thought about the migration from sqlite to mysql. User must export json file from sqlite then import to mysql manully in my design.

In the end I want to reiterate that it is a vervy low priority demand for me. Development fot this will not start in the near future

@VShawn commented on GitHub (May 30, 2022): IMO this has nothing to do with security, it just giving you an alternative. With mysql we can share servers in a team: sending json file to share servers just annoying us in my ofice. BTW I never thought about the migration from sqlite to mysql. User must export json file from sqlite then import to mysql manully in my design. In the end I want to reiterate that it is a vervy low priority demand for me. Development fot this will not start in the near future

kerem commented

2026-02-26 11:57:16 +03:00

Author

Owner

@majkinetor commented on GitHub (May 30, 2022):

With mysql we can share servers in a team: sending json file to share servers just annoying us in my ofice.

Yes, this is the only benefit of having central database. Full blown relational database requires WAY more maintenance, harder backups, many things to go wrong...

We can get the benefit of central db with sqlite alone. Didn't you implement mechanism to release a lock as soon as possible? It should be enough in most cases. This should work and is totally appropriate for this case since frequency of write will be miniscule.

@majkinetor commented on GitHub (May 30, 2022): > With mysql we can share servers in a team: sending json file to share servers just annoying us in my ofice. Yes, this is the only benefit of having central database. Full blown relational database requires WAY more maintenance, harder backups, many things to go wrong... We can get the benefit of central db with sqlite alone. Didn't you implement mechanism to release a lock as soon as possible? It should be enough in most cases. [This](https://stackoverflow.com/questions/22636625/accessing-a-sqlite-database-with-multiple-connections) [should work](https://stackoverflow.com/questions/22160108/can-multiple-applications-access-a-sqlite-database) and is totally appropriate for this case since frequency of write will be miniscule.

kerem referenced this issue

2026-02-28 12:02:22 +03:00

[GH-ISSUE #215] Capture keyboard shortcuts by host #1147

kerem referenced this issue

2026-03-01 17:17:46 +03:00

[GH-ISSUE #215] Capture keyboard shortcuts by host #2107

kerem referenced this issue

2026-03-13 01:34:44 +03:00

[GH-ISSUE #215] Capture keyboard shortcuts by host #3070