[SQLite] SQLite URI Configuration

Get rid of novice documents using SQLAlchemy to configure SQLite, only to find that the URI of SQLite is a bit special.

https://github.com/mitsuhiko/flask-sqlalchemy/issues/469

#Unix/Mac - 4 initial slashes in total
engine = create_engine(‘sqlite:////absolute/path/to/foo.db‘)
#Windows
engine = create_engine(‘sqlite:///C:\\path\\to\\foo.db‘)
#Windows alternative using raw string
engine = create_engine(r‘sqlite:///C:\path\to\foo.db‘)

Note Windows under SQLite is a three-way bar. Because the more common is the configuration document under Linux, it is easy to misunderstand the normal configuration is the four-bar. The actual URI format should be sqlite:///{$path}.

If the slash is wrong, it will error: unable to open the SQLite database file

[SQLite] SQLite URI Configuration