Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] Suggestions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-17-2017, 02:32 AM
Viggo Viggo is online now
Registered User
 
Join Date: 09-10-2006
Posts: 19
Multi-user - Client/Server

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
Reply With Quote
  #2  
Old 01-17-2017, 08:54 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 519
Take a look at InnoKB http://www.wjjsoft.com/
Reply With Quote
  #3  
Old 01-17-2017, 08:56 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
I would suggest trying with more users and see how it goes. Depending on that, it's something we can consider.
Reply With Quote
  #4  
Old 01-17-2017, 09:44 AM
Viggo Viggo is online now
Registered User
 
Join Date: 09-10-2006
Posts: 19
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.
Reply With Quote
  #5  
Old 01-17-2017, 09:46 AM
Viggo Viggo is online now
Registered User
 
Join Date: 09-10-2006
Posts: 19
Quote:
Originally Posted by cnewtonne View Post
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.
Reply With Quote
  #6  
Old 01-17-2017, 10:44 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,034
Quote:
Originally Posted by Viggo View Post
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.

Quote:
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.
Reply With Quote
Reply

Tags
client/server , multi-user , network , sqlite , sqlitening


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 06:22 PM.


Copyright © 1999-2023 Kinook Software, Inc.