diff --git a/community/index.html b/community/index.html
index fd5fc19..fe99ec6 100644
--- a/community/index.html
+++ b/community/index.html
@@ -69,6 +69,9 @@
   <li><a href="#mailing-lists" id="markdown-toc-mailing-lists">Mailing Lists</a></li>
   <li><a href="#help" id="markdown-toc-help">Help</a></li>
   <li><a href="#talks" id="markdown-toc-talks">Talks</a>    <ul>
+      <li><a href="#one-sql-to-rule-them-all---an-efficient-and-syntactically-idiomatic-approach-to-management-of-streams-and-tables" id="markdown-toc-one-sql-to-rule-them-all---an-efficient-and-syntactically-idiomatic-approach-to-management-of-streams-and-tables">One SQL to Rule Them All - an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables</a></li>
+      <li><a href="#apache-calcite-a-foundational-framework-for-optimized-query-processing-over-heterogeneous-data-sources" id="markdown-toc-apache-calcite-a-foundational-framework-for-optimized-query-processing-over-heterogeneous-data-sources">Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources</a></li>
+      <li><a href="#spatial-query-on-vanilla-databases" id="markdown-toc-spatial-query-on-vanilla-databases">Spatial query on vanilla databases</a></li>
       <li><a href="#apache-calcite-one-planner-fits-all" id="markdown-toc-apache-calcite-one-planner-fits-all">Apache Calcite: One planner fits all</a></li>
       <li><a href="#streaming-sql" id="markdown-toc-streaming-sql">Streaming SQL</a></li>
       <li><a href="#cost-based-query-optimization-in-apache-phoenix-using-apache-calcite" id="markdown-toc-cost-based-query-optimization-in-apache-phoenix-using-apache-calcite">Cost-based Query Optimization in Apache Phoenix using Apache Calcite</a></li>
@@ -81,28 +84,20 @@
 <h1 id="upcoming-talks">Upcoming talks</h1>
 
 <ul>
-  <li>2018/06/12 <a href="https://sigmod2018.org/index.shtml">SIGMOD/PODS 2018</a> (Houston, TX)
+  <li>September 8th-12th, 2019
+<a href="https://www.apachecon.com/acna19/">ApacheCon North America 2019</a>
+(Las Vegas, Nevada)
     <ul>
-      <li><a href="https://sigmod2018.org/sigmod_industrial_list.shtml">Apache Calcite: A Foundational Framework for Optimized Query
-Processing Over Heterogeneous Data
-Sources</a> (Edmon
-Begoli, Jesús Camacho-Rodríguez, Julian Hyde, Michael Mior, Daniel
-Lemire)</li>
-    </ul>
-  </li>
-  <li>2018/06/27 <a href="https://www.meetup.com/SF-Big-Analytics/">SF Big Analytics streaming meetup, hosted by Lyft</a>
-(San Francisco, CA)
-    <ul>
-      <li>Foundations of streaming SQL or: How I learned to love stream and
-table theory (Tyler Akidau)</li>
-      <li>Data all over the place! How Apache Calcite brings SQL and sanity to
-streaming and spatial data (Julian Hyde)</li>
-    </ul>
-  </li>
-  <li>2018/09/25 <a href="https://www.apachecon.com/acna18/">ApacheCon 2018</a> (Montréal, Canada)
-    <ul>
-      <li>Spatial query on vanilla databases (Julian Hyde)</li>
-      <li>Don’t optimize my queries, optimize my data! (Julian Hyde)</li>
+      <li>Building BigData Query Optimization with Apache Calcite – Best
+Practices from Alibaba MaxCompute (Haisheng Yuan)</li>
+      <li>Combining schema-on-read and schema-provisioning in Apache Drill
+(Aman Sinha)</li>
+      <li>Simple, Portable data pipelines with Apache Beam SQL
+(Andrew Pilloud)</li>
+      <li>One SQL to Rule Them All – a Syntactically Idiomatic Approach to
+Management of Streams and Tables (Kenneth Knowles, Julian Hyde)</li>
+      <li>Unifying Batch and Stream Data Processing with Apache Calcite and
+Apache Beam (Khai Tran)</li>
     </ul>
   </li>
 </ul>
@@ -444,6 +439,28 @@
 <p>Watch some presentations and read through some slide decks about
 Calcite, or attend one of the <a href="#upcoming-talks">upcoming talks</a>.</p>
 
+<h2 id="one-sql-to-rule-them-all---an-efficient-and-syntactically-idiomatic-approach-to-management-of-streams-and-tables">One SQL to Rule Them All - an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables</h2>
+
+<p>At <a href="https://sigmod2019.org/sigmod_industry_list">SIGMOD/PODS 2019</a>, Amsterdam, Netherlands, 2019
+and <a href="https://beam-summit.firebaseapp.com/schedule/">Beam Summit Europe 2019</a>;
+[<a href="https://arxiv.org/abs/1905.12133">paper</a>],
+[<a href="https://blog.acolyer.org/2019/07/03/one-sql-to-rule-them-all/">review</a>],
+[<a href="https://github.com/julianhyde/share/blob/master/slides/one-sql-to-rule-them-all-beam-summit-2019.pdf?raw=true">pdf</a>],
+[<a href="https://www.youtube.com/watch?v=9f4igtyNseo">video</a>].</p>
+
+<h2 id="apache-calcite-a-foundational-framework-for-optimized-query-processing-over-heterogeneous-data-sources">Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources</h2>
+
+<p>At <a href="https://sigmod2018.org/index.shtml">SIGMOD/PODS 2018</a>, Houston, TX, 2018;
+[<a href="https://arxiv.org/pdf/1802.10233">paper</a>],
+[<a href="https://www.slideshare.net/julianhyde/apache-calcite-a-foundational-framework-for-optimized-query-processing-over-heterogeneous-data-sources">slides</a>],
+[<a href="https://github.com/julianhyde/share/blob/master/slides/calcite-sigmod-2018.pdf?raw=true">pdf</a>].</p>
+
+<h2 id="spatial-query-on-vanilla-databases">Spatial query on vanilla databases</h2>
+
+<p>At ApacheCon North America, 2018;
+[<a href="https://www.slideshare.net/julianhyde/spatial-query-on-vanilla-databases">slides</a>],
+[<a href="https://github.com/julianhyde/share/blob/master/slides/calcite-spatial-apache-con-2018.pdf?raw=true">pdf</a>.</p>
+
 <h2 id="apache-calcite-one-planner-fits-all">Apache Calcite: One planner fits all</h2>
 
 <p>Voted <a href="http://www.xldb.org/archives/2015/05/best-lightning-talks-selected/">Best Lightning Talk at XLDB-2015</a>;