Typical Database operations in DGraph?

Users
1

Hello,

Does DGraph support typical DB operations, like :

  • AGGREGATES (SUM, AVG, COUNT, MIN, MAX…)
  • FULLTEXT (FUZZY) SEARCH
  • GEOSPACIAL (DISTANCE) Queries
  • DATE Queries
  • SORTING (ASC, DESC)
  • SELECT DISTINCT
  • …

If yes, how are these functions implemented using GraphQL in DGraph?
or can we use SPARQL (which support many of the above listed operations) against the RDF datamodel used in DGraph?

2

Hey @pmualaba,

We support:

  • Count
  • Full string / term matching.
  • Geospatial queries.

We’ll soon be supporting:

  • Sorting over various data types (integers, datetime, etc.)
  • Inequality filters for all the above data types (date >= some date, <= other date).

Other aggregates like Min, Max, Sum, Avg – we can support them easily. Feel free to file a feature request on Github, and we can schedule them for upcoming releases.

You can look at this page for the query spec:
https://wiki.dgraph.io/Queries_and_Mutations

Note that we’re going to do a v0.7 release this week, which contains all these newer functionalities.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.