Recently, our organization planned to migrate an internal application web API to Nodejs web API. We have everything to work on node app, but we were lacking a console where we can run queries and examine results to implement them in our controller or vice-versa. fig 1. Nodejs consoleWhat we have in Ruby on Rails frameworkrails_app $ rails c irb(main):005:0> User.first User Load (0.7ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT 1 => #<User id: 1, email: "email@example.com"
Following is an handy list of frequently used Linux (Ubuntu flavour) console commands Find Files find . -name '*.cnf' find . -name 'hello.workd' The dot here represents all files and folders in current path Mysql DUMP - Import and Export Export mysqldump -u username -p database_name > file_name_to_save.sql Import mysql -u username -p database_name Install LAMP on Ubuntu sudo apt-get install tasksel sudo tasksel sudo tasksel install lamp-server Install Apache2 on Ubuntu sudo apt-get update sudo apt-get install apache2 The /var/www path is the document root for the apache web apps. SCP - File