Datasette Alternatives

datasette reviews and mentions

• Ask HN: What are some unpopular technologies you wish people knew more about?
  56 projects | news.ycombinator.com | 2 Dec 2023

  Don't overlook https://datasette.io/ even though it does much more than endpoints.

• Effective GPT-4 Programming
  2 projects | news.ycombinator.com | 14 Nov 2023
• What is Glamorous Toolkit v1.0?
  3 projects | news.ycombinator.com | 5 Nov 2023

  OK, having watched the video at https://www.youtube.com/watch?v=lqogvp1dGpk (8 minutes, so 4 minutes if you 2x it) I understand why they have such a hard time answering the question "What is Glamorous Toolkit?"

  It's effectively a combination of a Smalltalk IDE, a Jupyter/Observable-style notebook environment and a tool somewhat like R Studio.

  It's a hard thing to categorize, because it's not exactly the same kind of thing as anything else.

  I emphasize wit the challenge: I have a similar problem with my https://datasette.io/ project.

• Portugal. The Man – Official Website Is a Google Sheets Document
  7 projects | news.ycombinator.com | 3 Nov 2023

  Thanks for the response, I was looking at your site from mobile earlier and it didn't jump out at me that it could also be used to edit data (tho I now see it mentioned clearly). Might be worth calling it out in a section as easy editing.

  Btw how would you compare this to https://datasette.io/ which is the first thing that came to mind? Is yours a bit more developer oriented?

• Seeking Help to Preserve Rare WWII Database on Windows 98
  2 projects | news.ycombinator.com | 18 Sep 2023

  Looks like it's an Access database. Perhaps convert it to SQLite and publish with something like https://datasette.io/?

  I think the problem is, thread author doesn't know how to rip an ISO of the CD or move the database out; looks like they are getting help already though.

• Why my favourite API is a zipfile on the European Central Bank's website
  10 projects | news.ycombinator.com | 15 Sep 2023

  You might find a lot of interesting tools in the Datasette ecosystem. Data dashboarding for SQLite with all sorts of import and export and visualization plugins.

  https://datasette.io/

• GitHub – GSA/code-gov: An informative repo for all Code.gov repos
  12 projects | news.ycombinator.com | 9 Sep 2023

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

  > You can use this tool to open any SQLite database file that is hosted online and served with a `access-control-allow-origin: ` CORS header. Files served by GitHub Pages automatically include this header, as do database files that have been published online using `datasette publish`.*

  > [...] You can paste in the "raw" URL to a file, but Datasette Lite also has a shortcut: if you paste in the URL to a page on GitHub or a Gist it will automatically convert it to the "raw" URL for you

  > To load a Parquet file, pass a URL to `?parquet=`

  > [...] https://lite.datasette.io/?parquet=https://github.com/Terada...*

  There are various *-to-sqlite utilities that load data into a SQLite database for use with e.g. datasette. E.g. Pandas with `dtype_backend='arrow'` saves to Parquet.

  datasette plugins are written in Python and/or JS w/ pluggy:

• Why Open Source?
  5 projects | news.ycombinator.com | 21 Aug 2023

  I'm building https://www.datasette.cloud/ and https://datasette.io/ almost entirely open source for a number of commercial reasons.

  1. I want organizations (initially newsrooms that care about data journalism, but rapidly growing beyond that) to be able to trust the product. The default result of 95% of startups is to go out of business, and going all-in on a product that then blinks out of existence is bad! When I'm selecting a vendor this is a thing I always consider, so I'd like my customers to feel confident that they have the ultimate escape hatch - run it yourself - should they ever need it.

  2. Newsrooms in particular have learned this lesson before, many times over. Remember Google Fusion Tables? https://en.wikipedia.org/wiki/Google_Fusion_Tables That's just one relatively recent example.

  3. Datasette is an ecosystem play. There are over 100 plugins already - https://datasette.io/plugins - and I hope for there to be thousands more. Developers don't invest nearly as heavily in building and releasing plugins for closed-source platforms.

  4. Open source is a way for me to punch _way_ above my weight. I can have a much larger impact on the world by participating in open source, compared to if everything I'd been building had been closed.

• Welcome to Datasette Cloud
  6 projects | news.ycombinator.com | 20 Aug 2023

  The https://datasette.io/ homepage has that video.

• Htmx is part of the GitHub Accelerator
  12 projects | news.ycombinator.com | 16 Aug 2023

  I dropped Accept header support from https://datasette.io/ because it's open source software that I build for other people to use, and I knew that it was very likely one of my users would choose to run it behind Cloudflare (or run it on a vendor like Vercel who might have a partnership with Cloudflare).

• A note from our sponsor - Onboard AI
  getonboard.dev | 6 Dec 2023

  Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev. Learn more →