Soemarko Ridwan

… 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.

2. 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.

3. 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.

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.

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.

source

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.

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.

FLUSH TABLES WITH READ LOCK

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

    UNLOCK TABLES

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.

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.