Daniel G. Aubert dgaubert

Cluade Code

Context management

Claude Code effectiveness will decrease if the context is polluted with non relevant information:

Provide relevant context for each request
Avoid misleading context

CLAUDE.md files

Architecture

Notes about I'd architecture a new long-life project.

TL;DR

Monolith first, split when needed.
Folder structure by feature, component, or service. Avoid layers, file category, or same class.
Place tests along code. Don't use a separate folder
Avoid long nested paths for endpoints. Context should be in the JWT

Get started

$ npm i

Run

$ node app.js

Test: tests/e2e/data/observatory/enrichment/test_enrichment.py::TestEnrichment::test_points_and_private_data

Test is failing in both branches because of the same reason: do_area area doesn't match between enriched vs expected. The easiest solution is to update fixture to match with current enriched reault.

Branch enrichment

Enriched DataFrame

    BLOCKGROUP  MLTCY7224  RSGCY7224       do_area                    geometry

Comparison beetwen overviews vs aggregation vs original data with turbocarto applied

Original table has 700k points. To compare load times, select a layer (You must be connected to the VPN) and open developer tools and check console output

Performance comparison beetwen overviews vs aggregation vs original data

Original table has 700k points. To compare load times, select a layer (You must be connected to the VPN) and open developer tools and check console output

Maps API: getting started

Basic concepts:

What's a map?: User's data (sql/analyses) + basemap + pop-ups + dataviews

Components:

Browser (carto[JS|VL]), cdn, nginx, varnish, maps-api, batch-api, redis-metadata, user's database

Map Instatiation Workflow: Map Config (request) & Layergroup (response):

Basic req -> res

Cheatsheet: PostgreSQL Monitoring

To query these metrics, you must be logged into PostgreSQL as a user that has read access to pg_stat_database

Useful psql commands

Check version of PostgreSQL: SELECT version();
Show location of postgresql.conf file (requires superuser privileges): SHOW config_file;
Show location of data directory (requires superuser privileges): SHOW data_directory;
Show location of log directory (may be a path relative to data directory, requires superuser privileges): SHOW log_directory;

	const { promisify } = require('util')

	function timeout (time, callback) {
	if (time > 1000) {
	throw new Error('Limit 1000')
	}

	if (time > 500) {
	return callback(new Error('Limit 500'))
	}

	// eslint-disable-next-line no-console
	console.log((await import('util')).inspect(myObject, { showHidden: false, depth: null, colors: true }))