Mysql Workbench error #1064

This is an incompatibility (assuming the database model is correct) between MySQL workbench and MySQL Server. For example, this could occur occasionally by installing XAMPP 3.2.2 and latest MySQL Workbench 8.

For example: XAMPP 3.2.2 installs Maria DB 10.1.37 which is compatible with MySQL 5.7 but MySql workbench 8 is compatible with MySQL 8.0.

The solution would be to either upgrade MySQL to 8.0 so that it is compatible with MySQL workbench or downgrade the MySQL workbench model:

  • Open MySQL workbench and desired model
  • Go to Edit, Preferences, then Modeling section, MySQL
  • set MySQL version to 5.7.
  • forward engineer

Visual Studio code settings

Install the following plugins:

  1. vscode-icons
  2. Netbeans keymaps
  3. Vue.js extension pack

Disable the following settings (search in settings):

  1. Explorer autoreveal

Disable line annotations:

File ->Settings->Extensions->GitLens: disable Current line blame annotations

 

Enable zoom via mouse:

  1. Ctrl+Shift+P (or View->Command Palette…)
  2. Type Open User Settings
  3. Edit settings.json
  4. Add “editor.mouseWheelZoom”: true
  5. Save it.

Vue links

Basics

  1. Official Style guide (v2)
  2. Deverus Style guide
  3. https://michaelnthiessen.com/26-time-saving-tips/

Authentication

  1. Authentication best practices
  2. User authentication with Vue and Vuex (jason watmore)
  3. https://scotch.io/tutorials/handling-authentication-in-vue-using-vuex (scotch.io)
  4. Cookie authentication for APIs

Rest API

  1. Implement with Vuex
  2. API calls with Vuex

Tools

  1. Basic understanding of elixir, gulp and webpac
  2. https://ponyfoo.com/articles/json-web-tokens-vs-session-cookies

Forms

  1. Submit with enter
  2. Use autofocus

Validation

  1. masks

Routing

  1. https://stackoverflow.com/questions/30414860/how-can-i-define-a-route-differently-if-parameter-is-not-integer

Templates

  1. Best Vue JS templates 2018
  2. https://stackoverflow.com/questions/50891858/vue-how-to-pass-down-slots-inside-wrapper-component

Deployment

  1. https://appdividend.com/2018/07/13/vue-history-mode-routing-tutorial/

Audio staggering in Windows 10

Update:

There are now two better solutions:

1. Disable dynamic tick

  1. Open Command prompt (Admin) to bring up elevated command prompt.
  2. Type BCDEDIT /SET DISABLEDYNAMICTICK YES command and press Enter to fix the high DPC latency
  3. restart the computer

2. Install and use TCP optimizer:

  1. Download TCP optimizer
  2. Set settings to optimal
  3. restart the computer

If the above does not work, you can try the older solutions mentioned below.

Continue reading Audio staggering in Windows 10

Personal portal to the Internet