You can install plugins like and to add visualizations, which again are bookmarkable and hence easy to share with other people.Īll of that said, I don't really see Datasette as competing with existing SQL clients. ĭatasette's plugin system is pretty unique too. Demo here (the owner, country_long and primary_fuel columns). I don't know if those alternatives have this feature or not, but I use this constantly. It also does web-style tricks like turning foreign key references into hyperlinks through to the associated records.ĭatasette's table browsing feature has faceting, which is enormously powerful. Queries you execute end up in your URL bar as ?sql= parameters, which means you can navigate to them in your history, bookmark them, share links with other people (if your Datasette is shared) and open them in new tabs. Obviously I'm biased, so I'd love to hear answers to this from other people (plus I've not really used any of those alternatives much).ĭatasette is very "webby". Grateful for what we just got, though! Just daydreaming. RFC3339 timestamps are already well designed, since if you stick to UTC (and if you don't store timezone data separately you deserve those problems), lexical order is temporal order, but queries which would be rendered in English as "return all accounts where last payment is ninety days prior to `now`" isn't really possible with string comparisons.Īlso, with the JSON library, you can use a check constraint to fail if a string isn't valid JSON, another affordance I would love to have for datetimes. SQLite already ships with a fairly large suite of JSON tools, which are optional to compile into the library, so there's precedent.ĭatetimes are of those things which is incredibly annoying to get right, and really belongs inside the database. On the subject of "it's called 'lite' for a reason", my wishlist does include library functions for working with RFC3339 timestamps. `RETURNING` will substantially clean up my code, and I already have one migration which could have just been a `DROP COLUMN`, so this is great news.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |