SheerPower4GL

Last updated

SheerPower 4GL is a fourth-generation programming language developed by Touch Technologies, Inc. [1] SheerPower 4GL is the result of porting Touch Technologies' Intouch 4GL programming language that runs on OpenVMS (for DEC Alpha and VAX computers) to Windows, launching in 2000. Downloads are free from the official SheerPower 4GL website. [2] SheerPower 4GL is similar to the BASIC programming language, and is easy to learn.

Contents

Features

SheerPower 4GL has several key features:

It is free for hobbyists and non-profit organizations.

Web scripting features make it fast and easy to develop dynamic web pages using SheerPower's BASIC-like syntax. [3] Version 5.0 was the official release containing the syntax and logic for web scripting in SheerPower.

SheerPower utilizes a "Perfect Precision Math Package" [4] for which the patent 7149765 "Apparatus and method for precision binary numbers and numerical operations" [5] is applied to. This precision math eliminates the rounding off errors experienced when using a floating point data type. [6]

SheerPower comes bundled with ARS – Advanced Record System database engine. [7] ARS is a proprietary database engine also developed by Touch Technologies, Inc. TTI created the ARS engine because performance is critical in many applications. For example, ARS is over 20 times faster than MySQL for shared read/write operations.[ citation needed ]

Open Database Connectivity - SheerPower supports other database engines through its ODBC interface, and its own ARS engine can be accessed via ODBC in other database applications.[ citation needed ]

SheerPower Internet Services (SPINS) Webserver also comes bundled with SheerPower 4GL. The SPINS Webserver comes bundled with SheerPower and was developed for simplicity in use and high-speed for performance. On a modern multi-core system, the SPINS web server can perform over 1,000 page hits per second—given enough bandwidth of course.[ citation needed ]

There is also a Common Gateway Interface (CGI) interface built into SheerPower, along with many other built-in functions designed for high-performance and increased programmer productivity.[ citation needed ]

Security

SheerPower 4GL has the following built-in security features:

A SheerPower program cannot be run from any Windows Temporary folder. This stops computer viruses written into SheerPower programs from being emailed and run when the email is opened.[ citation needed ]

SheerPower does not mix data and code during database operation, which makes it impervious to SQL injection attacks.[ citation needed ]

Platforms

A binary distribution is available for Microsoft Windows NT, 2000, 2003, XP and Vista. The virtual machine can be downloaded alone for the purpose of running .SPSRC or .SPRUN programs (SheerPower source code files or deployed files with the code encrypted).[ citation needed ]

License

The software is free for non-commercial use, its terms undefined besides levels of support for business customers. [8] Non-profit organizations and hobbyist programmers can use the free license that comes with the download. License fees are outlined for those wanting to develop applications for commercial or business use. High-priority support packages are available. Email and web forum support is available at no charge. Sheerpower is 100% free for all uses including commercial purposes. [9]

Related Research Articles

A fourth-generation programming language (4GL) is a high-level computer programming language that belongs to a class of languages envisioned as an advancement upon third-generation programming languages (3GL). Each of the programming language generations aims to provide a higher level of abstraction of the internal computer hardware details, making the language more programmer-friendly, powerful, and versatile. While the definition of 4GL has changed over time, it can be typified by operating more with large collections of information at once rather than focusing on just bits and bytes. Languages claimed to be 4GL may include support for database management, report generation, mathematical optimization, GUI development, or web development. Some researchers state that 4GLs are a subset of domain-specific languages.

<span class="mw-page-title-main">Microsoft Access</span> Database manager part of the Microsoft Office package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

Gecko is a browser engine developed by Mozilla. It is used in the Firefox browser, the Thunderbird email client, and many other projects.

ScriptBasic is a scripting language variant of BASIC. The source of the interpreter is available as a C program under the LGPL license.

In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.

Informix-4GL is a 4GL programming language developed by Informix during the mid-1980s. At the time of its initial release in 1986, supported platforms included Microsoft Xenix, DEC Ultrix, Altos 2086, AT&T 3B2, AT&T 3B5, AT&T 3B20 and AT&T Unix PC.

FileMaker is a cross-platform relational database application from Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify a database by dragging new elements into layouts, screens, or forms. It is available in desktop, server, iOS and web-delivery configurations.

