Datasette plugin providing an automatic GraphQL API for your SQLite databases
APACHE-2.0 License
Bot releases are hidden (Show)
Published by simonw about 4 years ago
Published by simonw about 4 years ago
_likethis_
. #48Published by simonw about 4 years ago
Published by simonw about 4 years ago
tablename_get
to tablename_row
. #36operationName
. #37_list
relationships now work with non-integer keys. #45Published by simonw about 4 years ago
_fts
tables. #39/graphql/dbname.graphql
- e.g. /graphql/github.graphql on the demo. #41Published by simonw about 4 years ago
where:
argument that accepts a fragment of SQL to add to the WHERE clause, as an alternative for if the query is too complex to express using filter:
. #26filter:
, sort:
, sort_desc:
, search:
and where:
arguments. #38Example query using these new features (try this query):
{
repos(filter: [{stargazers_count: {gt: 10}}]) {
nodes {
full_name
stargazers_count
issues_list(first: 5, where: "body like '%test%' or title like '%test%'", sort_desc: created_at) {
totalCount
nodes {
title
}
}
}
}
}
Published by simonw about 4 years ago
Table filtering has a new, better design. #25
Retrieving all records with license
of "apache-2.0"
and a stargazers_count
greater than 10 now looks like this:
{
repos(filter: {license: {eq: "apache-2.0"}, stargazers_count: {gt: 10}}) {
nodes {
full_name
stargazers_count
license {
key
}
}
}
}
See table filters examples for more operations, and column filter arguments in the Datasette documentation for details of how those operations work.
Published by simonw about 4 years ago
New tablename_get
field for retrieving single rows, including by their primary key. #11
Example query (try it out):
{
users_get(id: 9599) {
id
name
contributors_list(first: 5) {
totalCount
nodes {
repo_id {
full_name
}
contributions
}
}
}
}
Published by simonw about 4 years ago
suggest_facets
during internal calls, for a performance improvement. #29Published by simonw about 4 years ago
disable_cors
setting in favour of re-using the existing datasette --cors
flag, which means you have to opt-in rather than opt-out of CORS. #28Published by simonw about 4 years ago
disable_cors
plugin configuration setting is set. #24Published by simonw about 4 years ago
Published by simonw about 4 years ago
search:
argument for running searches against tables configured to use SQLite FTS. #22sort:
and sort_desc:
arguments. #21Published by simonw about 4 years ago
Published by simonw about 4 years ago
auto_camelcase
plugin setting. #15Published by simonw about 4 years ago
table_name(filters: [...])
argument. #12Published by simonw about 4 years ago
Published by simonw about 4 years ago
Published by simonw about 4 years ago