也谈自建统计

其实在使用各种第三方的统计之前，一直用的都是jetpack自带的统计系统，虽然简陋但是也基本够用了。主要是也没有什么太多需要分析的数据，后来有一段时间用的cnzz的免费版，但是在某一天之后忽然收费了不能用了。改换到百度，51la，不过这俩统计也是各种被屏蔽。 前几天看到小乔同学那个统计感觉很有意思就自建了一个： 是不是很可爱哒，就喜欢这种可可爱爱的风格。这个用的是Moe-Counter多种风格可选的萌萌计数器. 多种风格可选的萌萌计数器 https://github.com/journey-ad/Moe-Counter 122 forks. 907 stars. 21 open issues. Recent commits: Merge pull request #50 from HChenZi/feat-homePageUrlfeat: Get url from req for index page, GitHub perf: Use more precise variable naming and support configuration., journey-ad Merge pull request #49 from HChenZi/masterfeat: add docker deploy, GitHub feat: Get url from req for index page, HChenZi feat: add docker deploy, HChenZi 安装神马的也非常简单，使用sqlite数据库，可以直接通过数据库修改基数。 今天想着把百度的统计要给换了，于是尝试用Umami统计： Umami is a simple, fast, privacy-focused alternative to Google Analytics. Umami is a simple, fast, privacy-focused alternative to Google Analytics. https://github.com/umami-software/umami 3,001 forks. 16,726 stars. 100 open issues. Recent commits: Merge pull request #2203 from umami-software/devv2.5.0, GitHub Update react-basics., Mike Cao Re-add add reports button., Brian Cao Merge remote-tracking branch 'origin/dev' into dev, Brian Cao Hide edit button cloudMode., Brian Cao 不过在安装的时候出现了下面的错误： Error: P3018 A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve Migration name: 02_report_schema_session_data Database error code: 1064 Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN `event_data_type` TO `data_type`; ALTER TABLE `event_data` RENAME COLUMN ' at line 2 Please check the query number 1 from the migration file. ✗ Command failed: prisma migrate deploy Error: P3018 A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve Migration name: 02_report_schema_session_data Database error code: 1064 Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN `event_data_type` TO `data_type`; ALTER TABLE `event_data` RENAME COLUMN ' at line 2 Please check the query number 1 from the migration file. error Command failed with exit code 1. info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command. ERROR: "check-db" exited with 1. error Command failed with exit code 1. 这个就很蛋疼了，搜索了一下，发现说是语法问题，参考这个链接：https://roy.wang/umami-build-error-p3009/ 修改sql文件： vim db/mysql/migrations/02_report_schema_session_data/migration.sql 将下面的代码： -- AlterTable ALTER TABLE "event_data" RENAME COLUMN "event_data_type" TO "data_type"; ALTER TABLE "event_data" RENAME COLUMN "event_date_value" TO "date_value"; ALTER TABLE "event_data" RENAME COLUMN "event_id" TO "event_data_id"; ALTER TABLE "event_data" RENAME COLUMN "event_numeric_value" TO "number_value"; ALTER TABLE "event_data" RENAME COLUMN "event_string_value" TO "string_value"; 修改为： -- RenameColumns ALTER TABLE `event_data` ADD COLUMN data_type INTEGER UNSIGNED AFTER event_data_type; ALTER TABLE `event_data` ADD COLUMN date_value TIMESTAMP(0) AFTER event_date_value; ALTER TABLE `event_data` ADD COLUMN event_data_id VARCHAR(36) AFTER event_id; ALTER TABLE `event_data` ADD COLUMN number_value DECIMAL(19, 4) AFTER event_numeric_value; ALTER TABLE `event_data` ADD COLUMN string_value VARCHAR(500) AFTER event_string_value; UPDATE event_data SET data_type = event_data_type, date_value = event_date_value, event_data_id = event_id, number_value = event_numeric_value, string_value = event_string_value; ALTER TABLE `event_data` MODIFY data_type INTEGER UNSIGNED NOT NULL; ALTER TABLE `event_data` MODIFY event_data_id VARCHAR(36) NOT NULL; ALTER TABLE `event_data` DROP COLUMN event_data_type; ALTER TABLE `event_data` DROP COLUMN event_date_value; ALTER TABLE `event_data` DROP COLUMN event_id; ALTER TABLE `event_data` DROP COLUMN event_numeric_value; ALTER TABLE `event_data` DROP COLUMN event_string_value; ALTER TABLE `event_data` ADD PRIMARY KEY(event_data_id); 之行下面的命令重新build： npx prisma migrate resolve --rolled-back "02_report_schema_session_data" yarn build 基本就ok了。 如果要使用其他的端口启动服务，使用下面的命令： npx next start -p 4000 实际效果： The post 也谈自建统计 first appeared on obaby@mars.