yadayada/acd_cli

Request: MySQL / MariaDB support

Open

#312 opened on Apr 17, 2016

View on GitHub
 (6 comments) (1 reaction) (0 assignees)Python (1,360 stars) (173 forks)batch import
cachehelp wanted

Description

In some special use case, I have have to share the same database to multiple acd_cli fuse instances. This makes nodes.db crash very often, and if it does, I will have to manually remove nodes.db then $ acd_cli sync. If there is MySQL / MariaDB support, there will not be database crash problem. Thanks.

Contributor guide

Tech stack
pythonsqlitemysql
Domain
clidatabase
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
4
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
over 1 week
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
PythonSQLiteMySQL/MariaDB basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
15
Research direction
The issue requests switching from SQLite (nodes.db) to MySQL/MariaDB to avoid corruption. Investigate the current database implementation in the acd cli FUSE filesystem, likely in a file like 'acd cli/db.py' or similar. Review existing FUSE projects that support multiple database backends (e.g., rclone). Note that this repository is marked as unmaintained, so any work may require forking. Consider the complexity of abstracting the database layer and the minimal changes needed to support both SQLite and MySQL.