User contributions for Carli

21 August 2026

• 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
• 14:1314:13, 9 March 2026 diff hist +450‎ Persistency and Performance Guarantees ‎No edit summary Tag: Visual edit

27 February 2026

• 04:2104:21, 27 February 2026 diff hist +53‎ Main Page ‎No edit summary Tag: Visual edit
• 04:1904:19, 27 February 2026 diff hist +28‎ N File:Memcp-Load.png ‎No edit summary current

26 January 2026

• 08:3908:39, 26 January 2026 diff hist +29‎ Main Page ‎No edit summary Tag: Visual edit
• 08:3908:39, 26 January 2026 diff hist +1,272‎ Data Auto Sharding and Auto Indexing ‎No edit summary Tag: Visual edit
• 02:0602:06, 26 January 2026 diff hist +97‎ Supported SQL ‎ →‎Statements Tag: Visual edit
• 02:0602:06, 26 January 2026 diff hist −1,290‎ Auto Sharding ‎ Blanked the page Tags: Blanking Visual edit
• 02:0102:01, 26 January 2026 diff hist +1,160‎ Advanced SQL Tutorial ‎No edit summary Tag: Visual edit
• 02:0002:00, 26 January 2026 diff hist +2,078‎ N Performance Measurement ‎ Created page with " == Performance Testing Framework == MemCP includes an auto-calibrating performance test framework for regression detection and benchmarking. === Running Performance Tests === <code># Run performance tests (uses calibrated baselines) PERF_TEST=1 make test # Calibrate for your machine (run ~10 times to reach target) PERF_TEST=1 PERF_CALIBRATE=1 make test # Freeze row counts for bisecting regressions PERF_TEST=1 PERF_NORECALIBRATE=1 make test # Show query exe..." Tag: Visual edit
• 01:5801:58, 26 January 2026 diff hist +18‎ Auto Sharding ‎No edit summary Tag: Visual edit
• 01:5701:57, 26 January 2026 diff hist +1,272‎ N Auto Sharding ‎ Created page with "## Parallel Sharding MemCP automatically creates parallel shards for optimal query performance across multiple CPU cores. ### Bulk Insert Optimization When inserting large amounts of data, MemCP automatically: 1. **Splits bulk inserts into chunks** of 60,000 rows (configurable via ShardSize) 2. **Creates new shards on-the-fly** when the current shard fills up 3. **Rebuilds full shards in parallel** using background goroutines This enables insertion of millions of ro..."

5 October 2025

• 00:3700:37, 5 October 2025 diff hist +1‎ Persistency and Performance Guarantees ‎No edit summary Tag: Visual edit
• 00:3400:34, 5 October 2025 diff hist +43‎ Settings ‎No edit summary Tag: Visual edit

22 September 2025

• 13:5213:52, 22 September 2025 diff hist +1,914‎ Main Page ‎No edit summary
• 13:3913:39, 22 September 2025 diff hist −4,996‎ Main Page ‎No edit summary Tag: Visual edit: Switched

4 September 2025

• 14:4014:40, 4 September 2025 diff hist +39‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
• 14:4014:40, 4 September 2025 diff hist +2,328‎ N MySQL is too slow ‎ Created page with " =MemCP — Faster alternative when "MySQL is too slow"= '''Short description:''' MemCP is an in-memory, column-oriented database optimized for high throughput OLAP and OLTP workloads. It is designed to deliver much faster aggregation and query performance than traditional row-based engines like MySQL. ==Overview== MemCP is a blazing-fast, in-memory, columnar database with built-in REST APIs and a lightweight SQL frontend. It is intended for modern workloads where MySQL..." Tag: Visual edit
• 14:3814:38, 4 September 2025 diff hist +40‎ Main Page ‎ →‎🚀 Meet MemCP – The MySQL Alternative You've Been Waiting For Tag: Visual edit

31 August 2025

• 23:5723:57, 31 August 2025 diff hist +275‎ Cluster Monitor ‎ →‎How it works Tag: Visual edit
• 22:2722:27, 31 August 2025 diff hist +212‎ Cluster Monitor ‎No edit summary Tag: Visual edit
• 20:5920:59, 31 August 2025 diff hist +195‎ File System ‎No edit summary Tag: Visual edit
• 20:5820:58, 31 August 2025 diff hist +550‎ N File System ‎ Created page with "In the file system persistency layer, each subfolder of your data folder is a database. Each folder has the following files: * schema.json - list of all tables, columns, keys and shards; is updated every time a shard is added or removed or the schema changes * schema.json.old - fallback file for crash recovery * [uuid]-[columnname] - the content of a column (in case the ENGINE is not MEMORY) * [uuid].log - transaction log in c..." Tag: Visual edit
• 20:5520:55, 31 August 2025 diff hist +737‎ Cluster Monitor ‎No edit summary Tag: Visual edit
• 20:5120:51, 31 August 2025 diff hist +108‎ Cluster Monitor ‎No edit summary Tag: Visual edit
• 20:5020:50, 31 August 2025 diff hist +495‎ N Cluster Monitor ‎ Created page with "The cluster monitor lets you scale out MemCP over multiple nodes. Here is what you can achieve: * '''Multiple users''': each user has his own database * '''One big user''': Big tables are spread over multiple nodes * A mixture of both variants Each database and each shard (the piece where a part of a table's data is stored) can be placed either: * '''COLD''': only in storage backend * '''SHARED''': read-only on multiple nodes (e.g. the access table) * '''WRITE''': exc..." Tag: Visual edit
• 20:3720:37, 31 August 2025 diff hist +22‎ Main Page ‎ →‎Persistency Backends (= Storage) Tag: Visual edit
• 20:3720:37, 31 August 2025 diff hist +97‎ Main Page ‎No edit summary Tag: Visual edit

