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'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 “Return of the Jedi.” That stormtrooper we saw is apparently on Tatooine — home planet of Anakin Skywalker and his son, Luke — as a menacing voice intones, “There has been an awakening ” Have you felt it?”
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) — 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’s become apparent that relying on the second-year quarterback to win games with his arm isn’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é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’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> “It’s great to be recognized by your fellow players,” 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.”
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 ‘A Pigeon Sat…’, 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’ll need a round like (64, 65), but if he doesn’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 — 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 ”go out there and knock the rust off’ kind of thing, rather than overthrow.”
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'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> “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,” 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’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’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’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.’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: