Green Environment Q&A site proposal

I've took a shot and register a Green Environment Q&A site proposal on Area51:

Green environment
Proposed Q&A site for people interested in stuff recycling, products composting, trash utilization, alternative energy, sustainable economy, wild nature saving, green lifestyle etc. I know there are similar proposals but this one is more general thus may grow faster.

If you feel interested, please go there and follow!

Android Eco 1.3 - new bright design

From feedbacks I've learned design should be brighter and more readable.
Hope this 1.3 version will be more like that.

ecoFootprint

Calculate your personal ecological footprint, textual information taken from the Wildlife Fund site
- offline
- short 19 q and a full 42 q
- english & metric unit systems
- send userbar
- ways to improve
- ecological design
- Creative Commons License

direct link

ecoLamp

Calculate energy and environmental benefits of replacing light bulbs
- offline
- info from Wikipedia
- send userbar
- ecological design
- Creative Commons License
- Chinese translation by http://goapk.com

direct link

ecoTips

Widget, displays tips from Wildlife Fund site
- offline
- forward advice
- ecological design
- Creative Commons License
widget, click on Recycle for next tip
widget, click on text for tips list
list short click - move tip to widget
list long click - send advice

direct link

Android Eco by max.gontar@gmail.com is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
Based on a work at www.panda.org.

Please give your feedbacks!

Press Release for Ecology :)

Singapore Today Online
Be Superman, Save the world with these earth-friendly apps
by May Chua (2010/7/30)

ecoFootprint (Android)
Android users can try ecoFootprint. After taking the quick test (19 questions) or full test (42 questions), you will find out how many Earths the world would need if everyone lived like you, and what you can do to minimise your footprint.

...

ecoTips (Android)
Here's an app that lets you walk the talk. ecoTips presents tips on greener living from the Wildlife Fund site, divided into five categories - home, travel, office, market and garden. You can use this app to educate those around you by sending tips to them via social media, email, Bluetooth or SMS.

Well, it's like a nice word to me :)

And it's an online newspaper, no wood was cut down for printing!

Saving energy color scheme on OLED (Nexus One)

Just to repeat my question from SO:

To sum-up:
Ironic Sans: Ow My Eyes
they say it's not working for simple LCD
http://hackaday.com:
...using only the red pixels dropped the current use down to 35% of what the full color display was pulling...
WikiPedia - AMOLED:
For example, our measurement shows that a commercial QVGA OLED display consumes 3 and 0.7 Watts showing black text on a white background and white text on a black background, respectively.

Android ecoTips - Tips to save the Nature

From WikiPedia:

The World Wide Fund for Nature (WWF) is an international non-governmental organization working on issues regarding the conservation, research and restoration of the environment, formerly named the World Wildlife Fund, which remains its official name in the United States and Canada. It is the world's largest independent conservation organization with over 5 million supporters worldwide, working in more than 90 countries, supporting around 1300 conservation and environmental projects around the world.
...
The group says its mission is "to halt and reverse the destruction of our environment".

So it's really great org, they do the right stuff for human survival.
Also there is a list of tips on their website.

Since all text there is under Creative Commons license, I've made this small Android widget to display those tips. Enjoy!

Features:

• works offline
• forward tip text over email, twitter, SMS etc
• ecological energy-saving design
• Ukrainian and English localization
• Creative Commons license

Please give your feedbacks!!!

Android. Green. Ecology. Lamp.

Several years ago I've decided to upgrade my house lamps from light bulbs to CFL, about 7 items. I knew it will improve my electricity bill, but I never done any calculations.

Lately I was more interested in environment saving, and that brought me to idea of app which will calculate all advantages of energy saving lamps.

By some accident (maybe not-without-StackOverflow) I was gifted with N1. Thank you Google!

With ability to create ecoLamp it would be a crime not to try.

Features:

• works offline
• lamp types description with photos and text from Wikipedia
• calculates energy saving, equivalent coal, gas and oil, CO2 emission, lamps waste and money saving
• generates userbar which you can add to email, Picasa etc
  
  
• settings for electricity tariff and measurement units
• Ukrainian and English localisation

Please give your feedbacks!!!

Fun with SQL (games, painting, puzzles)

Several days ago my question on StackOverflow was deleted by system: Fun with SQL (games, painting, puzzles). Since it was not a real question and would be deleted again if I repost it I decided to post it here on my own territory : )

If you think SQL is boring or dumb or limited, try this:

SQL Games

• Lionel Clarke 3D Maze Game


• CraigD


• Battleship (MS SQL 2008 GEOGRAPHY and GEOMETRY)


• Adam Haines - Tic Tac Toe T-SQL Style


• Kevin Duan - A Sudoku solution with set based T-SQL utilizing binary operators


• Steve Wint - SQL Sudoku


• Steve Wint - T-SQL Checkers


• mySQLgame (online game)

Drawing with SQL

• Roji Thomas - T-SQL Drawing


• Graeme Job - T-SQL Mandelbrot


• Dean Swift - Mandelbrot Fractals Using Stored Procedures


• Gregory Stark - Mandelbrot in Postgres with recursive queries

SQL Puzzles

• A bunch of puzzles from Lionel Clarke blog: 1|2|3|4|5|6|7|8|9


• And of course Joe Celko's Puzzles

SQL Easter eggs

• SQL Server (Microsoft) Easter Eggs


• Database Easter Eggs


• Marco Gralike - Oracle 7.3 Year 2000 problems


• commented by Vikram Das

Songs about SQL

• Rob Lambert - SQL Song


• Roy Osherove - It's Time For Violence: A song about Databases


• SQL Rap Contest at SQLFool


• Chuck Boyce - SQL song parody


• Thomas LaRock - SQL Theme Song


• TidusXIII - 50 ways to inject your SQL

Other

• 99 bottles of beer: SQL version