Unable to load image

Every Bardfinn comment from pullpush

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

20
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

https://i.rdrama.net/images/17206372303956187.webp

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.

:siren:BARD BOT ALERT!:siren: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.

Link copied to clipboard
Action successful!
Error, please refresh the page and try again.