# 資料庫

###### 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/)