databases
databases copied to clipboard
encode
Async database support for Python. 🗄
Firstly, great project! There might be a way to access this already but... I'm trying to work out why what looks like a perfectly well formed SQLite query, which works...
I am trying to execute this piece of code and I am stuck on this. `tokens = ['a', 'hello']` `response = await database.fetch_all(query="""select * from word where text ilike any...
```py3 from databases import Database from sqlalchemy import sql from sqlalchemy.dialects.postgresql import array database = Database('postgresql://localhost/example') # This works # SQL Query is: SELECT ARRAY['a', 'b', 'c'] query = sql.select([...
Hey there guys, our database password contains a `#` character and databases doesn't seem to like it 😄 ``` In [25]: url = DatabaseURL("postgresql://username:password%23123@localhost/name") In [26]: url Out[26]: DatabaseURL('postgresql://username:********@localhost/name') In...
I need to deal with databases that automatically rotate passwords for users. This results in connection errors when Database tries to reconnect after the password it used before has been...
Before the release of 0.4.0: We were able to use high available postgres connection string. `postgresql://user:password@host1,host2:port/dbname` After the release of 0.4.0: We are not able to use the high available...
Hello, I have the following code: `self.database = databases.Database(f'{self.db_engine}://{self.db_user}@{self.db_host}:{self.db_port}/{self.db_database}', password=os.getenv("DB_PASS"), min_size=1, max_size=100)` when I execute that, I get the following error in the trace, I am not sure if something...
Session from sqlalchemy [allows](https://docs.sqlalchemy.org/en/13/orm/session_api.html#sqlalchemy.orm.session.sessionmaker.configure) postponed configuration: ```python SessionFactory = sessionmaker() SessionFactory.configure(bind=create_engine('sqlite://')) session_instance = SessionFactory() ``` Maybe `Database` should be also has `configure` method? This allows to create `Database` object at...
It's the continuation of the PR https://github.com/encode/databases/pull/150 (as this PR only implements for mysql and sqlite) for the ticket https://github.com/encode/databases/issues/61 to cover other back-ends.
Hey! Thanks for this awesome library. I'm replacing direct `aiopg` usage with it, but I ran into one issue that I can't seem to solve. When executing a query `aiopg`...
