Similar in spirit to https://www.sqlite.org/whentouse.html - people always appreciate it when there is host documentation describing when a tool is and is not appropriate.
You have data you wish to publish that's up to 2GB in size (this should work just fine)
You have up to 10GB of data and you're willing to put work into picking good indexes and being thoughtful about your query patterns
You data changes infrequently, and you can afford to re-deploy on changes (though Datasette can handle constant updates with a bit of extra work)
Inappropriate:
Over 1GB of constantly growing log data - look into Splunk or Elasticsearch or tools like that instead
Data where you need to support many concurrent writers
Data that's mostly big binary images and videos and suchlike - though you could host those files in something like S3 and have metadata about them (and URLs to the files) in Datasette
Really need to put quite a bit more thought into this - the above is just some quick initial notes.
Similar in spirit to https://www.sqlite.org/whentouse.html - people always appreciate it when there is host documentation describing when a tool is and is not appropriate.
Follows:
109