Are there open source or free versions of Pick OS that can be installed on a Linux/Unix box?

3,533 views
Skip to first unread message

Jonathan Rosen

unread,
Sep 26, 2017, 8:38:47 AM9/26/17
to Pick and MultiValue Databases
I want to play around with running a Pick Db system on Linux. Anyone have instructions to do an install from scratch? Not sure whether all versions of PICK require a license or not... Any help would be appreciated.

Thanks,

Jonathan

Zumasys Reply

unread,
Sep 26, 2017, 9:15:22 AM9/26/17
to Pick and MultiValue Databases
Jbase has a Evaluation Version.  Here is the link for that version http://www.jbase.com/products/demo/

I do not know about the other flavors of Multi-value if they have a Evaluation Versions or not.  Hopefully someone else can comment on them.

Mitch

Martin Phillips

unread,
Sep 26, 2017, 9:18:38 AM9/26/17
to mvd...@googlegroups.com

Hi Jonathan,

 

There is a very out of date open source release of OpenQM available under the GPL but you are probably better off installing the free single user Personal Version unless you are planning on making changes to the core components.

 

Simply download the relevant installer (32 or 64 bit) from www.openqm.com/downloads.htm and when the installation process asks for the licence number type "Personal" instead.

 

The Personal Version is intended for learning about the multivalue environment and has a few limitations:

·        Max 1 interactive user, 1 QMClient user and 1 phantom process.

·        The QMNet interface for linking QM multiple systems is not available

·        Hashed files are each limited to about half a megabyte of data.

·        No free support.

·        No bundled AccuTerm licence.

 

 

Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
+44 (0)1604-709200

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms

KOSDAY SOLUTIONS

unread,
Sep 26, 2017, 9:27:55 AM9/26/17
to Pick and MultiValue Databases
OpenQM has a open source version. www.opwnqm.com
Pedro


http://www.openqm.com/?X=2clv7dse42&t0=gpl

geneb

unread,
Sep 26, 2017, 9:58:02 AM9/26/17
to Pick and MultiValue Databases
Take a look at this: http://scarlet.deltasoft.com.

g.

--
Proud owner of F-15C 80-0007
http://www.f15sim.com - The only one of its kind.
http://www.diy-cockpits.org/coll - Go Collimated or Go Home.
Some people collect things for a hobby. Geeks collect hobbies.

ScarletDME - The red hot Data Management Environment
A Multi-Value database for the masses, not the classes.
http://scarlet.deltasoft.com - Get it _today_!

Wols Lists

unread,
Sep 26, 2017, 10:51:14 AM9/26/17
to mvd...@googlegroups.com
Back from the VMark days (I think) there's always been a free version of
U2 available. Various limitations eg.

It's time bombed - you have to update regularly
Only certified for Red Hat

That'll be somewhere on the Rocket site. Now they've taken over much of
the Pick world, chances are there will be versions of other commercial
Picks there too ...

