Soemarko Ridwan

iOS & Web Developer ⟡ Coffee Addict ⟡ Scuba Diver


@businessbillions is missing the big picture here.

  • Netflix did not kill BlockBuster. Streaming did. IIRC, BlockBuster along with Redbox were doing just fine when Netflix were a mere mailed-DVD subscription service.
  • Uber did not kill the taxi business. Taxi is on a decline ever since Uber, but that's because Uber is suffocating themselves by staying in the red even after IPO. So, Uber did not kill the taxi business, Uber is killing themselves.
  • Apple did not kill the music industry. In fact, music industry was doing better than ever. Spotify on the other hand is on their way to kill the music industry by paying the artists pennies on the dollar.
  • Amazon did not kill other retailers. In fact retail business as a whole is growing, many jumping on Amazon bandwagon. Amazon only killed Borders along with other bookstores.
  • AirBNB isn't killing hotel industry. Again, hotel industry is growing along with AirBNB due to the growth of travel industry in general. The conclusion at the end there, "Not being customer-centric is the biggest threat to any businesses." Come on, name any other businesses that are more customer-centric than hotel industry. In fact, hotels are waaay more customer focus than AirBNB.

Best of WWDC 2019 for iOS Dev
Best of WWDC 2019 for iOS Dev

… well, for me. the “IMHO” implied.

  1. Sign-in with Apple

This is huge, yuuuuge. I friggin hate accounts. Managing user account is a necessary evil for a long time. On the server side I need to handle a lot of things, this was even before GDPR. Sign-in with Twitter / Facebook kinda alleviate this a tiny bit, but normal implementation still requires the “sign-in with your email”. Sign-in with Apple felt more complete, and definitely more than enough if your app is iOS only app that requires a little bit of server integration.

  1. Project Catalyst

a.k.a Marzipan, honestly, I prefer Marzipan as the name. I’ve posted my thoughts about this. It’ll be an exciting time for Mac Apps ecosystem soon enough.

  1. SwiftUI + Combine framework

I never was a fan of Storyboard, or even _xib_s. But this, this felt like a native RxSwift. There were issues when I was playing around with RxSwift, mainly I was hitting a wall that wasn’t clear whether the problem were coming from RxSwift or Xcode. So back then (about a couple years ago), I decided to just use plain Swift. Which served me well on many jobs / projects that coming my way. I get to mix it up with Obj-C. And many libraries were updated for Swift only implementation.

Those are my top 3. Bonus: WWDC 2019 Art Wallpaper.

Slimming the Web
Slimming the Web

Jeff Atwood, of StackOverflow, thoughts on Pi-hole;

We simultaneously have a very real web obesity crisis, and a looming crackdown on ad blockers, seemingly the only viable weight loss program for websites. What's a poor web citizen to do? Well, there is one thing you can do to escape the need for browser-based adblockers, at least on your home network. Install and configure Pi-Hole.

Basically the same post as mine. I still believe that dietpi is the simplest way to go. And it is headless by design. You can just tuck the Pi somewhere behind your router.

The Five Stages of Developing a New App

Source. This is so true.

  1. Curiosity
  2. Excitement
  3. Productivity
  4. Despair
  5. Polish
  6. Ship

Despair is the worst. I've abandon many apps during that stage.

Sidebar: I listen to many podcasts. I have a few that I have to actively listen to, like ATP, and Hello Internet. I use a different app on iPad for mostly NPR podcasts, these are just for getting me to sleep. Under the Radar is one of those that I subscribe to, but I don't really listen unless I have nothing else to listen to. But I'm glad that I listened to this one.


I want one. Sweet and short post :D

But really, I have been a huge fan of Panic ever since Coda 1, which I pirated way back when I was in uni, on my first ever MacBook. Immediately purchased Coda 2 from the very first Mac AppStore. It is still my go to app for web / (s)ftp needs.

If nothing else, for me, Panic represents quality. Their products imbued with everything that reminds me of Steve Jobs era Apple. Firewatch was a beautiful game. And I have no doubt Playdate will have games of similar quality.

That said, I can't afford one. Not yet. I've been hunting jobs for a few months now with zero luck. At $150, it's not breaking any banks, just that I without income, I can't justify a gaming device. As of today, there are 70,000+ people on the wait list. I hope that I got a chance to get one.