Clarion is a commercial, proprietary, fourth-generation programming language (4GL), multi-paradigm, programming language and integrated development environment (IDE) from SoftVelocity used to program database applications. It is compatible with indexed sequential access method (ISAM), Structured Query Language (SQL), and ActiveX Data Objects (ADO) data access methods, reads and writes several flat file desktop database formats including ASCII, comma-separated values (CSV), DOS (binary), FoxPro, Clipper, dBase, and some relational databases via ODBC, Microsoft SQL Server, Sybase SQL Anywhere, and Oracle Database through the use of accelerated native database drivers, and XML, Clarion can be used to output to HTML, XML, plain text, and Portable Document Format (PDF), among others.

DataFlex is an object-oriented high-level programming language and a fourth generation visual tool for developing Windows, web and mobile software applications on one framework-based platform. It was introduced and developed by Data Access Corporation beginning in 1982.

newLISP

newLISP is a scripting language which is a dialect of the Lisp family of programming languages. It was designed and developed by Lutz Mueller. Because of its small resource requirements, newLISP is excellent for embedded systems applications. Most of the functions you will ever need are already built in. This includes networking functions, support for distributed and multicore processing, and Bayesian statistics. newLISP is free and open-source software released under the GNU General Public License, version 3 or later.

Core Data is an object graph and persistence framework provided by Apple in the macOS and iOS operating systems. It was introduced in Mac OS X 10.4 Tiger and iOS with iPhone SDK 3.0. It allows data organized by the relational entity–attribute model to be serialized into XML, binary, or SQLite stores. The data can be manipulated using higher level objects representing entities and their relationships. Core Data manages the serialized version, providing object lifecycle and object graph management, including persistence. Core Data interfaces directly with SQLite, insulating the developer from the underlying SQL.

Forté 4GL was a proprietary application server that was developed by Forté Software and used for developing scalable, highly available, enterprise applications.

Simba Technologies Inc. is a software company based in Vancouver, British Columbia, Canada. Simba specializes in products for ODBC, JDBC, OLE DB for OLAP (ODBO) and XML for Analysis (XMLA). The company licenses data connectivity technologies, and provides software development for Microsoft Windows, Linux, UNIX, Mac and mobile device platforms. Simba Technologies was founded as PageAhead Software in Vancouver and Seattle, Washington in 1991 and changed its name in 1995. Customers include Microsoft, Oracle Corporation, MIS AG, SAP AG and Descisys.

FAME is a time series database released in 1981 and owned by FIS Global.

In computing, quadruple precision is a binary floating-point–based computer number format that occupies 16 bytes with precision at least twice the 53-bit double precision.

CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by CUBRID Corp. for OLTP. The name CUBRID is a combination of the two words cube and bridge, cube standing for a space for data and bridge standing for data bridge.

FastCGI is a binary protocol for interfacing interactive programs with a web server. It is a variation on the earlier Common Gateway Interface (CGI). FastCGI's main aim is to reduce the overhead related to interfacing between web server and CGI programs, allowing a server to handle more web page requests per unit of time.

<span class="mw-page-title-main">Mono (software)</span> Computer software project

Mono is a free and open-source .NET Framework-compatible software framework. Originally by Ximian, it was later acquired by Novell, and is now being led by Xamarin, a subsidiary of Microsoft and the .NET Foundation. Mono can be run on many software systems.

References

  1. "Touch Technologies Inc". www.ttinet.com. Retrieved 2021-09-15.
  2. "Sheerpower". www.sp4gl.com. Retrieved 2021-09-15.
  3. "SheerPower 4GL". 2017-02-27. Archived from the original on 2017-02-27. Retrieved 2021-09-15.
  4. "SheerPower 4GL's Perfect Precision Math". 2017-02-27. Archived from the original on 2017-02-27. Retrieved 2021-09-15.
  5. "United States Patent: 7149765 - Apparatus and method for precision binary numbers and numerical operations".
  6. "General Decimal Arithmetic".
  7. "SheerPower 4GL". 2017-02-27. Archived from the original on 2017-02-27. Retrieved 2021-09-15.
  8. "SheerPower 4GL License & Support Options". 2017-02-27. Archived from the original on 2017-02-27. Retrieved 2021-09-15.
  9. "Sheerpower Programming Language" . Retrieved 2023-10-23.