{"id":111366,"date":"2021-06-13T15:54:40","date_gmt":"2021-06-13T15:54:40","guid":{"rendered":"http:\/\/www.timestored.com\/b\/?p=111366"},"modified":"2021-06-13T15:54:40","modified_gmt":"2021-06-13T15:54:40","slug":"kdb-2018-feature-wishlist","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/kdb-2018-feature-wishlist\/","title":{"rendered":"kdb &#8211; Feature Wishlist"},"content":{"rendered":"<p>Features I want:<\/p>\n<ol>\n<li><strong><a href=\"https:\/\/www.timestored.com\/b\/open-source-kdb\/\">Open Sourced kdb<\/a><\/strong> (a person can dream). As one of the top 5 tools in my programmers toolbox it&#8217;s frustrating that kdb is closed source. I can&#8217;t use the tool everywhere and at any time the price can be increased.<\/li>\n<li><strong>Increase ease of Use<\/strong>\n<ul>\n<li>Block user queries that will obviously kill the database (select from quote).<\/li>\n<li>Do not quit out when a query takes too much memory (-w exceeded or all RAM\/swap on box gone.). Sensibly return an error and keep going.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Faster Speed<\/strong> &#8211; Admittedly this isn&#8217;t a strong requirement for any work I do but it irritates me as a programmer to know some easy 10x speed improvements are not being used.\n<ul>\n<li>Perform warmup queries and counts on startup automatically to get most recent data into memory.<\/li>\n<li>Replace the kdb\/q code with CPU vector functions<\/li>\n<li><strong>Parse the user query and optimize it.<\/strong> If a user sends &#8220;select from trade where a=1,b=2,c=3,d=3&#8221; automatically order the evaluation of the where clause to at leaast prioritize those with attributes.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Marketing <\/strong>&#8211; I didn&#8217;t think this would be on my wishlist&#8230;but if you can market kdb better I would love to stop having people suggest I use mongodb\/hadoop\/latestFad when kdb is a great fit for the problem at hand.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Features I want: Open Sourced kdb (a person can dream). As one of the top 5 tools in my programmers toolbox it&#8217;s frustrating that kdb is closed source. I can&#8217;t use the tool everywhere and at any time the price can be increased. Increase ease of Use Block user queries that will obviously kill the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111366"}],"collection":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=111366"}],"version-history":[{"count":7,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111366\/revisions"}],"predecessor-version":[{"id":111561,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111366\/revisions\/111561"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=111366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=111366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=111366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}