User contributions for Carli

4 September 2025

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

31 August 2025

• 23:5723:57, 31 August 2025 diff hist +275‎ Cluster Monitor ‎ →‎How it works current 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 current 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..." current
• 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..." current 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" current
• 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 current 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..." current 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" current 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
• 22:4622:46, 19 December 2024 diff hist +1,083‎ Comparison: MemCP vs. MySQL ‎No edit summary Tag: Visual edit
• 22:4522: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
• 22:4222:42, 19 December 2024 diff hist +33‎ Main Page ‎ →‎Introduction Tag: Visual edit

10 December 2024

• 21:3321: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
• 21:0821:08, 10 December 2024 diff hist +29‎ Main Page ‎ →‎Custom Frontends Tag: Visual edit

20 November 2024

• 22:3122:31, 20 November 2024 diff hist +53‎ MemCP Console ‎No edit summary current Tag: Visual edit
• 21:1421:14, 20 November 2024 diff hist +19‎ Main Page ‎ →‎Administration Tag: Visual edit
• 21:0121: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
• 20:3820:38, 20 November 2024 diff hist −82‎ Current Status and Open Issues ‎ →‎Scheme language current Tag: Visual edit
• 20:3320:33, 20 November 2024 diff hist +18‎ Migration from MySQL and PostgreSQL ‎No edit summary current Tag: Visual edit
• 20:3120:31, 20 November 2024 diff hist +37‎ Migration from MySQL and PostgreSQL ‎ →‎Connection to MemCP from PostgreSQL Tag: Visual edit
• 20:2720:27, 20 November 2024 diff hist +3‎ What is OLTP and OLAP ‎ →‎See also current Tag: Visual edit
• 20:2320:23, 20 November 2024 diff hist +31‎ Deployment ‎No edit summary current Tag: Visual edit
• 20:2220:22, 20 November 2024 diff hist +138‎ Deployment ‎No edit summary Tag: Visual edit
• 20:2020:20, 20 November 2024 diff hist +43‎ Migration from MySQL and PostgreSQL ‎No edit summary Tag: Visual edit
• 20:1920:19, 20 November 2024 diff hist −28‎ Migration from MySQL and PostgreSQL ‎ →‎Connection to MemCP from PostgreSQL Tag: Visual edit
• 20:1920:19, 20 November 2024 diff hist +1‎ Migration from MySQL and PostgreSQL ‎ →‎Connection to MemCP from PostgreSQL Tag: Visual edit
• 20:1820:18, 20 November 2024 diff hist +280‎ Migration from MySQL and PostgreSQL ‎ →‎Connection to MemCP via MySQL Connector Tag: Visual edit
• 20:1520:15, 20 November 2024 diff hist +873‎ N Migration from MySQL and PostgreSQL ‎ Created page with "thumb|none|640x640px ===Connection to MemCP via MySQL Connector=== MemCP can be connected with any compatible MySQL connector: $db = new \PDO<code>"mysql:host=localhost;port=3307;dbname=system", 'root', 'admin');</code> echo $db->query("SELECT 'it works'")->fetchColumn(); // outouts: it works ===Import data from MySQL and PostgreSQL=== To import data from MySQL into MemCP, you have to perform the following command in<code>memcp</code>console: (l..." Tag: Visual edit
• 20:1120:11, 20 November 2024 diff hist +330‎ SQL over REST ‎No edit summary current Tag: Visual edit