Declining Eyesight Can Be Improved By Looking At Red Light, Pilot Study Says

Declining Eyesight Can Be Improved By Looking At Red Light, Pilot Study Says

swell shares the findings from a small pilot study that suggests a few minutes of looking into a deep red light could have a dramatic effect on preventing eyesight decline as we age. CNN reports: Researchers recruited 12 men and 12 women, whose ages ranged from 28 to 72. Each participant was given a small handheld flashlight that emitted a red light with a wavelength of 670 nanometers. That wavelength is toward the long end of the visible spectrum, and just short of an infrared wavelength, which tends to be invisible to the human eye.
They spent three minutes each day looking into the light over a period of two weeks.
The lights work on both cones and rods in the eye. Cones are photo receptor cells that detect color and work best in well-lit situations. Rods, which are much more plentiful, are retina cells that specialize in helping us see in dim light, according to the American Academy of Ophthalmology.
Researchers measured the cone function in subjects’ eyes by having them identify colored letters with low contrast. And they measured their eyes’ rod sensitivity by asking them to detect light signals in the dark. There was a 14% improvement in the ability to see colors, or cone color contrast sensitivity, for the entire two dozen participants. Improvement, however, was most significant in study participants over age 40. For those ages, cone color contrast sensitivity rose by 20% over the course of the study. That age bracket also saw significant increases in rod threshold, which corresponds to the ability to see in low light. Study participants under 40 also experienced some improvement, but didn’t see the same jump as older subjects. Younger eyes haven’t declined as much as older eyes.

Read more of this story at Slashdot.


via Slashdot

June 30, 2020 at 08:42PM

The Best Password Managers

The Best Password Managers

The Best Password Managers

Everyone should be using a password manager. It’s the most important thing you can do—alongside two-factor authentication—to keep your online data safe. We’ve evaluated dozens of paid and free password managers and tested four, and we think 1Password offers the best combination of features, compatibility, security, and ease of use. You don’t have to pay for a good password manager, but if you can, 1Password is worth the $36 per year.


via Wirecutter: Reviews for the Real World

June 25, 2020 at 01:35PM

Yorvi Arias: Setup ora2pg for Oracle to Postgres Migration

Yorvi Arias: Setup ora2pg for Oracle to Postgres Migration

An important part of performing a migration from Oracle to PostgreSQL is selecting the right tool for helping with the conversion between systems. When people ask me how they can get the migration process started, I like to recommend a powerful open source utility called "ora2pg".

As the name suggests, ora2pg is a tool that migrates Oracle (or MySQL) databases to PostgreSQL by generating compatible SQL files  As the documentation states, ora2pg “connects your Oracle database, scans it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.” 


via Planet PostgreSQL

June 24, 2020 at 02:47PM

Writing mysqlsh Scripts

Writing mysqlsh Scripts

    The new MySQL Shell or mysqlsh has provisions for loading user plugins in Python or JavaScript that are loaded when the shell starts up. I am just taking my initial steps into this area and wanted to share with you how easy it is to create a plug-in to produce a report.

    The ability to write and run your own scripts for information that you want on a regular basis is very useful. The idea behind this was a discussion with a community member who had issues with a locked account that unknowingly locked and knowing when passwords where changed.  This is a typical bit of work for a DBA that would be better automated and saved as a script for future uses.

The Query

    The query collects several vital facets of information for dealing with passwords and accounts.
SELECT concat(User, ‘@’,Host) as User, 
       password_expired as Expired, 
       password_last_changed as Changed, 
       password_lifetime as Lifetime, 
       account_locked as Locked, 
       User_attributes FROM mysql.user

    Nothing too exotic as far as a query goes.

The Code

    Most of the Python code deals with registering the registering the passwordData function that houses the query as report named userList. The query itself is in purple below and the registration ‘boilerplate is in green.  The shell.register_report is what ties the new function to the extension called userList.

# Define a passwordData function that generates a MySQL Shell report
def passwordData(session):
  query = "SELECT concat(User, ‘@’,Host) as User, password_expired as Expired, password_last_changed as Changed, password_lifetime as Lifetime, account_locked as Locked, User_attributes FROM mysql.user"
  result = session.sql(query).execute();
  report = []
  if (result.has_data()):
    report = [result.get_column_names()]
    for row in result.fetch_all():
  return {"report": report}
# Register the userList function as a MySQL Shell report
shell.register_report("userList", "list", passwordData, {"brief":"Lists the user password status on the target server."})
# Check if global object ‘ext’ has already been registered
if ‘ext’ in globals():
    global_obj = ext
    # Otherwise register new global object named ‘ext’
    global_obj = shell.create_extension_object()
    shell.register_global("ext", global_obj,
        {"brief":"MySQL Shell extension plugins."})
# Add the ‘userList’ extension object as a member of the ‘ext’ global object
    plugin_obj = global_obj.process
except IndexError:

