方言を話すおしゃべり猫型ロボット『ミーア』をリリースしました(こちらをクリック)

Server (Go)

スポンサーリンク
Development/Design

[Mia] How to use Google Calendar API with Go: From Refresh Token to Event Acquisition

The Google API does not allow direct use of refresh_token to access the API. Instead, you must use refresh_token to issue a temporary access_token and send a request to the API using this token.
application(Flutter)

[Mia] Implementation of Google Calendar API access utilizing Auth Code and Refresh Token (Go and Flutter)

To manage access to the Google Calendar API more securely and efficiently, instead of using access tokens directly on the app side, we have changed the mechanism to send an authentication code (Auth Code) to the backend, generate and store a refresh token, and use that refresh token to access the Changed to a mechanism to access Google Calendar API.
Development/Design

How to resolve Dirty status of database migration in Golang

This section summarises how to deal with a Dirty state of migration in server development using Golang and golang-migrate. a Dirty state means that the migration has been interrupted and the database is in an inconsistent state. The solution procedure is described below as a reminder.
application(Flutter)

[flutter_sound × Go] Upload audio files to AWS S3 via API

In this case, we want to implement the part where the app uploads the voice files recorded with the flutter_sound package from the app to the server (AWS S3) via API communication. We will associate the S3 path of the uploaded audio file with a phrase in the database and update the voice_path field.
application(Flutter)

[Development] Reflections on Developing a Large Function: Priorities for Function Development and Testing

Although we initially assumed that it would take about a month, we were able to finish the development in about half the time (currently waiting for PR review), which was good in itself, but I would like to describe my reflections (mindset and how efficient it is to proceed with the development) after developing a large function this time as a reminder. I would like to describe it as a reminder of the experience of developing a large feature this time (mindset and how to proceed efficiently with development).
Development/Design

[AWS] How to manage access restrictions on text-to-speech files using S3 signed URLs.

A pre-signed URL provides temporary access to an object in a cloud storage service (e.g. Amazon S3); this URL is signed with specific permissions and an expiry date, allowing the user to securely download or Uploading.
application(Flutter)

[Flutter × Go × ESP32] How to add mute function to Mia.

After the release of the beta version of Mia, several users who actually used it asked for a 'no talking mode' for the frequency of talking, so the implementation of this feature is described in this report. For reference, we looked at Alexa and found that mute (in this case, goodnight mode) was indeed displayed on the home screen with a toggle icon.
Development/Design

[Golang] Practice of Test-Driven Development: From Migration File Creation to SQL Injection Countermeasures

Describes test-driven development in Go language, including migration file creation, SQL injection countermeasures and actual testing methods using dockertest. testutils.RunMySQLContainer function is called to start the MySQL container and connect to the database. RunMySQLContainer function to start the MySQL container and connect to the database.
Development/Design

[gRPC] Create a .proto file, compile it, and use it with the Go language.

Protocol Buffers (protobufs) are Interface Definition Languages (IDLs) used in gRPC to transmit data in smaller sizes and at a faster rate than traditional formats such as JSON and XML. Create a .proto file to define messages and gRPC methods
スポンサーリンク