[GitHub] [airflow] Taragolis commented on issue #29572: Database is Locked -- Even when deleting database and using new airflow home dir

["Taragolis (via GitHub)" <gi...@apache.org>]

Taragolis commented on issue #29572:
URL: https://github.com/apache/airflow/issues/29572#issuecomment-1433284718

   Airflow supports SQLite only for developing purpose.
   
   I would recommend to use [`airflow standalone`](https://airflow.apache.org/docs/apache-airflow/stable/start.html) command in case if you need setup Airflow for quick developing DAGs.
   In case if you feel confident with docker or K8S you could run it on it, some doc:
   - [Running Airflow in Docker](https://airflow.apache.org/docs/apache-airflow/stable/howto/docker-compose/index.html)
   - [Helm Chart for Apache Airflow ](https://airflow.apache.org/docs/helm-chart/stable/index.html)
   
   And also would recommend use any other other [supported backend](https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html#choosing-database-backend), please note if you choose MS SQL Server it is [experimental feature](https://airflow.apache.org/docs/apache-airflow/stable/release-process.html#experimental-features), so better choose PostgreSQL or MySQL 8
   
   And last but not least, with any other database backend rather than SQLite you could use other executors for example if you run on single machine and you do not have intensive tasks you could select [LocalExecutor](https://airflow.apache.org/docs/apache-airflow/stable/core-concepts/executor/local.html), the reason to select other executor pretty simple [SequentialExecutor](https://airflow.apache.org/docs/apache-airflow/stable/core-concepts/executor/sequential.html) not recommended for production usage
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org