templates/index.html

   1 {%extends "base/base.html" %}
   2 {% load pgfilters %}
   3 {%block title%}The world's most advanced open source database{%endblock%}
   4 {%block meta%}
   5   <meta name="description" content="The official site for PostgreSQL, the world's most advanced open source database" />
   6 {%endblock%}
   7 {%block layoutblock%}
   8 <div class="jumbotron jumbotron-fluid pg-jumbotron">
   9   <div class="container">
  10     <h1 class="text-white pg-jumbotron-header">PostgreSQL: The World's Most Advanced Open Source Relational Database</h1>
  11     <div class="row">
  12       <div class="col text-center">
  13         <a class="btn btn-light btn-rounded" role="button" href="/download/">Download <i class="fa fa-arrow-right" aria-hidden="true"></i></a>
  14         <a class="btn btn-light btn-rounded" role="button" href="/about/">New to PostgreSQL?</a>
  15       </div>
  16     </div>
  17   </div>
  18 </div>
  19 <!-- END Jumbotron -->
  20 <div class="container margin">
  21   <!-- Start First Feature Row -->
  22
  23   <div class="row">
  24     <!-- Feature -->
  25     <div class="col-lg-6 feature">
  26       <img src="/media/img/about/press/elephant.png" alt="PostgreSQL Elephant Logo">
  27       <h2>New to PostgreSQL?</h2>
  28       <div class="text">
  29         <p>
  30           PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development
  31           that has earned it a strong reputation for reliability, feature robustness, and performance.
  32         </p>
  33         <p>
  34           There is a wealth of information to be found describing how to <a href="{{link_root}}/download/">install</a> and <a href="{{link_root}}/docs/">use</a> PostgreSQL through the <a href="{{link_root}}/docs/">official documentation</a>.
  35           The PostgreSQL community provides many helpful places to become familiar with the technology, discover how it works, and find
  36           career opportunities. Reach out to the community <a href="{{link_root}}/community/">here</a>.
  37         </p>
  38       </div>
  39       <a href="{{link_root}}/about/" title="Read More"><button type="button" class="btn btn-center btn-primary">Read More</button></a>
  40     </div>
  41     <!-- END Feature -->
  42
  43     <!-- Feature -->
  44     <div class="col-lg-6 feature">
  45       <i class="fas fa-download"></i>
  46       <h2>Latest Releases</h2>
  47       <div class="text">
  48         <p>
  49           <strong>
  50             2019-10-03 - PostgreSQL 12 Released!
  51           </strong>
  52         </p>
  53         <p>
  54           The PostgreSQL Global Development Group today announced the release of
  55           <a href="/about/news/1976/">PostgreSQL 12</a>, the latest version of
  56           the world's <a href="/">most advanced open source database</a>.
  57         </p>
  58         <p>
  59           <a href="/docs/12/release-12.html">PostgreSQL 12 enhancements</a>
  60           include notable improvements to query
  61           performance, particularly over larger data sets, and overall space
  62           utilization. This release provides application developers with new
  63           capabilities such as
  64           <a href="/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH">SQL/JSON path expression</a>
  65           support, optimizations for how common table expression (<code>WITH</code>)
  66           queries are executed, and <a href="/docs/current/ddl-generated-columns.html">generated columns</a>.
  67         </p>
  68         <p>
  69           The PostgreSQL community continues to support the extensibility and
  70           robustness of PostgreSQL, with further additions to
  71           internationalization, authentication, and providing easier ways to
  72           administrate PostgreSQL. This release also introduces the
  73           <a href="/docs/current/tableam.html">pluggable table storage interface</a>,
  74           which allows developers to create their own methods for storing data.
  75         </p>
  76         <p>
  77           For more information, please see the
  78           <a href="/docs/12/release-12.html">release notes</a>.
  79           <a href="/download/">Download PostgreSQL 12 here</a>.
  80         </p>
  81         <ul>
  82           {% for v in versions %}
  83             <li class="{% cycle '' 'pg-bg-gray' %}"><strong>{{ v.numtree }}.{{ v.latestminor }}</strong> &middot; {{ v.reldate|date:"Y-m-d" }} &middot; <a href="/docs/{{ v.numtree }}/{{ v.relnotes }}">Notes</a></li>
  84           {% endfor %}
  85         </ul>
  86       </div>
  87       <a href="{{link_root}}/download/" title="Download"><button type="button" class="btn btn-center btn-primary">Download</button></a>
  88       <a href="{{link_root}}/support/versioning/" title="Why Upgrade?"><button type="button" class="btn btn-center btn-outline-secondary btn-inline-block">Why Upgrade?</button></a>
  89       <a href="{{link_root}}/support/security/" title="Security"><button type="button" class="btn btn-center btn-outline-secondary btn-inline-block">Security</button></a>
  90     </div>
  91     <!-- END Feature -->
  92
  93   </div>
  94   <!-- END First Feature Row -->
  95   <!-- Start Second Feature Row -->
  96   <div class="row">
  97     <!-- Feature -->
  98     <div class="col-lg-6 feature">
  99       <i class="fas fa-calendar-alt"></i>
 100       <h2>Upcoming Events</h2>
 101       <div class="text">
 102         <ul>
 103           {% for event in events %}
 104             <li class="{% cycle '' 'pg-bg-gray' %} {% if not event.badged%}non-badged{% endif %}">
 105               {% if event.badged %}
 106                 <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event">
 107               {% endif %}
 108               {{ event.displaydate|safe }} &middot; <a href="/about/event/{{ event.id }}/">{{ event.title }}</a>
 109             </li>
 110           {% endfor %}
 111         </ul>
 112         <p>
 113           <img src="/media/img/PostgreSQL_Badge1.svg" class="community" alt="PostgreSQL Community Event">
 114           indicates that an event is recognised under the <a href="/community/recognition/#conferences">community event guidelines</a> and is directly helping the PostgreSQL community.
 115         </p>
 116       </div>
 117       <a href="/about/events/" title="Check Schedule"><button type="button" class="btn btn-center btn-primary btn-inline-block">Check Schedule</button></a>
 118       <a href="/account/events/new/" title="Add Your Event"><button type="button" class="btn btn-center btn-primary btn-inline-block">Add Your Event</button></a>
 119     </div>
 120     <!-- END Feature -->
 121     <!-- Feature -->
 122     <div class="col-lg-6 feature">
 123       <i class="fas fa-envelope"></i>
 124       <h2>Mailing Lists</h2>
 125       <div class="text">
 126         <p>
 127           The PostgreSQL <a href="https://lists.postgresql.org" target="_blank">mailing lists</a> enable you to interact with active community participants on subjects related to the development of PostgreSQL, discovering how to use PostgreSQL, or learning about upcoming events and product releases.
 128         </p>
 129         <p>
 130           In order to manage your mailing list subscription, you need a <a href="{{link_root}}/account/">PostgreSQL community account</a>. <a href="{{link_root}}/account/">Signing up</a> is easy and gives you direct access to the <a href="{{link_root}}/community/">global PostgreSQL community</a>.
 131         </p>
 132       </div>
 133       <a href="https://lists.postgresql.org" title="Subscribe"><button type="button" class="btn btn-center btn-primary">Subscribe</button></a>
 134       <a href="https://www.postgresql.org/list/" title="View Archives"><button type="button" class="btn btn-center btn-primary">View Archives</button></a>
 135     </div>
 136     <!-- END Feature -->
 137   </div>
 138   <!-- END Second Feature Row -->
 139 </div>
 140 <!-- CTA -->
 141 <div class="container-fluid">
 142   <div class="row">
 143     <div class="col-lg-6 cta cta-3"></div>
 144     <div class="col-lg-6 cta-text">
 145       <h2>Learning Opportunities Ahead</h2>
 146       <p class="text-left">
 147         Want to learn more about PostgreSQL and help build the community? Come to one of the many events, local user groups, &amp; training sessions where you can meet experienced PostgreSQL users and enhance your database skills.
 148       </p>
 149       <a href="{{link_root}}/about/events/" title="Browse Events"><button type="button" class="btn btn-light btn-rounded">Browse Events</button></a>
 150       <a href="{{link_root}}/community/user-groups/" title="Browse User Groups"><button type="button" class="btn btn-light btn-rounded">Browse User Groups</button></a>
 151     </div>
 152   </div>
 153 </div>
 154 <!-- END CTA -->
 155 <!-- News -->
 156 <div class="container">
 157   <div class="row">
 158     <div class="col-lg-7">
 159       <h2 class="centered-lines">Latest News</h2>
 160       <!-- Featured Post -->
 161         <header>
 162           <h3>
 163             <a href="/about/news/1976/">PostgreSQL 12 Released</a>!
 164           </h3>
 165           <ul class="meta">
 166             <li><i class="far fa-clock"></i>&nbsp;2019-10-03</li>
 167             <!--<li><i class="far fa-comments"></i> 0</li>-->
 168           </ul>
 169         </header>
 170         <p>
 171           The PostgreSQL Global Development Group today announced the release of
 172           <a href="/about/news/1976/">PostgreSQL 12</a>, the latest version of
 173           the world's <a href="/">most advanced open source database</a>.
 174         </p>
 175         <p>
 176           <a href="/docs/12/release-12.html">PostgreSQL 12 enhancements</a>
 177           include notable improvements to query
 178           performance, particularly over larger data sets, and overall space
 179           utilization. This release provides application developers with new
 180           capabilities such as
 181           <a href="/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH">SQL/JSON path expression</a>
 182           support, optimizations for how common table expression (<code>WITH</code>)
 183           queries are executed, and <a href="/docs/current/ddl-generated-columns.html">generated columns</a>.
 184         </p>
 185         <p>
 186           The PostgreSQL community continues to support the extensibility and
 187           robustness of PostgreSQL, with further additions to
 188           internationalization, authentication, and providing easier ways to
 189           administrate PostgreSQL. This release also introduces the
 190           <a href="/docs/current/tableam.html">pluggable table storage interface</a>,
 191           which allows developers to create their own methods for storing data.
 192         </p>
 193         <ul class="bold">
 194           <li><a href="/about/news/1976/">Release Announcement</a></li>
 195           <li><a href="/about/press/">PostgreSQL 12 Press Kit &amp; Translations</a></li>
 196           <li><a href="/docs/12/release-12.html">PostgreSQL 12 Release Notes</a></li>
 197           <li><a href="/download/">Download</a></li>
 198         </ul>
 199         <a href="/about/newsarchive/" title="Archives"><button type="button" class="btn btn-primary btn-center btn-inline-block">Browse Archives</button></a>
 200         <a href="/account/news/new/" title="Submit News"><button type="button" class="btn btn-primary btn-center btn-inline-block">Submit News</button></a>
 201     </div>
 202     <div class="col-lg-5">
 203       <div class="sidebar">
 204
 205         <!-- Archives -->
 206         <ul class="divided">
 207           {% for n in news %}
 208             <li>
 209               <h3><a href="/about/news/{{ n.id }}/">{{ n.title }}</a></h3>
 210               <ul class="meta">
 211                 <li><i class="far fa-clock"></i>&nbsp;{{ n.displaydate }} by {{ n.org.name }}</li>
 212               </ul>
 213             </li>
 214           {% endfor %}
 215         </ul>
 216         <!-- END Archives -->
 217       </div>
 218     </div>
 219   </div>
 220 </div>
 221 <!-- Blog -->
 222  <div class="container margin">
 223    <div class="row">
 224      <div class="col-md-12">
 225        <h2 class="centered-lines"><span>PLANET POSTGRESQL</span></h2>
 226        <div class="feature"><i class="fas fa-globe"></i></div>
 227     </div>
 228    </div>
 229    <!-- First Row Planet PostgreSQL -->
 230    <div class="row">
 231      <!-- First Column First Row Planet PostgreSQL -->
 232       {%for post in planet %}
 233         <div class="col-md-4">
 234           <div class="text-center">
 235             <h3><a href="{{ post.url }}">{{ post|planet_title }}</a></h3>
 236             <ul class="meta">
 237               <li><i class="far fa-comments"></i>&nbsp;{{ post|planet_author }}</li>
 238               <li><i class="far fa-clock"></i>&nbsp;{{ post.date }}</li>
 239             </ul>
 240           </div>
 241         </div>
 242       {% endfor %}
 243    </div>
 244    <!-- END First Row Planet PostgreSQL -->
 245    <div class="row">
 246      <div class="col-sm-12">
 247        <a href="https://planet.postgresql.org" title="Browse Archives" target="_blank"><button type="button" class="btn btn-center btn-primary">Browse Archives</button></a>
 248      </div>
 249    </div>
 250  </div>
 251  <!-- SUBMIT A BUG -->
 252  <div class="container-fluid">
 253    <div class="row">
 254      <div class="col-lg-6 cta-text">
 255        <h2>Seeing unexpected behavior?</h2>
 256        <p>
 257          The PostgreSQL community takes pride in releasing software that will reliably store your data. If you believe you've discovered a bug, please click the button below and follow the instructions on how to submit a bug.
 258        </p>
 259        <a href="/account/submitbug/" title="Submit a Bug"><button type="button" class="btn btn-light btn-rounded">Submit a Bug</button></a>
 260      </div>
 261      <div class="col-lg-6 cta cta-2"></div>
 262    </div>
 263  </div>
 264  <!-- END SUBMIT A BUG -->
 265 {%endblock%}