*BSD News Article 95784


Return to BSD News archive

Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!munnari.OZ.AU!news.ecn.uoknor.edu!feed1.news.erols.com!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!EU.net!sun4nl!fido.news.demon.net!demon!news2.euro.net!news.euro.net!usenet
From: "Jaap G" <jaapg@orion.nl>
Newsgroups: comp.unix.bsd.freebsd.misc
Subject: [ANNOUNCE] free downloadable DBMS for unix
Date: 20 May 1997 09:18:10 GMT
Organization: EuroNet Internet
Message-ID: <5lrq8i$h59@news.euro.net>
NNTP-Posting-Host: 194.134.34.194
X-Newsreader: Microsoft Outlook Express 4.71.0544.0
X-MimeOLE: Produced By Microsoft MimeOLE Engine V4.71.0544.0
Lines: 76
Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:41272

MDBMS is a new SQL database server (currently) for UNIX systems.

Some main features of MDBMS:

- Very easy installation, 1 binary, no configuration.
- Rich SQL support, like: subselects (WHERE IN, WHERE EXISTS), referential
  integrity (ON DELETE CASCADE, SET NULL, RESTRICT), GROUP BY, full
 expressions
  in SELECT and WHERE parts (SELECT (salary/12)*months FROM ...), primary
 keys
  and foreign keys consisting of multiple attributes and more.
- Support for tables without a primary key.
- Full control over a telnet TCP connection. There's a user TCP port for
 normal
  use and a client TCP port, for fast, easy to parse access by clients.
- Smooth multitasking: every port can run there own queries simultaneously.

- Full user based security system with GRANT/REVOKE on SELECT, INSERT,
DELETE,
  UPDATE, DROP and WITH GRANT OPTION.
- Low system demands: about 5 Mb of disk space and 4 Mb of RAM.
- Free for non commercial use. Commercial versions will be very cheap.
- A dynamic CGI-bin is included for easy web integration. This CGI-BIN can
  talk to the database in SQL and supports other features like: DES
 password
  encryption, IF THEN ELSE constructions (even nested), an INCLUDE
 statement,
  support for arithmetic calculations and more.
- Versions will be available for Linux, BSD, Alpha, Solaris and possibly
others.
  (Linux version can be downloaded now, others will be available in about
 1
  week). Later, the full source code will be released.
- A Java interface is being worked on, as well as ODBC.

Legal stuff:

This version of MDBMS is an alpha test version. Is it free for non
commercial use. Commercial users can use this version free for a period of
one month.
Future upgrades will probably be very cheap for commercial users: about
 $100.

Remember that this is alpha software, which means that it may still
contain bugs. I cannot be held reliable for any loss of data resulting from
the use
of
 this system. I have tested the database system for about 4 month now, and
it has run without problems here, but still be careful. A utility 'dumpdb'
is
included to backup your data.

The packages includes:
- The server
- A dynamic CGI-BIN for an easy web interface
- A set of utility's
- A C-library to interface with the database

The full MDBMS package can be downloaded at:

http://www.orion.nl/~marty/mdbms/
ps. don't forget the last '/' !!!

Currently we're working on porting the DBMS to other platforms, for any
suggestions
please mail :
mdbms@orion.nl