Reduce size of a SQLite database -

i created sqlite database yelp datasets client. resulting .db file 8.2gb in size, server optimized smaller databases -- 1gb or smaller, ideally ~100mb.

how on earth shrink down 8.2gb database tiny size?

if has thoughts, appreciate them. in advance!