Skip to main content

pypi codecov

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)

  1. 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.
  2. 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.
  3. 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.
  4. 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 (using spec_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.
  5. 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 a sample_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)

Source distribution for spectradb 1.0.6
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)

Table of built distributions (wheels) for spectradb 1.0.6
File Interpreter ABI Platform Actions
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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page