All public logs

Combined display of all available logs of MemCP. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 14:59, 15 June 2025 Carli talk contribs created page 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
• 22:45, 19 December 2024 Carli talk contribs created page 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:33, 10 December 2024 Carli talk contribs created page 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...") Tag: Visual edit
• 21:01, 20 November 2024 Carli talk contribs created page 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:15, 20 November 2024 Carli talk contribs created page 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:12, 20 November 2024 Carli talk contribs deleted page Replace MySQL with MemCP (content was: "thumb|none|640x640px === Connection to MemCP === 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 === To import data from MySQL into MemCP, you have to per...", and the only contributor was "Carli" (talk))
• 20:10, 19 November 2024 Carli talk contribs created page Deployment (Created page with "MemCP is relatively easy to deploy. It only requires minimal system requirements (some 10-20 Megabytes of RAM for the base system). There are two deployment methods: === Deployment via pm2 (preferred) === To run memcp, just follow these commands: git clone https://github.com/launix-de/memcp cd memcp go get make # make sure, go is installed pm2 start ./memcp -data ./data/ # use a different path than ./data if you wish; install pm2 If you want to update memcp, just r...") Tag: Visual edit
• 12:36, 31 October 2024 Carli talk contribs undeleted page File:Ports.svg (1 revision and 1 file)
• 12:34, 31 October 2024 Carli talk contribs deleted page File:Https---www.memcp.org-images-0-03-Webapps with MemCP.svg
• 12:31, 31 October 2024 Carli talk contribs uploaded File:Https---www.memcp.org-images-0-03-Webapps with MemCP.svg
• 12:31, 31 October 2024 Carli talk contribs created page File:Https---www.memcp.org-images-0-03-Webapps with MemCP.svg
• 12:27, 31 October 2024 Carli talk contribs uploaded File:Webapps.svg
• 12:27, 31 October 2024 Carli talk contribs created page File:Webapps.svg