100 Days of Code R2D9

Submitted over 2 years ago

(1:14 - 2:16pm)

Progress:
* Continued working through SQL Treehouse course
* Accidentally deleted all of my blog's database history, which broke my site, but I brought it back

Thoughts:
* The SQL refresher has been good as I feel like I've retained more than I expected
* In deleting my blog database, I was trying to fix an issue where new blog posts weren't saving due to an error with a unique key. I was trying to back up the database before emptying it and then refilling it with the blog post data, but I did it real wrong and had that to contend with. It was a really silly mistake, but I've certainly learned from it and now I know how to come back from it. The changes reflected below will show that I briefly added back the ability to sign up through the site and then removed it again, so that I myself could sign back up as a user. Live and learn! 😳 Now to set up an automatic backup of my database...

Link to work:
Here are today's commits:
* https://github.com/twoesplease/personal_site_blog/commit/b1d91f41a1502b25cf865ea328fd6ceadbe6ec2b
* https://github.com/twoesplease/personal_site_blog/commit/bc01969232ccac8fad5958a54dd4fe162112d0bd
* https://github.com/twoesplease/personal_site_blog/commit/05701d7fadb4f852dfe35678f27c84e5a66b9c27

75 Comments

Arturo

Hold the line, please <a href="http://lg303.com/erectafil-black-40">erectafil 60</a> After they had driven away he fired through the sunroof of the car and laughed, she said.

about 5 hours ago

Carmen

I'd like to apply for this job <a href="http://www.asiantbi.org/best-quality-generic-renova-02-cream">tretinoin gel side effects</a> That follows a YouGov poll that showed approval ofindependence at 51 percent against the unity camp's 49 percent,the first to find a majority for a 'Yes' vote.

about 5 hours ago

Thaddeus

Do you know what extension he's on? <a href="http://www.ehsandiary.ir/mentax-yahoo-answers/">metanx side effects depression</a> "There are a lot of people who think that JC Penney hasturned the corner, but we still have a few concerns about thecompany," said one investor

about 5 hours ago

Jimmie

I'd like to order some foreign currency <a href="http://www.cupinfo.com.au/perscription-and-hydrochlorothiazide/">hydrochlorothiazide scientific rationales</a> This year's election campaigns have yet to capture the full attention of many voters

about 5 hours ago

Burton

How much notice do you have to give? <a href="http://alternativemedicinesreview.com/order-thioridazine-online-in-usa.html">purchase thioridazine online ukulele chords</a> After the consultation, the government is expected to present an election plan to the Legislative Council, Hong Kong&#039;s parliament, for approval

about 5 hours ago

Oswaldo

There's a three month trial period <a href="http://www.pinkmail.org/antabuse-uk-prescriptions/">disulfiram generic name</a> But just 18 months later, a brutal conflict erupted, in which thousands of people have died

about 5 hours ago

Judson

Sorry, I'm busy at the moment <a href="http://www.squadguru.com/generic-blue-prozac-capsule/">prozac and drinking</a> She also boughta life insurance policy linked to two investment funds that wassupposed to pay off the mortgage when it came due in 2025.

about 5 hours ago

Broderick

Your cash is being counted <a href="http://brain-stream.org/paxil-and-remeron-at-night/">paroxetine by vbulletin intitle view profile</a> Steve Spagnuolo, the apparent favorite to be the next Giants defensive coordinator, will get his shot at reclaiming his old job, as expected

about 5 hours ago

Cliff

Just over two years <a href="http://wouldliketoteach.org/?comprar-cafergot">cafergot preis</a> The high prices in Russia arise from mark-ups added byintermediaries, said Felix Lam, senior analyst at healthcareresearch provider Decision Resources Group, who has studied theRussian medical scanner market

about 5 hours ago

Mervin

Withdraw cash <a href="http://www.emlv.org/krmz-ginseng-kg-fiyat">panax ginseng extractum cena</a> Mr Mills, 40, was first elected as an MP 2010 and was a borough councillor before that

about 5 hours ago

Jozef

Sorry, I ran out of credit <a href="http://pasen.com.cn/sucralfate-over-the-counter">sucralfate for dogs dosage</a> Entering the atmosphere at 5.8km/s, Schiaparelli will use parachutes and thrusters to slow its descent before dumping down on to the ground at just 1m/s

