sql.md

SQL

• rickbergfalk.github.io/sqlpad
• Mac, Linux 에서 쓸만한 DB Tool - DBeaver
• Intro to Database Systems : Schema Refinement - Functional Dependencies
• A Tiny Intro to Database Systems
• In memory database plus traditional database combination back end architecture pattern
• DISTRIBUTED SQL DATABASE FOR THE AGE OF DOCKER
• Aven is a code generator, create an .aven scheme file and the generator will iterate over your Database, tables and columns
• An Improved Private Mechanism for Small Databases
• Simplify: move code into database functions
• PROBABILISTIC M2M RELATIONSHIPS USING BLOOM FILTERS
• New course: Learn SQL interactively on Khan Academy
• SQLBolt, a series of interactive lessons and exercises
• Effective Micro-caching in Relational Database
• Graphs in the database: SQL meets social networks
• sqlfiddle.com
• Solving Sudoku with SQL
• Why the SQL Standard does not need another way to do GROUP BY
• Practical Persistence in Go: SQL Databases
• Why your query language should be explicit
• The Sequel to SQL
• Thoughts on Time-series Databases
• DB 102: Database Orientation - Row vs. Column
• NewSQL vs. NoSQL for New OLTP
• Database expert on why NoSQL mattered — and SQL still matters
• SQL Style Guide
• How does a relational database work
• Generating MoM, YoY and CMGR from SQL
• Crab adds SQL to your command lin
• PizzaHack - Project from Maghimim 2015 camp for teaching about the SQL Injection vulnerability, and about SQL
• free.codebashing.com/courses/python/lessons/sql_injection 파이썬으로 대화형 sql injection test
• Welcome to the π-Base - A community database of topological examples with automated deduction and powerful search
• Yesquel: scalable SQL storage for Web applications
• FreeGeoDB - Free database of geographic place names and corresponding geospatial data
• RDBMS Genealogy
• "Transactions: myths, surprises and opportunities" by Martin Kleppmann
• GalaXQL - Interactive SQL tutorial
• Torturing Databases for Fun and Profit
• EDB is a framework to make and manage backups of your database
• IntelliJ 0xDBE
• Chaos Tomb: Visualizing Gameplay with D3 and SQL
• Exploring the Wall Street Journal's Pulitzer-Winning Medicare Investigation with SQL
• Readings in Database Systems, 5th Edition
• aquerytool.com
• dbguide.net
• 코드카데미, SQL 중급 강의 무료 공개
• [SQL,SELECT문처리순서/과정]parsing,optimization,execution,fetch,옵티마이저,파싱,실행,패치
• (SQL초보자를 위한, 쿼리최적화 for SQL튜닝)SQL쿼리작성Tip,최적화팁,최적화된SQL작성방법교육
• 나만 모르고 있던 – Flyway (DB 마이그레이션 Tool)
• 예제로 배우는 SQL 프로그래밍
• DB-Engines Ranking - Trend Popularity
• Comparison of different SQL implementations
• DB 데이터를 Hadoop에 저장 시 삽질 두가지
• www.erdcloud.com
• 혀로그래머 charsyam은 구라쟁이
  • 샤딩은 쉬워요 샤딩하세요
  • 캐시 멤캐시나 레디스 쓰세요. 쉬워요
  • 레디스 관련 Q&A
• WebSanitizer ScanningVideotest acunetix com
• 패스트캠퍼스 SQL튜닝캠프 1일차 - 인덱스 구조와 스캔 방식

Amazon Aurora Database

• Redesigning MySQL - AWS Tech Talk on the Aurora Database
• Now Available – Amazon Aurora
• 최소한의 다운타임으로 아마존 RDS Aurora DB로 이전하기
• MySQL에서 RDS(Aurora) 로 이관하기

Book

• SQL 전문가 되어보기

Database

• joinc
• A Database Model for Simple Board Games
• [DB/분산] 초보자를 위한 CAP 이론

Join

• SQL기초강좌(외부조인, outer join), 오라클, MySQL, 내부조인,외부조인,
• 다양한 조인(JOIN) 기법
• What's the difference between NOT EXISTS vs. NOT IN vs. LEFT JOIN WHERE IS NULL?

MariaDB

