I deleted all of the versions I had, including Pycharm, then I reinstalled my 3.11 and Pycharm and immediately encountered a problem where I couldn't reinstall packages using pip because pip wasn't recognized. I installed the new 3.11 and the problems didn't go away. Designed & built in Brighton, England.I had problems with my old python 3.10 (working with pycharm), fetch_all ( query = query ) print ( 'High Scores:', rows )Ĭheck out the documentation on making database queriesįor examples of how to start using databases together with SQLAlchemy core expressions.ĭatabases is BSD licensed code. query = 'SELECT * FROM HighScores' rows = await database. execute_many ( query = query, values = values ) # Run a database query. query = 'INSERT INTO HighScores(name, score) VALUES (:name, :score)' values = await database.

execute ( query = query ) # Insert some data. query = '''CREATE TABLE HighScores (id INTEGER PRIMARY KEY, name VARCHAR(100), score INTEGER)''' await database. from databases import Database database = Database ( 'sqlite+aiosqlite:///example.db' ) await database. # Create a database instance, and connect to it. Note that we want to use ipython here, because it supports using awaitĮxpressions directly from the console.

We can now run a simple example from the console. Note that if you are using any synchronous SQLAlchemy functions such as engine.create_all() or alembic migrations then you still have to install a synchronous DB driver: psycopg2 for PostgreSQL and pymysql for MySQL.įor this example we'll create a very simple SQLite database to run some You can install the required database drivers with: $ pip install databases Sanic, Responder, Quart, aiohttp, Tornado, or FastAPI.

It allows you to make queries using the powerful SQLAlchemy CoreĮxpression language, and provides support for PostgreSQL, MySQL, and SQLite.ĭatabases is suitable for integrating against any async Web framework, such as Starlette, Databases gives you simple asyncio support for a range of databases.

Python 3 install pip