datasette

Open-source projects categorized as datasette Edit details

Top 23 datasette Open-Source Projects

  • datasette

    An open source multi-tool for exploring and publishing data

    Project mention: Does anyone here use sqlite just to do quick queries, because it is easier than loading to another rdb? | reddit.com/r/Python | 2022-08-05

    https://datasette.io is my larger open source project around building tools for analyzing and publishing data with SQLite

  • sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

    Project mention: Does anyone here use sqlite just to do quick queries, because it is easier than loading to another rdb? | reddit.com/r/Python | 2022-08-05

    https://sqlite-utils.datasette.io is the Python CLI tool and library I wrote to speed up this kind of work. Here's a recent tutorial I wrote about it: https://datasette.io/tutorials/clean-data

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • csvs-to-sqlite

    Convert CSV files into a SQLite database

    Project mention: Turning database into a searchable dashboard? | reddit.com/r/datascience | 2021-10-21

    Oh what's that you say, your data is in CSV and you don't want to write code to load them up into a database, well try this https://github.com/simonw/csvs-to-sqlite

  • til

    Today I Learned (by simonw)

    Project mention: Simon Willison's cool categorised TIL page | news.ycombinator.com | 2022-06-21
  • twitter-to-sqlite

    Save data from Twitter to a SQLite database

    Project mention: Using Datasette for an ELT Personal Twitter Data Warehouse | dev.to | 2021-12-26

    Keep in mind that all of this is automatically generated from a sqlite table (which itself was automatically generated by running twitter-to-sqlite), greatly reducing the bar for GUI-based, SQL-based EDA.

  • github-to-sqlite

    Save data from GitHub to a SQLite database

    Project mention: I created Scrumdog – a program to download Jira Issues to a local database | news.ycombinator.com | 2022-07-15

    Thanks for letting me know - fixed that here: https://github.com/dogsheep/github-to-sqlite/issues/74

  • dogsheep-beta

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

    Project mention: Zinc Search engine. A lightweight alternative to Elasticsearch written in Go | news.ycombinator.com | 2021-12-03
  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • healthkit-to-sqlite

    Convert an Apple Healthkit export zip to a SQLite database

    Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24

    I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

  • tapuino

    tapuino

    Project mention: Help setting up tapuino | reddit.com/r/c64 | 2021-10-05

    Download Link to source code:https://github.com/sweetlilmre/tapuino/releases/tag/v.2.8.0

  • datasette-lite

    Datasette running in your browser using WebAssembly and Pyodide

    Project mention: A SQLite extension for reading large files line-by-line | news.ycombinator.com | 2022-07-30

    Oh wow! I wonder how hard it would be to load that module into https://github.com/simonw/datasette-lite

  • datasette-dashboards

    Datasette plugin providing data dashboards from metadata

    Project mention: The interesting ideas in Datasette (2018) | news.ycombinator.com | 2022-04-05

    https://github.com/rclement/datasette-dashboards

    It is still very alpha but usable if you know Vega syntax.

    Looking for some contributors to bring Datasette to the level of Metabase!

  • google-takeout-to-sqlite

    Save data from Google Takeout to a SQLite database

    Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24

    I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

  • datasette-graphql

    Datasette plugin providing an automatic GraphQL API for your SQLite databases

  • covid-19-datasette

    Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times

    Project mention: Automating a Software Company with GitHub Actions | news.ycombinator.com | 2021-08-19

    I don't have any at the moment where a commit to one triggers a build in another, but I have a bunch that run on a schedule, pull code from other repos and do stuff with it.

    Best example of that is here: https://github.com/simonw/covid-19-datasette/blob/main/.gith...

  • pocket-to-sqlite

    Create a SQLite database containing data from your Pocket account

    Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24

    I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

  • swarm-to-sqlite

    Create a SQLite database containing your checkin history from Foursquare Swarm

    Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24

    I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

  • datasette.io

    The official project website for Datasette

    Project mention: Architecture Notes: Datasette | news.ycombinator.com | 2022-05-27

    Opened an issue exploring alternatives here: https://github.com/simonw/datasette.io/issues/109

    I decided to just drop "any size" but keep "any shape".

  • datasette-auth-github

    Datasette plugin that authenticates users against GitHub

  • hacker-news-to-sqlite

    Create a SQLite database containing data pulled from Hacker News

    Project mention: “Obtaining My Personal Data from Amazon Was a Nightmare” | news.ycombinator.com | 2022-03-27
  • museums

    A website recommending niche museums to visit

  • timezones-api

    A Datasette-powered API for finding the time zone for a latitude/longitude point

  • datasette-stripe

    A web SQL interface to your Stripe account using Datasette.

    Project mention: Show HN: Tdog – Download Stripe to SQLite | news.ycombinator.com | 2022-05-17

    This is a CLI written in Rust to download your Stripe account to a local SQLite database.

    It is intended to enable using SQL queries over your data.

    There is also a template for fly.io and Datasette to give you a Sigma like web UI:

    https://github.com/tabledog/datasette-stripe

  • datasette-dateutil

    dateutil functions for Datasette

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 2022-08-05.

datasette related posts

Index

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

Project Stars
1 datasette 6,314
2 sqlite-utils 945
3 csvs-to-sqlite 703
4 til 514
5 twitter-to-sqlite 344
6 github-to-sqlite 223
7 dogsheep-beta 149
8 healthkit-to-sqlite 131
9 tapuino 116
10 datasette-lite 102
11 datasette-dashboards 70
12 google-takeout-to-sqlite 66
13 datasette-graphql 63
14 covid-19-datasette 61
15 pocket-to-sqlite 58
16 swarm-to-sqlite 48
17 datasette.io 43
18 datasette-auth-github 38
19 hacker-news-to-sqlite 36
20 museums 25
21 timezones-api 24
22 datasette-stripe 20
23 datasette-dateutil 7
Find remote jobs at our new job board 99remotejobs.com. There is 0 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com