This article is about the cross-platform RDBMS by Hughes Technologies. It is not to be confused with Microsoft's Windows based system, Microsoft SQL Server.
In 1993–94 David Hughes developed a network monitoring and management system called Minerva.[2] The design of this system required a database management system to store its configuration and working data. To enable future portability, Hughes elected to use a Structured Query Language interface between the application and the database management system, despite the fact that at the time there was no free or inexpensive SQL database management implementation available. Hughes therefore developed a translation program which provided an SQL interface to the free Postgres DBMS (which did not use SQL[3]). This product was named miniSQL,[clarification needed] or mSQL. In time it became clear that Postgres did not perform adequately on the low-specification systems used to run Minerva, so mSQL developed into a lightweight database management system in its own right, implementing a limited subset of the SQL standard, but performing well on minimally specified hardware.[4]
mSQL was the first low-cost SQL-based database management system.[citation needed] Combined with the free Linux operating system, the availability of relatively powerful low-cost PC hardware, and the development of World Wide Web standards and technologies, mSQL was an important factor in the early development of interactive, dynamic web applications,[5] particularly in the period 1994–1997, after which it was increasingly supplanted by the more highly featured MySQL. mSQL had a large and widespread install base by the late 1990s.[6]
Licenseedit
Despite being offered in source code form, and being strongly associated with open source software, mSQL itself has never been offered under an open source license.
mSQL is provided free for non-commercial use.[6] A typical license for commercial use in 1997 would cost $170,[5] compared to a "five-digit purchase price"[7] for its full-featured competitors.
Current statusedit
By 1996, development on mSQL began to stagnate and MySQL arose to fill that void. By 1999, MySQL had surpassed mSQL[6] in popularity and today mSQL has less visibility. At this time the database system is more often licensed by other companies for use in their products than used by end-users directly. mSQL is actively maintained and developed primarily to support its licensees and internal use within Hughes Technologies products and projects. It is still provided under a license that allows its use free of charge for non-commercial, educational and charitable activities. mSQL 4.4 was released in October 2021.
^"Hughes Technologies : The home of mSQL and Network Knowledge". hughestech.com.au. Retrieved 2021-04-19.
^"Minerva : An Event Based Model For Extensible Network Management". CiteSeerX10.1.1.48.4006.
^Yarger, Randy Jay; Reese, George; King, Tim (1999). MySQL & mSQL. O'Reilly. p. 8. ISBN1-56592-434-7. "Postgres, unfortunately, came with similar resource requirements as its commercial counterparts without the advantage of SQL as a query language. At the time, postgres used a variant of the QUEL language called PostQUEL"
^Yarger, Randy Jay; Reese, George; King, Tim (1999). MySQL & mSQL. O'Reilly. p. 9. ISBN1-56592-434-7.
^ abBurkett, Scott (1997). "Using mSQL in a Web-Based Production Environment". Linux Journal. Retrieved 29 May 2010.
^ abcKomarinski, Mark F.; Collett, Cary (2000). Red Hat Linux system administration handbook. Prentice Hall. p. 203. ISBN978-0-13-025395-8.
^Lerner, Reuven (1999). "Review: MySQL & mSQL". Linux Journal. Retrieved 29 May 2010.
External linksedit
Official website
May 04, 2024
msql, this, article, about, cross, platform, rdbms, hughes, technologies, confused, with, microsoft, windows, based, system, microsoft, server, mini, abbreviated, lightweight, database, management, system, from, hughes, technologies, mini, developer, hughes, t. This article is about the cross platform RDBMS by Hughes Technologies It is not to be confused with Microsoft s Windows based system Microsoft SQL Server Mini SQL abbreviated mSQL is a lightweight database management system from Hughes Technologies Mini SQL or mSQLDeveloper s Hughes TechnologiesStable release4 4 October 20 2021 2 years ago 2021 10 20 1 Written inCOperating systemCross platformAvailable inEnglishTypeRDBMSLicenseProprietaryWebsitewww wbr hughestech wbr com wbr au wbr products wbr msql wbr Contents 1 History 2 License 3 Current status 4 Host languages 5 See also 6 References 7 External linksHistory editIn 1993 94 David Hughes developed a network monitoring and management system called Minerva 2 The design of this system required a database management system to store its configuration and working data To enable future portability Hughes elected to use a Structured Query Language interface between the application and the database management system despite the fact that at the time there was no free or inexpensive SQL database management implementation available Hughes therefore developed a translation program which provided an SQL interface to the free Postgres DBMS which did not use SQL 3 This product was named miniSQL clarification needed or mSQL In time it became clear that Postgres did not perform adequately on the low specification systems used to run Minerva so mSQL developed into a lightweight database management system in its own right implementing a limited subset of the SQL standard but performing well on minimally specified hardware 4 mSQL was the first low cost SQL based database management system citation needed Combined with the free Linux operating system the availability of relatively powerful low cost PC hardware and the development of World Wide Web standards and technologies mSQL was an important factor in the early development of interactive dynamic web applications 5 particularly in the period 1994 1997 after which it was increasingly supplanted by the more highly featured MySQL mSQL had a large and widespread install base by the late 1990s 6 License editDespite being offered in source code form and being strongly associated with open source software mSQL itself has never been offered under an open source license mSQL is provided free for non commercial use 6 A typical license for commercial use in 1997 would cost 170 5 compared to a five digit purchase price 7 for its full featured competitors Current status editBy 1996 development on mSQL began to stagnate and MySQL arose to fill that void By 1999 MySQL had surpassed mSQL 6 in popularity and today mSQL has less visibility At this time the database system is more often licensed by other companies for use in their products than used by end users directly mSQL is actively maintained and developed primarily to support its licensees and internal use within Hughes Technologies products and projects It is still provided under a license that allows its use free of charge for non commercial educational and charitable activities mSQL 4 4 was released in October 2021 Host languages editmSQL originally supported several host languages C included with the software Perl Java via mSQL JDBC Delphi Tcl PHPSee also editList of relational database management systems Comparison of relational database management systemsReferences edit Hughes Technologies The home of mSQL and Network Knowledge hughestech com au Retrieved 2021 04 19 Minerva An Event Based Model For Extensible Network Management CiteSeerX 10 1 1 48 4006 Yarger Randy Jay Reese George King Tim 1999 MySQL amp mSQL O Reilly p 8 ISBN 1 56592 434 7 Postgres unfortunately came with similar resource requirements as its commercial counterparts without the advantage of SQL as a query language At the time postgres used a variant of the QUEL language called PostQUEL Yarger Randy Jay Reese George King Tim 1999 MySQL amp mSQL O Reilly p 9 ISBN 1 56592 434 7 a b Burkett Scott 1997 Using mSQL in a Web Based Production Environment Linux Journal Retrieved 29 May 2010 a b c Komarinski Mark F Collett Cary 2000 Red Hat Linux system administration handbook Prentice Hall p 203 ISBN 978 0 13 025395 8 Lerner Reuven 1999 Review MySQL amp mSQL Linux Journal Retrieved 29 May 2010 External links editOfficial website Retrieved from https en wikipedia org w index php title MSQL amp oldid 1154278224, wikipedia, wiki, book, books, library,
