text:
Subscribe: RSS
April 16 through August 7, 2011
This traveling exhibition and publication are drawn from the Hood Museum of Art's George Maciunas Memorial Collection of works by Fluxus artists, enriched with loans from the Museum of Modern Art, Harvard University, and the Walker Art Center. Intended to provide a fresh assessment of Fluxus, the installation is designed to encourage experiential encounters for the visitor. The 1960s–70s phenomenon that was Fluxus resists characterization as an art movement, collective, or group, and it further defies traditional geographical, chronological, and medium-based approaches. The fundamental question—"What's Fluxus good for?"—in fact has important implications for the role of art today. The function of Fluxus artworks is to help us practice life; what we "learn" from Fluxus is how to be ourselves.
Organized by the Hood Museum of Art and generously supported by Constance and Walter Burke, Class of 1944, the Ray Winfield Smith 1918 Fund, and the Marie-Louise and Samuel R. Rosenthal Fund.
Read more on Fluxus: Free download of The Fluxus Reader, ed. Ken Friedman
Read Pulitzer Prize–winner Sebastian Smee's review of Fluxus and the Essential Questions of Life. See also Smee's accompanying video for the review.
Read Artforum's review of Fluxus and the Essential Questions of Life, featured in their "Critics' Picks" section, which selects a limited number of exhibitions to review worldwide.
Read Artnet.com's review of Fluxus and the Essential Questions of Life by Michèle C. Cone.
Watch the You Tube video made on July 21, 2011, of Alison Knowles, one of the founding members of Fluxus, and students from Dartmouth's Theater Department performing Fluxus scores during the Hood event titled "Appetizers and a Salad." The students performed their own event scores, which were created during Knowles's one-week residency, and her 1962 event score "Make a Salad."
Fluxus and the Essential Questions of Life at the Grey Art Gallery at New York University (through December 3, 2011): read artdaily.org's review of the show in Manhattan.
Available through the museum shop.
Click here to see a Flickr slideshow of exhibition-related events and installation photographs.
Click here to view gallery panoramas of Fluxus and the Essential Questions of Life.
14 April, Thursday, 5:30 P.M.
Fluxus and the Essential Questions of Life
With guest curator and founding Hood director Jacquelynn Baas. Champagne reception to follow. Open to investor-level members and above.
28 April, Thursday, 6:00 P.M.
Second-floor galleries
Dartmouth Goes Flux
"A Celebration of Music at Dartmouth" opens with a Flux concert by Dartmouth digital music students, who will premiere new works in response to Fluxus. The ASCAP Award–winning Voxare String Quartet will also perform music by Dartmouth composers and others.
6 May, Friday, 4:30 P.M.
Arthur M. Loew Auditorium
Fluxus and the Essential Questions of Life
Exhibition curator Jacquelynn Baas, emeritus director of the University of California Berkeley Art Museum and Pacific Film Archive. She served as chief curator and then founding director of the Hood Museum of Art from 1982 until 1989. A reception will follow in Kim Gallery.
7 May, Saturday, 2:00 P.M.
Fluxus and the Essential Questions of Life
17 May, Tuesday, 12:30 P.M.
Flux Dartmouth: Adventures in (Muse)ology
Mary Coffey, Associate Professor of Art History, Dartmouth College
18 May, Wednesday, 6:30–8:00 P.M.
What Is Fluxus? Learning to Look at Avant-Garde Works of Art
Explore the work of Fluxus, an art movement of the 1960s and 1970s, in this interactive, discussion-based workshop. You'll learn techniques for understanding and appreciating any work of art you encounter. Participation is limited. Please call (603) 646-1469 by May 16 to register.
4 June, Saturday, 2:00 P.M.
Fluxus and the Essential Questions of Life
9 July, Saturday, 2:00 P.M.
Fluxus and the Essential Questions of Life
21 July, Thursday, 4:00 P.M.
SPECIAL EVENT Read the Review in the Dartmouth
Flux Performance
Novack Cafe, Baker-Berry Library
Alison Knowles, one of the founding members of Fluxus, will perform her 1962 event score Make a Salad in collaboration with students in Dartmouth's Theater Studies Program.
26 July, Tuesday, 12:30 P.M.
Critical Play: Fluxus and the Art of Interaction
Second-floor galleries
Mary Flanagan, Sherman Fairchild Distinguished Professor in Digital Humanities, Dartmouth College
2 August, Tuesday, 12:30 P.M.
Adventures in Fluxland
Second-floor galleries
Juliette Bianco, Acting Associate Director, will discuss Fluxus and the Essential Questions of Life
Last Updated: 10/30/12


text:
I am a country boy who learned to shoot a rifle at age 4. I am also a retired former FBI Agent who fired 200,000 rounds in training and seven shots in anger. The school shooting at Newtown shows a clear need for gun control by restricting civilian ownership of assault rifles and pistol magazines holding more than 10 rounds of ammunition. These tools of death are designed for one thing, to kill human beings, and represent a needless risk to our law enforcement officers who protect our communities. I call on our politicians and public officials to do the right thing; protect our innocent children from future slaughter.
Avery Rollins
Madison, MS
User submission

subset: commoncrawl


text:
Jeff Bezos: Put Down the PowerPoint and Pull Out the Pen!Written by Jay Turo on Monday, November 18, 2013
Jeff Bezos is a great hero and role model for all entrepreneurs that dream of doing something really, really big, and…pulling it off.
Now when I learn of things like this, I understand why the success of a Jeff Bezos is no accident.
Remember, in addition to founding and leading one of the most successful technology companies of all times, Jeff Bezos also made arguably the greatest investment of all time.
Entrepreneurial America - NOT ShutdownWritten by Jay Turo on Monday, October 14, 2013
Watching the disaster of a process that is the D.C. budget drama, I found myself with a curious reaction.
Fed Easing: Three WinnersWritten by Jay Turo on Monday, September 23, 2013
The word from the Fed last week that it would continue with its quantitative easing - purchasing approximately $85 billion per month in U.S treasury bond and de facto continuing to expand the country's money supply - signaled that that the era of extremely low interest rates will continue.
Predictably, stock markets worldwide cheered along with it being seen as a very positive signal for the well-recovering US housing market.
Now, as to what it means that the Fed has, since 2008, expanded the U.S. Money Supply almost 400% - from $800 billion in 2008 to over $3.5 trillion today?
Well, it doesn't take a Nobel Prize in Economics to reliably predict the inevitable outcome…
Now, in spite of its strong negative connotations, an inflationary economy while extremely painful for very many, also offers opportunities to profit and win.
Here are three:
Winner Number One: Debtors. This is obvious, but easy to overlook. Those owing money at set interest rates - homeowners with 30 year fixed mortgages and companies issuing bonds - will benefit enormously as the inflation train rolls in.
Let's look at a worst but not overly improbable case - a hyperinflation period where all prices rise 10X, resulting in a $500,000 home able to be credibly listed for $5 million.
It sounds crazy, but over the years in countries where hyperinflation has hit, this has not been an uncommon occurrence.
Now let's say that home was financed (or refinanced) with a $400,000, 30-year mortgage at a fixed rate of 3.5%.
Well, with its price increasing from $500,000 to $5 million - while the amount owed on it remains fixed - all of a sudden the house's equity to debt ratio skyrockets from 20% to 92%!
Winner Number Two: Companies with Pricing Power. Businesses with the ability to increase prices quickly without seeing sales plummet - think luxury goods and easily adjusted staples like gasoline at the pump - will hold significant advantages over businesses constrained by "stickier" prices.
Examples of the latter include services like mobile phones contracts and gym memberships, and the classic example of restaurants not increasing prices because of the cost of printing new menus.
Winner Number Three: Private Companies for Sale. My favorite, as there is no greater form of an entrepreneurial, economic success than a sale of a business at an attractive price.
In a world of rising prices, the acquisition appetites of larger companies increase as their cost of money - as driven by their valuation multiples - decrease.
This is most evident for public companies, now trading at a rich 18x earnings (S&P 500), who are able to buy smaller, usually private companies with the relatively cheap currency of high multiple public equity.
This frothiness also drives the financing environment, where buyers (investors) and sellers (entrepreneurs, companies seeking capital) more easily strike higher risk, higher valuation deals (see Fab.com, HootSuite, and scores of others) with an ease that isn't there in a flat or deflationary environment.
So, if you're an entrepreneur, think about accelerating and intensifying both your financing and exit planning efforts.
And for investors, remember that the worst strategy in an era of rising prices is to be standing still and sliding away in fast depreciating cash.
P.S. Click here to complete our survey on investing and entrepreneurship and have a free cup of coffee on us!
Private Equity and Your IRA: The Pathway to Tax-Advantaged ReturnsWritten by Jay Turo on Sunday, September 22, 2013
Individual Retirement Accounts, or IRAs, in all their forms - traditional, Roth, 401k, Defined Contribution, Simple, SEP, 403(b) and 457, have become increasingly popular vehicles for private equity investing.
For the individual investor, investing in private equity via a "Self-directed" IRA has a number of key advantages:
First and foremost are tax savings - both at the time of investment and as the investment appreciates. In some circumstances - for pre-tax contributions via a SEP-IRA for example - up to $49,000 can be invested on a pre-tax (i.e. tax deductible) basis.
Secondly, the power of tax - free compounding of interest, dividends, and capital gains - via both traditional pre-tax IRAs as well as the increasingly popular (and increasingly tax-advantaged) post-tax Roth IRAs is enormous.
In high-return and payout scenarios, where there are larger cash dividends and/or capital gains paid on an annual basis, the value of tax free compounding can lead up to a doubling of total investment return when compared to taxed compounding.
And thirdly, investing in private equity via an IRA addresses "de facto" arguably the key negative of private equity investing - its illiquidity. This is because, to encourage a long-term, retirement-focused time horizon, under the IRA umbrella there are significant, structured penalties for early withdrawl.
In short, IRAs are ideally designed to house long-term investment assets with high capital appreciation potential. This is, of course, the core objective of almost all private equity investing.
Private Equity Investing: Secrets of Doing it Right (Part I)Written by Jay Turo on Monday, August 12, 2013
(Click HERE to complete my survey on investing and entrepreneurship and have a free cup of coffee on me!)
Last week, I talked about the communication breakdowns that occur when investors and entrepreneurs talk about risk.
Positive, Immediate, Close, Specific, and SharedWritten by Jay Turo on Sunday, July 21, 2013
My column last week, where I praised leaders that channeled legendary Green Bay Packers football coach Vince Lombardi's "tough love" leadership approach, prompted a lot of responses - some nice, some not so nice (and not just from the Minnesota Vikings fans out there!).
The most thoughtful ones came back and said, "well that style maybe all well and good if you are running a factory in China, but when it comes to managing younger people (i.e. Millenials - those born after 1982) in modern service businesses, to be effective a "softer" touch is needed.
Points well-taken, so do let me offer here five "Managing Milllenials" best practices:
#5. Revel in the Importance of Company Culture. In a world where everything can and is easily and quickly borrowed, copied, and sometimes just plain old stolen - the only sustainable competitive advantage is how a company organizes and aligns, inspires and challenges its people.
The best guidance I have seen on effective "recognition-based" leadership comes from authors Chester Elton and Adrian Gostick in their awesome book "The Carrot Principle."
They describe recognition done right as being "positive, immediate, close, specific, and shared:"
Positive - managers sometimes mistakenly use a recognition presentation as a time to talk about how far someone has come, or how they could have done even better. This is not the time or place. Comments must be positive and upbeat.
A Pat on the Back or a Kick in the…?Written by Jay Turo on Monday, July 15, 2013
Green Bay Packer tackle Henry Jordan once famously described legendary football Coach Vince Lombardi's coaching style as "He's Fair. He treats us all the same – like dogs."
The 3 Things You Must Do on July 1stWritten by Dave Lavinsky on Sunday, June 30, 2013
July 1 is a critical day in your business. Because it's the day that officially starts the second half of 2013. That's right, the year is already half-way over.
In assessing your performance, the key question to answer is "why?" For instance, if you didn't achieve your revenues goals, what obstacles prevented your success? And, how can you overcome those obstacles going forward.
The Two Most Important Quotes In BusinessWritten by Dave Lavinsky on Tuesday, June 25, 2013
If you don't know Peter Drucker, you should: he's known as the man who invented modern business management. He wrote 39 books on the subject and is widely regarded as the greatest management thinker of all time.
There are nearly 50 questions such as these that measure each aspect of your business.
Unfortunately, most entrepreneurs and business owners don't. Or their businesses would be much more successful than they currently are.
Lead Generation - Your Top 5 Lead Generation Questions AnsweredWritten by Dave Lavinsky on Thursday, June 20, 2013
Lead generation is critical for all entrepreneurs. And once you master it, your business will thrive.
Best of Growthink
Subscribe to Growing Your EmpirePrivate Equity Opportunities via Growthink How to Write a Business Plan for Raising Venture Capital Top Seven Capital Raising Mistakes 20 Reasons Why You Need a Business Plan Top 10 Private Placement Memorandum (PPM) Mistakes The Secrets to Their Success? 25 Quotes From Famous Entrepreneurs The 6 Untold Reasons Why Businesses Fail 7 Entrepreneurs Whose Perseverance Will Inspire You Top 7 Myths About Starting a Business Business Exit Strategy: Planning to Sell Your Business How to Make a Business Plan Capital Raising Resource Center Investing in Private Equity via Your IRA


