[New Features on steemr] Now steemr supports SteemSQL queries!
Repo
https://github.com/pzhaonet/steemr
New Features
steemr is an open source R package for playing with Steem data in R environment. It is used to download, post process, analyze, and visualize Steem data on the basis of the powerful statistic power of R.
What features did I add?
In the recent week, steemr has been updated from version 0.0.0 to version 0.0.5. Users can simply ignore 0.0.1 to 0.0.4, which were slightly modified to meet the requirements by CRAN. However, users cannot miss version 0.0.5, which now supports SteemSQL queries!
The main features of version 0.0.5 are listed as follows:
The following functions support SteemSQL queries with the parameter
method
to specify the server, andsql_id
andsql_password
to specify the SteemSQL ID and password, respectively:follower(method = 'steemsql.com', sql_id = your_id, sql_password = your_password) id_info(method = 'steemsql.com', sql_id = your_id, sql_password = your_password) post_df(method = 'steemsql.com', sql_id = your_id, sql_password = your_password) post_id(method = 'steemsql.com', sql_id = your_id, sql_password = your_password) post_info(method = 'steemsql.com', sql_id = your_id, sql_password = your_password) post_links(method = 'steemsql.com', sql_id = your_id, sql_password = your_password)
For example, users can get all the posts by an author from SteemSQL with a single command:
post_id(id = author_id, method = 'steemsql.com', sql_id = your_id, sql_password = your_password)
Of course, the pre-requirements is that you should have a valid SteemSQL ID. Go to https://steemsql.com and apply one.
If you don't have a SteemSQL ID, you can simply ignore the method
parameter, and retrieve data from steemdb.com by default.
The documentation has been improved.
Some minor literal chagnes.
How did I implement them?
I added the SQL queries with the R RODBC package and added the options that users can choose the server. Link to relevant lines in the code on GitHub can be found mainly in my latest commits:
https://github.com/pzhaonet/steemr/commit/617f36e6ae5c4aa0d06f1bc311f30afa75d38afb
The following figure shows how I updated a function as an example:
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
Thank you very much for your comments. I have just added an image to show what I did as an example.
Hey @dapeng
Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!
Contributing on Utopian
Learn how to contribute on our website or by watching this tutorial on Youtube.
Want to chat? Join us on Discord https://discord.gg/h52nFrV.
Vote for Utopian Witness!
Thanks, dear bot!