ghstahl

2023-12-14 07:14:47 time="2023-12-14T15:14:47Z" level=info msg="initialization started" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:71"
2023-12-14 07:14:47 time="2023-12-14T15:14:47Z" level=info msg="verify user" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_user.go:39" username=postgres
2023-12-14 07:14:47 time="2023-12-14T15:14:47Z" level=info msg="verify database" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_database.go:39" database=zitadel
2023-12-14 07:14:47 time="2023-12-14T15:14:47Z" level=info msg="verify grant" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_grant.go:34" database=zitadel user=postgres
2023-12-14 07:14:47 time="2023-12-14T15:14:47Z" level=info msg="verify zitadel" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:76" database=zitadel
2023-12-14 07:14:47 time="2023-12-14T15:14:47Z" level=info msg="verify system" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:37

ghstahl

2023-11-28 10:10:32 time="2023-11-28T18:10:32Z" level=info msg="initialization started" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:71"
2023-11-28 10:10:32 time="2023-11-28T18:10:32Z" level=info msg="verify user" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_user.go:39" username=postgres
2023-11-28 10:10:32 time="2023-11-28T18:10:32Z" level=info msg="verify database" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_database.go:39" database=zitadel
2023-11-28 10:10:32 time="2023-11-28T18:10:32Z" level=info msg="verify grant" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_grant.go:34" database=zitadel user=postgres
2023-11-28 10:10:32 time="2023-11-28T18:10:32Z" level=info msg="verify zitadel" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:76" database=zitadel
2023-11-28 10:10:32 time="2023-11-28T18:10:32Z" level=info msg="verify system" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:37

ghstahl

2023-11-25 08:31:45 time="2023-11-25T16:31:45Z" level=info msg="initialization started" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/init.go:71"
2023-11-25 08:31:45 time="2023-11-25T16:31:45Z" level=info msg="verify user" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_user.go:39" username=postgres
2023-11-25 08:31:45 time="2023-11-25T16:31:45Z" level=info msg="verify database" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_database.go:39" database=zitadel
2023-11-25 08:31:45 time="2023-11-25T16:31:45Z" level=info msg="verify grant" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_grant.go:34" database=zitadel user=postgres
2023-11-25 08:31:45 time="2023-11-25T16:31:45Z" level=info msg="verify zitadel" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:76" database=zitadel
2023-11-25 08:31:45 time="2023-11-25T16:31:45Z" level=info msg="verify system" caller="/home/runner/work/zitadel/zitadel/cmd/initialise/verify_zitadel.go:37

ghstahl

Mongo Normal Collection Usage w/ Bucket ID

BEWARE: You can't have a uniqueness index on a timeseries collection. If you write usage records that MUST be unique, they must be taken care of in the aggregation.

stackoverflow
mongodb timeseries issue

Which then whats the point of using a timeseries DB for normal queries if there are duplicates.

To capture all usage records, even ones that come in with a timestamp in the deep past, we will bucket data as it comes in.

ghstahl

Mongo Timeseries w/ Bucket ID

BEWARE: You can't have a uniqueness index on a timeseries collection. If you write usage records that MUST be unique, they must be taken care of in the aggregation.

stackoverflow
mongodb timeseries issue

Which then whats the point of using a timeseries DB for normal queries if there are duplicates.

ghstahl

model
  schema 1.1
type feature
  relations
    define access: subscriber_member from associated_plan
    define associated_plan: [plan]
    define subscriber: subscriber from associated_plan
type feature_repo
  relations
    define feature: [feature]

ghstahl

version: '3'
services:
  webhook:
    image: "webhooksite/webhook.site"
    # Enable build for development:
    # build:
    #   dockerfile: Dockerfile
    #   context: ./
    command: php artisan queue:work --daemon --tries=3 --timeout=10
    ports:

ghstahl

{
	"tuple_key": {
		"object": "org:a",
		"relation": "member",
		"user": "user:ted"
	},
	"contextual_tuples": {
		"tuple_keys": [{
				"object": "integrity:1",
				"relation": "member_in_context",

ghstahl

[
  {
    "object": "user_repo:global",
    "relation": "member",
    "user": "user:anne"
  },
  {
    "object": "integrity:0",
    "relation": "member",
    "user": "user:anne"

ghstahl

model
  schema 1.1
type user
type integrity
  relations
    define member_in_context: [user]
    define member: [user] and member_in_context
type user_repo
  relations
    define integrity : [integrity]