A reactive notebook for Python — run reproducible experiments, query with SQL, execute as a script, deploy as an app, and version with git. Stored as pure Python. All in a modern, AI-native editor.
Python artificial-intelligencedagdata-sciencedata-visualizationdataflowdeveloper-toolsmachine-learningnotebookspipelinepythonreactivesqlweb-app
/* Copyright 2026 Marimo. All rights reserved. */
import { URL_REGEX } from "../url-parser";
import type { JsonString } from "./base64";
const GLOBAL_URL_REGEX = new RegExp(URL_REGEX.source, "g");
declare global {
interface BigInt {
toJSON(): unknown;
}
}
// Treat BigInts as numbers
// https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON#using_json_numbers
BigInt.prototype.toJSON = function () {
return JSON.rawJSON(this.toString());
};
/**
* Parse an attribute value as JSON.
* This also handles NaN, Infinity, and -Infinity.
*/
export function jsonParseWithSpecialChar<T = unknown>(
value: JsonString<T> | string,
): T {
// This regex handling is expensive and often not needed.
// We try to parse with JSON.parse first, and if that fails, we use the regex.
try {
return JSON.parse(value, (_key, value) => sanitizeBigInt(value)) as T;
} catch {
// Do nothing
}
// Random unicode character that is unlikely to be used in the JSON string
const CHAR = "◐";
if (value == null || value === "") {
return {} as T;
}
try {
// This will properly handle NaN, Infinity, and -Infinity
// The python json.dumps encoding will serialize to NaN, Infinity, -Infinity which is not valid JSON,
// but we don't want to change the python encoding because NaN, Infinity, -Infinity are valuable to know.
value = value ?? "";
value = value.replaceAll(
// This was iterated on with GPT. The confidence lies in the unit tests.
/(?<=\s|^|\[|,|:)(NaN|-Infinity|Infinity)(?=(?:[^"'\\]*(\\.|'([^'\\]*\\.)*[^'\\]*'|"([^"\\]*\\.)*[^"\\]*"))*[^"']*$)/g,
`"${CHAR}$1${CHAR}"`,
);
return JSON.parse(value, (_key, v) => {
if (typeof v !== "string") {
return sanitizeBigInt(v);
}
if (v === `${CHAR}NaN${CHAR}`) {
return Number.NaN;
}
if (v === `${CHAR}Infinity${CHAR}`) {
return Number.POSITIVE_INFINITY;
}
if (v === `${CHAR}-Infinity${CHAR}`) {
return Number.NEGATIVE_INFINITY;
}
return sanitizeBigInt(v);
}) as T;
} catch {
return {} as T;
}
}
/**
* Converts JSON data to a Markdown table format
* Detects URLs and converts them to markdown links [url](url)
*/
export function jsonToMarkdown(json: Record<string, unknown>[]): string {
if (json.length === 0) {
return "";
}
const keys = Object.keys(json[0]);
const header = `| ${keys.join(" | ")} |`;
const separator = `|${keys.map(() => "---").join("|")}|`;
const rows = json.map((row) => {
const cells = keys.map((key) => formatValueForMarkdown(row[key]));
return `| ${cells.join(" | ")} |`;
});
return [header, separator, ...rows].join("\n");
}
/**
* Formats a value for markdown export
* - Detects URLs and converts them to markdown links
* - Skips URLs that are already in markdown link format
* - Escapes special markdown characters
* - Handles nulls, arrays, and objects
*/
function formatValueForMarkdown(value: unknown): string {
// Handle nulls and undefined
if (value === null || value === undefined) {
return "";
}
// Handle arrays and objects by stringifying
if (Array.isArray(value)) {
return escapeMarkdownTableChars(JSON.stringify(value));
}
if (typeof value === "object") {
return escapeMarkdownTableChars(JSON.stringify(value));
}
// Convert to string
let stringValue = String(value);
// Regex to match existing markdown links: [text](url)
const markdownLinkRegex = /\[([^\]]+)]\((https?:\/\/[^)]+)\)/g;
// Temporarily replace existing markdown links with placeholders
const placeholders = new Map<string, string>();
let placeholderIndex = 0;
stringValue = stringValue.replaceAll(markdownLinkRegex, (match) => {
const placeholder = `__MDLINK_${placeholderIndex++}__`;
placeholders.set(placeholder, match);
return placeholder;
});
// Convert plain URLs to markdown links using the shared URL matcher.
stringValue = stringValue.replaceAll(GLOBAL_URL_REGEX, "[$1]($1)");
// Restore markdown links from placeholders
for (const [placeholder, original] of placeholders) {
stringValue = stringValue.replace(placeholder, original);
}
// Escape special markdown table characters
return escapeMarkdownTableChars(stringValue);
}
/**
* Escapes special characters in markdown tables
*/
function escapeMarkdownTableChars(value: string): string {
return (
value
// Escape backslashes first (must be first to avoid double-escaping)
.replaceAll("\\", "\\\\")
// Escape pipes (markdown table delimiter)
.replaceAll("|", "\\|")
// Replace newlines with spaces
.replaceAll("\n", " ")
.replaceAll("\r", "")
);
}
/** Adapted from https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/BigInt#use_within_json */
function sanitizeBigInt(value: unknown): unknown {
if (
value !== null &&
typeof value === "object" &&
"$bigint" in value &&
typeof value.$bigint === "string"
) {
return BigInt(value.$bigint);
}
return value;
}