<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugs.webkit.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.4.1"
          urlbase="https://bugs.webkit.org/"
          
          maintainer="admin@webkit.org"
>

    <bug>
          <bug_id>220589</bug_id>
          
          <creation_ts>2021-01-13 06:15:40 -0800</creation_ts>
          <short_desc>[build.webkit.org] Use PostgreSQL for new build.webkit.org database</short_desc>
          <delta_ts>2022-01-24 07:44:49 -0800</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>WebKit</product>
          <component>Tools / Tests</component>
          <version>Other</version>
          <rep_platform>Unspecified</rep_platform>
          <op_sys>Unspecified</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          <see_also>https://bugs.webkit.org/show_bug.cgi?id=196229</see_also>
    
    <see_also>https://bugs.webkit.org/show_bug.cgi?id=235296</see_also>
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords>InRadar</keywords>
          <priority>P2</priority>
          <bug_severity>Normal</bug_severity>
          <target_milestone>---</target_milestone>
          
          <blocked>175056</blocked>
          <everconfirmed>1</everconfirmed>
          <reporter name="Aakash Jain">aakash_jain</reporter>
          <assigned_to name="Aakash Jain">aakash_jain</assigned_to>
          <cc>aakash_jain</cc>
    
    <cc>ap</cc>
    
    <cc>jbedard</cc>
    
    <cc>lingho</cc>
    
    <cc>ryanhaddad</cc>
    
    <cc>webkit-bug-importer</cc>
          

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>1719271</commentid>
    <comment_count>0</comment_count>
    <who name="Aakash Jain">aakash_jain</who>
    <bug_when>2021-01-13 06:15:40 -0800</bug_when>
    <thetext>Use PostgreSQL for upcoming build.webkit.org database since it&apos;s much better than the default sqlite. The new build.webkit.org would be running latest Buildbot (which uses database heavily).</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719275</commentid>
    <comment_count>1</comment_count>
    <who name="Aakash Jain">aakash_jain</who>
    <bug_when>2021-01-13 06:36:04 -0800</bug_when>
    <thetext>Also, it might be better to use passwords.json to store db info (like db url, username etc.) instead of environment variables.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719276</commentid>
    <comment_count>2</comment_count>
      <attachid>417529</attachid>
    <who name="Aakash Jain">aakash_jain</who>
    <bug_when>2021-01-13 06:39:55 -0800</bug_when>
    <thetext>Created attachment 417529
Patch</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719277</commentid>
    <comment_count>3</comment_count>
    <who name="Radar WebKit Bug Importer">webkit-bug-importer</who>
    <bug_when>2021-01-13 06:44:15 -0800</bug_when>
    <thetext>&lt;rdar://problem/73149418&gt;</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719318</commentid>
    <comment_count>4</comment_count>
    <who name="lingho@apple.com">lingho</who>
    <bug_when>2021-01-13 09:51:41 -0800</bug_when>
    <thetext>rs+</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719354</commentid>
    <comment_count>5</comment_count>
      <attachid>417529</attachid>
    <who name="Jonathan Bedard">jbedard</who>
    <bug_when>2021-01-13 10:55:07 -0800</bug_when>
    <thetext>Comment on attachment 417529
Patch

View in context: https://bugs.webkit.org/attachment.cgi?id=417529&amp;action=review

&gt; Tools/CISupport/build-webkit-org/master_buildbot2.cfg:-2
&gt; -# ex: set syntax=python:

