ec changed the topic of #elliottcable to: a 𝕯𝖊𝖓 𝖔𝖋 𝕯𝖊𝖙𝖊𝖗𝖒𝖎𝖓𝖊𝖉 𝕯𝖆𝖒𝖘𝖊𝖑𝖘 slash s͔̞u͕͙p͙͓e̜̺r̼̦i̼̜o̖̬r̙̙ c̝͉ụ̧͘ḷ̡͙ţ͓̀ || #ELLIOTTCABLE is not about ELLIOTTCABLE
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
<ec> gack ignore
<jfhbrook> ignore what?
<jfhbrook> :)
<ec> wow that is a really neat article, jfhbrook
<ec> thx 4 retweet
alexgordon has joined #elliottcable
<joepie91> jfhbrook: did you know: a postgresql query parser exists
<jfhbrook> what, in the source of postgres?
<joepie91> jfhbrook: well... there is a module on NPM that's basically bindings to PostgreSQL's query parser
<jfhbrook> wait really?
<joepie91> so, yes and no
<joepie91> :p
<joepie91> yes
<joepie91> sec
<joepie91> jfhbrook: I think I was thinking of thbis one: https://github.com/zhm/pg-query-parser
<joepie91> this*
<joepie91> though the README looks different from what I recall
<joepie91> so it may also be a different one I've used
<jfhbrook> whoa, that's pretty neat
<jfhbrook> though now I'm realizing that you don't necessarily want a parser for a linter
<joepie91> jfhbrook: ah yeah I was thinking of https://www.npmjs.com/package/pg-query-native
<joepie91> same author
<joepie91> lower-level dep
<jfhbrook> cause like you would need to alert on things that you lose in the parser like whitespace alignment
* joepie91 knows ALL the obscure modules that nobody uses :P
<joepie91> mmm
<joepie91> I suppose
<joepie91> jfhbrook: lots and lots of regex?
<jfhbrook> yeah I mean I've never researched this properly
<jfhbrook> I just have gotten mad at bad redshift errors
<jfhbrook> like PARSE ERROR ON CHARACTER 306834
<joepie91> I've generally found "SQL parsing as a thing that isn't a database" to be a fairly unexplored field
<joepie91> lol
<joepie91> jfhbrook: did I ever show you that partial query thing I was working on
<jfhbrook> nah
<joepie91> was for the purpose of a PostgreSQL dump parser
<joepie91> basically fished out valid queries out of a dump file
<joepie91> ignoring unfinished bits
<joepie91> I forgot the specifics
<joepie91> but it used that query parser
<joepie91> to parse out the dump
<joepie91> because PostgreSQL's dump format is weird and can basically only be read by PostgreSQL
<joepie91> lol
<joepie91> and it's some bizarre SQL/CSV hybrid iirc
<joepie91> so you need a multi-modal parser to make any sense of it
<jfhbrook> I've seen the old school text format yeah
<jfhbrook> I'd love a linter for olap shit though, like
<jfhbrook> idk what the rules would be but proper indentation, breaking shit up into multiple lines
<jfhbrook> aside from better parse error messaging
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
_whitelogger has joined #elliottcable
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Client Quit]
_whitelogger has joined #elliottcable
mylesborins has quit [Quit: farewell for now]
mylesborins has joined #elliottcable
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Client Quit]
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Client Quit]
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Client Quit]
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
alexgordon has joined #elliottcable
alexgordon has quit [Quit: My MacBook Pro has gone to sleep. ZZZzzz…]
<pikajude> ec, do you use macos
SwooshyCueb is now known as elfboy
alexgordon has joined #elliottcable