[Dxspider-support] Experimental SQL Backend for DXSpider

[Kin]

Hi,

Over the past few weeks, I've been developing and testing an experimental
integration of a relational backend (MariaDB/MySQL) into DXSpider.
This setup allows DXSpider to operate using SQL tables instead of the
traditional flat files and DB_File, providing new possibilities such as:

* Concurrent access to user and badlist data
* Centralised management across multiple nodes
* Easier backup, inspection and modification of data
* Native UTF-8 support via utf8mb4
* Fully compatible interface (get, put, del, etc.)

Currently supported data sets include:

* Users (user_json/users.v3j)
* Baddx / Badspotter / Badnode
* Badwords

A set of migration scripts and patched modules are available to help sysops
experiment with this setup safely and non-intrusively. Only 633 build.

Documentation and code:
https://github.com/EA3CV/dxspider_info/tree/main/MySQL

Important: This is an experimental project. It is recommended only for
sysops with solid Linux and DXSpider knowledge.
There is no automatic fallback, and proper backups should always be in place
before testing.

If there is enough interest, this concept could be proposed to Dirk for
possible upstream integration in a future release - provided it's useful and
robust enough for broader adoption.

Feel free to test it, suggest improvements, or report bugs. Feedback is
welcome.

73 de Kin EA3CV


https://clustermap.cronux.net/map.html
https://github.com/EA3CV/dxspider_info
https://github.com/EA3CV/dxspider_update
DXSpider Channel: t.me/dxspider
https://www.dxcluster.info/telnet/index.php