Alpha

These pages are built from main, turborel 0.0.0. Anything may change from one build to the next: SQL, API, protocol and files alike.

Volume V: Specialized Data

For SQL users whose data is more than numbers and strings: its model, the queries asked of it, and the indexes that serve them, a guide each.

The documentation set

Contents

  • Full-Text Search: search support tickets by their words, whatever their case and accents, index them, search them by pattern and show the best ranked first.
  • Spatial Data: import delivery addresses, search a map window, match orders to service areas, check routes against roadworks and find the nearest depots.
  • JSON Data: store orders as JSON documents, check them, read their values, find orders by their items, turn the items into rows and build JSON for a reply.
  • Vectors: store recipes' embeddings, find the nearest by distance, index them, compare the metrics, work with the vectors' arithmetic and define a distance of one's own.
  • XML Data: store suppliers' catalogs as XML documents, validate them by an XML Schema, read their values, find catalogs by their products, turn the products into rows, ask XQuery for more, build orders as XML and index the documents by path and value.
  • Graphs: present a bank's accounts and transfers as a graph, follow money along paths, find the shortest and cheapest, and index the transfers for the search.

Each guide runs on tables it makes at its start. The SQL Reference Manual gives each function's rules and errors, and The Embedded Library the Rust interfaces.