• HowTo: Install ClusterControl to Provision, Monitor and Manage MariaDB/Percona MariaDB MySQL Cluster
• Call me Maybe: MariaDB Galera Cluster
  • Clarification on “Call me Maybe: MariaDB Galera Cluster”
• Spring 4 + MyBatis 3 + MariaDB (Maven) 기반 게시판 예제
  • Project9 - Spring 4 + MyBatis 3 + MariaDB (Maven) 기반으로 제작한 웹 프로젝트 템플릿
• 빌링 시스템 장애, 이러지 말란 Maria~

MSSQL MS SQL

• Install SQL Server on Ubuntu

MySQL

• practice

  • 비개발자를 위한 MySQL
  • queries 비밀번호 변경 등 기타 명령도 포함
  • use case
    • 분리된 table을 통합하는 과정에서의 경험
    • unique constraint에서 null을 사용하는 경우의 핵심
    • table에 존재하지 않는지 검사하고 입력하는 INSERT 구문
    • 다른 table에 존재하는 record 삭제하는 DELETE 구문
    • ON DUPLICATE KEY UPDATE와 IF를 사용한 입력
  • COALESCE(<column name>, 0) column 값이 NULL인 경우 0 출력
  • LOAD, mysqlimport
    • csv 파일을 직접 MySQL 테이블로 Import 하는 방법 (대용량 파일 import 팁)

• count 1편 - count에 대해 몰랐던 사실

• count 2편 - benchmarking 해보기

• MySQL NULL 처리 삽질

• [리눅스 서버 구축하기] 7. MySQL 설치

• MySQL Tutorial

• how innodb lost its advantage

• How MySQL Is Able To Scale To 200 Million QPS - MySQL Cluster

• Working with JSON in MySQL

• JSON Labs Release: Native JSON Data Type and Binary Format

• 30 mins with JSON in MySQL

• Max JSON column length in MySQL

• MySQL performance optimization: 50% more work with 60% less latency variance

• on ORDER BY optimization

• MySQL의 ORDER BY로 지정한 순서대로 정렬하기

• Sharding Pinterest: How we scaled our MySQL fleet

• Learn to stop using shiny new things and love MySQL

• Open-sourcing Pinterest MySQL management tools

• Full Outer Join in MySQL

• MySQL InnoDB의 Adaptive Hash Index 활용

• mysql 테이블과 인덱스 설계 시 주의사항 13가지

• [MySQL] 인덱스 생성, 조회

• 패스트캠퍼스 SQL튜닝캠프 2일차 - 인덱스 향상

• gildang MySQL tutorial

• MySQL Slow Query log Monitoring using Beats & ELK

• MySQL INSERT IF NOT EXISTS

  INSERT INTO list (code, name, address,)
  SELECT 'ABC', 'ABC name', 'Johannesburg'
  FROM list
  WHERE NOT EXISTS(
      SELECT code, name, address
      FROM list
      WHERE code = 'ABC'
    AND name = 'ABC name'
    AND address = 'Johannesburg'
  )
  LIMIT 1
  

• MySQL: PHP를 사용하지 않고 Query만으로 unserialize하는 방법

• MySQL: id BETWEEN start AND end Instead of LIMIT start, step For Better Database Performance

• Troubleshooting

  • MySQL 에서 한글이 께어질때 수정을 하는 방법 UTF-8사용
    • 11.1.6 Configuring the Character Set and Collation for Applications
  • MySQL error 2006: mysql server has gone away e.g. --max_allowed_packet=268435456
    • SHOW VARIABLES LIKE 'max_allowed_packet'; or SELECT @@max_allowed_packet;
    • set global max_allowed_packet=64*1024*1024; to set (with privileged account such as root)
    • ~/.my.cnf나 /etc/my.cnf등 여러 개의 cnf file이 있을 수 있으니 적절한 file에서 수정 후 mysql을 재시작(e.g. service mysql restart)하는 방식으로 해야 할 수도 있음
    • python code with MySQLdb or mysqlclient; cursor.execute('SET GLOBAL max_allowed_packet=67108864', ()) root 권한이 필요해서 안될 듯

• MySQL 바이너리 로그를 활용한 DB 복구 방법 in Windows

