akheron
Repos
102
Followers
396
Following
3

C library for encoding, decoding and manipulating JSON data

C
2684
715

Type-safe routes for Express and Koa

158
14

Type-safe, ergonomic, polymorphic optics for TypeScript

404
9

Generate OpenAPI spec from typera routes

16
7

TypeScript types for raw PostgreSQL queries

89
8

Simple encrypted password storage

26
6

Events

pull request opened
Messaging speedups

Summary

Create a new cache table that makes fast SQL queries possible. Write those fast SQL queries and use them instead of the previous mega query.

These optimizations only apply to citizen and employee (personal and group) inboxes. The employee sent folder is not affected, as it doesn't seem to be a performance bottleneck, and it currently works very differently to how it should work.

Created at 17 hours ago

Keep track of message thread participants

Add table message_thread_participants that caches:

  • the timestamp of the latest message that the participant is allowed to see
  • the timestamp of the latest message that was received by the participant (if any)
  • the timestamp of the latest message that was sent by the participant (if any)

This table will facilitate fast lookups of visible threads for any given account.

Faster retrieval of message account inbox content

Add functions to query all threads or just received threads of an account. These are used to find threads and messages for citizen-side and employee-side inboxes, respectively. They use the new message_thread_participants table for fast lookups of visible threads.

Remove a now unused monster SQL query

Created at 17 hours ago

Fix messages reply button focus outline

Remove back button in child page

Scroll page to top on navigation in citizen frontend

Merge pull request #2930 from espoon-voltti/EVAKA-citizen-scroll-to-top-on-navigation-change

Citizen scroll page to top on navigation

Remove an unused endpoint

Fix message sending endpoint result

Keep track of message thread participants

Add table message_thread_participants that caches:

  • the timestamp of the latest message that the participant is allowed to see
  • the timestamp of the latest message that was received by the participant (if any)
  • the timestamp of the latest message that was sent by the participant (if any)

This table will facilitate fast lookups of visible threads for any given account.

Faster retrieval of message account inbox content

Add functions to query all threads or just received threads of an account. These are used to find threads and messages for citizen-side and employee-side inboxes, respectively. They use the new message_thread_participants table for fast lookups of visible threads.

Remove a now unused monster SQL query

Created at 18 hours ago
create branch
akheron create branch EVAKA-messaging-speedup
Created at 19 hours ago

Move all font handling logic to mod font

Copy PCX files to output

These files are named .PIC although their format is PCX, so it's enough to just copy and change the file extension.

Add ship converter

Load the palette, use for ships

Extend README

Created at 1 day ago
delete branch
akheron delete branch dependabot/npm_and_yarn/helmet-6.0.0
Created at 5 days ago

build(deps-dev): bump helmet from 5.1.1 to 6.0.0

Bumps helmet from 5.1.1 to 6.0.0.


updated-dependencies:

  • dependency-name: helmet dependency-type: direct:development update-type: version-update:semver-major ...

Signed-off-by: dependabot[bot] support@github.com

Created at 5 days ago
pull request closed
build(deps-dev): bump helmet from 5.1.1 to 6.0.0

Bumps helmet from 5.1.1 to 6.0.0.

Dependabot compatibility score

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.


You can trigger Dependabot actions by commenting on this PR:

  • @dependabot rebase will rebase this PR
  • @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
  • @dependabot merge will merge this PR after your CI passes on it
  • @dependabot squash and merge will squash and merge this PR after your CI passes on it
  • @dependabot cancel merge will cancel a previously requested merge and block automerging
  • @dependabot reopen will reopen this PR if it is closed
  • @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
  • @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
  • @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
  • @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
Created at 5 days ago
issue comment
build(deps-dev): bump helmet from 5.1.1 to 6.0.0

@dependabot rebase

Created at 5 days ago
issue comment
build(deps-dev): bump lerna from 5.4.3 to 5.5.1

@dependabot rebase

Created at 5 days ago
delete branch
akheron delete branch dependabot/npm_and_yarn/typescript-4.8.3
Created at 5 days ago

build(deps-dev): bump typescript from 4.7.4 to 4.8.3

Bumps typescript from 4.7.4 to 4.8.3.


updated-dependencies:

  • dependency-name: typescript dependency-type: direct:development update-type: version-update:semver-minor ...

Signed-off-by: dependabot[bot] support@github.com

Fix a type error

Created at 5 days ago
pull request closed
build(deps-dev): bump typescript from 4.7.4 to 4.8.3

Bumps typescript from 4.7.4 to 4.8.3.

Dependabot compatibility score

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.


You can trigger Dependabot actions by commenting on this PR:

  • @dependabot rebase will rebase this PR
  • @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
  • @dependabot merge will merge this PR after your CI passes on it
  • @dependabot squash and merge will squash and merge this PR after your CI passes on it
  • @dependabot cancel merge will cancel a previously requested merge and block automerging
  • @dependabot reopen will reopen this PR if it is closed
  • @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
  • @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
  • @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
  • @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
Created at 5 days ago

Fix a type error

Created at 5 days ago
pull request closed
Use ktfmt for Kotlin code

Summary

Created at 5 days ago
issue comment
Use ktfmt for Kotlin code

Closing, as this conflicts very easily

Created at 5 days ago
issue comment
build(deps-dev): bump @typescript-eslint/parser from 5.37.0 to 5.38.0

@dependabot rebase

Created at 6 days ago
issue comment
build(deps-dev): bump helmet from 5.1.1 to 6.0.0

@dependabot rebase

Created at 6 days ago