common

Common Terminal Blocks with Visible Indicators

Our Value Design Products Increase the Value of Your Control Panels. Contributing to downsize control panels and save work. It can proper wiring without skillful operators, because of indicators make wiring completion simply visible.(XW6T)




common

Glossary of common terms used during the mortgage process

A layman's glossary of 34 terms commonly used during the process of arranging a mortgage in the UK.




common

Natural Remedies For Common Ailments

Some of the best home remedies for common ailments can be found right in your kitchen!




common

Five Most Common Bathroom Types

By definition, all bathrooms contain at least a sink and toilet. Not all contain a shower, and some contain more than the standard toilet, shower and sink. So let’s learn about the top five most common bathroom types and discuss the design challenges each poses.




common

Fixing Common Java Errors

Whether you are just starting your first Java program, or you are a well experienced programmer, your code can not be an error free code and compile successfully from the first time.




common

Exposing the Truth about Tanning and the World's Most Common Cancer

"... there is biologic activity and that there is cell damage when the skin is exposed to UV rays. This repair process can eventually fail to do its job completely or correctly causing the cells to replicate abnormally [...] this breakdown in the normal functioning of cells can lead to malignant cancer." "Despite the fact that we know that there is no such thing as a safe tan, people still associate bronzed skin with beauty and health... "




common

Common Metrics for Valuing Real Estate

Many times, you will see triple net leases, and occasionally double net leases where the tenant is responsible for all the maintenance, tax costs, insurance and utilities. The landlord may have some remaining responsibilities – say the roof and structure, but by and large, the landlord can focus on being a financial owner rather than […]

The post Common Metrics for Valuing Real Estate appeared first on RSS News Feed.




common

8 Common Recruiting Mistakes made by Security Companies

Recruiting in the Security Industry is an extremely difficult task. Security Companies often compound these problems by making these 8 common mistakes:




common

Most Common WordPress Admin Dashboard Errors And How To Fix Them

Being the most popular CMS on the market, WordPress powers more than 75 million websites. Every fourth website on the Internet is running on it. It’s not a surprise as it’s considered to be the easiest one in terms of management. Sometimes, though, it can pose some challenges. If you are the owner of a […]

BlogPress.


Most Common WordPress Admin Dashboard Errors And How To Fix Them was first posted on May 5, 2020 at 6:17 am.
©2019 "BlogPress". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at partners@theblogpress.com



  • WordPress / Web Design

common

Causes of Gum Recession and Common Treatments

Huntington Beach dentist, Dr. Rassouli, offers pinhole surgery treatment and other gum recession treatments to correct gum recession and restore lost tissues.




common

Common Sense – or Lack of it – at the Front Door of Cyber Defense

Spending $170 billion a year globally on cybersecurity without protecting data ports and connectors is like installing in your home every sophisticated electronic security device available – and leaving the front door wide open.




common

Online Resource Offers Swift Access to Doctors and Prescription Refills for Many Common Ailments

MF Enterprises, dba Express Med Refills, allows fast, discreet access to registered doctors across US for Prescription Refills




common

Common distracted driving accidents lead to fatalities

An insurance company has analyzed national motor vehicle accident fatality statistics and discovered the most common types of distracted driving accidents.




common

COMMONTARY Receives Patent For New Alternate Audio Syncing Technology

Patent Covers Ability for Replacing a Portion of Video Broadcast Audio With a Customized, Live-Streaming Alternate Media Stream




common

What the World’s Best CEOs Have in Common

Long-term thinking, short-term savvy, and relentless focus on employees.




common

Common application form issued for PPF, NSC and other small savings schemes

It must be recalled that the finance ministry had revised rules and introduced separate forms for each small savings scheme via a notification in December 2019.




common

I Am Horse Racing Helps Answer The Common Question: What Is Colic?

The team at I am Horse Racing would like to introduce our newest endeavor, a series entitled “Vet's Corner.” This new arm of our video and social media installments will focus on delving into many of the most common ailments, issues, and physical aspects associated with horses, sport horses, and racehorses. We will gather the nation's top minds to speak […]

The post I Am Horse Racing Helps Answer The Common Question: What Is Colic? appeared first on Horse Racing News | Paulick Report.




common

Most Common WordPress Attacks in 2020