25 August 2025

• 20:1020:10, 25 August 2025 diff hist +7,819‎ N Storage ‎ Created page with "= Storage = The '''Storage''' module provides functions to manage databases, tables, columns, keys, partitions, and large data operations in SCM. ← Back to Full SCM API documentation == scan == Performs an unordered parallel filter-map-reduce on a table '''Allowed number of parameters:''' 6–10 '''Parameters:''' * '''schema''' (<code>string|nil</code>): database name * '''table''' (<code>string|list</code>): table name(s) * '''filterColumns''' (<code>list</c..."
• 20:0920:09, 25 August 2025 diff hist +3,539‎ N IO ‎ Created page with "= IO = The '''IO''' module provides functions for input and output operations, environment handling, file streaming, server control, and argument parsing in SCM. ← Back to Full SCM API documentation == print == Prints values to stdout (only in IO environment) '''Allowed number of parameters:''' 1–1000 '''Parameters:''' * '''value...''' (<code>any</code>): values to print '''Returns:''' <code>bool</code> == env == returns the content of a environment vari..." Tag: Visual edit: Switched
• 18:4418:44, 25 August 2025 diff hist +228‎ Main Page ‎No edit summary Tag: Visual edit
• 18:0618:06, 25 August 2025 diff hist +214‎ N Full SCM API documentation ‎ Created page with "= Documentation = * SCM Builtins * Arithmetic / Logic * Strings * Streams * Lists * Associative Lists / Dictionaries * Date * Vectors * Parsers * Sync * IO * Storage"
• 18:0318:03, 25 August 2025 diff hist +65‎ Main Page ‎ →‎How things work in MemCP Tag: Visual edit
• 18:0218:02, 25 August 2025 diff hist −7,609‎ Introduction to Scheme ‎ →‎Deeper Topics into Scheme Tag: Visual edit

22 August 2025

• 21:0621:06, 22 August 2025 diff hist +1,520‎ N Dictionary Compression ‎ Created page with "Strings are the nightmare of every database. You never know their exact size and you have to either reference them in a separate storage or reserve enough character space to store them in-table. Columnar databases can do better. But that's not guaranteed, you have to put a bit of extra effort into it. Here's how: At first, memcp converts strings into dictionaries. If you have a large list consisting of [Male, Male, Male, Female, Male, Female, Male, Male], you only have..." Tag: Visual edit

15 June 2025

• 14:5914:59, 15 June 2025 diff hist +204‎ N Add custom SQL operators to MemCP ‎ Created page with "Some special applications need user defined custom functions. You can define them in scheme like: (sql_builtins "ADD_1" (lambda (x) (+ x 1))) Now you can call the function by: SELECT ADD_1(4) AS result" Tag: Visual edit
• 14:5714:57, 15 June 2025 diff hist +39‎ Main Page ‎ →‎SQL Frontend Tag: Visual edit

30 May 2025

• 11:4311:43, 30 May 2025 diff hist −6‎ Main Page ‎ →‎🧑‍💻 Built for Developers, by Developers Tag: Visual edit
• 11:3811:38, 30 May 2025 diff hist +8‎ Main Page ‎ →‎🧑‍💻 Built for Developers, by Developers Tag: Visual edit
• 11:3811:38, 30 May 2025 diff hist +51‎ Main Page ‎ →‎🧑‍💻 Built for Developers, by Developers Tag: Visual edit

29 May 2025

• 13:0313:03, 29 May 2025 diff hist +2,668‎ Main Page ‎No edit summary Tag: Visual edit

20 December 2024

• 21:4721:47, 20 December 2024 diff hist +6‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit

19 December 2024

• 22:5622:56, 19 December 2024 diff hist +32‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
• 22:5422:54, 19 December 2024 diff hist +3‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
• 22:5422:54, 19 December 2024 diff hist +765‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
• 22:4722:47, 19 December 2024 diff hist −29‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit