Ivan Pereira ivanrvpereira

Zero knowledge databases

The idea

The idea is to provide a database as a service to end users in such a way that no one except the user herself can access the data, not even the hosting provider or the database administrator.

Advantages

A privacy- and/or security-conscious user will have more trust in such a setup.
The service provider cannot be coerced to release the data they were trusted with, and he cannot be held responsible for the content he is storing.

cd /Library/Preferences
sudo rm com.sophos.sav.plist

cd /Library/Application\ Support/Sophos/cloud/Installer.app/Contents/MacOS/tools/
sudo ./InstallationDeployer —force_remove

Exhaustive list of SPDX (Software Package Data Exchange) licenses: https://spdx.org/licenses/

Git Flow Quick Reference

Init

$ git flow init -d

Feature

Terraform vs PostgreSQL RDS

Thanks to new resources (postgresql_default_priviledges) and some fixes Terraform can now add new databases and manage ownership / access to them.

This example creates new database and two users. You can use owner to create new tables and run migrations and user for normal read/write access to database.

Logging setup for FastAPI

This logging setup configures Structlog to output pretty logs in development, and JSON log lines in production.

Then, you can use Structlog loggers or standard logging loggers, and they both will be processed by the Structlog pipeline (see the hello() endpoint for reference). That way any log generated by your dependencies will also be processed and enriched, even if they know nothing about Structlog!

Requests are assigned a correlation ID with the asgi-correlation-id middleware (either captured from incoming request or generated on the fly). All logs are linked to the correlation ID, and to the Datadog trace/span if instrumented. This data "global to the request" is stored in context vars, and automatically added to all logs produced during the request thanks to Structlog. You can add to these "global local variables" at any point in an endpoint with `structlog.contextvars.bind_contextvars(custom

	[Unit]
	Description=supervisord - Supervisor process control system for UNIX
	Documentation=http://supervisord.org
	After=network.target

	[Service]
	Type=forking
	ExecStart=/bin/supervisord -c /etc/supervisord/supervisord.conf
	ExecReload=/bin/supervisorctl reload
	ExecStop=/bin/supervisorctl shutdown

	#!/bin/bash
	# Creator: Phil Cook
	# Modified: Andy Miller
	#
	# >>> IMPORTANT: Moved to: https://github.com/rhukster/sphp.sh
	# >>> Kept here for legacy purposes
	#
	osx_major_version=$(sw_vers -productVersion \| cut -d. -f1)
	osx_minor_version=$(sw_vers -productVersion \| cut -d. -f2)
	osx_patch_version=$(sw_vers -productVersion \| cut -d. -f3)

	Github.com ui .currently does not natively supoport search for multiple topic tags as of now. However their api allows you to query multiple tags. Below is a simple example to query github.com with ecs and go topic tags.

	curl -H "Accept: application/vnd.github.mercy-preview+json" \
	https://api.github.com/search/repositories?q=topic:ecs+topic:go

	Response from the github can be rather verbose so lets filter only relavant info such repo url and description.

	curl -H "Accept: application/vnd.github.mercy-preview+json" \
	https://api.github.com/search/repositories\?q\=topic:ecs+topic:go \| jq '.items[] \| {url:.url, description:.description}'

	// Claude Code is a Beta product per Anthropic's Commercial Terms of Service.
	// By using Claude Code, you agree that all code acceptance or rejection decisions you make,
	// and the associated conversations in context, constitute Feedback under Anthropic's Commercial Terms,
	// and may be used to improve Anthropic's products, including training models.
	// You are responsible for reviewing any code suggestions before use.

	// (c) Anthropic PBC. All rights reserved. Use is subject to Anthropic's Commercial Terms of Service (https://www.anthropic.com/legal/commercial-terms).

	// Version: 0.2.9