Home›Google Cloud in 5 Days›Day 3
Day 3 of 5
⏱ ~60 minutes
Google Cloud in 5 Days — Day 3

Storage: GCS and Cloud SQL

Create Cloud Storage buckets, upload and serve files, use signed URLs for private access, and provision a Cloud SQL instance.

Cloud Storage Buckets

gsutil commands
# Create a bucket (name must be globally unique)
gsutil mb gs://my-unique-bucket-name

# Upload files
gsutil cp file.txt gs://my-bucket/
gsutil cp -r ./folder gs://my-bucket/folder/

# List bucket contents
gsutil ls gs://my-bucket/

# Make a file public
gsutil acl ch -u AllUsers:R gs://my-bucket/file.txt

# Make entire bucket public (for static sites)
gsutil iam ch allUsers:objectViewer gs://my-bucket
Python SDK
from google.cloud import storage

client = storage.Client()
bucket = client.bucket('my-bucket')

# Upload
blob = bucket.blob('uploads/photo.jpg')
blob.upload_from_filename('/local/photo.jpg')

# Generate signed URL (temporary private access)
url = blob.generate_signed_url(
    expiration=datetime.timedelta(hours=1),
    method='GET'
)
Cloud SQL
# Create a PostgreSQL instance
gcloud sql instances create my-db \
  --database-version=POSTGRES_15 \
  --tier=db-f1-micro \
  --region=us-central1

# Create a database
gcloud sql databases create myapp --instance=my-db

# Create a user
gcloud sql users create dbuser --instance=my-db --password=secret

# Connect via proxy
gcloud sql connect my-db --user=dbuser --database=myapp
📝 Day 3 Exercise
Build a File Upload App
  1. C
  2. r
  3. e
  4. a
  5. t
  6. e
  8. a
  10. G
  11. C
  12. S
  14. b
  15. u
  16. c
  17. k
  18. e
  19. t
  20. .
  22. W
  23. r
  24. i
  25. t
  26. e
  28. a
  30. P
  31. y
  32. t
  33. h
  34. o
  35. n
  37. s
  38. c
  39. r
  40. i
  41. p
  42. t
  44. t
  45. h
  46. a
  47. t
  49. u
  50. p
  51. l
  52. o
  53. a
  54. d
  55. s
  57. a
  59. f
  60. i
  61. l
  62. e
  63. ,
  65. g
  66. e
  67. n
  68. e
  69. r
  70. a
  71. t
  72. e
  73. s
  75. a
  77. s
  78. i
  79. g
  80. n
  81. e
  82. d
  84. U
  85. R
  86. L
  87. ,
  89. a
  90. n
  91. d
  93. p
  94. r
  95. i
  96. n
  97. t
  98. s
  100. i
  101. t
  102. .
  104. P
  105. r
  106. o
  107. v
  108. i
  109. s
  110. i
  111. o
  112. n
  114. a
  116. C
  117. l
  118. o
  119. u
  120. d
  122. S
  123. Q
  124. L
  126. i
  127. n
  128. s
  129. t
  130. a
  131. n
  132. c
  133. e
  135. (
  136. f
  137. r
  138. e
  139. e
  141. t
  142. i
  143. e
  144. r
  145. )
  146. .
  148. C
  149. o
  150. n
  151. n
  152. e
  153. c
  154. t
  156. t
  157. o
  159. i
  160. t
  162. a
  163. n
  164. d
  166. c
  167. r
  168. e
  169. a
  170. t
  171. e
  173. a
  175. t
  176. a
  177. b
  178. l
  179. e
  180. .

Day 3 Summary

  • GCS buckets store any file type. gsutil CLI + Python SDK for automation.
  • Signed URLs grant temporary access to private objects without making the bucket public.
  • Cloud SQL is managed PostgreSQL/MySQL — same SQL you know, GCP handles backups and updates.
  • db-f1-micro is the smallest Cloud SQL tier. Use it for development to minimize cost.
→
← Previous
Day 2: Compute: Cloud Run and GCE
Next →
Day 4: BigQuery for Analytics
→
Finished this lesson?