• vagrant로 설치하는 mysql / phpmyadmin

• MySQL에서 파티션 일부를 다른 파티션 테이블로 옮겨보기

• Perfecting Lambda Architecture with Oracle Data Integrator (and Kafka / MapR Streams)

  • MySQL 데이터베이스의 변경 내용을 스트림으로 캡처하기 위해 Oracle Data Integrator, Apache Kafka / MapR Stream를 구성하는 과정

• Replicating Relational Databases with StreamSets Data Collector

  • MySQL 데이터베이스의 변경 내용을 스트림으로 캡처하기 위해 StreamSets을 이용
  • StreamSets은 JDBC를 이용하여 폴링 기반의 스트림 데이터 캡처가 가능
  • 본문에서 MySQL 데이터베이스의 변경 사항을 캡처하고 HDFS/Hive/Impala로 streaming 하는 과정을 설명

• Delayed Replication을 이용해 유실된 데이터 빠르게 복구하기

• MySQL을 NoSQL로 사용하기

• utf8mb4

  • How to support full Unicode in MySQL databases

• Calculating disk space usage per MySQL DB

• How to Install Only MySQL Client on CentOS, Redhat, Fedora and Ubuntu

  • yum install mysql tried to install mariadb & mariadb-libs on Redhat 7.2(CentOS Linux release 7.2.1511 (Core))

• MySQL Performance - Number of Tables Vs. Number of Rows

• 오픈소스 디비로 행원이 되어보다

• phpmyadmin의 궁극적인 대안: MySQL Workbench + 터널링

• Node.js와 MySQL 연동시키기

• MySQL: Fulltext search에서 하이픈 캐릭터 사용하기

• surrogate key 와 natural key

• 카카오뱅크 – Percona / MariaDB / MySQL

• 카카오뱅크, 마이SQL 잘 쓰는 비결

• Different locations for MySQL databases?

• 소소한 데이터 이야기 – pt-online-schema-change 편 -

• MySQL Query 추적하기

Library

• ADT - Almighty Data Trasmitter
  • github.com/kakao/adt
• Directus - Free and Open-Source MySQL Database GUI
  • A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting
• DocStore: Document Database for MySQL at Facebook
• fluent-plugin-mysql-replicator
• Galera Cluster
• mycli - Mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting
• mysos - MySQL on Mesos (moving to the Apache Incubator)
• mysql-5.6 - Facebook's branch of the Oracle MySQL v5.6 database. This includes MyRocks
  • MyRocks: A space- and write-optimized MySQL database
• MySQLTuner-perl
• OSC - Facebook releases a new OnlineSchemaChange tool written in Python
• Planche - Javascript MySQL GUI Client Tool
• TiDB is a distributed SQL database compatible with MySQL protocol
• Yahoo MySQL Performance Analyzer
• MySQL 백업 mysqldump 사용법 정리

Oracle

• examples
  • queries
• Pro*C
  • Pro*C 목차 및 sample

ORM Object Relational Mapping

• ORM: DB에 오브젝트를 쓰자

PostgreSQL