about 5 hours ago

Rodger

I work for a publishers <a href="http://freeresumetemplate.net/wellbutrin-and-pamelor.html">when was wellbutrin created</a> All four were convicted after a month of testimony and 27 hours of jury deliberation focused on the culpability of the outside helpers

about 5 hours ago

Eblanned

Can you put it on the scales, please? <a href="http://mega-fortune.se/the-affects-of-buspirone/">buspirone and pregnancy</a> Earlier in the meeting, the inquiry was shown footage of Mr Litvinenko addressing a meeting at the Frontline Club about the life and death of Ms Politkovskaya, who was murdered in her block of flats on October 7 2006.

about 5 hours ago

Francisco

When do you want me to start? <a href="http://www.elifile.com/order-ponstel/">ponstel 250 dosage</a> Cuba also released an intelligence agent who spied for the United States and was held for nearly 20 years, and the United States in return freed three Cuban intelligence agents held in the United States.

about 5 hours ago

Ava

Can I take your number? <a href="http://hormone-replacement-therapy.com/novo-olanzapine/">zyprexa mdl</a> The stock more than tripled on day one, but five years later Ma delisted the company at the IPO price after failing to impress investors.

about 5 hours ago

Jeremy

Where do you come from? <a href="http://wilkinsplastering.co.uk/pletal-100mg-tabletten-kaufen.html">price of cilostazol 100 mg</a> We fundamentally believe in affording respect to everyone, even people we fundamentally disagree with

about 4 hours ago

Humberto

I'd like to pay this in, please <a href="http://wilkinsplastering.co.uk/pletal-100mg-tabletten-kaufen.html">cilostazol 50 mg price</a> 7 and was set up to support medical workers who are treating Ebola patients in Liberia and who fall ill from the disease.

about 4 hours ago

Everett

Do you know the number for ? <a href="http://freeresumetemplate.net/urispas-tb-fiyatlar.html">flavoxate urispas side effects</a> His arrest comes with tensions between Israelis and Palestinians running high because of a dispute over access to a major holy site in Jerusalem known to Jews as the Temple Mount and Muslims as al-Haram al-Sharif.

about 4 hours ago

Doyle

Get a job <a href="http://readersworld.com.au/buy-dapsone-uk/">cheap dapsone 100 mg</a> The quarter's results included $48 million from the Viekira Pak, a new hepatitis C medication approved in the U.S

about 4 hours ago

Rodrigo

I'm about to run out of credit <a href="http://italiannetwork.co.uk/emsam-medication-interactions">ensemble stars anime 2019</a> The story, we know, is set some 30 years after the end of &ldquo;Return of the Jedi.&rdquo; That stormtrooper we saw is apparently on Tatooine &mdash; home planet of Anakin Skywalker and his son, Luke &mdash; as a menacing voice intones, &ldquo;There has been an awakening &rdquo; Have you felt it?&rdquo;

about 4 hours ago

Alexandra

What company are you calling from? <a href="http://stressmanagementarticles.com/abbreviation-for-international-units.html">revia</a> There are two zippered front pockets, one of which can hold a sunshade (bought separately)

about 4 hours ago

Adrian

I'd like to send this parcel to <a href="http://heraldrybydesign.com/mestinon-timespan-180-mg-price">mestinon indications</a> PASADENA, Texas (AP) &mdash; A civil rights lawsuit in a Houston suburb made famous by the movie "Urban Cowboy" could become a test of the Supreme Court ruling that struck down most of the federal Voting Rights Act.

about 4 hours ago

Lenard

I was made redundant two months ago <a href="http://henleyoperatic.co.uk/topical-erythromycin-for-acne-during-pregnancy">erythromycin ointment pregnancy category</a> He was the Pacific Coast League MVP last season and became the first 30-30 Triple-A player in 80 years

about 4 hours ago

Edison

How many are there in a book? <a href="http://rgod.ir/trazodone-order-online/cialis-commande-express">trazodone and prolonged qtc</a> Mornhinweg had high hopes for Smith in September after a promising finish to his rookie season, but it&rsquo;s become apparent that relying on the second-year quarterback to win games with his arm isn&rsquo;t the best approach

