https://files.catbox.moe/lns6xi.zip
Sqlite database in a table called bardchive
Columns:
id - numeric autogenerated id
time - timestamp in utc
epoch - timestamp in epoch format
text - the comment text
sub - the comment subreddit
link_id - reddit comment id
controversial - if comment was controversial
score - comment score
name - reddit comment name
parent_id - reddit parent id
pp_id - pullpush comment id
Jump in the discussion.
No email address required.
For anyone else as interested in this as I am, a few things I've found useful:
Add a comment length field
Add Bardfinn's local timezone date. It's -06:00 UTC Central American Timezone (I think).
Create a view which formats the URL for Reddit and the pull push undelete
I'm going for a run now, but tomorrow I need to add a word count. I have a function already for this at work which I will steal, but can't be bothered recreating it now.
None of this is difficult but if anyone wants it exported to another SQLLite database lemme know.
Jump in the discussion.
No email address required.
BARD BOT ALERT!Current streak was: 0 days 00 hours 03 minutes and 53 seconds
Record is 1 days 13 hours 09 minutes and 59 seconds by TheDunceonFlorist
rdrama is currently running at 328.704 µBardyhertz
Jump in the discussion.
No email address required.
More options
Context
More options
Context