cmd模式 arp-a
B8-27-EB是Raspberry Pi的MAC起始位址
透過putty連入(預設帳密 pi/raspberry)
sudo apt-get update 更新
sudo apt-get -y install xrdp 安裝遠端桌面
sudo apt-get update 取得遠端更新伺服器的套件檔案清單
sudo apt-get -y install fpc 安裝FreePascalComplier
sudo apt-get -y install lazarus 安裝Linux上的免費Delphi開發工具 Lazarus

AngularJS 學習筆記(一) – 建置

一、到 https://nodejs.org/en/download/ 下載 node.js 及npm套件

二、安裝完後到命令字元(WIN+R) 輸入 npm -v  以及 node -v 確認版本


npm install -g @angular/cli


ng new happyweb

五、切換到 happyweb目錄下,開啟服務並打開瀏覽器檢視(打開瀏覽器為 –open 或 –o) 埠為4200

cd my-app
ng serve --open



國外網友 Minko Gechev 在Github分享了angular-performance-checklist這份清單


Angular Performance Checklist


This document contains a list of practices which will help us boost the performance of our Angular applications. “Angular Performance Checklist” covers different topics – from server-side pre-rendering and bundling of our applications, to runtime performance and optimization of the change detection performed by the framework.

The document is divided into two main sections:

  • Network performance – lists practices that are going to improve mostly the load time of our application. They include methods for latency and bandwidth reduction.
  • Runtime performance – practices which improve the runtime performance of our application. They include mostly change detection and rendering related optimizations.

Some practices impact both categories so there could be a slight intersection, however, the differences in the use cases and the implications will be explicitly mentioned.

Most subsections list tools, related to the specific practice, that can make us more efficient by automating our development flow.

Note that most practices are valid for both HTTP/1.1 and HTTP/2. Practices which make an exception will be mentioned by specifying to which version of the protocol they could be applied.

Table of Content

Network performance

Some of the tools in this section are still in development and are subject to change. The Angular core team is working on automating the build process for our applications as much as possible so a lot of things will happen transparently.


Bundling is a standard practice aiming to reduce the number of requests that the browser needs to perform in order to deliver the application requested by the user. In essence, the bundler receives as an input a list of entry points and produces one or more bundles. This way, the browser can get the entire application by performing only a few requests, instead of requesting each individual resource separately.

As your application grows bundling everything into a single large bundle would again be counter productive. Explore Code Splitting techniques using Webpack.

Additional http requests will not be a concern with HTTP/2 because of the server push feature.


Tools which allows us to bundle our applications efficiently are:


Minification and dead code elimination

These practices allow us to minimize the bandwidth consumption by reducing the payload of our application.


  • Uglify – performs minification such as mangling variables, removal of comments & whitespace, dead code elimination, etc. Written completely in JavaScript, has plugins for all popular task runners.
  • Google Closure Compiler – performs similar to uglify type of minification. In advanced mode it transforms the AST of our program aggressively in order to be able to perform even more sophisticated optimizations. It has also a JavaScript version which can be found here. GCC also supports most of the ES2015 modules syntax so it can perform tree-shaking.



For the final version of our applications we usually don’t use the entire code which is provided by Angular and/or any third-party library, even the one that we’ve written. Thanks to the static nature of the ES2015 modules, we’re able to get rid of the code which is not referenced in our apps.


// foo.js
export foo = () => 'foo';
export bar = () => 'bar';

// app.js
import { foo } from './foo';

Once we tree-shake and bundle app.js we’ll get:

let foo = () => 'foo';

This means that the unused export bar will not be included into the final bundle.


  • Webpack – provides efficient bundling by performing tree-shaking. Once the application has been bundled, it does not export the unused code so it can be safely considered as dead code and removed by Uglify.
  • Rollup – provides bundling by performing an efficient tree-shaking, taking advantage of the static nature of the ES2015 modules.
  • Google Closure Compiler – performs plenty of optimizations and provides bundling support. Originally written in Java, since recently it has also a JavaScript version which can be found here.

