Skip to content

Instantly share code, notes, and snippets.

View nmreadelf's full-sized avatar
🛠️
Coding

nmreadelf nmreadelf

🛠️
Coding
  • Beijing
  • 02:33 (UTC +08:00)
View GitHub Profile
@nmreadelf
nmreadelf / a.ahk
Created August 19, 2024 05:48
take lc
^F7::
{
; open shop
MouseMove 355, 44
MouseClick "left"
Sleep 50
; choose consumables in shop
MouseMove 562, 588
MouseClick "left"
@nmreadelf
nmreadelf / c6a.4xlarge
Last active November 17, 2023 07:59
chdb 0.16.0 rc2
[0.14784930900009385,0.01985562499999105,0.021213920000036524],
[0.23510076200000185,0.06982731300013256,0.06856002199992872],
[0.2806472989998383,0.10366240700000162,0.10361096500014355],
[0.4541343600001255,0.10390106999989257,0.10059215999990556],
[0.6548878610001339,0.45662324699992496,0.44750324799997543],
[0.9521819659998982,0.6404522270001962,0.6559423100000004],
[0.19805788999997276,0.08715895099999216,0.0858150569999907],
[0.19715853299999253,0.07409634200007531,0.07549481599994579],
[0.8598950299999615,0.6492269000000306,0.6434426030000395],
[1.4808940620000612,0.7829620970001088,0.7904872159999741],
@nmreadelf
nmreadelf / libchdb_cmd.sh
Created October 10, 2023 06:38
libchdb static
/usr/bin/clang++-15 --target=x86_64-linux-gnu --sysroot=/home/kongsys/repo/chdb/cmake/linux/../../contrib/sysroot/linux-x86_64/x86_64-linux-gnu/libc --gcc-toolchain=/home/kongsys/repo/chdb/cmake/linux/../../contrib/sysroot/linux-x86_64 -std=c++20 -fdiagnostics-color=always -fsized-deallocation -pipe -mssse3 -msse4.1 -msse4.2 -mpclmul -mpopcnt -mavx -mavx2 -fasynchronous-unwind-tables -ffile-prefix-map=/home/kongsys/repo/chdb=. -falign-functions=32 -mbranches-within-32B-boundaries -fPIC -fdiagnostics-absolute-paths -fstrict-vtable-pointers -DUSE_JEMALLOC=1 -Wl,-wrap,malloc -Wl,-wrap,valloc -Wl,-wrap,pvalloc -Wl,-wrap,calloc -Wl,-wrap,realloc -Wl,-wrap,memalign -Wl,-wrap,aligned_alloc -Wl,-wrap,posix_memalign -Wl,-wrap,free -DJEMALLOC_NO_RENAME=1 -DARROW_JEMALLOC=1 -Wall -Wextra -Wframe-larger-than=65536 -Weverything -Wpedantic -Wno-zero-length-array -Wno-c++98-compat-pedantic -Wno-c++98-compat -Wno-c++20-compat -Wno-sign-conversion -Wno-implicit-int-conversion -Wno-implicit-int-float-conversion -Wno-ctad-maybe
@nmreadelf
nmreadelf / c6a.4xlarge 1st
Last active July 25, 2023 06:33
chdb 0.11.4 2023-07-25
[0.24481195399999933,0.06919670200001349,0.06896518599999979],
[0.20465310199999465,0.060390686999994614,0.059956255999992436],
[0.2615953950000005,0.09735762900000111,0.09487622900000758],
[0.46551409699999624,0.09551590499998497,0.09289820099999702],
[0.7163985020000041,0.4652608510000107,0.46971446099999525],
[0.9932759190000127,0.7069003789999897,0.7012991210000052],
[0.17119048099999645,0.07387886199998661,0.07491920699999355],
[0.22577525500000206,0.06687168899998142,0.06752787499999613],
[0.8824369170000068,0.6579617419999977,0.6513440680000144],
[1.486658202000001,0.805362955999982,0.8235251099999914],
@nmreadelf
nmreadelf / c6a.4xlarge 2nd
Last active July 23, 2023 14:46
chdb 0.11.3 2023-07-23
[0.27622489099996983,0.06923746099994332,0.07005147600000328],
[0.18853068999999323,0.061215217000039956,0.06051315600007001],
[0.32840816899999936,0.0968581089999816,0.09454309000000194],
[0.49257302499995603,0.09417704299994512,0.09482075400001122],
[0.6442534400000568,0.45799368000007235,0.45034074800003054],
[1.1094209359999923,0.7445322300000043,0.7522552340000175],
[0.22465422000004764,0.07445777899999939,0.07696645299995453],
[0.18247364399996968,0.06625126599999476,0.06493597199994383],
[0.861058072999981,0.6518278120000787,0.6632243220000191],
[1.4186852180000642,0.800168527999972,0.8009721010000703],
@nmreadelf
nmreadelf / c6a.4xlarge
Last active July 23, 2023 08:12
chdb 0.11.2
[0.18604542899998933,0.06962641699999494,0.06824182000002565],
[0.14916791100000637,0.06132458399997631,0.05951455799998939],
[0.2608729639999865,0.0958906479999655,0.09617753499998116],
[0.40878004000001056,0.09374836000000641,0.09378371100001459],
[0.6718334320000281,0.4345236620000037,0.4334162419999643],
[1.002973752999992,0.7015915819999918,0.7080588069999862],
[0.17497927499999832,0.0756155509999985,0.07616734799995584],
[0.1498642690000338,0.06664470100002973,0.06627480200000946],
[0.8478573819999156,0.6415576590000001,0.6571600359999366],
[1.4339677990000155,0.8019762860000128,0.7825285239999857],
@nmreadelf
nmreadelf / error.log
Created July 17, 2023 07:58
py3.9.6 chdb==0.11.0 os=debian12.64bit
2023.07.17 15:57:25.466294 [ 154640 ] {} <Debug> Application: Working directory created: /tmp/clickhouse-local-154588-1689580645-13439769555555602661
Setting up /tmp/clickhouse-local-154588-1689580645-13439769555555602661/tmp/ to store temporary data in it
Added users.xml access storage 'users.xml', path:
65432cd2-c681-425d-a79b-178571bfec12 Authenticating user 'default' from 127.0.0.1:0
65432cd2-c681-425d-a79b-178571bfec12 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
65432cd2-c681-425d-a79b-178571bfec12 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.*
List of all grants including implicit: GRANT SHOW, SELECT, INSER
@nmreadelf
nmreadelf / lmdb.tcl
Created May 11, 2023 02:08 — forked from antirez/lmdb.tcl
LMDB -- First version of Redis written in Tcl
# LVDB - LLOOGG Memory DB
# Copyriht (C) 2009 Salvatore Sanfilippo <[email protected]>
# All Rights Reserved
# TODO
# - cron with cleanup of timedout clients, automatic dump
# - the dump should use array startsearch to write it line by line
# and may just use gets to read element by element and load the whole state.
# - 'help','stopserver','saveandstopserver','save','load','reset','keys' commands.
# - ttl with milliseconds resolution 'ttl a 1000'. Check ttl in dump!
@nmreadelf
nmreadelf / 4x origin
Last active May 5, 2023 13:57
2023-05-05 chdb 0.7.0
SELECT COUNT(*) FROM file("hits_*.parquet", Parquet);
0.4429148039999973
0.05523164400000269
0.05387431600001946
SELECT COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE AdvEngineID <> 0;
0.4565690250000216
0.06102334700000256
0.0607522119999544
@nmreadelf
nmreadelf / 0.4.0
Last active April 23, 2023 05:49
chdb 20230523 c6 4x indepen disk 500 gb
[0.4361737529999914,0.05658163800001148,0.056433019999985845],
[0.45631013700000267,0.06661815199998955,0.06499360399999432],
[1.2878869360000067,0.12046150599996963,0.12141279399997984],
[1.0351253719999818,0.19584039699998357,0.19377196099998173],
[2.000329340999997,1.3100056389999963,1.3103087160000086],
[1.8184413650000124,0.9605992319999928,0.9637660029999893],
[0.4596347169999717,0.0655916599999955,0.06513699300001008],
[0.45521096900000657,0.07589728199997126,0.07560694400001466],
[1.4177663510000116,0.7329907230000003,0.7416720749999968],
[3.5959058509999977,0.901890944999991,0.891994880000027],