https://wiki.kalen.pw/ 2026-05-01T00:30:02+00:00 https://wiki.kalen.pw/ https://wiki.kalen.pw/lib/tpl/SimpleDoku/images/favicon.ico text/html 2021-07-06T10:13:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.kalen.pw/doku.php?id=development:database:mongodb&rev=1625591590&do=diff MongoDB ---------- Basics Runs on port: 27017 ---------- Show databases show dbs ---------- Create DB use db_name # if db_name doesn't exist it will create it # However, db_name will not be saved unless you create a collection db.createCollection("Collection0") text/html 2021-06-29T19:38:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.kalen.pw/doku.php?id=development:database:mysql&rev=1625020714&do=diff MySQL ---------- Cleaner Terminal Output MySQL can have quite messy output when running queries from the mysql cli. You can terminate a statement with \G instead of ; to format as a list instead of table. SELECT * FROM users\G Alternatively, you can set the pager to text/html 2022-11-28T19:59:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.kalen.pw/doku.php?id=development:database:postgresql&rev=1669690768&do=diff Postgres ---------- Installation # Linux sudo apt install postgresql postgresql-contrib # Mac brew install postgresql # Starting service brew services start postgresql ---------- Change Password ALTER ROLE postgres WITH PASSWORD 'password'; text/html 2021-07-06T09:52:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.kalen.pw/doku.php?id=development:database:start&rev=1625590372&do=diff Database * MongoDB * MySQL * Postgres