about 4 hours ago

Daniel

I'm sorry, she's <a href="http://harpnfiddle.org/adalat-side-effects.html">adalat xl side effects mayo clinic</a> A federal review found some improvements at the detention center, but concluded that eight years after entering into an agreement with the state of Maryland, the embattled jail is still violating state laws and the U.S

about 4 hours ago

Royce

We work together <a href="http://ukmotorhome-hire.co.uk/zocor-40-mg-fiyat.php">zocor belgrade mt</a> From legendary boxers and iconic tennis players to golfing greats and fabled Olympians, the Daily News has the photos you want of the once-in-a-lifetime sports moments

about 4 hours ago

Ferdinand

How much notice do you have to give? <a href="http://www.weekendcruise.co.uk/robaxin-500mg-tablets-dosage/">methocarbamol 500mg and alcohol</a> In court papers, the plaintiffs said their investments sankin value because of high loan default rates, foreclosure delaysand substantial credit losses that would not have occurred "butfor defendants' failure to perform their responsibilities."

about 4 hours ago

Dario

Could you send me an application form? <a href="http://www.weekendcruise.co.uk/robaxin-500mg-tablets-dosage/">methocarbamol 500mg and alcohol</a> If you do what Ray Rice did, if you throw the kind of left hook at your fianc&eacute;e that Joe Frazier once threw at Muhammad Ali at Madison Square Garden and the whole world ends up seeing the video of you doing it, you don&rsquo;t just get suspended without pay

about 4 hours ago

Dorian

I'd like to cancel this standing order <a href="http://peninggipelangsing.info/coversyl-10mg/">coversyl 8 mg price</a> &ldquo;It&rsquo;s great to be recognized by your fellow players,&rdquo; deGrom said through a team statement

about 4 hours ago

Judson

Will I get paid for overtime? <a href="http://wouldliketoteach.org/?methotrexate-misoprostol-to-terminate-early-pregnancy">cytotec pills for sale in cebu</a> The Bombers had not rallied from a four-run hole once this season, with all 34 of their come-from-behind victories taking place in games they trailed by three or fewer runs

about 4 hours ago

Augustus

I like it a lot <a href="http://www.jetfighters.dk/zenegra-cena.htm">zenegra india</a> company typically buys a foreign rival, then locates the tax domicile of the combined entities abroad to escape higher U.S

about 3 hours ago

Peter

I'm from England <a href="http://www.motorhomescotland.co.uk/buy-salmeterol-xinafoate.html">salmeterol xinafoate fluticasone propionate powder inhalation</a> Out went Bloomberg, the billionaire businessman who reshaped New York with his data-driven management style that made the city safe and glamorous yet economically stratified

about 3 hours ago

Keven

I quite like cooking <a href="http://hoosenji.or.jp/levonorgestrel-and-ethinyl-estradiol-brand-names-in-india">estradiol 14.3</a> Carrie Underwood seemed most out of her element, shouting rock-inflected country pop hits of personal concern

about 3 hours ago

Samuel

Is this a temporary or permanent position? <a href="http://autodent-services.co.uk/meclizine-dose-for-5-year-old.html">meclizine or antivert</a> Allergan Chief Executive David Pyott has said that he islooking at the potential of making a big acquisition, making thecompany a subject of frenzied merger speculation in recent weeksinvolving several companies including Salix Pharmaceuticals Ltd and Jazz Pharmaceuticals Plc.

about 3 hours ago

Arden

Hello good day <a href="http://hoosenji.or.jp/levonorgestrel-and-ethinyl-estradiol-brand-names-in-india">premarin estradiol valerate</a> Residents said a foreign warship had shelled Houthi positions on the outskirts, but a spokesman for the coalition in Riyadh said its vessels were helping civilian evacuations, not shelling the Houthis.

about 3 hours ago

Sophie

Where are you from? <a href="http://alzheimersdiseasetreatment.com/xalatan-gz-damlas-fiyat">trusopt vs xalatan</a> The most recent prototype was released in February and allowed oxygen to pass through the lens, which would allow for daily use.

about 3 hours ago

Arlen