The Report

    The output is pretty much as expected and could use some careful tailoring.  It would be nice to add information on how many days until a password expires and parsing the User_attributes field for key/values in a pretty fashion.  But in a few minutes work I had a quick little utility that will save me time in the future.
 JS > \show userList
| User                       | Expired | Changed             | Lifetime | Locked | User_attributes                                                                  |
| demo@localhost             | N       | 2020-04-09 10:42:06 | NULL     | N      | NULL                                                                             |
| foobar@localhost           | N       | 2020-04-06 09:38:50 | NULL     | N      | {"Password_locking": {"failed_login_attempts": 3, "password_lock_time_days": 2}} |
| mysql.infoschema@localhost | N       | 2020-01-13 11:57:33 | NULL     | Y      | NULL                                                                             |
| mysql.session@localhost    | N       | 2020-01-13 11:57:33 | NULL     | Y      | NULL                                                                             |
| mysql.sys@localhost        | N       | 2020-06-12 10:20:33 | NULL     | Y      | NULL                                                                             |
| root@localhost             | N       | 2020-01-13 11:57:37 | NULL     | N      | NULL                                                                             |
You Try
    I recommended grabbing LeFred’s Github repo and reading through his code.  You can create your own directory under your ~/.mysqlsh/plugins/ext/ directory and using the above code saved as as an exercise.  
    I would love to see what similar scripts or reports others are creating so please share!
All opinions expressed in this blog are those of Dave Stokes who is actually amazed to find anyone else agreeing with him


via Planet MySQL

June 24, 2020 at 03:47PM

The Best iPhone SE (2nd Gen) Cases, iPhone 7 Cases, and iPhone 8 Cases

The Best iPhone SE (2nd Gen) Cases, iPhone 7 Cases, and iPhone 8 Cases

The Best iPhone SE (2nd Gen) Cases, iPhone 7 Cases, and iPhone 8 Cases

Even if you’re not splurging on the most cutting-edge iPhone model, we still think your phone should be in a case. Whether you own a brand-new iPhone SE (2nd generation) or an older iPhone 7 or 8, a case can extend your phone’s life by preventing scratches, dents, and dings, and some cases can even prevent a bent phone or a broken screen. Adding a case also personalizes your iPhone, and some models add useful features such as card holders, waterproof protection, or even extra power.


via Wirecutter: Reviews for the Real World

June 24, 2020 at 05:30PM

AWS ‘Honeycode’ makes Amazon a player in booming no-code software movement

AWS ‘Honeycode’ makes Amazon a player in booming no-code software movement

Amazon launched its “AWS Honeycode” app development tool in beta on Wednesday. (AWS Image)

A new Amazon service called Honeycode promises to let non-developers quickly create interactive web and mobile apps without knowing how to develop software.

Announced in beta on Wednesday afternoon, Honeycode inserts Amazon into the fast-growing market for low-code and no-code software development, in which analysts and other advanced users inside companies can create sophisticated apps that would otherwise require them to engage their internal IT and application development teams.

“We really wanted to push that power of AWS out to all those people in the line of business, who want to create these custom apps to get things done, but don’t have the skill set to do it today,” said Larry Augustin, an Amazon Web Services vice president.

The service uses an underlying AWS database, allowing data to be linked, filtered and sorted, but with a point-and-click interface and a data entry structure reminiscent of a spreadsheet. The service is free for applications with up to 20 users, with charges kicking in for larger applications.

Amazon expects the primary usage to be used for apps and websites inside companies, but Honeycode could also be used for public-facing apps and websites.

It’s part of a broader effort by AWS to expand its offerings beyond the core infrastructure and platform services that initially attracted software developers to its cloud technologies. Amazon is looking to defend its lead as the top public cloud platform against rivals such as Microsoft Azure and Google Cloud.

Microsoft is also involved in low-code software development through its Power Platform.

Gartner estimated last year that low-code and no-code approaches will represent more than 65% of application development inside companies by 2024. Earlier projections by Forrester predicted that the market would grow 50% a year to more than $21 billion by 2024. Forrester last fall named FileMaker, AppSheet, Caspio and Quick Base as leaders in the field.

Amazon itself used early versions of Honeycode in the process of planning, launching and naming the product, and for other functions such as creating an org chart for the team, said Meera Vaidyanathan, director of product management for AWS Honeycode.

“In terms of the specific verticals or industries, I don’t think there are any limitations to who can use it,” she said.


via GeekWire

June 24, 2020 at 06:53PM

9 Tools/Tips For Generating Epic Content

9 Tools/Tips For Generating Epic Content

When it comes to boosting organic reach, nothing works quite as well as a solid content marketing strategy. But no matter how much you churn out, the truth is, quality always beats quantity.

To stand out from your competitors (who are probably well-aware of the importance of content as well), you need to learn how to create something amazing.

Generating epic content isn’t that simple. Especially if you’re taking a DIY approach to your blog, YouTube channel, social media accounts, or podcast. But, it’s not impossible to produce either. All you need are the right tools and tips to make the most of your resources. 

