User contributions for Carli

20 December 2024

• 21:4721:47, 20 December 2024 diff hist +6‎ Comparison: MemCP vs. MySQL ‎No edit summary current 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 current 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
• 20:1020:10, 20 November 2024 diff hist −30‎ Main Page ‎ →‎SQL Frontend Tag: Visual edit
• 20:0920:09, 20 November 2024 diff hist +42‎ Main Page ‎ →‎Navigation Tag: Visual edit

19 November 2024

• 20:1020:10, 19 November 2024 diff hist +891‎ N 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
• 20:0220:02, 19 November 2024 diff hist +17‎ Main Page ‎ →‎Navigation Tag: Visual edit

31 October 2024

• 12:3712:37, 31 October 2024 diff hist +2‎ Main Page ‎ →‎What is memcp? Tag: Visual edit
• 12:3612:36, 31 October 2024 diff hist 0‎ Main Page ‎No edit summary Tag: Visual edit
• 12:3412:34, 31 October 2024 diff hist −38‎ Main Page ‎No edit summary Tag: Visual edit
• 12:3212:32, 31 October 2024 diff hist +14‎ Main Page ‎No edit summary Tag: Visual edit: Switched
• 12:3112:31, 31 October 2024 diff hist +6‎ Main Page ‎No edit summary Tag: Visual edit
• 12:3112:31, 31 October 2024 diff hist −11‎ Main Page ‎No edit summary Tag: Visual edit
• 12:3012:30, 31 October 2024 diff hist −14‎ Main Page ‎No edit summary Tag: Visual edit
• 12:3012:30, 31 October 2024 diff hist −32‎ Main Page ‎ →‎What is memcp? Tag: Visual edit
• 12:2712:27, 31 October 2024 diff hist −11‎ Main Page ‎No edit summary Tag: Visual edit
• 12:2712:27, 31 October 2024 diff hist 0‎ N File:Webapps.svg ‎No edit summary current
• 12:2312:23, 31 October 2024 diff hist 0‎ N File:Webapps with MemCP.svg ‎No edit summary current
• 12:2212:22, 31 October 2024 diff hist −6‎ Main Page ‎No edit summary Tag: Visual edit
• 12:1912:19, 31 October 2024 diff hist +11‎ Main Page ‎No edit summary Tag: Visual edit
• 12:0412:04, 31 October 2024 diff hist +61‎ N File:Ports.svg ‎No edit summary current
• 11:5511:55, 31 October 2024 diff hist +32‎ Main Page ‎No edit summary Tag: Visual edit
• 11:5511:55, 31 October 2024 diff hist +71‎ N File:MemCP Port.png ‎No edit summary current
• 11:5111:51, 31 October 2024 diff hist +6‎ Main Page ‎No edit summary Tag: Visual edit
• 11:4911:49, 31 October 2024 diff hist −8‎ Main Page ‎No edit summary Tag: Visual edit
• 11:4811:48, 31 October 2024 diff hist +71‎ N File:Webapps.png ‎No edit summary current

8 October 2024

• 23:2623:26, 8 October 2024 diff hist +44‎ Websockets in MemCP ‎ →‎Complex Example current Tag: Visual edit
• 23:2323:23, 8 October 2024 diff hist +59‎ Persistency and Performance Guarantees ‎ →‎Performance Guarantees current Tag: Visual edit