Note: GCC does not support export * yet, which is essential for building Angular applications because of the heavy usage of the “barrel” pattern.


Ahead-of-Time (AoT) Compilation

A challenge for the available in the wild tools (such as GCC, Rollup, etc.) are the HTML-like templates of the Angular components, which cannot be analyzed with their capabilities. This makes their tree-shaking support less efficient because they’re not sure which directives are referenced within the templates. The AoT compiler transpiles the Angular HTML-like templates to JavaScript or TypeScript with ES2015 module imports. This way we are able to efficiently tree-shake during bundling and remove all the unused directives defined by Angular, third-party libraries or by ourselves.


  • @angular/compiler-cli – a drop-in replacement for tsc which statically analyzes our application and emits TypeScript/JavaScript for the component’s templates.



Compression of the responses’ payload is a standard practice for bandwidth usage reduction. By specifying the value of the header Accept-Encoding, the browser hints the server which compression algorithms are available on the client’s machine. On the other hand, the server sets value for the Content-Encoding header of the response in order to tell the browser which algorithm has been chosen for compressing the response.


The tooling here is not Angular-specific and entirely depends on the web/application server that we’re using. Typical compression algorithms are:

  • deflate – a data compression algorithm and associated file format that uses a combination of the LZ77 algorithm and Huffman coding.
  • brotli – a generic-purpose lossless compression algorithm that compresses data using a combination of a modern variant of the LZ77 algorithm, Huffman coding and 2nd order context modeling, with a compression ratio comparable to the best currently available general-purpose compression methods. It is similar in speed with deflate but offers more dense compression.

Note: Brotli is not widely supported yet.


Pre-fetching Resources

Resource pre-fetching is a great way to improve the user experience. We can either pre-fetch assets (images, styles, modules intended to be loaded lazily, etc.) or data. There are different pre-fetching strategies but most of them depend on specifics of the application.

Lazy-Loading of Resources

In case the target application has a huge code base with hundreds of dependencies, the practices listed above may not help us reduce the bundle to a reasonable size (reasonable might be 100K or 2M, it again, completely depends on the business goals).

In such cases a good solution might be to load some of the application’s modules lazily. For instance, lets suppose we’re building an e-commerce system. In this case we might want to load the admin panel independently from the user-facing UI. Once the administrator has to add a new product we’d want to provide the UI required for that. This could be either only the “Add product page” or the entire admin panel, depending on our use case/business requirements.


  • Webpack – allows asynchronous module loading.

Don’t Lazy-Load the Default Route

Lets suppose we have the following routing configuration:

