0.12.3

• Fix for 400 error with CORS headers. #49

0.12.2

• Fixed bug triggered by columns with a name _likethis_. #48

0.12.1

• Fixed bug affecting tables with a primary key column called 'type'. #46

0.12

• Renamed tablename_get to tablename_row. #36
• Support operationName. #37
• Support GET as well as POST for executing GraphQL queries. #6
• Handle tables and columns with names that are not valid GraphQL identifiers. #10
• Foreign key _list relationships now work with non-integer keys. #45

0.11

• No longer exposes hidden tables, e.g. SQLite's _fts tables. #39
• Test fixtures database is now deployed as part of the live demo - see /graphql/fixtures. #40
• The generated GraphQL schema is now exposed at /graphql/dbname.graphql - e.g. /graphql/github.graphql on the demo. #41
• The example queries in the examples directory now link to live demos for each query. #42

0.10

• New 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:. #26
• Nested relationships now support the filter:, sort:, sort_desc:, search: and where: arguments. #38

Example 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
        }
      }
    }
  }
}

0.9

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.

0.8

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
      }
    }
  } 
}

0.7

• You can now access related rows for an item based on incoming foreign keys, and paginate through them. Demo. #27
• Tests are now partly driven by examples in the examples/ folder. #30
• Disable suggest_facets during internal calls, for a performance improvement. #29

0.6

• Removed 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. #28
• BLOB columns are now output encoded using base64. #13