Ok, besides making you look like a dork, what do they really do?

Who knows really, does anyone really know how the human eyes and brain work in their entirety? I do not believe anyone does, otherwise we could construct these things.

We can only run tests and draw conclusions from those tests.

Blue blocking glasses is one of those things that is incredibly hard to test. It would require taking measurements over the course of 20+ years. Attempting to isolate all other variables. Very difficult.

So, everything I am going to talk about is philosophy. There are some study's but they can only provide a small amount of data.

The Data

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5854379/ This is a study showing blue light effects retina cells in mice.

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4734149/ This one shows our Circadian cycle is affected by blue light.

There was another study I read months ago where they took mice, one cage had incandescent light, the other had LEDs. The mice with the LEDs had increased loss of retina cells.

The Philosophy

There is something going on. That is clear, LEDs, or blue light, or both. Our eyes can be affected by these things. So, can our sleep (circadian) patterns.

So, what can we do? I, like 70% of you reading this, spend a LOT of time staring at the computer screen. 99% of the screens we use today are backlit with LEDs.

That is not optional, we need to. So, what are we going to do about it? Anything at all? I mean we all do it, should we just ignore it, put it in the category of "don't eat sugar" Yeah, we know it is bad but what are you going to do?

Solutions

There is more than 1 way to combat this. These are the ones I see:

Let's talk about all of them. (Spoiler, I am a fan of the glasses route)

Blue Blocking Glasses

Pros:

Cons:

To me "they just work" yes, they are glasses, if you already wear readers then it might not be possible to find prescription blue blockers. I actually tried this for my father, they have clip on ones, oh boy do you look like a nerd with those on. They do work but he stopped wearing them because they were just too annoying.

I wear them every day, not 100% of the time. Some days I hardly wear them at all. It just depends, that is the nice thing about them. You can take them on and off very quickly.

The one's I have are USA made, and only $15. They are from UVEX. An authority on glasses, this specific model is just fantastic, for someone who never wears glasses I was able to just put them on and never feel soreness or discomfort of any kind.

Tape on screen filters:

Now I never even tried one of these. My mother had told me in the 90's they were all the rage. The only time I see tape on filters anymore are privacy filters. I would have a major problem with the use of them, so never even tried

Pros:

Cons:

Even though there are great pros to the screen filter, the cons are just too much.

Not being able to remove it on a moment's notice is a total deal breaker, I need to see colors, I am not going to rip a big piece of plastic off my screen 50 times a day.

Also, I know trying to get the thing to look perfect, cut to the perfect size, taped perfect, it is just not going to happen. It will bug me too much. Getting lint behind it that you cannot wipe off. No go for me.

Software Screen Filters

This is the easiest solution. Mac, windows, and Linux have free software available that will make the screen yellow to block out the blue light.

I just don't think they work. Displays are just filters in front of LEDs, if there is light coming through it all it is LED light, they can attempt to filter out all the blue but it just seems like it is not going to fully work.

Screens are not designed to do this.

Pros

Cons

If I was in some situation where glasses were just not an option then I would use this method. I actually use it on my phone every day. Yes, it is buggy and breaks things, and I am always wondering if it actually does anything.

Back to philosophy, it has to be better than nothing.

Eye care screens

Now this one is kind of new. I guess more and more people are thinking about their eyes and screens.

Pros:

Cons:

This is totally above my head. Monitors like the one I just bought have this technology. You would need to be a light engineer to understand if and how it works.

They just call it "eye care" it is on a lot of the newer Dell monitors.

I don't have much to say, it could be the end all superior solution to the problem. Or another marketing farse. I really have no idea.

Conclusion:

Like many things to do with the infinitely complicated machine called the human body, no one really knows. Do the solutions work? Is this even a problem?

All I know is the solution is not very expensive or difficult. So, if there is a chance it does something you are better safe than sorry.

I wear the above glasses every single day, on average 65% of the day. Sometimes when working with colors I need to just leave them off. Sometimes you just want to see the beautiful colors that are on the screen.

It just comforts me to know I am doing something. If I am buried in the terminal for hours then it just makes sense. I just need to see the text; it is not a problem.

It almost becomes like a ritual; it sets your mind into work mode. The brain does build associations, mine knows when the glasses are on it is time to work for an extended period of time.

Questions, Comments? Leave them below!

WordPress and MySql, One in the same

BACKUP BACKUP BACKUP!!! Before attempting this. Full server snapshot. Not just WordPress backup!

Hello, today I had a task and was unable to find a complete guide for it. So here you go.

This is a simple task. You have two sites on the same database server using different databases. You want to merge them into the same database.

I needed to do this so I could share user tables between sites. Without using Multisite.

Steps:


Grant site1 user privilege's on site2's database

We need to let the MySql user of site1 be able to make changes on site2's database.

Database username will be in wp-config.php
mysql> GRANT ALL PRIVILEGES ON site2's-db.* TO 'site1s-username'@'localhost';
mysql> FLUSH PRIVILEGES;

Change site1's database prefix

Now we change the prefix of site1 so that there is no conflicts when we move over it's tables to site2's database.

Select all tables in site1's database and click "replace table prefix"

Now we must correct all the inner-table prefixe's.

Come over to here in php-my-admin (in the database of the site you just appended.)

Run the following queries:

SELECT * FROM `NEW-PREFIX-GOES-HERE_options` WHERE `option_name` LIKE '%wp_%'

That will give you all the table entrys that still have the old prefix. You need to manually change every entry displayed to the new prefix

Do the same with the results of this query:

SELECT * FROM `NEW-PREFIX-GOES-HERE_usermeta` WHERE `meta_key` LIKE `%wp_%`

Merge databases

Now time to merge the two sites databases together into one.

Make a folder somewhere where you can save the .sql export to. You will only need it for a second.

I made a directory called "dbspot" in /opt (ignore the home folder ls, I accidently did that)

Now time to export site1's database to it

You need to be logged in as root for this.

sudo -i

mysqldump -u root -p SITE1'S-DATABASE-NAME > /YOUR-CREATED-DIRECTORY/ANY-NAME.sql
password: MYSQL-ROOT-PASSWORD

Now a copy of site1's database is in whatever directory you put it in.

Now time to import it to site2's database (will still need to be logged in as root.)

mysql -u root -p SITE2'S-DATABASE < /YOUR-CREATED-DIRECTORY/SITE1-BACKUP-NAME.sql
password: MYSQL-ROOT-PASSWORD

Now site1's database is merged with site2's

Change site1's wp-config.php to reflect changes

Now you have to change site1's wp-config.php to use site2's database.

Change this value in site1's wp-config to the name of site2's database
Change prefix to one you changed it to.

That's all folk's (of course restart the server)

You have merged two WordPress sites into a single database.

Any questions feel free to comment below.

We Would Love to Help

Web design. IT computer network systems. Security Cameras. Graphic design. We do it all. Reach out to see if we are a good fit for you.
menuchevron-down linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram