Datasette Fixtures

An example SQLite database demonstrating Datasette. Sign in as root user

6 databases49 tables11 views10 queries

Queries

𝐜𝐢𝐭𝐢𝐞𝐬 fixtures select id, name from facet_cities order by id limit 1;
pragma_cache_size fixtures PRAGMA cache_size;
magic_parameters fixtures select :_header_user_agent as user_agent, :_now_datetime_utc as datetime · inputs: _header_user_agent, _now_datetime_utc
Search neighborhoods fixtures select _neighborhood, facet_cities.name, state from facetable join facet_cities on facetable._city_id =... · inputs: text
increment_counter_a writes counters update counters set value = value + 1 where name = 'counter_a'