X2Net OneStore
< Next Topic | Back to topic list | Previous Topic >
Posted by Alexander Deliyannis
Jun 20, 2008 at 09:35 AM
X2Net has been mentioned here—or rather in the ancestor Outliners.com forum- for their Smartboard product ( http://www.x2net.com/smartboard/ ) a clipboard enhancement program like Clipmate and ClipCache. I purchased a license to Smartboard which at the time I found the most powerful—however, this power came at the price of slowness and/or large resource consumption.
The reason for this slowness is the same that makes X2Net’s products, including OneStore, differ from most of the competition: they are client/server applications, with an SQL server running locally that deals with the actual database and the front-end client interface that the user mostly deals with.
As a result, OneStore can be used by multiple users (though sadly each one requires a separate full-priced license) across a network and even the internet. I would note that until recently only Sycon’s IDEA! was built to work across a network; nowadays the MyBase developer offers a similar multi-user oriented program and UltraRecall has added multiple user support in its core functionality (previously it could be used as such but with no guarantees). I am not sure whether SQL Notes is multiuser, though I imagine it could be.
I am thus writing this note more as reference (Note for the File we used to call it at the UN), since I know that most here are interested in personal information managers. However, for small organisations looking for a common database—and mine has in the past- it is worth testing this particular product. I am especially intrigued by its internet access, something I have only seen Evernote—a single-user product as yet- provide.
Cheers
Alexander
Posted by Pierre Paul Landry
Jun 20, 2008 at 06:47 PM
Alexander Deliyannis wrote:
>I am not sure whether SQL Notes is multiuser, though I imagine it could be.
>
Yes SQLNotes is intrinsically multi-user as it uses the JET 4.0 database engine. The basic database unit is a cell value (and not the whole record, as it is usually). This allows different users to simultaneously update different cells of the same item. There are 2 configurations implemented and 2 more to come:
1- Simply put the .SNDB file on a LAN. Simultaneous multi-user read and updates. Pro: simple, Con: all users share the same UI (grids, forms, etc)
2- The .SNDB is split between UI and Data. Only the data file is put on the LAN. Pro: allows users to have different UI (different grids, columns, forms, etc). Enhanced security.
Coming configurations are:
3- Item 2 above but using SQL Server for enterprise level security and confidentiality.
4- Disconnected networking allowing users to share a database over a LAN or the web, online or offline with automatic synchronisation and updates.
(FYI, I’m the designer of http://www.sqlnotes.net)
Posted by Alexander Deliyannis
Jun 22, 2008 at 04:46 PM
Impressive; when (4) is implemented, SQL Notes will be the third personal information management product offering web access functionality as far as I know, Evernote and X2Net OneStore being the other two.
I think I have mentioned this in the past; any plans to make SQL Notes work with popular PHP/SQL web content management systems (CMS)? I believe this could be a killer as offline CMS are very hard to find.
Though several information managers use some kind of SQL database (UltraRecall, IDEA! team edition, X2Net, even ClipMate) the apparently logical step of publishing their information through a CMS is nowhere to be seen. I wonder if it’s technically hard to implement.
I know that two information managers discussed here are focused on web publishing (with the classic tree pane used for navigation) namely Web Idea Tree and TreePad, while others offer similar functionality, with the more aesthetically pleasing coming from Surfulater. However, this is not the same as being able to directly run a modern database driven website through an information manager.
Cheers
Alexander
Pierre Paul Landry wrote:
>Yes SQLNotes is intrinsically multi-user ...
>There are 2 configurations implemented and 2 more to come:
...
>3- Item 2 above but using SQL Server for enterprise level
>security and confidentiality.
>4- Disconnected networking allowing users to share
>a database over a LAN or the web, online or offline with automatic synchronisation and
>updates.
Posted by Slartibartfarst
Feb 20, 2016 at 09:45 PM
Just cross-referencing what might be useful information about OneStore - a type of personal DMS (Document Management System).
There was a query about it on Donation Coder forum: https://www.donationcoder.com/forum/index.php?topic=42347.msg396277#msg396277
Software discontinued…help!
In the course of doing some investigation in order to assist response to the query, I did a discovery trial of OneStore and found it quite good.
I put up a brief review of it here: https://www.donationcoder.com/forum/index.php?topic=42011.msg396319#msg396319
X2NET OneStore - Mini-Review (“also-ran”)
My references included useful posts on the outlinersoftware.com forum.
One outstanding issue seems to be the existence of a reportedly $FREE key (per BitsDuJour) for the single home user OneStore licence. If anyone knows anything about that, it could be very handy. The software seems to be far from dead/useless, though X2NET Limited have shut down.