[Dxspider-support] Experimental SQL Backend for DXSpider

[Dirk Koopman]

Kin

I would be happy to include this into the distro, but it has to be 
optional (much as the SQL spot DB is) and that the SQL used will work 
for all DBI based "standard SQL" databases (which should include SQLite3).

Thank you for the work you are doing.

Dirk

On 02/07/2025 07:45, Kin via Dxspider-support wrote:
> 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
>
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at tobit.co.uk
> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support