MediaWiki API result
This is the HTML representation of the JSON format. HTML is good for debugging, but is unsuitable for application use.
Specify the format parameter to change the output format. To see the non-HTML representation of the JSON format, set format=json.
See the complete documentation, or the API help for more information.
{
"batchcomplete": "",
"continue": {
"lecontinue": "2024-10-31 10:31:37+00|102",
"continue": "-||"
},
"query": {
"logevents": [
{
"logid": 112,
"ns": 0,
"title": "Add custom SQL operators to MemCP",
"pageid": 67,
"logpage": 67,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2025-06-15T12:59:44Z",
"comment": "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\""
},
{
"logid": 111,
"ns": 0,
"title": "Comparison: MemCP vs. MySQL",
"pageid": 66,
"logpage": 66,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2024-12-19T20:45:02Z",
"comment": "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\""
},
{
"logid": 110,
"ns": 0,
"title": "MemCP for Microservices",
"pageid": 65,
"logpage": 65,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2024-12-10T19:33:01Z",
"comment": "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...\""
},
{
"logid": 109,
"ns": 0,
"title": "MemCP Console",
"pageid": 64,
"logpage": 64,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2024-11-20T19:01:41Z",
"comment": "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...\""
},
{
"logid": 108,
"ns": 0,
"title": "Migration from MySQL and PostgreSQL",
"pageid": 63,
"logpage": 63,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2024-11-20T18:15:24Z",
"comment": "Created page with \"[[File:Ports.svg|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...\""
},
{
"logid": 107,
"ns": 0,
"title": "Replace MySQL with MemCP",
"pageid": 0,
"logpage": 56,
"params": {},
"type": "delete",
"action": "delete",
"user": "Carli",
"timestamp": "2024-11-20T18:12:04Z",
"comment": "content was: \"[[File:Ports.svg|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 \"[[Special:Contributions/Carli|Carli]]\" ([[User talk:Carli|talk]])"
},
{
"logid": 106,
"ns": 0,
"title": "Deployment",
"pageid": 62,
"logpage": 62,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2024-11-19T18:10:48Z",
"comment": "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...\""
},
{
"logid": 105,
"ns": 6,
"title": "File:Ports.svg",
"pageid": 57,
"logpage": 57,
"params": {
"count": {
"revisions": 1,
"files": 1
}
},
"type": "delete",
"action": "restore",
"user": "Carli",
"timestamp": "2024-10-31T10:36:16Z",
"comment": ""
},
{
"logid": 104,
"ns": 6,
"title": "File:Https---www.memcp.org-images-0-03-Webapps with MemCP.svg",
"pageid": 0,
"logpage": 61,
"params": {},
"type": "delete",
"action": "delete",
"user": "Carli",
"timestamp": "2024-10-31T10:34:22Z",
"comment": ""
},
{
"logid": 103,
"ns": 6,
"title": "File:Https---www.memcp.org-images-0-03-Webapps with MemCP.svg",
"pageid": 0,
"logpage": 61,
"params": {},
"type": "create",
"action": "create",
"user": "Carli",
"timestamp": "2024-10-31T10:31:37Z",
"comment": ""
}
]
}
}