{ "info": { "author": "Tom Christie", "author_email": "tom@tomchristie.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Environment :: Web Environment", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: OS Independent", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Internet :: WWW/HTTP" ], "description": "# Databases\n\n

\n\n \"Build\n\n\n \"Coverage\"\n\n\n \"Package\n\n

\n\nDatabases gives you simple asyncio support for a range of databases.\n\nIt allows you to make queries using the powerful [SQLAlchemy Core][sqlalchemy-core]\nexpression language, and provides support for PostgreSQL, MySQL, and SQLite.\n\nDatabases is suitable for integrating against any async Web framework, such as [Starlette][starlette],\n[Sanic][sanic], [Responder][responder], [Quart][quart], [aiohttp][aiohttp], [Tornado][tornado], [FastAPI][fastapi], or [Bocadillo][bocadillo].\n\n**Documentation**: [https://www.encode.io/databases/](https://www.encode.io/databases/)\n\n**Community**: [https://discuss.encode.io/c/databases](https://discuss.encode.io/c/databases)\n\n**Requirements**: Python 3.6+\n\n---\n\n## Installation\n\n```shell\n$ pip install databases\n```\n\nYou can install the required database drivers with:\n\n```shell\n$ pip install databases[postgresql]\n$ pip install databases[mysql]\n$ pip install databases[sqlite]\n```\n\nDriver support is providing using one of [asyncpg][asyncpg], [aiomysql][aiomysql], or [aiosqlite][aiosqlite].\n\n---\n\n## Quickstart\n\nFor this example we'll create a very simple SQLite database to run some\nqueries against.\n\n```shell\n$ pip install databases[sqlite]\n$ pip install ipython\n```\n\nWe can now run a simple example from the console.\n\nNote that we want to use `ipython` here, because it supports using `await`\nexpressions directly from the console.\n\n```python\n# Create a database instance, and connect to it.\nfrom databases import Database\ndatabase = Database('sqlite:///example.db')\nawait database.connect()\n\n# Create a table.\nquery = \"\"\"CREATE TABLE HighScores (id INTEGER PRIMARY KEY, name VARCHAR(100), score INTEGER)\"\"\"\nawait database.execute(query=query)\n\n# Insert some data.\nquery = \"INSERT INTO HighScores(name, score) VALUES (:name, :score)\"\nvalues = [\n {\"name\": \"Daisy\", \"score\": 92},\n {\"name\": \"Neil\", \"score\": 87},\n {\"name\": \"Carol\", \"score\": 43},\n]\nawait database.execute_many(query=query, values=values)\n\n#\u00a0Run a database query.\nquery = \"SELECT * FROM HighScores\"\nrows = await database.fetch_all(query=query)\nprint('High Scores:', rows)\n```\n\nCheck out the documentation on [making database queries](https://www.encode.io/databases/database_queries/)\nfor examples of how to start using databases together with SQLAlchemy core expressions.\n\n\n

— \u2b50\ufe0f —

\n

Databases is BSD licensed code. Designed & built in Brighton, England.

\n\n[sqlalchemy-core]: https://docs.sqlalchemy.org/en/latest/core/\n[sqlalchemy-core-tutorial]: https://docs.sqlalchemy.org/en/latest/core/tutorial.html\n[alembic]: https://alembic.sqlalchemy.org/en/latest/\n[asyncpg]: https://github.com/MagicStack/asyncpg\n[aiomysql]: https://github.com/aio-libs/aiomysql\n[aiosqlite]: https://github.com/jreese/aiosqlite\n\n[starlette]: https://github.com/encode/starlette\n[sanic]: https://github.com/huge-success/sanic\n[responder]: https://github.com/kennethreitz/responder\n[quart]: https://gitlab.com/pgjones/quart\n[aiohttp]: https://github.com/aio-libs/aiohttp\n[tornado]: https://github.com/tornadoweb/tornado\n[fastapi]: https://github.com/tiangolo/fastapi\n[bocadillo]: https://github.com/bocadilloproject/bocadillo", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/encode/databases", "keywords": "", "license": "BSD", "maintainer": "", "maintainer_email": "", "name": "databases", "package_url": "https://pypi.org/project/databases/", "platform": "", "project_url": "https://pypi.org/project/databases/", "project_urls": { "Homepage": "https://github.com/encode/databases" }, "release_url": "https://pypi.org/project/databases/0.2.5/", "requires_dist": null, "requires_python": ">=3.6", "summary": "Async database support for Python.", "version": "0.2.5" }, "last_serial": 5506389, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "72466c205128ac9d66acfae88a30db9e", "sha256": "d38434b1b6b9cfb6eb0af536d4a6f6166d5d8522be85f78fa26ba7ff09412ae0" }, "downloads": -1, "filename": "databases-0.0.1.tar.gz", "has_sig": false, "md5_digest": "72466c205128ac9d66acfae88a30db9e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5055, "upload_time": "2019-02-01T10:45:06", "url": "https://files.pythonhosted.org/packages/77/55/23019c441bfe37a58a31956f543ed5f5e7234a955f82decb5b23103a07f8/databases-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "83eea467700abb42b4a13c80799a218f", "sha256": "f185af1ba7393523ee4e2c45c28617c101fbf8cd92e19c4abd031ed4604510e4" }, "downloads": -1, "filename": "databases-0.0.2.tar.gz", "has_sig": false, "md5_digest": "83eea467700abb42b4a13c80799a218f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7136, "upload_time": "2019-02-07T17:15:43", "url": "https://files.pythonhosted.org/packages/be/89/957bbabeb09c41eb7819f833bd5c959e6bf778f04813036fce31c8aa8d3d/databases-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "a902f939749c3c8901d21ce47a251ee6", "sha256": "97e2637d3985a3450703acf0edc192f359d3b3105a309efab50984e085825046" }, "downloads": -1, "filename": "databases-0.0.3.tar.gz", "has_sig": false, "md5_digest": "a902f939749c3c8901d21ce47a251ee6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7164, "upload_time": "2019-02-08T10:25:04", "url": "https://files.pythonhosted.org/packages/61/8b/0a89d100c103fa708d6a56b1c12fa835d77e39785b3bfcbfc96c9f3d917a/databases-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "6a9c795fc9b03ee0350e1d87e126f18b", "sha256": "6f8502f240859420a96d2b9b3953b1eef440ea08dfe5c61c2e9552c37a989353" }, "downloads": -1, "filename": "databases-0.0.4.tar.gz", "has_sig": false, "md5_digest": "6a9c795fc9b03ee0350e1d87e126f18b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7413, "upload_time": "2019-02-08T10:45:47", "url": "https://files.pythonhosted.org/packages/e4/e5/bf645a2d1d0c58eab0a771dd0241f65375daa5b89b8ddc9c8721f2f34914/databases-0.0.4.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "916165047e54ef45af6320fed8dc93f7", "sha256": "3c57bc1efdcab583cb7fd7a507b4b8dd089a85d633436002a7f30c8b7800e51f" }, "downloads": -1, "filename": "databases-0.1.0.tar.gz", "has_sig": false, "md5_digest": "916165047e54ef45af6320fed8dc93f7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8638, "upload_time": "2019-02-08T17:07:38", "url": "https://files.pythonhosted.org/packages/79/e1/5f54816b80c5ec49917e76e29840c7977e5ae107a0f8cdbf491ad87d869a/databases-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "3ed83ec5d3d71045a3f917a715b374a5", "sha256": "979d01b794078c13fd1ecc9463e9e50783e45b6e8d3e5049664e551b1ca96771" }, "downloads": -1, "filename": "databases-0.1.1.tar.gz", "has_sig": false, "md5_digest": "3ed83ec5d3d71045a3f917a715b374a5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9744, "upload_time": "2019-02-11T09:58:37", "url": "https://files.pythonhosted.org/packages/c3/6b/374e9e7ae040f7d97561f8ac7023dd6b5255ca145c18ef8e5c70872e077b/databases-0.1.1.tar.gz" } ], "0.1.10": [ { "comment_text": "", "digests": { "md5": "2c0ad10781b662a64286e9d18cf3367b", "sha256": "49fd0d2f75970d34d9b0bb0f5c61a0a1b5e945f6f7a79646c5fe998c3f46537f" }, "downloads": -1, "filename": "databases-0.1.10.tar.gz", "has_sig": false, "md5_digest": "2c0ad10781b662a64286e9d18cf3367b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 15360, "upload_time": "2019-03-04T14:15:33", "url": "https://files.pythonhosted.org/packages/c2/5e/54181c56ce39a168b965dbffc15a52cff732519b647a04381bac5073a09f/databases-0.1.10.tar.gz" } ], "0.1.11": [ { "comment_text": "", "digests": { "md5": "8087b0378a68b0915d19ef3c6c8fdc12", "sha256": "c47ea5b6fb942067b5632fd78960f45ae654f194c2bd7a3e781d1df5e5849f46" }, "downloads": -1, "filename": "databases-0.1.11.tar.gz", "has_sig": false, "md5_digest": "8087b0378a68b0915d19ef3c6c8fdc12", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 15423, "upload_time": "2019-03-05T13:31:43", "url": "https://files.pythonhosted.org/packages/10/0b/a774ce80d5c0c9e5b58811096c85909f985361d43055061ab5e1ef380ca8/databases-0.1.11.tar.gz" } ], "0.1.12": [ { "comment_text": "", "digests": { "md5": "d75fb294642adaf253c80920e1bf8caa", "sha256": "bb33c2334ac1ed83eee3a25261d0ee7d05ce7a6362cac1c7dab6e522819a7e85" }, "downloads": -1, "filename": "databases-0.1.12.tar.gz", "has_sig": false, "md5_digest": "d75fb294642adaf253c80920e1bf8caa", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 15456, "upload_time": "2019-03-11T16:14:14", "url": "https://files.pythonhosted.org/packages/86/b3/fd9fc0b93e307abb259449f750941cf9398abf01093b537d3e8092dc619c/databases-0.1.12.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "7de561b15f717513f0927504774cdd08", "sha256": "469e52ff954ec9f84dff18f7cd849c209c8497dfb06cc3feddde465410c07cf8" }, "downloads": -1, "filename": "databases-0.1.2.tar.gz", "has_sig": false, "md5_digest": "7de561b15f717513f0927504774cdd08", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11072, "upload_time": "2019-02-12T20:30:39", "url": "https://files.pythonhosted.org/packages/fa/5b/2e1d2b32dc71f8da0a90ce97e8b3b9420a2f39d504e846c40045171813ea/databases-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "93949861da95bb74bc7931b5e91204c6", "sha256": "8d4aab25cd8a6ca54bb1ce424927154aed73312a273e2b9be943e151b2ee0f3b" }, "downloads": -1, "filename": "databases-0.1.3.tar.gz", "has_sig": false, "md5_digest": "93949861da95bb74bc7931b5e91204c6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13122, "upload_time": "2019-02-14T13:03:12", "url": "https://files.pythonhosted.org/packages/22/b8/14a3c9c64a659ddb1d1fd4598000624b608ac6d3dd2b2f51bc2a3c9e8fa9/databases-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "448b0be14a482274c03134e7e2807ccb", "sha256": "0bd10cff1f073ae5d5354eb95d4d5d7f436516ce48dc5d10a7d80a785f77efee" }, "downloads": -1, "filename": "databases-0.1.4.tar.gz", "has_sig": false, "md5_digest": "448b0be14a482274c03134e7e2807ccb", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 13814, "upload_time": "2019-02-14T15:08:32", "url": "https://files.pythonhosted.org/packages/68/17/bd97c82c88171d8354690e654bba743f372bef15bbe975d3e3be922c57e6/databases-0.1.4.tar.gz" } ], "0.1.5": [ { "comment_text": "", "digests": { "md5": "2eed1ece40babc5759e2446c063b6766", "sha256": "2164b60210729badcf170f24e37cd51265e271b504dd5608cc46c79761b3bf22" }, "downloads": -1, "filename": "databases-0.1.5.tar.gz", "has_sig": false, "md5_digest": "2eed1ece40babc5759e2446c063b6766", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 14751, "upload_time": "2019-02-18T10:13:10", "url": "https://files.pythonhosted.org/packages/67/70/3ebc2ae0fe948f70b5e7fddaf821a67b146ba37989bdf5225393f10a97db/databases-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "", "digests": { "md5": "af9a56153914825f6286ddec3c3d7ac0", "sha256": "85dfaff2e8ab378b23374ea22b178c39c227dc07218c6bd0d6d4dfc86c0152bc" }, "downloads": -1, "filename": "databases-0.1.6.tar.gz", "has_sig": false, "md5_digest": "af9a56153914825f6286ddec3c3d7ac0", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 14789, "upload_time": "2019-02-19T16:18:27", "url": "https://files.pythonhosted.org/packages/ac/09/b733aece81ee1db8bfc95ae561ae8eed92fcaedced9973f7d3f364667ac5/databases-0.1.6.tar.gz" } ], "0.1.7": [ { "comment_text": "", "digests": { "md5": "3f8aeb18cce0a3238c13507c88b1fa04", "sha256": "a15e36b16b57d5ce227e2fef4c706a014c005d22d3a86275325f34511fa4c7e8" }, "downloads": -1, "filename": "databases-0.1.7.tar.gz", "has_sig": false, "md5_digest": "3f8aeb18cce0a3238c13507c88b1fa04", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 15113, "upload_time": "2019-02-21T10:40:20", "url": "https://files.pythonhosted.org/packages/b4/d2/3cbb72b9910eb329432bf7952c2964059d838834cb562b3bbb5eabf7a6b6/databases-0.1.7.tar.gz" } ], "0.1.8": [ { "comment_text": "", "digests": { "md5": "9768b78d3cccc1fe30b99bec92f07890", "sha256": "005f8c181278282dc89482e1b88a90e4f74427bfe8d4fc219531dd4173af7ed1" }, "downloads": -1, "filename": "databases-0.1.8.tar.gz", "has_sig": false, "md5_digest": "9768b78d3cccc1fe30b99bec92f07890", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 15205, "upload_time": "2019-02-25T10:05:46", "url": "https://files.pythonhosted.org/packages/38/0b/5cbfdece00f2eccf10c83165c96ef90fbca6f75a8cf0ec5177eeebee2c77/databases-0.1.8.tar.gz" } ], "0.1.9": [ { "comment_text": "", "digests": { "md5": "de3e591f4f1c26b447175e8e5493a13e", "sha256": "b50409c597cc9bbb4c8203ad98361bf5e8b61d8b178c7b8ffaa5e45f3103babd" }, "downloads": -1, "filename": "databases-0.1.9.tar.gz", "has_sig": false, "md5_digest": "de3e591f4f1c26b447175e8e5493a13e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 15296, "upload_time": "2019-02-26T14:20:34", "url": "https://files.pythonhosted.org/packages/1e/60/12d2b10a1a268e67abbe3e06ee307144a477bffeef340c947ccbe00469b1/databases-0.1.9.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "3d88aac0e6e8ca7b2c68dc9e83bbccfb", "sha256": "4a0f15669c390a04b439972426350c0ae921ddc08c42bd54f125eb2fb86ee728" }, "downloads": -1, "filename": "databases-0.2.0.tar.gz", "has_sig": false, "md5_digest": "3d88aac0e6e8ca7b2c68dc9e83bbccfb", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 16253, "upload_time": "2019-03-22T12:26:57", "url": "https://files.pythonhosted.org/packages/1b/ae/0148a0f12a5a0f2e9f93eaacb9cc7fc1208cdd5e2bfb53204d0d5b06d770/databases-0.2.0.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "fdd70e0c73bfa7f7814be2f7e4a5b293", "sha256": "da819f7e00dc7d8c2f0585ec53aa49bae63b366f800506097db2e87972a4d44f" }, "downloads": -1, "filename": "databases-0.2.1.tar.gz", "has_sig": false, "md5_digest": "fdd70e0c73bfa7f7814be2f7e4a5b293", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 16299, "upload_time": "2019-03-27T14:37:02", "url": "https://files.pythonhosted.org/packages/f5/0b/e4959843279b6e8ebe638f9f52f4fb403c33ae621f3fbd5b6a8c973c7752/databases-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "6496c9f15151db6c60a600f0522fcc67", "sha256": "d365cff2035c5177ef5fd8c5abf6671da01189521da64848a01251c870daf48f" }, "downloads": -1, "filename": "databases-0.2.2.tar.gz", "has_sig": false, "md5_digest": "6496c9f15151db6c60a600f0522fcc67", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 16635, "upload_time": "2019-04-17T12:37:12", "url": "https://files.pythonhosted.org/packages/a3/43/edeab5f48c0e725c542d230566d3451b404779d2bcd337d18ca6a71c7517/databases-0.2.2.tar.gz" } ], "0.2.3": [ { "comment_text": "", "digests": { "md5": "eca0d7f3faac42fc77b999d8fd7b2d48", "sha256": "264c50471f86488d58cfd32470ae302ac32b0cfc99bbf2a5e3d84dc594ad2523" }, "downloads": -1, "filename": "databases-0.2.3.tar.gz", "has_sig": false, "md5_digest": "eca0d7f3faac42fc77b999d8fd7b2d48", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 12992, "upload_time": "2019-06-25T15:32:06", "url": "https://files.pythonhosted.org/packages/b6/73/5db4c367f94334b280a179d47650c7d09c55e0b7dba4628d8880e7251d5f/databases-0.2.3.tar.gz" } ], "0.2.4": [ { "comment_text": "", "digests": { "md5": "250508996590a40d6c0427384785f15d", "sha256": "5ee753cc8ff8956c08f1d859c450d9f615f4a0cd30a5f586e278c5144fae5f5b" }, "downloads": -1, "filename": "databases-0.2.4.tar.gz", "has_sig": false, "md5_digest": "250508996590a40d6c0427384785f15d", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 13018, "upload_time": "2019-07-09T10:59:03", "url": "https://files.pythonhosted.org/packages/55/9f/a8c302c605d046ff23f6317f81cd7fe84bce22243e62ada254a9586b2749/databases-0.2.4.tar.gz" } ], "0.2.5": [ { "comment_text": "", "digests": { "md5": "dab8f69100dce54507bac8c08179244e", "sha256": "1e3b21a237d8b8a8774da1237fa75e951e23bf8e943516df8fe2443f1968287f" }, "downloads": -1, "filename": "databases-0.2.5.tar.gz", "has_sig": false, "md5_digest": "dab8f69100dce54507bac8c08179244e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 13032, "upload_time": "2019-07-09T11:17:16", "url": "https://files.pythonhosted.org/packages/e2/46/fa109103549076ccf17357abd3c0229fd73b7fcc7972f5feaafcb6f67a8f/databases-0.2.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "dab8f69100dce54507bac8c08179244e", "sha256": "1e3b21a237d8b8a8774da1237fa75e951e23bf8e943516df8fe2443f1968287f" }, "downloads": -1, "filename": "databases-0.2.5.tar.gz", "has_sig": false, "md5_digest": "dab8f69100dce54507bac8c08179244e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 13032, "upload_time": "2019-07-09T11:17:16", "url": "https://files.pythonhosted.org/packages/e2/46/fa109103549076ccf17357abd3c0229fd73b7fcc7972f5feaafcb6f67a8f/databases-0.2.5.tar.gz" } ] }