MSQL: Difference between revisions

Latest revision as of 00:46, 26 February 2024

Mini SQL (mSQL) is a relational database management system from Hughes Technologies.

History

The database to feature a SQL interface but sported a flat file back end rather than a true relational file set. Very popular in the 90s as a web back end but gave way to MySQL and SQLite due to licensing issues. The original author David Hughes still supports the product commercially and provides occasional updates, but no one has bothered to port the more recent versions as better alternatives are available.

Versions

1.0.16 (Feb 1997)

2.0.4.1 build 4 (1998) - requires EMX runtime
2.0.11 (Aug 1999)

3.11 (Jun 2012)

4.1 (Jun 2017) - More operating systems were supported as ports but not by the original author directly, so ports of the most recent versions have dried up but it may be possible to compile the current codebase to other systems without much fuss.
4.4 (Oct 2021)

Interfaces

REXX: Rexx/SQL 2.4 [rxsql24_min2_os2.zip]
OBDC: mSQL odbc driver for Sibyl [modbc.zip]
JDBC: Imaginary JDBC Driver [msql-jdbc-2b.zip]

License

Commercial - Is open source but released as copyrighted software with a no commercial usage clause.

Publications

Brian Jepson; David J. Hughes: Official Guide to Mini SQL 2.0 - Wiley 1998, ISBN 0-471-24535-6

Links

Hughes Technologies

[dbf2msql-2.0.zip] - An utility to convert .dbf files to mSQL tables and back
[dbadmin-1.0.1.zip] - CGI interface to allow mSQL administration via the web

@@ Line 1: / Line 1: @@
-==Description==
+{{DISPLAYTITLE:mSQL}}
-The first open source database to feature an [[SQL]] interface, but has a flat file back end, originally called '''Mini SQL'''. Very popular in the 90's as a web back end but gave way to [[MySQL]] and [[SQLite]] due to licensing issues and is now primarily of historical interest. The original author still supports the product commercially and provides occasional updates, but no one has bothered to port the more recent versions as better alternatives are available, one of the issues being that the author seldom or never folded changes from third party authors into the codbase so that porters constantly had to re-do their work.
+[[Image:Msql.gif|right]]
+'''Mini SQL''' (mSQL) is a relational database management system from Hughes Technologies.
-==Version==
+==History==
-*'''Current OS/2 version''': [ftp://hobbes.nmsu.edu/pub/os2/apps/database/msql2041b4.zip 2.0.4.1 Build 4]
+The database to feature a [[SQL]] interface but sported a flat file back end rather than a true relational file set. Very popular in the 90s as a web back end but gave way to [[MySQL]] and [[SQLite]] due to licensing issues. The original author David Hughes still supports the product commercially and provides occasional updates, but no one has bothered to port the more recent versions as better alternatives are available.
-*Current Linux, Solaris & Mac OSX version: 3.11 - More operating systems were supported as ports but not by the original author directly, so ports of the most recent versions have dried up but it may be possible to compile the current codbase to other systems without much fuss.
-==Prerequisites==
+==Versions==
-* [[EMX]] runtime
+*1.0.16 (Feb 1997)
+*2.0.4.1 build 4 (1998) - requires [[EMX]] runtime
+*2.0.11 (Aug 1999)
+*3.11 (Jun 2012)
+*4.1 (Jun 2017) - More operating systems were supported as ports but not by the original author directly, so ports of the most recent versions have dried up but it may be possible to compile the current codebase to other systems without much fuss.
+*4.4 (Oct 2021)
+==Interfaces==
+;REXX:Rexx/SQL 2.4 [rxsql24_min2_os2.zip]
+;OBDC:mSQL odbc driver for Sibyl [modbc.zip]
+;JDBC:Imaginary JDBC Driver [msql-jdbc-2b.zip]
 ==License==
 * Commercial - Is open source but released as copyrighted software with a [[no commercial usage clause]].
+==Publications==
+* Brian Jepson; David J. Hughes: ''Official Guide to Mini SQL 2.0'' - Wiley 1998, ISBN 0-471-24535-6
 ==Links==
-* [http://www.hughes.com.au Huges Technologies homepage]
+* [https://hughestech.com.au/products/msql/ Hughes Technologies]
-* [ftp://hobbes.nmsu.edu/pub/os2/dev/rexx/rxsql24_min2_os2.zip REXX/SQL 2.4 mSQL version]
-* [ftp://hobbes.nmsu.edu/pub/os2/apps/database/dbf2msql-2.0.zip dbf2msql 2.0] - An utility to convert .dbf files to mSQL tables and back.
-* [ftp://hobbes.nmsu.edu/pub/os2/apps/database/dbadmin-1.0.1.zip BdBadmin 1.0] - [[CGI]] interface to allow mSQL administration via the web.
-* [ftp://hobbes.nmsu.edu/pub/java/apps/database/msql-jdbc-2b.zip Java mSQL JDBC driver]
-==Author==
-*Huges Technologies
-*David Huges
+* [dbf2msql-2.0.zip] - An utility to convert .dbf files to mSQL tables and back
+* [dbadmin-1.0.1.zip] - CGI interface to allow mSQL administration via the web
-[[Category:Tools]][[Category:Databases]][[Category:Software written in C]][[Category:Open Source Software]][[Category:Linux Tools]][[Category:Solaris Tools]][[Category:MAC OSX Tools]]
+[[Category:RDBMS]][[Category:Software written in C]]