Category: Solutions

Categories
Android Apps Device Open Source Solutions

Swift Key – Turn Off Keyboard Touch Vibration

SwiftKey

Swift Key is one of the best keyboards for Android and IOs. By default, its configured to enable vibration on key press (usually it takes the system defaults). If you are someone who dislikes this feature, here is a simple way to turn off keyboard touch vibration in it:

Steps to Disable Keyboard Touch Vibration in Swift Key:

  • Go to Home -> Settings -> Language & input

    Android Settings Page
    Android Settings Page
  • Tap on “Virtual Keyboard”
    Android Language & input
  • Locate “SwiftKey Keyboard” in the list and tap it
    Virtual Keyboard Menu
  • This will open the SwiftKey Settings… Tap on “Typing”
    Swiftkey Settings
  • Tap on “Sound & Vibration”
    Swiftkey Sound and Vibration Menu
  • Turn off “Keypress Vibration” & “Use the Android default vibration”
    Disable Vibration in SwiftKey
Categories
Laptop OsX Solutions

Open Apps From Unidentified Developers in Mac OS Sierra

Here is How to open applications that can’t be opened as they are from an ‘unidentified developer’ in Mac OS Sierra

How to Open Applications From Unidentified Developers in Mac OS Sierra

Opening a Specific App:

If you would like to allow just one specific application to run, use the following steps:

  1. Hold down the Control key and click the application icon.
  2. A contextual menu should appear – here Choose ‘Open’.
  3. A popup will appear asking you to confirm this action – Click the Open button.

Once you open the App is opened its stored as an exception in the settings and you can open it in future directly by double clicking it.

Allowing all Apps to Open(Works with some versions of Sierra):

If you would like to allow all applications from unidentified developers to run, use the following steps:

  1. Click on the “Apple” menu on the top left of your screen
  2. Select “System Preferences” option from the menu
  3. Choose ‘Security & Privacy’ from the System Preferences menu.
  4. Select ‘General’ from the tabs at the top of the Security & Privacy page.
  5. Click the ‘Lock icon’ at the bottom left of the window.
  6. Enter your administrative username and password and click Unlock
  7. Select ‘Anywhere’ from list of places to allow downloaded applications from. If this option does not show up in the window then you will have use the first method with each app.
  8. A popup window will appear asking you to confirm your selection. Click the Allow From Anywhere button.
Categories
Linux MySql Open Source Solutions

How to Rename Column in Mysql

rename column mysql

To Rename a Column in Mysql we need to use the ALTER query with CHANGE COLUMN statement. The standard version of this query is:

ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name
CHANGE [COLUMN] old_col_name new_col_name column_definition
[FIRST|AFTER col_name]

For Example:

ALTER TABLE City CHANGE CityId cityId varchar(25) NOT NULL;

Note: You will need to mention every constraint of the original column as defaults are assumed otherwise.

Categories
JavaScript Open Source Solutions Web

JavaScript Date Format YYYY-MM-DD

Here is a simple function that takes the input of JS Date and returns a string of format YYYY-MM-DD:

var getDateFromDateTime = function(date) {
date = new Date(date); //Using this we can convert any date format to JS Date
var mm = date.getMonth() + 1; // getMonth() is zero-based
var dd = date.getDate();
if(mm<10){ mm="0"+mm; } if(dd<10){ dd="0"+dd; } return [date.getFullYear(), mm, dd].join('-'); // padding };

Categories
JavaScript Open Source Solutions Web

Convert JavaScript Date format YYYYMMDD

JQuery Check If Element Exists

Here is a simple function that takes the input of JS Date and returns a string of format YYYYMMDD:

var getDateFromDateTime = function(date) {
date = new Date(date); //Using this we can convert any date format to JS Date
var mm = date.getMonth() + 1; // getMonth() is zero-based
var dd = date.getDate();
if(mm<10){ mm="0"+mm; } if(dd<10){ dd="0"+dd; } return [date.getFullYear(), mm, dd].join(''); // padding };