MSQL

Last updated
Mini SQL or mSQL
Developer(s) Hughes Technologies
Stable release
4.4 / October 20, 2021;18 months ago (2021-10-20) [1]
Written in C
Operating system Cross-platform
Available inEnglish
Type RDBMS
License Proprietary
Website www.hughestech.com.au/products/msql/

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

Contents

History

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]

License

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 status

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.

Host languages

mSQL originally supported several host languages:

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">Object database</span> Type of database management system

An object database or object-oriented database is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are different from relational databases which are table-oriented. A third type, object–relational databases, is a hybrid of both approaches.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.

Structured Query Language, abbreviated as SQL, is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables.

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation.

A database server is a server which uses a database application that provides database services to other computer programs or to computers, as defined by the client–server model. Database management systems (DBMSs) frequently provide database-server functionality, and some database management systems rely exclusively on the client–server model for database access.

In computing, a solution stack or software stack is a set of software subsystems or components needed to create a complete platform such that no additional software is needed to support applications. Applications are said to "run on" or "run on top of" the resulting platform.

<span class="mw-page-title-main">LAMP (software bundle)</span> Acronym for a common web hosting solution

LAMP is an acronym denoting one of the most common software stacks for many of the web's most popular applications. However, LAMP now refers to a generic software stack model and its components are largely interchangeable.

The acronyms BAPP and BAMP refer to a set of open-source software programs commonly used together to run dynamic websites or servers. This set is a solution stack, and an open source web platform.

<span class="mw-page-title-main">Silverstripe CMS</span> Content management system

Silverstripe CMS is a free and open source content management system (CMS) and framework for creating and maintaining websites and web applications. It provides an out of the box web-based administration panel that enables users to make modifications to parts of the website, which includes a WYSIWYG website editor. The core of the software is Silverstripe Framework, a PHP Web application framework.

<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

Polyhedra is a family of relational database management systems offered by ENEA AB, a Swedish company. The original version of Polyhedra was an in-memory database management system which could be used in high availability configurations; in 2006 Polyhedra Flash DBMS was introduced to allow databases to be stored in flash memory. All versions employ the client–server model to ensure the data are protected from misbehaving application software, and they use the same SQL, ODBC and type-4 JDBC interfaces. Polyhedra is targeted primarily for embedded use by Original Equipment Manufacturers (OEMs), and big-name customers include Ericsson, ABB, Emerson, Lockheed Martin, United Utilities and Siemens AG.

<span class="mw-page-title-main">Greenplum</span>

Greenplum is a big data technology based on MPP architecture and the Postgres open source database technology. The technology was created by a company of the same name headquartered in San Mateo, California around 2005. Greenplum was acquired by EMC Corporation in July 2010.

<span class="mw-page-title-main">Michael Stonebraker</span> American computer scientist (born 1943)

Michael Ralph Stonebraker is a computer scientist specializing in database systems. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational databases. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. For his contributions to database research, Stonebraker received the 2014 Turing Award, often described as "the Nobel Prize for computing."

Hyper Text Structured Query Language (HTSQL) is a schema-driven URI-to-SQL query language that takes a request over HTTP, converts it to a SQL query, executes the query against a database, and returns the results in a format best suited for the user agent The HTSQL language is implemented on "HTSQL servers," which use HTSQL to convert web requests into equivalent SQL, executes requests on a server-side database, and returns results in XML, HTML, CSV, JSON, or YAML formats. The current implementation as of April 2010 uses Python and works with PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server databases.

QUEL is a relational database query language, based on tuple relational calculus, with some similarities to SQL. It was created as a part of the Ingres DBMS effort at University of California, Berkeley, based on Codd's earlier suggested but not implemented Data Sub-Language ALPHA. QUEL was used for a short time in most products based on the freely available Ingres source code, most notably in an implementation called POSTQUEL supported by POSTGRES. As Oracle and DB2 gained market share in the early 1980s, most companies then supporting QUEL moved to SQL instead. QUEL continues to be available as a part of the Ingres DBMS, although no QUEL-specific language enhancements have been added for many years.

The following outline is provided as an overview of and topical guide to MySQL:

<span class="mw-page-title-main">DBeaver</span> Multi-platform database administration software

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

<span class="mw-page-title-main">YugabyteDB</span> Transactional distributed SQL database

YugabyteDB is a high-performance transactional distributed SQL database for cloud-native applications, developed by Yugabyte.

References

  1. ↑ "Hughes Technologies : The home of mSQL and Network Knowledge". hughestech.com.au. Retrieved 2021-04-19.
  2. ↑ "Minerva : An Event Based Model For Extensible Network Management". CiteSeerX   10.1.1.48.4006 .
  3. ↑ Yarger, Randy Jay; Reese, George; King, Tim (1999). MySQL & 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"
  4. ↑ Yarger, Randy Jay; Reese, George; King, Tim (1999). MySQL & mSQL. O'Reilly. p.  9. ISBN   1-56592-434-7.
  5. 1 2 Burkett, Scott (1997). "Using mSQL in a Web-Based Production Environment". Linux Journal. Retrieved 29 May 2010.
  6. 1 2 3 Komarinski, Mark F.; Collett, Cary (2000). Red Hat Linux system administration handbook. Prentice Hall. p. 203. ISBN   978-0-13-025395-8.
  7. ↑ Lerner, Reuven (1999). "Review: MySQL & mSQL". Linux Journal. Retrieved 29 May 2010.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.