You are viewing a single comment's thread from:

RE: SteemWorld ~ Weekly Support ~ #21

in #steemworld6 years ago

I just read the post by @gadrian (which I see you've spotted and resteemed) and learned about what you are currently working on.

As a utopian CM and contributor to the Analysis category I am very interested in this new data service. I don't see a mention of SQL though, and so i'm feeling a bit outdated :)

Will it be all web-service based?

Thank you as always for your hard work on Steem!

Sort:  

I'm working with regular relational databases, so of course, you can use SQL for querying the desired data. Since there is only a single process, that needs to write to the DBs at a time, I don't need to run any extra DB services like postgresql, mysql, mongodb or others, which would add an extra layer in between you and the data (always leads to extra performance costs). Many developers don't know that SQLite on SSD outperforms these big names with ease (as long as only one process writes data at a time). But I've planned to implement interfaces to other database systems as well (will come later).

The data service is based on Node.js, therefore it can be started locally or as a public web service without the need of running any additional servers like apache/nginx with php or so. I will also publish a documentation for the web service API. For local analyzing it won't even be needed to use the API, because the DB files are directly accessible and SQL queries can be executed via a direct connection from any app or via ODBC in a local network.

Nice! Thanks for the info and the service, looking forward to it :D