Description/documentation of SQLALCHEMY_ENGINES config param?

[smontanaro]

I'm new to flask-sqlalchemy-lite (and the non-lite variant). I have an existing Flask app which uses SQLite directly and want to convert to SQLAlchemy to ease transition to a more performant database. Looking here: https://pypi.org/project/Flask-SQLAlchemy-Lite/

I see mention of a SQLALCHEMY_ENGINES configuration variable, but it gives a pretty trivial example. I have yet to find much, if anything, about that variable in the documentation. If nothing else, it would be handy to have a note on the above example page pointing to where that variable is described.

(On a related note, I'm not too much of a JSON or TOML person. I gave up trying to define a useful configuration of that variable in TOML – didn't even try JSON – and resorted to from_pyfile.)

[davidism]

It's described in the docs https://flask-sqlalchemy-lite.readthedocs.io/en/stable/engine/#flask_sqlalchemy_lite.SQLALCHEMY_ENGINES You're looking at the short description about the project on PyPI, which is not intended as documentation.

I don't see anything that says you should use TOML or JSON. Flask's config is really flexible, and its docs go into detail about the many ways to manage config, including defaults, production overrides, etc. https://flask.palletsprojects.com/en/stable/config/#configuring-from-python-files

[smontanaro]

Thanks. My point about TOML and JSON was simply that it was not at all clear how the particular files should be structured for this specific usage, not that I was being forced to use one or the other. In my limited experience with TOML, the files have always looked like INI files with sections and so forth. It wasn't clear to me how the example setting of app.config["SQLALCHEMY_ENGINES"] in code would map onto setting in the TOML file. The doc seems to only document the call to from_file, not what the contents of the file might look like.

Maybe my Google fu just sucks these days, but searching for SQLALCHEMY_ENGINES didn't reveal that page for me. I still think a link to the relevant part of the doc would be helpful here. Just a suggestion though.

[davidism]

Unfortunately can't help with what search engines decide to return. In general, searching the docs will probably return better results than searching Google nowadays.

They would be the same structure as the config dict, so a SQLALCHEMY_ENGINES = {...} entry. TOML supports top-level keys, in JSON you'd need a surrounding {} dict.

[davidism]

For what it's worth, both Duck Duck Go and Kagi return the docs page in the top few results. I was using DDG for quite some time and am now using Kagi, if you do want to try a switch I've never had trouble with either.