Aliasing with Babel instead of Webpack
If you have been using aliases in Webpack, and want to switch over to Babel instead, you can use the Babel Module Resolver Plugin. Then just configure your aliases, such as: […]
API Programming
Working with NodeJS environment variables (such as for server specific settings)
To set an environment variable that NodeJS can access, in a DOS prompt: set variableName=value To access this value in your NodeJS, you can reference: process.env.variableName Note that while this […]
Proxying with Apache2 (running NodeJS apps through Apache)
Ubuntu 14.04 provided modapache2_mod_proxy_html as an option to pass requests to Apache through to something like NodeJS running on a different port. However, this package does not exist for 16.04! […]
Create a MySQL user
Log in to the console as root: mysql -u root -p To create a new user: GRANT ALL PRIVILEGES ON *.* TO ‘username’@’localhost’ IDENTIFIED BY ‘password’; (restrict permissions as necessary)
Finding table that a constraint is in, based on the constraint name
To find the table that a constraint is in, you can do: SELECT * FROM all_constraints WHERE constraint_name = ‘the_constraint_name’ This is useful for finding child table(s) that have dependent […]
Active Directory / Single Sign On (SSO) – Get a user’s SID for validation
Quick command to get the SID of the currently logged in user for SSO validation: whoami /user This can be an extra layer of security above and beyond the username […]
Changing password
To change a user’s password, including your own: alter user THEUSERNAME identified by “NEWPASSWORD“;
Find all tables with a specific column name
For a list of tables with a specific column name, you can query the DBA_TAB_COLUMNS table: select table_name from dba_tab_columns where column_name=’MY_COLUMN_NAME’ order by table_name asc; This is helpful for […]
Unlocking a locked account
To unlock an account: alter user {USERNAME} account unlock;
Getting the current time stamp
Easy! Just select: CURRENT_TIMESTAMP