The only internet database I know of with a search interface that satisfyingly queries its structured data is vndb [1]. You might laugh, but I think it's a good

The only internet database I know of with a search interface that satisfyingly queries its structured data is vndb [1]. You might laugh, but I think it's a good example of an open-source project where an opinionated maintainer rejects lowest-common-denominator design. For once I don't feel like I'd rather use bare SQL (looking at you, every web storefront ever), but vndb even supports that! I do wish were more sites like it. IMO almost no directory projects get both the wiki and database parts right like wikidata and vndb do (at two very different scales). Those two have in common: (come to think of it, so does OpenStreetMap mostly): - query builder in addition to the search form [1][2] - web query runner (SQL, SPARQL) [3], both with a custom backend [4] - open data license (ODbl, CC0) [5] - db dumps as files over http [5] - (A)GPL source. Both also self-host their git web ui [6] - no login-walls, and no ads [1] with relational subqueries https://vndb.org/v?f=["and",["olang","!=","en"],["staff","!=",["gender","=","m"]],["staff","=",["and",["gender","=","f"],["role","=","director"]]]]&s=220&skin=teal https://vndb.org/v?f=["and",["olang","!=","en"],["staff","!=... [2] wikidata's is experimental and incomplete https://query.wikidata.org/querybuilder/?query={"conditions":[{"propertyId":"P31","propertyDataType":"wikibase-item","propertyValueRelation":"matching","referenceRelation":"regardless","value":"Q7094076","subclasses":true,"conditionRelation":null,"negate":false},{"propertyId":"P31","propertyDataType":"wikibase-item","propertyValueRelation":"matching","referenceRelation":"regardless","value":"Q171","subclasses":true,"conditionRelation":"and","negate":false},{"propertyId":"P275","propertyDataType":"wikibase-item","propertyValueRelation":"matching","referenceRelation":"regardless","value":"Q1224853","subclasses":true,"conditionRelation":"and","negate":false},{"propertyId":"P275","propertyDataType":"wikibase-item","propertyValueRelation":"matching","referenceRelation":"regardless","value":"Q6938433","subclasses":true,"conditionRelation":"or","negate":false}],"limit":100,"useLimit":true,"omitLabels":false https://query.wikidata.org/querybuilder/?query={"conditions"...} [3] https://query.vndb.org/?sql=SELECT+'https://www.wikidata.org/wiki/Q'%7C%7Cw.id+AS+%22Wikidata%22,+e.id+AS+%22VNDB+id%22,+e.title%0D%0A++FROM+wikidata+w%0D%0A++JOIN+(++SELECT+id,+l_wikidata,+title+FROM+vn%0D%0AUNION+ALL+SELECT+id,+l_wikidata,+name+FROM+producers%0D%0AUNION+ALL+SELECT+s.id,+s.l_wikidata,+sa.name+FROM+staff+s+JOIN+staff_alias+sa+ON+sa.aid+=+s.main%0D%0A+++++++)+e+(id,+wd,+title)+ON+e.wd+=+w.id%0D%0A+WHERE+w.vndb+IS+NULL+OR+NOT+(w.vndb+@%3E+ARRAY%5Be.id::text%5D)%0D%0AORDER+BY+w.id&copy=76be6b8d434ac626 https://query.vndb.org/?sql=SELECT+'https://www.wikidata.org... [3] https://query.wikidata.org/##defaultView:ImageGrid%0ASELECT%0A%20%20?vn%0A%20%20(IRI(CONCAT('https://vndb.org/',%20SAMPLE(?vndb_id)))%20AS%20?vndb)%0A%20%20(SAMPLE(?label_ja)%20AS%20?label_ja)%0A%20%20(SAMPLE(COALESCE(?label_en,%20?item_label))%20AS%20?label)%0A%20%20(SAMPLE(COALESCE(?logo,%20?pic))%20AS%20?pic)%0AWHERE%20%7B%0A%20%20?vn%20wdt:P136%20%7C%20wdt:P31/wdt:P279*%20wd:Q689445;%0A%20%20%20%20%20%20wdt:P407%20wd:Q5287.%0A%20%20OPTIONAL%20%7B?vn%20wdt:P3180%20?vndb_id%7D%0A%20%20OPTIONAL%20%7B?vn%20rdfs:label%20?label_ja%20FILTER(LANG(?label_ja)%20=%20%22ja%22)%7D%0A%20%20OPTIONAL%20%7B?vn%20rdfs:label%20?label_en%20FILTER(LANG(?label_en)%20=%20%22en%22)%7D%0A%20%20OPTIONAL%20%7B?vn%20rdfs:label%20?item_label%7D%0A%20%20OPTIONAL%20%7B?vn%20wdt:P154%20?logo%7D%0A%20%20OPTIONAL%20%7B?vn%20wdt:P18%20?pic%7D%0A%7D%0AGROUP%20BY%20?vn%0AORDER%20BY%20?vn https://query.wikidata.org/##defaultView:ImageGrid%0ASELECT%... [4] https://dev.yorhel.nl/sqlbin https://dev.yorhel.nl/sqlbin [4] https://wikitech.wikimedia.org/wiki/Wikidata_Query_Service https://wikitech.wikimedia.org/wiki/Wikidata_Query_Service [5] https://vndb.org/d14 https://vndb.org/d14 [5] https://www.wikidata.org/wiki/Wikidata:Data_access https://www.wikidata.org/wiki/Wikidata:Data_access [6] https://code.blicky.net/yorhel/vndb https://code.blicky.net/yorhel/vndb [6] https://gerrit.wikimedia.org/g/mediawiki/extensions/Wikibase https://gerrit.wikimedia.org/g/mediawiki/extensions/Wikibase