New VPS being configured... 20/11/2025

New SQLSPA ver.0.2.2026

SQL "Structured Query Language" SPA "Single Page Application"

About SQLSPA...

System: VPS 2026 model VPS-3 provider of datacenter cloud service "ovhcloud"

Backend: server web sqlspa.js "NodeJs" use DBData "RDBMS SQL MariaDB"

Frontend: SQLSPA LIBName "GUI Dynamic", SQLTable, SQLQuery, QChart, SQLForm "Logical View"

Frontend: Examples JsAppName "SPA HTML, CSS and Javascript"

UpLoad Examples SQL table JsApp new SPA INSERT or UPDATE "Authorised users https NodeJs lib formidable"

Management DBData "Authorised users https Run scripts SQL"

IoT "Internet of Things Management DBData ARDUINO, Raspberry Pi and URLSQLClient.pyc "Authorised users https"

LIBName:ListButtonA

List Interactive buttons

SQLTable:Products or SQLTable:ProductsMark:Description EOrdBy:Price DESC

Logical View

SQLQuery:Select * from Products; only SELECT...

Logical View

QChart:Table:ProductsCalc:MAX(Products.Price), MIN(Products.Price), AVG(Products.Price) Title:Chart SQLSPA smartphoneType:PieChart

SQL Script Chart use JOIN:

Example: QChart:Table:ProductsJOIN:INNER JOIN Categories ON Products.IDCategory = Categories.ID INNER JOIN Notes ON Products.IDCategory = Notes.ID Calc:COUNT(Products.ID), COUNT(Categories.ID), COUNT(Notes.ID) Title:SQL QChart MyVPS SQLSPA by skole(1986)

New Features

LOGSqlOpen

Logs Activities during testing

LOGUsers

Logs Authorised Users SQL scripts during testing

JsAppName:JsApp

Javascript Application during testing

SQLForm:Products

Describe Table Products Features under consideration

GoEvent:

GoEvent Features under consideration

Search:

Semantic Search Features under consideration

Os Debian 13

NodeJs ver 20.19.2.

Mariadb ver 11.8.2-MariaDB-1 from Debian