DEV Community: Nobu

Developing accounting application as a personal project

Nobu — Mon, 30 Sep 2024 04:45:09 +0000

Application links

Application
https://accounting-app-six.vercel.app/login

Github
https://github.com/nobu0605/accounting-app

Why I developed

I had worked as a back office staff for 3 years half before I became a software engineer.
I'm still interested in accounting, so I developed it this time.

Features

・Revenue and expense

・Journal entry
You can input a journal.

・Financial Analysis

・Financial Reports

・Journals

What technology I used

Next.js
TypeScript(Front-end and Back-end)

Front-end
・material ui
・react-hook-form
・styled-components
・swr
・highcharts
・zod
・jest

Back-end
・prisma
・bcrypt
・JWT
・zod
・jest

・Server
Vercel

・DB
Supabase

・ER diagram　
https://dbdiagram.io/d/66e777896dde7f41492fd7d4

Deleted a table in production and lost four more table data with ON DELETE CASCADE

Nobu — Sun, 21 Jul 2024 05:29:29 +0000

What happened

I was asked to investigate data in the production environment. Before the investigation, I was using MySQL Workbench to delete unnecessary data on the production DB.

When investigating the data in the production DB, I mistakenly executed delete instead of select in SQL in MySQL Workbench, and deleted an entire table.

DELETE FROM posts;

ON DELETE CASCADE was set for the parent table, so four more table data were lost one after another.

If you would like to know more about ON DELETE CASCADE.
https://www.geeksforgeeks.org/mysql-on-delete-cascade-constraint/

Table structure (table names are given as examples and may differ slightly from the actual ones)

Correct settings

When a user is deleted from the users table, the records in the child tables linked to that user_id are also deleted.

comments table

CONSTRAINT `comments_ibfk_1 ` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

likes table

CONSTRAINT `likes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

points table

CONSTRAINT `points_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

posts table

CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

Incorrect setting

When you delete an entire child table posts table of the users table, the users records linked to post_id are also deleted.

Furthermore, the child table records linked to that user_id are also deleted in a chain reaction.

users table

