This release is a pre-release and may not be stable for production use.
Bigsheets
Open many huge CSV files in a click and query them with the power of SQL —group by, joins, etc.
This app is for convenience; just click “open” and select a sheet, headers are auto-detected and numbers and dates just work.
Each sheet is added as a table in a SQLite in RAM, so you can keep opening sheets and query them as regular SQL tables.
The UI is a native webview, which means that is smooth and native-feeling while being mlutiplatform.
Built as an useful and real exercise to master Domain Driven Design with Python —if many find it useful though we can make it more real.
Download
The software is multiplatform, but I have only built it on Mac, and there is some care to be taken before building it for Windows and Linux: set the style for Windows and Linux, setup py2exe for them, and optionally find a way how to use tabs in those systems.
The Mac version is here. Just download it an place it in your Applications folder.
Installation for developers
Theoretically it should work on Windows and Linux –but not tested!
Requirements: Python 3.8+ and not a very old nodejs.
pip install bigsheets
Or clone this project and pip install -e . -r requirements.txt.
Building
The software is multiplatform, but I have only built it on Mac, and there is some care to be taken before building it for Windows and Linux: set the style for Windows and Linux, and setup py2exe for them.
Mac
Clone this project and install it with pip.
To create the icons you will need Affinity Designer. Open the icon file and export them at the folder where the file is, then execute make icons in a terminal, generating the files pyinstaller requires.
Finally execute make build.
Tested in MacOS Catalina.
Architecture
Explained in my blog post.
Yes, the name is a childish sad pun.
Metadata
Release files for BigSheets 1.0b1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| BigSheets-1.0b1.tar.gz | 22.2 kB | Without provenance | Details for BigSheets-1.0b1.tar.gz |
Release files / BigSheets-1.0b1.tar.gz
| Download URL | BigSheets-1.0b1.tar.gz |
|---|---|
| Size | 22.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
6d2353bae542b7deab03a11b9d81919f68a1e19010979dfa9867f703daf1f532
|
|
BLAKE2b-256 checksum How to use checksums |
dfedb1958bf7148dfe31710a96c5273c792ac0fb677a9308ff697e889b034600
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
Python-urllib/3.8
|
Security for BigSheets 1.0b1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.