It’s a widely known fact that WordPress dominates the Content Management System scene. The amount of websites that run on WordPress far outnumber those of its competition, totalling to about a third of all known sites. That kind of ubiquity, of course, comes with severe exposure to cyber threats. WordPress is, unfortunately, the undisputed winner...




common

From top-down to grassroots: chronicling the search for common ground in conservation in the West.

Sustainable working landscapes are critical to the conservation of biodiversity in the American West and its cultures of rural ranching and forestry.




common

Licensing Showdown: Creative Commons vs Royalty Free vs GPL

Creative Commons, Royalty-free, and General Public License (GPL) are types of licensing for images, graphics, and video. Designers, photographers, software developers, and content creators regularly access and use licensed media for a variety of projects. The question is, which license is best? Licensing gives users the ability to legally use a piece of media in […]

The post Licensing Showdown: Creative Commons vs Royalty Free vs GPL appeared first on Elegant Themes Blog.




common

Commonwealth of the Northern Mariana Islands' forest resources, 2004.

The Forest Inventory and Analysis program collected, analyzed, and summarized field data on 37 field plots on the islands of Rota, Tinian, and Saipan in the Commonwealth of the Northern Mariana Islands (CNMI).




common

Passages: a common struggle for civil rights

A group of singers from Tampa Bay traveled to Israel and the West Bank to perform a play about Martin Luther King Jr. The play, "Passages of Martin Luther King," explores the philosophy of non-violence that guided the American civil rights movement. The U.S. Department of State sponsored the play's performance in Jerusalem and on the West Bank as a cultural exchange with the Palestinian National Theater and Palestinian director Kamel Elbasha. The play was performed with Palestinian and American artists who performed 10 shows over three and a half weeks as a way to share King's message of non-violence and peaceful resistance.




common

Phinney: County needs common sense, smarter government

I have been a Johnson County resident since 1977. I grew up in Clear Lake, a small farming community in North Central Iowa. I came to Iowa City after being recruited by Dan Gable to wrestle for the University of Iowa Hawkeye wrestling team and placed 3rd place in the 1980 NCAA Division I.

I met my wife Teresa and we settled in Iowa City. I have two children, Melissa, 36, and Anthony, 25; and grandchildren Emma, 9, Ellie and Emilia, 4-month-old twin girls, and Jack, who passed two just before his 2nd birthday. I am a cancer survivor and support cancer research and patient support.

I was a maintenance supervisor at the old Cantebury Inn, I owned and operated Advance Property Management for 23 years and drove a school bus for First Student, Inc. While working at First Student I was one of the driving forces in the campaign for the workers to unionize with the Teamsters. I was asked to join the Teamsters as a full-time organizer after the campaign, which I did for 13 years. I found my calling as an organizer because I was able to help others stand up for themselves and really change their lives.

I made the decision to run for Johnson County supervisor because we need to bring some common sense back to Johnson County government, and run a smarter government that works for all. The supervisors need to oversee the county departments better to stop wasting county funds paying settlements to individuals because of illegal action by department employees. Rules are for everyone and if you work outside the rules there will be costs and consequences.

I want to bring new blood to the board as well as new ideas. County supervisor is a public service position of honor and trust. Being a supervisor is about following through on jobs you were elected to do for the people. The supervisors need to finish jobs that they started but never completed. You should never leave a job half done!

I hope the voters agree the Johnson County Board of Supervisors need to answer to the public for their actions and their employees. We can no long just “sweep issues under the rug.”

Dean Phinney is a candidate in the Democratic primary for Johnson County Board of Supervisors.




common

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

common

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

common

3 Common Photography Mistakes To Avoid

Image from Wikimedia With photography and image-based social media flourishing, there’s no better time to get into this amazing hobby. Although many people do just fine with little or no guidance, there are certain common mistakes which a lot of rookies run into. To give you a better start in the world of photography, you need to keep a keen eye out for these slip-ups. Here are three of the most widespread. If you want to pursue photography as a career, then one of the worst things you can do is neglect to learn the jargon. I’ve met more than a few photographers who have a natural talent. Without playing with any settings or even glancing at the subject, they get shots which make even the blandest scenes look incredible. With some of these protégés, I’ve been totally shocked at how little technical knowledge they have. A good photographer is ... Read more

The post 3 Common Photography Mistakes To Avoid appeared first on Digital Photography Tutorials.




common

Common WordPress Errors & How to Fix Them

