Backlog

Data Source question

avatar

Hello,
since I am a single person and using it privately, I am using RDM free. However, as an IT-guy, I have multiple devices at home and a server-landscape with multiple VMs, Labs, etc.
I am managing that from RDM, and I have two computers I am using, a Windows PC desktop and a Macbook. Both running RDM locally.
Now, I am aware that SQLite is not supported nor recommended to be put on the SMB share. However, from the single user standpoint, there is for me no downside, even if it can do single writes only. I can't make changes on both instances at once.
I am trying the Personal Hub, however I see no benefit for me, except one downside: my data is online (nevermind the security aspect here now).
I was hoping that it would be a "live" kind, but I still have to refresh the database, for entries to become visible. Don't know how it would respond to conflicts, but that really isn't an issue, I don't have 1500 entries and I must use refresh manually...

So, long story short: is there a way to stop the nagging line that SQLite is not supported and recommended on shared drives?

Thanks
Kosta

All Comments (13)

avatar

Hello Kosta,

We understand the concerns you have raised regarding the shared SQLite data source. We currently have no plans to support accessing SQLite data sources from a network path, however, due to potential challenges regarding corruption when the file is accessed from multiple sources. While it is not your scenario, it is not possible for us to validate this.

If you prefer not to use a cloud data source, we suggest considering an XML file as an alternative. However, please note that XML files do not support licensed versions. Therefore, if you eventually decide to switch to a licensed version, you will need to migrate to a different data source. Both SQLite and Hub Personal data sources are compatible with licensing.

For more information on selecting the appropriate data source type, please consult the following resource: https://docs.devolutions.net/rdm/windows/getting-started/checklist-individuals/select-data-source-type/

If you have any further questions or concerns, please let us know.

Best regards,

Richard Boisvert

avatar

Hello,
thank you for the information.
However still, I am missing an answer to my main question:
Can this be turned off?

Thanks

97a320e2-1db6-4f47-b891-8319af1f5324.png

avatar

Hello Kosta,

When you configure a SQLite data source with a network path, you get a warning:
c98ebffa-6f85-4d6d-8964-2b126fc42b3f

If you still try to connect, you normally receive an error:
ea9434b6-5a1a-45f5-9ad9-d1a19dc31698

Can you confirm what version of RDM you are using?

Best regards,

Richard Boisvert

ea9434b6-5a1a-45f5-9ad9-d1a19dc31698.png

c98ebffa-6f85-4d6d-8964-2b126fc42b3f.png

avatar

Hi Richard,

I don't get such messages. On first computer, I created the DB, on the second one, I connected to the same file (*.db). Worked without a hitch, except that nagging notice, which I don't want to see. Honestly, it's my risk if I want to use the SQLite on the shared path. I also have other options for doing it, like I could even bind it that it thinks it's a local drive, but all that just adds complexity.

Can the message be turned off or not?

BR
Kosta

avatar

Hello Kosta.

I do not believe it is possible. I have asked the engineering team if they want to add an option for it, I will let you know their answer.

Best regards,

Richard Boisvert

avatar

Thank you, looking forward to an update.

avatar

Hello,

I am the one who initially requested the warning regarding SQLite. I wanted to address the issue that even on the SQLite website, it is explicitly mentioned that SQLite is not supported on a network drive. I always been receiving numerous error reports from users who are encountering problems with SQLite on network drives.

Perhaps these issues arise only when individuals attempt to share the same connection.db file among multiple users, which goes against recommended usage practices. A potential solution could be an agreement message that allows users to disable the warning, accompanied by a comprehensive disclaimer. Before implementing this change, I will consult with our legal department to ensure compliance with all necessary regulations and responsibilities in term data corruption.

Best regards,

David Hervieux

avatar

Thank you for an update. It would be great if what you said could be implemented.
I'm pretty sure that corruption scenarios pertain to multi-user environment, which is not the case in my case.

avatar

Any update?

avatar

It's still on our todo.

David Hervieux

avatar

Hello,

Licensed users will now be able to hide this warning. This should be available for 2023.3.9

Regards,

Jafran Majeau

avatar

I can’t express it enough, how much unfair I find it, that you limit this to licensed users only. Beside the fact that exactly licensed users have NO reason to go for this option, since SQL is completely free to implement. It only really matters for single users like me, who use it at home privately.

avatar

Hello,
We already offer of lot of feature in RDM Free and my goal 15 years ago has never been to offer SQLite on a shared drive. I can understand your disappointment but that the best I can do. I'm not interested in supporting SQLite on a network drive,

Regards

David Hervieux