hnbot

Commit Graph

Author	SHA1	Message	Date
ekzyis	cc5a05574a	Fix unique constraint hit For HN reposts, the same SN dupe was found but since sn_items.id was the primary key, a unique constraint was hit. This meant that posting the same item was attempted over and over again since the HN item id was never found in sn_items. I manually migrated the database.	2024-04-25 18:24:27 +02:00
ekzyis	7e4744503f	Store time series of HN data in SQLite3 This can be used in the future for better content curation and generating charts. Currently, it still posts stories when they hit rank 1.	2024-03-13 13:41:04 +01:00

Author

SHA1

Message

Date

ekzyis

cc5a05574a

Fix unique constraint hit

For HN reposts, the same SN dupe was found but since sn_items.id was the primary key, a unique constraint was hit.

This meant that posting the same item was attempted over and over again since the HN item id was never found in sn_items.

I manually migrated the database.

2024-04-25 18:24:27 +02:00

ekzyis

7e4744503f

Store time series of HN data in SQLite3

This can be used in the future for better content curation and generating charts.

Currently, it still posts stories when they hit rank 1.

2024-03-13 13:41:04 +01:00

2 Commits