{ "info": { "author": "John Reese", "author_email": "john@noswap.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Framework :: AsyncIO", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Software Development :: Libraries" ], "description": "aiosqlite\n=========\n\nAsyncIO bridge to the standard `sqlite3` module for Python 3.5+\n\n[![build status](https://travis-ci.org/jreese/aiosqlite.svg?branch=master)](https://travis-ci.org/jreese/aiosqlite)\n[![code coverage](https://img.shields.io/codecov/c/github/jreese/aiosqlite/master.svg)](https://codecov.io/gh/jreese/aiosqlite)\n[![pypi release](https://img.shields.io/pypi/v/aiosqlite.svg)](https://pypi.org/project/aiosqlite)\n[![MIT license](https://img.shields.io/pypi/l/aiosqlite.svg)](https://github.com/jreese/aiosqlite/blob/master/LICENSE)\n[![code style black](https://img.shields.io/badge/code%20style-black-000000.svg)](https://github.com/ambv/black)\n\n\nInstall\n-------\n\naiosqlite is compatible with Python 3.5 and newer.\nYou can install it from PyPI with the following command:\n\n $ pip install aiosqlite\n\n\nUsage\n-----\n\naiosqlite replicates the standard `sqlite3` module, but with async versions\nof all the standard connection and cursor methods, and context managers for\nautomatically closing connections:\n\n```python\n async with aiosqlite.connect(...) as db:\n await db.execute('INSERT INTO some_table ...')\n await db.commit()\n\n async with db.execute('SELECT * FROM some_table') as cursor:\n async for row in cursor:\n ...\n```\n\nAlternately, you can continue using connections and cursors more procedurally:\n\n```python\n db = await aiosqlite.connect(...):\n cursor = await db.execute('SELECT * FROM some_table')\n row = await cursor.fetchone()\n rows = await cursor.fetchall()\n await cursor.close()\n```\n\naiosqlite also replicates most of the standard connection properties, as needed\nfor advanced use cases like row or text factories, or for tracking the total\nnumber of rows inserted, modified, or deleted:\n\n```python\n async with aiosqlite.connect(...) as db:\n db.row_factory = aiosqlite.Row\n async with db.execute('SELECT * FROM some_table') as cursor:\n value = row['column']\n\n await db.execute('INSERT INTO foo some_table')\n assert db.total_changes > 0\n```\n\n\nDetails\n-------\n\naiosqlite allows interaction with SQLite databases on the main AsyncIO event\nloop without blocking execution of other coroutines while waiting for queries\nor data fetches. It does this by using a single, shared thread per connection.\nThis thread executes all actions within a shared request queue to prevent\noverlapping actions.\n\nConnection objects are proxies to the real connections, contain the shared\nexecution thread, and provide context managers to handle automatically closing\nconnections. Cursors are similarly proxies to the real cursors, and provide\nasync iterators to query results.\n\n\nLicense\n-------\n\naiosqlite is copyright [John Reese](https://jreese.sh), and licensed under the\nMIT license. I am providing code in this repository to you under an open source\nlicense. This is my personal repository; the license you receive to my code\nis from me and not from my employer. See the `LICENSE` file for details.", "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/jreese/aiosqlite", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "aiosqlite", "package_url": "https://pypi.org/project/aiosqlite/", "platform": "", "project_url": "https://pypi.org/project/aiosqlite/", "project_urls": { "Homepage": "https://github.com/jreese/aiosqlite" }, "release_url": "https://pypi.org/project/aiosqlite/0.10.0/", "requires_dist": null, "requires_python": ">=3.5", "summary": "asyncio bridge to the standard sqlite3 module", "version": "0.10.0" }, "last_serial": 5112116, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "884668d87ac61feb3a71f0352ef2c7c2", "sha256": "c58f110cef3407cb2fb144ceecb0e85fbfff091e8abea750ddcfd863d305140b" }, "downloads": -1, "filename": "aiosqlite-0.1.0.tar.gz", "has_sig": false, "md5_digest": "884668d87ac61feb3a71f0352ef2c7c2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2382, "upload_time": "2017-05-25T03:58:24", "url": "https://files.pythonhosted.org/packages/d9/9f/82927cd3ad2c0950c4d3c17598f5ec75e8be94eeaa16fff3f782c86e2539/aiosqlite-0.1.0.tar.gz" } ], "0.10.0": [ { "comment_text": "", "digests": { "md5": "9e0a7f348fff4f34e385dbc40d316b67", "sha256": "ad84fbd7516ca7065d799504fc41d6845c938e5306d1b7dd960caaeda12e22a9" }, "downloads": -1, "filename": "aiosqlite-0.10.0.tar.gz", "has_sig": false, "md5_digest": "9e0a7f348fff4f34e385dbc40d316b67", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 10109, "upload_time": "2019-04-08T06:04:55", "url": "https://files.pythonhosted.org/packages/74/bb/f5796f90ba82e788339449eb239dbb875ac072f6842f4429bcb76b877bc9/aiosqlite-0.10.0.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "54fe787950da9a89660d2e88e9bf8488", "sha256": "d0ad28b469bbfc1920b8d229ff6dabbdb698593db950cf07d9e9a23fce66f361" }, "downloads": -1, "filename": "aiosqlite-0.2.0.tar.gz", "has_sig": false, "md5_digest": "54fe787950da9a89660d2e88e9bf8488", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4360, "upload_time": "2017-08-24T23:34:51", "url": "https://files.pythonhosted.org/packages/13/19/ee023f214ded78e13e0be353253d8531abd3af9649bfe2f68853ae1c5cf4/aiosqlite-0.2.0.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "b197bef647fa8b57b51707a427043d0c", "sha256": "38c292420383d83fc4fc541899a8c595d8636813bda8a7d43a8a0dd99eaa1de2" }, "downloads": -1, "filename": "aiosqlite-0.2.1.tar.gz", "has_sig": false, "md5_digest": "b197bef647fa8b57b51707a427043d0c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4382, "upload_time": "2018-04-04T23:05:16", "url": "https://files.pythonhosted.org/packages/78/75/f4a6df442a389fe75b9a034796d076b75a37b3f46e33a84609c52b8e7c1e/aiosqlite-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "77b09f803cec96bd3dca3ae935f6da5a", "sha256": "5e17947e659a03b22aa4cdddbc5370e909262dbdec6edcc195299964af1db21e" }, "downloads": -1, "filename": "aiosqlite-0.2.2.tar.gz", "has_sig": false, "md5_digest": "77b09f803cec96bd3dca3ae935f6da5a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4821, "upload_time": "2018-04-05T06:41:00", "url": "https://files.pythonhosted.org/packages/59/a9/546a0d4b3dca81694e81e74409b292920677da02a08193b5c1ad7c93e44c/aiosqlite-0.2.2.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "ca79113b1cdd8a23395947d6c630d363", "sha256": "9eceb678e49b48fbd580e7f0a9c750655b1707b9f44f5a88fb4f05329c3175ee" }, "downloads": -1, "filename": "aiosqlite-0.3.0.tar.gz", "has_sig": false, "md5_digest": "ca79113b1cdd8a23395947d6c630d363", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5208, "upload_time": "2018-04-11T17:56:50", "url": "https://files.pythonhosted.org/packages/c5/26/bc5279cda725b6ccac6399cb629a29d83fbbf741c99f278f5410c7687a84/aiosqlite-0.3.0.tar.gz" } ], "0.4.0": [ { "comment_text": "", "digests": { "md5": "4d2720372c8adbc64d1ad7bb98034469", "sha256": "1040ed1bda9873b503be4d0dc1529ff1dba3a89e73c6faea7723b9e352e19d04" }, "downloads": -1, "filename": "aiosqlite-0.4.0.tar.gz", "has_sig": false, "md5_digest": "4d2720372c8adbc64d1ad7bb98034469", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5261, "upload_time": "2018-09-03T18:59:21", "url": "https://files.pythonhosted.org/packages/d6/89/657541fbc95a0ede44a2e9ef1a40b32c05e1582940cc29bc0f740fc7d161/aiosqlite-0.4.0.tar.gz" } ], "0.5.0": [ { "comment_text": "", "digests": { "md5": "65f14861f7ca8432cab15aebfd48a668", "sha256": "7dba55eab4cf75cee1ac9cbc7ebeafbc19f54cef3dabcae4290bd644854a91f9" }, "downloads": -1, "filename": "aiosqlite-0.5.0.tar.gz", "has_sig": false, "md5_digest": "65f14861f7ca8432cab15aebfd48a668", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5660, "upload_time": "2018-09-11T19:40:45", "url": "https://files.pythonhosted.org/packages/93/66/ce3b00518d68b836db36f8b93a2cadc0bc531d44fd9ebc8014b66a4b5889/aiosqlite-0.5.0.tar.gz" } ], "0.6.0": [ { "comment_text": "", "digests": { "md5": "afca8e926f16e266ca44c9ae26153c1e", "sha256": "e7e61f21abc101e6e448af923345bde818a0b4819980a103bed265540ddf6523" }, "downloads": -1, "filename": "aiosqlite-0.6.0.tar.gz", "has_sig": false, "md5_digest": "afca8e926f16e266ca44c9ae26153c1e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5809, "upload_time": "2018-09-19T20:24:52", "url": "https://files.pythonhosted.org/packages/44/3d/eb39aa906e4c520fa5ae08f5759a77e9ea1196c604fa842215e6f25162aa/aiosqlite-0.6.0.tar.gz" } ], "0.7.0": [ { "comment_text": "", "digests": { "md5": "ad2823d45133c8563b720d9feb242f30", "sha256": "0a553f871a04dee727b3ddcc9ce08434654cd9471660d95fd1d10a8d188027dd" }, "downloads": -1, "filename": "aiosqlite-0.7.0.tar.gz", "has_sig": false, "md5_digest": "ad2823d45133c8563b720d9feb242f30", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5963, "upload_time": "2018-10-14T05:57:25", "url": "https://files.pythonhosted.org/packages/2c/ea/a9f640c440aa57374aaeb9d36844bb38ff2e46839d753936a7fc25bea7b7/aiosqlite-0.7.0.tar.gz" } ], "0.8.0": [ { "comment_text": "", "digests": { "md5": "e8f852dcdaba4ac3edfbca5cb02b008e", "sha256": "554669169488785f56e2f186583a9d1023bb3dedb1fd08847966e78ce8854c96" }, "downloads": -1, "filename": "aiosqlite-0.8.0.tar.gz", "has_sig": false, "md5_digest": "e8f852dcdaba4ac3edfbca5cb02b008e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5783, "upload_time": "2018-11-01T19:03:18", "url": "https://files.pythonhosted.org/packages/08/2e/59f42b43764bb344d434f2d75410b6285b2f43d9272a646c38b2aa6b3cfc/aiosqlite-0.8.0.tar.gz" } ], "0.8.1": [ { "comment_text": "", "digests": { "md5": "dc229f6b5e1eeb8272b59168f5b6d2ef", "sha256": "a29bf465f0c366c9495c90c1802e62828eeccf12f3d704a33b14a50851e1715f" }, "downloads": -1, "filename": "aiosqlite-0.8.1.tar.gz", "has_sig": false, "md5_digest": "dc229f6b5e1eeb8272b59168f5b6d2ef", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5891, "upload_time": "2018-12-28T01:47:52", "url": "https://files.pythonhosted.org/packages/fc/0c/cb7df346fce249de017442c5e53780e81c0903d330f604dfb11b0530dc93/aiosqlite-0.8.1.tar.gz" } ], "0.9.0": [ { "comment_text": "", "digests": { "md5": "ff59df47340912f01444718c6dd35810", "sha256": "af4fed9e778756fa0ffffc7a8b14c4d7b1a57155dc5669f18e45107313f6019e" }, "downloads": -1, "filename": "aiosqlite-0.9.0.tar.gz", "has_sig": false, "md5_digest": "ff59df47340912f01444718c6dd35810", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5961, "upload_time": "2019-02-07T03:27:25", "url": "https://files.pythonhosted.org/packages/cf/2c/92fe44d4a932a5a9b2392820596f20d8e2439d63087539403f5e5d94eb68/aiosqlite-0.9.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "9e0a7f348fff4f34e385dbc40d316b67", "sha256": "ad84fbd7516ca7065d799504fc41d6845c938e5306d1b7dd960caaeda12e22a9" }, "downloads": -1, "filename": "aiosqlite-0.10.0.tar.gz", "has_sig": false, "md5_digest": "9e0a7f348fff4f34e385dbc40d316b67", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 10109, "upload_time": "2019-04-08T06:04:55", "url": "https://files.pythonhosted.org/packages/74/bb/f5796f90ba82e788339449eb239dbb875ac072f6842f4429bcb76b877bc9/aiosqlite-0.10.0.tar.gz" } ] }