add new resources and update changelog

mattmakai · mattmakai · commit 5ee9282a9fe0 · 2018-12-18T05:25:54.000-05:00
diff --git a/content/pages/03-data/06-sqlalchemy.markdown b/content/pages/03-data/06-sqlalchemy.markdown
@@ -33,7 +33,7 @@ application software stacks and backend databases. Any of these
 configurations can be a valid option depending on what type of application
 you are coding.
 
-<img src="/img/visuals/sqlalchemy-orm-example.png" width="100%" alt="Example SQLAlchemy configurations with different web frameworks." class="technical-diagram"></a>
+<img src="/img/visuals/sqlalchemy-orm-example.png" width="100%" alt="Example SQLAlchemy configurations with different web frameworks." class="shot"></a>
 
 A benefit many developers enjoy with SQLAlchemy is that it allows them 
 to write Python code in their project to map from the database schema 
@@ -123,6 +123,9 @@ your application's code with the SQLAlchemy library.
   has details on why, how and when you may want to use SQLAlchemy to
   augment the [Django ORM](/django-orm.html).
 
+* [Building a Simple Birthday App with Flask-SQLAlchemy](https://pybit.es/flask-sqlalchemy-bday-app.html)
+  combines SQLAlchemy with Flask to create a birthday reminder application.
+
 
 ### SQLAlchemy resources
 The best way to get comfortable with SQLAlchemy is to dig in and write
@@ -154,6 +157,10 @@ edge cases.
   [SQLAlchemy tutorial](https://overiq.com/sqlalchemy/101/intro-to-sqlalchemy/) provides
   a slew of code examples that cover the basics for working with SQLAlchemy.
 
+* [Implementing User Comments with SQLAlchemy](https://blog.miguelgrinberg.com/post/implementing-user-comments-with-sqlalchemy)
+  gives a wonderful walkthrough of how to build your own online commenting
+  system in Python using SQLAlchemy.
+
 * [SQLAlchemy and data access in Python](https://talkpython.fm/episodes/show/5/sqlalchemy-and-data-access-in-python)
   is a podcast interview with the creator of SQLAlchemy that covers the
   project's history and how it has evolved over the past decade.
diff --git a/content/pages/03-data/10-no-sql-datastore.markdown b/content/pages/03-data/10-no-sql-datastore.markdown
@@ -183,6 +183,10 @@ representing a person could have a property of "female" or "male".
   relational systems and what the Consistency, Availability and
   Partition-Tolerance (CAP) Theorem means.
 
+* [NoSQL Explained](https://www.mongodb.com/nosql-explained) is a good
+  high-level overview of considerations and features when choosing a type 
+  of NoSQL database compared to a relational database.
+
 * [CAP Theorem overview](http://natishalom.typepad.com/nati_shaloms_blog/2010/10/nocap.html)
   presents the basic constraints all databases must trade off in operation.
 
diff --git a/content/pages/03-data/12-mongodb.markdown b/content/pages/03-data/12-mongodb.markdown
@@ -41,6 +41,12 @@ command line and query language.
   operate that were non-intuitive to developers who are new to using this
   database.
 
+* [On MongoDB](https://www.nemil.com/mongo/index.html) is not a tutorial
+  but instead discusses the culture and adoption patterns around how MongoDB
+  became such a common NoSQL database. This is a must read to understand
+  both the strengths and many weaknesses Mongo has despite what you may
+  read in other introductory tutorials.
+
 
 ### MongoDB security
 NoSQL databases can be a weak spot in a production deployment environment,
diff --git a/content/pages/04-web-development/54-slack.markdown b/content/pages/04-web-development/54-slack.markdown
@@ -39,3 +39,42 @@ for programmatically interacting with its messaging service.
   a Python tutorial but it provides a crazy hack for communicating
   with Slack using a Super Nintendo.
 
+* [Hacking Slack accounts: As easy as searching GitHub](https://arstechnica.com/information-technology/2016/04/hacking-slack-accounts-as-easy-as-searching-github/)
+  explains how secret Slack API keys are often committed to public GitHub 
+  repositories which allows malicious actors to easily break into an 
+  organization's messaging systems. Secret credentials in public repositories
+  is a problem for any API and it is a particular problem for ones that are
+  critical to a business' private communications.
+
+* [Serverless Slash Commands with Python](https://renzo.lucioni.xyz/serverless-slash-commands-with-python/)
+  shows how to build a [serverless](/serverless.html) [Flask](/flask.html)
+  plus Zappa framework web app that is hosted on [AWS Lambda](/aws-lambda.html)
+  and can use the Slack API.
+
+* [Hacking Slack using postMessage and WebSocket-reconnect to steal your precious token](https://labs.detectify.com/2017/02/28/hacking-slack-using-postmessage-and-websocket-reconnect-to-steal-your-precious-token/)
+  examines a bug that the author found in Slack's WebSockets reconnection 
+  operation that he reported to Slack. Slack fixed the issue and paid him a
+  bug bounty for his work.
+
+* [Posting messages to Slack using incoming webhooks and Python3 Requests API](https://notes.ayushsharma.in/2017/09/posting-messages-to-slack-using-incoming-webhooks-and-python-requests-api)
+  is a short script that uses the [Requests](https://pypi.org/project/requests/) 
+  library instead of the Slack-provided Python helper libraries to interact
+  with the API.
+
+* [Build a Google Analytics Slack Bot with Python](https://www.twilio.com/blog/2018/03/google-analytics-slack-bot-python.html)
+  walks through creating a bot that posts Google Analytics data into
+  Slack channels by combining the Slack and Google APIs.
+
+
+### Example Slack bots
+* [python-rtmbot](https://github.com/slackapi/python-rtmbot) is the 
+  Slack-provided library for working with the Slack API and 
+  [WebSockets](/websockets.html) connection.
+
+* [slack-starterbot](https://github.com/mattmakai/slack-starterbot)
+
+* [slack-api-python-examples](https://github.com/mattmakai/slack-api-python-examples)
+  contains the example code from several Slack bot blog posts.
+ 
+* [slackbot](https://github.com/lins05/slackbot) another popular
+  Slack bot implementation.
diff --git a/content/pages/meta/00-change-log.markdown b/content/pages/meta/00-change-log.markdown
@@ -16,6 +16,9 @@ on GitHub.
 
 ## 2018
 ### December
+* Updated [SQLAlchemy](/sqlalchemy.html), [NoSQL](/no-sql-datastore.html),
+  [MongoDB](/mongodb.html) and [Slack API](/slack.html) pages with
+  new descriptions and resources.
 * Updated the [serverless](/serverless.html), 
   [operating systems](/operating-systems.html) and
   [HTTPS](/https.html) pages with a bunch of new resources.
