Newest at the top
| 2025-11-13 13:57:01 +0100 | <kuribas`> | [exa]: So you have three maps in parallel, then you intersect? |
| 2025-11-13 13:57:00 +0100 | <merijn> | something, something, lattice theory |
| 2025-11-13 13:55:38 +0100 | <[exa]> | (PS. skiplists are magical) |
| 2025-11-13 13:54:10 +0100 | <kuribas`> | hmm, interesting... |
| 2025-11-13 13:53:47 +0100 | <[exa]> | as in, in the 3-level map model, querying for (whatever, "bar", 3) requires traversing the whole first map; with inversion this is free |
| 2025-11-13 13:52:58 +0100 | <[exa]> | lucene version: make occurence inverted indexes for all key parts that you have, select Very Very Quickly by intersecting the skiplists. (That also gives you infinite wildcard queries for free.) |
| 2025-11-13 13:51:42 +0100 | <kuribas`> | True, putting * in the dictionary is less efficient. |
| 2025-11-13 13:51:07 +0100 | <[exa]> | kuribas`: can be highest; any predictable position is OK |
| 2025-11-13 13:50:51 +0100 | <kuribas`> | [exa]: why lowest? |
| 2025-11-13 13:49:51 +0100 | <kuribas`> | Maybe I can put an index at "a", and "b", since "c" (and d...) are sparse. |
| 2025-11-13 13:49:34 +0100 | <[exa]> | tree version: make * the lowest-ordering item, first select exactly, if that fails select minimum bound of ("foo","haha",whatever) to see if the wildcard is on the 3rd position (you can re-use the partial failed select!), then of ("foo", whatever, whatever) to see if it's on the 2nd position, ... |
| 2025-11-13 13:48:48 +0100 | CiaoSen | (~Jura@2a02:8071:64e1:da0:5a47:caff:fe78:33db) (Ping timeout: 256 seconds) |
| 2025-11-13 13:47:56 +0100 | <kuribas`> | yeah |
| 2025-11-13 13:47:17 +0100 | <[exa]> | ok I see, so whenever the `a` is not matched you try also the wildcard at that level, which also gives ordering to wildcards |
| 2025-11-13 13:46:24 +0100 | <kuribas`> | [exa]: no, something we use for configuration. |
| 2025-11-13 13:46:07 +0100 | <kuribas`> | [exa]: I have (HashMap (Wild a) (HashMap (Wild b) (HashMap (Wild c) val))) |
| 2025-11-13 13:45:57 +0100 | <lucabtz> | the wildcard is like a fallbacl |
| 2025-11-13 13:45:55 +0100 | <merijn> | kuribas`: Also, note that you can actually have SQLite run arbitrary custom functions mid query |
| 2025-11-13 13:45:51 +0100 | <[exa]> | kuribas`: is this RDF by the way? |
| 2025-11-13 13:45:44 +0100 | <lucabtz> | ah i see okay |
| 2025-11-13 13:45:34 +0100 | <merijn> | kuribas`: sorry, got distracted so missed half the context except the one question |
| 2025-11-13 13:45:19 +0100 | <kuribas`> | lucabtz: if you insert ((*, *, *) -> val), every lookup will succeed, but val only if everything else fails. |
| 2025-11-13 13:44:56 +0100 | merijn | (~merijn@77.242.116.146) merijn |
| 2025-11-13 13:44:28 +0100 | <[exa]> | (no other idea on how to map it to hashmaps) |
| 2025-11-13 13:44:13 +0100 | <lucabtz> | kuribas` so when setting say (*, *, *) you would modify the whole table? |
| 2025-11-13 13:43:59 +0100 | merijn | (~merijn@77.242.116.146) (Ping timeout: 256 seconds) |
| 2025-11-13 13:43:57 +0100 | <[exa]> | ah yes I meant that to get the result for ("foo","haha",3) you need to hash an dlookup the tuple as is, and then you need to hash and lookup (*, "haha", 3) and ("foo", *, 3), etc... |
| 2025-11-13 13:43:13 +0100 | <kuribas`> | each position can have a wildcard. |
| 2025-11-13 13:43:03 +0100 | <kuribas`> | [exa]: 3 |
| 2025-11-13 13:42:49 +0100 | <[exa]> | so your query algorithm basically checks 2 hash values for each position, right? |
| 2025-11-13 13:42:14 +0100 | <kuribas`> | but ordered by * last. So first the specific thing, only * if no specific thing exists. |
| 2025-11-13 13:41:39 +0100 | <kuribas`> | exactly |
| 2025-11-13 13:41:09 +0100 | <[exa]> | so these are keys that match all possible queries, as in, if you query for ("foo","haha",3) that thing with * is going to show up, right? |
| 2025-11-13 13:40:08 +0100 | <kuribas`> | [exa]: wildcard is only allowed when storing the keys, not when looking up. |
| 2025-11-13 13:39:22 +0100 | [exa] | confused |
| 2025-11-13 13:39:06 +0100 | <kuribas`> | [exa]: basically yes. Wildcard means match anything. |
| 2025-11-13 13:38:51 +0100 | merijn | (~merijn@77.242.116.146) merijn |
| 2025-11-13 13:38:35 +0100 | <[exa]> | so the * is essentially another constant? (I thought it's a query like "anything goes here") |
| 2025-11-13 13:37:56 +0100 | <kuribas`> | [exa]: I have "Hashable key => Hashable (Wild key)" |
| 2025-11-13 13:37:54 +0100 | <[exa]> | kuribas`: select everything with "foo" at position 1, everything with 3 at position 3, and intersect? |
| 2025-11-13 13:37:26 +0100 | <[exa]> | kuribas`: how do you evaluate a wildcard on the hashmaps btw |
| 2025-11-13 13:36:09 +0100 | <kuribas`> | Basically I have "data Wild a = Specific a | Wildcard", and map "Map (Wild key1, Wild key2, ...) val" |
| 2025-11-13 13:35:41 +0100 | <lucabtz> | [exa] yeah i was speaking about something distinct from multimap |
| 2025-11-13 13:35:28 +0100 | annamalai | (~annamalai@157.33.249.99) (Ping timeout: 255 seconds) |
| 2025-11-13 13:35:07 +0100 | qqe_ | (~qqq@185.54.21.203) (Quit: Lost terminal) |
| 2025-11-13 13:34:42 +0100 | __monty__ | (~toonn@user/toonn) toonn |
| 2025-11-13 13:34:20 +0100 | <kuribas`> | Storing * as NULL is a bit inelegant... |
| 2025-11-13 13:33:00 +0100 | deptype_ | (~deptype@2406:b400:3a:73c2:ffa7:a8a3:7599:8304) |
| 2025-11-13 13:32:39 +0100 | deptype_ | (~deptype@2406:b400:3a:73c2:4944:536a:6ac6:1483) (Remote host closed the connection) |
| 2025-11-13 13:32:32 +0100 | tromp | (~textual@2001:1c00:3487:1b00:7d:cf52:961a:9343) |