The following code will create my-sqlite.db in the current directory using sqlalchemy:
import sqlalchemy
db = sqlalchemy.create_engine('sqlite:///my-sqlite.db')
Note that you need three slashes in sqlite:/// in order to use a relative path for the DB. If you want an absolute path, use four slashes: sqlite:////.