• 한국 PostgreSQL
• Postgres Guide
• Scaling out PostgreSQL for CloudFlare Analytics using CitusDB
• Postgres CLI with autocompletion and syntax highlighting
• Managing big enough data in postgres
• Bottled Water: Real-time integration of PostgreSQL and Kafka
• Compressing PostgreSQL JSONB data 12x using cstore_fdw
• Migrating to JSON in PostgreSQL
• Unleash the Power of Storing JSON in Postgres
• PostgreSQL vs. MS SQL Server
• A simple relational data access tool for NodeJS
• A proof of concept MongoDB clone built on Postgres
• Zero-downtime Postgres migrations - the hard parts
• Upsert Lands in PostgreSQL 9.5 – a First Look
• Postgres UPSERT ON DUPLICATE and how other databases implement UPSERT
• Postgres Job Queues & Failure By MVCC
• PostgreSQL: the good, the bad, and the ugly
• Postgres pushes past MySQL in developer hearts
• Stopping Time In PostgreSQL
• POSTGIS 2.2 LEVERAGING POWER OF POSTGRESQL 9.5
• SQL MERGE is quite distinct from UPSERT
• Watch "Fashion Is Hard. PostgreSQL Is Easy"
• Discovering the Computer Science Behind Postgres Indexes
• Introducing HypoPG, hypothetical indexes for PostgreSQL
• How to scale PostgreSQL on Amazon RDS using pg_shard
• High Availability for PostgreSQL, Batteries Not Included
• Making Postgres and Elasticsearch work together like it's 2015
• Documenting Your PostgreSQL Database
• Transaction ID Wraparound in Postgres
• Making Postgres Bloom
• POSTGRESQL: A FULL TEXT SEARCH ENGINE - PART 1
• PostgreSQL 9.5 New Features With Examples
• "Big data" features coming in PostgreSQL 9.5
• Scaling out PostgreSQL at CloudFlare with CitusDB
• Aquameta Layer 0: meta - Writable System Catalog for PostgreSQL
• PostgreSQL Magic
• PostgreSQL, pg_shard, and what we learned from our failures
• A few PostgreSQL tricks
• PostgreSQL replication with Londiste from Skytools 3
• EXPLAIN - explained
• PostgreSQL Foreign Data Wrappers
• PostgreSQL Monitoring Cheatsheet
• PostgreSQL - A Platform for Multiple Sources Data Retrieval
• 다우기술, 포스트그레스 한국어 메뉴얼 공식 오픈
• PostgreSQL 업그레이드 이야기
• Getting PostgreSQL transactions under control with SQLAlchemy
• MySQL vs PostgreSQL - Why you shouldn't use MySQL
• PostgreSQL 9.6 Parallel Query & FDW
• PostgreSQL Exercises
• PostgreSQL에 실시간 기능 도입하기
• The Night the PostgreSQL IDs Ran Out

Library

• Agg: Parallel aggregations for PostgreSQL
• Bottled Water: Real-time integration of PostgreSQL and Kafka
• Envelope - Introducing a new paradigm in web application development written specifically for PostgreSQL developers!
• GraphpostgresQL
• Home - Full text search in milliseconds with PostgreSQL
• Kexi is an open source visual database applications creator, a long-awaited competitor for programs like MS Access or Filemaker
• meteor-pg - Reactive PostgreSQL for Meteor
• postgrest - REST API for any Postgres database
• pgcli - Postgres CLI with autocompletion and syntax highlighting
• pgfutter - Import CSV and JSON into PostgreSQL the easy way
• pgmemcache is a set of PostgreSQL user-defined functions that provide an interface to memcached
• pg-migrator - PostgreSQL Migration Tool
• pgsql: Support GROUPING SETS, CUBE and ROLLUP
• pgsql: Create an infrastructure for parallel computation in PostgreSQL
• PG-Strom is an extension of PostgreSQL, works as custom-scan provider
• pgTAP - a suite of database functions that make it easy to write TAP-emitting unit tests in psql scripts or xUnit-style test functions
• Slinky - The easiest way to query your PostgreSQL data
• sql_firewall - SQL Firewall Extension for PostgreSQL
• stolon - PostgreSQL cloud native HA replication manager
• ToroDB: A MongoDB-compatible, document-oriented database on top of PostgreSQL
• Vacuum
  • 베큠(VACUUM)을 실행해야되는 이유 그리고 성능 향상
• Vitesse X - A Speed Extension for PostgreSQL
• Yoke - a Postgres redundancy/auto-failover solution that provides a high-availability PostgreSQL cluster that's simple to manage

Realm

• 오픈소스 모바일 DB ‘렘’, 225억 투자 유치

SQLite

• example - python
• Appropriate Uses For SQLite
• Finding bugs in SQLite, the easy way
• http://sqlitestudio.pl/
• Don't test with SQLLite when you use Postgres in Production
• The SQLite Query Planner
• Code to transform Hillary's emails from raw PDF documents to a SQLite database
• Full Text Search with SQLite
• react-native-sqlite-storage - SQLite Native Plugin for React Native
• SimpleSQLite - Python library to simplify the table creation and data insertion in SQLite database (Automatic table creation from data. Support various data type for insertion: dictionary/namedtuple/list/tuple) http://simplesqlite.readthedocs.org/en/stable/apis/simplesqlite.html

SQLServer

• SQLServer JDBC의 이상한 동작