From c7815e48781b6d3a457eaff1808d179402558f8c Mon Sep 17 00:00:00 2001 From: 0livd Date: Sun, 6 Aug 2017 04:06:21 +0200 Subject: Fix #248: Database creation issue (#254) In flask's development server, the route handlers run in a different thread than the main thread thus an in-memory database created in the main thread cannot be acccessed by the route handlers. Switching the default database location to a temporary file solves the isssue. See full explanation here: https://gehrcke.de/2015/05/in-memory-sqlite-database-and-flask-a-threading-trap/ --- ihatemoney/default_settings.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'ihatemoney/default_settings.py') diff --git a/ihatemoney/default_settings.py b/ihatemoney/default_settings.py index 4ca11ca..fcb41db 100644 --- a/ihatemoney/default_settings.py +++ b/ihatemoney/default_settings.py @@ -8,7 +8,7 @@ DEBUG = False # The database URI, reprensenting the type of database and how to connect to it. # Enter an absolute path here. -SQLALCHEMY_DATABASE_URI = 'sqlite://' +SQLALCHEMY_DATABASE_URI = 'sqlite:////tmp/ihatemoney.db' SQLACHEMY_ECHO = DEBUG # Will likely become the default value in flask-sqlalchemy >=3 ; could be removed -- cgit v1.1