Social media proxy

• volta
• nodejs
• telegraf framework
• serverless framework
• serverless-http
• yandex-cloud-serverless-plugin

Setup

• install volta

• install yc cli

git clone https://github.com/nezort11/telegraf-serverless-yandex-cloud-template.git your-project-name
cd ./your-project-name
rm -rf .git

volta install node@18
pnpm install

# Start development server
pnpm dev

Scripts

List all latest posted:

SELECT *
  FROM posted
ORDER BY id DESC;

Delete some posted tweet:

DELETE FROM posted
WHERE id = "1932936634061766884";

Get specific author tweets:

SELECT * FROM tweets WHERE JSON_VALUE(data, "$.author.userName") = "JohnPiper";

Music

Music table link:

https://console.yandex.cloud/folders/b1gjh7irh9poadr6llcg/ydb/databases/etnuqad1rfmi6i6lc0h2/browse?path=%2Fmusic

Delete music from posted

DELETE FROM `music` WHERE id = "pTPCs8FQnJQ";