New myvpstest.ovh

My VPS for test Server WEB and Application Web(SPA)

Info: OS Linux: Debian 12, Server SQL:mariadb, Server Web:nodejs

I have been developing softwares skole since 1986

Ringrazio OVH che ospita le mie VPS, permettendomi quest'anno di poter utilizzare il servizio NoSQL tramite MangoDB. Il servizio in cluster con 512Mb di storage completamente gratuito, con una durata illimitata. Questo servizio mi permette di fare pratica con MangoDB integrando anche i Big Data in MyVPS test la mia piccola gestione d'internet delle cose che usa già embedded systems(MySQLClient.py), MyVPS(SQL mariadb), Smarthphone/PC(browsers) e dopo un perido di studio con gli scripts NoSQL(MangoDB) anche i Big Data.

SQLSPA will need via a SQL table to contain HTML graphical elements, CSS style classes end Javascript scripts. The SPA will not be like the one created for desktop HEADER, BODY, FOOTER, but it will have to be similar to a native APP for smartphones. The SQLSPA will contain a SQLTable or a SQLQuery. Due to work commitments I will only start SQLSPA development this summer and only in my spare time.

With this new web server, the DataEntry will not be created in javascript, to be used via the browser, but the SQLDEV functionality will be managed via new client written in python3, this allows it to be used with embedded systems in shared process management.

SPA Single Page Application

LIB List Interactive Button

LIBName simple interface for smartphones

SQLTable easy single table viewer

SQLQuery agile querys use SQL language and exec the SQL Script to server SQL mariadb

accept only SELECT no DROP, CREATE, ALTER, INSERT, UPDATE ect..

SQLDEV to developer with SQL language only for the administrator server SQL mariadb

Name: Search Name of a category order by Name

Categorys: Products, Art, Tecn, Video, Fotos, ect..

JsMediaShow javascript function to open iframe/img

Interactive Button use JsMediaShow(Link, IDFind, Height, Width, IframeImg)

Examples Width and Height: 1280x720 (HD) 1920x1080 (Full HD) 2048x1080 (2K - DLP) 3840x2160 (4K - Ultra HD)

SQLTable:TableName Open the SQLTable

It is possible using MyDBData.js to use existing

standard SQL scripts to be used to clone the company

database used on the LAN server and use it also on the cloud.

$ nodejs MyDBData.js Products y // CREATE TABLE Products (DROP TABLE IF EXISTS) and INSERT/UPDATE records.

$ nodejs MyDBData.js Products n // TABLE Products only INSERT/UPDATE records.

With this my new web server I use the URLs such as SQLTable:TableName which creates

the SQL code "SELECT * FROM SQLTABLE" for open the SQL table.

You can highlight a column or a value present in the SQL table by using SQLTable:ProductsMark:Price in the URL.

Examples of automatic creation of SQL scripts in dynamic mode by entering parameters in the URL:
https://myvpstest.ovh/SQLTable:Products
https://myvpstest.ovh/SQLTable:ProductsMark:Description E
https://myvpstest.ovh/SQLTable:ProductsOrdBy:Price
https://myvpstest.ovh/SQLTable:ProductsMark:Description EOrdBy:Price
All parameters are needed to extract values from a column using Find:
[SQLTable:Products] [Mark:ID] [OrdBy:Description] [Find:Description C] and create the SQL script.
SQL Script = SELECT * FROM [SQLTable] WHERE [OrdByFieldName] LIKE = '%[FindValue]%' ORDER BY [OrdByFieldName]
https://myvpstest.ovh/SQLTable:ProductsMark:Description COrdBy:DescriptionFind:Description C
https://myvpstest.ovh/SQLTable:CategoriesMark:IDOrdBy:CategoryFind:Category G

Examples JsMediaShow and INPUT value:IDFind...?
#input value="100.00", id="IDFindPrice">#/input>#button class="bt" id="Show" onclick="JsMediaShow('https://myvpstest.ovh/SQLTable:ProductsMark:Price:OrdBy:PriceFind:IDFind','IDFindPrice','540', '370','iframe')">Find: Price...#/button>

Example via MultiScripts SQL to add new buttons to LIB interface using the URL.