@Marvin I'm using sqlite in dev and wanted to use postgres in production. How can i upgrade without losing data? I couldn't find any resource that would lead in that direction. Can you help?

The resources I found cover different aspects that might be relevant to your question, but nothing directly addressing the migration from SQLite to PostgreSQL with data preservation. Here's what you can do: 1. Database Setup and Configuration: - Set up your PostgreSQL database and ensure you configure your environment to connect to it. - Update your Prefect profile to use PostgreSQL with the following command:

prefect config set PREFECT_API_DATABASE_CONNECTION_URL="<postgresql+asyncpg://postgres:yourTopSecretPassword@localhost:5432/prefect>"

Reference Link 2. Data Migration Strategy: - While Prefect documentation doesn't provide a direct guide for this migration, the general approach involves exporting data from SQLite and importing it into PostgreSQL. Tools like

pgloader

or custom scripts can facilitate this. 3. Managing Migrations: - Prefect uses Alembic for managing migrations. Ensure you run the appropriate migrations after setting up your PostgreSQL:

prefect server database upgrade -y

Reference Link For more tailored advice, searching broader resources on database migration from SQLite to PostgreSQL might be beneficial. Here are some quick links to assist further: - pgloader - SQLite to PostgreSQL on Stack Overflow If you need further assistance or examples, let me know!