pudo

dataset: Handle SQL Data with Minimal Boilerplate

dataset is a Python library for working with SQL data stores using a simple, JSON-like approach. It supports implicit table creation, bulk loading, and transactions for scripts and applications that need straightforward database access.

QuietPythonMITDatabaseLibrarySQL
Stars
4.9k
Forks
298
Stars, last 30 days
-7
Last commit
3 months ago
Contributors
61

Our take

Quietno commits in the last 90 days

Health score

34/100

How it is scored
Activity
31
Community
65
Issues
21
Pull requests
20

-7 stars in the last 30 days

dataset is a focused option for lightweight Python-to-SQL data handling, with a recent release but a currently quiet development period.

Good fit if

  • You need a Python library for basic SQL reads and writes, implicit table creation, bulk loading, or transactions.
  • Your project can use Python 3.10 or newer and the MIT license suits your needs.
  • You prefer a small, direct data-access layer over building your own routine database handling.

Look elsewhere if

  • You need the data export features that the project has moved into the separate datafreeze package.
  • Your environment cannot run Python 3.10 or newer.
  • You need evidence of active ongoing maintenance: the repository is marked quiet, with no commits in the last 90 days, despite a release during the past year.
All health signals
Last commit2026-07-22 (3 months ago)
Commits, last 90 days0
Releases, last 12 months1 (latest 2.0.0, 2026-04-12)
Contributors61 (top contributor: 58% of commits)
Issues closed, last 90 days0
Pull requests merged, last 90 days0
Project age13 years

Checked on 2026-10-16 with the GitHub API.

Project history

Daily GitHub snapshots since Oct 7, 2026. History covers stars and forks; health signals are not tracked historically.

Selected snapshot

Stars

4,865

Forks

304

Change since Nov 17, 2026: 0 stars·0 forks

Overview

dataset is a Python library for handling data in SQL data stores with a simple, JSON-like workflow. It aims to make routine database reads and writes easier, while supporting implicit table creation so users can work with data without first defining every table themselves.

The project also supports bulk loading and transactions, making it useful for scripts and applications that need to move or update structured data. It is a focused SQL data-access tool, not a database server or a general-purpose data export suite; the README notes that export features are now in the separate datafreeze project.

Key Features

  • Read and write data in SQL data stores through a straightforward Python interface.
  • Create tables implicitly when working with data.
  • Bulk-load data into databases.
  • Use transactions for database operations.
  • Install from PyPI with pip.
  • Keep data export functionality separate through the related datafreeze project.

Use Cases

  • A Python script author wants to write structured records to a SQL database without manually setting up every table first.
  • A data-processing workflow needs to bulk-load records into a SQL store.
  • An application needs transaction support for a sequence of database updates.
  • A developer accustomed to working with JSON-like data wants a simpler interface for routine SQL reads and writes.

What you need

Detected in the repository

  • Python >=3.10 (from pyproject.toml)
  • A test suite and automated checks on GitHub Actions

License in plain words

MITpermissive

  • Commercial use: yes
  • Modify and redistribute: yes
  • You must keep: the copyright and license notice
  • Share your changes: no

A summary, not legal advice: the LICENSE file is what applies.

Getting Started

Install the package:

pip install dataset

See the README and documentation for usage details.

Alternatives

  • sqlmodel: SQLModel uses typed Pydantic models and SQLAlchemy for database access, while dataset offers a simpler JSON-like interface with implicit table creation.
ProjectLanguageLicenseStarsStatus
datasetPythonMIT4.9kQuiet
sqlmodelPythonMIT18.4kActive

Considerations

The project is marked quiet because it has had no commits in the last 90 days, and no issues or pull requests were closed or merged during that period. It has a broad contributor base rather than depending mostly on one person, and it has had a release within the past year. Confirm that its SQL data-handling scope matches your needs: the README explicitly directs users to datafreeze for data export. The package requires Python 3.10 or newer and is MIT-licensed.

Found this useful?

Share it with someone who would like dataset.

Comparisons