You are viewing a single comment's thread from:

RE: Tower: A REST API implementation on the top of Hivemind

in #utopian-io • 6 years ago

What are your storage needs currently? I would like to do something similar, started off doing it in MySQL but getting all the data means gigs and gigs of space is needed.

6 years ago in #utopian-io by
$0.24
  • Past Payouts $0.24, 0.00 TRX
  • - Author $0.18, 0.00 TRX
  • - Curators $0.06, 0.00 TRX
2 votes
Reply 2
Sort:  
  • Trending
    • [-]
     6 years ago (edited)
    postgres=# SELECT pg_size_pretty( pg_database_size('hive') );
 pg_size_pretty
----------------
 181 GB
(1 row)

    181 GB for hivemind. But beware, Hive doesn't store all the data of the blockchain.

    $0.03
    • Past Payouts $0.03, 0.00 TRX
    • - Author $0.02, 0.00 TRX
    • - Curators $0.01, 0.00 TRX
    1 vote
    Reply
    [-]
     6 years ago 

    Thanks for this, I see it's a Postgres db in the back then.

    I am interested in only a subset of the data. Is it possible to filter posts where the parent id is empty (i.e. only get back posts, not comments)?

    Going to read up a bit more.

    $0.00
      Reply