開発スタッフがアプリ関連の最新技術やニュースをご紹介します。

Today, I would like to talk about hosting services that are available to upload your site for free. Although there are thousands of services that are giving free, I will share some good services among these which I know. Let’s get started.

Github Pages

Github is a company that hosts code repositories, collections of code for projects. Github has a feature called Github Pages, which makes it easy and free for you to create a multi-file website hosted on yourusername.github.io. GitHub Pages is a static site hosting service that takes HTML, CSS, and JavaScript files directly from a repository on GitHub, optionally runs the files through a build process, and publishes a website. You can see here. When uploading source code, it is necessary to consider whether the source code is safe to be released to the public.

Netlify

Netlify allows you to create a website using the repository on the git platform. You just need to choose the repository and run the deployment command. After the deployment is complete, your site will be live. You can see here.

AWS Free Tier

Amazon Web Services is an integrated provider of cloud-based computing solutions. One of the Services they provide is Web Site Hosting. AWS offers you a one year free account called AWS Free Tier and you can test and use variety of products from AWS like EC2, S3, RDS and so on. I know it is a little bit hard to consume the UI of AWS but it will improve your server administration knowledge. Be sure to test it out. See here for more detail.

Website Builders

There are some other free services that has website builder like wordpress. So you don’t have to write a single line of code and can build your website within minutes. For example wordpress, wix, weebly. But these services might also have pricing features, so they might force you to buy their product by somehow.

By Yuuma

Tweet

HTC VIVE用VRアプリ開発でUnityを使用してレーザーポインターを実装する方法を紹介します。
本記事は前回の「[HTC VIVE + Unity] レーザーポインターの実装方法 (1)」の続きです。

Tweet

AMD製 Ryzen CPU搭載のPC上で
VirtualBoxを使ってLinuxサーバーを立てようとしたところ
VirtualBoxの エラーに遭遇したのでその解決方法のご紹介です。

Tweet

Today I would like to talk about MySQL joins along with some practical example queries.

Inner Join

２テーブルの中で同じレコードだけ出る。
(return only matching records from both tables)

Left Join

left テーブルは全レコードが出る、right テーブルのは同じレコードだけ
(return all records from the left table, and only the matched records from the right table)

Right Join

right テーブルは全レコードが出る、leftテーブルのは同じレコードだけ
(return all records from the right table, and only the matched records from the left table)

Full Outer Join

同じレコードが有る時全部レコードが出る。
(return all records from both tables if there is match record between them)

Inner Join Query Example

SELECT column(s)
FROM tb1
INNER JOIN tb2
ON tb1.column = tb2.column;

Left Join Query Example

SELECT column(s)
FROM tb1
LEFT JOIN tb2
ON tb1.column = tb2.column;

Right Join Query Example

SELECT column(s)
FROM tb1
RIGHT JOIN tb2
ON tb1.column = tb2.column;

Full Outer Join Query Example

mysql doesn’t support full join syntax directly so we can use this as an alternative.
(full join = left + right join)

SELECT column(s)
FROM tb1
LEFT JOIN tb2 ON tb1.column = tb2.column;
LEFT JOIN tb3 ON tb1.column = tb3.column;
UNION
SELECT column(s)
FROM tb1
SELECT column(s)
FROM tb1
RIGHT JOIN tb2 ON tb1.column = tb2.column;
RIGHT JOIN tb3 ON tb1.column = tb3.column;

Tweet

HTC VIVE用VRアプリ開発でUnityを使用してレーザーポインターを実装する方法を紹介します。

Tweet