datasette-graphql

• Fix for 400 error with CORS headers. #49

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

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

• 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

• 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

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

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.

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

• 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

• 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

• Enable CORS access, unless disable_cors plugin configuration setting is set. #24

• Support views as well as tables. #23
• Support multiple databases. #9

• Implemented search: argument for running searches against tables configured to use SQLite FTS. #22
• Implemented sort: and sort_desc: arguments. #21

• First non-alpha release
• Supports GraphQL pagination using nodes, edges, pageInfo and totalCount. #2
• No longer throws an error if you try to expand a null foreign key. #20

• GraphQL variable support. #14
• auto_camelcase plugin setting. #15

• Foreign key relationships can now be expanded using nested GraphQL syntax. #3
• Tables can now be filtered using the new table_name(filters: [...]) argument. #12

• Now supports different column types - integer, float, string #7
• New live demo at https://datasette-graphql-demo.datasette.io/ #8

• Now includes GraphiQL interface, and correctly returns introspection metadata. #1

• Initial proof of concept