Python datasette-tool

Open-source Python projects categorized as datasette-tool

Top 19 Python datasette-tool Projects

  • sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

    Project mention: Why you should probably be using SQLite | news.ycombinator.com | 2023-10-27

    Sounds like your problem is with SQLAlchemy, not with SQLite.

    My https://sqlite-utils.datasette.io library might be a better fit for you. It's a much thinner abstraction than SQLAlchemy.

  • csvs-to-sqlite

    Convert CSV files into a SQLite database

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • django-sql-dashboard

    Django app for building dashboards using raw SQL queries

  • twitter-to-sqlite

    Save data from Twitter to a SQLite database

  • github-to-sqlite

    Save data from GitHub to a SQLite database

    Project mention: Getting things done (in small increments) | news.ycombinator.com | 2024-01-01

    Yeah, I worry about that too. I have SO much of my stuff dependent on my GitHub account now.

    I'm slightly reassured by how useful their APIs are. I have automated exports of a lot of my GitHub issues, though I really should shore those up and make sure I'm capturing everything.

    That's one of the reasons I built https://github.com/dogsheep/github-to-sqlite

  • db-to-sqlite

    CLI tool for exporting tables or queries from any SQL database to a SQLite file

    Project mention: Show HN: I built an open-source data copy tool called ingestr | news.ycombinator.com | 2024-02-27

    I was surprised to see SQLite listed as a source but not as a destination. Any big reasons for that or is it just something you haven't got around to implementing yet?

    I've been getting a huge amount of useful work done over the past few years sucking data from other systems into SQLite files on my own computer - I even have my own small db-to-sqlite tool for this (built on top of SQLAlchemy) - https://github.com/simonw/db-to-sqlite

  • csv-diff

    Python CLI tool and library for diffing CSV and JSON files

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • dogsheep-beta

    Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

  • healthkit-to-sqlite

    Convert an Apple Healthkit export zip to a SQLite database

  • apple-notes-to-sqlite

    Export Apple Notes to SQLite

  • library

    xk media library (by chapmanjacobd)

    Project mention: Ask HN: Anyone looking for contributors for their open source projects | news.ycombinator.com | 2024-03-21

    Sure, I write small python CLI utils that help me solve media organization, media consumption, and sometimes data analysis. I use this every day on Linux and Android but I haven't tested it on other platforms. There are a lot of different subcommands and, although the CLI package will always be opinionated to some extent, there is a lot of niche functionality which might not need to exist. So I'm open to things being refactored or new subcommands being added. [1]

    I have a lot of ideas for new ones, for example, I want a CLI that can take an artist name like "Theodor Kittelsen" and fetch highest quality public domain images--but I realize any implementation that does this well will be somewhat fragile so I haven't really attempted that yet. Other ideas that I have are often solved by piping output from one of my existing commands to another.

    1. https://github.com/chapmanjacobd/library

  • pocket-to-sqlite

    Create a SQLite database containing data from your Pocket account

  • sqlite-diffable

    Tools for dumping/loading a SQLite database to diffable directory structure

  • google-takeout-to-sqlite

    Save data from Google Takeout to a SQLite database

  • swarm-to-sqlite

    Create a SQLite database containing your checkin history from Foursquare Swarm

  • hacker-news-to-sqlite

    Create a SQLite database containing data pulled from Hacker News

    Project mention: Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.? | news.ycombinator.com | 2023-12-10

    Partially. https://github.com/dogsheep/hacker-news-to-sqlite

  • evernote-to-sqlite

    Tools for converting Evernote content to SQLite

  • ibis-datasette

    An ibis backend for querying datasette

  • inaturalist-to-sqlite

    Create a SQLite database containing your observation history from iNaturalist

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2024-03-21.

Python datasette-tool related posts

Index

What are some of the best open-source datasette-tool projects in Python? This list will help you:

Project Stars
1 sqlite-utils 1,454
2 csvs-to-sqlite 855
3 django-sql-dashboard 428
4 twitter-to-sqlite 395
5 github-to-sqlite 373
6 db-to-sqlite 334
7 csv-diff 264
8 dogsheep-beta 178
9 healthkit-to-sqlite 175
10 apple-notes-to-sqlite 167
11 library 152
12 pocket-to-sqlite 99
13 sqlite-diffable 90
14 google-takeout-to-sqlite 88
15 swarm-to-sqlite 57
16 hacker-news-to-sqlite 43
17 evernote-to-sqlite 35
18 ibis-datasette 11
19 inaturalist-to-sqlite 6
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com