database.db not appearing in website folder

[SpookySimon]

def create_database(app):
if not path.exists('website/' + DB_NAME):
with app.app_context():
db.create_all()
print('Created Database!')
else:print("Database exists")

Replaced the old app=app and got no errors. However even thow i get the msg Db created i can't seem to see it. When i look for it it appears in website folder but in my Pycharm Community Edition it doesn't appear. I run the main 6-7 times. Every time i got the msg Db created and it still doesn't appear. After some tries a folder called instances pops up and it has the db txt file inside. Important to say that i didn't change anything in the code, just rerun the same code. I got rid of the instances and transfered db under website. Now everything works. Posting this because i didn't see any relavant article. Hope to get some feedback on why this happened. Thank you!

[HasnainRaza026]

The instance folder is a special directory used in Flask applications. It is automatically created when using Flask-SQLAlchemy (or other Flask extensions) to store certain files (that should not be committed to version control), including the SQLite database if a relative file path is set in the SQLALCHEMY_DATABASE_URI.

For example
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///database.db
here we are not specifying the relative file path with the database name, hence Flask will create the instance folder in the project's root

If you don't want that, and wanted the database.db to appear inside the website folder you must include its relative path like so
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////website/database.db'

[SpookySimon]

Thanks for the reply. Yeah later i figured that it was kinda important. I just changed every path from database.db to instance/db.db. If i follow another flask project in the future I'll be ready.