// Bad practice
const routes: Routes = [
  { path: '', redirectTo: '/dashboard', pathMatch: 'full' },
  { path: 'dashboard',  loadChildren: './dashboard.module#DashboardModule' },
  { path: 'heroes', loadChildren: './heroes.module#HeroesModule' }

The first time the user opens the application using the url: https://example.com/ they will be redirected to /dashboard which will trigger the lazy-route with path dashboard. In order Angular to render the bootstrap component of the module, it will has to download the file dashboard.module and all of its dependencies. Later, the file needs to be parsed by the JavaScript VM and evaluated.

Triggering extra HTTP requests and performing unnecessary computations during the initial page load is a bad practice since it slows down the initial page rendering. Consider declaring the default page route as non-lazy.


Caching is another common practice intending to speed-up our application by taking advantage of the heuristic that if one resource was recently been requested, it might be requested again in near future.

For caching data we usually use a custom caching mechanism. For caching static assets we can either use the standard browser caching or Service Workers with the CacheStorage API.

Use Service Workers

We can think of the Service Worker as an HTTP proxy which is located in the browser. All requests sent from the client are first intercepted by the Service Worker which can either handle them or pass them through the network.



Runtime Optimizations

This section includes practices which can be applied in order to provide smoother user experience with 60 frames per second (fps).

Use enableProdMode

In development mode Angular performs some extra checks in order to verify that performing change detection does not result to any additional changes to any of the bindings. This way the frameworks assures that the unidirectional data flow has been followed.

In order to disable these changes for production to not forget to invoke enableProdMode:

import { enableProdMode } from '@angular/core';

if (ENV === 'production') {

Ahead-of-Time Compilation

AoT can be helpful not only for achieving more efficient bundling by performing tree-shaking, but also for improving the runtime performance of our applications. The alternative of AoT is Just-in-Time compilation (JiT) which is performed runtime, therefore we can reduce the amount of computations required for rendering of our application by performing the compilation as part of our build process.


  • @angular/compiler-cli – a drop-in replacement for tsc which statically analyzes our application and emits TypeScript/JavaScript for the component’s templates.
  • angular2-seed – a starter project which includes support for AoT compilation.
  • angular-cli Using the ng serve --prod


Web Workers

Usual problem in the typical single-page application (SPA) is that our code is usually run in a single thread. This means that if we want to achieve smooth user experience with 60fps we have at most 16ms for execution between the individual frames are being rendered, otherwise they’ll drop by half.

In complex application with huge component tree, where the change detection needs to perform millions of check each second it will not be hard to start dropping frames. Thanks to the platform agnosticism of Angular and it being decoupled from DOM architecture it’s possible to run our entire application (including change detection) in a Web Worker and leave the main UI thread responsible only for rendering.


  • The module which allows us to run our application in a Web Worker is supported by the core team. Examples how it can be used, can be found here.
  • Webpack Web Worker Loader – A Web Worker Loader for webpack.


Server-Side Rendering

A big issue of the traditional SPA is that they cannot be rendered until the entire JavaScript required for their initial rendering is available. This leads to two big problems:

  • Not all search engines are running the JavaScript associated to the page so they are not able to index the content of dynamic apps properly.
  • Poor user experience, since the user will see nothing more than a blank/loading screen until the JavaScript associated with the page is downloaded, parsed and executed.

Server-side rendering solves this issue by pre-rendering the requested page on the server and providing the markup of the rendered page during the initial page load.


  • Angular Universal – Universal (isomorphic) JavaScript support for Angular.
  • Preboot – Library to help manage the transition of state (i.e. events, focus, data) from a server-generated web view to a client-generated web view.


Change Detection

On each asynchronous event Angular performs change detection over the entire component tree. Although the code which detects for changes is optimized for inline-caching, this still can be a heavy computation in complex applications. A way to improve the performance of the change detection is to not perform it for subtrees which are not supposed to be changed based on the recent actions.


The OnPush change detection strategy allows us to disable the change detection mechanism for subtrees of the component tree. By setting the change detection strategy to any component to the value ChangeDetectionStrategy.OnPush, will make the change detection perform only when the component have received different inputs. Angular will consider inputs as different when it compares them with the previous inputs by reference, and the result of the reference check is false. In combination with immutable data structures OnPush can bring great performance implications for such “pure” components.


Detaching the Change Detector

Another way of implementing a custom change detection mechanism is by detaching and reattaching the change detector (CD) for given component. Once we detach the CD Angular will not perform check for the entire component subtree.

This practice is typically used when user actions or interactions with an external services trigger the change detection more often than required. In such cases we may want to consider detaching the change detector and reattaching it only when performing change detection is required.

Run outside Angular

The Angular’s change detection mechanism is being triggered thanks to zone.js. Zone.js monkey patches all asynchronous APIs in the browser and triggers the change detection in the end of the execution of any async callback. In rare cases we may want given code to be executed outside the context of the Angular Zone and thus, without running change detection mechanism. In such cases we can use the method runOutsideAngular of the NgZone instance.


In the snippet below, you can see an example for a component which uses this practice. When the _incrementPoints method is called the component will start incrementing the _points property every 10ms (by default). The incrementation will make the illusion of an animation. Since in this case we don’t want to trigger the change detection mechanism for the entire component tree, every 10ms, we can run _incrementPoints outside the context of the Angular’s zone and update the DOM manually (see the points setter).

  template: '<span #label></span>'
class PointAnimationComponent {

  @Input() duration = 1000;
  @Input() stepDuration = 10;
  @ViewChild('label') label: ElementRef;

  @Input() set points(val: number) {
    this._points = val;
    if (this.label) {
      this.label.nativeElement.innerText = this._pipe.transform(this.points, '1.0-0');
  get points() {
    return this._points;

  private _incrementInterval: any;
  private _points: number = 0;

  constructor(private _zone: NgZone, private _pipe: DecimalPipe) {}

  ngOnChanges(changes: any) {
    const change = changes.points;
    if (!change) {
    if (typeof change.previousValue !== 'number') {
      this.points = change.currentValue;
    } else {
      this.points = change.previousValue;
      this._ngZone.runOutsideAngular(() => {

  private _incrementPoints(newVal: number) {
    const diff = newVal - this.points;
    const step = this.stepDuration * (diff / this.duration);
    const initialPoints = this.points;
    this._incrementInterval = setInterval(() => {
      let nextPoints = Math.ceil(initialPoints + diff);
      if (this.points >= nextPoints) {
        this.points = initialPoints + diff;
      } else {
        this.points += step;
    }, this.stepDuration);

Warning: Use this practice very carefully only when you’re sure what you are doing because if not used properly it can lead to an inconsistent state of the DOM. Also note that the code above is not going to run in WebWorkers. In order to make it WebWorker-compatible, you need to set the label’s value by using the Angular’s renderer.

Use pure pipes

As argument the @Pipe decorator accepts an object literal with the following format:

interface PipeMetadata {
  name: string;
  pure: boolean;

The pure flag indicates that the pipe is not dependent on any global state and does not produce side-effects. This means that the pipe will return the same output when invoked with the same input. This way Angular can cache the outputs for all the input parameters the pipe has been invoked with, and reuse them in order to not have to recompute them on each evaluation.

The default value of the pure property is true.

Use trackBy option for *ngFor directive

The *ngFor directive is used for rendering a collection. By default *ngFor doesn’t know how to identify each item of the given collection.

When the collection is changed in some way then the whole DOM tree is destroyed and recreated again. This is acceptable if the collection is totally different. But most times we have just a slightly modified collection (e.g. collection is sorted or one item is added/removed/changed). Anyway DOM tree is destroyed and recreated from the scratch again. This is unnecessary and, what even more important, may lead to poor performance of the whole app, particularly on a big collection of data.

To modify this behavior it is up to developer to provide custom tracking function as trackBy option for the *ngFor directive. Tracking function takes two arguments: index and item. Angular uses the value returned from tracking function to track items identity.


  selector: 'yt-feed',
  template: `
  <h1>Your video feed</h1>
  <yt-player *ngFor="let video of feed; trackBy: trackById"
export class YtFeedComponent {
  feed = [
      id: 3849, // note "id" field, we refer to it in "trackById" function
      title: "Angular in 60 minutes",
      url: "http://youtube.com/ng2-in-60-min",
      likes: "29345"
    // ...

  trackById(index, item) {
    return item.id;



The list of practices will dynamically evolve over time with new/updated practices. In case you notice something missing or you think that any of the practices can be improved do not hesitate to fire an issue and/or a PR. For more information please take a look at the “Contributing” section below.


In case you notice something missing, incomplete or incorrect, a pull request will be greatly appreciated. For discussion of practices which are not included in the document please open an issue.







Laravel 5.4連線MS SQL Server方式

1. config/database.php 新增

        // 2017.04.05 by lin shou shan
        'sqlsrv' => [
            'driver'   => 'sqlsrv',  // 
            'host'     => 'localhost\sqlexpress',  // 資料庫位置及別名
            'username' => 'sa',  //密號
            'password' => '',  //密碼
            'database' => '',  //資料庫
            'prefix'   => '',


Route::get(‘/’, function () {
var_dump( DB::table(‘tablename’)->first() );