Skip to content

SQLite Backend Demo #225

Description

@matthewwiese

@adf-ncgr @ctcncgr

Hi guys - sorry for the delay on this. I was having a bear with rsyncing the SQLite db back to our servers. Anyway, enough excuses!

The database is based on a Postgres dump (using pg2sqlite) of Minimine with the gene function 5104 work. It wasn't a perfect 1-to-1 and I had to add missing indexes, because otherwise the performance was (obviously) slow.

Gene Function Search Demo: http://dev.lis.ncgr.org:50044/dev/lis-gene-function-search-element.html

Gene Search Demo: http://dev.lis.ncgr.org:50044/dev/lis-gene-search-element.html

The gene/gene functions were what I tested - there's no reason the other web components shouldn't work, but expect them to be broken currently. The gene function search is the better example - the data returned from gene search is incorrect/missing, but still demonstrates the proof of concept.

The branch is sqlite: https://github.com/legumeinfo/graphql-server/tree/sqlite

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions