paopao-ce

v0.5.0(alpha)

Fixed

• fixed get user tweets error when use cache &35b8657

备注：发布版本中，使用如下命令构建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

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

Fixed

• fixed remove multi-objects no effects and occurs resource leak error when use Minio as OSS(Object Storage System).#371 #372

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

Changed

• infinite scrolling instead of pagination for Home/User/Profile page

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

Added

• adapt paopao-ce v0.4 that use sqlx as ORM.

The source code is in r/paopao-ce-plus branch.

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

Added

• add pprof feature support #327
• use compiler profile-guided optimization (PGO) to further optimize builds. #327
• frontend: re-add stars page embed to profile page. #339
• simple support for user posts filter by style(post/comment/media/star). #345
  migration database first(sql ddl file in scripts/migration/**/*_create_view_post_filter.up.sql):

  CREATE VIEW p_post_by_media AS SELECT post.*FROM (SELECT DISTINCT post_id FROM p_post_content WHERE (TYPE=3 OR TYPE=4 OR TYPE=7 OR TYPE=8) AND is_del=0) media JOIN p_post post ON media.post_id=post.ID WHERE post.is_del=0;
  CREATE VIEW p_post_by_comment AS SELECT P.*,C.user_id comment_user_id FROM (SELECT post_id,user_id FROM p_comment WHERE is_del=0 UNION SELECT post_id,reply.user_id user_id FROM p_comment_reply reply JOIN p_comment COMMENT ON reply.comment_id=COMMENT.ID WHERE reply.is_del=0 AND COMMENT.is_del=0) C JOIN p_post P ON C.post_id=P.ID WHERE P.is_del=0;
  

• add user highlight tweet support include custom tweet set to highlight and list in user/profile page.
• add cli subcommand to start paopao-ce serve or other task. #354
• add Followship feature . #355
  migration database first(sql ddl file in scripts/migration/**/*_user_following.up.sql):

  DROP TABLE IF EXISTS p_following; 
  CREATE TABLE p_following (ID BIGSERIAL PRIMARY KEY,user_id BIGINT NOT NULL,follow_id BIGINT NOT NULL,is_del SMALLINT NOT NULL DEFAULT 0,created_on BIGINT NOT NULL DEFAULT 0,modified_on BIGINT NOT NULL DEFAULT 0,deleted_on BIGINT NOT NULL DEFAULT 0); 
  CREATE INDEX idx_following_user_follow ON p_following USING btree (user_id,follow_id);
  

Changed

• change man content width to 600px and optimize tweet/comment/replay text length. #333
• optimize embed web ui to paopao execute binary file logic. #354

  # embed web ui to execute file default
  make build 
  # use slim model to disable embed web ui to exectute file
  make build TAGS='slim embed'
  

• frontend: optimize user profile page route path to domain/#/u/?s=username. [&c857142](https://github.com/rocboss/paopao-ce/commit/c857142565f0c28294344c7abc5c2df4e363b04c
• change the Friendship feature and Followship feature as builtin feature. #362
• deprecated/remove Lightship feature. #362
• optimize Followship feature allow follow/unfollow user in follow page. &fd5e54b
• use Meilisearch as default search in docker-compose.yaml.

Fixed

• fixed JWT valide error whent get user by id failed.&51fd972

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(rc)

Added

• add pprof feature support #327
• use compiler profile-guided optimization (PGO) to further optimize builds. #327
• frontend: re-add stars page embed to profile page. #339
• simple support for user posts filter by style(post/comment/media/star). #345
  migration database first(sql ddl file in scripts/migration/**/*_create_view_post_filter.up.sql):

  CREATE VIEW p_post_by_media AS SELECT post.*FROM (SELECT DISTINCT post_id FROM p_post_content WHERE (TYPE=3 OR TYPE=4 OR TYPE=7 OR TYPE=8) AND is_del=0) media JOIN p_post post ON media.post_id=post.ID WHERE post.is_del=0;
  CREATE VIEW p_post_by_comment AS SELECT P.*,C.user_id comment_user_id FROM (SELECT post_id,user_id FROM p_comment WHERE is_del=0 UNION SELECT post_id,reply.user_id user_id FROM p_comment_reply reply JOIN p_comment COMMENT ON reply.comment_id=COMMENT.ID WHERE reply.is_del=0 AND COMMENT.is_del=0) C JOIN p_post P ON C.post_id=P.ID WHERE P.is_del=0;
  

• add user highlight tweet support include custom tweet set to highlight and list in user/profile page.
• add cli subcommand to start paopao-ce serve or other task. #354
• add Friendship feature . #355
  migration database first(sql ddl file in scripts/migration/**/*_user_following.up.sql):

  DROP TABLE IF EXISTS p_following; 
  CREATE TABLE p_following (ID BIGSERIAL PRIMARY KEY,user_id BIGINT NOT NULL,follow_id BIGINT NOT NULL,is_del SMALLINT NOT NULL DEFAULT 0,created_on BIGINT NOT NULL DEFAULT 0,modified_on BIGINT NOT NULL DEFAULT 0,deleted_on BIGINT NOT NULL DEFAULT 0); 
  CREATE INDEX idx_following_user_follow ON p_following USING btree (user_id,follow_id);
  

Changed

• change man content width to 600px and optimize tweet/comment/replay text length. #333
• optimize embed web ui to paopao execute binary file logic. #354

  # embed web ui to execute file default
  make build 
  # use slim model to disable embed web ui to exectute file
  make build TAGS='slim embed'
  

• frontend: optimize user profile page route path to domain/#/u/?s=username. [&c857142](https://github.com/rocboss/paopao-ce/commit/c857142565f0c28294344c7abc5c2df4e363b04c
• change the Friendship feature and Followship feature as builtin feature. #362
• deprecated/remove Lightship feature. #362
• optimize Folloship feature allow follow/unfollow user in follow page. &fd5e54b

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(beta)

Added

• add pprof feature support #327
• use compiler profile-guided optimization (PGO) to further optimize builds. #327
• frontend: re-add stars page embed to profile page. #339
• simple support for user posts filter by style(post/comment/media/star). #345
  migration database first(sql ddl file in scripts/migration/**/*_create_view_post_filter.up.sql):

  CREATE VIEW p_post_by_media AS SELECT post.*FROM (SELECT DISTINCT post_id FROM p_post_content WHERE (TYPE=3 OR TYPE=4 OR TYPE=7 OR TYPE=8) AND is_del=0) media JOIN p_post post ON media.post_id=post.ID WHERE post.is_del=0;
  CREATE VIEW p_post_by_comment AS SELECT P.*,C.user_id comment_user_id FROM (SELECT post_id,user_id FROM p_comment WHERE is_del=0 UNION SELECT post_id,reply.user_id user_id FROM p_comment_reply reply JOIN p_comment COMMENT ON reply.comment_id=COMMENT.ID WHERE reply.is_del=0 AND COMMENT.is_del=0) C JOIN p_post P ON C.post_id=P.ID WHERE P.is_del=0;
  

• add user highlight tweet support include custom tweet set to highlight and list in user/profile page.
• add cli subcommand to start paopao-ce serve or other task. #354
• add Friendship feature . #355
  migration database first(sql ddl file in scripts/migration/**/*_user_following.up.sql):

  DROP TABLE IF EXISTS p_following; 
  CREATE TABLE p_following (ID BIGSERIAL PRIMARY KEY,user_id BIGINT NOT NULL,follow_id BIGINT NOT NULL,is_del SMALLINT NOT NULL DEFAULT 0,created_on BIGINT NOT NULL DEFAULT 0,modified_on BIGINT NOT NULL DEFAULT 0,deleted_on BIGINT NOT NULL DEFAULT 0); 
  CREATE INDEX idx_following_user_follow ON p_following USING btree (user_id,follow_id);
  

Changed

• change man content width to 600px and optimize tweet/comment/replay text length. #333
• optimize embed web ui to paopao execute binary file logic. #354

  # embed web ui to execute file default
  make build 
  # use slim model to disable embed web ui to exectute file
  make build TAGS='slim embed'
  

• frontend: optimize user profile page route path to domain/#/u/?s=username. [&c857142](https://github.com/rocboss/paopao-ce/commit/c857142565f0c28294344c7abc5c2df4e363b04c
• change the Friendship feature and Followship feature as builtin feature. #362
• deprecated/remove Lightship feature. #362
• optimize Folloship feature allow follow/unfollow user in follow page. &fd5e54b

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(alpha)

Changed

• frontend: optimize user/profile page in dark theme.&6b96954
• frontend: add following tag in user page.&097cfd9
• change the Friendship feature and Followship feature as builtin feature. #362
• deprecated/remove Lightship feature. #362

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(alpha)

Added

• add Friendship feature . #355
  mirgration database first(sql ddl file in scripts/migration/**/*_user_following.up.sql):

  DROP TABLE IF EXISTS p_following; 
  CREATE TABLE p_following (ID BIGSERIAL PRIMARY KEY,user_id BIGINT NOT NULL,follow_id BIGINT NOT NULL,is_del SMALLINT NOT NULL DEFAULT 0,created_on BIGINT NOT NULL DEFAULT 0,modified_on BIGINT NOT NULL DEFAULT 0,deleted_on BIGINT NOT NULL DEFAULT 0); 
  CREATE INDEX idx_following_user_follow ON p_following USING btree (user_id,follow_id);
  

  custom set config.yaml in Features section add Followship to enable Followship feature:

  ...
  # add Followship to enable this feature
  Features:
    Default: ["Meili", "LoggerMeili", "Base", "Sqlite3", "BigCacheIndex", "MinIO", "Followship"]
    Base: ["Redis", "PhoneBind"]
  ...
  

Changed

• frontend: optimize user profile page route path to domain/#/u/?s=username. &c857142

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(alpha)

Added

• add cli subcommand to start paopao-ce serve or other task. #354

Changed

• optimize embed web ui to paopao execute binary file logic. #354

  # embed web ui to execute file default
  make build 
  # use slim model to disable embed web ui to exectute file
  make build TAGS='slim embed'
  

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(alpha)

Fixed

• fixed get user comment tweets return incorrect data error.&1a41075
  mirgration database first(sql ddl file in scripts/migration/**/*_create_view_post_filter.up.sql):

  CREATE VIEW p_post_by_comment AS SELECT P.*,C.user_id comment_user_id FROM (SELECT post_id,user_id FROM p_comment WHERE is_del=0 UNION SELECT post_id,reply.user_id user_id FROM p_comment_reply reply JOIN p_comment COMMENT ON reply.comment_id=COMMENT.ID WHERE reply.is_del=0 AND COMMENT.is_del=0) C JOIN p_post P ON C.post_id=P.ID WHERE P.is_del=0;
  

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(alpha)

Fixed

• fixed mysql sql ddl define error for post_content/comemnt_content/comment_reply table.

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.21.0 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

v0.4.0(alpha)

Added

• add pprof feature support #327
• use compiler profile-guided optimization (PGO) to further optimize builds. #327
• frontend: re-add stars page embed to profile page. #339
• simple support for user posts filter by style(post/comment/highlights/media/likes). #345
  mirgration database first(sql ddl file in scripts/migration/**/*_create_view_post_filter.up.sql):

  CREATE VIEW p_post_by_media AS SELECT post.*FROM (SELECT DISTINCT post_id FROM p_post_content WHERE (TYPE=3 OR TYPE=4 OR TYPE=7 OR TYPE=8) AND is_del=0) media JOIN p_post post ON media.post_id=post.ID WHERE post.is_del=0;
  CREATE VIEW p_post_by_comment AS SELECT P.*FROM (SELECT post_id FROM p_comment WHERE is_del=0 UNION SELECT post_id FROM p_comment_reply reply JOIN p_comment COMMENT ON reply.comment_id=COMMENT.ID WHERE reply.is_del=0 AND COMMENT.is_del=0) C JOIN p_post P ON C.post_id=P.ID WHERE P.is_del=0;
  

• add user highlight tweet support include custom tweet set to highlight and list in user/profile page.

Changed

• change man content width to 600px and optimize tweet/comment/replay text length. #333

Fixed

• fixed: video player assets cdn error. &caff8c0

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.20.5 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

Added

• add custom comment sort strategy support #243
• add RedisCacheIndex feature #250
• add Sentry feature #258
• add simple tweet share feature(just copy tweet link to clipboard now) support #264
• add default tweet max length configure in web/.env support. &a1160ca
  Set the value of VITE_DEFAULT_TWEET_MAX_LENGTH in file web/.env to change the tweet max default length.
• add custom whether provide user register configure in web/.env support. #267
  Set the value of VITE_ALLOW_USER_REGISTER in file web/.env to custom whether provide user register feature.

  # file: web/.env or web/.env.local
  ...
  # 局部参数
  VITE_ALLOW_USER_REGISTER=true
  ...
  

  and disallow user register in backend(add Web:DisallowUserRegister feature in config.yaml):

  # file config.yaml
  ...
  Features:
    Default: ["Base", "Postgres", "Zinc", "LocalOSS", "LoggerZinc", "BigCacheIndex", "Friendship", "Service", "Web:DisallowUserRegister"]
  ...
  

• add topic follow feature support #273
  mirgration database first(sql ddl file in scripts/migration/**/*_topic_follow.up.sql):

    CREATE TABLE `p_topic_user` (
        `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
        `topic_id` BIGINT UNSIGNED NOT NULL COMMENT '标签ID',
        `user_id` BIGINT UNSIGNED NOT NULL COMMENT '创建者ID',
        `alias_name` VARCHAR ( 255 ) COMMENT '别名',
        `remark` VARCHAR ( 512 ) COMMENT '备注',
        `quote_num` BIGINT UNSIGNED COMMENT '引用数',
        `is_top` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否置顶 0 为未置顶、1 为已置顶',
        `created_on` BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
        `modified_on` BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '修改时间',
        `deleted_on` BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
        `is_del` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除 0 为未删除、1 为已删除',
        `reserve_a` VARCHAR ( 255 ) COMMENT '保留字段a',
        `reserve_b` VARCHAR ( 255 ) COMMENT '保留字段b',
        PRIMARY KEY ( `id` ) USING BTREE,
      UNIQUE KEY `idx_topic_user_uid_tid` ( `topic_id`, `user_id` ) USING BTREE 
    ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户话题';
  

• add tweet comment thumbs up/down feature support #275
  mirgration database first(sql ddl file in scripts/migration/**/*_comment_thumbs.up.sql):
• add load more comments feature support &60b217b

Fixed

• fixed sql ddl p_contact's column is_delete define error (change to is_del) in scripts/paopao-mysql.sql &afd8fe1
• fixed cache index not expire in delete/add tweet error #266
• fixed tweet's owner not allow star/collection action when tweet is private error #274
• fixed user not list owner's collectioned private tweet error #274
• fixed comments thumbs up/down state incorrect error #283

Changed

• use github.com/rueian/rueidis as Redis client #249
  the Old redis client configure field

  ...
  Redis:
    Host: redis:6379
    Password: 
    DB: 
  

  the New redis client configure field

  ...
  Redis:
    InitAddress:
    - redis:6379
    Username:
    Password:
    SelectDB:
    ConnWriteTimeout: 60   # 连接写超时时间 多少秒 默认 60秒
  

• optimize web frontend dark theme &b082a8f
• change web frontend main content layout default size to 544px &b082a8f
• optimize web frontend in mobile environment use Drawer to display menu #265
• optimize Dockerfile use pre-build builder/runner image to prevent network latency problem (bitbus/paopao-ce-backend-builder bitbus/paopao-ce-backend-runner) #265
• optimize web ui in mobile environment #280
• optimize upload zip attachment compatible with different browsers for uploading zip mimetype #286
• adapte meilisearch to version v1.1 #288

Removed

• remove Deprecated:OldWeb feature #256

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.20.4 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

v0.3.0(rc)

Added

• add custom comment sort strategy support #243
• add RedisCacheIndex feature #250
• add Sentry feature #258
• add simple tweet share feature(just copy tweet link to clipboard now) support #264
• add default tweet max length configure in web/.env support. &a1160ca
  Set the value of VITE_DEFAULT_TWEET_MAX_LENGTH in file web/.env to change the tweet max default length.
• add custom whether provide user register configure in web/.env support. #267
  Set the value of VITE_ALLOW_USER_REGISTER in file web/.env to custom whether provide user register feature.

  # file: web/.env or web/.env.local
  ...
  # 局部参数
  VITE_ALLOW_USER_REGISTER=true
  ...
  

  and disallow user register in backend(add Web:DisallowUserRegister feature in config.yaml):

  # file config.yaml
  ...
  Features:
    Default: ["Base", "Postgres", "Zinc", "LocalOSS", "LoggerZinc", "BigCacheIndex", "Friendship", "Service", "Web:DisallowUserRegister"]
  ...
  

• add topic follow feature support #273
  mirgration database first(sql ddl file in scripts/migration/**/*_topic_follow.up.sql):

    CREATE TABLE `p_topic_user` (
        `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
        `topic_id` BIGINT UNSIGNED NOT NULL COMMENT '标签ID',
        `user_id` BIGINT UNSIGNED NOT NULL COMMENT '创建者ID',
        `alias_name` VARCHAR ( 255 ) COMMENT '别名',
        `remark` VARCHAR ( 512 ) COMMENT '备注',
        `quote_num` BIGINT UNSIGNED COMMENT '引用数',
        `is_top` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否置顶 0 为未置顶、1 为已置顶',
        `created_on` BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
        `modified_on` BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '修改时间',
        `deleted_on` BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
        `is_del` TINYINT UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除 0 为未删除、1 为已删除',
        `reserve_a` VARCHAR ( 255 ) COMMENT '保留字段a',
        `reserve_b` VARCHAR ( 255 ) COMMENT '保留字段b',
        PRIMARY KEY ( `id` ) USING BTREE,
      UNIQUE KEY `idx_topic_user_uid_tid` ( `topic_id`, `user_id` ) USING BTREE 
    ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户话题';
  

• add tweet comment thumbs up/down feature support #275
  mirgration database first(sql ddl file in scripts/migration/**/*_comment_thumbs.up.sql):
• add load more comments feature support &60b217b

Fixed

• fixed sql ddl p_contact's column is_delete define error (change to is_del) in scripts/paopao-mysql.sql &afd8fe1
• fixed cache index not expire in delete/add tweet error #266
• fixed tweet's owner not allow star/collection action when tweet is private error #274
• fixed user not list owner's collectioned private tweet error #274
• fixed comments thumbs up/down state incorrect error #283

Changed

• use github.com/rueian/rueidis as Redis client #249
  the Old redis client configure field

  ...
  Redis:
    Host: redis:6379
    Password: 
    DB: 
  

  the New redis client configure field

  ...
  Redis:
    InitAddress:
    - redis:6379
    Username:
    Password:
    SelectDB:
    ConnWriteTimeout: 60   # 连接写超时时间 多少秒 默认 60秒
  

• optimize web frontend dark theme &b082a8f
• change web frontend main content layout default size to 544px &b082a8f
• optimize web frontend in mobile environment use Drawer to display menu #265
• optimize Dockerfile use pre-build builder/runner image to prevent network latency problem (bitbus/paopao-ce-backend-builder bitbus/paopao-ce-backend-runner) #265
• optimize web ui in mobile environment #280
• optimize upload zip attachment compatible with different browsers for uploading zip mimetype #286
• adapte meilisearch to version v1.1 #288

Removed

• remove Deprecated:OldWeb feature #256

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.20.4 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

Changed

• optimize load more comments logic in tweet detail page.

Fixed

• fixed comments thumbs up/down state incorrect error. #283

备注：发布版本中，使用如下命令构建paopao-ce: (go version go1.20.3 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

Changed

• frontend: optimize load more comments logic in tweet detail page #282

备注：发布版本中，提交了构建好的paopao-ce供大家使用，使用如下命令构建: (go version go1.20.3 darwin/amd64)

make release CGO_ENABLED=0 TAGS='embed go_json'

条件有限(外加 精力有限)，本人只测试了paopao-ce-darwin_amd64，其余平台的未亲测，如有问题，请使用源码在自己平台下自行构建。

同时也提供了构建好的docker image，使用如下命令构建:

docker build --build-arg USE_DIST=yes -t bitbus/paopao-ce:0.3.0-beta.3 .

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

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

Fixed

• fixed sql ddl error for contact table #281

备注：发布版本中，提交了构建好的paopao-ce供大家使用，使用如下命令构建: (go version go1.20.3 darwin/amd64)

make release CGO_ENABLED=0 TAGS='embed go_json'

条件有限(外加 精力有限)，本人只测试了paopao-ce-darwin_amd64，其余平台的未亲测，如有问题，请使用源码在自己平台下自行构建。

同时也提供了构建好的docker image，使用如下命令构建:

docker build --build-arg USE_DIST=yes -t bitbus/paopao-ce:0.2 .

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

docker compose up -d
# visit http://localhost:8008  👀 paopao-ce