ATTN: Spagbog shatpistons

@Sythe lol arent you the king of #statfags ??

@SuF

 

[Sephiroth]

@SuF

Touche sir. Touche

 

[SuF]

@SuF

oh shit am i going to have to like actually learn statistics that anyone that isn't a stupid psych major can do?

 

[Sephiroth]

oh shit am i going to have to like actually learn statistics that anyone that isn't a stupid psych major can do?

You wanted HASKELL so TAKE IT

 

[SuF]

You wanted HASKELL so TAKE IT

uhg i've spent like hours learning postgres and figuring out why i can use fucking $1 shits and have to use ?s instead

 

[Sephiroth]

uhg i've spent like hours learning postgres and figuring out why i can use fucking $1 shits and have to use ?s instead

This is why you should have the title of #statsfag

 

uhg i've spent like hours learning postgres and figuring out why i can use fucking $1 shits and have to use ?s instead

you talking about prepared statements?

almost every sql engine with prepared statements uses ?

 

[SuF]

you talking about prepared statements?

almost every sql engine with prepared statements uses ?

i was hoping to get the library i was using to do it for me so i wouldn't have to do a prepare but i gave up so i just prepared it first

 

[SuF]

apparently they don't do it because the c lib they use underneath doesn't really support it or something and i have very little database experience so this was highly entertaining /s

 

apparently they don't do it because the c lib they use underneath doesn't really support it or something and i have very little database experience so this was highly entertaining /s

SQL is required learning for any programmer

I can't stand it when I'm talking to another programmer and they're like "DUH what's a join"

 

[Shin]

SQL is required learning for any programmer

I can't stand it when I'm talking to another programmer and they're like "DUH what's a join"

Fucking lol'd

 

[Sephiroth]

SQL is required learning for any programmer

I can't stand it when I'm talking to another programmer and they're like "DUH what's a join"

LOL RIchard you are a fucking SAVAGE. @SuF you gotta SQL Inject that ass son.

#buttrapedbyrich

 

[SuF]

SQL is required learning for any programmer

I can't stand it when I'm talking to another programmer and they're like "DUH what's a join"

it wasnt required for my degree (which it is now since they decided that was stupid) and it always conflicted with something and i never had a project to use it with. i learned basics at my job but we don't really use it all that much. what i've worked on for the last 10 or so months hasnt needed us to touch any database at all

 

[SuF]

so my answer is get off my lawn just use a fucking csv

 

[Syed]

>not storing all data in text files with semi-colons as seperators

its like you guys are trolling me, are you trying to lose performance???

sql??? what is that???

 

it wasnt required for my degree (which it is now since they decided that was stupid) and it always conflicted with something and i never had a project to use it with. i learned basics at my job but we don't really use it all that much. what i've worked on for the last 10 or so months hasnt needed us to touch any database at all

so my answer is get off my lawn just use a fucking csv

If I ever hire (more) programmers I will quiz them on how they would walk a tree in SQL

 

[Sephiroth]

@Syed its simple... SQL is Sexual Quantitative Logistics. I thought you knew this son?

 

>not storing all data in text files with semi-colons as seperators

its like you guys are trolling me, are you trying to lose performance???

sql??? what is that???

>2016
>metadata what's that?
>everyone's using graphdatabases dont you know, it's all the rage
>what's that? they were tried and failed in the 70s and 80s and now are just a fad
>you don't know what you're talking about! graph databases are the bomb!

^ actual conversation

 

@Syed its simple... SQL is Sexual Quantitative Logistics. I thought you knew this son?

INSERT PENIS INTO VAGINA;

checks out

 

[Sephiroth]

INSERT PENIS INTO VAGINA;

checks out

Walk SQL??

Like this??

With Family As
(
Select s.ID, s.ParentSeriesId, 0 as Depth
From Series s
Where ID = @ParentID
Union All
Select s2.ID, s2.ParentSeriesId, Depth + 1
From Series s2
    Join Family
        On Family.ID = s2.ParentSeriesId
)
Select *
From Family

Or am I no where close to getting that done