Multi-user - Client/Server

[Viggo]

Greetings,

I have using UR since 2007 in a network with multiple 2-3 users. We are very happy with the rich functionality in UR.
I really would like to expand the usage to 18-20 users, but the lack of true client/server a limiting factor.
UR is based on shared SQLite db-files we are concerned about speed, possible corruption and other problems, although I have not testet with more than 3 users simultanously.

I am still looking for an alternative - and have not found anything matching the outstanding functionality found in UR!
TreePad seem to be the only somewhat similar, but it's more limited and not as user friendly and also it's an outdated product not developed anymore.

Cloud-based systems are not an alternative, I want a self-hosted Group Information Manager.

Thinking about it, there ought to be a marked for a self-hosted solid IP-based true Client/Server information manager with the rich functionality of UR. Not everything belongs in the cloud.

Thus, I would really really like to see UR being further evolved into a true Client/Server system. This would mean a version that will use a standard (free/low cost) SQL Server.

Also I see there is a SQLite alternative for client/server, called SQLitening, see http://www.sqlitening.com/support/index.php and http://apothesoft.com/as/SQLitening.Pdf

Maybe this makes a port much easier than to a completely different SQL db?

Does Kinook have any thoughts on this?

Also, what does the road map for Ultra Recall look like presently?

Kind regards
Viggo Kleven
MediLink Software

[cnewtonne]

Take a look at InnoKB http://www.wjjsoft.com/

[Viggo]

Originally Posted by cnewtonne

Take a look at InnoKB http://www.wjjsoft.com/

Thanks. I am aware of InnoKB, had a good look at it some time ago.

-Viggo.

[kinook]

I would suggest trying with more users and see how it goes. Depending on that, it's something we can consider.

[Viggo]

Thanks for your quick responses.

Yes, I actually plan to test with more simultaneous users using the UR Viewer.
Apart from eventually speed issues - what are the risks for trashing database and/or other conflicts?
If those tech aspects are a "no worry", then we may be ok for now as a start.

Thanks for being open to considering ;-)

Also thanks for the updated road map!
What is maximum size per database in latest version? Will this change with a new SQLite version as mentioned in road map?
I see that SQLite3 can hold upto 140 TB pr db (https://www.sqlite.org/limits.html)

-Viggo.

[kinook]

Originally Posted by Viggo

Thanks for your quick responses.

Yes, I actually plan to test with more simultaneous users using the UR Viewer.
Apart from eventually speed issues - what are the risks for trashing database and/or other conflicts?
If those tech aspects are a "no worry", then we may be ok for now as a start.

I'm not sure about the risks, but using the UR Viewer, I would think the risks would be minimal. Of course, it's always a good idea to keep regular backups of any important files.

What is maximum size per database in latest version? Will this change with a new SQLite version as mentioned in road map?
I see that SQLite3 can hold upto 140 TB pr db (https://www.sqlite.org/limits.html)

The limit for UR is still currently 2TB.