Device harvests water from humidity 24 hours a day

https://www.futurity.org/wp/wp-content/uploads/2021/06/water-harvesting-humidity-24-hours-1600.jpgA cone-shaped device on top of a box on a roof

Researchers have developed a condenser for countries where water is in short supply.

Theirs is the first zero-energy solution for harvesting water from the atmosphere throughout the 24-hour daily cycle. It relies on a self-cooling surface and a special radiation shield.

Fresh water is scarce in many parts of the world and getting it comes at great expense. Communities near the ocean can desalinate sea water for this purpose, but doing so requires a large amount of energy.

Further away from the coast, often the only remaining option is to condense atmospheric humidity through cooling, either through processes that similarly require high energy input or by using “passive” technologies that exploit the temperature swing between day and night.

With current passive technologies, such as dew-collecting foils, however, water can only be extracted at night. This is because the sun heats the foils during the day, which makes condensation impossible.

The new technology, for the first time, allows researchers to harvest water 24 hours around the clock, with no energy input, even under the blazing sun.

A diagram shows the cone-shaped radiation shield, radiation-reflecting coating, a glass pane, and a water-repellent coating beneath the shield. Below, there's a water collection container
Schematic of the condensator. (Source: Haechler I et al./Science Advances)

The new device essentially consists of a specially coated glass pane, which both reflects solar radiation and also radiates away its own heat through the atmosphere to the outer space. It thus cools itself down to as much as 15 degrees Celsius (59 degrees F) below the ambient temperature. On the underside of this pane, water vapor from the air condenses into water. The process is the same as can be observed on poorly insulated windows in winter.

The scientists coated the glass with specifically designed polymer and silver layers. This special coating approach causes the pane to emit infrared radiation at a specific wavelength window to the outer space, with no absorption by the atmosphere nor reflection back onto the pane.

Another key element of the device is a novel cone-shaped radiation shield. It largely deflects heat radiation from the atmosphere and shields the pane from incoming solar radiation, while allowing the device to radiate the aforementioned heat outward and thus self-cool, fully passively.

As tests of the new device under real-world conditions on the roof of a building in Zurich showed, the new technology can produce at least twice as much water per area per day as the best current passive technologies based on foils: the small pilot system with a pane diameter of 10 centimeters (about 3.94 inches) delivered 4.6 milliliters (0.155 ounces) of water per day under real-world conditions. Larger devices with larger panes would produce more water accordingly.

The scientists were able to show that, under ideal conditions, they could harvest up to 0.53 deciliters (1.79 ounces) of water per square meter of pane surface per hour.

“This is close to the theoretical maximum value of 0.6 deciliters per hour, which is physically impossible to exceed,” says Iwan Hächler, a doctoral student in the group of Dimos Poulikakos, professor of thermodynamics at ETH Zurich.

Other technologies usually require the condensed water to be wiped from a surface, which requires energy. Without this step, a significant portion of the condensed water would cling to the surface and remain unusable while hindering further condensation. The researchers applied a novel superhydrophobic (extremely water-repellent) coating to the underside of the pane in their water condenser. This causes the condensed water to bead up and run or jump off on its own accord.

“In contrast to other technologies, ours can really function without any additional energy, which is a key advantage,” Hächler says.

The researchers’ goal was to develop a technology for countries with water scarcity and, in particular, for developing and emerging countries. Now, they say, other scientists have the opportunity to further develop this technology or combine it with other methods, such as water desalination, to increase their yield.

The production of the coated panes is relatively simple and building water condensers that are larger than the current pilot system ought to be possible. Similar to the way solar cells feature several modules set up next to each other, several water condensers could also be positioned side by side to piece together a large-scale system.

The research appears in Science Advances.

Source: ETH Zurich

The post Device harvests water from humidity 24 hours a day appeared first on Futurity.

Futurity

MySQL in a Docker Container cheat sheet

Here’s a cheat sheet to run MySQL in a Docker container in your Windows or Mac laptop in a few minutes. In this brief how-to you will:

  1. Install Docker Desktop in your laptop
  2. Download official Oracle MySQL image or Docker Inc. image
  3. Start the container
  4. Administer it
  5. Start a MySQL session and start a Linux session

Download and install Docker

You can download Docker Desktop for Windows or Mac from https://docs.docker.com/desktop/. Install like any other application and you’re ready to move to the next step. As you can read from the docs, Docker Desktop will install several things like Docker Compose or Kubernetes. We’ll use both in advanced examples in future posts.

Pull MySQL Server image

