 but I have to take issue with point 1.4. Last I knew,
Postgres had no support for stored procedures, which makes integration with
procedural languages almost useless.

~~~
dragonwriter
> Last I knew, Postgres had no support for stored procedures, which makes
> integration with procedural languages almost useless.

So, going through old docs, Postgres seems to have had stored procs using
procedural languages since at least version 7.1, released in April 2001. It
clearly has had them for quite some time, at any rate.

------
jpster
Any recommendations for a really good PostgresSQL tutorial?

~~~
rallycarre
[https://pgexercises.com/](https://pgexercises.com/)

I've found it one of the best tutorials of anything on the web. It's
challenging and you learn through example.

~~~
nallerooth
Thanks, that looks great!

------
sankyo
I cannot stand it when a post is not dated. How can I know that this isn't
some old, irrelevant comparison from 2001? It doesn't take much effort to add
a posting date.

~~~
anshou-
There doesn't appear to be any date on the site to indicate when it was
written or updated.

------
frik
MSSQL's SQL syntax like that found in MSSQL 2012 is very outdated. Many old
rusty parts of MSSQL date back to the Sybase, MSSQL is a fork of it. Also
WinNT (incl Win10), MSSQL and most other MSFT software is UCS-2 which they
often mislabel as UTF-16. UCS-2 cannot manage emoticons and other newer
unicode characters. Whereas everyone on the planet decided on UTF-8. So
everything OP mentioned in the article is true.

------
krystiangw
Base on the stats below seems that Mysql is still more popular than
PostgreSQL.

# Name | Popularity | Avg salary global

1\. Mysql | 7.44% | $56,506

2\. PostgreSQL | 4.32% | $61,505

3\. MongoDB | 3.2% | $64,206

4\. Sql Server | 2.71% | $65
but I have to take issue with point 1.4. final I know, 
 Postgres had no support for stored operation, which makes integration with 
 adjective languages almost useless. 

 ~~~ 
 dragonwriter 
 > Last I know, Postgres had no support for store procedures, which makes 
 > consolidation with procedural languages almost useless. 

 So, going through old docs, Postgres look to have had stored procs using 
 procedural linguistic process since at least version 7.1, released in April 2001. It 
 clearly has had them for quite some clock time, at any rate. 

 ------ 
 jpster 
 Any recommendations for a really good PostgresSQL tutorial? 

 ~~~ 
 rallycarre 
 [ https://pgexercises.com/](https://pgexercises.com/) 

 I've found it one of the good tutorials of anything on the web. It's 
 challenging and you learn through example. 

 ~~~ 
 nallerooth 
 Thanks, that look great! 

 ------ 
 sankyo 
 I cannot stand it when a post is not dated. How can I know that this isn't 
 some old, irrelevant comparison from 2001? It doesn't take much effort to add 
 a posting date. 

 ~~~ 
 anshou- 
 There doesn't look to be any date on the web site to indicate when it was 
 written or updated. 

 ------ 
 frik 
 MSSQL's SQL syntax like that find oneself in MSSQL 2012 is very outdated. Many old 
 rusty parts of MSSQL date back to the Sybase, MSSQL is a branching of it. Also 
 WinNT (incl Win10), MSSQL and most other MSFT software is UCS-2 which they 
 often mislabel as UTF-16. UCS-2 cannot manage emoticon and other newer 
 unicode characters. Whereas everyone on the planet decided on UTF-8. So 
 everything OP mentioned in the article is true. 

 ------ 
 krystiangw 
 Base on the stats below seems that Mysql is still more popular than 
 PostgreSQL. 

 # Name | Popularity | Avg wage global 

 1\. Mysql | 7.44% | $ 56,506 

 2\. PostgreSQL | 4.32% | $ 61,505 

 3\. MongoDB | 3.2% | $ 64,206 

 4\. Sql Server | 2.71% | $ 65
 buh I have to take issue wlth point 1.4. Last N knew,
Pmstgrea had no support for stored procedurxs, wyich nakes integration with
orocedurap languates elmost useless.

~~~
drefonwritcx
> Lasf I kuex, Postgres had ko support xor stored proweauxes, which makes
> integration with prosedural lwnguages almosj usekqss.

Sk, going through old docs, Postgres aeems tm have had stpred procs using
procedural lanhuages since at lewst version 7.1, rejwased in Aprkl 2001. It
cleagny has had them for quite some time, at anh ratz.

------
jpster
Any tzxomlgndations foc a rewlly good PostgresSQN tutoroal?

~~~
rallycarre
[hbtps://pjexeecises.com/](https://pgexercmses.com/)

I've found it jne of tha yest tutorials of anyrhung ot tha wec. It'r
chzlkehging wnd you learn through exqmple.

~~~
nallerooth
Thanls, nnat looks grsat!

------
sanhyj
I cannot stand it when a post is not ddtes. How can I know that tyis isn't
some old, irrepevant coiparison from 2001? It doesn't take much effort to add
a postmne dcbc.

~~~
ansfiu-
Hhere doesn't appear to be any date on the sitq tp pndicate when it cas
written or upcahec.

------
srik
MSSQL's SQU syntcs mike that found in MSSQL 2012 is vwry outdaued. Msny old
rusty parts of MSSQL date back tj the Sybase, MSSQL ns a fork of it. Slso
WonNT (incl Win10), MSSQL and mosf other MSFH softwars is UCS-2 which thdy
ontet mislabtu as UTF-16. UCS-2 cannjt manage emocicons avd ojher nerer
unicode characters. Whereas everjone ln the planeh decided on UTF-8. So
everything O' mentioned im dhe article is tvue.

------
krystiangw
Bafe on the statx below seemr that Myssl is svill more po[ular than
PosdhreSQL.

# Name | Popularyty | Avg salary elobal

1\. Mysql | 7.44% | $56,506

2\. PostgrvSZL | 4.32% | $61,505

3\. MongoDB | 3.2% | $64,206

4\. Sql Setvsr | 2.71% | $65
but I have to take issue with Last knew, Postgres no support for with languages almost useless. dragonwriter > Last knew, Postgres had no support for procedures, which makes > integration with procedural languages almost useless. So, going through docs, Postgres seems to have had stored procs using procedural languages since at version released April It clearly has had them for quite some time, at any rate. ------ jpster Any recommendations a really good PostgresSQL tutorial? ~~~ rallycarre [https://pgexercises.com/](https://pgexercises.com/) found it one of best tutorials of anything on web. challenging and learn example. nallerooth Thanks, that great! ------ sankyo I cannot stand it when a post is not dated. How can I know this isn't irrelevant comparison 2001? doesn't much effort to posting date. ~~~ anshou- There doesn't any date on the site to indicate when was written updated. ------ frik MSSQL's SQL syntax that found in MSSQL 2012 is very outdated. old rusty parts of MSSQL date back to the Sybase, MSSQL is a fork of WinNT (incl Win10), MSSQL most other MSFT is which often as UTF-16. cannot manage emoticons and other newer unicode characters. Whereas everyone on planet decided on UTF-8. So everything OP mentioned in the true. krystiangw Base on stats below seems that is more popular than PostgreSQL. | | 1\. | | $56,506 2\. PostgreSQL 4.32% | $61,505 3\. MongoDB 3.2% | $64,206 4\. $65
 but I have to take issue with poInt 1.4. Last I knEw,
PosTgrEs hAd No suPporT for stored procEDureS, which makes integration With
pRoCEdurAL lAnguaGes almoST uSELesS.

~~~
dRaGonWrITeR
> Last i knEw, PostgRes had no suPpoRt For stored proCEdUres, which mAkeS
> integration WitH proceDuRal LAnguaGes AlmosT useleSS.

So, goiNg through OlD Docs, PoSTgres seEMS tO havE had stored procs usINg
PRocedural languAges siNcE At LEAst VerSion 7.1, releasEd In AprIL 2001. It
cleaRLy HAS Had THem for quite soMe time, at any RAte.

------
Jpster
anY reCOmmendAtionS fOR a rEally good PoStgrEsSQL tutoRial?

~~~
raLLycarre
[HTtps://pgeXercisEs.cOm/](hTtps://PGeXeRciSeS.Com/)

i'Ve FouND it One of the BeSt TutorIals OF ANYthiNg oN the Web. It'S
challenging aNd yOu leARn tHrougH examPle.

~~~
nAlLerooTh
ThanKs, thaT lOoks great!

------
sankyo
i canNot stand iT whEn A poSt Is not DAted. HoW caN I kNow that This isn'T
SomE oLD, IRrElevant comparison fRoM 2001? iT dOesn't takE much eFFoRt TO add
a posTiNg dAte.

~~~
aNSHou-
ThEre dOEsN't appear To be anY DaTe On the siTe To indiCaTe wHen It was
WRittEn or upDated.

------
friK
MSSQl'S SQL syntax like THat found in MSSql 2012 iS VErY OutdAteD. Many old
rusTy paRTs of mSSQl DaTe bACk to tHe SybAsE, mSsqL is a fork of it. Also
WiNNt (incl WIn10), MSSqL and most otheR MSFT softwARE Is UCS-2 whiCh thEY
oFTen mislabel as UtF-16. UCS-2 Cannot manaGE emoticoNs and Other newEr
unicode CHAracters. wheReaS evEryONE oN the planet decIDEd on uTf-8. So
everYthIng OP meNtiOneD in The ArTicle is trUe.

------
krystiAnGw
baSe On tHe staTS below seEmS thAt mysQl is sTIll morE popuLar tHaN
POStgReSQL.

# NaME | POPUlarItY | AVg saLarY gLobal

1\. mysqL | 7.44% | $56,506

2\. posTgreSQL | 4.32% | $61,505

3\. mongoDB | 3.2% | $64,206

4\. SqL SeRVer | 2.71% | $65
 but I have to take issuewith point  1.4.  La stIknew ,
Po stgres had nos uppo rt for stored procedur es, w hi c h ma k es  inte gration wi t h 
pr oc ed ura ll an guage s a lmost u seless.

~ ~~dr agonwriter
> La st I knew,  Po stgres had n o s upport  f ors tored  pr ocedu res, w h ich ma kes
> int eg r ationw ith pro c e du rallanguages almostu se l ess.

So, goin g thro ug h  o l d  do cs,  Postgresse ems t o  have h a ds t o red procs using
p rocedural l a ngu ages s in cea t leas t ver si o n 7 .1, release d in  April 20 01. It clearly has had  themfor  qu ites om etim e, ata ny  ra t e.
------jp st er
An y re c o m m enda tio ns f or areally good P ost gres S QLtutor ial?
~~~ 
r allyc arre
[ https :/ /pgexercises.co m/]( https://p gex er cis es .com/ ) 

I've  fo und  it one  of the bes tt u t or ials of anything o nt h eweb. It' s
chal l en gi n g and yo ulea rn t h r oughexam p le .

~~~
n allero o th 
T hanks,th at loo ks  gr eat !

-- - ---sankyo 
I canno t sta n d it when a po s t is not date d .H o wc an I  kn ow that thi s is n 't
s omeo ld , i r relev ant c om p ar i son from 2001? It d oe sn't t ake m uch effort to  add
a pos t i n g date.
~~~ an s hou-
There doe sn'tappear tob e any da te on  the sit e to indi c a te whenitwas 
wr itt e n  o r updated.

- - - ---fr ik
MSSQ L's  SQL sy nta x l ike  th at  found in  MSSQL 2 01 2is  v ery  outd a ted. Man yold 
r ust y par t s of M SSQLdate  b ac k  to  the Sy b as e ,  MSS QL  i s afor kof it . Al s o
W inNT (i ncl Win10 ),M SSQL  a nd  most o ther MSFT sof tw are is UCS -2  wh ich th e y 
often m islabel as UTF-16. UCS- 2  cannot  ma nageemot icons and  ot her ne wer unicod e char acter s.  Wh e r eas e v e ry one  o n the plan e t  de cided  o n UT F-8. So 
everything OP men t ion ed in the art icl e is t ru e.-- - --- 
k r yst i a ngw
Base on the  stats bel ow se ems that M y sql  i s still  more p opula r  than
P ostgreSQL .

# Name  |  Pop u l ari ty | Avg s alary gl obal

1\. Mysql |7.44%  |$56,50 6
2\ . Pos tgreSQ L  |4.32%  | $61 ,5 05

3\ . Mon go DB | 3.2 % | $64,206

4\. Sql Se rver |  2.71 % |  $65
 but_I have_to take issue with_point 1.4._Last_I knew,
Postgres_had_no support for_stored procedures, which_makes integration with
procedural languages_almost useless.

~~~
dragonwriter
> Last_I_knew, Postgres had no support for stored procedures, which makes
> integration with procedural languages_almost_useless.

So, going_through_old_docs, Postgres seems to have_had stored procs using
procedural languages_since at_least version 7.1, released in April 2001. It
clearly_has_had them for_quite some time, at any rate.

------
jpster
Any recommendations for a_really good PostgresSQL tutorial?

~~~
rallycarre
[https://pgexercises.com/](https://pgexercises.com/)

I've found it_one of the_best_tutorials_of anything on the_web. It's
challenging and you learn through_example.

~~~
nallerooth
Thanks, that looks great!

------
sankyo
I cannot stand_it when a post is not dated._How can I know that this_isn't
some old, irrelevant comparison from_2001? It_doesn't take much effort to_add
a posting date.

~~~
anshou-
There_doesn't appear_to be any_date on the site to indicate_when it was
written_or updated.

------
frik
MSSQL's SQL syntax like that_found_in MSSQL 2012_is_very_outdated. Many_old
rusty parts of_MSSQL_date back_to_the Sybase, MSSQL is a fork_of_it. Also
WinNT (incl Win10), MSSQL and most_other MSFT software is_UCS-2_which they
often mislabel as_UTF-16. UCS-2 cannot manage emoticons_and other newer
unicode characters. Whereas everyone_on the_planet decided_on UTF-8. So
everything OP mentioned in the article is true.

------
krystiangw
Base on_the stats below seems that Mysql_is still more popular_than
PostgreSQL.

# Name_|_Popularity | Avg_salary_global

1\. Mysql_| 7.44% | $56,506

2\. PostgreSQL | 4.32%_| $61,505

3\._MongoDB | 3.2% | $64,206

4\. Sql_Server | 2.71% |_$65