User contributions for Carli

9 September 2026

• 23:5423:54, 9 September 2026 diff hist −11,675‎ Benchmark MemCP vs. MariaDB on Wordpress ‎No edit summary current
• 23:4423:44, 9 September 2026 diff hist +11,448‎ Benchmark MemCP vs. MariaDB on Wordpress ‎ →‎Host PHP directly: remove a round trip for every small query Tag: Visual edit: Switched
• 23:4323:43, 9 September 2026 diff hist +572‎ Benchmark MemCP vs. MariaDB on Wordpress ‎No edit summary
• 23:3923:39, 9 September 2026 diff hist +120‎ Benchmark MemCP vs. MariaDB on Wordpress ‎No edit summary
• 23:3623:36, 9 September 2026 diff hist −1,650‎ Benchmark MemCP vs. MariaDB on Wordpress ‎No edit summary
• 23:3623:36, 9 September 2026 diff hist +30‎ Benchmark MemCP vs. MariaDB on Wordpress ‎No edit summary
• 23:3423:34, 9 September 2026 diff hist +2,327‎ Benchmark MemCP vs. MariaDB on Wordpress ‎No edit summary

8 September 2026

• 20:5020:50, 8 September 2026 diff hist +12,936‎ N Benchmark MemCP vs. MariaDB on Wordpress ‎ Created page with "<!-- Copyright (C) 2026 MemCP contributors --> <!-- SPDX-License-Identifier: AGPL-3.0-or-later --> = Benchmark MemCP vs. MariaDB on Wordpress = WordPress does more than fetch individual posts. Category pages, comment counters, search, archive lists, and plugin metadata queries repeatedly join and aggregate data. These are the places where a different database engine can make a noticeable difference. We compared '''MariaDB, MemCP, and MemCP with JIT''' using seven SQL..."

7 September 2026

• 22:4822:48, 7 September 2026 diff hist +41‎ Main Page ‎ →‎Optimizations current Tag: Visual edit
• 22:4822:48, 7 September 2026 diff hist +17‎ Main Page ‎ →‎Optimizations Tag: Visual edit

2 September 2026

• 01:5301:53, 2 September 2026 diff hist −19‎ RecSets ‎No edit summary current Tag: Visual edit

28 August 2026

• 12:0312:03, 28 August 2026 diff hist −68‎ Supported SQL ‎ →‎Planner inspection Tag: Visual edit

27 August 2026

• 08:4708:47, 27 August 2026 diff hist +57‎ Main Page ‎No edit summary Tag: Visual edit: Switched
• 08:3808:38, 27 August 2026 diff hist +3,527‎ N Window Functions ‎ Created page with "← Back to Full SCM API documentation == stream_emit == invokes a streaming callback immediately; marks ordering-sensitive emission as an observable effect '''Allowed number of parameters:''' 2–2 <span id="parameters"></span> === Parameters === * '''emit''' (<code>func(value:any) -> any</code>): * '''value''' (<code>any</code>): <span id="returns"></span> === Returns === <code>any</code> == stream_window_reduce == applies OFFSET/LIMIT and a serial redu..." Tag: Visual edit: Switched
• 08:3808:38, 27 August 2026 diff hist +23‎ Full SCM API documentation ‎No edit summary Tag: Visual edit
• 08:3708:37, 27 August 2026 diff hist +76‎ Vectors ‎No edit summary Tag: Visual edit: Switched
• 08:3608:36, 27 August 2026 diff hist +1,394‎ N Transactions ‎ Created page with " ← Back to Full SCM API documentation == tx_commit == Commits the current transaction. '''Allowed number of parameters:''' 1–1 <span id="parameters-2"></span> === Parameters === * '''session''' (<code>func(key:string?, value:any?) -> any</code>): the session function that holds tx state <span id="returns-2"></span> === Returns === <code>bool</code> == tx_rollback == Rolls back the current transaction. '''Allowed number of parameters:''' 1–1 <span..." Tag: Visual edit: Switched
• 08:3608:36, 27 August 2026 diff hist +19‎ Full SCM API documentation ‎No edit summary Tag: Visual edit
• 08:3608:36, 27 August 2026 diff hist +44‎ Timezone ‎No edit summary
• 08:3508:35, 27 August 2026 diff hist +3,203‎ N Timezone ‎ Created page with " == unix_timestamp == returns a unix timestamp (integer seconds since epoch) '''Allowed number of parameters:''' 0–1 <span id="parameters"></span> === Parameters === * '''dt''' (<code>any</code>): optional datetime value to convert ''(optional)'' <span id="returns"></span> === Returns === <code>int</code> == system_time_zone == returns the operating system's local timezone name '''Allowed number of parameters:''' 0–0 <span id="parameters-1"></span> === Para..." Tag: Visual edit: Switched
• 08:3508:35, 27 August 2026 diff hist +15‎ Full SCM API documentation ‎No edit summary Tag: Visual edit
• 08:2908:29, 27 August 2026 diff hist +3,437‎ Sync ‎No edit summary
• 08:2408:24, 27 August 2026 diff hist +27,255‎ Strings ‎No edit summary
• 08:2308:23, 27 August 2026 diff hist +354‎ Streams ‎No edit summary
• 08:2008:20, 27 August 2026 diff hist +37,871‎ Storage ‎No edit summary Tag: Visual edit: Switched
• 08:1908:19, 27 August 2026 diff hist +4,116‎ SCM Builtins ‎No edit summary Tag: Visual edit: Switched
• 08:1708:17, 27 August 2026 diff hist −17‎ Parsers ‎No edit summary
• 08:1508:15, 27 August 2026 diff hist +5,315‎ Lists ‎No edit summary Tag: Visual edit: Switched
• 08:1508:15, 27 August 2026 diff hist +1,541‎ N JIT in Scheme ‎ Created page with "= JIT Compilation = Our scheme dialect allows to JIT-compile SCM code into real machine code. ← Back to Full SCM API documentation == jit == compiles a lambda to optimized native code when this build enables JIT '''Allowed number of parameters:''' 1–1 <span id="parameters"></span> === Parameters === * '''fn''' (<code>any</code>): the function to compile <span id="returns"></span> === Returns === <code>any</code> <span id="jit-1"></span> == jit? == tel..." current Tag: Visual edit: Switched
• 08:1408:14, 27 August 2026 diff hist +24‎ Main Page ‎ →‎Scheme documentation Tag: Visual edit
• 08:1308:13, 27 August 2026 diff hist +24‎ Full SCM API documentation ‎No edit summary Tag: Visual edit
• 08:1208:12, 27 August 2026 diff hist +3,967‎ IO ‎No edit summary
• 08:1108:11, 27 August 2026 diff hist +4,180‎ Date ‎No edit summary
• 08:1008:10, 27 August 2026 diff hist +4,501‎ Associative Lists / Dictionaries ‎No edit summary
• 08:0908:09, 27 August 2026 diff hist +715‎ Arithmetic / Logic ‎No edit summary
• 08:0808:08, 27 August 2026 diff hist +5,758‎ Arithmetic / Logic ‎No edit summary

