# Features / Improvements & Fixes

## Improvements :muscle:

### Helm

{% stepper %}
{% step %}

#### **Embedded Storage Re-introduction with H2 Support**

We've brought back H2 embedded storage with comprehensive testing and improved implementation.

**✨ What's New:**

* Full H2 database support for lightweight deployments
* Enhanced persistence options for both logs and embedded storage
* Comprehensive test coverage for embedded storage scenarios

**📋 Configuration Example:**

```yaml
# Enable H2 embedded storage
lensesAgent:
  storage:
    postgres:
      enabled: false  # Disable Postgres to use H2
      
persistence:
  storageH2:
    enabled: true
    size: 5Gi
    storageClass: ""
    accessModes:
      - ReadWriteOnce
  log:
    enabled: true
    size: 2Gi
```

**✅ Benefits:**

* Simpler deployment for development/testing environments
* Reduced external dependencies
* Automatic data persistence

{% endstep %}

{% step %}

#### **Enhanced External Secrets Operator (ESO) Integration**

Updated to the latest ESO API version with extended functionality for secure credential management.
{% endstep %}

{% step %}

### **Helm: Advanced Volume Mount Configuration for HQ**

* Enhanced `additionalVolumeMounts` support for HQ charts

**📋 Configuration Example:**

```yaml
# Lenses HQ with TLS certificates
additionalVolumeMounts:
  - name: hq-truststore
    mountPath: "/mnt/provision-secrets/hq"
  - name: tls-certificates
    mountPath: "/etc/ssl/certs"

additionalVolumes:
  - name: hq-truststore
    secret:
      secretName: hq-agent-test-authority
  - name: tls-certificates
    secret:
      secretName: lenses-hq-tls-certs
```

{% endstep %}

{% step %}

### SQL Processors <a href="#sql-processors" id="sql-processors"></a>

* Removed Lenses-enforced memory limitations on deployed SQL processors
* Aligned Avro schema validation with official Avro specification
  {% endstep %}
  {% endstepper %}

## Fixes 🛠️

### **Removed hard limits for heap size to allow container support to work**

### SQL Snapshot

Fixed topic-partition offset retrieval to honor the `kafka.offset.batch.size` setting when pulling start and end offsets in a single Kafka request. Added intellisense support for this configuration parameter.

### **SQL Processors AVRO namespace**

When the AVRO namespace was overwritten via \`SET, it incorrectly validated the name.

```
SET defaults.topic.value.avro.namespace=****
```