new microservices and bokeh resources

mattmakai · mattmakai · commit 6cd3ec97b30a · 2019-02-01T21:19:21.000Z
diff --git a/content/pages/03-data/00-data.markdown b/content/pages/03-data/00-data.markdown
@@ -86,6 +86,13 @@ and [data visualization](/data-visualization.html) pages.
   combines earthquake data with questions around earthquake recurrence
   probabilities to tell its story.
 
+* [Data Science Project: Profitable App Profiles for App Store and Google Play](https://www.dataquest.io/blog/basic-data-science-portfolio-project-tutorial/)
+  is a tutorial that shows you how to use iOS and Android app store data
+  for business analysis. This post is part of a larger series on 
+  [how to get your first job as a data scientist](https://www.dataquest.io/blog/how-to-get-your-first-data-science-job/)
+  which is all worth your time reading to understand the intersection of
+  working with data to figure out its value to companies sand organizations.
+
 
 ### Example data sets
 Looking for freely-available data to use in your projects but aren't 
diff --git a/content/pages/03-data/04-sqlite.markdown b/content/pages/03-data/04-sqlite.markdown
@@ -104,6 +104,9 @@ tutorials will help you get started.
   provides another beginner's tutorial using the built-in `sqlite3`
   Python standard library module.
 
+* [A SQLite tutorial with Python](https://stackabuse.com/a-sqlite-tutorial-with-python/)
+  covers both SQL and Python code to interact with SQLite.
+
 
 ### Specific SQLite scenarios
 These are solid resources if you are looking to solve a particular problem 
@@ -118,6 +121,11 @@ you are having with SQLite rather than going through a general tutorial.
   SQLite instead of porting to another relational database such as 
   [MySQL](/mysql.html) or [PostgreSQL](/postgresql.html).
 
+* This overview of SQLite as part of the 
+  [Databaseology Lectures](https://www.youtube.com/watch?v=gpxnbly9bz4)
+  is amazing because they are given by the creator and he shines a ton
+  of light on how SQLite is built and why.
+
 * [How SQLite is tested](https://www.sqlite.org/testing.html) digs into the
   nitty-gritty behind the quality assurance practices for testing potential
   SQLite releases.
@@ -148,3 +156,15 @@ you are having with SQLite rather than going through a general tutorial.
   covers how to control access to the SQLite database connection and
   file even though SQLite normally allows unauthorized access by design.
 
+* [Can I read and write to a SQLite database concurrently from multiple connections?](https://stackoverflow.com/questions/10325683/can-i-read-and-write-to-a-sqlite-database-concurrently-from-multiple-connections)
+  answers one of the concerns that was an issue in earlier versions of
+  SQLite that could have issues if more than one connection was writing
+  to the database at one time.
+
+* [Appropriate uses for SQLite](https://sqlite.org/whentouse.html) is an 
+  official documentation page that explains what types of applications
+  are designed to work well with SQLite as the backend.
+
+* [How to corrupt a SQLite file](https://sqlite.org/howtocorrupt.html) 
+  explains how the database file could potentially get corrupted if you
+  really work at screwing it up.
diff --git a/content/pages/03-data/07-peewee.markdown b/content/pages/03-data/07-peewee.markdown
@@ -124,3 +124,10 @@ Python applications.
   with Peewee. This library is worth watching if you use an async 
   [web framework](/web-frameworks.html) and want to have Peewee serve as your
   application's ORM.
+
+* [Accessing remote MySQL database with peewee](https://stackoverflow.com/questions/16448198/accessing-remote-mysql-database-with-peewee)
+  debugs a question where the original author had issues accessing a remote
+  [MySQL](/mysql.html) database because they did not properly include the
+  `Model` class from 
+  [peewee.py](https://github.com/coleifer/peewee/blob/master/peewee.py)
+  when instantiating a mapper class.
diff --git a/content/pages/03-data/08-django-orm.markdown b/content/pages/03-data/08-django-orm.markdown
@@ -15,7 +15,7 @@ that can be used to interact with application [data](/data.html) from various
 [relational databases](/databases.html) such as [SQLite](/sqlite.html),
 [PostgreSQL](/postgresql.html) and [MySQL](/mysql.html).
 
-<a href="https://docs.djangoproject.com/en/dev/topics/db/" style="border: none;"><img src="/img/logos/django.png" width="100%" alt="Official Django logo. Trademark Django Software Foundation." class="technical-diagram"></a>
+<a href="https://docs.djangoproject.com/en/dev/topics/db/" style="border: none;"><img src="/img/logos/django.png" width="100%" alt="Official Django logo. Trademark Django Software Foundation." class="shot"></a>
 
 
 <div class="well see-also">The Django ORM is an implementation of the <a href="/object-relational-mappers-orms.html">object-relational mapping (ORM)</a> concept. Learn more in the <a href="/data.html">data</a> chapter or view <a href="/table-of-contents.html">all topics</a>.</div>
diff --git a/content/pages/03-data/12-mongodb.markdown b/content/pages/03-data/12-mongodb.markdown
@@ -63,6 +63,11 @@ command line and query language.
   covers schema design, replication lag, resource provisioning and query
   efficiency.
 
+* [Getting Started With Google Cloud Functions and MongoDB](https://thecodebarbarian.com/getting-started-with-google-cloud-functions-and-mongodb.html)
+  shows how to connect Mongo with a 
+  [Google Cloud Function](/google-cloud-functions.html) 
+  to store persistent data while running on a serverless platform.
+
 
 ### MongoDB security
 NoSQL databases can be a weak spot in a production deployment environment,
diff --git a/content/pages/03-data/15-data-analysis.markdown b/content/pages/03-data/15-data-analysis.markdown
@@ -109,3 +109,10 @@ libraries from scratch.
   uses a 
   [Google BigQuery Python helper library](https://github.com/SohierDane/BigQuery_Helper/blob/master/bq_helper.py)
   to work with a massive 3 terabyte data set provided by GitHub.
+
+* [Cleaning and Preparing Data in Python](https://towardsdatascience.com/cleaning-and-preparing-data-in-python-494a9d51a878)
+  shows how to uses [pandas](/pandas.html) to do the "boring" part of
+  a data analysis job and convert dirty data into a more consistent,
+  structured format.
+
+
diff --git a/content/pages/03-data/19-bokeh.markdown b/content/pages/03-data/19-bokeh.markdown
@@ -108,3 +108,7 @@ basic syntax will change as the library's API is not yet stable.
   although the web application only contained a single type of data 
   visualization so it is hard to drawn any real conclusions from his
   opinion.
+
+* [Realtime Flight Tracking with Pandas and Bokeh](https://www.geodose.com/2019/01/realtime-flight-tracking-pandas-bokeh-python.html)
+  provides a great example of combining [pandas](/pandas.html) for structuring
+  data with Bokeh for visualization.
diff --git a/content/pages/04-web-development/45-microservices.markdown b/content/pages/04-web-development/45-microservices.markdown
@@ -99,3 +99,6 @@ ease further development and deployment. This approach is called the
   [Using Netflix Zuul to Proxy your Microservices](https://blog.heroku.com/using_netflix_zuul_to_proxy_your_microservices)
   to learn more and get started using it.
 
+* [The Majestic Monolith](https://m.signalvnoise.com/the-majestic-monolith/)
+  explains the advantages of a monolithic architecture and how it's worked
+  amazingly well for the Basecamp small development team.
diff --git a/content/pages/05-deployment/41-google-cloud-functions.markdown b/content/pages/05-deployment/41-google-cloud-functions.markdown
@@ -27,3 +27,12 @@ alternative until Google Cloud Functions supports Python.
 * [Microsoft Azure Functions vs. Google Cloud Functions vs. AWS Lambda](http://cloudacademy.com/blog/microsoft-azure-functions-vs-google-cloud-functions-fight-for-serverless-cloud-domination-continues/)
   gives an overview of these three serverless cloud platforms and
   compares their current capabilities.
+
+* [Getting Started With Google Cloud Functions and MongoDB](https://thecodebarbarian.com/getting-started-with-google-cloud-functions-and-mongodb.html)
+  explains how to connect a
+  [Google Cloud Function](/google-cloud-functions.html) to a persistent
+  [MongoDB](/mongodb.html) data store.
+
+* [Running End to End tests as Google Cloud Functions](https://hackernoon.com/running-end-to-end-tests-as-google-cloud-functions-f5e34ffc3984)
+  provides the code and a walkthrough for running a headless Chrome 
+  instance in a serverless Cloud Function to perform browser-based tests.
