Not totally related, but stumbled upon this thing a while ago :
It claims it can automagically create a REST API on top of any database. Have not actually tested it, but that could allow to approach databases in an agnostic way, without having to develop a node set for all types.
@sebescudie I’m testing different options.
I understand that there are a number of ways to make the databases external. I’m just trying to use the bloat-free approach - quickly create a database with nodes, easily work with it with nodes. What I’ve come across in the last few years are telegram bot users. It’s dozens of times easier to make a bot with users in Python than it is in Gamma now.
Well since all the data stored in the ram I think you should be good, at list I did that for a project, just dumped bunch of tables in json (around 100k row), read it in the class, then did few methods to get data async, not 100% percent sure about writing, but I think if you use async or sync, (no parallel) it should work quite descent. However I would not recommend to use native deserialiser/serialiser and use some sort of small plug in c# that does deserialisation and querying (this would avoid bloat (technical fields that gamma does)).
Also if you looking for performant solution for key value pairs you should look to redis and not SQL