Soemarko Ridwan

iOS & Web Developer ⟡ Coffee Addict ⟡ Scuba Diver


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.

Code Monkey

No, it's not about that Jonathan Coulton's song, though it's somewhat related. It's about Chinese developers that are burning out before 30 years old;

He is so focused on keeping his start-up alive that he can't sleep at night. She was asked in an interview if she would be willing to break up with her boyfriend for the job. A young couple want their own family but have no energy for sex after work.


Tech firms in China typically expect their employees to work long hours to prove their dedication. That means a so-called 996 schedule: 9am to 9pm, six days a week.


There are many derogatory slang words for software developers in China, such as manong (码农), which literally means “coding farmers”, and chengxuyuan (程序猿), a play on words that translates to “programming apes.”

That last part, "programming apes," it's basically code monkey, the song was released in 2006. It's nothing new. But other than that, everything else is pretty fucked up. The thing is these situations aren't that far off here in Indonesia, especially if you're a lower ranked developer. The code monkey. The companies here won't force you to do the 996 schedule, but they just won't pay you enough so you'll need to pick up some side gigs to cover basic living costs.

Network Wide Ad-block
Network Wide Ad-block

As the tagline said, blackhole for internet ads. Ever since the day of the original Adblock (even before ABP), I no longer able to browse the internet without some kind of ad blocking. But today, where most things turn into some kind of app, ad blocker doesn’t really work outside of browser. And that is where pi-hole comes in.

I never really took to Raspberry Pi, unlike Arduino, Pi doesn’t really inspire me to do anything with it. But I bought a couple of Zero W, cause it was dirt cheap, and they sit on my shelf for a year or so. Until I came across dietpi, a super lightweight, extremely minimal version of the OS. And it is designed to work headless right off the bat. I literally look for things to do with my Pi. Again, uninspiring. So I just install CUPS, and turn my USB printer into wifi printer. That’s it. These days, we hardly print anything anyway.

Until I came across pi-hole in one of the list of supported software in dietpi. Seriously, dietpi is a brilliant OS. literally just hit a checkbox, and you have pi-hole installed. Make sure you have static IP for the Pi device, and set your router DNS to the pi-hole, BAM! You’re done. Most ads are gone. Even the one in your apps. Since pi-hole is blocking on the network level, it won’t be as clean as a browser extension blocker. The boxes will still be there, but they are just empty boxes or a placeholder messages.

After using pi-hole for 3 days, turns out 30% of my queries are blocked. OMFG! a third of my internet queries are either ads or trackers. Seriously, pi-hole is so good that it’ll be worth it for you to get a $10 Raspberry Pi just for running it. Think about it, it’s like having $10 once for a lifetime service of ad blocking within your network.

A little caveat when running pi-hole under dietpi, it’s a bit tricky if you want to run dnscrypt as well (still way easier than compiling and installing everything on your own), personally, I just wait until dietpi added dnscrypt to their supported software list. Up until a few days a go, I was running nothing other than pointing my DNS to CloudFlare’s Pi-hole is a huge step-up. I can wait a bit for dnscrypt.

Uber & Lyft == GoJek & Grab
Uber & Lyft == GoJek & Grab

An interesting post from Washington Post about Uber / Lyft;

But Lyft and Uber are a different story. They’re not selling a song or a movie that can be endlessly replicated for little incremental cost; they’re selling a physical service that’s pretty expensive to deliver. At some point, we’re going to have to pay for it.

Heavy users of ride sharing should start getting used to the idea that the cost will soon go up, and plan their lives accordingly. And investors should prepare for demand to drop when customers and drivers discover the true price of the service.

I have told and repeated that to many folks in start-up world around me about GoJek and Grab. Literally the clone of Uber or Lyft in Indonesia, and some of Southeast Asia for Grab. The days of having food delivered to our door cheaper than the parking fee will go away, sooner or later.