nitricware/nwdatabase

An XML driven simple database solution for projects where SQLite is not available and MySQL seems overpowered.

NWDataBase

Introduction

NWDataBase is an XML-based database system for small databases. It provides a lightweight database solution for webspaces where no SQLite is available. The system provides simple functions, including a search function., _(*1)

License

The NWDataBase system is distributed under the MIT License which allows you to use it privately and commercially, to distribute, modify and sublicense it. You may not hold me liable and must include my name in the credits of your work., _(*2)

NWDataBase was created by Kurt Höblinger aka NitricWare., _(*3)

Dependencies

Unlike version 1.x, NWDatabase 2.x and 3.x does not require any additional packages. PHP Extension ext-dom must be installed, however., _(*4)

Usage

Use Composer to install NWDataBase to your project via the composer require nitricware/nwdatabase command or your composer.json., _(*5)

Alternatively you can also just include all the files from the src/ directory., _(*6)

require("NWDatabase.php");
require("NWDBRecord.php");

use NitricWare\NWDatabase;
use NitricWare\NWDBRecord;

Functions

For information about the functions of the class, please check the documentation inside the .php-file!, _(*7)

With NWDataBase you can:

• Create a database
• Create columns
• Insert records
• Fetch records
• Update records
• Delete records
• Search for records
• Draw an ASCII table with the database content
• Delete a database
• Sort a result by a specified column ascending or descending
• Limit a result to a specified amount and start by a specified offset if desired

Changelog

v3.0 - PHP 8.0 support - makes better use of classes and types, _(*8)

v2.0 - docker support - examples added - PHP 7.4 support - eliminated the need for dependencies, _(*9)

v1.1.1 - fixed composer, _(*10)

v1.1 - added limit parameter to NWDBSearch and NWDBGetRecords - the array structure of NWDBGetRecords has changed to match the structure of NWDBSearch - added the possibility to sort a result - made NWDataBase available to composer, _(*11)

v1.0.2 - bugfixes - whitespace fixes, _(*12)

v1.0.1 - fixed XML layout - using new NWLog 1.0.1, _(*13)

v1.0 - initial release, _(*14)