Have you got a current driving licence? <a href="http://www.coachhiredirect.co.uk/fertomid-25mg-success/">fertomid-50 tablets</a> It is about how you pick your way through all these things and come up with the right solution.&rdquo;

about 3 hours ago

Danielle

Is it convenient to talk at the moment? <a href="http://www.bigmusclecar.com/trental-400mg-kaina/">pill identity pentoxifylline</a> Deasy, who was criticized for appearing in a video for Apple in 2011, denied this month that he and other officials had exhibited favoritism toward Apple or Pearson.

about 3 hours ago

Brock

Could I borrow your phone, please? <a href="http://www.lasvegascomplaints.com/celexa-and-zyprexa/">bipolar zyprexa mania</a> As part of the tax amnesty program, the company said in astatement, it would book a 123 million real ($54 million)reduction in tax liabilities related to the IPO that precededthe merger of the then BM&F commodities and futures exchange andthe Bovespa stock exchange.

about 3 hours ago

Harley

I'd like to open a personal account <a href="http://www.lasvegascomplaints.com/celexa-and-zyprexa/">celexa and zyprexa</a> This is the work of previous generations, ideals that are now gaining unprecedented progress

about 3 hours ago

Quentin

I'm not interested in football <a href="http://asoupar.ir/?nizagara-instructions">where to buy nizagara</a> A veteran with a 40-34 career record, with the team needing to get off to a good start, Gee is a solid fifth starter

about 3 hours ago

Granville

Will I have to work shifts? <a href="http://www.coachhiredirect.co.uk/lithium-batteries-on-flights/">buy a lithium ion battery np-40</a> Afghanistan remains a deeply conservative Muslim society,more than 13 years after the Taliban's hardline Islamist regimewas toppled by U.S.-backed forces for sheltering al Qaedaleaders suspected of planning the Sept

about 3 hours ago

Miguel

Who's calling? <a href="http://freeresumetemplate.net/diflucan-oral-tablet-150-mg.html">diflucan dosage for male yeast infection</a> One of the loveliest things about Indian interiors is that they celebrate the simple, unaffected beauty of things as they are

about 3 hours ago

Bradly

I'm doing an internship <a href="http://asoupar.ir/?nizagara-instructions">nizagara directions</a> It also produced one of British legal history's most memorable courtroom ripostes when Rice-Davies took the stand at the trial of Stephen Ward, the man who brought Keeler and Profumo together, who was being prosecuted for living off immoral earnings.

about 3 hours ago

Kayla

Where did you go to university? <a href="http://ukmotorhome-hire.co.uk/rumalaya-tabletki-opinie.php">rumalaya gel price</a> In its most recent case in 2013, the court struck down part of a federal anti-gay marriage law in a decision that has paved the way for a wave of lower court rulings across the country in favor of same-sex marriage rights.

about 3 hours ago

Solomon

I'm not interested in football <a href="http://hoosenji.or.jp/risperdal-consta-injection-procedure">risperdal consta injection dosing</a> Corporate regulator the Australian Securities andInvestments Commission said it had asked the government to handover information about its communications with UBS, saying thebank may have failed to separate its banking and advisory workadequately.

about 2 hours ago

Edgar

I'm a housewife <a href="http://heraldrybydesign.com/erfahrungen-mit-eriacta">eriacta testimonials</a> The tool monitors websites visited and search terms used and lists them in a simple, easy-to-read report

about 2 hours ago

Elliot

Very Good Site <a href="http://k9prop.info/buy-speman-online">speman himalaya tablets</a> "If you have to have a drink, then make sure you sort out a means to get home before you go out

about 2 hours ago

Demetrius

I'm not sure <a href="http://www.kopekpansiyonu.com.tr/where-to-buy-unique-hoodia-in-south-africa.html">hoodia gordonii onde comprar em bh</a> New York state also will get $167.5 million, nearly all of which will compensate victims of the misconduct, authorities said

about 2 hours ago

Jerald

A Second Class stamp <a href="http://heleneburrow.co.uk/buy-astelin-nasal-spray">astelin astepro</a> Four years ago, recall, Cuomo appeared in a single debate with six challengers, several of whom were loons.

about 2 hours ago

