User contributions for Carli
Jump to navigation
Jump to search
20 May 2024
- 14:0314:03, 20 May 2024 diff hist +131 Database Tools compatibility with MemCP No edit summary Tag: Visual edit
- 14:0214: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
- 14:0114:01, 20 May 2024 diff hist +19 Main Page →Getting Started Tag: Visual edit
- 13:2513:25, 20 May 2024 diff hist +2,363 Data Auto Sharding and Auto Indexing →Auto-Indexing current Tag: Visual edit
- 13:0413: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
- 13:0213:02, 20 May 2024 diff hist +984 Scan No edit summary Tag: Visual edit
- 12:5412: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
- 12:5012:50, 20 May 2024 diff hist +292 Settings No edit summary current Tag: Visual edit
- 12:4112:41, 20 May 2024 diff hist +171 Advanced SQL Tutorial →Atomic Counters through Unique Key Checks current Tag: Visual edit
- 12:4112:41, 20 May 2024 diff hist +40 N Data Auto Sharding and Auto Indexing Created page with "== Auto-Indexing == == Auto-Sharding ==" Tag: Visual edit
- 11:5511: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
- 11:4511:45, 20 May 2024 diff hist +28 Main Page →SQL Frontend Tag: Visual edit
19 May 2024
- 21:2721:27, 19 May 2024 diff hist +17 Supported SQL →Expressions current Tag: Visual edit
- 17:2617:26, 19 May 2024 diff hist +74 Supported SQL No edit summary Tag: Visual edit
- 16:2116:21, 19 May 2024 diff hist +13 Main Page →Features Tags: Reverted Visual edit
- 16:2016:20, 19 May 2024 diff hist +32 Main Page No edit summary Tag: Visual edit: Switched
- 15:4615:46, 19 May 2024 diff hist 0 Main Page →Custom Frontends Tag: Visual edit
- 15:4615: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
- 15:4615: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
- 15:4615:46, 19 May 2024 diff hist +38 Main Page →Custom Frontends Tag: Visual edit
- 15:4415: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
- 11:0811: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
- 10:4910:49, 19 May 2024 diff hist +137 SQL over REST No edit summary Tag: Visual edit
- 10:4710: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
- 10:4210: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
- 10:2310: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
- 10:1610:16, 19 May 2024 diff hist +20 Main Page →SQL Frontend Tag: Visual edit
- 10:0610:06, 19 May 2024 diff hist +102 Current Status and Open Issues No edit summary Tag: Visual edit
- 10:0410: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
- 10:0410: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
- 10:0410:04, 19 May 2024 diff hist −31 Main Page →Introduction Tag: Visual edit
- 10:0210:02, 19 May 2024 diff hist +82 Main Page →Navigation Tag: Visual edit
18 May 2024
- 22:4122:41, 18 May 2024 diff hist +1,950 Hardware Requirements →Micro-Benchmark current Tag: Visual edit
- 21:5321:53, 18 May 2024 diff hist +31 Main Page →Introduction Tag: Visual edit
- 18:4118:41, 18 May 2024 diff hist +4,012 Hardware Requirements →Running on Raspberry Pi Tag: Visual edit
- 18:3118:31, 18 May 2024 diff hist +841 Hardware Requirements No edit summary Tag: Visual edit
- 13:5813:58, 18 May 2024 diff hist +88 Integer Compression →See also current Tag: Visual edit
17 May 2024
- 23:0723: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
- 23:0323:03, 17 May 2024 diff hist +31 Settings No edit summary Tag: Visual edit
- 23:0223: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
- 22:5822:58, 17 May 2024 diff hist +97 Main Page →Navigation Tag: Visual edit
- 22:5122:51, 17 May 2024 diff hist +3,585 Integer Compression No edit summary Tag: Visual edit
- 22:4922:49, 17 May 2024 diff hist +40 N Temporary Columns Carli moved page Temporary Columns to Temporary Computed Columns current Tag: New redirect
- 22:4922:49, 17 May 2024 diff hist 0 m Temporary Computed Columns Carli moved page Temporary Columns to Temporary Computed Columns current
- 22:4822:48, 17 May 2024 diff hist +2,999 N Temporary Computed Columns Created page with "Most (or better: all) RDBMS know the concept of so-called „temporary tables“. These tables act as a buffer when complex computations or joins are made and the result has to be sorted afterwards. Temporary tables are also a big loss of performance in daily workloads: Let’s say a table consists of 1,000,000 items and you display them with ORDER BY … LIMIT 100. Because auf some complex join, the 1,000,000 items spanning sorted temptable has to be rendered first and..." Tag: Visual edit
- 22:4622:46, 17 May 2024 diff hist +89 Main Page →Internals Tag: Visual edit
- 22:4422:44, 17 May 2024 diff hist −12 In-Memory Compression, Columnar Compression Techniques No edit summary current Tag: Visual edit
- 22:4322:43, 17 May 2024 diff hist +1,232 N Integer Compression Created page with "Traditional Database Management Systems use fixed width integers of 32 or 64 bit that are administered by the database operator. MemCP however uses a different approach: according to a data analysis pass, we detect the maximum bit width of an integer to be encoded into our database. This is done by: * finding the smallest integer in a shard * finding the highest integer * <code>offset = smallest</code> * <code>bitwidth = ⌈ld (highest - smallest)⌉</code> * allocate..." Tag: Visual edit
- 22:3222:32, 17 May 2024 diff hist 0 In-Memory Compression, Columnar Compression Techniques No edit summary Tag: Visual edit
- 22:3122:31, 17 May 2024 diff hist +332 In-Memory Compression, Columnar Compression Techniques No edit summary Tag: Visual edit