Simple Log Service:Connect to SLS using the PostgreSQL protocol

postgresql://{AccessKey_ID}:{AccessKey_Secret}@{Endpoint}:5432/{Project_Name}
# The connection enables TLS by default (MD5 for authentication). To explicitly disable TLS (for example, if the client does not support it), set the sslmode parameter to disable.
postgresql://{AccessKey_ID}:{AccessKey_Secret}@{Endpoint}:5432/{Project_Name}?sslmode=disable

private static final String URL = "jdbc:postgresql://{Endpoint}:5432/{Project_Name}?preferQueryMode=simple";
private static final String AccessKey_ID = "xyz";
private static final String AccessKey_Secret = "123456";

public static void main(String[] args) throws Exception
{
    Properties props = new Properties();
    props.setProperty(PGProperty.USER.getName(), AccessKey_ID);
    props.setProperty(PGProperty.PASSWORD.getName(), AccessKey_Secret);

    try (Connection conn = DriverManager.getConnection(URL, props)) {
        System.out.println("Connection successful!");
    }
}

CREATE TABLE users (
    id           BIGINT,
    name         TEXT,
    create_time  TIMESTAMP
)
WITH (
    shard_count = 4,
    ttl = 14,
    default_query_range = '1d',
    full_text_search_enabled = true,

    index_tokens = '&[ ]",''\',

    log_time_field = 'create_time',
    insert_any_allowed = false
);

ALTER TABLE users ADD COLUMN change_time TEXT;

ALTER TABLE users RENAME COLUMN change_time TO update_time;

ALTER TABLE users ALTER COLUMN update_time TYPE TIMESTAMP;

ALTER TABLE users DROP COLUMN update_time;

TRUNCATE TABLE users;

DROP TABLE users;

SELECT id, name FROM users LIMIT 10;

Méthode 1 : Utiliser le champ __time__

-- Specify the lower limit of the time range
SELECT id, name FROM users 
WHERE __time__ > 1766646000
LIMIT 10;

-- Specify the time range
SELECT id, name FROM users 
WHERE __time__ > 1766646000 AND __time__ < 1766646987
LIMIT 10;

Remarque : La valeur de __time__ est un horodatage Unix en secondes. Vous devez définir une limite inférieure pour que la plage de temps prenne effet. Si aucune limite supérieure n'est définie, l'heure de fin correspond par défaut à l'heure actuelle.

Méthode 2 : Utiliser les variables query_begin et query_end

-- Set the lower limit of the time range
SET query_begin = 1766646000; 
SELECT id, name FROM users LIMIT 10;

-- Set the time range
SET query_begin = 1766646000; 
SET query_end = 1766646987; 
SELECT id, name FROM users LIMIT 10;

-- Set the variables in a single statement (recommended)
SET query_begin = 1766646000; SET query_end = 1766646987; SELECT id, name FROM users LIMIT 10;

Remarque : Une fois définies, les variables query_begin et query_end restent valides pour toute la session de connexion. Exécutez show query_begin ou show query_end pour afficher leurs valeurs actuelles. Une valeur de 0 signifie que la variable n'a pas été définie.

INSERT INTO users (id, name, create_time) 
VALUES
    (1, 'Name#1', '2025-12-25T06:54:19'),
    (2, 'Name#2', '2025-12-25T06:54:20'),
    (3, 'Name#3', '2025-12-25T06:54:21');

SET hash_key = 'file#1'; 
SET seq_id = 1; 
INSERT INTO users (id, name, create_time) 
VALUES
    (1, 'Name#1', '2025-12-25T06:54:19'),
    (2, 'Name#2', '2025-12-25T06:54:20'),
    (3, 'Name#3', '2025-12-25T06:54:21');

error: sequence id is lower than expected, hash_key=xyz,current sequence_id=100,requested sequence_id=90

current\s+sequence_id=(\d+)

SELECT 
    table_schema, 
    table_name
FROM 
    information_schema.tables;

SELECT 
    column_name, 
    data_type
FROM 
    information_schema.columns 
WHERE 
    table_name = 'access_log';