text:
Photo: Laurey W. Glenn
Family Portraits
Connect the past and present by framing and matting old photographs and portraits in a fresh way. "Clean them up, blow them up—do whatever you need to do—and then put them in a simple black or white frame," says Phoebe. "Black looks modern, but white with a white mat also looks great."
Steer clear of posed-looking family portraits, though. "Instead, take candid, casual pictures, and collect them as a nice assortment on the wall," she says. And whatever you do, get photos professionally framed.


text:
Types of Information
- Scholarly SourcesScholarly sources are those written by experts in a particular field. They are usually peer reviewed and available in databases.
- Trade PublicationsTrade publications are those journals and magazines published by and for people working in a particular field.
- Popular SourcesPopular publications are non-scholarly sources such as magazines and newspapers.
- Primary, Secondary, and Tertiary Sources
How to Access Information
- Accessing Databases while On Campus
- Accessing Databases from Off CampusHow to access research databases from off campus.
Remember: your PIN number is your YSU ID number!
- Maag Journal FinderHow to locate journal articles using a citation
- Accessing Course ReservesHow to access materials your instructor has placed on reserve
- Finding Newspaper Articles in the New York TimesUse print, microfilm, and database resources to find articles in the New York Times.
- Finding Oversized BooksHow to locate oversized books in the catalog and on the shelf
How to Search
- Selecting KeywordsChoosing keywords for your search.
Example: teenagers, adolescents, volunteerism
- Boolean OperatorsUsing AND, OR, and NOT to combine keywords.
Example: women AND drug abuse
- Phrase Searching and NestingUse "" to form phrases and () to combine groups of synonyms.
Example: "emissions standards" and (car or automobile)
- TruncationUse symbols with root words to find all possible word endings in a single search.
Example: educat*
Subject Guide
Contact Info
Maag Library
1 University Plaza
Youngstown, OH 44509
Send Email
Profile & Guides
English, general research


text:
Happy to have positions as servants, Jon Barker as Prince Mikaïl Alexandrovitch Ouratieff pledges his love to his wife, Grand Duchess Tatiana Pêtrovna played by Carly Street.
- Filed Under
Do you remember Grand Duchess Tatiana Petrovna and her consort, Prince Mikail Alexandrovitch Ouratieff? Perhaps you might recall them better as "Tina and Michael," the nicknames they assume when they take jobs as butler and housemaid in a wealthy financier's household. Still doesn't ring a bell?
Well, you're not alone. Despite the fact that "Tovarich," the tale of the post-Revolution fortunes of two White Russian aristocrats has enjoyed some half dozen incarnations as a play, a film and a stage musical, it's become what director Bonnie J. Monte calls a lost "theatrical gem," a forgotten ...


text:
Midtown Miscreant has an update on Muscare, the one-time local TV host who was busted for molestation back in the 1980s. And I found this older post from Kansas Watch about Muscare that's worth reading, too.
« VIDEO: Mom literally drags kid through store, police say | Main | Cops allegedly ran criminal background check on Obama »
Friday, July 31, 2009
The continuing saga of Uncle Ed
TrackBack URL for this entry:
Listed below are links to weblogs that reference The continuing saga of Uncle Ed:


text:
Former longtime Newtown resident Leslie Hudson-Tolles will have a one-woman exhibit of her paintings at Koenig FrameWorks, April 26-May 31.
Ms Hudson-Tolles moved to Newtown in 1977 and stayed for over 30 years. She was one of the three original founders of Newtown Bridle Lanes Association, and was able to transfer her love of horses and the equestrian world into a career as both artist and teacher.
"I chose Newtown for the school system and because they were horse friendly. I liked the fact that there was a town center and a real sense of community," she said recently via email from her home and studio in North Carolina. "My girls received a great education there and I had and have a terrific support group of neighbors and friends as I raised my girls.
"The only reason I left was the best reason: love. After my girls were in college, I married the man I had met as a teenager on a mission trip," she continued. Leslie Hudson-Tolles and that man, Richard Rouse, were married at Newtown United Methodist Church on March 30, 2006. Five months later the couple — "along with horses, dogs, cats, and all the art and the studio," she said — moved to Faith, N.C., where Ms Hudson-Tolles continued to teach art in the public schools.
The couple moved in December to Cleveland, N.C. Ms Hudson-Tolles is still teaching, at Sacred Heart Catholic School in Salisbury, N.C., and maintains a large teaching studio in her home.
While primarily an equine artist, Ms Hudson-Tolles also draws and paints other animals, and is well known for her portraits. Regardless of the move away from Newtown a few years ago, Ms Hudson-Tolles says she has "remained very connected with Newtown. I visit summers and talk to friends regularly. I had returned for an art show three years ago at Koenig's Frameworks Gallery."
While visiting the area last summer ("The promise I got from Richard," she told The Bee recently, "was that we would return every summer."), Ms Hudson-Tolles reconnected with Koenig FrameWorks gallery owner Casper Sabatino and Alegre Poniros, manager, and scheduled a one-woman show for this spring.
"Everything Changed"
A few months ago, Ms Hudson-Tolles was, along with friends, unpacking from her latest move.
"Everything changed on 12/14. For Newtown, for the world, for me," she said. "Friends were helping me unpack … and I ignored my phone until the calls became constant, and I noticed they were all from home, 203 numbers."
When she finally answered the phone that day, Ms Hudson-Tolles was told by a friend to turn on her television.
"I imagine that a similar scenario was repeated all over the country," she said, "all over the world, but more so by those having roots in Newtown."
Ms Hudson-Tolles called her daughters — Lindsay, a technician at an animal hospital in Virginia, and Alyssa, a clinical social worker at a state mental hospital in North Carolina — "and we cried together," she said. "There were months of late night calls to home, checking in with friends and neighbors and the overwhelming urge to go home and help ... and the awareness that there was nothing we could do and the last thing Newtown needed was another 'visitor.'"
After decades of teaching art and creating art, Ms Hudson-Tolles is very aware, she said, of the therapeutic value of art.
"I am surrounded by woods here as I was in Newtown and found myself drawn to the enduring quality of the trees, some bent and broken by the storms," she said. With that in mind, she has created a collection of more than 30 pieces for the upcoming Newtown exhibition, which she is calling "A Show of Strength."
"Lots of painted and rendered trees. Symbols of endurance. Beautiful in their survival. Standing after the lightning struck," she said. "And a young bull, an Angus Bull... and always the horses, strong beautiful, sensitive.
"I am coming home in the hopes that my images of strength and renewal can in some small way help corners of our hearts heal," said Ms Hudson-Tolles. "To let Newtown know that they are on our minds, in our hearts."
The show will open with a reception on Friday, April 26, from 5 to 7:30 pm. Ms Hudson-Tolles will also offer an artist's talk at the gallery, located at 97 Main Street South, on Saturday, April 27, at noon.
A portion of profits from the sale of any work in the exhibition will be donated by Ms Hudson-Tolles to The Newtown Rotary Club's Sandy Hook School Fund. The fund, administered by the 501(c)(3) Newtown Rotary Foundation, "is dedicated to the victims of the Sandy Hook School tragedy, their families and those in the Newtown community who have been affected, to help support both their short term and long term needs," according to Rotary's website.
The framing gallery and exhibition space is open Monday through Saturday from 10 am until 5 pm. Call 203-270-1887 or visit KoenigFrameworks.com for additional information.


text:
Your cart is empty!
Weekly Medicine Organizer Deep and roomy design. Pill Box Multipack for pocket, purse or briefcase.
7 Day Pill Organizer, Size : Large, 1 Ea
Our Price:$1.00
Disney Princess Complete Multivitamin Supplement Chewables, 60 Tablets
Our Price:$5.01
Alka-Seltzer Plus Cold Medicine, Original Effervescent Tablets - 36 Ea
Our Price:$8.00
Amo Complete Blink-N-Clean Lens Drops For Soft Contact Lenses - 0.5 Oz (15 Ml)
Our Price:$6.41
John Frieda Root Awakening Health Infusing Hair Conditioner, Normal Hair, 8.45 Oz
Our Price:$3.64
Scotch Heavy Duty Foam Mounting Squares - 16 Ea


text:
Firefighters respond to two Westmoreland County blazesDecember 22, 2013 7:24 AM
Share with others:
A two-story house and a mobile home were destroyed in separate fires early today in Westmoreland County.
An emergency dispatcher reported that no one was injured in either blaze.
The first was reported at 3:36 a.m. at a two-story house in the 600 block of Church Street in Sewickley Township. The dispatcher said no one was home, as the house was being remodeled.
The second blaze was called in to emergency responders at 3:56 a.m. A mobile home on Century Court in Mount Pleasant Township was destroyed .It's unclear whether anyone was home at the time but no injuries were reported, according to the dispatcher.


