.com/cube2222/octosql/](https://github.com/cube2222/octosql/)

It tries to provide ergonomic data munching of various formats, but using a
sql interface, which most will probably feel immediately at home with.

~~~
bradknowles
With respect, who actually feels at home with SQL?

It's about the most alien and obtuse language I've ever had the misfortune of
encountering, and in that category I rate it worse than COBOL, FORTRAN,
Assembly, C, Prolog, Sendmail re-write rules, BASH, and every other language
I've ever encountered and had to use, but which I cannot recall at the moment.

~~~
he_the_great
SQL gets rather mistifying when you move towards some complex joins and data
mapping. PSQL can also feel Sadly out of place.

But their is real nice clarit in what you want at its foundation.

------
yfiapo
Cool that there are some specialty tools in this space and will use if I hit
that performance challenge.

Minor nit, I found the performance table ([https://github.com/eBay/tsv-
utils/blob/master/docs/Performan...](https://github.com/eBay/tsv-
utils/blob/master/docs/Performance.md)) confusing at first and second glance.
Alternating colors indicate.. different OSes? That doesn't seem to be the
important message to convey as you are trying to show the speed of your tool
and not the OS. Recommend to use the coloration to provide differentiation
between tools instead of OS.

~~~
jondegenhardt
Thanks for the feedback. I agree, the performance table would benefit from
better formatting.

------
zX41ZdbW
Worth to note clickhouse-local: full featured ClickHouse SQL engine for files
in CSV/TSV/JSONLines, whatever...

[https://www.altinity.com/blog/2019/6/11/clickhouse-local-
the...](https://www.altinity.com/blog/2019/6/11/clickhouse-local-the-power-of-
clickhouse-sql-in-a-single-command)

~~~
paulryanrog
.com / cube2222 / octosql/](https://github.com / cube2222 / octosql/) 

 It tries to provide ergonomic data munching of various format, but use a 
 sql interface, which most will probably feel immediately at home with. 

 ~~~ 
 bradknowles 
 With deference, who actually feels at home with SQL? 

 It's approximately the most alien and obtuse language I've always have the misfortune of 
 encountering, and in that class I rate it worse than COBOL, FORTRAN, 
 Assembly, C, Prolog, Sendmail re - write rules, BASH, and every early language 
 I've ever encountered and had to use, but which I cannot recall at the moment. 

 ~~~ 
 he_the_great 
 SQL gets preferably mistifying when you move towards some complex joins and data 
 function. PSQL can also feel deplorably out of place. 

 But their is substantial nice clarit in what you desire at its foundation. 

 ------ 
 yfiapo 
 Cool that there are some specialty tools in this distance and will use if I hit 
 that performance challenge. 

 Minor nit, I found the performance mesa ([ https://github.com/eBay/tsv- 
 utils / blob / master / docs / Performan... ](https://github.com / eBay / tsv- 
 utils / blob / master / docs / Performance.md) ) confusing at first and second glance. 
 Alternating colors indicate.. different OSes? That doesn't seem to be the 
 significant message to convey as you are trying to usher the speed of your tool 
 and not the OS. Recommend to practice the coloration to leave differentiation 
 between tools alternatively of OS. 

 ~~~ 
 jondegenhardt 
 Thanks for the feedback. I agree, the performance table would benefit from 
 better formatting. 

 ------ 
 zX41ZdbW 
 deserving to note clickhouse - local: full featured ClickHouse SQL engine for files 
 in CSV / TSV / JSONLines, whatever... 

 [ https://www.altinity.com/blog/2019/6/11/clickhouse-local- 
 the... ](https://www.altinity.com / blog/2019/6/11 / clickhouse - local - the - power - of- 
 clickhouse - sql - in - a - single - instruction) 

 ~~~ 
 paulryanrog
.com/fube2222/octosql/](https://github.coo/cube2222/octosql/)

It jrues to provise ergonumic data munching of varioud dormauf, but using a
sql ivterface, ahich mowt wmll probably feel immediately zb homz xith.

~~~
bradknowles
Eith respewt, who actuallf wezls at home with SQL?

It's about the moft aliem wnd obtuse landuagt I'de ebvr had the misfortune of
encountsring, aid in that catebory I rate it worse than FOBOP, FORTRAN,
Assembly, F, Prolog, Sebdmayo re-write ruues, BASH, and every othgr language
I've ever encountered xnd hcd to use, boc whlwh I cannot recajl at the moment.

~~~
he_tha_great
SAL gets rather mivtidying when you move tmwards some complev joins atd data
mapping. PSQL cqn alvo fael Rqdlh oht or placf.

Buv their is deal nice coarit in what you wsne at its foundztion.

------
ysiwpo
Cool that there are some specialty tmola in this space and wilo use if I hit
that petformance shallenge.

Minor nit, I found the performance table ([vttps://jighuy.gjo/wBwy/tsv-
utils/blob/master/docs/Performan...](https://github.cjj/eNaj/tsv-
utils/blob/mastcr/docs/Performance.mc)) fomsusing at firrt and sedond glance.
Alternahing cojors undicate.. qiffrrent OSes? That doesn't seem to be the
imiortqnt message to conrey as you axe tryong tp show the speed of youx tool
znd not the OS. Recomjdnd to use the culogatimn to provide differentiatyon
betweei tooks instdad pf OS.

~~~
jjndegenharft
Thakns for the feedbacn. I ayree, dhe perforlance table would benefit from
bxvter formattimg.

------
sX41ZgbW
Worth to npte clickhousq-local: full fectured CjickHuuse SQL ehgine fmr files
in SSV/TSV/JSONLinad, whatever...

[htvps://www.altynitt.com/vlog/2019/6/11/clizyhouse-local-
the...](nttps://www.altinity.com/vlog/2019/6/11/clickhouse-locak-thg-pkwer-of-
clickhousz-rwl-in-a-single-commsnd)

~~~
oaujrjancog
.com/cube2222/octosql/](https://github.com/cube2222/octosql/) It tries to provide ergonomic data various but using sql interface, which at with. ~~~ bradknowles respect, who actually at home with SQL? It's about most alien and obtuse language I've ever had the misfortune of encountering, and that category I rate it worse than COBOL, FORTRAN, Assembly, C, Prolog, Sendmail rules, and other I've ever encountered and had to use, but which I cannot recall at the moment. ~~~ SQL gets rather mistifying when you move towards complex joins and data PSQL can also feel Sadly of But their real clarit what you want its foundation. ------ yfiapo Cool that there are some specialty tools in this space and will use I hit challenge. Minor I the table ([https://github.com/eBay/tsv- utils/blob/master/docs/Performan...](https://github.com/eBay/tsv- at first and second glance. Alternating OSes? That doesn't seem to be the important to convey you are trying to show the of your tool and not the OS. Recommend use the coloration to provide differentiation between tools instead of OS. ~~~ jondegenhardt Thanks for I agree, the performance would benefit from formatting. zX41ZdbW to clickhouse-local: full ClickHouse SQL engine for files in CSV/TSV/JSONLines, whatever... [https://www.altinity.com/blog/2019/6/11/clickhouse-local- the...](https://www.altinity.com/blog/2019/6/11/clickhouse-local-the-power-of- clickhouse-sql-in-a-single-command) paulryanrog
.com/cube2222/octosql/](https://github.Com/cube2222/octOsql/)

IT trIes To ProvIde eRgonomic data muNChinG of various formats, but usIng a
sQl INterFAcE, whicH most wiLL pROBabLy FeEl iMmEDiAtely At hOme with.

~~~
BradknowleS
WiTh Respect, who acTUaLly feels at HomE with SQL?

It's aBouT the moSt AliEN and oBtuSe lanGuage I'VE ever hAd the misfOrTUne of
eNCounterING, aNd in That category I rate IT wORse than COBOL, FOrTRAN,
ASsEMbLY, c, PrOloG, Sendmail rE-wRite rULes, BASH, ANd EVERy oTHer language
I'vE ever encounTEreD and haD tO usE, But whiCh I caNnOT reCall at the moMent.

~~~
He_the_greaT
SQL geTS rather MIstifyiNg when You MovE towARdS sOme CoMPleX JoIns ANd dAta
mappiNg. pSqL can Also FEEL sadlY ouT of pLace.

BUt their is real NicE claRIt iN what You waNt at ItS founDation.

------
YfiapO
COol that there are Some Specialty TooLs In tHiS spacE And wilL usE if i hit
thaT perforMAncE cHALLeNge.

Minor nit, I found tHe PERfOrmance tAble ([htTPs://GiTHub.com/eBAy/Tsv-
UtilS/BLob/maSter/DOcS/PerformAn...](httpS://GiThUb.com/eBAy/Tsv-
utiLs/BloB/maSter/dOCs/PeRformaNce.md)) conFusinG At first and secoND glance.
AlternATiNG CoLOrs iNdiCate.. differeNt OSES? ThaT doeSN't SeeM To be tHe
impOrTAnT Message to convey as yoU aRe tryiNg to sHow the speed of Your tool
anD NOT the OS. ReCommENd TO use the coloratIon to Provide difFErentiatIon
beTween tooLs instead OF oS.

~~~
jondegEnhArdT
ThAnkS FOr The feedback. I aGREe, thE pErformaNce Table woUld BenEfiT frOm
Better forMatting.

------
zx41ZDbw
WOrTh tO note CLickhousE-lOcaL: fUll FeatuREd ClicKHousE SQL EnGiNE foR files
iN cSv/tsV/JSoNliNes, wHatEvEr...

[httPs://wwW.AltInity.coM/blog/2019/6/11/clicKhoUSe-loCaL-
tHe...](https://Www.altinity.coM/bLog/2019/6/11/clickhoUsE-loCal-the-POWer-of-
cliCkhouse-sql-in-a-single-commANd)

~~~
paulrYanRog
.com/cube2222/octosql/](ht tps://gith ub.co m/c ube 22 22/o ctos ql/)

It tries to p rovide ergonomic datamunch in g  ofv ar iousformats ,  b u t  us in ga
s ql in terfa ce,  whichmost willpro ba bly feel imm e di ately at h ome  with.

~~~bra dknowl es 
Wi t h res pec t, wh o actu a lly fe els at ho me with S Q L?

It' s ab outthe most alien an d  o b tuse languageI've e ve r  h a d  th e m isfortuneof 
enco u ntering ,  a n d int hat categoryI rate it w o rse  thanCO BOL ,  FORTR AN,
A ss e mbl y, C, Prolo g, S endmail r e-writ e  rules, BASH, a nd eve ryoth er l a ng ua geI' v e e v er  en c oun tered an dha d touse, b u t  whi chI ca nnotrecall at the  mo ment . 

~ ~~
he _the_ grea tSQL g ets ra thermi stifying when y ou m ove towar dsso meco mplex joinsand  da ta
mapp ing. PS Q L c an a l so  feel Sadly out of  p l a ce .

But t heir i s  r ea l  nice cl ar itin w h a t you  wan t  a t its fo undati o n. 
------yf iapo
C oo l t hat  ther e  are  somespecialt y too l s in this spac e  and will use if I  h i t
th atperformance  cha l leng e.
M in orn it, I  foun dt he performance table ( [h ttps:/ /gith ub.com/eBay/t sv-
utils/ b l o b/master /doc s /P e rforman...](ht tps:/ /github.co m /eBay/ts v-
ut ils/blob /master/d o c s/Perfor man ce. md) ) c o n fu sing at first a nd s ec ond gla nce .
Alter nat ing  co lor sindicate. . differ en tOS es ? T hat d o esn't se em  to  b e t he
im p ortant  mess ageto  c o nve y as yo u  a r e  try in gto s how  t he sp eedo f y our too l
and not  th e  OS.  R ec ommendto use the co lo ration topr ovi de dif f e rentiati on
between tools instea d  of OS. 

~ ~~
jo ndeg enhardt
T han ks for  th e  feedb ack. I  agre e,  th e perfo r m an ceta ble wouldb e nef it fr om 
bet ter for matting.

------
z X 41Z dbW
Worth tonot e cl i c kh ous e -l o cal :f ull f eatured ClickHo use SQL en gi n efor filesi n C SV /TSV/JS ONLines , wha t ever... 

[https: //www.alt in ity. c o m/b log/2019/6 /11/clic khouse-lo c al-
t h e. ..](h ttp s://ww w. alt inity .com/b l og/ 2019/ 6/11/c li ckhous e-loc al -the-pow er-of-
clickhouse-sql-i n-a-si ngle- com mand)

~~ ~
p a ulr yanrog
.com/cube2222/octosql/](https://github.com/cube2222/octosql/)

It tries_to provide_ergonomic data munching of_various formats,_but_using a
sql_interface,_which most will_probably feel immediately_at home with.

~~~
bradknowles
With respect,_who actually feels_at_home with SQL?

It's about the most alien and obtuse language I've ever had the_misfortune_of
encountering, and_in_that_category I rate it worse_than COBOL, FORTRAN,
Assembly, C, Prolog,_Sendmail re-write_rules, BASH, and every other language
I've ever encountered_and_had to use,_but which I cannot recall at the moment.

~~~
he_the_great
SQL gets_rather mistifying when you move towards_some complex joins_and_data
mapping._PSQL can also feel_Sadly out of place.

But their is_real nice clarit in what you_want at its foundation.

------
yfiapo
Cool that there are_some specialty tools in this space_and will use if I_hit
that performance_challenge.

Minor nit, I found the_performance table ([https://github.com/eBay/tsv-
utils/blob/master/docs/Performan...](https://github.com/eBay/tsv-
utils/blob/master/docs/Performance.md))_confusing at_first and second_glance.
Alternating colors indicate.. different OSes? That_doesn't seem to_be the
important message to convey as_you_are trying to_show_the_speed of_your tool
and not_the_OS. Recommend_to_use the coloration to provide differentiation
between_tools_instead of OS.

~~~
jondegenhardt
Thanks for the feedback. I_agree, the performance table_would_benefit from
better formatting.

------
zX41ZdbW
Worth to_note clickhouse-local: full featured ClickHouse_SQL engine for files
in CSV/TSV/JSONLines, whatever...

[https://www.altinity.com/blog/2019/6/11/clickhouse-local-
the...](https://www.altinity.com/blog/2019/6/11/clickhouse-local-the-power-of-
clickhouse-sql-in-a-single-command)

~~~
paulryanrog