Damon

Thanks funny site <a href="http://mega-fortune.se/topamax-for-cluster-headaches/">lyrica combined with topamax</a> The Pentagon's new report maps out four areas of climate change deemed the most threatening to the U.S

about 2 hours ago

Albert

On another call <a href="http://www.triptoir.com/carbidopalevodopaentacapone-strengths/">parkinson's medication sinemet taken with protien</a> The pound has been through a dramatic (in market terms) fall since early June when it was trading above $1.71.

about 2 hours ago

Vincent

I'm doing an internship <a href="http://dohon.co.jp/bentyl-generic-cost-without-insurance">dicyclomine iv use</a> The company, which listed on the London Stock Exchange this year with the ticker symbol CAKE, opened 19 new stores in the past 12 months, and saw a 100% increase in online sales (yes, they offer a range of gateaux via the web).

about 2 hours ago

Jonas

I read a lot <a href="http://www.coachhiredirectory.co.uk/amlodipinevalsartanhydrochlorothiazide-fixed-dose-combination-in-hypertension/">hyzaar plus 100 mg 25 mg</a> Shiloh Missionary Baptist Church was founded more than 90 years ago and is part of the National Baptist Convention

about 2 hours ago

Carol

I'll text you later <a href="http://mega-fortune.se/topamax-for-cluster-headaches/">can cartia be taken with topamax</a> The complete opposite of &#8216;A Pigeon Sat&#8230;&#8217;, the Russian film tells the story of life in a remote village, where the only way to know about the outside world is through the local postman.

about 2 hours ago

Frederic

Lost credit card <a href="http://www.cellulitereviews.org/prazosin-ptsd-mayo-clinic/">minipress xl 5mg dosage</a> He covered the NFL, Olympics and college hoops for seven years at the Star-Ledger

about 1 hour ago

Kristofer

I'm only getting an answering machine <a href="http://buychay.ir/cost-of-iv-ondansetron">zofran injection used for</a> shoots somewhere around par, we&rsquo;ll need a round like (64, 65), but if he doesn&rsquo;t, which can happen on this course at any time, we might not need as low a number as that.

about 1 hour ago

Donnie

Sorry, you must have the wrong number <a href="http://brain-stream.org/what-is-ranitidine-150-mg-tab/">ranitidine light sensitive</a> Over time, many department stores have disappeared &mdash; think ofFilenes, Bullock's, Thalhimer's, Strawbridge's, Hecht's, Woodward &Lothrop, I Magnin, Wanamaker, Jordan March, Marshall Field's, Daytons, Sterns,Garfinklel's and J.M Fields

about 1 hour ago

Bruno

A Second Class stamp <a href="http://www.ebookmart.com.au/dapoxetine-priligy-india/">que es el dapoxetine</a> It was more a &rdquo;go out there and knock the rust off&rsquo; kind of thing, rather than overthrow.&rdquo;

about 1 hour ago

Behappy

I want to make a withdrawal <a href="http://www.ebookmart.com.au/dapoxetine-priligy-india/">forum sur dapoxetine</a> Because Rousseff's attempts early in her term to strong-arm banks into lowering interest rates and increasing lending ended up backfiring, investors are betting on less state intervention in the financial sector going forward, even if the president is re-elected.

about 1 hour ago

Johnie

Hold the line, please <a href="http://drgeorgelikes.com/cijena-corega">corega donde comprar</a> And none was left along the Texas-Mexico border or outside any of the state's largest urban areas.

about 1 hour ago

Rickey

History <a href="http://comfortwoodcottage.co.uk/metoprolol-buy-online">lopressor not working</a> Family and friends often seem horrified that I&#039;m going to be on my own for 12 hours

about 1 hour ago

Kristofer

I'm not sure <a href="http://comfortwoodcottage.co.uk/duetact">duetact manufacturer</a> Oi now owns Portugal Telecom's operating assets following aa merger between the two companies, which soured after the nowbankrupt Rioforte holding company of the Espirito Santo bankingfamily, ultimately a shareholder in PT SGPS, defaulted on nearly900 million euros ($1.14 billion) of loans from PT, a debt whichOi said it had not been aware of before their merger deal.

about 1 hour ago

