ruslandoga

Last persisted job appears to run twice (before and after app restart)

5

👋 I'm having a problem with duplicate job runs after app startup when the job is persisted: Repro: https://gist.github.com/ruslandoga/425765b892605c426f55b7c02683bace Version: SwiftQueue (5.0.2) Expected output: ``` job created Optional(["id": 4]) job...

[question] sqlite extension alignment problem in exqlite, but not in sqlite3

8

👋 I understand that it's unlikely to be a problem in `exqlite`, but just in case you have any idea as to what I'm doing wrong. --- Repo: https://github.com/ruslandoga/sqlite-zig-problem I'm...

lite geonames by default

1

👋 Right now the container image contains a large [`geonames.csv`](https://github.com/plausible/analytics/blob/cc4d4bb8e0e8686c13cd08e5c97584fbabf3d326/Dockerfile#L19) file that makes self-hosting difficult on small instances as it requires additional ~700MB of RAM and slows down `plausible` container...

update clickhouse to 22.9 for better arm64 support

2

Relevant: https://github.com/plausible/analytics/discussions/2292 **tl;dr** In [22.9](https://clickhouse.com/docs/en/whats-new/changelog/#-clickhouse-release-229-2022-09-22) ClickHouse [switched](https://github.com/ClickHouse/ClickHouse/pull/38171) from [`hyperscan`](https://github.com/intel/hyperscan) to [`vectorscan`](https://github.com/VectorCamp/vectorscan) and multi-substring search now works on arm64. I'm trying it out on my instance and everything seems to be...

v1.5.0 release

1

Going to track progress with this one. Here're the TODOs left. #### Changes to docker compose config, in-repo upgrade docs - [x] https://github.com/plausible/hosting/pull/52 - [x] add something like `upgrades/postgres.md` (naming...

add self-hosting GA-imports configuration

1

This PR adds instructions to enable GA imports on a self-hosted instance.

replace docker-compose commands with docker compose

1

`docker-compose` cli is no longer necessary to install separately as [`docker` supports most of that functionality via its `compose` command.](https://docs.docker.com/compose/cli-command-compatibility/)

### Changes This PR allows taking into account imported views per visit. #exports-imports ### Tests - [x] Automated tests have been updated ### Changelog - [ ] Entry has been...

collapse clickhouse migrations

2

### Changes This is an alternative approach to #2945 which completely removes v1 events and sessions migrations. I think it's a bit cleaner in that no v1 tables are created...

### Changes This PR changes how **Time on Page** statistic is calculated. Before it was: ```js sum(duration(page)) / count(unique(page, next_page, session)) ``` Now it is: ```js avg(sum(duration(page) per user) >...