SpectraDB: A Lightweight Spectroscopic Data Manager
Introduction
In many labs, data from instruments like FTIR, fluorescence, or NMR are saved as individual files (often in strange formats) and scattered across different folders. This can quickly lead to a cluttered system that’s hard to manage and search through.
SpectraDB is designed to simplify this process by letting you store all your spectroscopic data in a single, organized SQLite database. Each type of spectroscopic data gets a unique spec_id, and every sample is given a sample_id. This means you can easily search and retrieve any analysis for any sample without digging through endless folders of files.
How It Works (in Simple Terms)
-
Collect Data from Instruments:
- After running a sample on an instrument (like FTIR or NMR), you typically copy the data file onto your computer. The file might be in an unusual format specific to the instrument, but don’t worry—SpectraDB handles that for you.
-
Add the Data to SpectraDB:
- You can use built-in functionality to add the data to the database. SpectraDB will convert the raw file (whatever format it's in) into a format that’s easy to work with, and then store it in an SQLite database.
- Along with the spectroscopic data, you’ll also be able to store metadata like
measurement_id,instrument_id, experiment details, and anything else you want to track.
-
Avoid Duplicates:
- SpectraDB is smart! It checks if the same sample and analysis already exist in the database, so you won’t accidentally store duplicate data. This helps keep things tidy.
-
Query the Data Easily:
- Once your data is in the database, you can search by sample (using
sample_id) to see what spectroscopic techniques have been run on that sample, or search by spectroscopy type (usingspec_id) to pull all the relevant data for a particular technique (e.g., all FTIR results). - No more hunting through folders—just run a query, and you get what you need.
- Once your data is in the database, you can search by sample (using
-
What You Can Do Next:
- After pulling the data, you can visualize it, analyze trends, or run further processing as needed. You have all the information in one place!
Key Features
- Centralized Storage: All spectroscopic data is stored in one SQLite database, making it easy to manage and search.
- Automatic Conversion: Raw data files from instruments are automatically converted to usable formats and stored efficiently in the database.
- Unique IDs: Each spectroscopic file gets a
spec_id, and each sample gets asample_id, allowing for simple and quick queries. - Duplicate Checks: Built-in checks prevent duplicate entries, ensuring clean and organized data.
- Query Flexibility: Search by sample or spectroscopy type, and get a complete view of your data without hassle.
Project Ideas
- Organize all your data in one place by converting raw instrument data into a database-friendly format.
- Query data based on sample (
sample_id) to see all the spectroscopic analyses performed on that sample. - Query based on spectroscopy type (
spec_id) to retrieve specific data (e.g., only FTIR results). - Visualize and analyze the data after retrieval for further insights.
Metadata
Release files for spectradb 1.0.6
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 |
|---|---|---|---|---|
| spectradb-1.0.6.tar.gz | 18.1 kB | Without provenance | Details for spectradb-1.0.6.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| spectradb-1.0.6-py3-none-any.whl | Python 3 | none | any | Details for spectradb-1.0.6-py3-none-any.whl |
Total release size: 36.9 kB
Release files / spectradb-1.0.6.tar.gz
| Download URL | spectradb-1.0.6.tar.gz |
|---|---|
| Size | 18.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
87cf7fb7e770a76cac040cc528d3ea7f202d585a26020a6fa8d7b2cd5d9b9653
|
|
BLAKE2b-256 checksum How to use checksums |
9ad651d6348a1d26fbad49122eec0135f86e6e87a7209fee6f7a03661180fed9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.9
|
Release files / spectradb-1.0.6-py3-none-any.whl
| Download URL | spectradb-1.0.6-py3-none-any.whl |
|---|---|
| Size | 18.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
84427e78365769b7949e9f1b95e9b9055933dd99866305a46ac3908167124b82
|
|
BLAKE2b-256 checksum How to use checksums |
b9733de9aad8a42cbe73014780cbd97d7268c61ba7da1e84ae6f4fd4752957b9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.9
|
Security for spectradb 1.0.6
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.