TxtSQL
Encyclopedia
txtSQL is an object-oriented (OOP
) flat-file database management system
written in PHP
. Working on ordinary text files with increased file-security, it offers support for a small subset of SQL
and is extremely efficient in terms of execution time. txtSQL utilizes a file system similar to that of MySQL
by employing the concept of tables and databases. Furthermore, it does not require any outside plugins just so that txtSQL can operate. There are two levels of operation for developmental purposes; a low-level implementation and a high-level implementation that supports SQL
. txtSQL is an open source
project licensed under the GNU General Public License
(GPL).
Object-oriented programming
Object-oriented programming is a programming paradigm using "objects" – data structures consisting of data fields and methods together with their interactions – to design applications and computer programs. Programming techniques may include features such as data abstraction,...
) flat-file database management system
Database management system
A database management system is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators and other specialists. A database is an integrated...
written in PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
. Working on ordinary text files with increased file-security, it offers support for a small subset of SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
and is extremely efficient in terms of execution time. txtSQL utilizes a file system similar to that of MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
by employing the concept of tables and databases. Furthermore, it does not require any outside plugins just so that txtSQL can operate. There are two levels of operation for developmental purposes; a low-level implementation and a high-level implementation that supports SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
. txtSQL is an open source
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
project licensed under the GNU General Public License
GNU General Public License
The GNU General Public License is the most widely used free software license, originally written by Richard Stallman for the GNU Project....
(GPL).
Features
- Quicker than most other flatfile databaseDatabaseA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
scripts (PHPPHPPHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
). - One can use a small subset of the SQL language
- An admin system similar to phpMyAdminPhpMyAdminphpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and...
is included in the latest stable release (2.2). - Well documented code, with a detailed manual, so it's easy to install and use.
- Extra software or outside plugins are not needed for txtSQL to function.
- True SQLSQLSQL is a programming language designed for managing data in relational database management systems ....
syntax is being developed and will be included in next release (4.0).