Multi data source

[VShawn]

Sometime we need a personal session database + some shared session database for work teams.

• [x] MySQL database supported
• [ ] SQLite path editing view
• [ ] MySQL config editing view
• [ ] Additonal data source control manager
  • [ ] data RSA encryption for mysql
  • [ ] profile encryption
  • [ ] Database statue detector
  • [ ] Database statue detector work with ASYNC
  • [x] reconnect after db config edit
  • [x] A list view of all data source.( add / edit / delete )
• [ ] Servers management for multi data source
  • [ ] Add new server to assign data source
  • [ ] Server list sort by data source

[VShawn]

here comes the list view

[majkinetor]

Have you consider something database agnostic? 1RM certainly doesn't require non ANSI SQL.

Using postgresql should be equally easy as mysql and far more sane.

[VShawn]

Actually we are required to use MySQL in the develop, so I started with MySQL first, mssql postgresql would be letter.

I trying to use VARCHAR only in create tabel. It would work (to my understanding) with most of the db.

Not very sure, I'm not expert of Database.

[majkinetor]

Yeah, varchar works everywhere but you are limiting yourself if you only use that.

You need check if it is ANSI SQL or use ORM like entity framework.

[VShawn]

almost done, @majkinetor you can try this one since you mentioned in https://github.com/1Remote/PRemoteM/issues/76#issuecomment-1246395658

1Remote alpha.01.zip

[Wikiphil]

Hi, Is this version will be merged with the main?

I configured my MySQL server and now all my entries are working on it. Pretty easy to configure, I'll try to access from another computer at the same time.

Regards.

[VShawn]

Yes, this version will next generation of PRemoteM. But it's not a good choose to use this version, it not stable now： AKA you might lost your data.

I suggest you get build pack from GitHub action artifacts: https://github.com/1Remote/PRemoteM/actions/runs/3806712068

The package I uploaded on Oct 22 is now obsolete.

[Wikiphil]

Done! I’ve updated to the latest version.

Views/Filters in the main windows are betters.

I'll test the readonly.

Thanks.

[Joly0]

Hey, this feature looks really cool and might be quite useful. Though a useful addition would be the possibility to define, if usernames and password are saved in the mysql database or in the local sqlite database. This would be very useful for teams which all share the same servers, but dont share the same login or other servers for which the login is the same for every user.

I might be wrong, but i dont see this is possible at the moment, as far as i can see, the login is saved in the mysql and used for everyone that uses the mysql database

[VShawn]

@Joly0 You are right, sharing servers' address only is not possible for the current data structure.

And if you ask me, I suggest everyone save their own login in the local sqlite db in this case.

Anyhow... We need a user authority management if we are going to satisfy teams which all share the same servers, but dont share the same login. This means server-side\ more complex logic control \ management ui \ bla bla bla... That's too much work for me, I won't do that...