WordPress DB Tidy

Clean WordPress

As all WordPress developers know, it doesn’t take too long for the database to get clunky, especially with the wp_options table. Continue reading

Advertisements

Minister of 1 Massive Database

From Brainstruck.com

From Brainstruck.com

Do you remember various members of the Labour party going on about that “1 massive database” (to quote IT expert John Prescott)? That was going to tie all public data together. In ONE. MASSIVE. DATABASE. The ill-conceived idea that any IT consultant worth his/her salt would have recommended against, but large corporate IT service providers decided to nod vigorously in agreement, then waste millions of tax payers money implementing systems that they must have known, did not have a hope of fulfilling the requirements. At best, a fabulously expensive experiment. When there is money to be made from ignorance, you can bet your life that business will take full advantage. And none more so that on IT projects, especially government initiated ones. At high-level decision positions, competency in the industry you are working in is a given. In goverment, a Sports minister can become a Work and Pensions minister within a day. Polictians are simply the voice of a department and advisors. Whoever bandied about the phrase “one massive database” to an extent whereby politicans who probably struggled with email, became database champions.

The concept of a single store seems logical enough as a concept, but technologically and architecturally difficult. Plus centralisation of data is a big deal – as whoever is responsible for the centralisation has more control than is necessary or desired. The general feeling is anti-centralisation – so the natural alternative is to think about data in different way, and increase it’s portability. Data that resides in one system can be easily read and manipulated by other systems. Here we go again, into the semantic web territory, where all data in perfectly microformated, with multiple cloud web/data services to process and distribute in a myriad of different ways. This is where philosophy is so right and so wrong – you cannot forget the unpredictability and individualism of human beings, who will do things different to be … well, just different.

Maybe the next government phrase could be “1 massive cloud”, which is of course a complete contradiction. They have interest in Cloud Computing, as data stored in this way transcends many international privact laws. Makes the current phone-tapping scandal seem a little small. Invasion of privacy is about to take a huge leap forward.

Command-line wordpress install

  • ssh root@domain.com
  • cd /var/www/vhosts/domain.com/httpdocs/
  • wget http://wordpress.org/latest.zip
  • unzip latest.zip
  • cp -rf ./wordpress/* ./
  • mysql -uusername -ppassword
  • create database dbname
  • grant usage on *.* to username@localhost identified by ‘password’
  • grant all privileges on dbname.* to username@localhost
  • mv wp-config-sample.php wp-config.php
  • vi ./wp-config.php

Emotion Harvest

“… a database of several million human feelings, increasing by 15,000 – 20,000 new feelings per day. Using a series of playful interfaces, the feelings can be searched and sorted across a number of demographic slices, offering responses to specific questions like: do Europeans feel sad more often than Americans? Do women feel fat more often than men? Does rainy weather affect how we feel? What are the most representative feelings of female New Yorkers in their 20s? What do people feel right now in Baghdad? What were people feeling on Valentine’s Day? Which are the happiest cities in the world? The saddest?”
We Feel Fine / mission

thisisreality

The Facts Burning coal is a leading source of global warming pollution. “GHG Emissions and Sinks 1990–2006,” US EPA 2008 Burning coal is the dirtiest way we produce electricity. “Carbon Dioxide Emissions from the Generation of Electric Power in the United States,” US DOE 2000.; “GHG Emissions and Sinks 1990-2006,” US EPA 2008 There are no homes in America powered by “clean” coal. IEA Greenhouse Gas R&D Programme CO2 Capture and Storage Database; Carbon Capture and Sequestration Technologies Program at MIT, CO2 Capture and Storage Project Database CO2 emissions from U.S. coal-based electricity are greater than emissions from all the cars and trucks in America. “GHG Emissions and Sinks 1990-2006,” US EPA 2008 The coal industry is spending millions advertising “clean” coal, but not a single “clean” coal power plant exists in the U.S. today. “Big Coal Campaigning to Keep Its Industry on Candidates’ Minds,” Wall Street Journal, Oct. 20, 2008; IEA Greenhouse Gas R&D Programme CO2 Capture and Storage Database; Carbon Capture and Sequestration Technologies Program at MIT, CO2 Capture and Storage Project Database “While you might have heard the phrase ‘clean’ coal during the presidential campaign, it’s actually an oxymoron.” Brian Williams, NBC News, Nov 18, 2008 There are roughly 600 coal plants producing electricity in the U.S. Not one of them captures and stores its global warming pollution. “Electricity Facts,” US DOE 2008; IEA Greenhouse Gas R&D Programme CO2 Capture and Storage Database; Carbon Capture and Sequestration Technologies Program at MIT, CO2 Capture and Storage Project Database “‘Clean’ coal is like a healthy cigarette.” Blan Holman, attorney, Southern Environmental Law Center in Charleson, S.C. There is not a single large-scale demonstration “clean” coal plant in the U.S. today. IEA Greenhouse Gas R&D Programme CO2 Capture and Storage Database; Carbon Capture and Sequestration Technologies Program at MIT, CO2 Capture and Storage Project Database Virtually all the new coal plants that have been proposed will, just like their predecessors, release 100 percent of the CO2 they produce into the atmosphere, where it will linger—and contribute to global warming. “Coal Power in a Warming World: A Sensible Transition to Cleaner Energy Options,” Union of Concerned Scientists. Oct. 2008. Although carbon sequestration has been the subject of considerable research and analysis, it has yet to be demonstrated in the form of commercial-scale, fully integrated projects at coal-fired power plants. “Coal Power in a Warming World: A Sensible Transition to Cleaner Energy Options,” Union of Concerned Scientists. Oct. 2008. An investment in wind power produces almost three times as many jobs as the same investment in coal power. And an investment in solar power produces almost four times as many jobs, and energy efficiency, almost thirty times as many jobs as coal power. Based on analysis of the new energy economy released by Earth Policy Institute, Nov. 2008 “We don’t have a plant here in the United States today that has commercially installed carbon capture technology.” Joe Lucas, Vice President of Communications, American Coalition for Clean Coal Electricity (ACCCE). From: “Can Coal Be Clean? A Debate Between Michael Brune of Rainforest Action Network and Joe Lucas of American Coalition for Clean Coal Electricity.” Democracy Now! The War and Peace Report, Oct. 2008 “Without the price on greenhouse gas emissions that is delivered by cap-and-trade mechanisms, CO2 capture and storage will remain a daydream.” Jeroen van der Veer, CEO of Shell. July 2008 Madrid. Shell, “Delivering Energy for Sustainable Growth. The European Perspective,” The 19th World Petroleum Congress Plenary Session, Madrid, June 30, 2008.