v0.5.0-alpha.1

v0.5.0(alpha)

Added

• add LoggerOpenObserve feature use OpenObserve to collect log.#370
  add LoggerOpenObserve to conf.yaml 's Features section to enable this feature like below:

  # file config.yaml
  ...
  Features:
    Default: ["Base", "Postgres", "Meili", "LocalOSS", "LoggerOpenObserve", "BigCacheIndex", "web"]
  LoggerOpenObserve: # 使用OpenObserve写日志
  Host: 127.0.0.1:5080
  Organization: paopao-ce
  Stream: default
  User: [email protected]
  Password: tiFEI8UeJWuYA7kN
  Secure: False
  MinWorker: 5               # 最小后台工作者, 设置范围[5, 100], 默认5
  MaxLogBuffer: 100          # 最大log缓存条数, 设置范围[10, 10000], 默认100
  ...

• Added friend tweets bar feature support in home page. #377
• web: add custom Friendship feature support. To custom setup Friendship use below configure in web/.env or web/.env.local

  # 功能特性开启
  VITE_USE_FRIENDSHIP=true
  
  # 模块开启
  VITE_ENABLE_FRIENDS_BAR=true

• add Newest/Hots/Following tweets support in friend bar feature.
  mirgration database first(sql ddl file in scripts/migration/**/*_home_timeline.up.sql):

CREATE TABLE `p_post_metric` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint unsigned NOT NULL,
  `rank_score` bigint unsigned NOT NULL DEFAULT 0,
  `incentive_score` int unsigned NOT NULL DEFAULT 0,
  `decay_factor` int unsigned NOT NULL DEFAULT 0,
  `motivation_factor` int unsigned NOT NULL DEFAULT 0,
  `is_del` tinyint NOT NULL DEFAULT 0, -- 是否删除, 0否, 1是
  `created_on` bigint unsigned NOT NULL DEFAULT '0',
  `modified_on` bigint unsigned NOT NULL DEFAULT '0',
  `deleted_on` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_post_metric_post_id_rank_score` (`post_id`,`rank_score`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO p_post_metric (post_id, rank_score, created_on) 
SELECT id AS post_id, 
    comment_count + upvote_count*2 + collection_count*4 AS rank_score,
    created_on
FROM p_post
WHERE is_del=0;

-- 原来的可见性: 0公开 1私密 2好友可见 3关注可见
-- 现在的可见性: 0私密 10充电可见 20订阅可见 30保留 40保留 50好友可见 60关注可见 70保留 80保留 90公开
UPDATE p_post a, p_post b 
SET a.visibility = (
  CASE b.visibility 
  	WHEN 0 THEN 90 
  	WHEN 1 THEN 0 
  	WHEN 2 THEN 50 
  	WHEN 3 THEN 60 
  	ELSE 0
  END 
)
WHERE a.ID = b.ID;

• add cache support for index/home etc. page.

Changed

• some other optimize.

---

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.1 darwin/amd64)

./build-release.sh && ./build-image.sh

发布的二进制文件中只测试了paopao-ce-darwin_amd64，其余平台的未亲测，如有问题，请使用源码在自己平台下自行构建。

您可以使用如下命令启动一个测试实例尝鲜:

docker compose up -d
# visit http://localhost:8008  👀 paopao-ce
# visit http://localhost:8001  👀 RedisInsight
# visit http://localhost:8080  👀 phpMyAdmin