| Name | sheetcloud JSON |
| Version |
0.1.0.post12
JSON |
| download |
| home_page | |
| Summary | Sheetcloud.de | Turn Spreadsheets into a Cloud Database | Account required |
| upload_time | 2023-06-07 13:14:34 |
| maintainer | |
| docs_url | None |
| author | |
| requires_python | >=3.7 |
| license | |
| keywords |
spreadsheets
rad
database
cloud
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# Sheetcloud
Turn Spreadsheets into a Cloud Database with SheetCloud! Python library for easy access.
Website: https://sheetcloud.org
## NOTE: We are still in beta testing phase. If you like to become a Sheetcloud beta tester (with some perks attached), write us an email at `contact[at]sheetcloud.org`.
## Status
Tests
[](https://github.com/sheetcloud/sheetcloud/actions/workflows/continuous_integration.yml)
Deploy to PYPI
[](https://github.com/sheetcloud/sheetcloud/actions/workflows/deploy_to_pypi.yml)
## Setup
Sheetcloud expects the following environment variables to be present:
1. `SHEETCLOUD_USERNAME`
2. `SHEETCLOUD_PASSWORD`
You can find both in your Sheetcloud dashboard spreadsheet. If you have no account yet, you can create your free account in less than 30sec (no credit card required). Head over to [Sheetcloud website](https://sheetcloud.org) and connect your account. That's it! You will be re-directed to the Sheetcloud dashboard spreadsheet containing the username and password.
## Supported functionality
Sheetcloud supports Pandas DataFrames. Most functions are easy-to-use, self-explanatory, one-liners.
Spreadsheets
- Read/write/append spreadsheets in batches
- List spreadsheets and worksheets of a spreadsheet
- Get modification time
- Formatting
- Caching
Drive
- Read/write CSVs in batches
ORM
- map bidirectional data classes to spreadsheets
Environment Variables
- read/write environment variables to spreadsheets
- load variables into local environment
Templates
- load pre-defined templates
- customize templates
User
- request recovery token
- reset and change passwords
- validate license key
- authentication/authorization
REST:
- language agnostic API and documentation available
## What is Sheetcloud?
Transform Your Spreadsheets into a powerful Cloud Database with SheetCloud
Unlock the full potential of your data with SheetCloud! Say goodbye to the headaches of managing clunky offline spreadsheets and files, or setting up and maintaining a costly SQL database. With SheetCloud, you can turn your Google Sheets into a powerful cloud-based database with history, analytics, and online collaboration built in. Plus, with no hidden fees or charges, our simple and transparent pricing model will help you avoid the high costs of third-party databases.
Keep your data secure and accessible by storing it within your own Google Drive account, protected by robust security measures against potential breaches. Say goodbye to version control issues and data silos, and work seamlessly with your team, including non-developers such as business analysts who use spreadsheets. Whether you need to process, read, or write data in batches, build powerful dashboards and automated reports, handle secrets and environment variables, or schedule workflows, SheetCloud has got you covered, all with a single command from Python.
## [Test it now for free! No credit card required!](https://sheetcloud.org)
Raw data
{
"_id": null,
"home_page": "",
"name": "sheetcloud",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "Spreadsheets,RAD,Database,Cloud",
"author": "",
"author_email": "\"sheetcloud.org\" <contact@sheetcloud.org>",
"download_url": "https://files.pythonhosted.org/packages/f9/ba/61c29846a97bcb228d8ebb6e14d1bad77d54efaa2db20e9d8afd8358430c/sheetcloud-0.1.0.post12.tar.gz",
"platform": null,
"description": "# Sheetcloud\n\nTurn Spreadsheets into a Cloud Database with SheetCloud! Python library for easy access.\n\nWebsite: https://sheetcloud.org\n\n\n## NOTE: We are still in beta testing phase. If you like to become a Sheetcloud beta tester (with some perks attached), write us an email at `contact[at]sheetcloud.org`.\n\n## Status\n\nTests\n[](https://github.com/sheetcloud/sheetcloud/actions/workflows/continuous_integration.yml)\n\nDeploy to PYPI\n[](https://github.com/sheetcloud/sheetcloud/actions/workflows/deploy_to_pypi.yml)\n\n## Setup\n\nSheetcloud expects the following environment variables to be present:\n\n1. `SHEETCLOUD_USERNAME`\n\n2. `SHEETCLOUD_PASSWORD`\n\nYou can find both in your Sheetcloud dashboard spreadsheet. If you have no account yet, you can create your free account in less than 30sec (no credit card required). Head over to [Sheetcloud website](https://sheetcloud.org) and connect your account. That's it! You will be re-directed to the Sheetcloud dashboard spreadsheet containing the username and password.\n\n## Supported functionality\n\nSheetcloud supports Pandas DataFrames. Most functions are easy-to-use, self-explanatory, one-liners.\n\nSpreadsheets\n\n- Read/write/append spreadsheets in batches\n- List spreadsheets and worksheets of a spreadsheet\n- Get modification time\n- Formatting\n- Caching\n\nDrive\n\n- Read/write CSVs in batches\n\nORM\n\n- map bidirectional data classes to spreadsheets\n\nEnvironment Variables\n\n- read/write environment variables to spreadsheets\n- load variables into local environment\n\nTemplates\n\n- load pre-defined templates\n- customize templates\n\nUser\n\n- request recovery token\n- reset and change passwords\n- validate license key\n- authentication/authorization\n\nREST:\n\n- language agnostic API and documentation available\n\n## What is Sheetcloud?\n\nTransform Your Spreadsheets into a powerful Cloud Database with SheetCloud\n\nUnlock the full potential of your data with SheetCloud! Say goodbye to the headaches of managing clunky offline spreadsheets and files, or setting up and maintaining a costly SQL database. With SheetCloud, you can turn your Google Sheets into a powerful cloud-based database with history, analytics, and online collaboration built in. Plus, with no hidden fees or charges, our simple and transparent pricing model will help you avoid the high costs of third-party databases.\n\nKeep your data secure and accessible by storing it within your own Google Drive account, protected by robust security measures against potential breaches. Say goodbye to version control issues and data silos, and work seamlessly with your team, including non-developers such as business analysts who use spreadsheets. Whether you need to process, read, or write data in batches, build powerful dashboards and automated reports, handle secrets and environment variables, or schedule workflows, SheetCloud has got you covered, all with a single command from Python.\n\n## [Test it now for free! No credit card required!](https://sheetcloud.org)\n",
"bugtrack_url": null,
"license": "",
"summary": "Sheetcloud.de | Turn Spreadsheets into a Cloud Database | Account required",
"version": "0.1.0.post12",
"project_urls": {
"Examples": "https://github.com/sheetcloud",
"Homepage": "https://www.sheetcloud.org",
"Source": "https://github.com/sheetcloud/sheetcloud",
"Tracker": "https://github.com/sheetcloud/sheetcloud/issues"
},
"split_keywords": [
"spreadsheets",
"rad",
"database",
"cloud"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "ed269c0effa678605ca9c8b1d4e13b50fd804f9896c10e4fc453e6baafc476e4",
"md5": "1d843cbbc124e5d427a5338078175744",
"sha256": "32fb140302fe27dc4151227593c8ce2f805708e57501dbd1d8273e36f5090a7e"
},
"downloads": -1,
"filename": "sheetcloud-0.1.0.post12-py3-none-any.whl",
"has_sig": false,
"md5_digest": "1d843cbbc124e5d427a5338078175744",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 19012,
"upload_time": "2023-06-07T13:14:32",
"upload_time_iso_8601": "2023-06-07T13:14:32.982309Z",
"url": "https://files.pythonhosted.org/packages/ed/26/9c0effa678605ca9c8b1d4e13b50fd804f9896c10e4fc453e6baafc476e4/sheetcloud-0.1.0.post12-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "f9ba61c29846a97bcb228d8ebb6e14d1bad77d54efaa2db20e9d8afd8358430c",
"md5": "74b67bbb94a494e003ece3776c3422ff",
"sha256": "f4449a867ec913f76c2b31dae6442866bae37e849a2b69b21acee7a1c415b5cf"
},
"downloads": -1,
"filename": "sheetcloud-0.1.0.post12.tar.gz",
"has_sig": false,
"md5_digest": "74b67bbb94a494e003ece3776c3422ff",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 15784,
"upload_time": "2023-06-07T13:14:34",
"upload_time_iso_8601": "2023-06-07T13:14:34.566983Z",
"url": "https://files.pythonhosted.org/packages/f9/ba/61c29846a97bcb228d8ebb6e14d1bad77d54efaa2db20e9d8afd8358430c/sheetcloud-0.1.0.post12.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-07 13:14:34",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "sheetcloud",
"github_project": "sheetcloud",
"github_not_found": true,
"lcname": "sheetcloud"
}
