Wild select: intuitive queries for JSON, XML, and other hierarchical data

(developforperformance.com)

1 points | by kirk_krauss 7 hours ago ago

1 comments

  • kirk_krauss 7 hours ago ago

    The FastUtf8::Uniseries class provides a C++ solution for working with internationalized content and also meets the pattern matching needs associated with semistructured data. Setting up a wild select query for JSON, XML, or other hierarchical semistructured data is as simple as choosing a sequence of tags leading to a chosen level, creating a search pattern that has those opening and closing tags delimited by * wildcards at its beginning and end, completing the middle of the pattern to include a * wildcard for each value to be selected, and passing the completed pattern and chosen level to a case-sensitive or case-insensitive method. Anyone who’s familiar with commonplace * and ? wildcard syntax can quickly comprehend a query. Yet the query is powerful enough to act essentially like an SQL SELECT statement with basic FROM, JOIN, WHERE, and ORDER BY clauses.