WordPress is an amazingly stable platform thanks to the dedication and talent of the hundreds of professionals contributing to it, and the strict code standards they follow. Even so, the huge variety of themes, plugins and server environments out there make it difficult to guarantee nothing will ever go wrong. This guide will help you […]


The post Common WordPress Errors & How to Fix Them appeared first on Web Designer Wall.




common

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

common

Common traps in user needs research and how to avoid them

Whether you call it a field visit, a contextual inquiry or a customer discovery interview, the goal of early stage research is the same: to uncover users' needs. Here are 5 mistakes I've seen crop up time and again in this kind of research.




common

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering

common

Jealousy-freeness and other common properties in Fair Division of Mixed Manna. (arXiv:2004.11469v2 [cs.GT] UPDATED)

We consider a fair division setting where indivisible items are allocated to agents. Each agent in the setting has strictly negative, zero or strictly positive utility for each item. We, thus, make a distinction between items that are good for some agents and bad for other agents (i.e. mixed), good for everyone (i.e. goods) or bad for everyone (i.e. bads). For this model, we study axiomatic concepts of allocations such as jealousy-freeness up to one item, envy-freeness up to one item and Pareto-optimality. We obtain many new possibility and impossibility results in regard to combinations of these properties. We also investigate new computational tasks related to such combinations. Thus, we advance the state-of-the-art in fair division of mixed manna.




common

Common field magnetic susceptors

Thermoplastic pellitized materials are melted in gravity flow through coaxially oriented perforated cylindrical metal susceptors. The susceptors are equally energized by the interception of a common magnetic field formed by a high frequency powered inductor coil.




common

System and method to actively drive the common mode voltage of a receiver termination network

An active termination circuit for a differential receiver includes a first receiver element configured to receive a first component of a differential signal, a second receiver element configured to receive a second component of a differential signal, a common mode measurement element configured to receive the differential signal and generate a transmit common mode signal (Vcm) representing an average value of the differential signal, and a receiver (RX) common mode signal node. The termination circuit also comprises an active element configured to receive the transmit common mode signal (Vcm) and provide an output to the receiver common mode signal node, the output configured to drive the value of the signal at the receiver common mode signal node to the value of the transmit common mode signal (Vcm), and a capacitive element coupled to the receiver common mode signal node in parallel with the active element.




common

Single differential-inductor VCO with implicit common-mode resonance

A circuit for a single differential-inductor oscillator with common-mode resonance may include a tank circuit formed by coupling a first inductor with a pair of first capacitors; a cross-coupled transistor pair coupled to the tank circuit; and one or more second capacitors coupled to the tank circuit and the cross-coupled transistors. The single differential-inductor oscillator may be configured such that a common mode (CM) resonance frequency (FCM) associated with the single differential-inductor oscillator is at twice a differential resonance frequency (FD) associated with the single differential-inductor oscillator.




common

System for lifting, moving and transporting a vehicle via multiple slings connected to a common lifting vertex, and method of retrofitting a vehicle to facilitate lifting

A system for lifting a vehicle via multiple slings comprises a vehicle not engineered with structural facility to withstand lifting forces, including a frame which unmodified will deform in response to vertically imposed lifting forces, frame reinforcing elements affixed to the frame at selected locations which are subject to lifting deformation, at least two lifting members at spaced-apart forward frame locations, at least two lifting members at spaced-apart rearward frame locations, and a plurality of elongate slings extending respectively between each lifting member and a common lifting vertex. Each lifting member has an enlarged lower base portion rigidly affixed to the frame and an upper lifting portion. The frame reinforcing elements resist deformation of the frame in response to vertically imposed lifting forces. The enlarged base portions of the lifting members apply forces over a correspondingly enlarged area of the frame and the reinforcing elements without deforming the frame.




common

EPGS architecture with multi-channel synchronous generator and common unregulated PMG exciter

A generator system includes a generator having a stationary portion and a rotating portion. The generator includes a permanent magnet based exciter with permanent magnets disposed on the stationary portion. A first channel includes a first main field winding and a first main field power converter disposed on a rotating portion. The first main field power converter selectively delivers voltage from the exciter winding to the first main field winding. A second channel includes a second main field winding and a second main field power converter disposed on the rotating portion. The second main field power converter selectively delivers voltage from the exciter winding to the second main field winding. A generator control unit is connected to the first channel and the second channel. The generator control unit monitors an output voltage at each of the first channel and the second channel and generates the first and second control signals based on the output voltage.




