*BSD News Article 95526


Return to BSD News archive

Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!munnari.OZ.AU!news.mel.connect.com.au!news.mel.aone.net.au!news.netspace.net.au!news.mira.net.au!pumpkin.pangea.ca!www.nntp.primenet.com!nntp.primenet.com!howland.erols.net!newsfeed.internetmci.com!in1.uu.net!206.109.2.48!bonkers!not-for-mail
From: "Jaap G" <jaapg@orion.nl>
Newsgroups: comp.unix.bsd.freebsd.announce
Subject: [ANNOUNCE] MDBMS, new unix DBMS free download
Date: 16 May 1997 12:50:28 -0500
Organization: EuroNet Internet
Lines: 81
Sender: daemon@taronga.com
Approved: peter@taronga.com
Message-ID: <5li6p4$gfl@bonkers.taronga.com>
NNTP-Posting-Host: localhost.taronga.com
Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.announce:563

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

For now it has Linux and FreeBSD support
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.

 
Later, the full source code will be released.

A Java interface is being released soon, as well as ODBC and JDBC.

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/

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