If you’re ready to step up your game, read on to learn how you can create posts that raise the bar.

1. Come up with a great topic

Before you get down to writing or recording, you need to have a clear understanding of the exact message you want to send out to your audience. After all, nobody likes reading a page full of rambling that’s got no beginning, middle, ending, or value. So make sure you’ve got your topic figured out.

For a good place to start, you can check out HubSpot’s Blog Ideas Generator, which is a helpful tool you can turn to whenever you lack inspiration.

2. Make your headline attention-grabbing

Whether you’re the type of person who starts from the headline or tends to do their writing first and circle back to the beginning, know that the title you choose for your post is going to determine whether you get the results you want. So ensure it’s attention-grabbing, optimized for SEO, and that it ties in well with your central topic.

According to research, one of the most successful marketing strategies is to appeal to your reader’s emotions. And your headlines can be a huge part of that strategy. So, before you click publish, you can run it through the Headline Analyzer, which will check its Emotional Marketing Value and let you know whether you’ve got it right or if you still need to do a bit of polishing.

3. Check your readability score

When writing for the web, aim to make your text understandable to anyone over the age of 13. This means skipping complicated words, keeping sentences short, and avoiding the passive voice. You should also try to shorten your paragraphs, break your text up with headlines, and use bullet points where possible.

The Hemingway Editor app is one of the best tools out there. It will let you check your readability score and give you tips on improvement. All you need to do is enter your text, and you’ll get a comprehensive overview of everything that’s working well and anything that still needs refinement. Plus, it’s free.

4. Make the most of user-generated content

While the motivation behind your content marketing is building your authority, don’t forget that letting others do the talking is one of the best strategies out there.

Customer feedback and reviews are crucial forms of social proof. So give them the space they deserve on your website and social media profiles. And don’t stop there. You can share a host of user-generated content over a variety of platforms. Unboxing videos on YouTube, influencer posts on Instagram, or hashtags that let customers tag you in their posts are all a great way to encourage engagement and build trust.

5. Keep your brain sharp

This is a piece of advice that most entrepreneurs fail to follow, yet it really could be a gamechanger.

For you to be able to generate epic content, you need to be at the top of your game. And that takes equal amounts of hard work and self-care. 

Lack of exercise, poor nutrition, and insufficient sleep can all negatively influence your cognitive abilities. And that includes your creativity, as well as productivity

That being said, make sure to work out at least a few times per week, eat a healthy and balanced diet, and consistently get a good night’s rest on a comfortable bed. Furthermore, try to keep yourself from working in bed (no matter how great that idea seems at the time), and, of course, look for efficient ways to manage your stress levels.

6. Collect inspiration

One of the best ways to see what works is to look at your competition.

When it comes to collecting inspiration for ad copy, Facebook Ad Library is a great tool. You can search for active and inactive advertisements based on competitors’ names and sort the results according to impressions.

Although you can’t see the targeting options used, you can use this free resource to determine what type of content you can include in your social media advertising. Use it to: 

  • Check whether your target audience reacts better to video or images. 
  • See how your copy compares. 
  • Identify the unique selling points that just might give you the upper edge.

And don’t stop there. Websites, social media feeds, and blog sections are all excellent sources of inspiration – so keep an eye on your competitors, and do your best to stay one step ahead. 

7. Take a deep dive into SEO

To create awesome content, you have to know what exactly people are searching for. And in this regard, you’ll need a powerful research tool such as Ahrefs.

Not only can it give you a good idea where to focus your efforts, but even more, Ahrefs makes it super-easy to figure out what competing domains are doing right. You can put together a comprehensive list of your competitors (even the ones you’re not aware of), and do an in-depth analysis of their best-performing posts and keywords.

From there, you can see whether there are any opportunities you’re missing out on, and get to work creating new content that has a high chance of ranking well on SERPs.

8. Don’t forget the visuals

You’re probably aware of the fact that the human brain processes images faster than words. And the great thing is, you can use this to make your content perform much better.

Simply adding images to your web pages – or even better, creating infographics – can give you a chance to both get your message across and widen your reach. 

And the best place to look for inspiration? Pinterest. Just type your targeted keyword into the search bar, and you’ll find thousands of great content ideas you can expand upon.

9. Create beautiful designs

Lastly, know that you don’t have to spend a fortune to get great visuals for your website, blog, or social feeds. Using something as simple as Canva, you can create a wide variety of designs, including infographics, posters, flyers, t-shirts, and even a logo for your business.

Plus, the platform offers an entire learning section, which means that you can keep on getting better.


When it comes to epic content, you’ll find that research is key. Covering all your bases from start to finish will ensure that your effort bears fruit, instead of getting lost in a sea of similar posts.

Of course, don’t forget that content needs to be original to be truly successful. So always put your spin on the subject and make it into something that reflects your brand’s core values. This way, it will find its way to the people who will appreciate it.

Business vector created by stories –

via Noupe

June 24, 2020 at 10:50AM