rinsuki/sea

🌊 a minimal (chat-like) social-networking service for closed small community.

Sea 🌊

Requires

• Node.js 12.x
• Postgres >= 10.x

How to develop

cp .env.example .env
yarn web-push generate-vapid-keys
# Insert your vapid keys to .env
editor .env
docker-compose up

Deploy

Heroku

Docker

https://hub.docker.com/r/rinsuki/sea

sea's Issues

タイムライン取得時に使えるインデックスがない

ので投稿が増えるとタイムラインが遅くなる

添付画像の削除

の実装

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on Greenkeeper branches of this repository. 🚨

To enable Greenkeeper, you need to make sure that a commit status is reported on all branches. This is required by Greenkeeper because it uses your CI build statuses to figure out when to notify you about breaking changes.

Since we didn’t receive a CI status on the greenkeeper/initial branch, it’s possible that you don’t have CI set up yet. We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

If you have already set up a CI for this repository, you might need to check how it’s configured. Make sure it is set to run on all new branches. If you don’t want it to run on absolutely every branch, you can whitelist branches starting with greenkeeper/.

Once you have installed and configured CI on this repository correctly, you’ll need to re-trigger Greenkeeper’s initial pull request. To do this, please click the 'fix repo' button on account.greenkeeper.io.

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on Greenkeeper branches of this repository. 🚨

To enable Greenkeeper, you need to make sure that a commit status is reported on all branches. This is required by Greenkeeper because it uses your CI build statuses to figure out when to notify you about breaking changes.

Since we didn’t receive a CI status on the greenkeeper/initial branch, it’s possible that you don’t have CI set up yet. We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

If you have already set up a CI for this repository, you might need to check how it’s configured. Make sure it is set to run on all new branches. If you don’t want it to run on absolutely every branch, you can whitelist branches starting with greenkeeper/.

Once you have installed and configured CI on this repository correctly, you’ll need to re-trigger Greenkeeper’s initial pull request. To do this, please click the 'fix repo' button on account.greenkeeper.io.

API will return 500 Internal Server Error when access to /oauth/authorize without login

ログイン画面にリダイレクト飛ばして

Action Required: Fix Renovate Configuration

There is an error with this repository's Renovate configuration that needs to be fixed. As a precaution, Renovate will stop PRs until it is resolved.

Error type: undefined. Note: this is a nested preset so please contact the preset author if you are unable to fix it yourself.

topic

ハッシュタグ的なやつ

• 付けないとデフォルトの #lobby になる
• 一個しか付けられない
• 新しいやつが欲しいときは作成する必要がある
• ユーザーは任意のトピックをミュートできる
• タイムラインAPIでは特定のトピックのみのタイムラインを取得することもできる
• ユーザーはトピックを任意個数お気に入りにできる、よく使うトピックをお気に入りにして上位に固定などを想定(あれこれ並び順決められて欲しくね…？)

どう思いますか @otofune @motitaiyaki

サブアカウント

• @bot.admin のように、<subaccount name>.<owner name>でサブアカウントを作れるようにする
  • 主にbot用などを想定
• 以下の画面で、サブアカウントを選択して利用できるようにする
  • アプリ認証画面
  • アプリのアクセストークン発行画面
• サブアカウントとしてのWebUIへのログインはできない

avatarFile の参照削除方法

案

• DELETE /api/v1/account/avatarFile by otofune
• PATCH /api/v1/account with {avatarFile: null} by me
• PATCH /api/v1/account with {avatarFile: 0} by me
• PATCH /api/v1/account with {avatarFile: -1} by rinsuki

Your .dependabot/config.yml contained invalid details

Dependabot encountered the following error when parsing your .dependabot/config.yml:

