寫了一陣子的英文部落格文章，這篇用中文書寫調劑一下。Postgres 在 8.3 版之後的版本開始提供全文搜尋功能，資料表上若沒加上 tsvector 的欄位，每次查詢
read moreI use following codes and tools to debug files of CoffeeScript/JavaScript: Safari browser’s developer tool set breakpoints at debugger tab of javascript files responsive design mode of developer tool can help us to see what a web page is rendered. coffeescript code if myVariable? # this statement can check whether this variable has its value(s), null or undefined. If it has value, this statement would return true, otherwise false. alert
read moreFollow below code for inquiring ones in ActiveRecord between two dates: YourModel.find(:date => somenumber.days.ago..Date.today) # or YourModel.find(:created_at => yourNumber.years.ago..Date.today) # or YourModel.find(:updated_at => yourVariable.months.ago..Date.yesterday) Aboved code are modified from a post at stackoverflow.com. Reference: http://stackoverflow.com/questions/2381718/rails-activerecord-date-between
read moreUse below command to start/restart/stop the postgresql easily: brew services start postgresql brew services restart postgresql brew services stop postgresql Reference: How to start postgreSQL server on mac os x? http://stackoverflow.com/a/24251522/2704360
read moreUse CoffeeScript and JQuery to bind click event at website for getting parameters of a form at URL. In someone.js.coffee file. The following example is modified from reference 1,2,3 and 4 to meet my need. get_parameters_from_url = -> aryParams = {} # Initial an empty object rawVars = window.location.search.substring(1).split("&") #window is used to getting global variables of browsers in coffeescript. location.search is the query string at URL including the question
read moreWanna use functions, which are defined in files of coffeescript language, to change one of CSS attributes such as display when an user clicking a button or element at a web page? You can follow below instructions. At side of web page, for example: Write down a button of HTML 5 for triggering event <button type="button" name="btn-veggie-list" class="btn-veggie-list">Veggie list</button> Target HTML. For example, it’s an unordered list for items in
read more
Howard Lee, Frontend-engineer with Typescript, JavaScript, HTML, CSS, Angular 19+, ReactJS, Next.js, GraphQL, Tanstack Query, Material-UI, Cypress, Postgres, Amazon Web Services, Google Cloud Platform Docker and TestCafe. Have a certificate of AWS Solution Architect Associate with verify number: 8FYNL55LCEEQ10W5. You can verify at AWS Certificate site or Credly site Tech lead role Lead 4 colleagues to build products and infrastructure Coordinate schedule of delivering products Senior web frontend developer role Products Team-management, form-filling, form-sharing, file-management, repair-management and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.
Know More