# <img src="resources/singlestore-logo.png" height="60" valign="middle"/> Ibis backend for SingleStoreDB
This project contains an [Ibis](https://ibis-project.org) backend
for the SingleStore database. This allows you to access and manipulate your
data using a DataFrame-like API.
## Install
This package can be installed from PyPI using `pip`:
```
pip install ibis-singlestoredb
```
## Usage
Connections to the SingleStoreDB database are made using URLs that specify
the connection driver package, server hostname, server port, and user
credentials.
```
import ibis
# Connect using the default connector
conn = ibis.singlestoredb.connect('user:password@host:3306/db_name')
# Get an Ibis DataFrame object that points to the 'employees' table
employees = conn.table('employees')
# Apply DataFrame-like operations (lazily)
res = employees[employees.name.like('Smith')][employees.deptId > 1]
# Execute the operations
res.execute()
```
Connecting to the HTTP API is done as follows:
```
# Use the HTTP API connector
conn = ibis.singlestoredb.connect('http://user:password@host:8080/db_name')
```
## Examples
There are some example Jupyter notebooks in the
[examples](https://github.com/singlestore-labs/ibis-singlestoredb/tree/main/examples)
directory.
## License
This library is licensed under the [Apache 2.0 License](https://raw.githubusercontent.com/singlestore-labs/singlestoredb-python/main/LICENSE?token=GHSAT0AAAAAABMGV6QPNR6N23BVICDYK5LAYTVK5EA).
## Resources
* [SingleStore](https://singlestore.com)
* [Ibis](https://ibis-project.org)
* [Python](https://python.org)
## User agreement
SINGLESTORE, INC. ("SINGLESTORE") AGREES TO GRANT YOU AND YOUR COMPANY ACCESS TO THIS OPEN SOURCE SOFTWARE CONNECTOR ONLY IF (A) YOU AND YOUR COMPANY REPRESENT AND WARRANT THAT YOU, ON BEHALF OF YOUR COMPANY, HAVE THE AUTHORITY TO LEGALLY BIND YOUR COMPANY AND (B) YOU, ON BEHALF OF YOUR COMPANY ACCEPT AND AGREE TO BE BOUND BY ALL OF THE OPEN SOURCE TERMS AND CONDITIONS APPLICABLE TO THIS OPEN SOURCE CONNECTOR AS SET FORTH BELOW (THIS “AGREEMENT”), WHICH SHALL BE DEFINITIVELY EVIDENCED BY ANY ONE OF THE FOLLOWING MEANS: YOU, ON BEHALF OF YOUR COMPANY, CLICKING THE “DOWNLOAD, “ACCEPTANCE” OR “CONTINUE” BUTTON, AS APPLICABLE OR COMPANY’S INSTALLATION, ACCESS OR USE OF THE OPEN SOURCE CONNECTOR AND SHALL BE EFFECTIVE ON THE EARLIER OF THE DATE ON WHICH THE DOWNLOAD, ACCESS, COPY OR INSTALL OF THE CONNECTOR OR USE ANY SERVICES (INCLUDING ANY UPDATES OR UPGRADES) PROVIDED BY SINGLESTORE.
BETA SOFTWARE CONNECTOR
Customer Understands and agrees that it is being granted access to pre-release or “beta” versions of SingleStore’s open source software connector (“Beta Software Connector”) for the limited purposes of non-production testing and evaluation of such Beta Software Connector. Customer acknowledges that SingleStore shall have no obligation to release a generally available version of such Beta Software Connector or to provide support or warranty for such versions of the Beta Software Connector for any production or non-evaluation use.
NOTWITHSTANDING ANYTHING TO THE CONTRARY IN ANY DOCUMENTATION, AGREEMENT OR IN ANY ORDER DOCUMENT, SINGLESTORE WILL HAVE NO WARRANTY, INDEMNITY, SUPPORT, OR SERVICE LEVEL, OBLIGATIONS WITH
RESPECT TO THIS BETA SOFTWARE CONNECTOR (INCLUDING TOOLS AND UTILITIES).
APPLICABLE OPEN SOURCE LICENSE: Apache 2.0
IF YOU OR YOUR COMPANY DO NOT AGREE TO THESE TERMS AND CONDITIONS, DO NOT CHECK THE ACCEPTANCE BOX, AND DO NOT DOWNLOAD, ACCESS, COPY, INSTALL OR USE THE SOFTWARE OR THE SERVICES.
Raw data
{
"_id": null,
"home_page": "https://github.com/singlestore-labs/ibis-singlestoredb",
"name": "ibis-singlestoredb",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "",
"keywords": "",
"author": "SingleStore",
"author_email": "support@singlestore.com",
"download_url": "https://files.pythonhosted.org/packages/58/ab/e7ae82eff73ca9c12bfe91a01a7042894c162c14a69f486b186f2fad8a14/ibis_singlestoredb-0.4.3.tar.gz",
"platform": null,
"description": "# <img src=\"resources/singlestore-logo.png\" height=\"60\" valign=\"middle\"/> Ibis backend for SingleStoreDB\n\nThis project contains an [Ibis](https://ibis-project.org) backend\nfor the SingleStore database. This allows you to access and manipulate your\ndata using a DataFrame-like API.\n\n## Install\n\nThis package can be installed from PyPI using `pip`:\n```\npip install ibis-singlestoredb\n```\n\n## Usage\n\nConnections to the SingleStoreDB database are made using URLs that specify\nthe connection driver package, server hostname, server port, and user\ncredentials.\n```\nimport ibis\n\n# Connect using the default connector\nconn = ibis.singlestoredb.connect('user:password@host:3306/db_name')\n\n# Get an Ibis DataFrame object that points to the 'employees' table\nemployees = conn.table('employees')\n\n# Apply DataFrame-like operations (lazily)\nres = employees[employees.name.like('Smith')][employees.deptId > 1]\n\n# Execute the operations\nres.execute()\n```\n\nConnecting to the HTTP API is done as follows:\n```\n# Use the HTTP API connector\nconn = ibis.singlestoredb.connect('http://user:password@host:8080/db_name')\n```\n\n## Examples\n\nThere are some example Jupyter notebooks in the\n[examples](https://github.com/singlestore-labs/ibis-singlestoredb/tree/main/examples)\ndirectory.\n\n\n## License\n\nThis library is licensed under the [Apache 2.0 License](https://raw.githubusercontent.com/singlestore-labs/singlestoredb-python/main/LICENSE?token=GHSAT0AAAAAABMGV6QPNR6N23BVICDYK5LAYTVK5EA).\n\n## Resources\n\n* [SingleStore](https://singlestore.com)\n* [Ibis](https://ibis-project.org)\n* [Python](https://python.org)\n\n## User agreement\n\nSINGLESTORE, INC. (\"SINGLESTORE\") AGREES TO GRANT YOU AND YOUR COMPANY ACCESS TO THIS OPEN SOURCE SOFTWARE CONNECTOR ONLY IF (A) YOU AND YOUR COMPANY REPRESENT AND WARRANT THAT YOU, ON BEHALF OF YOUR COMPANY, HAVE THE AUTHORITY TO LEGALLY BIND YOUR COMPANY AND (B) YOU, ON BEHALF OF YOUR COMPANY ACCEPT AND AGREE TO BE BOUND BY ALL OF THE OPEN SOURCE TERMS AND CONDITIONS APPLICABLE TO THIS OPEN SOURCE CONNECTOR AS SET FORTH BELOW (THIS \u201cAGREEMENT\u201d), WHICH SHALL BE DEFINITIVELY EVIDENCED BY ANY ONE OF THE FOLLOWING MEANS: YOU, ON BEHALF OF YOUR COMPANY, CLICKING THE \u201cDOWNLOAD, \u201cACCEPTANCE\u201d OR \u201cCONTINUE\u201d BUTTON, AS APPLICABLE OR COMPANY\u2019S INSTALLATION, ACCESS OR USE OF THE OPEN SOURCE CONNECTOR AND SHALL BE EFFECTIVE ON THE EARLIER OF THE DATE ON WHICH THE DOWNLOAD, ACCESS, COPY OR INSTALL OF THE CONNECTOR OR USE ANY SERVICES (INCLUDING ANY UPDATES OR UPGRADES) PROVIDED BY SINGLESTORE.\nBETA SOFTWARE CONNECTOR\n\nCustomer Understands and agrees that it is being granted access to pre-release or \u201cbeta\u201d versions of SingleStore\u2019s open source software connector (\u201cBeta Software Connector\u201d) for the limited purposes of non-production testing and evaluation of such Beta Software Connector. Customer acknowledges that SingleStore shall have no obligation to release a generally available version of such Beta Software Connector or to provide support or warranty for such versions of the Beta Software Connector for any production or non-evaluation use.\n\nNOTWITHSTANDING ANYTHING TO THE CONTRARY IN ANY DOCUMENTATION, AGREEMENT OR IN ANY ORDER DOCUMENT, SINGLESTORE WILL HAVE NO WARRANTY, INDEMNITY, SUPPORT, OR SERVICE LEVEL, OBLIGATIONS WITH\nRESPECT TO THIS BETA SOFTWARE CONNECTOR (INCLUDING TOOLS AND UTILITIES).\n\nAPPLICABLE OPEN SOURCE LICENSE: Apache 2.0\n\nIF YOU OR YOUR COMPANY DO NOT AGREE TO THESE TERMS AND CONDITIONS, DO NOT CHECK THE ACCEPTANCE BOX, AND DO NOT DOWNLOAD, ACCESS, COPY, INSTALL OR USE THE SOFTWARE OR THE SERVICES.\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Ibis backend for the SingleStoreDB database",
"version": "0.4.3",
"project_urls": {
"Homepage": "https://github.com/singlestore-labs/ibis-singlestoredb"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "3e61f389c6bb375720e558f99daa892296085ae52126864bf00e2a634b64dd61",
"md5": "250099cbc4b1e0644142d1eb6ccf6939",
"sha256": "a1e1ac886e168fa8355d908bfab6e8ae29ce2f837b9d2db9e89b3c1a8ae357dc"
},
"downloads": -1,
"filename": "ibis_singlestoredb-0.4.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "250099cbc4b1e0644142d1eb6ccf6939",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 73072,
"upload_time": "2023-09-05T15:31:51",
"upload_time_iso_8601": "2023-09-05T15:31:51.752140Z",
"url": "https://files.pythonhosted.org/packages/3e/61/f389c6bb375720e558f99daa892296085ae52126864bf00e2a634b64dd61/ibis_singlestoredb-0.4.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "58abe7ae82eff73ca9c12bfe91a01a7042894c162c14a69f486b186f2fad8a14",
"md5": "bb82b42d61822c1898223c27a4624f58",
"sha256": "d7b7a47d3bb65a0e557702858f3f940f7a7a7be8deafcd058ac7fac37d3e661b"
},
"downloads": -1,
"filename": "ibis_singlestoredb-0.4.3.tar.gz",
"has_sig": false,
"md5_digest": "bb82b42d61822c1898223c27a4624f58",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 55954,
"upload_time": "2023-09-05T15:31:53",
"upload_time_iso_8601": "2023-09-05T15:31:53.014989Z",
"url": "https://files.pythonhosted.org/packages/58/ab/e7ae82eff73ca9c12bfe91a01a7042894c162c14a69f486b186f2fad8a14/ibis_singlestoredb-0.4.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-09-05 15:31:53",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "singlestore-labs",
"github_project": "ibis-singlestoredb",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [],
"lcname": "ibis-singlestoredb"
}
JSON
