recent_releases (view)
5 rows where topics contains "datasette-io", topics contains "evernote" and topics contains "sqlite"
This data as json, CSV (advanced)
Suggested facets: date, date (date), published_at (date), topics (array)
rowid | repo | release | date | body_markdown | published_at | topics |
---|---|---|---|---|---|---|
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.2 | 2021-08-26 | - Fixed error when encountering `<en-note>` documents that were not well-formed XML. [#13](https://github.com/dogsheep/evernote-to-sqlite/issues/13) | 2021-08-26T19:02:47Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.1 | 2021-02-11 | - Explicitly open file using utf-8 encoding - thanks, RiverZhou. [#10](https://github.com/dogsheep/evernote-to-sqlite/pull/10) - Fix import error if note has no "updated" element - thanks, Matej Korosec. [#8](https://github.com/dogsheep/evernote-to-sqlite/pull/8) | 2021-02-11T22:40:40Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3 | 2021-02-11 | - Correctly handle entities in XHTML notes. [#9](https://github.com/dogsheep/evernote-to-sqlite/issues/9) - Fixed a bug importing ENEX files on Windows. Thanks, [dskrad](https://github.com/dskrad). [#11](https://github.com/dogsheep/evernote-to-sqlite/issues/11) | 2021-02-11T22:16:20Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.2 | 2020-10-12 | - Notes now use an ID derived from a hash of their contents. #3 - Date columns are now in ISO format, and indexd. #4 - Notes and resources table now have full-text search configured. #4 - Improved how OCR is stored in the database, only storing the most confident matches. #6 | 2020-10-12T00:07:24Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
303218369 | https://github.com/dogsheep/evernote-to-sqlite | https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.1 | 2020-10-11 | - Initial release, with support for importing ENEX files. | 2020-10-11T21:47:39Z | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW recent_releases AS select repos.rowid as rowid, repos.html_url as repo, releases.html_url as release, substr(releases.published_at, 0, 11) as date, releases.body as body_markdown, releases.published_at, coalesce(repos.topics, '[]') as topics from releases join repos on repos.id = releases.repo order by releases.published_at desc;