The latest articles on DEV Community by Ragekill3377 (@ragekill3377). https://dev.to/ragekill3377 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4024365%2F5447bdec-9393-42b9-b0ee-6299ac86756e.jpg https://dev.to/ragekill3377 en Ragekill3377 Sat, 11 Jul 2026 03:07:19 +0000 https://dev.to/ragekill3377/-770 https://dev.to/ragekill3377/-770 <div class="ltag__link--embedded"> <div class="crayons-story "> <a href="https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b" class="crayons-story__hidden-navigation-link">Really fast columnar analytics engine</a> <div class="crayons-story__body crayons-story__body-full_post"> <div class="crayons-story__top"> <div class="crayons-story__meta"> <div class="crayons-story__author-pic"> <a href="/ragekill3377" class="crayons-avatar crayons-avatar--l "> <img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4024365%2F5447bdec-9393-42b9-b0ee-6299ac86756e.jpg" alt="ragekill3377 profile" class="crayons-avatar__image"> </a> </div> <div> <div> <a href="/ragekill3377" class="crayons-story__secondary fw-medium m:hidden"> Ragekill3377 </a> <div class="profile-preview-card relative mb-4 s:mb-0 fw-medium hidden m:inline-block"> Ragekill3377 <div id="story-author-preview-content-4115403" class="profile-preview-card__content crayons-dropdown branded-7 p-4 pt-0"> <div class="gap-4 grid"> <div class="-mt-4"> <a href="/ragekill3377" class="flex"> <span class="crayons-avatar crayons-avatar--xl mr-2 shrink-0"> <img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4024365%2F5447bdec-9393-42b9-b0ee-6299ac86756e.jpg" class="crayons-avatar__image" alt=""> </span> <span class="crayons-link crayons-subtitle-2 mt-5">Ragekill3377</span> </a> </div> <div class="print-hidden"> Follow </div> <div class="author-preview-metadata-container"></div> </div> </div> </div> </div> <a href="https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b" class="crayons-story__tertiary fs-xs"><time>Jul 10</time><span class="time-ago-indicator-initial-placeholder"></span></a> </div> </div> </div> <div class="crayons-story__indention"> <h2 class="crayons-story__title crayons-story__title-full_post"> <a href="https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b" id="article-link-4115403"> Really fast columnar analytics engine </a> </h2> <div class="crayons-story__tags"> <a class="crayons-tag crayons-tag--monochrome " href="/t/database"><span class="crayons-tag__prefix">#</span>database</a> <a class="crayons-tag crayons-tag--monochrome " href="/t/vectordatabase"><span class="crayons-tag__prefix">#</span>vectordatabase</a> <a class="crayons-tag crayons-tag--monochrome " href="/t/analytics"><span class="crayons-tag__prefix">#</span>analytics</a> <a class="crayons-tag crayons-tag--monochrome " href="/t/bytecode"><span class="crayons-tag__prefix">#</span>bytecode</a> </div> <div class="crayons-story__bottom"> <div class="crayons-story__details"> <a href="https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left"> <div class="multiple_reactions_aggregate"> <span class="multiple_reactions_icons_container"> <span class="crayons_icon_container"> <img src="https://assets.dev.to/assets/sparkle-heart-5f9bee3767e18deb1bb725290cb151c25234768a0e9a2bd39370c382d02920cf.svg" width="18" height="18"> </span> </span> <span class="aggregate_reactions_counter">1<span class="hidden s:inline">&nbsp;reaction</span></span> </div> </a> <a href="https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b#comments" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left flex items-center"> 2<span class="hidden s:inline">&nbsp;comments</span> </a> </div> <div class="crayons-story__save"> <small class="crayons-story__tertiary fs-xs mr-2"> 1 min read </small> <span class="bm-initial crayons-icon c-btn__icon"> </span> <span class="bm-success crayons-icon c-btn__icon"> </span> </div> </div> </div> </div> </div> </div> Ragekill3377 Fri, 10 Jul 2026 17:32:56 +0000 https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b https://dev.to/ragekill3377/really-fast-columnar-analytics-engine-1j4b <p>it’s not a database, just a bytecode vm engine. has 2 modes: interpreter and JIT. I managed to get the JIT to run at 1.4-1.6 Billion elements per second processing on an intel core i3 4th gen which I think is pretty good. It depends on the cpu. I worked really hard on the JIT and currently it’s only x86_64 right now. to test it I benchmarked it against DuckDB on nyc taxi data. You can view it on the GitHub link. :)<a href="https://github.com/Ragekill3377/Voxel" rel="noopener noreferrer">VoxelVM</a></p> database vectordatabase analytics bytecode