1 of 29

Code for SAKE

2 of 29

What is Code for SAKE?

Code for SAKE is the civic tech project for Japanese Sake breweries.�

These days, Japanese sake breweries are shrinking.�We had about 5500 breweries, Now there is 1500 breweries in Japan.

参照 国税庁HP

http://www.nta.go.jp/taxes/sake/shiori-gaikyo/shiori/2018/pdf/100.pdf

No more Shrink!!

No Sake

No LIFE!!

3 of 29

Why it's important?

  1. Local traditional culture

Sake brewery is related for local traditional culture. like a festival, ceremony, or cherry blossom viewing.�People gather to sake, and events are exciting with sake.�If sake breweries were to disappear, festivals and other cultural events would also disappear.

4 of 29

Why it's important?

  1. Sake yeast are alive.

If we lost it, it's difficult to revive.�But the brewery yeast is only there so we cannot create it by ourselves.

5 of 29

Why it's important?

  1. Various Delicious Sake

I just want to drink various sake forever so personally want to keep various Sake.�Also each Sake has their proper tempreture to drink and proper shape of glasses to drink just like wine.�However some people dont know how to drink sake in delicious way.�So I want to share some ways to enjoy Sake more deliciously and enjoyable.

6 of 29

Why it's important?

  • For inovation

Alcohol make us optimistic and creative.�It's useful for civic tech community.�Sometimes we need new idea. �Drinking alcohol gives us ideas I wouldn't normally come up with.�And drinkers can “Yes And” discussion naturally.

7 of 29

Sakepedia

8 of 29

What is Sakepedia?

Sakepedia is the Wiki for Sake information open data.�Users can edit Breweries, Brands, Bottles data.�Where is it? What is the policy? How taste is it?�

Sake + Wikipedia

Sake Open Data for All

9 of 29

Issues we are working on

  1. Nuxt2 → Nuxt3
  2. VPS → Firebase
  3. Japanese only → i18n
  4. GitHub Login → Add Google Login

10 of 29

Contact us

This project is not only for today.�Please join our projects.

Slack: https://cfj.slack.com/archives/C014YUFP8LQ

Github: https://github.com/Code-for-SAKE

11 of 29

Sakepedia Nuxt3

システム説明

12 of 29

システム構成 system architecture

Firebase

GitHub

local

Docker

Nuxt3

Docker

Firebase Emulator

Auth

Hosting

Auth

Firestore

Firestore

pull/push

deploy

import

13 of 29

データ構造 data structure

breweries

↪︎brands

↪︎sakes

↪︎breweryDatas

posts

ref(breweries)

ref(brands)

ref(sakes)

14 of 29

Nuxt3

/app� /assets 静的データ デザイン/画像etc� /components 再利用可能vueコンポーネント� /composables 再利用可能関数� /layouts 画面レイアウト(ヘッダー/フッター)� /middleware ミドルウェア(フィルタや置換)� /pages 画面� /public 公開フォルダ� /server サーバサイドAPI処理� /utils 便利なユーティリティ関数

15 of 29

pages

about�login�breweries★� brands★� sakes★� breweryDatas★�brands 検索�sakes 検索�posts★

index.vue 一覧�add.vue 追加�[id]� /index.vue データ詳細/削除� /update.vue 更新�

★CRUD

16 of 29

Model

useFirestore <T>

getList 検索一覧 (params:{query,before,limit,converter})� getReference 参照 (path)� getItem 取得 (path,converter):Data<T>� addItem 追加 (path, data:T)� setItem 更新 (path, data:T)� deleteItem 削除 (path)

Data<T>

id:string

path:string

data:T

useFirestore� ↪︎useBrewery� ↪︎useBrand� ↪︎useSake� ↪︎useBreweryData� ↪︎usePosts

17 of 29

Component

BreweriesMap 酒蔵一覧地図(都道府県)�OnsenBreweriesMap 酒蔵一覧地図(温泉の近く)�BreweryMap 1酒蔵の位置表示�BreweryList 酒蔵一覧 追加読み込み/検索可能(名前、都道府県)�BrandList 銘柄一覧 追加読み込み/検索可能(名前、酒蔵)�SakeList 銘柄一覧 追加読み込み/検索可能���

18 of 29

2024/8/17 Today’s Results

19 of 29

Almost Translated!!

150 words translated on Spead Sheet.�Only Japanese → English, Korean, Chinese��Now embedding to source code.

20 of 29

21 of 29

2024/8/17+18 FtO Results

22 of 29

Many people enjoyed SAKE🍶🍶🍶

So Good!!

I love it!!

Amazing!!

23 of 29

i18n Sakepedia Coming!

24 of 29

  • 🇹🇭 Thai language!!!

25 of 29

And English ReadMe! You can join us!

26 of 29

We still need translate Database data….

There is many text / comment in database.

27 of 29

Contact us

This project is not only for today.�Please join our projects.

Slack: https://cfj.slack.com/archives/C014YUFP8LQ

Github: https://github.com/Code-for-SAKE

28 of 29

And I hope to develop…

29 of 29

Sakepedia for everyone in the world!

There is many local rice wine in Asia.

マッコリ 막걸리 Makgeolli

Thai has rice wine too.

🍶

🍶

🍶

🍶