Kennith

I'd like to transfer some money to this account <a href="http://www.a1accommodation.com.au/lisinopril-20-30">lisinopril nosebleed</a> If Goodell watched the video after it was received illegally, it could have created problems for him and the league.

about 1 hour ago

Chung

Special Delivery <a href="http://toolsandgarages.com/methocarbamol-dose-for-dogs">methocarbamol brand name in pakistan</a> In response to this, the report recommends that the use of patient co-payments should be assessed as a potential method of payment for medical card patients

about 1 hour ago

Mason

Where do you come from? <a href="http://www.pizzanews.co.uk/forxiga-eu-spc/">forxiga 10 mg tablets for weight loss</a> They found that the percentageof these younger households that owed education debt rose from14 percent to 38 percent.

41 minutes ago

Valentine

Some First Class stamps <a href="http://kaimo.dk/azulfidine-dosage-forms/">sulfasalazine generic cost</a> "If an adult between their 20s and 40s who isn't physically active became active three times per week, they would reduce their risk of depression by approximately 16%," commented the study's lead author, Dr Snehal Pinto Pereira of University, College London (UCL).

41 minutes ago

Johnathan

I'm a housewife <a href="http://k9prop.info/chloromycetin-ointment-schedule">can i buy chloramphenicol eye drops</a> Click on the homepage for all the post-match reaction, but make sure you check back tomorrow for more live coverage from the Euro 2016 qualifiers as England visit Switzerland

41 minutes ago

Dillon

Why did you come to ? <a href="http://zhidan.org/where-to-buy-hoodia-diet-pills">acheter mega hoodia</a> &ldquo;It does nothing to relieve the anxiety institutions feelthat they may be harmed by a rating system developed by theDepartment of Education based on poorly vetted formulas andinadequate data,&rdquo; said Hartle, whose group represents more than1,600 college presidents.

41 minutes ago

Jonathan

I sing in a choir <a href="http://zhidan.org/where-to-buy-hoodia-diet-pills">where to buy hoodia diet pills</a> The restaurateur David Page&rsquo;s Fulham Shore vehicle has spent 27.5m on its latest venture, snapping up the Franco Manca pizza chain founded by Giuseppe Mascoli

41 minutes ago

Allan

I work here <a href="http://betapitke.org/torsemide-webmd.html">torsemide dosage range</a> This summer&rsquo;s transfer window showed us the inexorable momentum of Premier League football, which assembles Hollywood Studios of players, irrespective of nationality.

19 minutes ago

Jerrell

Hold the line, please <a href="http://domrolshop.ir/actos-ilocutorios-exercicios-online">lactospore sabinsa</a> Prince Harry's brother, Prince William and his wife - Kate Middleton, the Duchess of Cambridge - attended a game last month at Barclays Center between the Nets and Cleveland, hobnobbing with Jay-Z and Beyonce before meeting with LeBron after the game.

19 minutes ago

Thomas

I've only just arrived <a href="http://autodent-services.co.uk/clindamycin-acne-cream.html">pediatric dose of clindamycin</a> Merck&rsquo;s best-selling acute care product, the antifungal Cancidas (caspofungin) grew in sales 5.9% during January-September 2014 compared with Q1-Q3 2013, to $505 million; followed by the antibacterial Invanz (ertapenem), up 8.3% to $390 million; the antifungal Noxafil (posaconazole) for protection against Aspergillus and Candida infections, up 32% to $280 million; muscle relaxation reversing drug Bridion (sugammadex), up 18.9%, to $245 million; and the antibacterial Primaxin (imipenem and cilastatin), whose sales slid 5.1% to $243 million.

19 minutes ago

Fredric

About a year <a href="http://voyagermagazine.com.au/levitra-side-effects/">levitra side effects long term</a> Barrett Rude Jr.&rsquo;s starry past as the front man of the group Subtle Distinctions comes into view

19 minutes ago

Wesley

Some First Class stamps <a href="http://www.kopekoteli.com.tr/buy-glyburide-5mg">glyburide compared to glipizide</a> The resources on the Democratic side should be focused on winning that seat back for the people of Illinois, not on Democrats fighting one another."

19 minutes ago

Add a comment: