How can I back up my database in a Python web application?

How can I back up my database in a Python web application?

You can use libraries like SQLAlchemy or Django ORM to manage your database. Would you like a code example?

Yes, please provide a code example for backing up a PostgreSQL database.

Sure! You can use the pg_dump command in a subprocess. Here's a sample code snippet:

import subprocess

def backup_database(db_name, backup_file):
    command = f'pg_dump {db_name} > {backup_file}'
    subprocess.run(command, shell=True)

This will create a backup of your PostgreSQL database.

What if I'm using SQLite instead?

For SQLite, you can simply copy the database file. Here's how:

import shutil

def backup_sqlite_database(db_file, backup_file):
    shutil.copy(db_file, backup_file)

This will create a backup of your SQLite database file.