Ditto Query Language - V4.7

Ditto Query Language (DQL) is a powerful, flexible query language designed specifically for use with the Ditto platform. It allows you to perform complex data operations with ease, enabling real-time synchronization and efficient data management.
DQL is designed to simplify data interactions in your applications, providing a consistent and intuitive interface for querying and manipulating data. Whether you're a developer looking to streamline your backend operations or an engineer focused on optimizing data flow, DQL is tailored to meet your needs.
DQL Quick Reference
﻿SELECT﻿﻿
DQL
SELECT *
FROM your_collection_name
[WHERE condition]
[ORDER BY orderby_expression_1, orderby_expression_2, ... [ASC|DESC]]
[LIMIT limit_value]
[OFFSET number_of_documents_to_skip]
SELECT *
FROM your_collection_name
[WHERE condition]
[ORDER BY orderby_expression_1, orderby_expression_2, ... [ASC|DESC]]
[LIMIT limit_value]
[OFFSET number_of_documents_to_skip]
﻿
﻿INSERT﻿﻿
﻿
﻿UPDATE﻿﻿
DQL
UPDATE your_collection_name
SET field1 = value1, field2 -> [mutator], ...
WHERE [condition]
UPDATE your_collection_name
SET field1 = value1, field2 -> [mutator], ...
WHERE [condition]
﻿
﻿EVICT﻿﻿
DQL
EVICT FROM your_collection_name
WHERE [condition]
EVICT FROM your_collection_name
WHERE [condition]
﻿
﻿

Updated 22 Aug 2024

Did this page help you?

SELECT

Ditto Query Language - V4.7

DQL Quick Reference

﻿SELECT﻿﻿

﻿INSERT﻿﻿

﻿UPDATE﻿﻿

﻿EVICT﻿﻿

SELECT

INSERT

UPDATE

EVICT