login sign up

content: with combined as ( select 'news' as item_type, date as item_date, null as title, body, 'https://datasette.io/news/' || date as url from news where coalesce(nullif(cast(:news as text), ''), '1') = '1' union all select 'blog' as item_type, substr(datetime_utc, 1, 10) as item_date, title, coalesce(summary, '') as body, 'https://datasette.io' || path as url from blog_posts where coalesce(nullif(cast(:blog as text), ''), '1') = '1' union all select 'release' as item_type, substr(releases.published_at, 1, 10) as item_date, repos.name || ' ' || releases.tag_name as title, coalesce(releases.body, '') as body, releases.html_url as url from releases join repos on releases.repo = repos.id where releases.draft = 0 and coalesce(nullif(cast(:release as text), ''), '1') = '1' ) select item_type, item_date, title, body, url from combined where coalesce(:q, '') = '' or title like '%' || :q || '%' or body like '%' || :q || '%' order by item_date desc limit 200

agent.datasette.io
saved by
0 people
related read on
Datasette Apps: Host custom HTML applications inside Data... from the discussion