Closed simonw closed 4 years ago
Maybe something like this:
https://codepen.io/simonwillison/pen/wvBwjNy
<section class="hero is-dark is-bold">
<div class="hero-body">
<div class="container">
<h1 class="title">
Niche Museums
</h1>
<h2 class="subtitle">
Find tiny museums <span class="is-hidden-mobile">near you</span>
</h2>
<div class="buttons" style="display: block;" id="buttons">
<button class="button is-link">Use my location</button>
</div>
<div class="field has-addons">
<div class="control">
<input class="input is-small" type="text" placeholder="Search">
</div>
<div class="control">
<input type="submit" class="button is-small" value="🔍"> </div>
</div>
</div>
</div>
</section>
Slightly better query: does't throw an error on empty input:
select
museums_fts.rank,
museums.*
from
museums
join museums_fts on museums.id = museums_fts.rowid
where
museums_fts match case
:q
when '' then '*'
else :q
end
order by
museums_fts.rank
Prototype: