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