mik-laj commented on pull request #18382: URL: https://github.com/apache/airflow/pull/18382#issuecomment-923486249
I am missing one more element. On [the database configuration](https://github.com/apache/airflow/blob/main/docs/apache-airflow/howto/set-up-database.rst) page, we should add an example URL address. For SQLite, we have the following fragment: > An example URI for the sqlite database: > > sqlite:////home/airflow/airflow.db For MySQL, we have the following fragment: > We recommend using the mysqlclient driver and specifying it in your SqlAlchemy connection string. > > mysql+mysqldb://<user>:<password>@<host>[:<port>]/<dbname> > But we also support the mysql-connector-python driver, which lets you connect through SSL without any cert options provided. > > mysql+mysqlconnector://<user>:<password>@<host>[:<port>]/<dbname> For. PostgresSQL, we have the following fragment: > We recommend using the psycopg2 driver and specifying it in your SqlAlchemy connection string. > > postgresql+psycopg2://<user>:<password>@<host>/<db> Only MSSQL does not include an example URI address for me to be able to. configure the database. SQLAlchemy supports multiple drivers. Which one is the best for production deployment? ``` # pyodbc mssql+pyodbc://scott:tiger@mydsn # pymssql mssql+pymssql://scott:tiger@hostname:port/dbname # mxODBC mssql+mxodbc://<username>:<password>@<dsnname> ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
