User contributions for Carli

23:3723:37, 4 October 2025 diff hist +1‎ Persistency and Performance Guarantees ‎No edit summary current Tag: Visual edit
23:3423:34, 4 October 2025 diff hist +43‎ Settings ‎No edit summary current Tag: Visual edit

12:5212:52, 22 September 2025 diff hist +1,914‎ Main Page ‎No edit summary current
12:3912:39, 22 September 2025 diff hist −4,996‎ Main Page ‎No edit summary Tag: Visual edit: Switched

13:4013:40, 4 September 2025 diff hist +39‎ Comparison: MemCP vs. MySQL ‎No edit summary current Tag: Visual edit
13:4013: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..." current Tag: Visual edit
13:3813:38, 4 September 2025 diff hist +40‎ Main Page ‎ →‎🚀 Meet MemCP – The MySQL Alternative You've Been Waiting For Tag: Visual edit

22:5722:57, 31 August 2025 diff hist +275‎ Cluster Monitor ‎ →‎How it works current Tag: Visual edit
21:2721:27, 31 August 2025 diff hist +212‎ Cluster Monitor ‎No edit summary Tag: Visual edit
19:5919:59, 31 August 2025 diff hist +195‎ File System ‎No edit summary current Tag: Visual edit
19:5819: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
19:5519:55, 31 August 2025 diff hist +737‎ Cluster Monitor ‎No edit summary Tag: Visual edit
19:5119:51, 31 August 2025 diff hist +108‎ Cluster Monitor ‎No edit summary Tag: Visual edit
19:5019: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
19:3719:37, 31 August 2025 diff hist +22‎ Main Page ‎ →‎Persistency Backends (= Storage) Tag: Visual edit
19:3719:37, 31 August 2025 diff hist +97‎ Main Page ‎No edit summary Tag: Visual edit

19:1019: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..." current
19:0919: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..." current Tag: Visual edit: Switched
17:4417:44, 25 August 2025 diff hist +228‎ Main Page ‎No edit summary Tag: Visual edit
17:0617: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" current
17:0317:03, 25 August 2025 diff hist +65‎ Main Page ‎ →‎How things work in MemCP Tag: Visual edit
17:0217:02, 25 August 2025 diff hist −7,609‎ Introduction to Scheme ‎ →‎Deeper Topics into Scheme current Tag: Visual edit

20:0620: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..." current Tag: Visual edit

13:5913: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" current Tag: Visual edit
13:5713:57, 15 June 2025 diff hist +39‎ Main Page ‎ →‎SQL Frontend Tag: Visual edit

12:0312:03, 29 May 2025 diff hist +2,668‎ Main Page ‎No edit summary Tag: Visual edit

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

21:5621:56, 19 December 2024 diff hist +32‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
21:5421:54, 19 December 2024 diff hist +3‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
21:5421:54, 19 December 2024 diff hist +765‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
21:4721:47, 19 December 2024 diff hist −29‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
21:4621:46, 19 December 2024 diff hist +1,083‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
21:4521:45, 19 December 2024 diff hist +293‎ N Comparison: MemCP vs. MySQL ‎ Created page with "MemCP has the following advantages over MySQL: * No 64 character limit for column names * uses only 20% of storage compared to InnoDB and MyISAM storage format * supports natural sort (1, 2, 10, 11 instead of 1, 10, 11, 2) with collations * Up to 10x faster query performance for aggregations" Tag: Visual edit
21:4221:42, 19 December 2024 diff hist +33‎ Main Page ‎ →‎Introduction Tag: Visual edit

20:3320:33, 10 December 2024 diff hist +2,992‎ N MemCP for Microservices ‎ Created page with "MemCP is a neat database to implement microservices. Here's a code example for a simple key value store: →‎microservice democase: a simple key value store with prepared statements: (import "../lib/sql-parser.scm") (import "../lib/queryplan.scm") →‎initialize database and prepare sql statements: (createdatabase "keyvalue" true) (eval (parse_sql "keyvalue" "CREATE TABLE IF NOT EXISTS kv(key TEXT, value TEXT, UNIQUE KEY PRIMARY(key))")) (set item_get (par..." current Tag: Visual edit
20:0820:08, 10 December 2024 diff hist +29‎ Main Page ‎ →‎Custom Frontends Tag: Visual edit

21:3121:31, 20 November 2024 diff hist +53‎ MemCP Console ‎No edit summary current Tag: Visual edit
20:1420:14, 20 November 2024 diff hist +19‎ Main Page ‎ →‎Administration Tag: Visual edit
20:0120:01, 20 November 2024 diff hist +498‎ N MemCP Console ‎ Created page with "There are two ways to access MemCP Scheme Console: a) if you run <code>memcp</code>in the console, just type in your scheme commands b) if you run <code>memcp</code>in docker or pm2 where you don't have access to the console, open a MySQL connection and type <code>SET syntax = 'scheme';</code>and then type in your commands followed by <code>;.</code> In option b) it might be that some commands like (help) output to memcp console instead of your mysql shell. So better..." Tag: Visual edit
19:3819:38, 20 November 2024 diff hist −82‎ Current Status and Open Issues ‎ →‎Scheme language current Tag: Visual edit
19:3319:33, 20 November 2024 diff hist +18‎ Migration from MySQL and PostgreSQL ‎No edit summary current Tag: Visual edit
19:3119:31, 20 November 2024 diff hist +37‎ Migration from MySQL and PostgreSQL ‎ →‎Connection to MemCP from PostgreSQL Tag: Visual edit
19:2719:27, 20 November 2024 diff hist +3‎ What is OLTP and OLAP ‎ →‎See also current Tag: Visual edit
19:2319:23, 20 November 2024 diff hist +31‎ Deployment ‎No edit summary current Tag: Visual edit
19:2219:22, 20 November 2024 diff hist +138‎ Deployment ‎No edit summary Tag: Visual edit
19:2019:20, 20 November 2024 diff hist +43‎ Migration from MySQL and PostgreSQL ‎No edit summary Tag: Visual edit
19:1919:19, 20 November 2024 diff hist −28‎ Migration from MySQL and PostgreSQL ‎ →‎Connection to MemCP from PostgreSQL Tag: Visual edit

User contributions for Carli

4 October 2025

22 September 2025

4 September 2025

31 August 2025

25 August 2025

22 August 2025

15 June 2025

30 May 2025

29 May 2025

20 December 2024

19 December 2024

10 December 2024

20 November 2024

Navigation menu

Search