[Utopian-data] Switched the database to MySQL, added access_data() for query use and resolved several important issues.

in #utopian-io7 years ago (edited)

img.jpg
source

Utopian-data

github repository

What is the project about?

This tool uses https://api.steemit.com and https://api.utopian.io/ as well as coinmarketcap to fetch all the interesting Utopian related data that could in future be tied to it's growth and properly analyzed. It was created out of curiosity, but per demand of @wehmoen has now been rewritten to handle more data with a better database (MongoDB/MySQL over SQLite), as well as save more data than just liquid steem value of all Utopian accounts. As such, the code is now a part of the official Utopian-io company on Github.

New Features

What feature(s) did you add?

66ddbde1, f0f6acf, d160fc4, b1e2d59, d5fc7e0, 45cc0d3;

MySQL database
  • Switched MongoDB related code to MySQL code.

The decision was made to drop support for MongoDB and moving it to a different branch, while changing all code to support MySQL. This will help a more broad public interact with the database, as SQL is far more popular than Mongo.

Other
  • Added access_data() for users that want to run this script in real time.

The access_data() function takes in a SQL querry as an argument and returns the outcome of it, reducing the number of lines of code necessary to run every time it's requested.

  • Fixed an issue where timestamps wouldn't work and databases had to use unix instead.
  • Switched unix to UTC Timestamp.
  • Added more comments and improved code clarity ever so slightly.
The future!

The database is currently being deployed in a form of an API that everyone will be able to connect to with HTTP requests. This is likely the last update to the project, but it's soon to be deployed on utopian.info in a form of interactive charts and graphs that you can hopefully put custom queries into.

How to contribute?

You can contribute by Pull Requests on the official Github repository. You can also contact me on Discord at Jestemkioskiem#5566 to ask questions about this project and/or the code.



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Hey @jestemkioskiem I am @utopian-io. I have just upvoted you!

Achievements

  • You have less than 500 followers. Just gave you a gift to help you succeed!
  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Coin Marketplace

STEEM 0.16
TRX 0.16
JST 0.032
BTC 59615.63
ETH 2524.32
USDT 1.00
SBD 2.44