Posts

Build Sequel Pro from source in XCode 10

Sequel Pro is great GUI MySQL tool in macOS (it's open source and of course totally free)

Never stop learning

#TIL : The safest way to reset root password of MySQL Server

I learned on 2018-08-25 about sysadmin, security, database, mysql

Never stop learning

#TIL : SQL Wildcard Characters

I learned on 2018-07-26 about database

Never stop learning

#TIL : Use temporarily data from another database in SQLite

I learned on 2018-05-02 about sqlite, database

Never stop learning

#TIL : Indexes on multiple columns

I learned on 2017-10-13 about indexes, database

Never stop learning

#TIL : Basics about sqlite command line tool

I learned on 2017-04-25 about sqlite, database

Never stop learning

#TIL : Persistent connection to MySQL

I learned on 2017-02-28 about database, php, mysql

Never stop learning

#TIL : UNION vs UNION ALL

I learned on 2017-02-23 about database, mysql

Backup and Restore ElasticSearch databases using Docker

One day, your ElasticSearch data is large and you have to move all data to another nodes or you just want backup the data file to somewhere.