SQL

Configure relational databases, brush up on your query language syntax, or find third-party services to interact with your data.
Roundup
19 Jun 2018

Lynx Roundup, June 19th

Daily roundup of Data Science news around the industry, 6/19/2018.
Lynx Roundup, June 19th

https://www.cybertec-postgresql.com/en/index-decreases-select-performance/

https://dsweb.siam.org/The-Magazine/Article/topological-data-analysis-1

https://github.com/DistrictDataLabs/yellowbrick

Continue Reading
Python
15 Jun 2018

Using PyMySQL: Python's MySQL Library

The lightweight Python library for interacting with MySQL.
Using PyMySQL: Python's MySQL Library

It's almost Friday night, and the squad at H+S is ready to get cooking. Dim down the lights and slip into something more comfortable as we take you on this 100% organic flavor extravaganza. Tonight's menu? A Python MySQL library: PyMySQL.

PyMySQL is lightweight and perfect for fulfilling MySQL queries. If you want bells and whistles, you're probably barking up the wrong tree (and you probably should’ve used a DB other than MySQL in the first place).

Why write tutorials for technologies we openly trash talk? Out of necessity, of course! There's nothing wrong with MySQL, most enterprises

Continue Reading
Roundup
15 Jun 2018

Lynx Roundup, June 15th

Daily roundup of Data Science news around the industry, 6/15/2018.
Lynx Roundup, June 15th Continue Reading
Roundup
04 Jun 2018

Lynx Roundup, June 4th

Daily roundup of Data Science news around the industry, 6/4/2018.
Lynx Roundup, June 4th Continue Reading
MySQL
22 Apr 2018

Accessing Self-Hosted MySQL Externally

Connecting to MySQL instances hosted on a VPS.
Accessing Self-Hosted MySQL  Externally

In the previous post, we got familiar with the basics of creating and navigating MySQL databases. This leads us to the next most logical thing to ask: how can I use this in any meaningful way?

MySQL installations default to refusing connections outside of the local machine's IP address, as we should expect. That said, relational databases aren't usually being used by a single person on a single machine forever (but if you do, we should hang out). It goes without saying that our MySQL instance should be focusing on uptime and accessibility, or in other terms, far away from

Continue Reading
MySQL
17 Apr 2018

Setting up a MySQL Database on Ubuntu

Setting up MySQL the old-fashioned way: on a Linux server.
Setting up a MySQL Database on Ubuntu

As frameworks and services evolve to remove us further away from boilerplate code, the first casualty of saved time is the fundamental understanding of what we're actually doing sometimes. This has good reason; one can only learn so much from repetitive command-line interactions with databases, thus making any service's one-click-deploy button all the more sensible.  If I  had to imagine the least sexy title for a post in software development, it would be something along the lines of How to Configure MySQL on a VPS, as opposed to like, a cloud-based solution, or Even a Docker Container, as Though we

Continue Reading