re: A Conspiracy To Kill IE6
re: A Conspiracy To Kill IE6


The plan was very simple. We would put a small banner above the video player that would only show up for IE6 users. It would read “We will be phasing out support for your browser soon. Please upgrade to one of these more modern browsers.” Next to the text would be links to the current versions of the major browsers, including Chrome, Firefox, IE8 and eventually, Opera.

Well technically, it’s just a conspiracy to deprecate IE6 within YouTube. Although, to be fair, back in 2009, when I was also a full time web developer, IE6 was the bane of my existence. No sane web programmers liked IE6.

The whole thing was a fun read though. It’s like a mini heist done by a bunch of programmers, to jump over a bunch of red tapes within their corporation. Ultimately they just lucked out that the narratives surrounding it was in support of dropping IE6. Otherwise, they’d just be told to kill the banner, one or more of them got fired, and continue supporting IE6.


I responded in a thread in Bludit’s forum where there’s someone planning on making an Android app for Bludit. In that I too have plan to make an app, but since I’m more of an iOS dev than Mac, and since marzipan just around the corner, I’d wait a bit. Also, one stone — three birds.

And then there’s Marzipanify. I think I’ve mentioned this in passing before. The screenshot above was done by Steve Troughton-Smith with Marzipanify, and more importantly, without access to source code. I’m now super excited for this WWDC.

Three Ways to Migrate MySQL Database

1. phpMyAdmin:

  1. Export your database: Go in phpMyAdmin, select your database and go to Export tab. You should see a set of options, by default both data and structure should be checked so your export will contain the database structure and the actual data in the database, for transferring the database you should use the SQL format. At the bottom of the page there should be a for that will let you specify the file name, and compression. If you select “none” the export will be dumped in your browser, this is not recommended because you would have to copy that sql and then paste it in phpMyAdmin on the new server and if the dump is large it may not work.
  2. Import the database on the new server: Click on the SQL button in the left sidebar in phpMyAdmin. In the pop up window that just showed up go to “Import files” tab. In there you will be able to import the sql file you get from your first server. The problem with the phpMyAdmin approach is that most web server configurations limit the maximum size of files you upload or the maximum execution time of a php script or the maximum memory that a PHP script can use. So unless you have small dumps (under 10 MB) this method is not recommended.

2. Command line mysql client tools: if you have shell access to any of the servers ( ssh or telnet ) you can use the command line mysql client to either export (dump ) or import a mysql database . To dump the database use mysqldump:

mysqldump -u "your_username" -p —lock-tables \\
"your_database" > your_database_dump.sql

I added —lock-tables there so that it puts a read lock on all tables while running the dump process to make sure that no one can modify the databases and create inconsistencies in the dump. If you have more then one database that needs to be exported you can use the —databases option like this:

mysqldump -u "your_username" -p —lock-tables \\
—databases DB1 **[**DB2 DB3…**]** > your_database_dump.sql

If you want to export all of your databases you can just replace —databases DB1 [DB2 DB3…] with —all-databases

To import the databases on the new server you can try the phpMyAdmin method or if you have shell access (preferable ) you can use the mysql client. If you’re going to use the mysql client you will have to transfer the dump file to the server ( use ftp or sftp/scp ).You might want to compress the file before transferring it

    bzip2 your_database_dump.sql
    scp your_database_dump.sql.bz2 user@newserver:~

and after the transfer finished, run this on the new server: mysql -u “your username” -p "your_database" < database_dump.sql

Or if your dump includes a “CREATE DATABASE” statement ( usually when a file contains the dump of more then one database or if you exported you databases using —all-databases or —databases options ) then you can just do: mysql -u “your_username” -p < your_database_dump.sql

This method works with very large databases.

3. File transfer: The MySQL server stores database structure and data in regular files on disk. This means that if you can login on the server with privileges to access the folder where the databases are stored ( usually /var/lib/mysql) then you can just copy or transfer then to another server via ftp, scp, sftp, or rsync.

Before doing so, you have to make sure no one is writing to the databases that you want to transfer so you should put a read lock on them.


Leave the mysql client running and then copy or transfer transfer the files. After the transfer finished, exit the mysql client or type:


To release the read lock.

This method also works with large databases, and it is faster than the previous method in this case MySQL server does not have to parse and process queries or recreate indexes because the whole data including indexes is transferred from the old server.