Howard Lee Cloud

By Howard Lee 02 September 2018

JavaScript 初學者必讀文章，用來熟悉 JS 觀念：深入了解物件模型 https://developer.mozilla.org/zh-TW/docs/Web/JavaScript/Guide/Details_of_the_Object_Model 繼承與原型鍊 https://developer.mozilla.org/zh-TW/docs/Web/JavaScript/Inheritance_and_the_prototype_chain 箭頭函式 https://developer.mozilla.org/zh-TW/docs/Web/JavaScript/Reference/Functions/Arrow_functions __proto__, prototype 的差異 https://medium.com/@peterchang_82818/javascripter-%E5%BF%85%E9%A0%88%E7%9F%A5%E9%81%93%E7%9A%84%E7%B9%BC%E6%89%BF%E5%9B%A0%E5%AD%90-prototype-prototype-proto-object-class-inheritace-nodejs-%E7%89%A9%E4%BB%B6-%E7%B9%BC%E6%89%BF-54102240a8b4 查 js 和 css 在各瀏覽器的可用情況 https://caniuse.com/ bind() 用法，常見和 this 關鍵字

軟體工程 config of Capistrano deploy rails 5.2.0

By Howard Lee 05 August 2018

In Gemfile: # Use Capistrano for deployment group :development do gem 'capistrano' gem 'capistrano-passenger' gem 'capistrano-rails' gem 'capistrano-bundler' gem 'capistrano-rvm' gem 'highline' end In deploy.rb # Set rvm type #set :rvm\_type, :user set :rvm\_custom\_path, '/usr/local/rvm' # Remote server using rvm set :rvm\_ruby\_version, '[email protected]' In config/environment/production.rb config.require_master_key = true

軟體工程 Problems of deploying rails 5.2.0 to production

By Howard Lee 05 August 2018

When I deploying a new rails 5.2.0 app to production machine, which has been the other rails 5.2.0 app there, I encounter a serious problem: ActiveSupport::MessageEncryptor::InvalidMessage: ActiveSupport::MessageEncryptor::InvalidMessage ArgumentError: invalid base64 /var/www/blogApp/shared/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/core_ext/module/delegation.rb:271:in `method_missing' /var/www/blogApp/shared/bundle/ruby/2.4.0/gems/railties-5.2.0/lib/rails/application.rb:433:in `secret_key_base' Below are a part of debug info when I use capistrano to deploying a rails 5.2.0 app: DEBUG [b79779f0] Command: cd /var/www/blogApp/releases/20180802145508 && ( export RAILS_ENV="production" RAILS_GROUPS="" ; /usr/local/rvm/bin/rvm [email protected] do bundle exec rake assets:precompile )

軟體工程都2018年了, MySQL 資料庫字元編碼請使用 utf8mb4

By Howard Lee 20 July 2018

都 2018 年了, MySQL 資料庫字元編碼請使用 utf8mb4，原因是從來沒有一個時代，能夠從手機如此容易輸入 emoji 表情符號。若是新開的案子就直接使用 utf8mb4 當作字元

軟體工程 Laravel 5.5 ORM 的 ( cond1 and cond2) OR (cond3 and cond4) 寫法

By Howard Lee 30 June 2018

假設兩個 Model : A, B, 一對一關係，例如 A has B, B belongs A，當要撈出 A 中有 B 且符合在 B 的篩選欄位條件。A 是 Post 貼文, B 是 Comment 評論，A 和 B 的更新日期時間欄位都是

軟體工程 Tricky number operation between SQLite and MySQL

By Howard Lee 16 June 2018

Important: The result of 10/110 in SQLite is 0 and different with 0.09090909 when manipulating in MySQL. When testing Laravel Eloquent ORM both at local machine with SQLite and at remote machine with MySQL, you will find some execution results don’t same as expected at local machine. That’s is because SQLite won’t transform integer to real number automatically. Workaround: Add multiply 1.0 to ORM SQL statement and it becomes portable

About

Category

Tag

Social