====== Database ====== * [[http://sqlfiddle.com/|SQLFiddle]] 웹상에서 SQL 테스트. ===== Databases ===== * [[database:mysql|MySQL]] * [[database:mariadb|MariaDB]] * [[database:postgresql|PostgreSQL pgsql]] * [[mssqlserver|MS SQL Server]] * [[database:aurora|Aurora - AWS Database]] ===== 관리도구 ===== * [[database:omnidb|OmniDB]] * [[database:phpmyadmin|PHPMyAdmin]] * [[database:adminer|Adminer]] * [[database:dbeaver|DBeaver]] * https://www.heidisql.com/ ===== 시각화/분석 ===== * [[database:metabase|Metabase]] * [[database:sqlpad|SQLPad]] * [[database:redash|redash]] ===== Catalog, Database, Schema, User 등의 개념? ===== * Database 종류마다 각 용어의 의미가 다르다. * [[https://stackoverflow.com/questions/7942520/relationship-between-catalog-schema-user-and-database-instance|mysql - Relationship between catalog, schema, user, and database instance - Stack Overflow]] * 특히 [[database:mysql|MySQL]] 은 ''schema''의 개념이 없다고 보면 된다. ''catalog''를 사용해야 한다.