There've been various attempts to get a Free version of Pick up and
running, but the only one that really seems to have got any traction is
ScarletDME (the one mentioned by both Martin and Gene), and that hasn't
got much :-(

Cheers,
Wol

Glen Batchelor

unread,
Sep 26, 2017, 10:55:20 AM9/26/17
to mvd...@googlegroups.com
  ScarletDME brings back memories... I don't even think I have the Debian packaging stuff any more. Gene, when's the last time someone rolled a new source up?

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com
Message has been deleted

Robert Burke

unread,
Sep 26, 2017, 11:23:52 AM9/26/17
to Pick and MultiValue Databases

You can get evaluation licenses for D3, Universe and UniData with 10 users and support by requesting them at http://www.rocketsoftware.com/demos?f[0]=product2_category_backref%3A15061. These are fully featured with no restrictions other than they are to be used for evaluating the products only. The Rocket support department can help you with the installation or any other questions.


Ed Clark

unread,
Sep 26, 2017, 11:34:36 AM9/26/17
to mvd...@googlegroups.com
Rocket has evaluations for uniVerse at http://www.rocketsoftware.com/products/rocket-u2/rocket-universe-trials and for unidata at http://www.rocketsoftware.com/products/rocket-u2/rocket-unidata-trials. I don’t know how limited they are but they do expire. It doesn’t look like they have evaluations for D3 or mvBase.

Northgate has an evaluation of their Reality dbms at http://www.nps-reality.com/request-evaluation. It gives you 3 processes, but I don’t know if it runs on linux. It expires eventually.

jBase and QM have already been mentioned.

Since I work for Intersystems, I’d recommend Intersystems Caché. It does Pick, plus a whole lot more. You can download the evaluation from https://download.intersystems.com/download/login.csp.
The Caché evaluation software is a fully functional, non-expiring, single-user version, but it can run 12 concurrent processes so things like phantoms and spooler will work. It's available for Windows, Mac OS X, Red Hat Linux, and SUSE Linux.


--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com

Zumasys Reply

unread,
Sep 26, 2017, 12:19:23 PM9/26/17
to Pick and MultiValue Databases
Also, the default jBASE eval is 3 users for 30 days. This may be adjusted if necessary. You may also obtain an eval of MV Connect and MV Dashboard from Zumasys as well. Feel free to contact me directly if you need any assistance.

geneb

unread,
Sep 26, 2017, 1:54:34 PM9/26/17
to mvd...@googlegroups.com
On Tue, 26 Sep 2017, Glen Batchelor wrote:

> ScarletDME brings back memories... I don't even think I have the Debian
> packaging stuff any more. Gene, when's the last time someone rolled a new
> source up?
>
There were some tweaks submitted by someone about a year ago. That's the
most recent activity. The git repo is here:
https://github.com/geneb/ScarletDME

It's complete and it works, but it could sure stand some 64 bit love. ;)
(the tricky part is converting the binary objects to 64 bit, OR figuring
out how to stand up the system from nothing and use the compiler itself to
generate all the code after the system is up - but that presents problems
as well since the compiler is written in DataBASIC...kind of a chicken/egg
thing. ;) )

Tony Gravagno

unread,
Sep 26, 2017, 6:34:17 PM9/26/17
to Pick and MultiValue Databases
Would be nice if someone created a page at PickWiki.com for this so that the MV providers can update their own content. Then questions like this could be answered with a single link. But I don't believe I've ever seen these DBMS providers update a wiki page for their own products, user groups, or any other resources.

Marketing much?
T

geneb

unread,
Sep 27, 2017, 9:17:52 AM9/27/17
to Pick and MultiValue Databases
On Tue, 26 Sep 2017, Tony Gravagno wrote:

>
> Marketing much?

Marketing?

HAAHAHAHAHAHAHAHAHAHAHHAHAHAHA! *GASPS* AHAHAHAHAHAHAHAHAHAHHAHAH!

If the MV industry sold sushi:

"Cold, dead, fish for sale. Pricing available upon request."

Glen Batchelor

unread,
Sep 27, 2017, 10:29:55 AM9/27/17
to mvd...@googlegroups.com
"New Sushi: Food re-Invented for the new century"

fwinans

unread,
Sep 29, 2017, 5:43:38 PM9/29/17
to Pick and MultiValue Databases
If one was tinkering around on a shoestring budget, you'd also need a cheapo way to get linux;
Granted the more limited 'workstation' version of redhat is pretty cheap but a) I'm not sure it meets all the required linux packages
noted for d3, esp. the 'developer package' and b) probably omits the samba server, so you won't be able
to see linux disk shares from winboxes on the lan -- dunno about you guys, but our site uses d3 to keep
databases of info gotten from windows apps in same office, and we ofthen massage d3 report data to
be used in windows applications, hence d3 without the samba server would be a real pinch.

