Skip to content

Arch Forum 2025-10-16

Participants: Backend devs, Andy, Kyle, Magnus and Victor

Agenda

  • SqlFluff
  • Editorconfig update
  • PubSub

Summary

SqlFluff

SqlFluff now runs on PRs in areas with a .sqlfluff config file. Currently only be-ach has this file.
Example of where it has formatted something: https://github.com/majority-dev/be-ach/pull/115/files

  • No objections, Victor will roll this out
  • As part of the rollout, all sql files will be formatted. (normally only changed files are formatted by the pr pipeline)

Editorconfig update

Suggestion is to add:

resharper_arrange_object_creation_when_type_not_evident_highlighting = none

Which will turn off warning for

KeyValuePair

Discussion followed with varying opinions:

  • Fewer warnings are better; let's add the override.
  • This is a useful warning; let's keep it.
  • It's good if we keep to the standard config.
  • This setting only applies to Resharper/Rider; code written in Cursor, for example, won't get this.

Given this, for now we will not change the standard editorconfig we use.

PubSub

It's now possible for the data warehouse to publish events to the backend. This is documented at Data Warehouse Events.

Note that this new feature should not be overused; in general, the backend should not depend on data from the data warehouse for its operation.