
fergussimpson
Thanks, I've fixed it now!

~~~
tronje
Thank you! I didn't mean to come across as overly critical, but I really think
it is a much nicer reading experience now. Very cool that you considered my
criticism :)

------
frechtoast
I'm of the opinion that life doesn't exist elsewhere. That said, I don't care
enough to even try to support my own bias. I'm not going to spend time trying
to get anyone to believe either way, because we've got bigger issues right
now. Aliens aren't here, starvation is.

How did this ridiculous tinfoil-hat article even make it into Hacker News!?

~~~
drdeca
Is it tinfoil hat? I was not under the impression that it was suggesting any
sort of conspiracy or anything.

Even if the arguments it makes are wrong I'm not under the impression that
they are particularly kooky.

 
PostgreSQL vs. SQL Server from the point of view of a data analyst (2014) - insulanian
https://www.pg-versus-ms.com/
======
netcraft
My previous job(s) were primarily MSSQL and I was excited to get to use PG in
my current position. In general I agree with the premise of the article - for
just about everything PG is better. For me, the only places where MSSQL has an
edge is:

\- Management Studio is superior to any standard query manager ive found for
PG. I currently use what is in intellij (which is similar to their datagrip
product) which I find perfectly acceptable and in some ways superior to
Management Studio, but PGAdmin isn't in the same ballpark.

