New pages
Jump to navigation
Jump to search
- 20:50, 8 September 2026 Benchmark MemCP vs. MariaDB on Wordpress (hist | edit) [14,108 bytes] Carli (talk | contribs) (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...")
- 11:59, 28 August 2026 RecSets (hist | edit) [15,784 bytes] Wikiservice (talk | contribs) (Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference)
- 11:59, 28 August 2026 Security and Authentication (hist | edit) [1,368 bytes] Wikiservice (talk | contribs) (Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference)
- 11:59, 28 August 2026 Storage Backends (hist | edit) [1,272 bytes] Wikiservice (talk | contribs) (Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference)
- 11:59, 28 August 2026 JIT Compilation (hist | edit) [2,955 bytes] Wikiservice (talk | contribs) (Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference)
- 11:59, 28 August 2026 Dashboard Metrics (hist | edit) [3,135 bytes] Wikiservice (talk | contribs) (Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference)
- 08:38, 27 August 2026 Window Functions (hist | edit) [5,104 bytes] Carli (talk | contribs) (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:36, 27 August 2026 Transactions (hist | edit) [3,840 bytes] Carli (talk | contribs) (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:35, 27 August 2026 Timezone (hist | edit) [4,198 bytes] Carli (talk | contribs) (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:15, 27 August 2026 JIT in Scheme (hist | edit) [1,541 bytes] Carli (talk | contribs) (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...") Tag: Visual edit: Switched
- 09:22, 26 August 2026 JSON (hist | edit) [2,837 bytes] Carli (talk | contribs) (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</...")
- 13:04, 21 August 2026 Dashboard and Operations (hist | edit) [2,154 bytes] Carli (talk | contribs) (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:03, 21 August 2026 Triggers (hist | edit) [1,323 bytes] Carli (talk | contribs) (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:02, 21 August 2026 Memory Management and Eviction (hist | edit) [2,134 bytes] Carli (talk | contribs) (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:01, 21 August 2026 Transactions and Isolation (hist | edit) [2,420 bytes] Carli (talk | contribs) (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:58, 21 August 2026 Query Planner and Physical Lowering (hist | edit) [9,341 bytes] Carli (talk | contribs) (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