Lesson 01: Introduction and Submitting Homework

This is for chapter 1 of Learning MySQL – it’s only pages 3-8, so it is an easy one!

Homework for this week: How to Submit Homework

Notes/errata/updates for Chapter 1:
The book mentions MySQL AB, the company behind MySQL. Since the book was written, MySQL was acquired by Sun, and then Sun was acquired by Oracle. (see http://ift.tt/1yteR9A­ for the timeline).

Topics covered:
MySQL History
Why MySQL is popular
Submitting Homework

Reference/Quick Links for MySQL Marinate

via Planet MySQL
Lesson 01: Introduction and Submitting Homework

How to Submit MySQL Marinate Homework

We will be submitting the homework via GitHub. The reason for this is to have a centralized place for homework, as well as teaching how to use a revision control system and how to interact specifically with GitHub.

Reading:
Learn about git at http://ift.tt/Y1XtW1 (You only need to read this one webpage, no need to go to the next page)

To do:
– Create a github account at www.github.com if you do not already have one.
– Install and configure git on your local machine as per http://ift.tt/W0viGn
– Fork the MySQL Marinate repo as per http://ift.tt/VSDl4q
The URL for the MySQL Marinate repo is http://ift.tt/2vIxmYY

– To demonstrate that you can submit homework, open and modify the 01Intro/homework.txt file
– Then commit your work locally:
git add 01Intro/homework.txt
git commit

– When you’re done, commit your work up to the github server:
git push origin master

When doing homework, remember to commit locally often. I would recommend committing up to the github server whenever you finish a question or a part of a question. Pretend at any time your local machine may die; how much work are you willing to lose? (5 minutes’ worth? 3 days’ worth?) I do not look at individual commits, only the final pull request when you’re done.

When you’re done with your homework, submit a Pull Request as per http://ift.tt/QITIBk

If you have trouble and need help, ask away in the comments!

Reference/Quick Links for MySQL Marinate

via Planet MySQL
How to Submit MySQL Marinate Homework

Watch: DIY Pressurized Solar Water Heater & Shower System

So you want a portable shower solution that will provide good water flow and warm water when you’re away from civilization? Well, you could pony up hundreds of bucks or you could settle for a plastic bag… or you could build your own, which is just what this guy did. In the end he has a nice solar-heated tank that rides atop his vehicle, which he can pressurize using a small portable air compressor. Add a short water hose with a spray nozzle, and you are in business.

The tools and materials he used are all pretty basic and should be easy to get. The only real snag I see would be when the water level gets low, a small compressor would have to work pretty hard to pressurize that big tube… but as Dad used to say, that’s a minor detail. Overall it looks like a great solution.

Check it out and let us know what you think:

The post Watch: DIY Pressurized Solar Water Heater & Shower System appeared first on AllOutdoor.com.

via All Outdoor
Watch: DIY Pressurized Solar Water Heater & Shower System

Rural America Is Building Its Own Internet Because No One Else Will

New submitter bumblebaetuna writes: In many cases, it’s not financially viable for big internet service providers like Comcast and CharterSpectrum to expand into rural communities: They’re not densely populated, and running fiber optic cable into rocky Appalachian soil isn’t cheap. Even with federal grants designed to make these expansions more affordable, there are hundreds of communities across the US that are essentially internet deserts — so many are building it themselves. But in true heartland, bootstrap fashion, these towns, hollows — small rural communities located in the valleys between Appalachia hills — and stretches of farmland have banded together to bring internet to their doors. They cobble together innovative and creative solutions to get around the financial, technological, and topological barriers to widespread internet.



Share on Google+

Read more of this story at Slashdot.

via Slashdot
Rural America Is Building Its Own Internet Because No One Else Will

Why Driving Through Six Inches of Water Can Blow Your Engine Up

Parts of Texas are currently experiencing record-breaking levels of flooding brought on by Hurricane Harvey. One of the people who died as a result was reportedly trying to drive her car through a flooded area. The car stalled, the woman became trapped inside as the car filled with water and she subsequently drowned.

It would seem common sense that one oughtn’t drive an automobile through a heavily flooded area. But did you know that driving your car through as little as six inches of water can lead to your engine throwing a connecting rod? Here mechanic Scotty Kilmer explains and demonstrates why:


via Core77
Why Driving Through Six Inches of Water Can Blow Your Engine Up

Watch: 5th Generation GLOCK 17 and 19

James over at the Firearm Blog put together an excellent video detailing features of the new 5th generation Glock 17 and 19.  In typical James fashion, he does an excellent job explaining the upcoming changes.

If you would rather read than watch a video, Ron Gunner wrote about the new 5th generation Glcok in this article – GLOCK Spills Details on the New Gen5 Pistols.

Glock should officially announce the new 5th generation on Wednesday, August 30th.

Starting at 2:00, James talks about mean stoppages between rounds. Part of the Modular Handgun System tests was to go 12,000 rounds with no more than one stoppage every 2,000 rounds.  The only handguns to pass that part of the MHS tests were Glock and Sig.

According to Glock, the Gen 5 handguns can go more than 30,000 rounds with better than one stoppage every 2,000 rounds.

Let’s put that into perspective.  In the 1980s during the M9 contract tests, the Beretta M9 had one stoppage in 35,000+ rounds. Source: Shooting Times, January 1990, page 52.

Glock using 2,000 rounds between failures as a selling point, would be comparable to your Ford getting 35 miles a gallon in the 1980s, then your Chevy getting 2 miles a gallon in 2017, and you bragging about how great the Chevy gas mileage is in 2017.

The orange magazine follower is a nice change.

On a personal note, I have never been a big fan of Glock.  However, for some reason, I like the changes of the 5th generation.  What I really want to know, where can I buy a MHS Glock model?

Special thank you to James for making another great video.  Keep up the great work.

The post Watch: 5th Generation GLOCK 17 and 19 appeared first on AllOutdoor.com.

via All Outdoor
Watch: 5th Generation GLOCK 17 and 19

Sami Inkinen on his bold plan to cure type 2 diabetes forever

Sami Inkinen founded and then exited Trulia about a year after Zillow snapped it up for $3.5 billion in 2014. He’s since moved on to build Virta, a health care startup claiming it can cure type 2 diabetes.

It’s a bold claim. Most treatment plans offer to help those with the disease manage it, not get rid of it. But Inkinen, with zero medical background, believes he’s found a way to wholly eradicate diabetes for good.

The secret is as simple as a low-carb diet.

It seems pretty obvious — cut out the sugar and bad carbs and your diabetes will get better. But that’s easier said than done with humans. Inkinen tells me he’s learned through time where the pain points are and what people need to truly succeed.

So far Virta has conducted a small trial involving 262 people and the results seem promising. A majority (91 percent) of those participating finished the program and 87 percent of them either reduced their dosage or went off their insulin, says the startup. Over half of the participants were able to reduce at least one of their diabetes medications.

I sat down with Inkinen to talk about his company and why he decided to jump into the health care space after his success in the real estate field.

Founder Sami Inkinen relaxing in the Virta office space in downtown San Francisco.

 

SB: That’s a bold claim that you’re making that you can cure diabetes. 

SI: Yeah totally…Without tech you can’t do Virta.

We’re not just a software company, we’re a software company that combines biochemistry and science to cure the disease. If one of those is wrong it’s not going to work.

SB: Do you worry you tell them a bit too early to get off their medications? 

SI: Yeah, that’s precisely the reason why we have our own doctors. That’s precisely the reason why we have a full-stack health care company…It’s absolutely critical that we get this data very, very rapidly so we can start adjusting them off of meds. If we don’t get people off the meds quickly and accurately, it’s actually dangerous for the patients. When you’re diabetic your blood sugar runs high. You take drugs, you get it down. If we can get your blood sugar down naturally and then you take drugs on top of that you’re going to be in the ER.

SB: Insurance companies, are you working with them? 

SI: Well, they are excited because they can save costs. In America, each state we have who pays your health care. It’s either your employer if you’re at a large company, and most companies will cover it. So we sell both to employers.

SB: Okay, but this just sounds like a diet. 

SI: It sounds very simple. Like, oh carbs are bad throw the carbs out. Yes, but it gets more nuanced. How do you do it in a way that you can reverse the type 2 diabetes and do it in a way that’s very sustainable and you feel good about it? Because you know if you’re eating bagels and bread all the time and I say just stop doing that, you feel horrible and you don’t want to do that.

It’s absolutely necessary to deliver results. The traditional approach is that it’s overweight or obesity that causes diabetes. Therefore all we have to do is help people lose weight. But, it’s a combination of tech and how we track the markers and the right science nutritionally.

SB: Is that proprietary software that you’re using?

Latest Crunch Report

SI: Yeah, we build everything in house… After the doctor makes all the clinical decisions about the patient, and so forth, what he’s looking at is basically a data pool of all the patients every day, several times a day. When he sees the data, he see’s that drug for that patient needs to go off.

SB: Couldn’t anyone look at it and say, “Oh, I can replicate this program?” 

SI: Well it has the IP. The IP is in two places. One is the protocol that we use, which drives high participation and the results. It’s not trivial. It really has to be highly individualized. Whether it’s food or what you do or how you choose medications, it’s nothing one-size fits all. Every person is different. That’s the first one.

The second one is this entire system where we collect data and data improves the protocols, this kind of cycle. The more data we have the better the protocol, the better the treatment, the more we can automate, the more efficient we can be.

The way we use software and AI for the benefit of doctors is we basically give them superpowers. We can read all that data on a real-time basis every day of every second and then tell our patients, “Okay, Wilma she needs attention. Her, whatever medication she might be on, needs to be reduced.”

SB: How do you do that?

SI: What we try to do is take thinking out of the picture for the patients. Every morning that you wake up you have a task to complete. Whether that’s tracking related, changing your nutrition, or some behavior change, or something else. We basically stitch together a personalized care plan for each patient based on what’s their background and what’s happening to them.

You may have heard the Center for Disease Control, CDC, has a diabetes prevention program, which is really a weight loss program. It’s basically 16 educational modules over 16 weeks…It’s kind of like the diet approach, the cookie-cutter approach. You want to do the South Beach Diet, buy the South Beach Diet book and you get the 50 foods that we should eat and the 50 foods you shouldn’t.

You can’t be successful in curing someone’s health if you have a one-size fits all approach.

SB: You got involved because you were pre-diabetic.

SI: I was on my way, yes. I was pre-diabetic. You may remember, I’ve got a company called Trulia, which just happens to be in this building. Once Trulia went public, I just stayed on the board and I stepped away from an operational role.

I thought maybe I’ll start competing and I won the Ironman World Championships in my age group.

(Inkinen has been a competitive triathlete since 2007).

SB: Really?

SI: I was like wow, this is freaking awesome. Then I found out that I was pre-diabetic.

SB: Even after you were very active and athletic?

SI: That was my moment of truth, if you will. I thought, it doesn’t make any sense. What we are telling people to do, the message to pre-diabetics today in America is “Don’t you worry. You’re getting fit but you have to eat a little less, eat a little healthier and exercise a little more everything will be just fine.” Well I had been doing that freaking 20 years.

SB: Mm-hmm.

Crunchbase

    • Founded
      2004
    • Overview
      Trulia is an online real estate platform providing information on properties and real estate professionals for home buyers, sellers, owners, and renters.

      Trulia has enabled its users to get information about the areas that people want to live and they can also learn about agents, neighbors, schools, crime, commute times, and ask the local community questions.

      Through Trulia’s hyper …

    • Location

      San Francisco, CA
    • Categories

      Internet, Rental, Mobile Apps, Real Estate
    • Founders
      Sami Inkinen
    • Website

      http://trulia.com
    • Full profile for Trulia

SI: That was the turning point for me. I started reading research and that’s what kind of led me to meet my scientific co-founders. The bottom line, what these guys had shown is that there is a way to nutritionally reverse type 2 diabetes without starving you to death. They had published all these papers. I was like this is nuts. This is 30 years-old science.

I said the key that’s missing here is we don’t have the tech to deliver this, the continuous outpatient services. That was the catalyst for Virta.

Then we kind of built the protocol, built the first product, and then the key step for me was I said we don’t want to be another Theranos. In health care, maybe we’re just shrinking our own pool, but we have to run a clinical trial. If this works, this is going to be absolutely huge.

SB: If an employer wants to get involved with your program, do they just contact you?

SI: Call us up, through our website, and also of course we have our sales as well…Our business model is, if we don’t reverse diabetes we don’t want to be paid.

SB: When you’re saying that you cure it, do you mean that if they switch back to the same old diet they wouldn’t have diabetes?

SI: Well type two diabetes is not an acute, like broken bones and then the bone is fixed and then it’s not broken anymore.

Type 2 diabetes can be reproduced in any one patient. Of course, the subtle lifestyle changes have to last and that’s why you want to show that once you cure the disease it actually stays in remission.

SB: What’s the individual cost?

SI: It’s about $400 a month. Then low-income people we have patients that use a program that keeps them with access.

SB: So, if the drugs are $500 and this is $400…

SI: Yeah so that’s the average cost of diabetic medicine in America.

SB: Do they have to stay on the program for life? $400 a month for life?

SI: It’s one year minimum and then the second year is up to your choice. Whether you need our support or not.

SB: What’s next?

SI: There’s a couple of big things coming out. One is the one-year results (now out at the time of publishing). That’s one huge thing for us…We can make powerful claims like “Hey, the reversal rate is this much, how much we saved money, this is how many lives we saved. These are the results.”

Then the second thing that we’re focused on is just scaling with employers, insurance companies, and patients directly. Letting them know that this works.

via TechCrunch
Sami Inkinen on his bold plan to cure type 2 diabetes forever