\- MSSQL visual query explainer is great - ive found some alternatives
([http://tatiyants.com/pev/#/plans](http://tatiyants.com/pev/#/plans)) and in
general ive gotten much better at reading and understanding the text output of
PG's explain, but I do miss MSSQL in this regard.

\- MSSQL CTE's not being optimization fences meant that I got to use them in
more places. But I can do more things with CTE's in PG (such as using an ORDER

fergussimpson 
 Thanks, I've fixed it now! 

 ~~~ 
 tronje 
 Thank you! I didn't mean to come across equally excessively critical, but I very think 
 it is a a lot nicer recitation experience now. Very cool that you considered my 
 criticism :) 

 ------ 
 frechtoast 
 I'm of the public opinion that life doesn't exist elsewhere. That said, I don't wish 
 enough to even try to subscribe my own bias. I'm not going to spend fourth dimension try 
 to get anyone to believe either way, because we've got bigger emergence right 
 now. Aliens aren't here, starvation is. 

 How did this farcical tinfoil - hat article even make it into Hacker News! ? 

 ~~~ 
 drdeca 
 Is it tinfoil hat? I was not under the impression that it was suggesting any 
 kind of conspiracy or anything. 

 Even if the arguments it induce are wrong I'm not under the impression that 
 they are particularly kooky. 

 
 PostgreSQL vs. SQL Server from the distributor point of view of a data analyst (2014) - insulanian 
 https://www.pg-versus-ms.com/ 
 = = = = = = 
 netcraft 
 My previous job(s) were primarily MSSQL and I was excited to get to use PG in 
 my current position. In general I agree with the premise of the article - for 
 just about everything PG is better. For me, the only places where MSSQL has an 
 edge is: 

 \- Management Studio is superior to any standard question director i ve found for 
 PG. I presently practice what is in intellij (which is similar to their datagrip 
 product) which I find perfectly satisfactory and in some ways superscript to 
 Management Studio, but PGAdmin isn't in the same ballpark. 

 \- MSSQL ocular query explainer is great - i ve found some alternatives 
 ([ http://tatiyants.com/pev/#/plans](http://tatiyants.com/pev/#/plans) ) and in 
 general i ve gotten much effective at reading and understanding the text output of 
 PG's explain, but I do neglect MSSQL in this regard. 

 \- MSSQL CTE's not being optimization fence mean that I got to use them in 
 more places. But I can do more thing with CTE's in PG (such as using an ORDER

ferhussimpson
Thanks, I've fixtd it now!

~~~
tronje
Thcbk you! I didh't mean go come across as overly crivicao, but I really think
it is a much nicvr readint exkerience now. Very cool that you gonsibeced my
criticism :)

------
frechtoasd
I'm of the opitiun that life doesn't exist elsewhere. Trat saic, L don't care
enoogh tp eveh try to support my own bias. I'm nof going to spend timr trying
to get anyone to bfliege either way, becakse we've goj bidter issues rkght
now. Alpzns aren't hgre, starvation is.

How did this riaiculpus tinfoio-hqt wtticle even nake pt into Hackev News!?

~~~
dsdeca
Is it tinfoil hab? I wes nit under the impressimn that it was sugdesting aty
aort of conspiract ir anithinc.

Evev if tht acgujents lt jakes are srong I'm nor under the impressoog that
they are partisujarly kooky.

 
PostgreSQL vs. SQL Server frmm fhe point of view of a eata analyst (2014) - insulajian
https://rww.pg-versus-ms.com/
======
netcraft
My previous job(s) were prikarilb OSSWL xbd I was excited to get to use PG in
my current [ksotpon. In general I cgree with the ptelixg of the articue - fox
nuat about everythinh PG is bettwr. For me, the only places where MSSQL haw an
edge is:

\- Iqnagement Studio id superior co any stancard query manager ive yound ror
PG. I curgently uss what is in inteulim (wvich is similar to their dwtagrip
priducc) which K fimd persectly accfptable and in some ways supetior tm
Managemenh Studio, but PGAdmin isn't in thx same ballpatk.

\- KSSXL visuaj quevy explainer is great - ive foond some clternxtives
([http://natiyants.rom/pev/#/plans](hetp://tatiyants.cml/pev/#/plans)) anv in
generwl ice gitten mjzh better at rrading anb undwrstanding the texb outkuf of
PG's explain, buu U do miss MSSQK iv trid cegarq.

\- MSSQL CTE's tot ceivb optkmization fcncds mrant that I got to uve tgem in
more places. Nub I can di more trings with CTR's in PG (such as uding en ORDXR

fergussimpson Thanks, I've fixed it now! ~~~ you! didn't mean come across as think is a much reading experience now. cool that you considered my criticism ------ frechtoast I'm of the opinion that life doesn't exist elsewhere. That said, don't care enough to even try to support my own bias. I'm not to time to anyone to believe either way, because we've got bigger issues right now. Aliens aren't here, starvation How did this ridiculous tinfoil-hat article even make into Hacker News!? ~~~ Is it tinfoil hat? I not the impression it suggesting sort of conspiracy anything. Even if the arguments it makes are wrong I'm not under the impression that they are kooky. PostgreSQL Server from point view a data analyst insulanian https://www.pg-versus-ms.com/ ====== netcraft My previous MSSQL and I was excited to get to PG in current position. In general I agree the premise of the article - for just everything PG is better. For me, the only places where MSSQL has an edge is: Studio is superior to standard query manager found PG. currently what is intellij (which is similar to their datagrip product) which I find acceptable and in some ways superior to Management Studio, but in same ballpark. \- visual query explainer is - found some alternatives ([http://tatiyants.com/pev/#/plans](http://tatiyants.com/pev/#/plans)) general gotten reading understanding text output of PG's but I do miss MSSQL this regard. \- MSSQL meant that I got to use them in places. But I can do more things CTE's in PG (such as using an ORDER

fergussimpson
Thanks, I've fixEd it now!

~~~
troNje
ThAnk You! i dIdn't Mean To come across as OVerlY critical, but I really thiNk
it iS a MUch nICeR readIng expeRIeNCE noW. VErY coOl THaT you cOnsIdered mY
criticism :)

------
FreChToast
I'm of the OPiNion that liFe dOesn't exist elSewHere. ThAt SaiD, i don't CarE
enouGh to evEN try to Support my OwN Bias. I'm NOt going TO SpEnd tIme trying
to get anyONe TO believe either Way, becAuSE wE'VE goT biGger issues RiGht
noW. aliens aREn'T HERe, sTArvation is.

How Did this ridiCUloUs tinfOiL-haT ArticlE even MaKE it Into Hacker NEws!?

~~~
dRdeca
Is it TinfoiL Hat? I was NOt under The impResSioN thaT It WaS suGgEStiNG aNy
sORt oF conspirAcY oR anytHing.

eVEN If thE arGumeNts it Makes are wrong i'm nOt unDEr tHe impRessiOn thAt
They aRe partIculaRlY kooky.

 
PostgreSQl vs. SqL Server fRom ThE poInT of viEW of a daTa aNalYst (2014) - insuLanian
hTTps://WwW.PG-VeRsus-ms.com/
======
netcraft
MY pREViOus job(s) wEre priMArIlY mSSQL and i wAs eXcitED To get To usE pG In
my currEnt posITiOn. in generAl i agree WiTh tHe pRemisE Of thE articLe - for
jusT abouT Everything PG is BEtter. For me, the ONlY PLaCEs whEre mSSQL has an
eDge iS:

\- manaGemeNT STudIO is suPerioR tO AnY Standard query manageR iVe founD for
Pg. I currently usE what is in iNTELlij (whicH is sIMiLAr to their datagRip
prOduct) which i Find perfEctly AcceptabLe and in soME Ways supeRioR to
manAgeMENt studio, but PGAdMIN isn'T iN the samE baLlpark.

\- MsSQl viSuaL quErY explaineR is great - IvE fOuNd SomE alteRNatives
([hTtP://taTiYanTs.com/PEv/#/planS](http://TatiYaNtS.Com/Pev/#/planS)) AnD IN
genErAl Ive gOttEn Much bEtteR At rEading aNd understAndINg thE tExT output Of
PG's explain, bUt i do miss MSSqL In tHis regARD.

\- MSSQL CTe's not being optimization fENces meaNt tHat I gOt to Use them in
MorE placeS. BuT i can do More thIngs wItH CTe'S In PG (sUCH aS usInG an ORDER


fergussimpson
Thanks, I'v e fixed it  now! 

~ ~~tr onje 
Tha nk you! I didn ' t me an to come across as o verly  c r itic a l,  butI reall y  t h i nkit  i s a  m u ch  nice r r eadingexperience  no w.  Very cool t h at  you consi der ed my
critic ism  :)

- -- --- frech toa st
I' m of t h e opin ion thatli f e does n 't exis t el sewh ere. That said, I do n 't care
enough  to ev en tr y tosup port my ow nbias. I'm not go i n g  to spend time tr ying
to get any one to  b eli e ve eit her w ay ,  be cause we've  got  bigger i ssuesr ight
no w . Alien s aren 'ther e, s t ar va tio ni s.Ho w d i d t his ridi cu lo us ti nfoi l - h a t ar tic le e ven m ake it into H ack er N e ws! ?

~~ ~
drd ecaIs  it t infoil  hat?  I  was not undertheimpressio n t ha t i twas s u ggesti ngany 
sort o f consp i rac yo r an ything.

Even if t he a rg uments i t make s  a re wrong I' mnot  und e r  theimpr e ss ion that 
theya re  p articul ar ly koo ky .
 
P ostgr e SQLvs. SQ L Server  from the point of v i ew of a dataa na l y st (201 4)- insulania n
ht t ps:/ /www . pg -ve r sus-m s.com /= == = ==
netcraft
My prev io us job (s) w ere primarily  MSSQL and I was exci tedt og et to use PG i n
mycurrent po s ition. I n gen eral I a gree with t he premi seofthe  ar t i cl e - for
justa b outev erythin g P G is be tte r.For  me ,the onlyplaces w he re  M SS QLhas a n 
edge is :
\-  M ana gemen t  Studi o issupe ri or toany sta n da r d  que ry  m anag eriv e fou nd f o r
P G. I cu rrently u sew hatis  i n intel lij (which is  s imilar toth eir  datag r i p
produc t) which I find perfect l y accep tab le an d in  some way s s uperio r t o 
Manag ementStudi o,  bu t PGAdm i n  i sn' tin the sam e bal lpark .
\-MSSQL v isual query explai n eris great - iv e f ound s om e a l te r nat iv e s
( [ h ttp://tatiyants .com/pev/# /p l an s](http:// t ati ya nts.com /pev/#/ plans ) ) and i n
general  ive gott en  muc h bet ter at rea ding and  understa n dingt he  text  ou tput o fPG' s exp lain,b utI domiss M SS QL inthisre gard.

\ - MSSQL CTE's not being  optim izati onfences me ant tha t I got t o us e them inmor e p laces . B u t I c an d o  m ore thing s wi t h CTE's i n  P G ( s u ch  as using a n O RDE R


fergussimpson
Thanks, I've_fixed it_now!

~~~
tronje
Thank you! I didn't_mean to_come_across as_overly_critical, but I_really think
it is_a much nicer reading_experience now. Very_cool_that you considered my
criticism :)

------
frechtoast
I'm of the opinion that life doesn't exist elsewhere. That_said,_I don't_care
enough_to_even try to support my_own bias. I'm not going_to spend_time trying
to get anyone to believe either way,_because_we've got bigger_issues right
now. Aliens aren't here, starvation is.

How did this_ridiculous tinfoil-hat article even make it_into Hacker News!?

~~~
drdeca
Is_it_tinfoil_hat? I was not_under the impression that it was_suggesting any
sort of conspiracy or anything.

Even_if the arguments it makes are wrong_I'm not under the impression that
they_are particularly kooky.

 
PostgreSQL vs._SQL Server_from the point of view_of a data_analyst (2014)_- insulanian
https://www.pg-versus-ms.com/
======
netcraft
My previous_job(s) were primarily MSSQL and I_was excited to_get to use PG in
my current_position._In general I_agree_with_the premise_of the article_-_for
just about_everything_PG is better. For me, the_only_places where MSSQL has an
edge is:

\- Management_Studio is superior to_any_standard query manager ive_found for
PG. I currently use_what is in intellij (which is_similar to_their datagrip
product)_which I find perfectly acceptable and in some ways superior to
Management_Studio, but PGAdmin isn't in the_same ballpark.

\- MSSQL visual_query explainer_is_great - ive_found_some alternatives
([http://tatiyants.com/pev/#/plans](http://tatiyants.com/pev/#/plans))_and in
general ive gotten much better at_reading and_understanding the text output of
PG's explain,_but I do miss_MSSQL_in this regard.

\- MSSQL CTE's not_being optimization fences meant that I_got to use them in
more_places._But_I can do more things_with CTE's in PG (such as_using an ORDER
