Datasette is my data hammer

• simonwillisonblog

  28 156 8.2 JavaScript

  The source code behind my blog

• simonw

  9 380 9.9 Python

  https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/

• WorkOS

  workos.com sponsored

  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

  8 430 4.4 Python

  Django app for building dashboards using raw SQL queries

I have a sister project to Datasette called Django SQL Dashboard which works against PostgreSQL databases: https://django-sql-dashboard.datasette.io

It used Django for the authentication layer but can otherwise work against any PostgreSQL database.

I partly built it to help explore what Datasette could look like if it expanded to work with more databases than SQLite. That's still something I'm considering doing in the future, via a plugin hook, but it's not on my short-term roadmap.

• datasette-app

  12 115 2.6 JavaScript

  The Datasette macOS application

I'd love to get the desktop app working on Linux and Windows.

I did manage to get a prototype working on Windows, despite having VERY little experience working on that platform: https://github.com/simonw/datasette-app/issues/71

The bit I'm stuck on is how to turn that prototype into an application with an installer that's signed so people can download and run it.

• til

  20 965 9.6 HTML

  Today I Learned (by simonw)

I'm definitely keen on suggestions for improvements I can make to the default UI.

Datasette provides both a JSON API (easily enabled for CORS access) and supports custom templates, so it's possible to customize the UI any way you like.

So far I've not seen many examples of extensive customization. I use the custom templates a lot myself - these four sites are all just regular Datasette with some custom templates:

- https://datasette.io/

- https://til.simonwillison.net/

- https://www.niche-museums.com/

- https://www.rockybeaches.com/us/pillar-point

Source code is on GitHub for all four.

• datasette

  187 8,881 9.2 Python

  An open source multi-tool for exploring and publishing data

I'm definitely keen on suggestions for improvements I can make to the default UI.

Datasette provides both a JSON API (easily enabled for CORS access) and supports custom templates, so it's possible to customize the UI any way you like.

So far I've not seen many examples of extensive customization. I use the custom templates a lot myself - these four sites are all just regular Datasette with some custom templates:

- https://datasette.io/

- https://til.simonwillison.net/

- https://www.niche-museums.com/

- https://www.rockybeaches.com/us/pillar-point

Source code is on GitHub for all four.

Suggest a related project