User contributions for Carli
Jump to navigation
Jump to search
28 May 2024
- 06:0706:07, 28 May 2024 diff hist +272 Scan No edit summary current Tag: Visual edit
27 May 2024
- 08:1908:19, 27 May 2024 diff hist −61 Current Status and Open Issues →Scheme language Tag: Visual edit
- 07:0207:02, 27 May 2024 diff hist +92 Contributing No edit summary current Tag: Visual edit
26 May 2024
- 13:2013:20, 26 May 2024 diff hist +255 N Advanced Graph Querying Created page with "== Property Paths == see also: https://en.wikibooks.org/wiki/SPARQL/Property_paths TODO for MemCP: * property/propertypath * propertypath*, propertypath+ (mark&sweep, then iterate over the results) * property? * (propertypath) * ^property (inverse path)" current Tag: Visual edit
- 12:4712:47, 26 May 2024 diff hist +30 Main Page →RDF Frontend Tag: Visual edit
20 May 2024
- 13:1213:12, 20 May 2024 diff hist +222 N Contributing Created page with "Here's how you can contribute: * Go to https://github.com/launix-de/memcp * Build From Source * Add unit tests * Implement more SQL Syntax * Find and report Bugs * Add Passes to the Optimizer" Tag: Visual edit
- 13:0413:04, 20 May 2024 diff hist +119 Database Tools compatibility with MemCP →VSCode SQLTools Tag: Visual edit
- 13:0313:03, 20 May 2024 diff hist +131 Database Tools compatibility with MemCP No edit summary Tag: Visual edit
- 13:0213:02, 20 May 2024 diff hist +126 N Database Tools compatibility with MemCP Created page with "== PHPMyAdmin == no support yet. Read more under: Contributing == DBeaver == Support for: * List Databases * List Tables" Tag: Visual edit
- 13:0113:01, 20 May 2024 diff hist +19 Main Page →Getting Started Tag: Visual edit
- 12:2512:25, 20 May 2024 diff hist +2,363 Data Auto Sharding and Auto Indexing →Auto-Indexing current Tag: Visual edit
- 12:0412:04, 20 May 2024 diff hist +222 Scan →(scan_order schema table filterColumn filter sortcols sortdirs offset limit mapColumns map reduce neutral isOuter) Tag: Visual edit
- 12:0212:02, 20 May 2024 diff hist +984 Scan No edit summary Tag: Visual edit
- 11:5411:54, 20 May 2024 diff hist +4,903 N Scan Created page with "Scan is the most important function in whole MemCP. It implements an optimized, indexed and parallelized <code>for</code> loop over items in a table. There are two variants of scan: <code>scan</code> and <code>scan_order</code>. == (scan schema table filterColumns filter mapColumns map reduce neutral reduce2 isOuter) == Help for: scan === does an unordered parallel filter-map-reduce pass on a single table and returns the reduced result Allowed nø of parameters..." Tag: Visual edit
- 11:5011:50, 20 May 2024 diff hist +292 Settings No edit summary Tag: Visual edit
- 11:4111:41, 20 May 2024 diff hist +171 Advanced SQL Tutorial →Atomic Counters through Unique Key Checks current Tag: Visual edit
- 11:4111:41, 20 May 2024 diff hist +40 N Data Auto Sharding and Auto Indexing Created page with "== Auto-Indexing == == Auto-Sharding ==" Tag: Visual edit
- 10:5510:55, 20 May 2024 diff hist +661 N Advanced SQL Tutorial Created page with "== Atomic Counters through Unique Key Checks == Imagine the following table: CREATE TABLE u(id INT PRIMARY KEY, cnt INT); INSERT INTO u VALUES (1, 2), (2, 4); SELECT * FROM u; +------+------+ | id | cnt | +------+------+ | 1 | 2 | | 2 | 4 | +------+------+ '''3 rows in set (0,001 sec)''' If you want to add to <code>cnt</code> whenever an event occurs, add a unique key over <code>id</code> and do the following: INSERT INTO u VALUES (2, 1) O..." Tag: Visual edit
- 10:4510:45, 20 May 2024 diff hist +28 Main Page →SQL Frontend Tag: Visual edit
19 May 2024
- 20:2720:27, 19 May 2024 diff hist +17 Supported SQL →Expressions current Tag: Visual edit
- 16:2616:26, 19 May 2024 diff hist +74 Supported SQL No edit summary Tag: Visual edit
- 15:2115:21, 19 May 2024 diff hist +13 Main Page →Features Tags: Reverted Visual edit
- 15:2015:20, 19 May 2024 diff hist +32 Main Page No edit summary Tag: Visual edit: Switched
- 14:4614:46, 19 May 2024 diff hist 0 Main Page →Custom Frontends Tag: Visual edit
- 14:4614:46, 19 May 2024 diff hist +51 N In-Database WebApps Carli moved page In-Database WebApps to In-Database WebApps and REST Services current Tag: New redirect
- 14:4614:46, 19 May 2024 diff hist 0 m In-Database WebApps and REST Services Carli moved page In-Database WebApps to In-Database WebApps and REST Services
- 14:4614:46, 19 May 2024 diff hist +38 Main Page →Custom Frontends Tag: Visual edit
- 14:4414:44, 19 May 2024 diff hist 0 In-Database WebApps and REST Services →Including SQL or RDF queries in your custom REST endpoint Tag: Visual edit
- 10:0810:08, 19 May 2024 diff hist +2,689 N In-Database WebApps and REST Services Created page with "In-Database WebApps are a huge game changer in REST API performance since the web app runs in the same context as the == REST Endpoint setup == You basically set up a REST endpoint by overwriting the <code>http_handler</code> variable in the global scope. Best practice is here to overload http_handler, store the old handler in <code>old_handler</code> and cascade the router with a prefix: (define http_handler (begin (set old_handler (coalesce http_handler han..." Tag: Visual edit
- 09:4909:49, 19 May 2024 diff hist +137 SQL over REST No edit summary Tag: Visual edit
- 09:4709:47, 19 May 2024 diff hist +567 N SQL over REST Created page with "There are two methods to do SQL over REST: a) GET method: <code>curl <nowiki>http://root:admin@localhost:4321/sql/</nowiki>[SCHEMA]/[SQL_QUERY]</code> b) POST method: <code>curl -X POST -d '[SQL_QUERY]' <nowiki>http://root:admin@localhost:4321/sql/</nowiki>[SCHEMA]</code> == JSONL results == The result is a <code>jsonl</code> document containing the result lines: curl -X POST -d 'select a, sum(b) as sum_b from a group by a' <nowiki>http://root:admin@localhost:4321/sq..." Tag: Visual edit
- 09:4209:42, 19 May 2024 diff hist +374 N Introduction to RDF Created page with "RDF is the '''Resource Description Format'''. It describes all data in ''Triple Format'': {| class="wikitable" |+ !Subject !Predicate !Object |- |item:1 |a |foaf:Person |- |item:1 |foaf:name |Klaus |- |item:1 |foaf:mbox |klaus@example.com |- |item:1 |foaf:knows |item:2 |- |item:2 |a |foaf:Person |- |item:2 |foaf:name |Dieter |} See also: https://github.com/launix-de/rdfop" current Tag: Visual edit
- 09:2309:23, 19 May 2024 diff hist +755 N Supported SQL Created page with "The following SQL statements are supported: * SELECT FROM GROUP BY HAVING ORDER BY LIMIT OFFSET * UPDATE SET WHERE * DELETE FROM WHERE * INSERT INTO VALUES * CREATE TABLE * ALTER TABLE * CREATE DATABASE * CREATE USER * ALTER USER * SHOW DATABASES * SHOW TABLES * SHOW TABLE STATUS * SHOW VARIABLES * SET NAMES (no function) * DROP DATABASE * DROP TABLE * SET SESSION * LOCK TABLES (no function) * UNLOCK TABLES (no function) The following functions are supported: * CASE..." Tag: Visual edit
- 09:1609:16, 19 May 2024 diff hist +20 Main Page →SQL Frontend Tag: Visual edit
- 09:0609:06, 19 May 2024 diff hist +102 Current Status and Open Issues No edit summary Tag: Visual edit
- 09:0409:04, 19 May 2024 diff hist +44 N Current Status and open issues Carli moved page Current Status and open issues to Current Status and Open Issues current Tag: New redirect
- 09:0409:04, 19 May 2024 diff hist 0 m Current Status and Open Issues Carli moved page Current Status and open issues to Current Status and Open Issues
- 09:0409:04, 19 May 2024 diff hist −31 Main Page →Introduction Tag: Visual edit
- 09:0209:02, 19 May 2024 diff hist +82 Main Page →Navigation Tag: Visual edit
18 May 2024
- 21:4121:41, 18 May 2024 diff hist +1,950 Hardware Requirements →Micro-Benchmark current Tag: Visual edit
- 20:5320:53, 18 May 2024 diff hist +31 Main Page →Introduction Tag: Visual edit
- 17:4117:41, 18 May 2024 diff hist +4,012 Hardware Requirements →Running on Raspberry Pi Tag: Visual edit
- 17:3117:31, 18 May 2024 diff hist +841 Hardware Requirements No edit summary Tag: Visual edit
- 12:5812:58, 18 May 2024 diff hist +88 Integer Compression →See also current Tag: Visual edit
17 May 2024
- 22:0722:07, 17 May 2024 diff hist +419 N Process Hibernation Created page with "MemCP is a In-Memory database. In case you use the <code>memory</code> engine, there is no data stored on disk. <code>criu</code> is an OpenSource project to hibernate processes on linux on disk and restore them later (see https://criu.org/Main_Page). You can hibernate the memcp process with sudo criu dump -t [PID] -j -D [DUMP_DIRECTORY] And reactivate the process with: sudo criu restore -j -D [DUMP_DIRECTORY]" current Tag: Visual edit
- 22:0322:03, 17 May 2024 diff hist +31 Settings No edit summary Tag: Visual edit
- 22:0222:02, 17 May 2024 diff hist +734 N Settings Created page with "Settings are changed by: (settings "key" "value") The following settings are available: * <code>"Backtrace"</code>: <code>true</code> or <code>false</code> whether to print backtraces from Scheme. Using true decreases the performance by ~10% but gives you better debugging capabilities. * <code>"PartitionMaxDimensions"</code>: number from 0 to 10 how many partitioning dimensions are allowed at max. 0 means, don't partition shards for values (use it to workaround bugs),..." Tag: Visual edit
- 21:5821:58, 17 May 2024 diff hist +97 Main Page →Navigation Tag: Visual edit
- 21:5121:51, 17 May 2024 diff hist +3,585 Integer Compression No edit summary Tag: Visual edit
- 21:4921:49, 17 May 2024 diff hist +40 N Temporary Columns Carli moved page Temporary Columns to Temporary Computed Columns current Tag: New redirect