How to create a new datebase(named xx.db) using python and sqlite3

Question

import sqlite3

conn = sqlite3.connect(r"D:\aaa.db")

Is there a way to automatically create the db file if it doesn't already exist when I connect to it?

thanks

Answer 1

The code you give does create 'D:\\aaa.db' if it doesn't exist.

Answer 2

Pretty sure .connect will create the file if it doesn't exist.

Answer 3

If it isn't created automatically, make sure that you have the directory permissions correct