Automerging is not enabled for this account. You can enable it from the [account settings](https://app.dependabot.com/accounts/rinsuki/settings) screen in your Dependabot dashboard.

Please update the config file to conform with Dependabot's specification using our docs and online validator.

WebUIのSPA化

• 全部APIに押し込めることでスクレイピングの必要性をなくす
• そのついでにテストがしやすくなる
• pugを書く必要もなくなる

subscriptions で description のキー名が間違っている

GET /api/v1/subscriptions にて本来は description であるべきキーの値が name となっている

リアクション

• カスタム絵文字 #263 と、Twemoji由来(要検討)の絵文字を利用できるようにする
• Unicode絵文字はTwemojiのshortcodeに落とせる物のみ受け付け、Twemojiのshortcodeに変換する

アプリ向けのKey-Valueストア

app * user 分のKVSを用意したい。
用途としては設定の共有などを想定。

要検討

別appにも公開、別userにも公開などのフラグがあるといいかも?
データ量制限について
KVSのwatch用ストリーミングAPIを作る?

POST /api/v1/posts の user.avatarFile がnull

全文検索

WebPush による通知待受機能

• 通知を受け取れるエンドポイントをユーザー側で n つまで指定できる機能の提案
• 現時点で送信可能な通知: リプライ
• 形式: Slack Compatible?
• 制約: Slack / Discord に絞ってしまう?

Redirect /oauth/authorize to login without logged in

ログイン後に戻ってこれると嬉しい (?next= とかでパス渡せるといいのか？)

アルバムのファイル一覧

カスタム絵文字

• 以下の3つを用意する
  • グローバルカスタム絵文字
    • :emoji_name:で利用可能
  • ユーザーカスタム絵文字
    • :emoji_name@user_name:で利用可能
    • 自分の絵文字に限り :emoji_name@:でも利用可能 (になるが、サーバー側で@のあとにユーザー名を付与する)
  • ユーザーアイコン絵文字
    • :@user_name:で利用可能
    • 指定されたユーザーのアイコンを取る

Dependency Dashboard

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Warning

These dependencies are deprecated:

Datasource	Name	Replacement PR?
npm	@types/redis
npm	@types/sharp

Edited/Blocked

These updates have been manually edited so Renovate will no longer make changes. To discard all commits and start over, click on a checkbox.

• Update dependency @types/supertest to ^2.0.16
• Update dependency dotenv to ^9.0.2
• Update dependency http-errors to ^1.8.1 (http-errors, @types/http-errors)
• Update Node.js to >=12.22.12
• Update dependency redis-mock to ^0.56.3
• Update dependency tsc-watch to ^4.6.2
• Update dependency typescript to ^3.9.10
• Update dependency web-push to ^3.6.7 (web-push, @types/web-push)
• Update redis Docker tag to v7

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• Update dependency pug to v3.0.3 [SECURITY]
• Update dependency axios to ^0.28.0 [SECURITY]
• Update dependency file-type to v16.5.4 [SECURITY]
• Update dependency got to v12.1.0 [SECURITY]
• Update dependency redis to v3.1.1 [SECURITY]
• Update dependency sharp to ^0.32.0 [SECURITY]
• Update dependency typeorm to ^0.3.0 [SECURITY]
• Update dependency ws to v7.5.10 [SECURITY]
• Update dependency @types/pug to ^2.0.10
• Update dependency ts-jest to ^27.1.5
• Update codecov/codecov-action action to v1.5.2
• Update dependency @types/cookies to ^0.9.0
• Update dependency @types/sharp to ^0.32.0
• Update dependency @types/ws to ^8.5.12
• Update dependency aws-sdk to ^2.1680.0
• Update dependency date-fns to ^2.30.0
• Update dependency koa to ^2.15.3 (koa, @types/koa)
• Update dependency pg to ^8.12.0
• Update dependency playwright-firefox to ^1.46.1
• Update dependency prettier to ^2.8.8
• Update dependency raw-body to ^2.5.2
• Update dependency reflect-metadata to ^0.2.2
• Update jest monorepo (@types/jest, jest)
• Update node Docker tag to v14.21.3 (node, @types/node)
• Update react monorepo (@types/react, @types/react-dom)
• Update GitHub Artifact Actions to v4 (major) (actions/download-artifact, actions/upload-artifact)
• Update Node.js to v20 (node, @types/node)
• Update actions/cache action to v4
• Update codecov/codecov-action action to v4
• Update dependency @koa/router to v13
• Update dependency @types/koa__router to v12
• Update dependency @types/redis to v4
• Update dependency @types/supertest to v6
• Update dependency bcrypt to ^5.1.1 (bcrypt, @types/bcrypt)
• Update dependency date-fns to v3
• Update dependency dotenv to v16
• Update dependency http-errors to v2 (http-errors, @types/http-errors)
• Update dependency koa-body to v6
• Update dependency prettier to v3
• Update dependency raw-body to v3
• Update dependency supertest to v7
• Update dependency tsc-watch to v6
• Update dependency typescript to v5
• Update jest monorepo to v29 (major) (@types/jest, jest, ts-jest)
• Update postgres Docker tag to v16
• Update react monorepo to v18 (major) (@types/react, @types/react-dom, react, react-dom)
• Click on this checkbox to rebase all open PRs at once

Detected dependencies

docker-compose

docker-compose.yml

• postgres 12
• redis 5

e2e/docker-compose.yml

• postgres 12
• redis 5

dockerfile

Dockerfile

• node 14-alpine

github-actions

.github/workflows/build-and-test.yaml

• actions/cache v2
• actions/upload-artifact v2
• actions/download-artifact v2
• codecov/codecov-action v1.1.1
• actions/download-artifact v2
• actions/upload-artifact v2

npm

e2e/package.json

• got ^12.0.0
• playwright-firefox ^1.17.1

package.json

• @koa/router ^9.4.0
• @linkage-community/bottlemail ^3.0.0
• aws-sdk ^2.1050.0
• axios ^0.21.1
• bcrypt ^5.0.0
• date-fns ^2.16.1
• dotenv ^9.0.0
• file-type ^16.0.0
• http-errors ^1.8.0
• koa ^2.13.0
• koa-body ^4.2.0
• pg ^8.5.1
• pug ^3.0.0
• raw-body ^2.4.1
• react ^17.0.2
• react-dom ^17.0.2
• redis ^3.0.2
• reflect-metadata ^0.1.13
• sharp ^0.27.0
• transform-ts ^0.3.0
• typeorm ^0.2.22
• web-push ^3.4.4
• ws ^7.4.1
• @types/bcrypt ^3.0.1
• @types/http-errors ^1.8.1
• @types/jest ^27.4.0
• @types/koa ^2.11.5
• @types/koa__router ^8.0.11
• @types/node ^14.18.5
• @types/pug ^2.0.6
• @types/react ^16.9.53
• @types/react-dom ^17.0.11
• @types/redis ^2.8.32
• @types/sharp ^0.27.1
• @types/supertest ^2.0.11
• @types/web-push ^3.3.1
• @types/ws ^8.2.2
• jest ^27.4.6
• prettier ^2.1.2
• redis-mock ^0.52.0
• supertest ^5.0.0
• ts-jest ^27.1.2
• tsc-watch ^4.2.9
• typescript ^3.8.3
• node >=12
• @types/cookies ^0.7.7

---

• Check this box to trigger a request for Renovate to run again on this repository

ある投稿に対するリプライ一覧を取得したい

例えば投稿詳細画面を実装する際に使いたい

API will return 500 Internal Server Error when try to post with too big text

Add before,after query to /v1/timelines/local API