Sure we want to remove these lines?</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719380</commentid>
    <comment_count>6</comment_count>
    <who name="Aakash Jain">aakash_jain</who>
    <bug_when>2021-01-13 12:04:38 -0800</bug_when>
    <thetext>(In reply to Jonathan Bedard from comment #5)
&gt; Sure we want to remove these lines?
Yeah, I don&apos;t see much benefit of keeping them. EWS master.cfg also doesn&apos;t have these.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1719384</commentid>
    <comment_count>7</comment_count>
    <who name="EWS">ews-feeder</who>
    <bug_when>2021-01-13 12:21:40 -0800</bug_when>
    <thetext>Committed r271450: &lt;https://trac.webkit.org/changeset/271450&gt;

All reviewed patches have been landed. Closing bug and clearing flags on attachment 417529.</thetext>
  </long_desc>
      
          <attachment
              isobsolete="0"
              ispatch="1"
              isprivate="0"
          >
            <attachid>417529</attachid>
            <date>2021-01-13 06:39:55 -0800</date>
            <delta_ts>2021-01-13 12:21:41 -0800</delta_ts>
            <desc>Patch</desc>
            <filename>bug-220589-20210113093954.patch</filename>
            <type>text/plain</type>
            <size>2110</size>
            <attacher name="Aakash Jain">aakash_jain</attacher>
            
              <data encoding="base64">SW5kZXg6IFRvb2xzL0NoYW5nZUxvZwo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09Ci0tLSBUb29scy9DaGFuZ2VMb2cJKHJl
dmlzaW9uIDI3MTQzOSkKKysrIFRvb2xzL0NoYW5nZUxvZwkod29ya2luZyBjb3B5KQpAQCAtMSwz
ICsxLDEyIEBACisyMDIxLTAxLTEzICBBYWthc2ggSmFpbiAgPGFha2FzaF9qYWluQGFwcGxlLmNv
bT4KKworICAgICAgICBbYnVpbGQud2Via2l0Lm9yZ10gVXNlIFBvc3RncmVTUUwgZm9yIG5ldyBi
dWlsZC53ZWJraXQub3JnIGRhdGFiYXNlCisgICAgICAgIGh0dHBzOi8vYnVncy53ZWJraXQub3Jn
L3Nob3dfYnVnLmNnaT9pZD0yMjA1ODkKKworICAgICAgICBSZXZpZXdlZCBieSBOT0JPRFkgKE9P
UFMhKS4KKworICAgICAgICAqIENJU3VwcG9ydC9idWlsZC13ZWJraXQtb3JnL21hc3Rlcl9idWls
ZGJvdDIuY2ZnOgorCiAyMDIxLTAxLTEzICBEaWVnbyBQaW5vIEdhcmNpYSAgPGRwaW5vQGlnYWxp
YS5jb20+CiAKICAgICAgICAgW2J1aWxkYm90XSBXZWJLaXRHVEsoR1RLNCkgaXNuJ3QgdHJpZ2dl
cmVkIGFmdGVyIGEgYmluYXJ5IGJ1aWxkCkluZGV4OiBUb29scy9DSVN1cHBvcnQvYnVpbGQtd2Vi
a2l0LW9yZy9tYXN0ZXJfYnVpbGRib3QyLmNmZwo9PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09Ci0tLSBUb29scy9DSVN1cHBv
cnQvYnVpbGQtd2Via2l0LW9yZy9tYXN0ZXJfYnVpbGRib3QyLmNmZwkocmV2aXNpb24gMjcxNDM5
KQorKysgVG9vbHMvQ0lTdXBwb3J0L2J1aWxkLXdlYmtpdC1vcmcvbWFzdGVyX2J1aWxkYm90Mi5j
ZmcJKHdvcmtpbmcgY29weSkKQEAgLTEsNSArMSw2IEBACi0jIC0qLSBweXRob24gLSotCi0jIGV4
OiBzZXQgc3ludGF4PXB5dGhvbjoKK2ltcG9ydCBqc29uCitpbXBvcnQgb3MKK2ltcG9ydCBzeXMK
IAogZnJvbSBidWlsZGJvdC5jaGFuZ2VzLnBiIGltcG9ydCBQQkNoYW5nZVNvdXJjZQogZnJvbSBi
dWlsZGJvdC5wbHVnaW5zIGltcG9ydCB1dGlsCkBAIC0yMyw5ICsyNCwyMyBAQCBjWyd3d3cnXVsn
dWlfZGVmYXVsdF9jb25maWcnXSA9IHsKIH0KIAogY1sncHJvdG9jb2xzJ10gPSB7J3BiJzogeydw
b3J0JzogMTcwMDB9fQotY1sncHJvamVjdE5hbWUnXSA9ICJXZWJLaXQiCi1jWydwcm9qZWN0VVJM
J10gPSAiaHR0cHM6Ly93ZWJraXQub3JnIgotY1snYnVpbGRib3RVUkwnXSA9ICJodHRwczovL2J1
aWxkLndlYmtpdC5vcmcvIgorY1sncHJvamVjdE5hbWUnXSA9ICdXZWJLaXQnCitjWydwcm9qZWN0
VVJMJ10gPSAnaHR0cHM6Ly93ZWJraXQub3JnJworCitpZiBpc190ZXN0X21vZGVfZW5hYmxlZDoK
KyAgICBjWydidWlsZGJvdFVSTCddID0gJ2h0dHA6Ly9sb2NhbGhvc3Q6ODcxMC8nCitlbHNlOgor
ICAgIGNbJ2J1aWxkYm90VVJMJ10gPSAnaHR0cHM6Ly9idWlsZC53ZWJraXQub3JnLycKKyAgICBw
YXNzd29yZHMgPSBqc29uLmxvYWQob3BlbigncGFzc3dvcmRzLmpzb24nKSkKKyAgICBkYl91cmwg
PSBwYXNzd29yZHMuZ2V0KCdEQl9VUkwnKQorICAgIGRiX25hbWUgPSBwYXNzd29yZHMuZ2V0KCdE
Ql9OQU1FJykKKyAgICBkYl91c2VybmFtZSA9IHBhc3N3b3Jkcy5nZXQoJ0RCX1VTRVJOQU1FJykK
KyAgICBkYl9wYXNzd29yZCA9IHBhc3N3b3Jkcy5nZXQoJ0RCX1BBU1NXT1JEJykKKyAgICBpZiBO
b25lIGluIFtkYl91cmwsIGRiX25hbWUsIGRiX3VzZXJuYW1lLCBkYl9wYXNzd29yZF06CisgICAg
ICAgIHByaW50KCdEYXRhYmFzZSBpbmZvcm1hdGlvbiBtaXNzaW5nIGZyb20gcGFzc3dvcmRzLmpz
b24uJykKKyAgICAgICAgc3lzLmV4aXQoMSkKKyAgICAjIFNlZSBodHRwczovL2RvY3MuYnVpbGRi
b3QubmV0LzIuMTAuMC9tYW51YWwvY29uZmlndXJhdGlvbi9nbG9iYWwuaHRtbCNkYXRhYmFzZS1z
cGVjaWZpY2F0aW9uCisgICAgY1snZGJfdXJsJ10gPSAncG9zdGdyZXNxbDovL3t9Ont9QHt9L3t9
Jy5mb3JtYXQoZGJfdXNlcm5hbWUsIGRiX3Bhc3N3b3JkLCBkYl91cmwsIGRiX25hbWUpCiAKIGNb
J2J1aWxkQ2FjaGVTaXplJ10gPSA2MAogY1snbG9nQ29tcHJlc3Npb25NZXRob2QnXSA9ICdsejQn
Cg==
</data>

          </attachment>
      

    </bug>

</bugzilla>