Centos is 'almost like redhat' but I dunno if the d3 installer would tolerate those slight differences, like not having
any /etc/redhat-release  file on the linux disk.  Also, you're meant to download the centos and burn your own
media in your own office, but the time needed to fetch a 4 or 5 gig dvd image boggles the mind, esp. if your
office uses a cheap but kindof slow and unreliable isp {not naming names here, but I guess you've heard of some}
I think you can buy a centos media on ebay or something, but I consider that too much trouble for just a casual
tinkering project.

Frank

geneb

unread,
Sep 29, 2017, 6:04:52 PM9/29/17
to Pick and MultiValue Databases
On Fri, 29 Sep 2017, fwinans wrote:

> Centos is 'almost like redhat' but I dunno if the d3 installer would
CentOS is effectivly /exactly/ like redhat.

It's not missing anything that D3 needs and I'm running three different
manufacturing plants on D3 with CentOS. The installer works just fine.

Anthony Youngman

unread,
Sep 30, 2017, 5:10:11 PM9/30/17
to mvd...@googlegroups.com
On 29/09/17 22:43, fwinans wrote:
> Also, you're meant to download the centos and burn your own
> media in your own office, but the time needed to fetch a 4 or 5 gig dvd
> image boggles the mind, esp. if your
> office uses a cheap but kindof slow and unreliable isp {not naming names
> here, but I guess you've heard of some}

I thought you could get hold of RedHat even without a maintenance
contract ... (although I think the deal is that if you licence one copy
you have to licence them all, which causes problems if your employer is
a licencee), and what's to stop you downloading the ISO at home? I've
got a 20Mb connection - quite slow by modern broadband standards - and
it's no hassle firing off a DVD download and going to bed, to find it
all there in the morning.

Cheers,
Wol

ERNIE VEGAS

unread,
Oct 10, 2017, 11:06:43 PM10/10/17
to mvd...@googlegroups.com
The only open source one I have seen is MaVerick:

http://www.maverick-dbms.org/

I toyed around with it (I think I needed the source code for a verb to
act as a starting point to save time in modifying to suit my needs for
a client. Keep in mind it is fairly bare bones...

Enjoy,

Robert Norman
ROBERT NORMAN AND ASSOCIATES

ERNIE VEGAS

unread,
Oct 10, 2017, 11:12:59 PM10/10/17
to mvd...@googlegroups.com
Pretty much all vendors have demo versions that time out after so many days.

As far as a full-feature no expiration date free version, OPENQM would
be the only one I am can think of offhand.

Robert Norman, PICK Programmer

geneb

unread,
Oct 11, 2017, 9:13:46 AM10/11/17
to mvd...@googlegroups.com
On Tue, 10 Oct 2017, ERNIE VEGAS wrote:

> The only open source one I have seen is MaVerick:
>
> http://www.maverick-dbms.org/
>
> I toyed around with it (I think I needed the source code for a verb to
> act as a starting point to save time in modifying to suit my needs for
> a client. Keep in mind it is fairly bare bones...
>
Then you need to look at OpenQM and its fork, ScarletDME. Both are full
multi-value systems as well as being licensed GPL - you can't get more
open source than that without declaring it to be public domain. ;)

Marcus Rhodes

unread,
Nov 9, 2017, 2:19:54 PM11/9/17
to Pick and MultiValue Databases

Martin Phillips

unread,
Nov 10, 2017, 4:25:10 AM11/10/17
to mvd...@googlegroups.com

 

On Tuesday, September 26, 2017 at 8:38:47 AM UTC-4, Jonathan Rosen wrote:

I want to play around with running a Pick Db system on Linux. Anyone have instructions to do an install from scratch? Not sure whether all versions of PICK require a license or not... Any help would be appreciated.

The Personal Version of OpenQM can be installed for free. It is limited to a single user, restricts the size of files to prevent its use in a production environment and has some of the advanced features such as QMNet for linking systems disabled. It is intended for learning about multivalue and QM in particular.

 

If you really want to go for an open source version, there is one available but it is very old and may require some work to get it to build on current Linux/Unix systems. It is aimed at users who want to experiment with new features that would require changes to the core components.

Reply all
Reply to author
Forward
0 new messages