Steemit filtering tool from Curie
Clone or download
Pull request Compare This branch is 6 commits behind djordjeparovic:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
app
client
controllers
img
middlewares
templates
utils
webpack
.babelrc
.gitignore
README.md
TODO.md
faq
manifest.json
package.json
postcss.config.js
posts_refresher.js
router.json
server.js
steemlookup.config.json
webpack.config.js

README.md

Steemlookup.com

DB

CREATE TABLE steem_posts (
    permlink varchar(2000) PRIMARY KEY,
    author varchar(100),
    title varchar(2000),
    author_reputation int,
    created TIMESTAMP,
    last_visited TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    last_payout TIMESTAMP,
    tags varchar(2000),
    imageCount int,
    wordCount int,
    body varchar(100000),
    children int,
    active_votes varchar(20000),
    net_votes integer,
    pending_payout_value float,
    lang varchar(20),
    thumbnails varchar(20000)
);

create table steem_user (
    id int,
    name varchar(300) NOT NULL PRIMARY KEY,
    created TIMESTAMP,
    mined boolean,
    post_count int,
    voting_power int,
    last_vote_time TIMESTAMP,
    balance float,
    savings_balance float,
    sbd_balance float,
    savings_sbd_balance float,
    savings_withdraw_requests int,
    vesting_shares float,
    curation_rewards float,
    last_post TIMESTAMP,
    last_root_post TIMESTAMP,
    vesting_balance float,
    reputation bigint,
    witness_votes varchar(2000),
    json_metadata varchar(20000),
    sl_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

create table lookup_user (
    name varchar(100),
    email varchar(100) primary key,
    password varchar(100) not null,
    token varchar(100),
    saved_searches varchar(20000) default null,
    custom_user_list varchar(20000) default null
);

env variables

  • NODE_ENV
  • PSQL_USER
  • PSQL_HOST
  • PSQL_SLAVE_HOST
  • PSQL_DB
  • PSQL_PASS
  • PSQL_PORT
  • REDIS_HOST
  • REDIS_PASS
  • WORKER_ID
  • PULL_DATA