---
# System prepended metadata

title: 資料庫
tags: [Database, MySQL, SQLite, PostgreSQL]

---

# 資料庫

###### tags: `Database` `SQLite` `MySQL` `PostgreSQL`


- [1116 資料庫-上課投影片、SQLite範例檔](https://discord.com/channels/748042598983401482/748046752870826045/777817409255112724)

## Postgre

### [中文使用手冊](https://docs.postgresql.tw/)
### 安裝
 - Mac安裝問題
    - [Install PostgreSQL macOS](https://www.postgresqltutorial.com/install-postgresql-macos/)
### Q&A
- [有些id欄位後面是用BIGSERIAL，這個和使用INT這兩個有什麼不同？](https://discord.com/channels/748042598983401482/748046752870826045/778293052644130838)
  - [Postgre中文使用手冊 - 8.1. 數字型別](https://docs.postgresql.tw/the-sql-language/data-types/numeric-types)


## MySQL

- [SQL 教學](https://www.fooish.com/sql/)
- MySQL Server
- MySQL WorkBench
### 安裝
 - Mac安裝問題
   - [MacOS Can't start MySQL Server](https://stackoverflow.com/questions/41995912/macos-cant-start-mysql-server)
   - [在Mac如何啟動MySQL](https://www.itread01.com/p/1194830.html)
   - [Mac OS 上安裝 MySQL 以及相關設定筆記](https://www.zeusdesign.com.tw/article/19-Mac%20OS%20%E4%B8%8A%E5%AE%89%E8%A3%9D%20MySQL%20%E4%BB%A5%E5%8F%8A%E7%9B%B8%E9%97%9C%E8%A8%AD%E5%AE%9A%E7%AD%86%E8%A8%98.html)
 - Windows安裝問題
   - [Windows 10 安裝 Ruby + Rails + Node.js + Git + postgresql](https://riverye.com/2019/10/12/Windows%2010%20%E5%AE%89%E8%A3%9D%20Ruby%20+%20Rails%20+%20Node.js%20+%20Git%20+%20postgresql/)

### Q&A

## SQLite
- [DB Browser for SQLite](https://sqlitebrowser.org/)
