Explore
Reading data
Instant provides a GraphQL-like interface for querying. We call our query language InstaQL
Why InstaQL
We like the declarative nature of GraphQL queries but are not fans of a) configuration and b) build steps required to get up and running. To get around a) and b) we built InstaQL using only native javascript arrays and objects.
Fetch namespace
One of the simpliest queries you can write is to simply get all entities of a namespace.
const query = { goals: {} }
const { isLoading, error, data } = db.useQuery(query)
Inspecting data, we'll see:
console.log(data)
{
"goals": [
{
"id": healthId,
"title": "Get fit!"
},
{
"id": workId,
"title": "Get promoted!"
}
]
}
For comparison, the SQL equivalent of this would be something like:
const data = { goals: doSQL('SELECT * FROM goals') }
Fetch multiple namespaces
You can fetch multiple namespaces at once:
const query = { goals: {}, todos: {} }
const { isLoading, error, data } = db.useQuery(query)
We will now see data for both namespaces.
console.log(data)
{
"goals": [...],
"todos": [
{
"id": focusId,
"title": "Code a bunch"
},
{
"id": proteinId,
"title": "Drink protein"
},
...
]
}
The equivalent of this in SQL would be to write two separate queries.
const data = {
goals: doSQL('SELECT * from goals'),
todos: doSQL('SELECT * from todos'),
}
Fetch a specific entity
If you want to filter entities, you can use the where keyword. Here we fetch a specific goal
const query = {
goals: {
$: {
where: {
id: healthId,
},
},
},
}
const { isLoading, error, data } = db.useQuery(query)
console.log(data)
{
"goals": [
{
"id": healthId,
"title": "Get fit!"
}
]
}
The SQL equivalent would be:
const data = { goals: doSQL("SELECT * FROM goals WHERE id = 'healthId'") }
Fetch associations
We can fetch goals and their related todos.
const query = {
goals: {
todos: {},
},
}
const { isLoading, error, data } = db.useQuery(query)
goals would now include nested todos
console.log(data)
{
"goals": [
{
"id": healthId,
"title": "Get fit!",
"todos": [...],
},
{
"id": workId,
"title": "Get promoted!",
"todos": [...],
}
]
}
Comparing InstaQL vs SQL
The SQL equivalent for this would be something along the lines of:
const query = "
SELECT g.*, gt.todos
FROM goals g
JOIN (
SELECT g.id, json_agg(t.*) as todos
FROM goals g
LEFT JOIN todos t on g.id = t.goal_id
GROUP BY 1
) gt on g.id = gt.id
"
const data = {goals: doSQL(query)}
Notice the complexity of this SQL query. Although fetching associations in SQL is straightforward via JOIN, marshalling the results in a nested structure via SQL is tricky. An alternative approach would be to write two straight-forward queries and then marshall the data on the client.
const _goals = doSQL("SELECT * from goals")
const _todos = doSQL("SELECT * from todos")
const data = {goals: _goals.map(g => (
return {...g, todos: _todos.filter(t => t.goal_id === g.id)}
))
Now compare these two approaches with InstaQL
const query = {
goals: {
todos: {},
},
}
const { isLoading, error, data } = db.useQuery(query)
Modern applications often need to render nested relations, InstaQL really starts to shine for these use cases.
Fetch specific associations
A) Fetch associations for filtered namespace
We can fetch a specific entity in a namespace as well as it's related associations.
const query = {
goals: {
$: {
where: {
id: healthId,
},
},
todos: {},
},
}
const { isLoading, error, data } = db.useQuery(query)
Which returns
console.log(data)
{
"goals": [
{
"id": healthId,
"title": "Get fit!",
"todos": [
{
"id": proteinId,
"title": "Drink protein"
},
{
"id": sleepId,
"title": "Go to bed early"
},
{
"id": workoutId,
"title": "Go on a run"
}
]
}
]
}
B) Filter namespace by associated values
We can filter namespaces by their associations
const query = {
goals: {
$: {
where: {
'todos.title': 'Code a bunch',
},
},
todos: {},
},
}
const { isLoading, error, data } = db.useQuery(query)
Returns
console.log(data)
{
"goals": [
{
"id": workId,
"title": "Get promoted!",
"todos": [
{
"id": focusId,
"title": "Code a bunch"
},
{
"id": reviewPRsId,
"title": "Review PRs"
},
{
"id": standupId,
"title": "Do standup"
}
]
}
]
}
C) Filter associations
We can also filter associated data.
const query = {
goals: {
todos: {
$: {
where: {
'todos.title': 'Go on a run',
},
},
},
},
}
const { isLoading, error, data } = db.useQuery(query)
This will return goals and filtered todos
console.log(data)
{
"goals": [
{
"id": healthId,
"title": "Get fit!",
"todos": [
{
"id": workoutId,
"title": "Go on a run"
}
]
},
{
"id": workId,
"title": "Get promoted!",
"todos": []
}
]
}
Notice the difference between these three cases.
- A) Fetched all todos for goal with id
health - B) Filtered goals with a least one todo titled
Code a bunch - C) Fetched all goals and filtered associated todos by title
Go on a run
Inverse Associations
Associations are also available in the reverse order.
const query = {
todos: {
goals: {},
},
}
const { isLoading, error, data } = db.useQuery(query)
console.log(data)
{
"todos": [
{
"id": focusId,
"title": "Code a bunch",
"goals": [
{
"id": workId,
"title": "Get promoted!"
}
]
},
...,
]
}
Advanced filtering
And
The where clause supports multiple keys which will filter entities that match all of the conditions.
You can also provide a list of queries under the and key.
Multiple keys in a single where:
const query = {
todos: {
$: {
where: {
completed: true,
'goals.title': 'Get promoted!',
},
},
},
};
const { isLoading, error, data } = db.useQuery(query);
console.log(data)
{
"todos": [
{
"id": focusId,
"title": "Code a bunch",
"completed": true
}
]
}
and key:
This query type is useful when querying references, like todos.title, where a single entity can have multiple values:
const query = {
goals: {
$: {
where: {
and: [
{ 'todos.title': 'Drink protein' },
{ 'todos.title': 'Go on a run' },
],
},
},
},
};
const { isLoading, error, data } = db.useQuery(query);
console.log(data)
{
"goals": [
{
"id": healthId,
"title": "Get fit!"
}
]
}
OR
The where clause supports or queries that will filter entities that match any of the clauses in the provided list:
const query = {
todos: {
$: {
where: {
or: [
{ title: 'Code a bunch' },
{ title: 'Review PRs' }
],
},
},
},
};
const { isLoading, error, data } = db.useQuery(query);
console.log(data);
{
"todos": [
{
"id": focusId,
"title": "Code a bunch"
},
{
"id": reviewPRsId,
"title": "Review PRs"
},
]
}
In
The where clause supports in queries that will filter entities that match any of the items in the provided list:
const query = {
todos: {
$: {
where: {
title: { in: ['Code a bunch', 'Review PRs'] },
},
},
},
};
const { isLoading, error, data } = db.useQuery(query);
console.log(data)
{
"todos": [
{
"id": focusId,
"title": "Code a bunch"
},
{
"id": reviewPRsId,
"title": "Review PRs"
},
]
}
More features to come!
We're actively building more features for InstaQL. Let us know on discord if there's a missing feature you'd love for us to add!