[Dxspider-support] Experimental SQL Backend for DXSpider

[Kin]

Dirk,

I will try to adapt the different modules to include SQLite3 along with the
other SQLs.
It will take some time.
I'll let you know.

Kin

-----Mensaje original-----
De: Dxspider-support <dxspider-support-bounces at tobit.co.uk> En nombre de
Dirk Koopman via Dxspider-support
Enviado el: miércoles, 2 de julio de 2025 15:00
Para: Kin via Dxspider-support <dxspider-support at tobit.co.uk>
CC: Dirk Koopman <djk at tobit.co.uk>
Asunto: Re: [Dxspider-support] Experimental SQL Backend for DXSpider

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


_______________________________________________
Dxspider-support mailing list
Dxspider-support at tobit.co.uk
https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support