Google Databases Gemini Code Assist ๋„๊ตฌ๋กœ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ธ์‹ ์ฝ”๋“œ ์ƒ์„ฑ

Gemini Code Assist Google Databases ๋„๊ตฌ๋Š” Gemini Code Assist Standard ๋ฐ Enterprise ๋ฒ„์ „์˜ ์ผ๋ถ€๋กœ ์ œ๊ณต๋ฉ๋‹ˆ๋‹ค.

Gemini Code Assist ์ฑ„ํŒ…์—์„œ Google Databases ๋„๊ตฌ ํ”„๋กฌํ”„ํŠธ @GoogleDatabases๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ํ†ตํ•ฉ ๊ฐœ๋ฐœ ํ™˜๊ฒฝ(IDE)์—์„œ Cloud SQL์šฉ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ธ์‹ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์ฝ”๋“œ๋ฅผ ์ƒ์„ฑํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์‹œ์ž‘ํ•˜๊ธฐ ์ „์—

์ฒ˜์Œ ์„ธ ๋‹จ๊ณ„๋Š” ๊ด€๋ฆฌ์ž๊ฐ€ ์ˆ˜ํ–‰ํ•ด์•ผ ํ•˜๋ฉฐ ๋‚˜๋จธ์ง€ ๋‹จ๊ณ„๋Š” ๊ฐœ๋ณ„ ๊ฐœ๋ฐœ์ž๊ฐ€ ์™„๋ฃŒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

  1. Gemini Code Assist ์„ค์น˜
  2. Data Catalog๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Cloud SQL ๋ฆฌ์†Œ์Šค ๊ด€๋ฆฌ์˜ ์•ˆ๋‚ด์— ๋”ฐ๋ผ Cloud SQL์—์„œ Data Catalog๋ฅผ ์‚ฌ์šฉ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  3. Gemini Code Assist ๋„๊ตฌ ์‚ฌ์šฉ ์„ค์ •์˜ ๋‹จ๊ณ„์— ๋”ฐ๋ผ ์‚ฌ์šฉ์ž๋ฅผ ์œ„ํ•ด Google Databases ๋„๊ตฌ๋ฅผ ์‚ฌ์šฉ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.
  4. ๋„๊ตฌ ๊ตฌ์„ฑ์˜ ๋‹จ๊ณ„์— ๋”ฐ๋ผ IDE์— Google Databases ๋„๊ตฌ๋ฅผ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.

ํ•จ์ˆ˜ ์ƒ์„ฑ

  1. IDE์—์„œ Gemini Code Assist ์ฑ„ํŒ…์œผ๋กœ ์ด๋™ํ•˜์—ฌ ๋‹ค์Œ ํ”„๋กฌํ”„ํŠธ๋ฅผ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

    @GoogleDatabases generate a function FEATURE
    

    FEATURE๋ฅผ ์ฝ”๋“œ๋ฅผ ์ƒ์„ฑํ•˜๋ ค๋Š” ๊ธฐ๋Šฅ ์š”๊ตฌ์‚ฌํ•ญ์œผ๋กœ ๋ฐ”๊ฟ‰๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด ๋‹ค์Œ ํ”„๋กฌํ”„ํŠธ๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ID๋ณ„๋กœ ๊ณ ๊ฐ์„ ๊ฐ€์ ธ์˜ค๋Š” ํ•จ์ˆ˜๋ฅผ ์ƒ์„ฑํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. @GoogleDatabases generate a function to get customers by ID

    Gemini Code Assist Google Databases ๋„๊ตฌ๋Š” ๊ธฐ๋Šฅ ์š”๊ตฌ์‚ฌํ•ญ์— ๋งž๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ธ์‹ ์ฝ”๋“œ๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์ถ”๊ฐ€ ํ”„๋กฌํ”„ํŠธ

Google Databases ๋„๊ตฌ์— ๊ถŒ์žฅ๋˜๋Š” ํ”„๋กฌํ”„ํŠธ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

  • @GoogleDatabases generate a function that gets a sales comparison between the last two months
  • @GoogleDatabases generate a function that returns the top 5 selling items over the past week

๋‹ค์Œ ๋‹จ๊ณ„