SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python datasette-io Projects
-
Project mention: Little Data: How do we query personal data? (2013) | news.ycombinator.com | 2024-03-01
I'm a fan on simonw's datasette/dogsheep ecosystem https://datasette.io/
-
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.
-
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.
-
-
-
-
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
-
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
-
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
-
-
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
-
-
Project mention: Tuql: Automatically create a GraphQL server from a SQLite database | news.ycombinator.com | 2023-04-25
Impressive how little code is involved here! This is really neat.
The biggest feature I can see that's missing is pagination - it looks like this doesn't have a way to retrieve e.g. ten results, then pass a next token to get back the next set.
Here's how I implemented pagination in my similar datasette-graphql plugin (which also gives you a GraphQL API for an existing SQLite database): https://github.com/simonw/datasette-graphql#pagination
-
-
-
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:
-
-
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
-
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Python datasette-io related posts
- Getting things done (in small increments)
- Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.?
- Welcome to Datasette Cloud
- SQLite Functions for Working with JSON
- I'm sure I'm being stupid.. Copying data from an API and making a database
- Datasette is my data hammer
- Ask HN: What Do You Use for a Personal Database
-
A note from our sponsor - SaaSHub
www.saashub.com | 28 Mar 2024
Index
What are some of the best open-source datasette-io projects in Python? This list will help you:
Project | Stars | |
---|---|---|
1 | datasette | 8,791 |
2 | sqlite-utils | 1,454 |
3 | csvs-to-sqlite | 855 |
4 | django-sql-dashboard | 428 |
5 | twitter-to-sqlite | 395 |
6 | github-to-sqlite | 373 |
7 | db-to-sqlite | 334 |
8 | csv-diff | 264 |
9 | dogsheep-beta | 178 |
10 | healthkit-to-sqlite | 175 |
11 | datasette-dashboards | 131 |
12 | pocket-to-sqlite | 99 |
13 | datasette-graphql | 93 |
14 | sqlite-diffable | 90 |
15 | google-takeout-to-sqlite | 88 |
16 | datasette-ripgrep | 69 |
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 |