技術情報

[Laravel]バッチ処理のタスクスケジュール

今回はLaravelでバッチ処理をタスクスケジュールで実行する方法を紹介します。

続きを読む

CDN (Content Delivery Network)

Content delivery networks (CDNs) are the transparent backbone of the Internet in charge of content delivery.

The website delay interval is affected by a number of factors, many of which are specific to a given web page. However, in all cases, the length of the delay is affected by the physical distance between you and that website’s hosting server.

The mission of a CDN is to virtually shorten that physical distance, with the goal of improving the speed and performance of the site.

To minimize the distance between visitors and your website’s server, a CDN stores a cached version of its content in multiple geographic locations (points of presence, or PoP). Each PoP contains a number of caching servers responsible for delivering content to visitors within its proximity.

In essence, CDN places your content in many places at once, providing superior coverage to its users. For example, when someone in Japan accesses your website hosted in the USA. USA, Performed through a local Japan PoP. This is much faster than receiving visitor requests and responses, traversing the entire width between the source and destination.

This is how a CDN works in a nutshell. Then I think you might understand roughly how CDN works.

By Yuuma.



[SQL]年齢による条件抽出

データベースレコードには「生年月日」のカラムがありますが、「年齢」のカラムはありません。そのような場合に年齢によるSQLの条件抽出をおこなうためにはどのようにSQLを組み立てていけばいいのでしょうか。

続きを読む

Common Aggregate Functions in SQL

Today I will talk about some common aggregate functions that are widely used in SQL programming language.

Count

if we want to get the count of all records or specific where condition records, we can get by using count function.

AVG

For average rate calculations, we can use this.

SUM

For sum results of all records, we can use this.

MIN

For specific minimum result of a column, we can use this.

Likewise min, we can use max to get maximum result.

By Yuuma



[Laravel] ルーティングについて

ルーティングとは「ブラウザで入力されたURL」(リクエストURL)と、Laravelのコントローラを紐付ける方法です。

続きを読む


アプリ関連ニュース

お問い合わせはこちら

お問い合わせ・ご相談はお電話、またはお問い合わせフォームよりお受け付けいたしております。

tel. 06-6454-8833(平日 10:00~17:00)

お問い合わせフォーム