server: switch from lib/pq to jackc/pgx #1259

	name: Build and Test Go
	on: [push, pull_request]
	permissions:
	contents: read

	jobs:
	build:
	name: Go CI
	runs-on: ubuntu-latest
	strategy:
	matrix:
	go: ["1.22", "1.23"]
	steps:
	- name: Set up Go
	uses: actions/setup-go@0a12ed9d6a96ab950c8f026ed9f722fe0da7ef32 # v5.0.2
	with:
	go-version: ${{ matrix.go }}
	- name: Check out source
	uses: actions/checkout@692973e3d937129bcbf40652eb9f2f61becf3332 # v4.1.7
	- name: Install Linters
	run: "go install github.com/golangci/golangci-lint/cmd/[email protected]"
	- name: Build
	run: go build ./...
	- name: Test
	run: go test ./...
	- name: Lint
	run: golangci-lint run
	- name: Upload logs if tests failed
	if: failure()
	uses: actions/upload-artifact@0b7f8abb1508181956e8e162db84b466c27e18ce # v3.1.2
	with:
	name: ${{matrix.go}}-test-logs
	path: /tmp/br*

Provide feedback