26 August 2026

• 09:3109:31, 26 August 2026 diff hist +112‎ Supported SQL ‎No edit summary Tag: Visual edit
• 09:2209:22, 26 August 2026 diff hist +14,180‎ N JSON ‎ Created page with "= JSON and SQL/JSON in MemCP = '''MemCP provides native JSON and SQL/JSON support on its high-performance columnar SQL engine.''' JSON documents can be filtered, joined, grouped, sorted, modified and assembled into deeply nested application responses without leaving SQL. The same JSON engine is exposed through both MemCP SQL dialects: applications get MySQL/MariaDB-compatible JSON functions such as <code>JSON_EXTRACT</code>, <code>JSON_VALUE</code>, <code>JSON_OBJECT</..."

21 August 2026

• 17:1117:11, 21 August 2026 diff hist +11,921‎ Current Status and Open Issues ‎No edit summary
• 16:2316:23, 21 August 2026 diff hist +7,296‎ Main Page ‎No edit summary
• 13:2713:27, 21 August 2026 diff hist +254‎ Main Page ‎No edit summary Tag: Visual edit
• 13:1813:18, 21 August 2026 diff hist +55‎ Main Page ‎ →‎Navigation Tag: Visual edit
• 13:0413:04, 21 August 2026 diff hist +1,092‎ N Dashboard and Operations ‎ Created page with "The <code>/dashboard</code> interface provides CPU/memory/request metrics, database and table browsing, shard/compression details, SQL/Scheme consoles, users and grants, runtime settings, process inspection, service state, and configured logs. <code>SHOW [FULL] PROCESSLIST</code>, dashboard process controls, <code>KILL QUERY</code>, and <code>KILL CONNECTION</code> expose active work and cancellation. Graceful shutdown stops new requests and waits up to <code>ShutdownDr..." Tag: Visual edit: Switched
• 13:0313:03, 21 August 2026 diff hist +1,027‎ N Triggers ‎ Created page with "MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read <code>OLD</code> and <code>NEW<</code>, assign permitted <code>NEW</code> values, run conditional BEGIN/END bodies, and execute supported DML including <code>INSERT … SELECT</code>. Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statemen..." Tag: Visual edit
• 13:0213:02, 21 August 2026 diff hist +1,024‎ N Memory Management and Eviction ‎ Created page with "MemCP tracks persisted shard columns, indexes, temporary columns, keytables, cache-engine objects, and string dictionaries in a global memory manager. The overall budget defaults to 50% of system RAM. A separate persisted-data budget defaults to 30%. Exact byte limits override percentages. If system available memory falls too low, MemCP can evict before its own configured budget is exhausted. Eviction is LRU-like and type-aware. Persistent shard eviction releases only..." Tag: Visual edit
• 13:0113:01, 21 August 2026 diff hist +1,260‎ N Transactions and Isolation ‎ Created page with "Every SQL statement runs in an implicit transaction unless the session already has an explicit <code>BEGIN</code>/<code>COMMIT</code>/<code>ROLLBACK</code> transaction. The default cursor-stability mode applies writes directly with undo masks, gives statement atomicity, and rolls back on errors. MemCP also contains an ACID mode with snapshot visibility and optimistic commit conflict detection. Savepoints are used internally for nested trigger/error recovery. Transactio..." Tag: Visual edit
• 12:5812:58, 21 August 2026 diff hist +14,007‎ N Query Planner and Physical Lowering ‎ Created page with "MemCP compiles SQL into executable Scheme code. The planner first converts SQL into a logical representation, decorrelates subqueries, and chooses a join order. Only after those semantic decisions are complete does the physical lowerer select scans, indexes, caches, RecSets, computed columns, and other storage-engine operators. This separation is important: two queries that mean the same thing should reach the same logical representation even when they use different..." Tag: Visual edit

9 March 2026

• 14:2014:20, 9 March 2026 diff hist +82‎ Persistency and Performance Guarantees ‎ →‎Persistency Guarantees Tag: Visual edit
• 14:1614:16, 9 March 2026 diff hist +275‎ Persistency and Performance Guarantees ‎ →‎Persistency Guarantees Tag: Visual edit
• 14:1314:13, 9 March 2026 diff hist +16‎ Persistency and Performance Guarantees ‎ →‎Persistency Guarantees Tag: Visual edit