datasette-io

Open-source projects categorized as datasette-io
Edit details
Topics: datasette datasette-tool Sqlite dogsheep datasette-plugin
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
Sponsored

Top 23 datasette-io Open-Source Projects

  • datasette

    An open source multi-tool for exploring and publishing data

    • Project mention: Ask HN: High quality Python scripts or small libraries to learn from | news.ycombinator.com | 2024-04-19

    Simon Willison's github would be a great place to get started imo -

    https://github.com/simonw/datasette

  • sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

    • Project mention: Ask HN: High quality Python scripts or small libraries to learn from | news.ycombinator.com | 2024-04-19

    https://github.com/simonw/sqlite-utils

    So, his code might not be a good place to find best patterns (for ex, I don't think they are fully typed), but his repos are very pragmatic, and his development process is super insightful (well documented PRs for personal repos!). Best part, he blogs about every non-trivial update, so you get all the context!

  • 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.

    InfluxDB logo

  • csvs-to-sqlite

    Convert CSV files into a SQLite database

  • 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

  • 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.

    WorkOS logo

  • csv-diff

    Python CLI tool and library for diffing CSV and JSON files

  • healthkit-to-sqlite

    Convert an Apple Healthkit export zip to a SQLite database

  • dogsheep-beta

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

  • datasette-dashboards

    Datasette plugin providing data dashboards from metadata

    • Project mention: Observable 2.0, a static site generator for data apps | news.ycombinator.com | 2024-02-15

    Me too, and that lead to developing the « datasette-dashboards » plugin[0]. I use this for my company where all the data is gathered by connectors scheduled in CI, storing data in Git, and triggering a SQLite db build and Datasette deployment. « BI as Code » if you will

    [0] https://github.com/rclement/datasette-dashboards

  • pocket-to-sqlite

    Create a SQLite database containing data from your Pocket account

  • datasette-graphql

    Datasette plugin providing an automatic GraphQL API for your SQLite databases

  • google-takeout-to-sqlite

    Save data from Google Takeout to a SQLite database

  • sqlite-diffable

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

  • datasette-ripgrep

    Web interface for searching your code using ripgrep, built as a Datasette plugin

    • Project mention: GitHub – GSA/code-gov: An informative repo for all Code.gov repos | news.ycombinator.com | 2023-09-09

    https://github.com/simonw/datasette-ripgrep

    Seeing as there's already a JSONLD @context (schema) for code.json, CSVW as JSONLD and/or YAMLLD would be an easy way merge Linked Data graphs of tabular data:

  • 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

  • datasette-auth-github

    Datasette plugin that authenticates users against GitHub

  • evernote-to-sqlite

    Tools for converting Evernote content to SQLite

  • datasette-auth-passwords

    Datasette plugin for authentication using passwords

  • ibis-datasette

    An ibis backend for querying datasette

  • datasette-dateutil

    dateutil functions for Datasette

  • SaaSHub

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

    SaaSHub logo
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).

datasette-io related posts

Index

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

Project Stars
1 datasette 8,934
2 sqlite-utils 1,510
3 csvs-to-sqlite 858
4 django-sql-dashboard 431
5 twitter-to-sqlite 395
6 github-to-sqlite 376
7 db-to-sqlite 334
8 csv-diff 273
9 healthkit-to-sqlite 184
10 dogsheep-beta 178
11 datasette-dashboards 131
12 pocket-to-sqlite 99
13 datasette-graphql 97
14 google-takeout-to-sqlite 93
15 sqlite-diffable 90
16 datasette-ripgrep 70
17 swarm-to-sqlite 57
18 hacker-news-to-sqlite 43
19 datasette-auth-github 41
20 evernote-to-sqlite 35
21 datasette-auth-passwords 19
22 ibis-datasette 11
23 datasette-dateutil 7

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com