Howard Lee Cloud

軟體工程 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

軟體工程 The quick way to validate you ORM query to SQL

By Howard Lee 13 June 2018

Refer from link: http://laragems.com/post/a-quick-way-to-display-a-sql-query-in-tinker Please enter tinker command: php artisan tinker Type below code: DB::listen(function ($query) { dump($query->sql); dump($query->bindings); dump($query->time); }); And from above line on, every ORM manipulation you type will show what transformed SQL is.

軟體工程 Postgres WAL 概述

By Howard Lee 10 May 2018

PostgreSQL version 10 WAL 設定概述參數： checkpoint_timeout default is 5 minute max_wal_size default is 1GB archive_timeout full_page_writes checkpoint_warning checkpoint_completion_target default is 0.5 and only be fraction of checkpoint_timeout pg_test_fsync can measure average speed in microsecond of single WAL flush operation. Half of its value is effective for reporting average time setting that it flush single 8KB write operation to commit_delay. pg_test_fsync doesn’t care whether fsync

軟體工程 Deploy problems when upgrading to rails 5.2.0 from 4.2.5

By Howard Lee 28 April 2018

Capistrano 部署 production 環境從 Rails 4.2.5.1 升級到 Rails 5.2.0 的環境時遭遇了兩個問題 Cannot find gem bundler >= 0.a Solution for your production environment: reinstall rvm and bundler gem rvm implode rvm get head rvm reload rvm reset rvm use 2.4.1 rvm gemset create rails5.2.0 rvm use [email protected] --default gem install bundler which bundle modify config/deploy.rb content and

軟體工程採用新技術的考量方式

By Howard Lee 12 April 2018

團隊成員若建議使用新技術，我建議團隊主管一定要請這個團隊成員，除了自己以外，還要訓練好最少兩個人。若其他產品團隊會使用到新技術開發的功能，建

軟體工程 PHP Laravel 5.5 和 Vuejs 2.4 使用 Google invisible recaptcha

By Howard Lee 25 March 2018

Laravel 5.5 請用 composer 安裝 albertcht/invisible-recaptcha，安裝指令是 composer require albertcht/invisible-recaptcha ，設定 invisible recaptcha 的變數值在 .env 檔案，請參考這個網頁 https://github.com/albertcht/invisible-recaptcha Laravel controller 端

About

Category

Tag

Social