common

Computer-controlled common access cabinet

A control system for a common access cabinet having a plurality of drawers and electrically controlled latches. Each latch corresponds to one drawer and is configured to receive an electrical signal. The electrical signal contains an address assigned to a particular drawer. When a latch receives a signal that defines the address of the drawer to which that latch corresponds, the latch unlocks that corresponding drawer. The latches receive the signals over an asynchronous serial interface bus. A user input device receives user identification data that is processed by a processor device to determine if the user is authorized to access any of the drawers. If the user is authorized, the processor device generates a signal that contains an address that corresponds to a drawer identified in the user identification data. The signal is converted to an asynchronous serial signal which is routed to the asynchronous serial interface bus.




common

Two-stage hydroprocessing apparatus with common fractionation

Two-stage hydroprocessing uses a common dividing wall fractionator. Hydroprocessed effluents from both stages of hydroprocessing are fed to opposite sides of the dividing wall.




common

Common window frame

Disclosed is an operating-fixed-operating window with a common frame. The window frame includes a sill with a sill lock and sill tower upwardly extending from the sill. The window frame also includes a head disposed atop the window frame, at least one jamb and at least one operating window frame. The window also includes at least one fixed window frame with a sill cover disposed atop the sill, the sill cover engaged with the sill lock and the sill tower.




common

Colden Common Primary School - Rock Challenge

Colden Common Primary School prepares for this year's Rock Challenge.




common

Fewer Long Island Students Opt Out Of Common Core Tests

Fewer Long Island students chose to opt out of New York’s standardized testing last spring, compared to two years ago.




common

Commonwealth Games 2022 – Something they forgot to mention

Two Sandwell community swimming pools to close to help fund Commonwealth Games Aquatics Centre, reports Steve Beauchampe.




common

As he does for his Ballard shop, Curtis Steiner curates the uncommon for his own garden


Every inch of this backyard oasis in Phinney Ridge is covered in captivating plants, moss or ground cover.




common

Try this gift list: Commonly used products should have made Seattle famous, but didn’t


IT BEGAN HUMBLY, as a small seed, nearly three decades ago, in the mind of a local wood and metal patternmaker. The germ of Jeff Carnevali’s idea — a round, elastomeric rubber ball, surrounded by a spring-loaded, double-armed metal clamp to form a grippy, orbital socket capable of mounting countless devices to solid surfaces — […]



  • Pacific NW Magazine

common

What do zombies, puppies and hills have in common? They can all be part of your coronavirus-era fitness routine


So what if your gym is closed? There are lots of different ways to keep your fitness level up. Just look around your neighborhood and incorporate some of these fun little "games" into your workout routine.




common

Need workout ideas? Use these common household items or find workout routines on Instagram from many Seattle-area gyms


Don't have any dumbbells? Tape some rolls of quarters together. Sick of pushups and situps? Many Seattle-area gyms have been posting workouts on Instagram, Facebook and YouTube, so follow along and keep your fitness going.




common

Lockdown order: Where’s the ‘practicality and common sense’?


Gov. Jay Inslee’s continued lockdown is not giving us transparency on metrics for reopening the state. Even with the so-called “phased approach,” there’s nothing that the public can look for to know whether the next phase is in sight. The governor keeps talking about “data.” The Seattle Times publishes graphs of the daily number of […]




common

Lockdown order: Where’s the ‘practicality and common sense’?


Gov. Jay Inslee’s continued lockdown is not giving us transparency on metrics for reopening the state. Even with the so-called “phased approach,” there’s nothing that the public can look for to know whether the next phase is in sight. The governor keeps talking about “data.” The Seattle Times publishes graphs of the daily number of […]




common

'Connecting with people': The quest for common ground on climate change

Atmospheric scientist Katharine Hayhoe and sustainable energy economist Mark Jaccard join host Chris Hall to talk about how to talk about climate change. Plus, we speak with Donald Savoie, scholar of Canadian public administration, about his magnum opus Democracy in Canada: The Disintegration of Our Institutions, and discuss tackling social isolation with Baroness Diana Barran, the U.K.’s "minister of loneliness".



  • Radio/The House

common

For me a common cold can mean a hospital stay: Living with Cystic Fibrosis during the COVID19 pandemic

Emmah Money lives with the lung disease Cystic Fibrosis so she has to be especially careful to avoid coronavirus