Discussion
Loading...

Post

Log in
  • About
  • Code of conduct
  • Privacy
  • Users
  • Instances
  • About Bonfire
argv minus one
argv minus one
@argv_minus_one@mastodon.sdf.org  ·  activity timestamp 2 weeks ago

I downloaded my Reddit history archive. It has a giant list of every comment I've ever made, as a CSV file.

I wanted to look at each comment, in context, on #Reddit. (To do that you need to open the URL in your browser with ?context=9 appended to the URL.)

At first, I loaded this behemoth into LibreOffice Calc, but it does not like data that big.

Then I was like, “hey wait, this is basically a database.” So I loaded it into SQLite.

#SQLite has absolutely no problem with data that big. 😌

  • Copy link
  • Flag this post
  • Block
argv minus one
argv minus one
@argv_minus_one@mastodon.sdf.org replied  ·  activity timestamp 2 weeks ago

To import the data, all you have to do is open a new file with the sqlite3 command-line tool, and then:

sqlite> .mode csv
sqlite> .import comments.csv comments
sqlite> .mode list

This will create a new table named “comments”, loaded with every comment in your archive.

  • Copy link
  • Flag this comment
  • Block

bonfire.cafe

A space for Bonfire maintainers and contributors to communicate

bonfire.cafe: About · Code of conduct · Privacy · Users · Instances
Bonfire social · 1.0.1-beta.35 no JS en
Automatic federation enabled
Log in
  • Explore
  • About
  • Members
  • Code of Conduct