ssb-patchql demo cast

VIDEO : https://www.youtube.com/watch?v=lVqUSi9XxnE

This is a tour of what it's like to use ssb-patchql since @piet announced this here ... I hope you can all see how easy it's going to be to build new things with this ... you don't really need to know any of the backend stuff, and you can pretty much get away without learning GraphQL !

Awesome!
Going to download this as soon as my boss looks away and play with it!

Looks like I need to run the Rust SSB server to make this work. Will see if I can transfer my "account data" over to Sunrise Choir or start a new identity

It works, uploading stuff to youtube now ;)

https://youtu.be/OKL4vaQFxtw
runs with Tightbeam now ;)

omgosh so awesome @mix @piet @hendrik!

#sunrise-choir

Really impressive stuff!

I see that the interface already aggregates some things related to threads. What are the thoughts in relation to creating your own indexes? Imagine I would port books over to this interface.

@Robert.Best/d 🖥️ check this out. You've heard of graphql right?

Well if you can get this much working, you could run all the graph queries till your heart was content :p

I think it would be sweet to understand the flow of data here. I was thinking about drawing a diagram. It goes like :

1. replication into the log file (just a big no-sql dump)
2. rust is told (via a graphql mutation) to nom some log into it's relational sql database, which currently looks something like :
   
3. rust provides a graphql interface which lets you ask a range of questions really easily of those sql tables.
4. ssb-patchql is an js plugin for the js ssb-server which just starts the rust binary up so steps (2) and (3) just work

@arj to answer your question, the sql tables have a lot of what you want. I think with a little reading / more documentation we'll see that links might be the backlinks you might want ... you can see there's an about table which gathering about messages. The only things that might need dong would be to expose some of this using graphql. Personally I'm keen to replace some core Patchbay stuff with this .... start with something simple like likes ... move on to names (which is a massive slow cached process at the moment).

and so ssb-patchql is being used in phones already!

wow @Hendrik Peter, that was quick! Awesome work

psst, threads work too
https://youtu.be/FkhHMLOmWHg

@Piet , wow nice, I'll try that when I wake up tomorrow!

@mix that would work, I basically just need messageByType and backlinks.

One last thing, this doesn't have any way to do live queries, right?

This could be an interesting subtopic for our call next week.

@piet

There’s and env var LISTEN which you can set, eg: LISTEN=0.0.0.0:8080

I tried this both like this:

export LISTEN=0.0.0.0:8080
npm start

in Patchbay and

export LISTEN=0.0.0.0:8080
npm install

The above don't really work, this is probably because let host = env::var("LISTEN").unwrap_or_else(|_| "localhost:8080".to_owned())8; in ssb-patchql is evaluated on compile-time (and not function()-run-time), so all builds on the build page (downloaded in jsbot-patchql) are locked to localhost. But that's super fine for now!

aha! that explains it. Thanks!

@arj that's correct - there is no live stream with graphql (that I know of). I was planning to do some naive cache invalidation - have a live pull stream and if anything comes through that is in the neighbourhood of what I've been looking at, re-fetch + re-render

I was planning to do some naive cache invalidation

yeah, I need to restart the app now (haven't made that deep of a dive into caching in GraphQL yet), there isn't too much happening on my side when new messages come in on the backend.

I tried to play with this but i can't seem to figure out how to trigger ti to process the log and put it in to sql lite. My sqlite db just has my identity stuff. What do i need to do?

Did you call the process Mutation @Rabble? That's what triggers the indexing.

Ok, i'm thinking, there's something about graphql i don't know... but perhaps others also don't know it. So i think it should be in the readme perhaps.

{
    process Mutation
}


{
  "errors": [
    {
      "message": "Unknown field \"process\" on type \"Query\"",
      "locations": [
        {
          "line": 30,
          "column": 2
        }
      ]
    },
    {
      "message": "Unknown field \"Mutation\" on type \"Query\"",
      "locations": [
        {
          "line": 30,
          "column": 10
        }
      ]
    }
  ]
}

Where do you run process Mutation?

check out this query @rabble:
https://git.picodevelopment.nl/ssbc/tightbeam-hub/blob/master/TightbeamHubNode/patchql.js#L9

or this one from @mixmix including nest logic:
https://github.com/ssbc/patchbay/blob/patchql/app/sync/initialise/patchql.js

hey @mixmix thanks for the video. Can't wait to play with it too.

@Hendrik Peter it's awesome seeing you moving from new in this space, to building clients, to answering technical questions to make it more accessible for those following you. This makes my heart sing xxx

:facepalm:

Yeah it works, the :facepalm: was for not figuring it out from the readme. I've got it running now with ssb-sqwish visualization too. Nifty stuff.