Test page

Mar 8, 2025
test aws charts

My first MDX post2

I am excited to announce that I have successfully achieved the AWS Certified Developer - Associate certification without formal learning, leveraging my existing expertise and practical knowledge. This certification validates my proficiency in AWS fundamentals and aligns with Apex Lab’s strategic goal of joining the AWS Partner Network.

1
import { GENERATE_SLUG_FROM_TITLE } from "@/config";
2

3
export default function (title: string, staticSlug: string) {
4
  return !GENERATE_SLUG_FROM_TITLE
5
    ? staticSlug
6
    : title
7
        // remove leading & trailing whitespace
8
        .trim()
9
        // output lowercase
10
        .toLowerCase()
11
        // replace spaces
12
        .replace(/\s+/g, "-")
13
        // remove special characters
14
        .replace(/[^\w-]/g, "")
15
        // remove leading & trailing separtors
16
        .replace(/^-+|-+$/g, "");
17
}

Sql

1
CREATE TABLE ppum.logs
2
(
3
    `_id` UInt64 DEFAULT generateSnowflakeID() CODEC(ZSTD(1)),
4
    `EventTime` DateTime64(9) CODEC(Delta(8), ZSTD(1)),
5
    `EventReceivedTime` DateTime64(9) CODEC(Delta(8), ZSTD(1)),
6
    `EventID` Nullable(UInt32) CODEC(ZSTD(1)),
7
    `SourceModuleName` LowCardinality(String) CODEC(ZSTD(1)),
8
    `SourceName` Nullable(String) CODEC(ZSTD(1)),
9
    `Severity` LowCardinality(String) CODEC(ZSTD(1)),
10
    `SeverityValue` Nullable(UInt8) CODEC(ZSTD(1)),
11
    `MessageSourceAddress` Nullable(String) CODEC(ZSTD(1)),
12
    `AccountName` Nullable(String) CODEC(ZSTD(1)),
13
    `TargetUserName` Nullable(String) CODEC(ZSTD(1)),
14
    `ProcessID` Nullable(UInt32) CODEC(ZSTD(1)),
15
    `TraceID` Nullable(String) CODEC(ZSTD(1)),
16
    `SpanID` Nullable(String) CODEC(ZSTD(1)),
17
    `TraceFlags` Nullable(UInt32) CODEC(ZSTD(1)),
18
    `Hostname` String CODEC(ZSTD(1)),
19
    `Message` String CODEC(ZSTD(1)),
20
    `Body` String CODEC(ZSTD(1)),
21

22
    `Data` Map(LowCardinality(String), Dynamic) CODEC(ZSTD(1)),
23
    `DataJson` JSON CODEC(ZSTD(1)),
24
    `Keys` Array(LowCardinality(String)) MATERIALIZED arraySort(mapKeys(Data)) CODEC(ZSTD(1)),
25
    `KeysHash` UInt32 MATERIALIZED xxHash32(Keys) CODEC(ZSTD(1)),
26
    INDEX idx_body lower(Body) TYPE tokenbf_v1(32768, 3, 0) GRANULARITY 1,
27
    INDEX idx_message lower(Message) TYPE tokenbf_v1(32768, 3, 0) GRANULARITY 1,
28
    INDEX idx_data_keys mapKeys(Data) TYPE bloom_filter(0.01) GRANULARITY 1,
29
    INDEX idx_keys_array Keys TYPE bloom_filter(0.01) GRANULARITY 1,
30
    INDEX idx_sourcemodulename SourceModuleName TYPE set(1000) GRANULARITY 1,
31
    INDEX idx_id _id TYPE minmax GRANULARITY 1
32
)
33
ENGINE = MergeTree
34
PARTITION BY toDate(EventTime)
35
ORDER BY EventTime
36
TTL toDateTime(EventTime) + toIntervalDay(365)
37
SETTINGS ttl_only_drop_parts = 1, index_granularity = 8192

V0 Chart

Request speeds

New test 1

Mermaid test

Loading diagram...

Source

1
flowchart TD
2
    Start --> Stop

Chart test 2

Mermaid test 2

Loading diagram...

Source

1
xychart-beta
2
    title "Sales Revenue"
3
    x-axis [jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec]
4
    y-axis "Revenue (in $)" 4000 --> 11000
5
    bar [5000, 6000, 7500, 8200, 9500, 10500, 11000, 10200, 9200, 8500, 7000, 6000]
6
    line [5000, 6000, 7500, 8200, 9500, 10500, 11000, 10200, 9200, 8500, 7000, 6000]

Excalidraw test

This is a test