Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
DBFlute Introで 気軽にDBコメント変更
Search
Akifumi Tominaga
November 26, 2017
Programming
0
130
DBFlute Introで 気軽にDBコメント変更
DBFlute IntroでDatabaseのスキーマをコメントをつけて管理しようという話
Akifumi Tominaga
November 26, 2017
Tweet
Share
More Decks by Akifumi Tominaga
See All by Akifumi Tominaga
Firebase Remote Config を利用した Feature Flags の導入
decoch
0
200
Firebase Performance を利用したアプリの起動時間高速化
decoch
0
150
依存関係を静的解析しよう
decoch
2
400
CircleCIを使って 「完全サーバーレス運用」を 実現した話
decoch
2
490
GOで作るCLIツール
decoch
1
380
DBFlute-intro
decoch
0
65
Other Decks in Programming
See All in Programming
私の後悔をAWS DMSで解決した話
hiramax
4
180
Rancher と Terraform
fufuhu
2
180
Oracle Database Technology Night 92 Database Connection control FAN-AC
oracle4engineer
PRO
1
360
詳解!defer panic recover のしくみ / Understanding defer, panic, and recover
convto
0
210
オープンセミナー2025@広島「君はどこで動かすか?」アンケート結果
satoshi256kbyte
0
230
Laravel Boost 超入門
fire_arlo
2
180
AI OCR API on Lambdaを Datadogで可視化してみた
nealle
0
220
複雑なドメインに挑む.pdf
yukisakai1225
5
910
兎に角、コードレビュー
mitohato14
0
170
機能追加とリーダー業務の類似性
rinchoku
0
360
AI時代のUIはどこへ行く?
yusukebe
9
5.4k
testingを眺める
matumoto
1
130
Featured
See All Featured
How to Ace a Technical Interview
jacobian
279
23k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
185
54k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.9k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
910
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
Building a Modern Day E-commerce SEO Strategy
aleyda
43
7.5k
Building an army of robots
kneath
306
46k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
139
34k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
830
Producing Creativity
orderedlist
PRO
347
40k
The Cult of Friendly URLs
andyhume
79
6.6k
Transcript
DBFlute IntroͰ ؾܰʹDBίϝϯτมߋ 2017/11/26 #DBFluteFes @deco
Agenda • ࣗݾհ • DBFlute-introͱ • DBίϝϯτʹ͓͚Δ՝ • DBFlute-introͰͲ͏ղܾ͢Δ͔ •
σϞ • ػೳՃ༧ఆ • Q&A
ࣗݾհ
ࣗݾհ • ໊લ : Ӭߊ࢙ @deco • ৬छ : AndroidɺiPhoneΤϯδχΞ
DBFlute-introίϛολʔ
DBFlute-introͱ
DBFlute-introͱ • Javaͷ࣮ߦڥ͑͋͞Εར༻Ͱ͖Δπʔϧ • ΞϓϦͷ֎ଆͰ׆༂͢ΔDBFluteͷػೳΛɺ GUI͚ͩͰ࣮ߦͰ͖Δπʔϧ • ຊόʔδϣϯ0.1.3ΛϦϦʔε͠·ͨ͠ɻ https://github.com/dbflute/dbflute-intro/ releases
DBFlute-introͱ
DBFlute-introͱ • Github https://github.com/dbflute/dbflute-intro • ֓ཁ http://dbflute.seasar.org/ja/manual/function/helper/intro/ index.html https://www.slideshare.net/nakamu0718/dbflute-
intro-69599954?ref=https://connpass.com/event/43457/ presentation/
DBίϝϯτʹ͓͚Δ՝
࣭ • DBมߋΛߦ͏ػೳՃΛߦͬͨ͜ͱ͋Γ· ͔͢ʁ • DBมߋ࣌ʹίϝϯτ͕ͳͯ͘ࠔͬͨ͜ͱ͋ Γ·ͤΜ͔ʁ
എܠ • ͳΜͰ͜Μͳ͜ͱ͕ى͖Δͷ͔ʁ • ߟ͑ͯΈ·ͨ͠ɻ(ओ؍)
αʔϏεϦϦʔεޙ
αʔϏεϦϦʔεޙ • ςʔϒϧ20ະຬ • ։ൃऀ1~2໊ • ͦΕͧΕςʔϒϧͷҙຯΛѲ͍ͯ͠Δ
ϦϦʔεޙ1 ඇެ։
αʔϏεޙ1 • ςʔϒϧ50ະຬ • ։ൃऀ1~10໊ • ଞͷ։ൃऀ͕࡞ͬͨςʔϒϧ͕ѲͰ͖ͳ͘ͳͬ ͯ͘Δ • ։ൃऀ͕ଟ͘ͳ͍ͷͰɺฉ͚୭͔͕͍ͬͯ
Δ
ϦϦʔεޙ10ޙ ඇެ։
αʔϏεޙ10 • ςʔϒϧ300Ҏ্ • ։ൃऀ30໊~ • Α͘Θ͔Βͳ͍ɺࣅͨΑ͏ͳςʔϒϧଟ • ࡞ͬͨਓࣾʹ͍ͳ͍͜ͱ͕ଟ͍ •
༗ࣝऀࢄ͍ͯͯ͠୭ʹฉ͚͍͍͔Θ͔Βͳ͍
՝ • ίϝϯτ͕ͳ͍͔ΒɺαʔϏεಛ༗ͷཕΛ ౿Ήएख͕ଓग़ɻ • ίϝϯτΛॻ͜͏ͱͯ͠ɺERMϑΝΠϧΛ มߋ͢ΔͨΊ͕͔͔࣌ؒΓΓ͕ͨΒͳ͍ਓ ͕ଟ͍ɻʢDBFluteͷ߹ʣ
DBFlute-introͰͲ͏ղܾ͢Δ͔
DBFlute-introͰͲ͏ղܾ͢Δ͔ • DBͷใΛݟΔͷERਤ͔schema.html͕΄ ͱΜͲɻ -> schema.html্ͷDBίϝϯτΛมߋͰ ͖ΔΑ͏ʹ͠Α͏ʂʂ
DBFlute-introͰͲ͏ղܾ͢Δ͔
Ͳ͏࣮ͬͯݱ͢Δͷ͔
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷอଘॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap
DBίϝϯτͷөॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap ϑΝΠϧΛ։͍ͨλΠϛϯάͰintroʹϦΫΤετ
DBίϝϯτͷөॲཧͷྲྀΕ scheme.html DBFlute-intro dfmap dfmapϑΝΠϧΛಡΈࠐΉ
DBίϝϯτͷөॲཧͷྲྀΕ schema.html DBFlute-intro dfmap Ϛʔδ݁ՌΛJSONʹม JSON݁Ռ͔Βschema.htmlΛDOMૢ࡞
͍ํ • DBFlute-introΛμϯϩʔυ • ىಈ • schema.html͔ΒίϝϯτΛฤू
͍ํ • ֤։ൃऀ͕ࣗͷ࡞ۀϒϥϯνͰίϝϯτฤ ू • developϒϥϯνʹϚʔδ͞ΕΔɻ • ࠶࡞ۀϒϥϯνΛΔͱଞͷ։ൃऀͷίϝ ϯτΛ֬ೝ͢Δ͜ͱ͕Ͱ͖Δɻ
σϞ
ػೳͷઆ໌ • ࠷৽ͷίϝϯτΛͲͷΑ͏ʹఆ͍ͯ͠Δͷ͔ • ίϯϑϦΫτͷఆͲͷΑ͏ʹ͍ͯ͠Δͷ͔
ػೳͷઆ໌ • ίϝϯτ͝ͱʹϋογϡɺҰͭલͷϋογϡ Λ࣋ͨͤΔ
࠷৽ͷίϝϯτͷఆํ๏ code: hoge previous: null code: fuga previous: hoge code:
foo previous: fuga code: bar previous: fuga
࠷৽ͷίϝϯτͷఆํ๏ code: hoge previous: null code: fuga previous: hoge code:
foo previous: fuga code: bar previous: fuga
ίϯϑϦΫτΛHTML্ʹө
ίϯϑϦΫτͷղফ code: hoge previous: null code: fuga previous: hoge code:
foo previous: fuga code: bar previous: fuga code: end previous: foo, bar
ػೳՃ༧ఆ
ػೳՃ༧ఆ • ݱঢ়ColumnίϝϯτͷΈରԠ͍ͯ͠ΔͷͰ TableίϝϯτରԠͰ͖ΔΑ͏ʹ͢Δ • IntroΛ͍ͬͯͳ͍ਓͰίϝϯτΛදࣔͰ ͖ΔΑ͏ʹ͢Δ • ERFluteͱͷ࿈ܞͯ͠ERMϑΝΠϧʹࣗಈө Ͱ͖ΔΑ͏ʹ͢Δ
Q&A
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