New pages

Jump to navigation Jump to search
New pages
Hide registered users | Hide bots | Show redirects
  • 20:58, 31 August 2025 ‎File System (hist | edit) ‎[745 bytes] ‎Carli (talk | contribs) (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:50, 31 August 2025 ‎Cluster Monitor (hist | edit) ‎[1,827 bytes] ‎Carli (talk | contribs) (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:10, 25 August 2025 ‎Storage (hist | edit) ‎[7,819 bytes] ‎Carli (talk | contribs) (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:09, 25 August 2025 ‎IO (hist | edit) ‎[3,539 bytes] ‎Carli (talk | contribs) (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:53, 25 August 2025 ‎Sync (hist | edit) ‎[2,480 bytes] ‎Aiagent (talk | contribs) (Created page with "= Sync = The '''Sync''' module provides synchronization and concurrency functionality for the SCM programming language. This module includes: * '''Session management''': Functions to create threadsafe key-value stores (newsession) * '''Context handling''': Context management with session support (context) * '''Timing control''': Functions to pause execution (sleep) * '''Function caching''': One-time execution wrappers with result caching (once) * '''Thread synchronizat...")
  • 18:51, 25 August 2025 ‎Parsers (hist | edit) ‎[2,281 bytes] ‎Aiagent (talk | contribs) (Created page with "= Parsers = The '''Parsers''' module provides parsing functionality for the SCM programming language. This module includes: * '''Parser creation''': Functions to create custom parsers using grammar syntax (parser) * '''Grammar support''': Support for various parser types including AtomParser, RegexParser, AndParser, OrParser, KleeneParser, ManyParser, MaybeParser, and more * '''Packrat parsing''': Implementation of packrat parsing algorithms for efficient parsing * '''...")
  • 18:50, 25 August 2025 ‎Vectors (hist | edit) ‎[832 bytes] ‎Aiagent (talk | contribs) (Created page with "= Vectors = The '''Vectors''' module provides vector mathematics functionality for the SCM programming language. This module includes: * '''Vector operations''': Functions to perform mathematical operations on vectors (dot) * '''Distance calculations''': Support for different distance metrics including DOT, COSINE, and EUCLIDEAN These functions provide essential tools for working with vectors in mathematical computations, enabling vector analysis and similarity calcul...")
  • 18:49, 25 August 2025 ‎Date (hist | edit) ‎[854 bytes] ‎Aiagent (talk | contribs) (Created page with "= Date = The '''Date''' module provides date and time functionality for the SCM programming language. This module includes: * '''Current time''': Functions to get the current Unix timestamp (now) * '''Date parsing''': Functions to parse date strings into Unix timestamps (parse_date) These functions provide essential tools for working with dates and timestamps in SCM programs, enabling time-based operations and date string processing. ← Back to Full SCM API docume...")
  • 18:48, 25 August 2025 ‎Associative Lists / Dictionaries (hist | edit) ‎[4,457 bytes] ‎Aiagent (talk | contribs) (Created page with "= Associative Lists / Dictionaries = The '''Associative Lists / Dictionaries''' module provides key-value data structure operations for the SCM programming language. This module includes: * '''Dictionary filtering''': Functions to filter dictionaries based on key-value conditions (filter_assoc) * '''Dictionary mapping''': Transform dictionary values while preserving keys (map_assoc) * '''Dictionary reduction''': Aggregate dictionary data into single values (reduce_asso...")
  • 18:46, 25 August 2025 ‎Lists (hist | edit) ‎[6,678 bytes] ‎Aiagent (talk | contribs) (Created page with "= Lists = The '''Lists''' module provides comprehensive list manipulation and processing functions for the SCM programming language. This module includes: * '''List operations''': Basic operations like counting (count), accessing elements (nth), and type checking (list?) * '''List construction''': Building lists with append, cons, and unique operations (append_unique, merge_unique) * '''List deconstruction''': Extracting parts with car (head), cdr (tail), and filtering...")
  • 18:43, 25 August 2025 ‎Streams (hist | edit) ‎[1,858 bytes] ‎Aiagent (talk | contribs) (Created page with "= Streams = The '''Streams''' module provides stream processing and compression functionality for the SCM programming language. This module includes: * '''Stream creation''': Functions to create streams from string content (streamString) * '''Compression''': Stream compression using gzip and xz algorithms * '''Decompression''': Stream decompression using zcat (gzip) and xzcat (xz) functions These functions enable efficient handling of data streams, file compression, a...")
  • 18:35, 25 August 2025 ‎Strings (hist | edit) ‎[5,794 bytes] ‎Aiagent (talk | contribs) (Created page with "= Strings = The '''Strings''' module provides comprehensive string manipulation and processing functions for the SCM programming language. This module includes: * '''String validation''': Functions to check string types and properties (string?, strlen) * '''String manipulation''': Concatenation (concat), substring extraction (substr), and case conversion (toLower, toUpper) * '''Pattern matching''': Wildcard pattern matching (strlike) and string replacement (replace) *...")
  • 18:30, 25 August 2025 ‎Arithmetic / Logic (hist | edit) ‎[4,649 bytes] ‎Aiagent (talk | contribs) (Created page with "= Arithmetic / Logic = The '''Arithmetic / Logic''' module provides essential mathematical operations and logical comparisons for the SCM programming language. This module includes: * '''Type checking''': Functions to verify data types (int?, number?, nil?) * '''Basic arithmetic''': Addition (+), subtraction (-), multiplication (*), and division (/) * '''Comparison operations''': All standard comparison operators (>, <, >=, <=, equal?) * '''Logical operations''': Boole...")
  • 18:16, 25 August 2025 ‎SCM Builtins (hist | edit) ‎[9,333 bytes] ‎Aiagent (talk | contribs) (Created page with "# SCM Builtins ## quote returns a symbol or list without evaluating it **Allowed number of parameters:** 1–1 ### Parameters - **symbol** (`symbol`): symbol to quote ### Returns `symbol` ## eval executes the given scheme program in the current environment **Allowed number of parameters:** 1–1 ### Parameters - **code** (`list`): list with head and optional parameters ### Returns `any` ## size compute the memory size of a value **Allowed number of param...")
  • 18:06, 25 August 2025 ‎Full SCM API documentation (hist | edit) ‎[214 bytes] ‎Carli (talk | contribs) (Created page with "= Documentation = * SCM Builtins * Arithmetic / Logic * Strings * Streams * Lists * Associative Lists / Dictionaries * Date * Vectors * Parsers * Sync * IO * Storage")
  • 21:06, 22 August 2025 ‎Dictionary Compression (hist | edit) ‎[1,520 bytes] ‎Carli (talk | contribs) (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
  • 14:59, 15 June 2025 ‎Add custom SQL operators to MemCP (hist | edit) ‎[204 bytes] ‎Carli (talk | contribs) (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
Retrieved from "https://www.memcp.org/wiki/Special:NewPages"