paskvilwiki

databases & search

  • 4storebuild, start, load data, query it from Python, write Turtle files
  • Elasticsearchsetup, indexing, getting, updating, deleting, indices and mappings management, diagnostics
  • Elasticsearch query DSLthe queries and filters i use the most - match, bool, query_string, range, term, exists…
  • Elasticsearch searchrequest body and URI search, filters vs facets, pagination, sorting, fields, facets
  • Kyoto Cabinetbuilding Kyoto Cabinet and Kyoto Tycoon, Kyoto Tycoon's RPC API calls
  • MongoDBinstall on Ubuntu with the PHP driver, desktop troubles, using it from PHP
  • MySQLerror 1045, the on duplicate key update pitfall, shrinking ibdata1, indexing JSON columns
  • PostgreSQLdump and restore, deleting duplicates, resetting sequences, killing stuck queries
  • SPARQL, RDQLquery optimization, loading vs insertion, Turtle groupings