apps/monitoring/database/containers.go:59

• This change from LIKE prefix matching to exact matching will break metric retrieval. The database stores the full container name (e.g., "myapp-1") via SaveContainerMetric which saves container.Name. However, the appName parameter passed to this function from the API is the service name without the numeric suffix (e.g., "myapp").

In the previous implementation, GetServiceName logic stripped the suffix, allowing "myapp" to match "myapp-1" via LIKE. With exact matching, queries for "myapp" will return no results when the database contains "myapp-1".

To fix the container name collision issue while preserving functionality, consider storing a normalized service name separately in the database or applying the GetServiceName transformation when saving metrics.

func (db *DB) GetLastNContainerMetrics(containerName string, limit int) ([]ContainerMetric, error) {
	query := `
		WITH recent_metrics AS (
			SELECT metrics_json
			FROM container_metrics
			WHERE container_name = ?
			ORDER BY timestamp DESC
			LIMIT ?
		)
		SELECT metrics_json FROM recent_metrics ORDER BY json_extract(metrics_json, '$.timestamp') ASC
	`

apps/monitoring/database/containers.go:92

• This change from LIKE prefix matching to exact matching will break metric retrieval for the same reason as GetLastNContainerMetrics. The database stores full container names with suffixes (e.g., "myapp-1") but queries use service names without suffixes (e.g., "myapp"), resulting in no matches with exact equality comparison.

func (db *DB) GetAllMetricsContainer(containerName string) ([]ContainerMetric, error) {
	query := `
		WITH recent_metrics AS (
			SELECT metrics_json
			FROM container_metrics
			WHERE container_name = ?
			ORDER BY timestamp DESC
		)
		SELECT metrics_json FROM recent_metrics ORDER BY json_extract(metrics_json, '$.timestamp') ASC
	`