Add a SQL / Document feature

[gedw99]

Cete looks pretty strong.

I have a few thoughts on some things that can be easily add.

1. Lets Encrypt.

• with the Cert itself stored in Cete, because in a Cluster you need to use the same Cert for all Servers.
• Many examples of this: https://github.com/lithdew/flatend/blob/master/cmd/flatend/main.go#L153

2. Search

• Add https://github.com/genjidb/genji which wraps Badger
• Because Genji provides a SQL string like API, it can be added easily to the existing GRPC API as a 2nd API
• Looks like adding it here is possible: https://github.com/mosuka/cete/blob/master/storage/kvs.go

[mosuka]

@gedw99
That's a good idea to store the certificates in cete itself.
Regarding SQL support, I'd like to keep Cete as a simple KVS server and try to implement a SQL server built on top of Genji.
What do you think?

[gedw99]

Hey @mosuka

I was thinking exactly the same thing. Use GRPC for the API.
The API with Genji is really easy to use also so it will be quite easy to make a GRPC API on top.
Its just tables and standard SQL.

Also as a GRPC API the genji shell can then be used remotely to help with Ops.

Personally i think it shoudl be done in their github Org, because there are many people there to help out etc.

I am building a Flutter based Admin system on top of Genji at the moment, and use GRPC with FLutter everyday. Works like a dream. Run anywhere ( Web, Desktop, Mobile).

Genji slack. You should raise all this with them !!
https://app.slack.com/client/T029RQSE6/CKPCYQFE0/thread/CKPCYQFE0-1598618530.005300