Create a Custom Database Table

/**
 * Create a custom database table on theme activation.
 *
 * @return void
 */
function mytheme_create_analytics_table(): void {
    global $wpdb;

    $table_name      = $wpdb->prefix . 'snippet_views';
    $charset_collate = $wpdb->get_charset_collate();

    $sql = "CREATE TABLE IF NOT EXISTS {$table_name} (
        id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
        snippet_id BIGINT(20) UNSIGNED NOT NULL,
        user_ip VARCHAR(45) NOT NULL DEFAULT '',
        viewed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (id),
        KEY snippet_id (snippet_id),
        KEY viewed_at (viewed_at)
    ) {$charset_collate};";

    require_once ABSPATH . 'wp-admin/includes/upgrade.php';
    dbDelta( $sql );
}
add_action( 'after_switch_theme', 'mytheme_create_analytics_table' );

/**
 * Record a snippet view.
 *
 * @param int $snippet_id The snippet post ID.
 * @return void
 */
function mytheme_record_snippet_view( int $snippet_id ): void {
    global $wpdb;

    $wpdb->insert(
        $wpdb->prefix . 'snippet_views',
        array(
            'snippet_id' => $snippet_id,
            'user_ip'    => sanitize_text_field( $_SERVER['REMOTE_ADDR'] ?? '' ),
        ),
        array( '%d', '%s' )
    );
}