text:
DVD Releases worth MentioningGoon
Theres always DVDs being released but usually you have to wade through all the crap to find the good stuff. Well I'm going to cut that step out for you and post the good ones up here.
The first DVD that caught my eye is Sky High. This film is directed by Ryuhei Kitamura, the man behind Versus. In this film he adds more of a horrific twist and people hearts get cut out. Now you can't go wrong with that.
Next up is the Tartan Release of "A Tale of Two Sisters". This is by far the best Korean horror film I have ever seen. It is definetly worth your time and if you are even considering picking up an Asian horror film, this should be the one.
Lastly is the "Toxic Avenger 21st Anniversary DVD". Now I am not much of a fan of Troma films but this Toxic Avenger is welcome in my DVD collection. Some of the bonus' for this DVD are:
- Numerous Fan projects including cartoons, original short films, re-inactments and many more!
- Scenes from the hit stage show Toxic Avenger Musikill!
-Interviews with original cast members Robert Prichard, Dan Snow and Mitch Cohen, the original Toxie! - A rare and highly anticipated on-camera Interview with Michael Herz, Vice President of Troma and Lloyd Kaufman, President of Troma Entertainment and creator of The Toxic Avenger!
-Make Your Own Damn Movie film school in a box!
-Toxie in Africa!
-Original theatrical trailers For The Toxic Avenger, parts 1 through 4
- All featured in Tro-morphic Widescreen
So there ya go. All the DVDs that are worth checking out. If I had to suggest picking up just one of them, I would definitely say "A Tale of Two Sisters". Its a really smart horror film that has a great twist in it. Next week I'll have another list of DVDs that are deemed "Goon Approved"..


text:
|Acute otitis externa: an update.
MedLine Citation:
|PMID: 23198673 Owner: NLM Status: In-Data-Review
|Acute otitis externa is a common condition involving inflammation of the ear canal. The acute form is caused primarily by bacterial infection, with Pseudomonas aeruginosa and Staphylococcus aureus the most common pathogens. Acute otitis externa presents with the rapid onset of ear canal inflammation, resulting in otalgia, itching, canal edema, canal erythema, and otorrhea, and often occurs following swimming or minor trauma from inappropriate cleaning. Tenderness with movement of the tragus or pinna is a classic finding. Topical antimicrobials or antibiotics such as acetic acid, aminoglycosides, polymyxin B, and quinolones are the treatment of choice in uncomplicated cases. These agents come in preparations with or without topical corticosteroids; the addition of corticosteroids may help resolve symptoms more quickly. However, there is no good evidence that any one antimicrobial or antibiotic preparation is clinically superior to another. The choice of treatment is based on a number of factors, including tympanic membrane status, adverse effect profiles, adherence issues, and cost. Neomycin/polymyxin B/hydrocortisone preparations are a reasonable first-line therapy when the tympanic membrane is intact. Oral antibiotics are reserved for cases in which the infection has spread beyond the ear canal or in patients at risk of a rapidly progressing infection. Chronic otitis externa is often caused by allergies or underlying inflammatory dermatologic conditions, and is treated by addressing the underlying causes.
|Paul Schaefer; Reginald F Baugh
Related Documents :
|12591193 - Evaluation of pcr to detect theileria parva in field-collected tick and bovine samples ...
9195713 - Use of an in vitro infectivity assay in comparison with histological techniques in the ...
24480673 - Shell colouration and parasite tolerance in two helicoid snail species.
Publication Detail:
|Type: Journal Article
Journal Detail:
|Title: American family physician Volume: 86 ISSN: 1532-0650 ISO Abbreviation: Am Fam Physician Publication Date: 2012 Dec
Date Detail:
|Created Date: 2012-12-03 Completed Date: - Revised Date: -
Medline Journal Info:
|Nlm Unique ID: 1272646 Medline TA: Am Fam Physician Country: United States
Other Details:
|Languages: eng Pagination: 1055-61 Citation Subset: AIM; IM
|University of Toledo College of Medicine, Toledo, OH, USA.
Export Citation:
|APA/MLA Format Download EndNote Download BibTex
|MeSH Terms
From MEDLINE®/PubMed®, a database of the U.S. National Library of Medicine
Previous Document: Subacute to chronic mild traumatic brain injury.
Next Document: Identifying Well Contamination through the use of 3-D Fluorescence Spectroscopy to Classify Coalbed ...


text:
ASP.NET 5 introduces a new runtime model for the .NET framework which allows us to employ a "pay-as-you-go" approach, building composable applications using only those framework components our application needs, without relying upon a central, monolithic library repository present on the host machine.
This new model also provides us with command line tools for managing our .NET version selection, library packages, and execution environment outside of Visual Studio. It is now possible to develop cross-platform ASP.NET applications using a text editor and command line (either CMD or Powershell on Windows) without ever opening Visual Studio.
Image by César Astudillo | Some Rights Reserved
Understanding the relationship between the .NET Version Manager (DNVM), the .NET Execution Environment (DNX) and .NET Development Utilities (DNU) is fundamental to developing with ASP.NET 5. In this post we will look at installing and using DNVM, DNX, and DNU on to work with ASP.NET from the command line.
DNVM is a version manager tool for the command line. As its name implies, DNVM provides the functionality needed to configure your .NET runtime. We can use DNVM to specify which version of the .NET Execution Environment to use at the process, user, or machine level.
What is this DNX, anyway? From the ASP.NET Documentation site:
The .NET Execution Environment (DNX) is a software development kit (SDK) and runtime environment that has everything you need to build and run .NET applications for Windows, Mac and Linux. It provides a host process, CLR hosting logic and managed entry point discovery. DNX was built for running cross-platform ASP.NET Web applications, but it can run other types of .NET applications, too, such as cross-platform console apps.
The .NET Execution Environment (DNX) is a software development kit (SDK) and runtime environment that has everything you need to build and run .NET applications for Windows, Mac and Linux. It provides a host process, CLR hosting logic and managed entry point discovery. DNX was built for running cross-platform ASP.NET Web applications, but it can run other types of .NET applications, too, such as cross-platform console apps.
Broadly speaking, different DNX runtime versions are available which reflect which .NET framework version you want to use in your application. At a basic level, there are different versions for:
We can use the .NET Version Manager to select which DNX version we want to use with our application.
DNU is a command-line tool which provides a variety of utility functions to assist with development in ASP.NET. Most commonly, we will use DNU to install and manage library packages in our application, and/or to package and publish our own application.
DNU uses Nuget behind the scenes for package management and deployment.
If you have installed Visual Studio 2015 (currently available as a Release Candidate HERE), you already have the .NET Version Manager installed.
UPDATE: According to the ASP.NET team (thanks Glenn!) DNX/DNVM isn't actually installed until you run File -> New after VS 2015 is installed, so if you have VS 2015 installed but have not cracked open a new file yet, you won't have it on your machine yet.
If you want to upgrade to the most recent version of DNVM, or if you want to work with ASP.NET, but don't want to install Visual Studio, you can download the DNVM script as follows from either the Windows Command prompt (CMD) or using Powershell:
@powershell -NoProfile -ExecutionPolicy unrestricted -Command "&{$Branch='dev';iex ((new-object net.webclient).DownloadString('https://raw.githubusercontent.com/aspnet/Home/dev/dnvminstall.ps1'))}"
&{$Branch='dev';iex ((new-object net.webclient).DownloadString('https://raw.githubusercontent.com/aspnet/Home/dev/dnvminstall.ps1'))}
Once we have DNVM on our machine, we should be able to fire up the Windows command prompt, and get started.
At the command line (or Powershell prompt) run the following to see that DNVM is, in fact, installed on your machine:
> dnvm
If all has gone well to this point, you should see the following (we're going to stick with CMD for this post, to keep things simple):
Now that we have DNVM installed and running, let's see which DNX versions we have available, and how to install DNX versions if we need.
To examine the runtime options available to us, we can run the following command from the Console:
> dnvm list
I had previously installed Visual Studio 2015 on my machine, which also installed a few DNX versions, so when I runt he above I see the following output:
Because I had installed Visual Studio 2015 already, there are DNX versions available for .NET Framework (the beta4 clr in the image above) and also .NET Core (the coreclr above) for both 32 and 64 bit architectures.
If you have NOT installed Visual Studio 2015, your list is very likely empty. Installing DNVM does not, in and of itself, install any DNX versions on your machine. No worries, we'll take care of that next.
If you just installed DNVM fresh, or if you want to get the latest version of a particular DNX implementation, we can use the the dnvm install command with some appropriate arguments:
By default, DNVM will work with the basic .NET framework, and assume the x86 architecture. For example, if we do the following:
> dnvm install latest
DNVM will download and install the latest stable version of the regular .NET framework for the x86 architecture. If we run dnvm list again, we see the following:
If we want to specify a different runtime (say, the CoreCLR instead of the .NET Framework, and/or specify the x64 version, we need to add the -r ( -runtime ) and/or -arch ( -architecture ) flags, and values:
> dnvm install latest -r coreclr -arch x64
Once the above is finished running, we have now added the latest version of the full .NET Framework for the x86 architecture, and CoreCLR for the x64 architecture to our available runtimes list:
DNVM also has an upgrade command, which behaves just a little differently than Install.
DNVM Install fetches the specified version, and makes it active in the current Command process by adding it to the process PATH variable. The selection is "Active" is only for the duration of our terminal session. Once the current terminal session is closed, the active selection will revert to none, or whatever had been previously persisted in our User PATH variable as the default.
DNVM Upgrade does essentially the same thing, but also adds it to the User's PATH variable as the default active version, and updates the default alias. For example, if we used dnvm upgrade to install the latest 64 bit version of the .NET framework clr:
> dnvm upgrade -r clr -arch x64
After running the above, our Console output tells us that the latest version of dnx-clr-win-x64 has been added not only to the current process PATH, but also to our User PATH. In addition, the "default" alias has been updated to point to the just-installed version:
Note that dnvm upgrade pulls down the latest stable release from Nuget. If you want to work on the bleeding edge with the latest unstable (development) release, you can use:
> dnvm upgrade -u
In the above, you can specify runtime/architecture as previously using the -r and -arch flags.
5/17/2015 - NOTE: If you installed Visual Studio 2015, the system environment PATH variable likely points to C:\Program Files\Microsoft DNX\Dnvm\. As of this writing, the Visual Studio version of DNVM does not recognize the -u (-unstable ) flags. Even if you installed DNVM using the shell scripts at the beginning of this article, the Visual Studio variable will be found first. In order to use the -u flag, you will need to either change the order in which the PATH variables occur, or remove the Visual Studio PATH and add DNVM using one of the scripts above.
Notice in the previous section the asterisk that appears in the "Active" column of the console output once we started installing new DNX runtime versions. When we use dnvm Install, DNVM makes the just-installed version the default active version for the current process (in other words, for the current terminal session only).
As noted previously, when we run dnvm upgrade, DNVM makes the just-installed version the default active version not only for the current process, but also at the User level.
We can switch to a different DNX runtime by using the dnvm use command. By default, dnvm use changes the active selection for the current Command process. For example, given the current active runtime in the console output from the previous section (1.0.0-beta4-11566 clr x64), we could decide we want to switch to the latest 64 bit coreclr version for our current terminal session instead:
> dnvm use 1.0.0-beta4-11566 -r coreclr -arch x64
If we run the above command, and then run dnvm list again, we see our active version has changed:
If we look closely at the console output above though, we see that the new version was added to the process PATH, meaning, the selection will persist for the current Console process only. If we close the console window, and open another, the default set in our User PATH will be selected again.
If we want to set our user default, we could run the command just like we did previously, but instead we can add the -p ( -persistent) flag, which will cause the selection to be added to our user path instead of the process path:
> dnvm use 1.0.0-beta4-11566 -r coreclr -arch x64 -p
Now, our selection will persist as the default between Command sessions. We can still select a different version per process just like we did previously, but until we make additional changes, the default active DNX runtime in a Command session will be the beta 4 CoreCLR from build 11566.
If we want to remove all runtime references from the process path (in other words, return to a state where no runtime is set as "Active" we can run:
> dnvm use none
If we want to remove any defaults we have set in our User PATH variable, we can add the -p flag:
> dnvm use none -p
If you have been working through the examples so far, you may have noticed how painful it can be typing out the full, semantic version names each time you want to refer to a runtime version. DNVM affords us the ability to assign aliases to the different installed versions. We can do this during install or upgrade using the -a ( -alias ) flag, or we can set aliases for existing installed versions using the alias command.
For example, we already have an alias, default, which in my case was set up when I installed Visual Studio. It was originally assigned to the regular x86 .NET framework CLR, and then was re-assigned when we ran dnvm upgrade in the previous section. As of now, the alias default on my machine points to the latest (build 11566) x64 bit version of the .NET CLR.
I can set an alias for the latest x64 version of CoreCLR like so:
> dnvm alias core-64-latest 1.0.0-beta4-11566 -r coreclr -arch x64
Having done that, I can now refer to that particular runtime by its alias, for example:
> dnvm use core-64-latest
5/17/2015 - NOTE: There is currently a bug (see issue #175 / PR #248 at the DNVM Repo on Github) in which referring to a CoreClr runtime by alias does not work. As of this writing, the PR has not yet been merged, but things are supposed to work as described here. Until the issue is resolved, it is still necessary to refer to any CoreClr runtime by its full version name…
We can re-assign a previously set alias by simply using the dnvm alias command, and assigning the alias to a different DNX Runtime.
To get a feel for how DNVM, DNU, and DNX work together, we'll put together a very basic example project, using only the Windows Command Prompt and a text editor (for this post, I'm going to use Sublime Text 3, but we could just as easily use Visual Studio Code, or Notepad).
First, let's create a project directory, and then open the folder in Sublime Text:
C:\Users\John> mkdir dnx_demo
C:\Users\John> cd dnx_demo
C:\Users\John> mkdir dnx_demo
C:\Users\John> cd dnx_demo
Then, open the directory folder in Sublime text. First, we'll add a project.json file:
"version": "1.0.0-*",
"description": "Silly demo project",
"commands": {
"runme": "dnx_demo"
"frameworks": {
"dnx451": { },
"dnxcore50": {
"dependencies": {
"System.Console": "4.0.0-beta-22816",
"Microsoft.CSharp": "4.0.0-beta-22816"
"version": "1.0.0-*",
"description": "Silly demo project",
"commands": {
"runme": "dnx_demo"
"frameworks": {
"dnx451": { },
"dnxcore50": {
"dependencies": {
"System.Console": "4.0.0-beta-22816",
"Microsoft.CSharp": "4.0.0-beta-22816"
In the above, note we have defined a command, "runme" which refers to the project name. We can invoke this command from the Command Line using dnx to run our project. Also note, we have specified both the traditional .NET Framework (dnx451) as well as the .NET Core (dnxcore50) as compilation targets, so our application wioll be cross-compiled for both DNX runtimes and frameworks.
Next, add a file named Program.cs and paste in the following code:
using System;
namespace dnx_demo
public class Program
public void Main(string[] args)
Console.WriteLine("No Visual Studio Here!!");
using System;
namespace dnx_demo
public class Program
public void Main(string[] args)
Console.WriteLine("No Visual Studio Here!!");
By simply adding these two files, we have (almost) everything we need to run a very basic, but complete, .NET Console application. Save the two files above, and return to the Command prompt.
Our project.json file specifies the target frameworks and dependencies our project requires. Note that for this project, there are no packages to be pulled down when we run against the standard .NET framework 4.5.1 - the required references are already present in the .NET framework itself.
We will need to restore packages before we can run against the .NET Core framework and CoreCLR. Remember, .NET Core is all about "pay as you go." In other words, We pull in only those libraries we need for our application to run, and leave out everything else.
We can restore library packages by simply running dnu restore from within our project directory:
C:\Users\John\dnx_demo> dnu restore
With our package dependencies restored, we can run our application using DNX. We can now run the application, after we select which DNX runtime we want to use.
In my case, we set the default active runtime to the latest .NET Core CLR / x64 in a previous example, so we can run the application straight away from within our project directory:
C:\Users\John\dnx_demo> dnx . runme
Take a close look there. Since I am already in the project directory, I can simply type dnx, and use a period to indicate the current directory. DNX will parse the command, runme, we set up in our project.json file, and use that to run the project.
We could also simply reference the project by name:
C:\Users\John\dnx_demo> dnx . dnx_demo
Or, as long as we are in the project directory, we could keep it REAL SIMPLE and just use dnx . run
C:\Users\John\dnx_demo> dnx . run
Now, let's switch runtimes from .NET Core to the traditional .NET Framework. Recall, we had previously used dnvm upgrade to install the latest x64 binaries for the .NET framework, and when we did that, our default alias was assigned to that runtime:
C:\Users\John\dnx_demo> dnvm use default
We can check to make sure we are now targeting the .NET CLR instead of CoreCLR, and then run our application again:
So far, we've examined the basics of using the .NET Version Manager, the .NET Development Utility (DNU), and the .NET Execution Environment in order to get a basic application up and running in the new ASP.NET environment.
In our simple example above, we compiled and executed our project in memory. There is no generation of binaries as part of the dnx run process. DNX, and DNU offer a wealth of additional features, such outputting binaries as a part of the build process (dnu build), creating Nuget packages (dnu pack) and other useful commands.
DNU, DNX, and DNVM are currently in active development, and things are changing daily. Keep your eye on the ASP.NET 5 repo, and watch for updates here and elsewhere.
We will explore more in upcoming posts
Postgres is just too cool. Because Postgres can work with both JSON and arrays as first-class data types, it is possible to perform some very handy mappings on the server end which would become potential performance bottlenecks on the client side.
When working in Node.JS, it might be handy to do some heavy lifting via Postgres to reduce some n+1 / lazy loading issues, especially when pulling data for display. Using some of Postgres' in-built JSON functions in conjunction with the JSON data type, we can compose ready-to-use JSON objects before returning the result.
In this post, we'll take a quick look at the row_to_json() function, the array_to_json() function, and the json_agg() function, and see how between these three we can shape relational data on the database side, possibly in a much more performant manner than we might within our application.
First off, lets' aggregate some row data into a JSON object.
For the examples which follow, I will be using a slightly modified version of the Chinook database, which I tweaked to be a little more Postgres-friendly.
Consider the following tables from Chinook (with Sample Data added):
CREATE TABLE albums
id int DEFAULT nextval('albums_id_seq'::regclass) NOT NULL,
title VARCHAR(160) NOT NULL,
artist_id INT NOT NULL,
CONSTRAINT pk_albums PRIMARY KEY (id)
CREATE TABLE artists
id int DEFAULT nextval('artists_id_seq'::regclass) NOT NULL,
name VARCHAR(120),
CONSTRAINT pk_artists PRIMARY KEY (id)
CREATE TABLE albums
id int DEFAULT nextval('albums_id_seq'::regclass) NOT NULL,
title VARCHAR(160) NOT NULL,
artist_id INT NOT NULL,
CONSTRAINT pk_albums PRIMARY KEY (id)
CREATE TABLE artists
id int DEFAULT nextval('artists_id_seq'::regclass) NOT NULL,
name VARCHAR(120),
CONSTRAINT pk_artists PRIMARY KEY (id)
For our purposes the artists and albums tables, populated as they are, will do admirably.
We can use the Postgres row_to_json() function in a straightforward manner to take a full row of data, and squeeze it into a JSON object before the result set is returned.
For example, let's grab all the artist records, and return rows of JSON:
select row_to_json(artists)
from (
select * from artists) as artists
select row_to_json(artists)
from (
select * from artists
) as artists
Running the query above gives output like so:
// ... a bunch more artist records ...
// ... a bunch more artist records ...
We could modify the above, and add some criteria so that we are limiting the records to to a specific artist like so:
select row_to_json(artists)
from (
select * from artists where id = 12
) as artists
select * from artists where id = 12
Running the above with criteria set to artist id 12 (which happens to be Black Sabbath) returns the following predictable result:
{"id":12,"name":"Black Sabbath"}
Now, each artist can have any number of albums in the albums table. Wouldn't it be nice if we could grab the albums for a specific artist, and transform them into JSON array?
Postgres offers us the json_agg() function, which takes an input values and aggregates them as a JSON array:
For example, we might want to aggregate the album records for a specific artist into a JSON array:
select json_agg(albums)
from (
select * from albums where artist_id = 12
) as albums;
select json_agg(albums)
select * from albums where artist_id = 12
) as albums;
Running this query returns the following:
[{"id":16,"title":"Black Sabbath","artist_id":12},
{"id":17,"title":"Black Sabbath Vol. 4 (Remaster)","artist_id":12}]
[{"id":16,"title":"Black Sabbath","artist_id":12},
{"id":17,"title":"Black Sabbath Vol. 4 (Remaster)","artist_id":12}]
There we go… we now have an array of albums for a specific artist. Now, can we expand on this, and return the artist record as a JSON object, including an albums property represented by such an array, containing all the albums for each artist?
Why, yes, yes we can!
Let's return each row as a complete JSON object, such that each artist record is represented as JSON, and contains an albums property which itself contains an array of album objects.
We can aggregate the album records for each artist using json_agg() in a correlated subquery with the artists table, and then we can pass each row to the row_to_json() function to transform the result into complete JSON object, ready for use in our application.
Per usual with correlated subqueries, keep your eye on the numerous database object aliases here. Naming can get a little funky…
select row_to_json(art) as artists
select a.id, a.name,
(select json_agg(alb)
from (
select * from albums where artist_id = a.id
) alb
) as albums
from artists as a) art;
select row_to_json(art) as artists
select a.id, a.name,
(select json_agg(alb)
from (
select * from albums where artist_id = a.id
) alb
) as albums
from artists as a) art;
The result of the query above:
{"id":1,"title":"For Those About To Rock We Salute You","artist_id":1}, +
{"id":4,"title":"Let There Be Rock","artist_id":1}
{"id":2,"title":"Balls to the Wall","artist_id":2}, +
{"id":3,"title":"Restless and Wild","artist_id":2}
{"id":5,"title":"Big Ones","artist_id":3}
// ... a bunch more records ...
{"id":1,"title":"For Those About To Rock We Salute You","artist_id":1}, +
{"id":4,"title":"Let There Be Rock","artist_id":1}
{"id":2,"title":"Balls to the Wall","artist_id":2}, +
{"id":3,"title":"Restless and Wild","artist_id":2}
{"id":5,"title":"Big Ones","artist_id":3}
// ... a bunch more records ...
Voila – we have ready-to-use JSON to return to our application. Most importantly, we have completely assembled artist objects, with albums available as an array via the albums property on each artist.
Postgres offers a wealth of innovative features such as the JSON / JSONB data type, the array data type, HStore, and plenty of functionality built around each. What we have seen here is a simple solution to one of the common challenges presented by data access and managing parent/child relationships – the lazy loading / n+1 problem.
By flexing the power of Postgres' JSON type and associated functions, we have blurred the line between document and relational storage.
If you haven't taken Postgres for a spin yet, I strongly suggest you do. There's more where that came from.
Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided firmly in the latter camp. I am a huge fan of the Postgres database platform, and I have been slowly but steadily trying to improve my Linux chops.
If you are an experienced Linux user, or a PostgreSQL DBA, this is not the post for you, although your feedback and constructive criticism are most welcome – if you see something amiss, please do let m eknow in the comments, or via email.
I should note here that, where practical, I do as much as I can on Linux from the terminal. While the desktop/GUI is handy for some tasks, I am doing my level best to become proficient with the terminal in Linux. I strongly recommend doing the same. Which is how we're going to do things here.
The installation process for Postgres on Ubuntu or Linux Mint is, like many things in the Linux world, less than intuitive for new users. As much for my own sake as anyone else's, I'm going to walk through the steps to getting Postgres installed and configured on a Linux box.
PostgreSQL is a fantastic database platform. Postgres is open source, cross-platform, free, and offers an amazing feature set which, in my mind, exceeds those of its principle peers in the relational database space.
Postgres offers all of the (mostly) standards-compliant SQL/relational database feature you would expect, plus a host of exciting and innovative features. Highlights include a JSON datatype (and also JSONB!), an array datatype, and the new HStore type, which essentially allows the specification of a column as containing a list of key/value pairs. We'll take a tour of PostgreSQL in another post, but first, let's get the thing installed and running.
At the moment, my preferred Linux distro is Linux Mint 17 ("Quiana") with the Cinnamon desktop. This is a long-term support release of the Linux Mint distro, very stable, and an excellent place to start. If you do not have a dedicated Linux machine, it is simple enough to spin up a VM using Virtual Box.
As of this writing, the most recent version of PostgreSQL is version 9.4, which brought with it some very cool features such as full JSONB support. However, the 9.4 release is not available directly using the Advanced Packaging Tool (APT) or the Linux Mint/Ubuntu Software Manager.
Fortunately, the PostgreSQL Global Development Group (PGDB) maintain an APT repository of PostgreSQL packages for Debian and Ubuntu-derived Linux distros.
Before we can install Postgres, we need to add the package source for the distro we are using. In my case, I am using Linux Mint 17, which is derived from, and compatible with, the Ubuntu 14.04 ("Trusty Tahar") release. We'll see why this matters in a moment.
We need to create a sources file reflecting the proper Postgres source for our particular distro. In my case, as noted above, we need the source compatible with the "Trusty" release of Ubuntu. So we can do this from the terminal to add the file (make sure you use sudo in all of the following steps):
~ $ sudo touch /etc/apt/sources.list.d/pgdg.list
Now that the file exists, open in your editor of choice (we'll use gedit here):
~ $ sudo gedit /etc/apt/sources.list.d/pgdg.list
then add the following line in gedit and save (where I used "trusty" below, use the name of your release for Ubuntu, or the corresponding Ubuntu release if you you are using Linux Mint):
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main
Save, and close gedit.
Alternately, we can achieve all of the above in one shot from the terminal like so (take note of the placement of single and double quotes here…):
~ $ sudo sh -c \
'echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" > \
~ $ sudo sh -c \
'echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" > \
Next, add the package repository key:
~ $ sudo apt-get install wget ca-certificates
~ $ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
~ $ sudo apt-get install wget ca-certificates
~ $ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
Then, we need to update our package sources:
~ $ sudo apt-get update
Once that's done, we need to upgrade packages to the latest versions:
~ $ sudo apt-get upgrade
Note, this can be a long process. Also, you may be prompted at several points to make some choices about configuration items. Specifically, you may informed that this that or the other configuration file has been changed, and asked if you want to keep your original version, or replace with the package maintainer's version. Select "Y" to accept the package maintainer's version in these cases.
When the upgrade process finishes, we are ready to install Postgres (we'll also include pgadmin3):
~ $ sudo apt-get install postgresql-9.4 pgadmin3
This shouldn't take long (especially compared to the installation times for certain other GUI – installer-based database platforms. I'm looking at you, SQL Server). Once the installation completes, we're ready to configure our new database.
We've now installed both PostgreSQL and the database management utility Pg Admin 3. Next, we should understand a few things about how PostgreSQL works, out of the box.
The Postgres User
When PostgreSQL was installed, a system user account named postgres was created. with a matching user account in Postgres. By default, the postgres user account is not configured with a password, so it is not possible to log into the server using the postgres user account without first creating a password for it. This postgres account has an all-access pass on your postgres database server, permission-wise. The postgres user account is analogous to the sa account in SQL Server. For security reasons, it is recommended that a password not be created for the postgres account.
The Postgres Database
PostgresSql is installed with a default database named…wait for it… postgres. From the PostgreSQL documentation:
Creating a database cluster consists of creating the directories in which the database data will live, generating the shared catalog tables (tables that belong to the whole cluster rather than to any particular database), and creating the "template1" and "postgres" databases . . .
. . . The postgres database is a default database meant for use by users, utilities and third party applications.
Creating a database cluster consists of creating the directories in which the database data will live, generating the shared catalog tables (tables that belong to the whole cluster rather than to any particular database), and creating the "template1" and "postgres" databases . . .
. . . The postgres database is a default database meant for use by users, utilities and third party applications.
For the most part, we use the postgres database for admin purposes, and create new databases on the PostgreSQL server to suit our needs.
The psql Command Line Utility
PostgreSQL includes psql, a command line utility for managing your databases and server. While a GUI-based utility such as pgadmin3 is often easier to use in the day-to-day, the command line utilty psql is also handy. Psql offers complete control of your Postgres system from the terminal, including the ability to execute SQL queries.
Also, we need to use psql to perform our initial configuration, and to create an initial database super user.
Since we will not be creating a password for the postgres user account, we need a super-user account in order to work with our database in the day-to-day.
To do this, we will gain access to the postgres account through your system root user, and then use that postgres account to create a new super-user account on your Postgres installation which can be regulated more effectively. As an example, from my own machine (comments denoted by ##):
## switch user to root:
xivsolutions@mint-vm ~ $ su -
## switch user to postgres:
mint-vm ~ # su - postgres
postgres@mint-vm ~ $
## switch user to root:
xivsolutions@mint-vm ~ $ su -
## switch user to postgres:
mint-vm ~ # su - postgres
postgres@mint-vm ~ $
As we can see, we now have a prompt for the postgres user. We can now log in to the default postgres database and, using psql, create a super user account for ourselves:
To get into the psql command line utility, we type the following:
postgres@mint-vm ~ $ psql
Now, from the psql prompt, enter the following. Note the name you specify for your super-user account should match the system user account you plan to use to manage your Postgres Installation (use your own user account name in place of youruseraccount here):
postgres=# CREATE USER youruseraccount
postgres-# WITH SUPERUSER CREATEDB CREATEROLE
postgres-# PASSWORD 'userAccountPassword';
postgres=# CREATE USER youruseraccount
postgres-# WITH SUPERUSER CREATEDB CREATEROLE
postgres-# PASSWORD 'userAccountPassword';
Notice in the above we can enter multiple lines of SQL. The SQL is not executed until we enter a semi-colon followed by enter. Which means, the semi-colon matters!
Now, we can exit psql, exit the postgres user, and exit root like so:
postgres=# \q
postgres@mint-vm ~ $ exit
mint-vm ~ # exit
xivsolutions@mint-vm ~ $
postgres=# \q
postgres@mint-vm ~ $ exit
mint-vm ~ # exit
xivsolutions@mint-vm ~ $
With that, we should now be able to log in using psql and make sure everything is wired up correctly.
Now, just to make sure everything is working correctly, let's log in with psql using our new super user account and create a quick test database:
xivsolutions@mint-vm ~ $ psql postgres
psql (9.4.1)
Type "help" for help.
xivsolutions@mint-vm ~ $ psql postgres
psql (9.4.1)
Type "help" for help.
Note in the above, we specified the postgres default database when we logged in, since there aren' tyet any other databases to connect to. We'll use the default postgres as our admin platform, create a new database, and then connect to the new database to test things out.
So, let's create a database to play with (once again, make sure to end the SQL statement with a semi-colon!):
postgres=# CREATE DATABASE test_db WITH OWNER xivsolutions;
Now that we have our own database to mess with, use the \connect command to switch psql to that:
postgres=# \connect test_db;
You are now connected to database "test_db" as user "xivsolutions".
postgres=# \connect test_db;
You are now connected to database "test_db" as user "xivsolutions".
Now, let's whip up a quick and dirty table, insert some data, and query:
test_db=# CREATE TABLE products (id SERIAL PRIMARY KEY, name TEXT);
test_db=# INSERT INTO products (name) VALUES ('Brass Widgets');
test_db=# SELECT * FROM products;
id | name
1 | Brass Widgets
(1 row)
test_db=# CREATE TABLE products (id SERIAL PRIMARY KEY, name TEXT);
test_db=# INSERT INTO products (name) VALUES ('Brass Widgets');
test_db=# SELECT * FROM products;
id | name
1 | Brass Widgets
(1 row)
This is a quick example of what can be done from the psql command line. psql is a powerful tool, and is very much worth exploring. While GUI-based tools like PG Admin 3 and others certainly can be helpful, gaining a certain level of comfort working with Postgres from the terminal will save you time in many cases.
That said, let's configure PG Admin 3, so we can have our cake and eat it too.
PG Admin 3 is a free, open source GUI database management tool for Postgres. While the GUI itself is not as polished as some, all the essentials are there. We already installed PG Admin 3 when we installed Postgres itself, so let's take a look.
First off, open PG Admin 3from the terminal:
xivsolutions@mint-17 ~ $ pgadmin3
You will probably see something like this:
Before we can do much of anything here, we need to add our new database server. Since we are working on our local machine, we'll go ahead and add a local server, which points to localhost. Use File –> Add Server… to open the Server Registration Dialog, and you should see something like the following:
Note the default values you see in the above may differ slightly on your machine. We're going to provide a name by which our local server will be known, specify the host, and make sure that the User Name matches our new Super User name (which in most cases should match our system user name, although this is not a requirement).
As an example, on my machine, I set things up like so:
In the above note that I deselected the "Store Password" option. In general, storing of Postgres user passwords is not recommended, although you may consider your circumstances and proceed accordingly. For example, if you are setting up a local development installation on your laptop, you may choose to store the password anyway. Next, hit "OK" and voila – our existing Postgres database server is available in PG Admin 3:
Now you can use PG Admin 3 to create new databases, tables, query, and all the other tasks you might expect. While the GUI experience is not as polished as some commercially available alternatives, you will find that PG Admin 3 is highly functional, and can handle most of your database administration needs quite well.
When we performed our installation and configuration above, we basically allowed Postgres to use its own sensible defaults for most things. Most of the time, if you are setting up Postgres on your own machine, for development or just to mess around, these are sufficient. However, understanding some of the basic configuration options, how and where these are set, can be most helpful.
When Apt installs Postgres, it creates a few directories by default:
/etc/postgresql/9.4/main – Primary PostgreSQL configuration files are located here. This directory is owned by root, so you will need to elevate your privileges to edit files in here. Of particular interest to us are two files:
/var/lib/postgresql/9.4/main – Default location for the database cluster and associated files. Above, when we initialized our database, we were working with database files in this location.
For a variety of reasons we may wish to specify a different directory for our database files. We may want to keep them more easily accessible, or we might have set up our system with a separate partition for data files. In any case, if we want to use a location other than the default for our database cluster, we can.
The Postgres cluster directory must be owned by the postgres user, so we need to create the directory, and then assign ownership to postgres.
For our example, we'll create a /database directory in our file system root, and within that a pg subdirectory:
$ sudo mkdir –p /database/pg
$ sudo chown -R postgres /database
$ sudo mkdir –p /database/pg
$ sudo chown -R postgres /database
In the above, the –p flag tells bash to make sure any leading directories are created on the way to the final directory. The –R flag used with chown tells chown to work recursively, and apply the ownership change to any nested directories or files.
Now we need to initialize the new database cluster in the new directory. Note, if you are already running an existing postgres instance, it is best to stop the server before moving the data directory:
$ sudo service postgresql stop
Once again, we will need to get to our postgres user through root, and then initialize the new cluster (note – I'm showing the full terminal prompt here for clarity, so we can see which user privileges are used):
xivsolutions@mint-vm / $ su -
mint-vm ~ # su - postgres
postgres@mint-vm ~ $ /usr/lib/postgresql/9.4/bin/initdb -D /database/pg
postgres@mint-vm ~ $ exit
mint-vm ~ # exit
xivsolutions@mint-vm / $
xivsolutions@mint-vm / $ su -
postgres@mint-vm ~ $ /usr/lib/postgresql/9.4/bin/initdb -D /database/pg
xivsolutions@mint-vm / $
Don't forget to exit from the postgres user, and then also exit root as shown.
Next, we need to edit the postgresql.conf file and point the data_directory variable to the new cluster location. We can open the file with elevated privileges in gedit like so:
$ sudo gedit /etc/postgresql/9.4/main/postgresql.conf
Scroll down in the file to the file locations section, comment out the existing entry for data_directory (using the '#' character), and add a new entry pointing to our new directory like so:
# The default values of these variables are driven from the -D command-line
# option or PGDATA environment variable, represented here as ConfigDir.
# Add a '#' to the beginning of the line below:
# data_directory = '/var/lib/postgresql/9.4/main' # use data in another directory
data_directory = '/database/pg'
# Blah blah more configuration stuff . . .
# The default values of these variables are driven from the -D command-line
# option or PGDATA environment variable, represented here as ConfigDir.
# Add a '#' to the beginning of the line below:
# data_directory = '/var/lib/postgresql/9.4/main' # use data in another directory
data_directory = '/database/pg'
# Blah blah more configuration stuff . . .
Save and exit Gedit, then re-start the postgres server:
$ sudo service postgresql restart
NOTE: If you forgot to stop an existing instance of Postgres before moving the data directory (or for other potential reasons), you may receive an error indicating that "the pid file is invalid, and to manually kill the stale server process." If this happens, you can manually kill the process with the following:
sudo pkill -u postgres
Before restarting the server, it is important to make certain all Postgres processes have, in fact, stopped. Make sure that the shell command ps returns no results when used as follows:
ps -u postgres
Then go ahead and restart postgres as per previous.
You should now be running Postgres in the new location. Note that any existing database files did not move as part of this process, so you will need to follow the previous steps for creating a new super user, etc.
In upcoming posts, we'll take a look at some of the stand-out features of this database.
If you are just digging in to PostgreSQL, Linux, or both, see some of these excellent resources for additional information:
Some OSS projects I'm privileged to be involved with using PostgreSQL:
My name is John Atten, and my "handle" on many of my online accounts is xivSolutions. I am Fascinated by all things technology and software development. I work mostly with C#, JavaScript/Node, and databases of many flavors. Actively learning always. I dig web development. I am always looking for new information, and value your feedback (especially where I got something wrong!). You can email me at:
johnatten at typecastexception dot com
Get notified when a new post is published.


text:
Yeah there could be different Quincies. Different clans, different names and abilities.
And that's true, not all of them have German names. Most do though. I guess the ones with German names are usually the more evil ones.
And Kirge referred to the Ishidas by their name, so I doubt it's a fake name.


text:
Crazy Snow Camp, looking for people to join Switzerland / Bosnia
Over Christmas and newyear I went on this Crazy Snow Camp which was absolutely amazing and I am planning to go again if we can find enough lovely crazy people to join ;-) Feb 1-8 Switzerland and March 1-8 Bosnia.
I surely hope so as...... guess I said it already but will say it again it was amazing !
Made a little video for the group you can see on the website
CrazyCamp.org | Home of the Crazy Theme CampsCrazyCamp.org
This is right on the edge of spamminess. It's obvious spam (I made five million dollars a day from this website, but I'm not affiliated -- honest!) but it's at least somewhat on-topic. We allowed this one http://www.snowboardingforum.com/gen...eb-2014-a.html the other day...
|All times are GMT -5. The time now is 07:02 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2015, vBulletin Solutions, Inc.
Content Relevant URLs by vBSEO 3.6.0 PL2


text:
Harrison guard Besty Grogan drives on Frankfort's Emily Cunningham during the Raiders' 38-37 victory Saturday. / By Michael Heinz/Journal & Courier
Just because Harrison and Frankfort were playing for seventh place in the girls J&C Hoops Classic on Saturday afternoon, that didn't mean there couldn't be a little excitement.
With 5.4 seconds left, Raider sophomore Kelsey Barr drained a wide open 3 from the right side to give Harrison its first victory of the season, 38-37.
"I just knew we needed a 3 to win it," Barr said. "Betsy (Grogan) did a great job of getting me the ball and I just shot it and hoped it went in. I honestly thought it wasn't going to go in."
Prior to her game winner, Barr had only attempted one other shot -- a missed 3-pointer.
"We know if we can get it to her on a spot-up shot, she is going to get it to go down," Harrison coach Jane Schott said. "Betsy did a great job of creating. We have not worked a lot of end of game situations, and I didn't have any timeouts left, so it was nice to have a senior point guard to get the ball in the right place."
Frankfort called a timeout immediately after Barr's winning shot and worked the ball up the court, but Frankfort junior Jennifer Stoms' long-range 3-point attempt hit the rim and fell away at the buzzer. Stoms led all scorers with 14 points.
"We had a breakdown of communication in who had (Barr)," Hot Dogs coach Ed Niehaus said. "With high school kids, you'll have that sometimes in pressure situations. We just have to learn from that and make sure next time we know what is happening and be there at the right time and the right place."
Neither team had a bigger lead than five points.
The Raiders held a 32-27 advantage after a 3-point play by Grogan with 5:49 to play, but Frankfort came back to take a 36-34 lead after a basket by Rachel Kauffman with 2:30 left on the clock. Ally Byrne, who finished with 11 points and seven rebounds, added a free throw with 13.8 seconds left to make it 37-35.
The teams combined for 48 turnovers, with Harrison committing 25.
"We're really pleased with that effort," Schott said. "We just need some confidence."
Kristen Martin led Harrison in scoring with 10.


text:
Game 2: Rangers' 8-6 win over Tampa Bay
Photo: Tom Fox/Staff Photographer
Texas Rangers second baseman Ian Kinsler takes off as he gets two runs in during the sixth inning of their American League Division Series game against the Tampa Bay Rays Saturday, October 1, 2011 at Rangers Ballpark in Arlington.
To post a comment, log into your chosen social network and then add your comment below. Your comments are subject to our Terms of Service and the privacy policy and terms of service of your social network. If you do not want to comment with a social network, please consider writing a letter to the editor.


text:
The walk that covers all the towers is strictly for the fit - once you start there is no way back and on a timed tour you don't have much time to rest. But the views were well worth it. Otherwise, you can go to the one top turret which is an easy walk. The countryside all around is picturesque, and probably looks much the same as Victorian times.
April 2010
Dirk M
South Africa
Some content licensed under a Creative Commons Attribution 3.0 License.
© 1997–2015 Viator, Inc. CUR015 - 330214 All rights reserved. Viator is a registered trademark of Viator, Inc.
is a Service Mark of Viator, Inc. Travel with an Insider is a Service Mark of Viator, Inc.
Use of this website constitutes acceptance of Viator's Terms & Conditions.
Viator uses cookies to improve your experience on our website. Learn more about how we use cookies and how to change your cookie settings | Close message


text:
I have been trying to find a V neck, princess seamed t-shirt pattern and the closest I can find is McCalls2818
Is there any reason I couldnt make this from a knit fabric? I realise I'd probably need to go down a size or two but other than that, can you see any reason this wouldnt work as a knit?
Thanks :o)
------Sew Much Fabric, Sew Little Time
For jersey knits, I would cut the back on the fold and eliminate the buttons, and check the amount of sleeve ease (I don't like ease in knit sleeves). I would eliminate neckline facings & bind instead.
For doubleknits, which have little to no stretch, I'd bind the neckline rather than any facings but otherwise would sew as if it were a woven fabric.
For sizing, I'd do a muslin first before using the good stuff, either an extra length of the good stuff or a similiar knit that you don't care much about, just to be safe.
I saw a v-neck princess t-shirt (for knits) pattern just the other day, I'll try to remember where. Coulda been Christine Jonson.
------I heart Woo (HimmyCat). Until we meet again, my beautiful little boy. I love you.
Thanks for the advise.
I should have added in my first post that I would eliminate the back closure and just cut on the fold.
If you could remember where you saw the knit pattern, I certainly love to know.
Thanks :o)
Vogue 8323 princess seam t-shirt, but scoop neck. That would be easy to convert to a V-neck.
The one I'd had in mind was the Trudy Jansen #707 also not a V-neck but easy to convert.
Either of the above would be far easier to convert to a V-neck than to reduce sleeve ease, adjust sizing etc on the pattern for wovens. Hope this helps!
Pesonally I'd use Vogue 8323 and add a v-neckline from another pattern. I think it would be a whole lot easier. This knit, princess seam pattern is very popular for a reason.
------Belinda. Melbourne, Australia
Vogue 8323 in all views is my absolute! favorite top pattern. I think you would get great results for the look you are after.
------She looks for wool and flax And works with her hands in delight. Proverbs 31:13 NAS
* Advertising and soliciting is strictly prohibited on PatternReview.com. If you find a post which is not in agreement with our Terms and Conditions, please click on the Report Post button to report it.
Class Details
by: Elle D
Pattern Details
by: bindurk
Online Classes
Sewing Machines
Sign Up
Shop Now
Merchant Gallery
Conditions of Use | Posting Guidelines | Privacy Policy | Shipping Rates | Returns & Refunds | Contact Us | About | New To PR | Advertising
Copyright © 2015 PatternReview.com® , OSATech, Inc. All rights reserved.


text:
Cape Cod News
Where to get the perfect bowl of clam chowder on the Cape6 Sep 2012 8:01 AM
For decades, a fierce debate has raged about the relative merits of Manhattan and New England clam chowders. Although that dispute may rage for years, there is no denying that either one can be perfect on a brisk autumn afternoon. Of course, no place has a stronger and more distinguished reputation for producing savory, delicately balanced New England clam chowder than Cape Cod, a longstanding bulwark of all things seafood.
The Cape is heavy with places to down this local favorite, but, of course, not all of these venues are equally worthy of your patronage. Owners of Cape Cod homes have come to expect only the best from their chowder, so knowing where to get the cream of the crop is vital for any Cape resident.
Here are a few of the restaurants that many people believe serve the best bowl of clam chowder money can buy.
Brewster Inn & Chowder House
This venerable institution, located at 1993 RT. 6A in Brewster, has been serving steaming bowls of the dish for almost a century, and has developed quite a following. However, unlike some other spots on the Cape, Brewster Inn is more of a local favorite than a tourist destination.
As such, the food is traditional and in line with the tastes of seasoned Cape Codders. People keep coming back to this restaurant for several reasons, and its extensive list of seafood dishes and soups is high on the list. Additionally, its reputation, for having the best martini in town, according to Frommer's, certainly doesn't hurt.
Chatham Squire
For a traditional chowder-gulping experience, Cape Cod residents often head to 152 South Shore Dr. in South Yarmouth to find The Skipper Restaurant and Chowder House. Here, they can get a taste of classic clam chowder with a great view of the Nantucket Sound.
The restaurant has been perfecting its chowder recipe since 1936. Over that time, many locals believe it has achieved the perfect balance of fresh cream, hearty potatoes and - of course - delicious clams.
With rustic decor and an extensive beer selection, The Skipper is considered by numerous Cape residents to be an ideal place to while away an afternoon enjoying the view, the friendly crowd and, above all, a perfect bowl of chowder.
Between these two venues - and many more on scenic Cape Cod - it is likely that even the most entrenched Manhattan-chowder fan will find room in his or her heart - and belly- for a hot bowl of the New England variety.


text:
Wine Search
Search Results
Click on any name below for more info including weblinks, email addresses, and info on retailers who carry many of these products.
Please note: We review wine, beer, and spirits. We don't sell it. Prices may vary significantly due to shipping fees and state taxes, and some items may be hard to find.
Recent Reviews - We haven't seen any wine matching your search criteria in the last year. If you are the producer or marketer of this kind of wine, please consider sending in the current vintage for review. How to Submit Samples
Older Reviews - The following reviews were conducted 12 to 0.000000 months ago. Some wines may be hard to find or may no longer be available. Below are 1 through 4 of the 4 older reviews found.
91 • Momokawa "Ruby" Junmai Ginjo Saké $12. Best Buy.
Very pale straw color. Bold umami aromas of sautéed shittakes, hard cheese rind, and coconut meat follow through on a soft, round entry to a dryish medium body with good depth and a starfruit, jicama, and honey roasted almond accented finish. A savory, sake that will pair fantastically with teriyaki and tempura. (tasted on Jun-15-2010)
90 • Momokawa Organic Junmai Ginjo Saké $13. Best Buy. Certified Organic
Clear with a silvery green cast. Aromas of Asian pear, tapioca pudding, and star anise follow through on a supple entry to a dry-yet-fruity, vinous medium-to-full body with great depth and balance. Finishes with a nougat, jicama, and sweet rice cracker accented fade. A tasty and well crafted sake for sipping or food. (tasted on Jun-15-2010)
90 • "G" Joy Junmai Ginjo Genshu Saké $20.
Very pale straw green color. Aromas of tapioca powder, white toffee, and banana cake follow through on a soft, creamy entry to a dry-yet-fruity medium-full body with toasty almond nougat and caramelized pear notes. Finishes with a peppery radish and dusty mineral accented fade that serves to balance the more confected notes. (tasted on Jun-15-2010)
86 • Momokawa "Silver" Tanrei Junmai Ginjo Sake $12. Best Buy.|Find-a-Wine|
Floral aromas of peach danish, honeysuckle, and spicy poached apple follow through on a soft, silky entry to a dryish medium body with notes of wet rice dough and toasted pistachio. Finishes with a drying, rice flour, yellow plum, and radish accented fade. Interesting. Try in a saketini. (tasted on Jun-15-2010)
418 ms


text:
Michelin tire recall, Coby TV recall
Don't Waste Your Money
One of the most popular tire brands, which advertises safety in its magazine ads and TV commercials, is recalling more than a million tires.
Michelin, long considered a premium brand, is recalling 1.2 million LTX tires sold as original equipment on many new trucks and SUV's.
The company has no reports of any injuries, but has several reports of the tires separating under heavy use.
Affected Tires
Affected are LTX M/S (mud and snow) tires, made between January 2010 and June 2012.
They were standard on many Ford E Series vans, along with several different brands of pickups and SUV's.
LTX tires are not made in passenger car sizes.
If you suspect you have these tires, contact any authorized retailer. If they are on the recall list, they should give you new tires.
Coby TV Recall
Meantime, a group of electronics retailers is recalling 9,000 Coby 32 inch HDTV's.
These were sold since August 2011 for around $200.
6 of these TV's have overheated and started smoking or catching fire. In one case, a wall was scorched.
Affected TV's are Coby 32 inch HDTV's, model number TFTV3229.
The problem is that Coby is out of business. So you need to contact the store where you bought it, so you stay safe and you don't waste your money.
Don't Waste Your Money is a registered trademark of the EW Scripps Co.
"Like" John Matarese on Facebook
Follow John on Twitter (@DWYM)


text:
Are there any websites (not associated with the owners, of course!) that store and/or keep track of deleted questions and/or answers, like Deletionpedia does to Wikipedia, and YouTomb does to YouTube?
What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 150 Stack Exchange communities.
Do you -really- want to see the deleted content? Let me tell you...99% of it is garbage.
I would suggest that you could mine the data dump if you are that interested. If the data is visible to 10K plus users, it should be available in the dump.
Deleted questions and answers are visible to users with at least 10k reputation points (and moderators)


text:
- Filed Under
Reading, writing, arithmetic and rods and reels.
If the National Fishing in Schools Program accomplishes its mission, those will be the five R's in education.
Dana Cole, a professor at the University of Nebraska who also operates a fly-fishing guide service in Montana, and his daughter, Katie Cole, who also is an educator and avid angler, started the program several years ago. ...


text:
|Renal cells activate the platelet receptor CLEC-2 through podoplanin.
MedLine Citation:
|PMID: 18215137 Owner: NLM Status: MEDLINE
|We have recently shown that the C-type lectin-like receptor, CLEC-2, is expressed on platelets and that it mediates powerful platelet aggregation by the snake venom toxin rhodocytin. In addition, we have provided indirect evidence for an endogenous ligand for CLEC-2 in renal cells expressing HIV-1. This putative ligand facilitates transmission of HIV through its incorporation into the viral envelope and binding to CLEC-2 on platelets. The aim of the present study was to identify the ligand on these cells which binds to CLEC-2 on platelets. Recombinant CLEC-2 exhibits specific binding to HEK-293T (human embryonic kidney) cells in which the HIV can be grown. Furthermore, HEK-293T cells activate both platelets and CLEC-2-transfected DT-40 B-cells. The transmembrane protein podoplanin was identified on HEK-293T cells and was demonstrated to mediate both binding of HEK-293T cells to CLEC-2 and HEK-293T cell activation of CLEC-2-transfected DT-40 B-cells. Podoplanin is expressed on renal cells (podocytes). Furthermore, a direct interaction between CLEC-2 and podoplanin was confirmed using surface plasmon resonance and was shown to be independent of glycosylation of CLEC-2. The interaction has an affinity of 24.5+/-3.7 microM. The present study identifies podoplanin as a ligand for CLEC-2 on renal cells.
|Charita M Christou; Andrew C Pearce; Aleksandra A Watson; Anita R Mistry; Alice Y Pollitt; Angharad E Fenton-May; Louise A Johnson; David G Jackson; Steve P Watson; Chris A O'Callaghan
Related Documents :
|1505737 - Bordetella heat-labile toxin causes release of radioactivity from smooth muscle cells l...
7725327 - Clostridium sordellii cytotoxin induces phosphorylation of an 80,000 mol. wt protein in...
8757867 - Translocation of shiga toxin across polarized intestinal cells in tissue culture.
12165427 - The viral killer system in yeast: from molecular biology to application.
19396247 - Visualization of sporopollenin-containing pathogenic green micro-alga prototheca wicker...
23468377 - Fgf10 overexpression enhances the formation of tissue-engineered small intestine.
Publication Detail:
|Type: Journal Article; Research Support, Non-U.S. Gov't
Journal Detail:
|Title: The Biochemical journal Volume: 411 ISSN: 1470-8728 ISO Abbreviation: Biochem. J. Publication Date: 2008 Apr
Date Detail:
|Created Date: 2008-03-12 Completed Date: 2008-04-15 Revised Date: 2014-02-19
Medline Journal Info:
|Nlm Unique ID: 2984726R Medline TA: Biochem J Country: England
Other Details:
|Languages: eng Pagination: 133-40 Citation Subset: IM
Export Citation:
|APA/MLA Format Download EndNote Download BibTex
|MeSH Terms
Cell Line
Cloning, Molecular
Kidney / chemistry, cytology*
Lectins, C-Type / metabolism*
Membrane Glycoproteins / analysis, metabolism*
Podocytes / chemistry
Protein Binding
Surface Plasmon Resonance
|Grant Support
|G0801186//Medical Research Council; G116/165//Medical Research Council; G116/165(64081)//Medical Research Council; MC_U137884182//Medical Research Council; PG/07/064/23293//British Heart Foundation; PG/11/4/28645//British Heart Foundation; //Wellcome Trust
Reg. No./Substance:
|0/CLEC2B protein, human; 0/Lectins, C-Type; 0/Ligands; 0/Membrane Glycoproteins; 0/PDPN protein, human
From MEDLINE®/PubMed®, a database of the U.S. National Library of Medicine
Previous Document: Involvement of Egr-1 in HGF-induced elevation of the human 5alpha-R1 gene in human hepatocellular ca...
Next Document: Two interaction sites on mammalian adenylyl cyclase type I and II: modulation by calmodulin and G(be...


text:
Updated 12/23/2013
A steady favorite for its lively ambience and dependable Mediterranean fare, Napi's presents a long and varied menu. The food and the interior share a penchant for unusual, striking juxtapositions—a classical sculpture in front of an abstract canvas, for instance. On the gustatory front, look for sharp combinations such as Thai chicken and shrimp, cod amandine, and Brazilian-style shrimp.
Wild mushroom ravioli is just one of several very nice vegetarian dishes.
7 Freeman St., Provincetown, Massachusetts, 02657, United States
Website: www.napis-restaurant.com
Restaurant Details:
Updated 12/23/2013
No Thanks


text:
With less than two minutes to go, Max Banziger scored his third goal of the season to lift Marymount University to a 2-1 non-conference victory against Gettysburg College in men's soccer action at Clark Field.
The Saints (4-5) opened the scoring in the 40th minute off a free kick from the corner of the field.
The Bullets kept the pressure on and broke through in the 60th minute when Brooks Taylor found the tail end of a long ball from Kyle Franks and put it into the net from the top corner of the box. The goal was Taylor's second on the season.
Marymount 1 1 -- 2
Gettysburg 1 0 -- 1
First Half --1. MU, Akram Bensalem (Onar Yousefi, 39:27, 2. GC, Brooks Taylor, (Kyle Franks), 59:15
Second -- 3. MU, Max Banziger, (Bensalem), 88:12.
Shots On Goal --MU 2, GC 5
Goalies --MU, Logan Cropper (4 saves), GC, Connor Darrell (0 saves)
--- Catholic University 1, York College 0:The Catholic University Cardinals scored in the 82nd minute to swipe a non-conference win at York.
The Cardinals improved to 5-4 overall while the Green and White dropped to 4-3-1.
The game was marked by physical and aggressive play from both sides. The Cardinals squeezed off the first five shots of the game, but York had the first dangerous scoring chance when Kirsten Good blasted a shot from outside the box that scooted just outside the right post.
Catholic 0 1-- 1
York College 0 0 -- 0
Second Half --C, Kaylre Greaves, (Lindsay Aleman), 81:14.
Shots On Goal --C 20, YCP 12
Corners --C 2, YC 2
Goalies --C, Amy-Lynn Friel (6 saves), YC, Stevi Lukacz (8 saves)
--- McDaniel 4, Goucher 0:McDaniel scored a pair of goals in each half to register its third straight win in non-conference action.
Meghan Sturgill led the Green Terror with a goal and an assist, leading her team to its best eight-game start since the 2004 squad also started 6-2.
Liz Stradtman made four saves for the Gophers in nearly 60 minutes of relief action between the pipes.
McDaniel 2 2 -- 4
Goucher 0 0 -- 0
First Half -- 1. McD, Meghan Sturgill, (Christina Wroblewski), 7:31, 2. McD, Sam Wilson, (Erica Diffendal), 17:54
Second -- 3. McD, Nicole Hill, (Meghan Sturgill), 55:38, 4. McD, Maggie Quinn, (Catherine Wroblewski), 68:00
Shots on Goal -- McD 10, G 5
Corners -- McD 5, G 1
Goalies -- McD, Haley Jacobs (4 saves), G, Liz Stradtman (4 saves)
--- Susquehanna 3, Gettysburg 1: Gettysburg rallied late, but Susquehanna used a serving spree at the end of the fourth game to hold on for a non-conference victory in Bream Gymnasium.
The Crusaders (14-3) won the first two games before the Bullets (7-8) came back to win the third game, 25-18. Gettysburg trailed just 18-15 late in the fourth game before Erin Byrne iced the match for Susquehanna, reeling off five consecutive aces in the Crusaders' 25-18 victory.
at Gettysburg
25-23, 25-22, 18-25, 25-18
Susquehanna stats -- Jessica Holm (13 kills, 2 aces), Erin Byrne (13 kills, 8 aces, 2 blocks), Maggie O'Hearn (34 assists, 4 kills, 6 aces, 1 block, 8 digs), Sarah Paluck (14 digs).
Gettysburg stats -- Courtney Cyr (12 kills, 1 block), Sarah Gorski (11 kills, 2 blocks, 1 assist, 2 digs), Lizzy Kuhn (33 assists, 6 kills, 3 bloks, 10 digs), Kelly Milone (13 digs, 3 assists).


text: (Larry French, Getty Images) [ Miss America Talks Super Bowl, Atlantic City By Joe Votruba February 1, 2014 When you wear the Miss America crown you can expect a lot of attention and responsibility but what you can't expect is for one day to be just like the next - especially when the Super Bowl is about to kick off. Read More|Comment Category: Deminski & Doyle, Nation & World, News, Super Bowl Tags: Joe V posts, Miss Amaerica, Nina Davuluri, Super Bowl 2014 Send to a friend! Share on Facebook Share on Twitter Pin it! Reddit This! Share on Tumblr!


text:
Riverside Camping
A family owned and operated campground for 35 years along the scenic South Fork of the Shenandoah River in the heart of the Shenandoah Valley. Minutes from Luray Caverns, The George Washington National Forest, Skyline Drive and New Market Battlefield. April-November with reasonable rates. Clean, comfortable, peaceful and safe environment. 12 miles excellent canoe waters. Located on Highway 340 between Luray and Shenandoah. Register at Kite's Store, a quaint old country store, when you visit us on the Shenandoah. Mostly seasonal campers, but over night camping available for campers and tents.


text:
World Cup 2014: 100 great World Cup moments - 64 days to go
Cannot play media. Sorry, this media is not available in your territory.
BBC Sport counts down 100 of the greatest World Cup moments, as the 2014 tournament in Brazil draws nearer.
Today we look back to a stormy encounter between Portugal and Netherlands in the second round of the 2006 World Cup in Germany. Four players are sent off and 16 yellow cards handed out - the most in any World Cup match in history.
Portugal won the game 1-0, but the match was so bad-tempered it was latter dubbed the 'Battle of Nuremberg'.
Available to UK users only.
More from World Cup 2014
Most watched/listened


text:
Man and young boy wanted for Provo Canyon burglary
Utah County homeowners who were burglarized by an adult and a pint-sized tag-along in December are offering a cash reward for any information that could nab the criminals.
Utah County Sheriff's Sgt. Spencer Cannon said Thursday that a woman living in the Springdell neighborhood of Provo Canyon discovered a man in his 20s and a child between the ages of 8 and 12 inside her home stealing valuables. When they were discovered, the two ran away with jewelry and a Nikon camera together worth about $10,000.
The woman chased after the two and saw them run across a nearby stream to Highway 89 before she lost them. A neighbor also saw the pair wandering the area that same day. The burglary occurred at about 11:30 a.m.
Cannon said that police are especially concerned that a young boy was involved in the crime. Authorities aren't sure what connection the two may have.
"Fortunately for this case, they were more worried about getting away than not being identified," Cannon said. The homeowner was able to provide a fairly detailed description of the two burglars.
The man is described as being between 20 and 25 years old, about 5-foot, with a medium build, dark hair, dark complexion and scruffy facial hair. He was wearing a brown and black coat, jeans and boots.
The boy is described as shorter than average for his approximate age. He was wearing a light-colored jacket with a dark knit hat or hood. He also is believed to have worn a pair of white Nike Shox Monster shoes.
Twitter: @KimballBennion
Who to Call
P Anyone with information about this burglary is encouraged to call Utah County Sheriff's Det. Josh Chappell at 801-851-4013.


text:
Monmouth's Ed Waite takes a shot while St. Francis' Stephon Mosley defends on Thursday.
- Filed Under
After seven straight losses, King Rice knew something had to change for his Monmouth University men's basketball team.
So with senior guard Jesse Steele having struggled from the floor during their recent skid, the head coach spent time working with him on three-foot shots so Steele could see the ball going in again, resulting in five three-pointers against St. Francis (Pa.) on Thursday night.
He plugged freshman forward Tyrone O'Garro into the starting lineup alongside sophomore Khalil Brown in the frontcourt, and the early energy was noticeable at both ends of the court. ...


text:
Interested in premises and fundin for a team? And gaming future of Ireland!3 years ago News 1 comment
The current standing of gaming in Ireland, and a small proposal for a possible opening for a new team.
The Mod Data Base group for Irish users. Post in the forum: Share ideas, help each other, work together and have fun!
The current standing of gaming in Ireland, and a small proposal for a possible opening for a new team.
An update on the group, it's plan, and it's direction.
Just got verification, things are going! This news is just to outline the benefits of the Irish group for moddb users from Ireland and aims of the Irish...
The Irish Group is just waiting activation from the administrators, and once that [hopefully!] goes through, the group should be going. Hope to see all...
No articles were found matching the criteria specified. We suggest you try the article list with no filter applied, to browse all available. Post article and help us achieve our mission of showcasing the best content from all developers.
YAY! us
Urban Chaos, what a game!
sure was
Nice group :)
You guys rule
Any of you guys from Belfast? Currently here on holiday for a few days. Wondering about a meet up perhaps?
Are you member of the EC? Join here: Moddb.com
Hey, this is a shameless plug btw :)
As far as I know I am the only Irish developer working on a project that made it into the indie section of the moty awards. My project Solitude Moddb.com) is for the psp and is compeateing agenst the big boys like Overgrowth and Natural Selection 2 for one of the 5 places.
I would like that you consider voting for us as my team and I would greatly appericate any spot in the top 5, besides it would be nice to see the Irish snag a prize in the moty. No?
Thank you.
Plug away man! It's just another way to show how well an Irish game developer is doing. Speaking of which, if you need a level designer or Prop modeler, let me know I can always lend a hand to low poly modeling =]
Battlefordune ><
Hey there guys so I just had a thought.
Should we have a yearly meet up? Moddb Irish event? I've got contacts in D.I.T College, Kevin Street, Dublin that would love to host such an event. =]
Sounds like a good idea, i doubt i would be able to make it if it was on. Still it would be nice to know that maybe once ever year we could have a chance to meet up.