Now you can pull the MySQL Server image. You have two options. You can download the image maintained by Oracle MySQL (find the description here https://dev.mysql.com/doc/refman/8.0/en/linux-installation-docker.html)

docker pull mysql/mysql-server:latest

Or you can download the image maintained by Docker Inc. You can find a description together with examples here: https://hub.docker.com/_/mysql

docker pull mysql 

The differences? Oracle MySQL image runs over Oracle Linux, whereas Docker Inc. image runs over Debian. And if you have a MySQL subscription, you will get Support for the Oracle MySQL Docker image if in trouble.

List Docker images

You can list the brand new MySQL image here. Pay attention to the IMAGE ID field, you will need it (I have downloaded both images, Oracle MySQL and Docker Inc. in the following output).

docker images
REPOSITORY           TAG       IMAGE ID       CREATED       SIZE
mysql                latest    5c62e459e087   6 days ago    556MB
mysql/mysql-server   latest    1504607f1ce7   6 weeks ago   391MB

Start a MySQL image in a Docker container

You can start the container, and choose a:

  • A name for the container (mysql_cnt in the example)
  • The root password
  • The image you want to launch
docker run --name=mysql_cnt -e MYSQL_ROOT_PASSWORD="Password1*" --restart on-failure -d 5c62e459e087

Find additional information to configure the instance in the corresponding image documentation, shared before.

Verify that the container has started normally

Make sure the container is up.

docker ps -a
CONTAINER ID   IMAGE          COMMAND                  CREATED         STATUS         PORTS                 NAMES
30f6e1462b9e   5c62e459e087   "docker-entrypoint.s…"   4 minutes ago   Up 4 minutes   3306/tcp, 33060/tcp   mysql_cnt

Troubleshooting

If the container has not started, you can check logs. In this case, all is working.

docker logs mysql_cnt

[...]
2021-06-28T13:46:43.873232Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.25'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.

Start and stop the container

Stop your container:

docker stop mysql_cnt
mysql_cnt

Verify it’s stopped:

docker ps -a         
CONTAINER ID   IMAGE          COMMAND                  CREATED         STATUS                    PORTS     NAMES
30f6e1462b9e   5c62e459e087   "docker-entrypoint.s…"   5 minutes ago   Exited (0) 1 second ago             mysql_cnt

And restart it:

docker start mysql_cnt
mysql_cnt

Remove the container

As easy as stopping it and running:

docker rm mysql_cnt
mysql_cnt

Get a mysql command line client session

In order to authenticate, you need to have the mysql command line client installed, or even better, MySQL Shell:

docker exec -it mysql_cnt mysql -uroot -p        
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.25 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Create a bash session

In case you would like to install things or edit the my.cnf:

docker exec -it mysql_cnt bash           
root@10b5e2727ef3:/# 

Note that if you installed a Debian based release, you will be able to install stuff like:

apt-get update
apt-get install vim

If you installed the Oracle MySQL image, it comes with Oracle Linux installed. Then use:

microdnf update
microdnf install vim

You are now able to setup Docker in your laptop, download your favorite MySQL image, start it in a container and stop it and also capable of installing packages in the Linux distribution. You can configure and optimize MySQL as usual, using SET PERSIST (recommended over editing the configuration file manually, when possible).

If you are curious and would like to explore running MySQL containerized services, you may want to read the official documentation. You will find several hints to use networking or taking backups.

The post MySQL in a Docker Container cheat sheet appeared first on mortensi.

Planet MySQL

Comic for June 27, 2021

https://assets.amuniversal.com/d165c9409a5601395f68005056a9545d

Thank you for voting.

Hmm. Something went wrong. We will take a look as soon as we can.

Dilbert Daily Strip

How Adhesive Bandages are Made

https://theawesomer.com/photos/2021/06/how_bandages_are_made_t.jpg

How Adhesive Bandages are Made

Link

Next time you get a cut and slap a bandage on it, remember this factory video in appreciation of all the engineering and operational complexity that goes into producing that little thing you stuck on your skin. There’s something incredibly satisfying about watching all of those roller machines running.

The Awesomer

Screwing around at Lowes

I went to Lowes for more safety chain for the U-Haul trailer I’m pulling.

It comes with the DOT safety chain in case your hitch fails.

I wanted chain to padlock the trailer to the truck so it’s harder to steal the trailer by disconnecting it from the truck while it’s  parked.

So I ask for two 5-foot lengths of 5/16 trailer chain while holding some heavy duty padlocks.

The Lowes person and I have this conversation.

“What are you trying to secure?”

“I’m not”

“What’s the chain for?”

“Chain fights.”

“What?”

“Chain fights.  Two men enter, one man leaves.  You’ve never beat a man with a padlock on a chain? ”

“Umm….”

“It’s a hell of a rush.”

“Okay….”

“Chain fights.”

I’m gonna get banned from Lowes.

 

 

Calling All Rebels! CMMG Drops Secret Plans to Build Your Own AR Blaster!

https://cdn0.thetruthaboutguns.com/wp-content/uploads/2021/06/build_blaster.jpegCalling All Rebels! CMMG Drops Secret Plans to Build Your Own AR Blaster!

CMMG has brought a piece of cinematic history to life by pulling together the parts and plans to build an AR Blaster in 22LR.

Check out the interactive video below to view all the parts needed to build your own AR Blaster!

 

 

 

 

Continue reading Calling All Rebels! CMMG Drops Secret Plans to Build Your Own AR Blaster! at The Truth About Guns.

The Truth About Guns

Recall Notice: Winchester and Browning 9mm Ammo

https://www.thefirearmblog.com/blog/wp-content/uploads/2021/06/re-180×180.jpg

Certain lots of Winchester and Browning 115gr 9mm ammo have been recalled for safety.When it comes to handling your firearms in any capacity or context, nothing is more important than safety. Everyone should know the basic firearms safety rules inside and out before they ever get on a live-fire range. Beyond those fundamentals like keeping your gun pointed in a safe direction and keeping your finger off of […]

Read More …

The post Recall Notice: Winchester and Browning 9mm Ammo appeared first on The Firearm Blog.

The Firearm Blog

The Mega Pistol: DIY 3D-Printed 40-Round .22LR Semi-Auto Pistol

https://www.thefirearmblog.com/blog/wp-content/uploads/2021/06/megapistol-180×180.jpg

New DIY "Mega Pistol" 3D-Printed and Aluminum Milled 22LR Semi-AutoI was recently bumming around on YouTube when I came across an interesting video from May 26th featuring a supposedly 100% original design of a semi-automatic .22LR pistol. Coming from the YouTube channel Humphrey Wittinsworth IV, the so-called “Mega Pistol” features a 40-round fixed rotary magazine that would only really be possible to the common […]

Read More …

The post The Mega Pistol: DIY 3D-Printed 40-Round .22LR Semi-Auto Pistol appeared first on The Firearm Blog.

The Firearm Blog