CONSTRAINT `users_ibfk _1` FOREIGN KEY (`comment_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE 
CONSTRAINT `users_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE 
CONSTRAINT `users_ibfk_3` FOREIGN KEY (`like_id`) REFERENCES `likes` (`id`) ON DELETE CASCADE 
CONSTRAINT `users_ibfk_4` FOREIGN KEY (`point_id`) REFERENCES `points` (`id`) ON DELETE CASCADE

comments table

CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

likes table

CONSTRAINT `likes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

points table

CONSTRAINT `points_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

posts table

CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE

Dealing with the problem

This time, we took a backup of RDS every day, so I was able to restore it to its original data.
The problem occurred at about 10:45 that morning, and I was able to restore RDS at about 13:00. The restoration time may vary depending on the amount of data.
It happened during a meeting, so I was able to report the problem immediately.
Backups are very important.

Measures to prevent a recurrence

Only senior engineers or managers have editing rights (delete, etc.) to the production environment DB, and other members have read-only rights.
It was bad to have ON DELETE CASCADE set in the parent table at first, so I removed it from the parent table. I don't know how it was implemented, but it's clearly an anti-pattern, so I removed it.

Thoughts

Since I became an engineer, I had never made a big mistake until this incident, so I think I was pretty relaxed.

Also, during a meeting, we needed to investigate the data, and it was not good that I looked at the production database while talking.

When I executed DELETE, my mind went blank,
but afterwards my colleague encouraged me by saying, "I've had a lot of experiences like that. Don't worry about it," which made me happy.
I think that this is how we grow as engineers, step by step, even as we make mistakes, so I hope I can use this failure as a stepping stone to grow myself!

The presentation slides of the 10th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 18:08:02 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

We hold English-only Lightning talk events for engineers in Japan!
We are looking for LT speakers for each event! The theme is free as long as the content is for engineers.
Doing an LT in English can be quite difficult for Japanese, and it can be even more difficult when all the participants are foreigners.
We would love to hear from people who are not very confident but would like to take on the challenge of giving an LT in English.
We hope to run an event where engineers who love English can interact with each other.

10th Try English LT! event page
https://try-english-lt.connpass.com/event/308327/

slides

・Nobu
エンジニアの海外就職準備編
Preparation for working abroad for engineers
https://docs.google.com/presentation/d/1L1PACSbxG7UUuYL-84wbkMQ6_LLx3UOTN0GmnKv2Vhg/edit?usp=sharing

ワトソン san
"Do not post credentials on Slack" High School Song
https://speakerdeck.com/wattson496/do-not-post-credentials-on-slack-high-school-song-try-english-lt-10

・kohekohe san
Terraform user getting started with AWS CDK
https://speakerdeck.com/kohekohe/english-lt-terraform-vs-aws-cdk-kohekohe

・Ugo san
The Talking Rhythm
https://speakerdeck.com/yugo/the-talking-rhythm

・Yuta Miyama san
海外現地就職で6年エンジニアをやって分かった
「英語の力の入れどころ、抜きどころ」
https://docs.google.com/presentation/d/1_nYBeVhYdeUXcZlH2OFbX-Xnf4GBYDU6hyPG3xtrI5k/edit#slide=id.p

・Tamtam san
"Which should come first, the design of the data model or the domain model?"
https://speakerdeck.com/tamtam0423/which-should-be-designed-first-the-data-model-or-the-domain-model

・Jumpaku san
cyamli: A YAML-based CLI code generator
https://drive.google.com/file/d/11EMMdoeFo20exqIPYPqNd9bi7CYY5EFU/view

The presentation slides of the 9th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 18:06:47 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

9th Try English LT! event page
https://try-english-lt.connpass.com/event/267720/

slides

・Nobu
What's the difference between SQL and NoSQL?
SQLとNoSQLの違いは何か?
https://docs.google.com/presentation/d/1zOwgGObDCE05RAbTYY8HTpOQohg2uRB9P66mGWGuGVo/edit?usp=sharing

・willsmile　san
My Learning Plan on IoT
https://speakerdeck.com/willsmile/my-learning-plan-on-iot

・sugiy san
Onboarding determines the first impression after joining the company! Team onboarding is important!
https://www.figma.com/proto/fj7FJMfpD1mcewEAwrDXge/LT?page-id=1301%3A2850&node-id=1388%3A930&viewport=370%2C112%2C0.5&scaling=contain&starting-point-node-id=1388%3A930

・かきそふと san
Amazing Documents Converter Application ‘Docurain’
https://kakisoft.github.io/slides/amazing-documents-converter-application-docurain-en/export/index.html

・こーいち san
Why automated tests is important
なぜ自動テストは大切なのか
https://www.slideshare.net/secret/LCdiLihIIQafGm

・noel san
Monitering Web Vitals in our Next.js App
https://speakerdeck.com/ingenieur_noel/monitering-web-vitals-nextjs-d611cdeb-d94f-4478-9848-f1781c99cb06

・heisy san
Let's Try Kotlin
https://www.slideshare.net/HideyukiSASAKURA/lets-try-kotlin

The presentation slides of the 8th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 18:05:24 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

8th Try English LT! event page
https://try-english-lt.connpass.com/event/201124/

slides

・Henry san
Ways to be more efficient with the keyboard
https://docs.google.com/presentation/d/16QjZn62jz2B7wGOtmd4IDU5OxEXh0Sc5s1Y0C7Nv9K4/edit#slide=id.g1f87997393_0_782

・Nobu
A story about developing an accounting application using Laravel, React, and TypeScript.
Laravel、React、TypeScriptで会計アプリを開発した話
https://docs.google.com/presentation/d/1NNLAF2XdfB3Jx3yOGfzzH5pz5ACZwjxp_jUC2jlslX8/edit?usp=sharing

・canonno san
if takashi-kun runs from Hokkaido to Okinawa at 10 km an hour
たかしくんが時速10kmで日本全国を走ったら
https://speakerdeck.com/canonno/try-english-lt

・1ft-seabass. jp san
A talk about developing Node-RED node communicating with IODATA Qwatch internet camera device API.
IODATA Qwatch というインターネットカメラデバイスAPIとやりとりできる Node-RED ノードを作った話
https://speakerdeck.com/1ftseabass/20210207-try-english-lt-for-engineers

・かきそふと san
A hidden trap in DNS
DNSに潜む罠
https://kakisoft.github.io/slide/a-hidden-trap-in-DNS/export/index.html#/

・szskr san
On Yacc
https://drive.google.com/file/d/184R2KepyaGR1HvFuLNX5U2BetRLcRpKg/view?usp=sharing

The presentation slides of the 7th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 18:02:20 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

7th Try English LT! event page
https://try-english-lt.connpass.com/event/191090/

slides

・Nobu
The story of creating a bubble tea map with React and TypeScript
ReactとTypeScriptでタピオカマップを作った話
https://docs.google.com/presentation/d/1gMzCPNT5gTx4ka0R25G6MstxSgXWukhdbkRcyHReXGs/edit#slide=id.p

・にし san
Developing 'FLAPTALK' by Firebase
Firebaseを使ってFLAPTALKを開発した話
https://speakerdeck.com/takec24/developing-flaptalk-by-firebase

・nayokoNayoko san
Tips for Online English Lesson
オンライン英語学習のtips
https://speakerdeck.com/naoko3in4/tips-for-online-english-lesson

・みのる san
Making Simple IoT Bot with Azure, Obniz, Ngrok
シンプルな IoT Bot を作ってみた with Azure, Obniz, Ngrok
https://www.slideshare.net/MinoruIto3/making-iot-line-bot-with-azure-obniz-ngrok?ref=https://try-english-lt.connpass.com/event/191090/presentation/

・坂本 san
A loose move abroad to Estonia, even with a TOEIC score of 500.
TOEIC500点でもできる、エストニアでのゆるい海外移住
https://www.beautiful.ai/player/-ML2M6-wse-wOm4GhxDE/20201101_LT

・かきそふと san
Accounting for engineers
エンジニアの会計
https://kakisoft.github.io/slide/accounting-for-engineers/export/index#/

・Steve Kasuya san
Multi-factor authentication mechanism for my DIY smart lock
SuicaとQRコードの2段階認証スマートロック作ってみた
https://docs.google.com/presentation/d/1FBlhmc9KgZoF7sohwLJfHedVoo3kS8eR8QucI-sA-k4/edit#slide=id.ga697998844_0_90

・szskr san
Build Dynamic! Intro to Linkers and Loaders
https://drive.google.com/file/d/1P35YM65NJLSj1Ry98Cz7zh6mOueVyfxf/view?usp=sharing

The presentation slides of the 6th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 17:58:43 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

6th Try English LT! event page
https://try-english-lt.connpass.com/event/184047/

slides

・ShoheiKai san
Introduction of Kano Model
狩野モデルでフィードバックを整理した話
https://speakerdeck.com/show60/introduction-of-kano-model

・kanpou0108 san
What is a Closure in JavaScript
JavaScriptにおけるクロージャとは何か
https://docs.google.com/presentation/d/1W4mb5D1Gdsz9jekfwryYj95fNnMNGfpPH8APLgDitus/edit#slide=id.g9265a312a3_0_16

・szskr san
The Joy of Comment
https://drive.google.com/file/d/127rao6JzzifaGIU78KE57is1xZy6ANz8/view

・Mikihiro Saito san
Let’s develop app with react and recoil
Reactで話題のRecoilを使ってみた
https://www.slideshare.net/ssusera082dd1/reactrecoil?ref=https://try-english-lt.connpass.com/event/184047/presentation/

・bunta fujikawa san
OSS Document Translation
OSSのドキュメント翻訳について
https://docs.google.com/presentation/d/1Lr35qc0L3QPYQdw12aRuEQyIxxKzDXEQuxzAum1IcRU/edit#slide=id.p

・noel san
Push Notifications with Web App
小規模Webアプリにプッシュ通知を実装する旅路
https://www.slideshare.net/noelchris3/push-notifications-238249077?ref=https://try-english-lt.connpass.com/event/184047/presentation/

・Iqbal san
Technology selection in your software project
https://drive.google.com/file/d/1FkjMGbZBmj1VF-w6XAkV3UXT6egET3QJ/view?usp=sharing

The presentation slides of the 5th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 17:55:23 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

5th Try English LT! event page
https://try-english-lt.connpass.com/event/178498/

slides

・Nobu
How I work in the global team of the Japanese company
私がどのように日系企業のグローバルチームで働いているか
https://docs.google.com/presentation/d/1cOLJJxVR9TdrOTUHckVySZQ6dmkV-CRP9kbyDdPOw5w/edit?usp=sharing

・Yui san
The reason why I am studying NoCode.
私がノーコードを勉強している理由
https://drive.google.com/file/d/1bhhujmzqN7dlZ6tOTYKNu9lzordrlPvi/view

・akihide san
The Wall between Designers and Engineers - Storybook
https://www.slideshare.net/AKIHIDEEgashira/the-wall-to-control-storybook-for-engineers-for-designers

・Qaiyyum san
LEARNING HOW TO LEARN
https://drive.google.com/file/d/1pstztq4aR1NyX3S9A0c3xqOlDXHcBZA1/view

・willsmile san
Potentiality of using Raspberry Pi as Application Dev Environment
ラズベリーパイを開発環境とするのポテンシャリティーについての語り
https://speakerdeck.com/willsmile/potentiality-of-using-raspberry-pi-as-application-dev-environment

・b0xp2 san
A story about releasing a online pairing service for avatars living in virtual worlds
VR上で生きるアバター専用のマッチングサービスをリリースした話
https://speakerdeck.com/boxp/a-story-about-releasing-a-online-pairing-service-for-avatars-living-in-virtual-worlds

The presentation slides of the 4th Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 17:53:36 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

4th Try English LT! event page
https://try-english-lt.connpass.com/event/162045/

slides

発表資料

・anchor_cable san
https://speakerdeck.com/anchorcable/tdd-supports-us-all-the-time

The presentation slides of the 3rd Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 17:49:29 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

3rd Try English LT! event page
https://try-english-lt.connpass.com/event/152272/

slides

・Nobu
Test code of JavaScript
JavaScriptのテストコード
https://docs.google.com/presentation/d/1sQ9hXuTYzDSCaO91KGgSFtN6PVW33t9fCIfyQxd1HDA/edit?usp=sharing

・Toshi san
LaaI - LT as an Icebreaking
https://drive.google.com/file/d/11qbaI9Gz0EjzYhf_n8fVO9zTkuGZztl0/view?usp=sharing

・EmiYaegashi san
KPI and chart library
KPIとチャートライブラリ
https://speakerdeck.com/eyaegashi/kpi-and-chart-libary

・HiromuNakamura san
If you are suddenly assigned to work on k8s
もしいきなりk8sを使う作業を任されたら
https://speakerdeck.com/po3rin/if-you-are-suddenly-assigned-to-work-on-k8s

・anchor_cable san
I highly recommend Active Book Dialogue!
Active Book Dialogueの紹介
https://speakerdeck.com/anchorcable/i-highly-recommend-active-book-dialogue

・naoki85 san
A story about replacing my blog to a severless architecture
私のブログをサーバーレス構成に置き換えた話
https://speakerdeck.com/naoki85/a-story-about-replacing-my-blog-with-serverless-architecture

・nunulk san
Design It!" in a nutshell.
"Design It!" を簡単にご紹介します
https://speakerdeck.com/nunulk/design-it-in-a-nutshell

・Qaiyyum san
Cultivating a code review culture
コードレビューの文化を作る
https://drive.google.com/file/d/13gO1DQO_WJZnkqbVtLhJAxW7Lk4-Dcpu/view?usp=sharing

The presentation slides of the 2nd Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 17:46:56 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

2nd Try English LT! event page
https://try-english-lt.connpass.com/event/141242/

slides

・Toshi san
LaaI - LT as an Icebreaking
https://drive.google.com/file/d/1swQ-T3W6LfoyycFAZMS5N47UkjUpCGz4/view

・Nobu
綺麗で読みやすいコードの書き方
how to write clean code
https://docs.google.com/presentation/d/1RRscs5WfCeDKrwhqgSk7dmnpy1j7lW3YeIUT6esDLwo/edit?usp=sharing

・Manami san
Bridge SEとしての仕事ってどんな感じ？
What’s it Like My Job as a Bridge SE?
https://speakerdeck.com/penguin_note/whats-it-like-my-job-as-a-bridge-se

・n_watanabe san
日本人のためのアリババクラウド
Alibaba Cloud for Japanese
https://www.slideshare.net/NobuhideWatanabe1/alibaba-cloud-for-japanese-169288211/NobuhideWatanabe1/alibaba-cloud-for-japanese-169288211

・もーすけ san
Encouragin you to write technology blogs
https://www.slideshare.net/mosuke5/encouragin-you-to-write-technology-blogs

・alamin365 san
コンテナ戦争：Kubernetes対Docker Swarm対Amazon ECS
Container Wars: Kubernetes vs. Docker Swarm vs. Amazon ECS
https://docs.google.com/presentation/d/1KLw8x3Ba6eydqhy_A6Z5gBLWR8F8en-6FVKcS-yb090/edit#slide=id.p

・EmiYaegashi san
Sierと事業会社で習得できる英語スキルの違い
The differences of English skills which can be acquired between Sier and Service Company
https://speakerdeck.com/eyaegashi/the-differences-of-english-skills-which-can-be-acquired-between-sier-and-service-company

The presentation slides of the 1st Try English LT! for engineers

Nobu — Sun, 07 Jul 2024 17:44:10 +0000

What is Try English LT! for engineers?

https://try-english-lt.connpass.com/

1st Try English LT! event page
https://try-english-lt.connpass.com/event/133844/

slides

・Nobu
エンジニア向けの英語学習アプリを開発した話
A story about developing a learning English app for engineers
https://docs.google.com/presentation/d/1ueLECpLbZwIbPY3V2tig9NY00EfI_I4Q2u3shGA2ssw/edit#slide=id.g35f391192_00

・Toshi san
LaaI - LT as an Icebreaking
https://drive.google.com/file/d/11qbaI9Gz0EjzYhf_n8fVO9zTkuGZztl0/view?usp=sharing

・Sally san
ノンネイティブの私がなぜ留学中にトップクラスの成績が取れたのか
How I got "A" grades at a university in the US, even though I am not a native English speaker
https://speakerdeck.com/sallykinoshita/how-i-got-a-grades-at-a-university-in-the-us

・Laravel-tan san
弱小エンジニアのポジション取り作戦
A strategy to take a position for a just engineer
https://docs.google.com/presentation/d/1eOqMaSxIqdfcDYdhoQEYt1VjQh3gkkbBl0zyNDuaqC4/edit#slide=id.p

・tsu-nera san
MOOC紹介(きみも激つよエンジニアになれる）
MOOC Introduction(You can become a GEKITSUYO Engineer)
https://speakerdeck.com/tsu_nera/mooc-introduction

・Sakamoto san
CVを簡単に管理する方法を考える
Thinking about easy ways to manage your CV
https://gitpitch.com/Skmt3P/gitpitch/20190627#/

・nunulk san
英語を学ぶとどのように世界が広がるか
How does learning English broaden your world?
https://speakerdeck.com/nunulk/how-does-learning-english-broaden-your-world

・tatane san
外国人エンジニアとの付き合い方
How to get along with non-Japanese engineers
https://speakerdeck.com/tatane616/how-to-get-along-with-non-japanese-engineers

・Yuki Miyake san
Slack APIを使ってリアクションの使い方が似ているユーザをグルーピングする
Find users similar to you by analysing the history of emoji reactions in Slack
https://speakerdeck.com/zawawahoge/clustering-users-by-slack-reactions

・Kohei Tanaka san
ブロックチェーンがどのように世界を変えるのか
How blockchain change the world
https://drive.google.com/file/d/1K5jPcAl1hcH_klZBpDd1e9ru3TQUubsl/view