Categories
iPhone app Music

Playlist

Reading Time: 3 minutes

Music playlist is quite common nowadays. For me personally I was a bit late to the party. I did use playlist on my iPhone Apple Music app, and on my YT: both desktop and iPhone. But recently since I started to participate the group exercise class at the J, I realized playlist and music in general is a big deal. I believe the Yoga teachers at the J has a playlist too.

An example or case study

清新女声何璟昕:薄荷糖般的味道甜入我心 (QQ Music QQ音乐 ) Note: you will likely need to log in to see the content. For me I use my WeChat login (SSO) for many China-based website/apps. You can read more about Ayen 何璟昕 here

I created a few Playlists for Ayen 何璟昕 on YT and YT Music – this one specially for original songs – Ayen阿昕原创+新歌. Note I have the premium subscription for YT and it allows me to listen to the YT Music in the background, in addition to some other features such as skipping ads in a video.

And I just noticed she has some playlists on YT too: this one is for 翻唱 cover – Ayen cover 何璟昕的翻唱

She did quite a bit of 翻唱 (cover, or acoustic cover) in last few years. I like them all. Some of songs are new to me because I left mainland China in summer/fall 1997. Below a “mixes” of 翻唱 cover songs I listened on 04-08-2025 early morning – “Mixes are playlists YouTube makes for you” per YT. I think the link above may expire after certain time. Btw, I think “mixes” or the YT generated list is a good way to explore what’s out there, because YT will recommend new songs. So in other words, this kind of playlist has some discovery functions. Update 04-20-2025 Btw, I realized this is a dynamic list. Update 04-28-2025: I started to appreciate the computers (and the AI) may have an edge or advantage to create playlist, based on the listening history. The recommendation algorithm may be similar to the social media posts suggestion.

【Mr. 森林】Acoustic guitar cover | Ayen 何璟昕 (Oct 16, 2020, this is YT upload date, same below) Hint: this one has about one minute of funny behind the scenes 花絮/彩蛋 videos in the end – made me realize that it’s not easy to learn a new song and so on. Obviously, it depends on the song itself too. Also, I think many people would appreciate some of the light hearted carefree nature in the behind the scenes 花絮/彩蛋 too.

梅艷芳 – 似是故人來 Acoustic guitar cover 吉他弹唱 粵語翻唱+旗袍 | Ayen 何璟昕

千千闕歌 | 吉他彈唱 cover 陳慧嫻/張國榮 經典粵語歌 | Ayen 何璟昕 (Apr 17, 2020)

Eason 陳奕迅 – Shall we talk 女生版 Acoustic cover (Jan 21, 2022) I didn’t pay attention to Eason 陳奕迅 to be honest, and only till very recently I read his Wikipedia page.

陳奕迅 – 苦瓜 粵語吉他彈唱女生版(完整版)| Ayen 何璟昕

鄭秀文 | 終身美麗 Cover 吉他彈唱 何璟昕 (Feb 15, 2019)

一人有一個夢想 – 黎瑞恩 (Mar 30, 2021)

陳奕迅 Eason – 最佳損友 Acoustic cover (Aug 28, 2021)

謝安琪【喜帖街】Kay Tse 鋼琴+吉他彈唱 這是一首關於懷舊的粵語歌 | cover by Ayen 何璟昕 (Mar 22, 2020; make sure watch till the end 🙂

衛蘭歌曲串燒!低半度/驗傷/就算世界無童話/街燈晚餐 新歌老歌 吉他彈唱cover | Ayen 何璟昕 (Mar 1, 2020) This is a new experiment of singing 4 songs together (one after another) – 《低半度》《驗傷》《就算世界無童話》《街燈晚餐》

王菲/李健 – 傳奇 Acoustic cover|吉他彈唱|Ayen何璟昕 (Sept 30, 2022)

盛夏的果實 – 莫文蔚 Acoustic cover|吉他彈唱|Ayen何璟昕 (Aug 12, 2022)

你的眼神 国粤双语版 cover蔡琴/卫兰/林志美 Acoustic cover|吉他弹唱|Ayen何璟昕 (Sept 9, 2020)

周傑倫《回到過去》女生版宿舍版吉他彈唱 | Ayen 何璟昕 (Sept 25, 2020)

一场游戏一场梦 – 王杰 Cover 吉他弹唱 – 电影《风中有朵雨做的云》插曲 何璟昕 (Apr 7, 2019)

粵語民謠「四季歌」女生版 Acoustic cover 生活需要一些安靜🍃|粵語歌吉他彈唱|Ayen何璟昕 (Jul 22, 2024) My comment: one of my favorites, I like this simple folk song 🙂

阿郎戀曲(許冠傑)Cover 吉他彈唱 何璟昕 (Jul 16, 2017)

一生何求 陈百强 (Feb 26, 2021)

Other playlists I plan to create

Some of my older readers may know I have an iPod Nano 7th generation. Right now I just sync all my iTunes songs that I like from Mac to the iPod. Thinking creating playlist next (from Mac, then sync to the iPod Nano).

Usage of playlist

I think there are at least two use cases for me. One is the background music during work. Another one is background music for sleep. I used to listen to the radio (more specifically NPR or over the night it’s more likely BBC World News), but listening to news has its downside, because sometimes the news can be depressing, and other times news would keep me awake. I prefer some calming music over news. A secondary factor is using iPod nano as radio drains battery more quickly.

More on YT Playlist

I found playlist is integrated with YouTube Studio (I create YT video there too). I have 203 playlists: I think I need to clean up some. Also the link above is only available to me (because I am the owner of my YT Studio account).

PS:

Google search “can people make money from curating music playlist”

Search Labs | AI Overview

Yes, people can make money curating music playlists. Platforms like Playlist Push and others offer curators payment for reviewing music and maintaining active playlists. Pay varies, with some curators earning $1.50 to $15 per song reviewed, depending on their playlist’s listenership.

Btw, I just noticed two of my YT Music playlists have more than 1,000 views.

Ayen阿昕翻唱

and

Ayen阿昕原创+新歌

Categories
iPhone app Music

YouTube Music and Music Industry

Reading Time: 6 minutes

Music made together may one day heal mankind. – from “We Gather Here Together” (YT)

For music streaming nowadays I mainly use YouTube Music, because I have YouTube Premium subscription. It’s not perfect, but YT Music has a decent collection, and functionality.

YouTube and YouTube Music

When I was listening to Ayen 何璟昕 music both via YT and YT Music, as I switch between them as I was trying to conserve some data usage (partially because I lost power and Wi-Fi a few days ago). I noticed that YT Music is sometimes automatically generated by YouTube (Google), for example this channel. More on YouTube automation here.

Also, I realized there are two ways we can avoid using cell phone data.

1) Listen to music on YT Music: if we download the video via Wi-Fi in advance, and listen to it in the Download mode, not the library mode. The playlist in Download mode can play continuously, or you can actually loop the playlist if you like;

2) Watch videos on YT, if we download the video via Wi-Fi in advance. If we start playing from the last downloaded video, it will continue to the next, and so on.

If we are watching the video from the library mode, it will use data on YT Music.

YT Music Sync from Library to Download: there is a sync icon button in the downloaded playlist, press it and a popup will show up, ask you to confirm, you say yes, and it will apply the update.

Some More Tips for YT and YT Music

Loop in YT: I just found out we can loop a single song on YouTube too (move mouse over the video, right mouse click, and you see an option of “Loop”. Also, sometimes YT has the “transcript” function (I think it depends on how the creator set it up), and you can follow along with the lyrics for a song (or words/captions for a video). Note the looping works both on Desktop and in the iOS app.

YT Music: you can loop a song or loop a playlist. The icon is at the bottom right when you play a song. If you just want to loop a song, tap twice and make sure you have a number “1” inside that loop.

A bug in YT Music (italics for emphasis):

I learned this lesson the hard way a few times. I found that, “saving to playlist” in YT Music website will mess up my playlist pretty badly. Now if I can stay away from doing that. By “messing up” I mean a lot of duplicates or songs that I don’t intend to add got added when I did the “save” 🙂

Also, I found recently, for many songs, we can jump directly from YT to YT Music by press a “play icon button” inside YT (when applicable).

Sometimes we need to get to the comments and edit. Below is the link getting to the comments.

Google – My Activity (YouTube comments)

Also, YouTube History has a link to “Comments

A subtle bug in YT Music

Someday I hope I can become a product manager for YT Music and I noticed a subtle bug: in the YT music occasionally the cover page (the image and the song name) is wrong. The music or the song is still correct. The video is correct too.

a screenshot from YT
YT: note the YT music image and song name don’t match the song in YT

Music industry

The landscape of digital music is overly fragmented, in my opinion. For example, in China it appears QQ音乐 and 网易云音乐 (Ayen何璟昕 on 网易云音乐) are popular. In the west Spotify and Apple Music are two largest platforms. Personally, I used mostly YT and YT Music as I have YT Premium Sub. Then there are the social media platforms: which are also fragmented, obviously.

Keep in mind in last 10 years or so, the music industry has experienced seismic shift – music is increasingly being streamed online, instead of the good old days of CD, or singles sales. I think it may have something impact on Ayen 何璟昕‘s journey becoming a musician/song writer/singer. She does have one advantage: her undergraduate major is digital media – and we can see some of her work in the MV (music video) she created.

I still remember the days at Best Buy there are racks and racks of CDs on display, it was probably 15 or 20 years ago. Both our 2012 Toyota Camry and 2012 Toyota Sienna still had CD player build in – both has bluetooth and USB too, so it can be connected to smartphone.

Google search “npr music indstry steaming” || NPR – How the music industry has changed in the first quarter of this century

Copyrights etc.

Also, I just came across this – 中国音乐人,困在版权里。从虾米音乐关停聊聊中国音乐人的版权困境。by Feng’s Music Channel (叨叨冯). You may read some of the comments if you know Chinese. It’s interesting to say the least.

This reminds me at St. Louis Children’s Choirs, they check the copyrights of the music or the song they are singing, and pay the author a royalty or something like that. I don’t know if they use companies such as Swank Motion Pictures or some other company. Btw, our old daughter sung at St. Louis Children’s Choirs from 1st grade to 7th grade, and we have many wonderful memories.

More about music copyrights in China: 什么是音乐版权?by HEM Records

I recall many years ago, probably in year 2004, I heard a lot of controversy of copyrights issues at YouTube too. That’s when YouTube was bought by Google.

In terms of singers, think I am going to write about Sandy Lam (Lin Yi’lian) and G.E.M. Deng Ziqi next.

It’s hard to make a decent living as a musician

I am not talking about the top dogs, such as Taylor Swift in the USA, or G.E.M. Deng Ziqi in HK. They make money both from music (even from streaming, because of their music are being played quite a bit on streaming platforms), and from live performance.

But most musicians are not that lucky: the two income streams are usually not enough to make decent living. I saw people work on a few other things to make ends meet: teach, write customized music (song, lyrics, collaborate etc.), make/sell instruments. For example, I saw many song writers do customized music. And Ayen何璟昕 does all three. Carlos makes instruments.

(Update 05-03-2025) I confirmed above with a friend who has about 3 millions streaming (a year) on Spotify. He told the gross profit is about $10,000. But he needs to pay record label and recoding studio etc., so basically he has nothing left after that. He also said people like Taylor Swift has billions of streaming for her songs. Also Spotify has better payout ratio for people like Taylor Swift, compared to ordinary creators Joe and Jane. Last but not least, this is not new phenomena: it was like that pre-streaming, and I assume that’s applicable for the days when CD, cassette and vinyl were the main media for distribute the music. So if I could expand it a bit, it’s basically similar to the wealth distribution of the USA: the rich get richer, the poor becomes poorer. (Update 05-16-2025) This reminds me of the similar point Warren Buffett said here on YT Shorts – “a more and more specialized economy”.

(Update 05-09-2025) I looked around a bit more. I found couple places that musicans can sell their products.

TomPlay website

Gum Road (also google search “any musicians successfully sell on gumroad”)

Related: Google Search “is it harder to survive as musician”

Last but not least, [Piano Cover] 八三夭 831 – 想見你想見你想見你|你沒看過的超難還原鋼琴版 (the piano instruction video and also the author sells music sheet too)

(Update 05-12-2025) I found couple music platforms that act between musicians and the YT. For example, I found this one ewway.com at 痴人. And I came across another one Bquate SAC from this song 此生无憾 (国粤对唱版). I like to do a bit more research in the near future.

(Update 05-13-2025) Here is another one 敢开始 submitted by Tencent. In this case, it seems the song was submitted by the publisher to YT Music. You can watch the actual music video here –東風日產勁客《敢開始》Ayen何璟昕 原創歌曲 既有所想,就勇敢開始,不為一個結果 .

I noticed “Auto-generated by YouTube” (link goes to Reddit) in the description. From programming or software integration point of view, I speculate the music platforms have backend integrations with Google/YouTube via API. This is likely accomplished via a batch process.

Last not not least, I found the competition among Chinese songs are so tense, and for example, for 哪吒2主题曲 — 此生无憾. I am aware of 7 versions on YT. And this is only a partial list. One of them is very gimmicky, and obviously I won’t give special attention to the channel or the video. But you can guess which one 🙂

1

2

3 此生无憾 (国语女生版)

4

5

6

7 – 哪吒主题曲【2】完整版《此生无憾 》张碧晨演唱👍🌹好听

PS:

Also refer to How to listen to Chinese music or songs nowadays

PS 2:

I noticed one Ladue HS graduate picked composition as the college major. I think the college is JHU. I want to wish the senior best of luck.

PS 3:

A thread on Apple Music

Categories
China gadgets iOS iPhone app Life Life Tips Technology Travel Web

VPN software I have used personally

Reading Time: 3 minutes

This article can also be read on Medium. But this blog post has all the up to date information, while the medium.com article doesn’t get regular update.

Sometimes called 科学上网 in CHN

Mac:

VPN Prime – Unlimited Proxy 4+

Update early June 2025, the free plan appears stopped working in my most recent CHH trip.

Update June 12, 2025: I purchased the paid plan, and it works (again I found a sever that worked). Considering switching from the below iOS app to this Mac app for my VPN needs.

Update 06-13-25: sometimes the connection will get reset and get lost. In that case, I tried to connect to another server and it usually works.

Update 06-14-2025: I felt more confident using this app. I think this is a viable option if I need to work from CHN (right now my employer doesn’t allow that).

iPhone, iPad

VPN – Super Unlimited Proxy 4+ (Update June 2025, it still works, I have the premium sub now, and I know not all servers work, and I have my fav server now. Email me if you like to know 🙂

Update 06-12-2025: I noticed this app doesn’t always work flawlessly. At least in the two hotels I stayed, it didn’t like the Hotel WiFi. I don’t know how the app works exactly, but during the connection process, it seems dropping the WiFi and used the cellular data, which would cause the connection issue.

Update 06-17-2025: again, this app works flawlessly when I am in the US. Now I tend to think due to its popularity, China blocks this app’s use 🙁

(Original) Note: both apps have free versions, and both have add-ons that are available for purchase. I verified them on my trip and they work for the most part, iPhone app sometimes takes a few tries to get going. The Mac app works out of the box most of the time.

Cell phone international roaming

I know T-mobile used to have it. Mint Mobile has international pass too: 1 day, 3 day and 10 day. The device can go to outside world just like the VPN would. One may have to check her/his current cell phone carrier and see there is such a program or a pass.

Cell phone roaming has its own advantage, for example, we can order food or ride-share cars as those apps are usually available on the smart phone and they usually require internet connection. But in the case of China, ideally one may want to get a local phone number, as it’s needed by the meituan and didi chuxing apps.

Other use cases:

Netflix (shows from other country etc.)

Organizations sometimes block certain social media websites: this can happen in the western countries too.

Other software

Nord VPN: paid. It takes some effort to get it working in CHN. It seems all the default servers are blocked. Had to open a ticket to get alternative server names (ip address etc.), try and error, to got it working in year 2023. Retrieved a list during most recent trip too (summer 2024), haven’t tried it out as I found the two solutions above are good enough.

Default setting for Nord VPN is working when in the USA. That’s true for the free versions for two apps above too.

(Update 01/03/2025) I found this bug a while back, the issue was when my phone is on the Mobile Data network (not Wi-Fi), and when the VPN was on via Wi-Fi before the cut over, it seems Nord VPN has difficulty connect to VPN. Took me a while to understand why I lost internet connection. I am ditching this app (and software) now – not solely because of this. It’s just another annoying thing or bug for me. I noticed it didn’t work out of box on the public K-12 school’s public Wi-Fi – had to use VPN – Super Unlimited Proxy 4+ (the free version: I may consider support them later once my Nord VPN subscription expires).

(Original post July 2024) Open VPN (I set it up on my own $DGCN server), but it stopped working for me in CHN in my 2023 trip. Bought Nord VPN in that trip too. Refer to this Chinese article if you want to learn more about OpenVPN or setup your own OpenVPN server (note it still works outside CHN’s GFW).

PS: you may want to take a look at eSIM app for travel.

我用VPN主要是因为我的personal email 是GMail,还有我有时会听YT/YT Music上面的歌。下面是谷歌中文翻译。

======

这篇文章也可以在 Medium 上阅读。但这篇博文包含所有最新信息,而 medium.com 上的文章则没有定期更新。

中文有时称为“科学上网”,或者叫梯子:可能是从“翻墙”那里衍生出来的。

Mac:

VPN Prime – 无限代理 4+

更新于 2025 年 6 月初,免费套餐似乎在我最近的一次 CHN 之旅中停止了工作。

更新于 2025 年 6 月 12 日:我购买了付费套餐,现在可以使用了(我又找到了一个可以正常工作的服务器)。我考虑从下面的 iOS 应用切换到这个 Mac 应用来满足我的 VPN 需求。

更新于 2025 年 6 月 13 日:有时连接会被重置并丢失。在这种情况下,我尝试连接到其他服务器,通常情况下可以正常工作。

iPhone、iPad

VPN – 超级无限代理 4+(更新至 2025 年 6 月,它仍然有效,我现在有付费订阅,我知道并非所有服务器都能正常工作,而且我现在有我最喜欢的服务器了。如果你想知道,请给我发邮件

更新于 2015 年 6 月 12 日:我注意到这个应用程序并不总是完美无缺。至少在我住过的两家酒店,它不如酒店的 WiFi 好用。我不知道这个应用程序的具体工作原理,但在连接过程中,它似乎会断开 WiFi 并使用蜂窝数据,这会导致连接问题。

(原文)注意:这两个应用程序都有免费版本,并且都有可购买的附加组件。我在旅途中验证了它们,它们大部分时间都可以正常工作,iPhone 应用程序有时需要尝试几次才能启动。Mac 应用程序大多数时候开箱即用。

手机国际漫游

我知道 T-mobile 以前有这个功能。Mint Mobile 也有国际漫游通行证:1 天、3 天和10天。该设备可以像VPN一样连接到外部网络。用户可能需要检查当前的手机运营商,看看是否有这样的程序或通行证。

手机漫游有其自身的优势,例如,我们可以订餐或叫车,因为这些应用程序通常在智能手机上可用,并且通常需要网络连接。但在中国,理想情况下,用户可能需要获取一个本地电话号码,因为美团和滴滴出行等应用程序需要这些号码。

其他用例:

Netflix(其他国家的节目等)

一些组织有时会屏蔽某些社交媒体网站:这种情况在西方国家也可能发生。

其他软件

Nord VPN:付费。在中国使用需要一些时间。似乎所有默认服务器都被屏蔽了。不得不提交工单获取备用服务器名称(IP地址等),反复尝试,最终在2023年成功恢复。在最近的一次旅行中(夏季)也获取了一份列表。 2024),我还没试过,因为我觉得上面两个方案已经够用了。

Nord VPN 在美国默认设置下可以正常工作。上面两个应用的免费版本也一样。

(更新于 2025 年 3 月 1 日)我之前发现了这个 bug,问题出在当我的手机连接移动数据网络(而非 Wi-Fi)时,如果在切换之前 VPN 是通过 Wi-Fi 开启的,Nord VPN 似乎很难连接到 VPN。我花了一段时间才明白为什么我断网了。我现在正在放弃这个应用(和软件),不仅仅是因为这个。这只是另一个让我恼火的问题或 bug。我注意到它在公立 K-12 学校的公共 Wi-Fi 上无法开箱即用——不得不使用 VPN——Super Unlimited Proxy 4+(免费版:等我的 Nord VPN 订阅到期后,我可能会考虑支持他们)。

(原帖)Open VPN(我在自己的 $DGCN 上设置了它)服务器),但在我2023年的中国之行中,它失效了。那次旅行我也买了Nord VPN。如果你想了解更多关于OpenVPN的信息,或者搭建你自己的OpenVPN服务器(注意,它在中国的GFW之外仍然可以使用),请参阅这篇中文文章。

Categories
iPhone app Life Life Tips

Keep fit

Reading Time: 2 minutes

I am trying to keep fit and I have been doing this for a while (before pandemic). This includes both the physical fit, weight and most recently, the iPhone addiction. Also as the weather is getting colder, and I am thinking doing a bit more swimming. Last but not least, I am thinking slowly going back to office: my office is about 5 minutes away.

About 5 years ago, I started running (joggling), initially doing a few 5K races. I still remember I ran out of breath quickly after running probably a few hundred yards. I did better and ran longer over the time, until I ran a half marathon with about 2 hours 23 minutes before the pandemic shutdown. Did a few 10k and 5K, and trail runs too. But since pandemic and reopen, I did not do as well as I thought and hoped. Due to various reasons. This year I did two half marathon: the Creve Coeur (near CC lake and the bridge to St. Charles Katy trail and back), and the St. Charles (near research park at Weldon Spring). I finished but the time is not as good as 2020. I also signed one or two races last year and this year, and eventually bailed out at the last minute. Last March (year 2021) was due to the 2nd Covid Vaccine shot, this Oct (2022) I did not do the Inns Brook HM at the last minute as I felt my right leg is not perfect the day before. I do have a few frost bite series paid for but not sure if I will do it this winter eventually.

Back to swimming

At the same time, I decided to go back to swim a bit since Sunday (this past weekend). I used to do it for a few years from 2012 to 2017, at local JCC. My initial reason for running in 2017 was mainly to make sure I don’t gain more weight. From year 2004 I gained quite a bit weight, probably from 135 lbs to 155 lbs. I did quite a bit Tae Kwon Do back in 2002 to 2004 and lost some weight. The tough part is to keep it that way. One good thing about swimming this time: now I have Apple Watch (series 5) and it can track swimming (previously between 2012 to 2017 I didn’t have something like that). The other day I did the steam room, it’s probably the 1st time I went back since pandemic. Once I was interviewing for jobs in Seattle (in early fall / Sept 2014), I decided against it one Saturday morning when I was enjoying the outdoor pool with my family.

Pandemic

Working from home is probably not the best for me as I am not best at disciplined myself in terms of snacking. That’s one reason I decided to go to office, another reason is to be more focused.

iPhone

It seem the screen time for me is just way too much. I am using 2 apps to help me: Off Screen and MiiDii clock. I paid $20 total for both. I like the gentle reminder from Off Screen regarding “don’t use phone when walking”, as well as “pickup challenge” (default limit is 50 times a day). Basically I need to get off WeChat and other frequent used apps.

Categories
iPhone app

Dotnet core

Reading Time: < 1 minuteBuild a CRUD App with ASP.NET Core 2.2 and Entity Framework Core

One advantage I see using dotnet core is for .Net shops the transition is relatively smooth in terms of skill set. Second advantage is it’s cross platform (Windows, Mac and Linux): so in away it’s get the same cross platform capability as Java (Spring etc)

also
.NET for Java developers

Migrate your .NET app to Azure

Categories
iPhone app

Code exercise : linear chamber animation / simulation

Reading Time: < 1 minuteThis is the code that works (my code):

Junit test code is here.

I will add some ReadME as time permits. This is not as straightforward as it sounds. I didn’t get it working initially after spending hours on it 🙁

Categories
iPhone app

h2 database

Reading Time: < 1 minuteH2 Database – Installation

H2 Database – JDBC Connection (the only differs from the docs is we need to add “mem” before the “:~/test”. Otherwise it gives me error.

Mixed mode

Another Java H2 tutorial

Last but not least, how much time should a coding test be? I feel couple hours are probably the way to go (think of Filtered AI, Hacker Rank etc). The other approach is more like open-ended projects: those could take from a few hours to a few days 🙁 In some cases I was suspecting the hiring companies could use this opportunity to get some real work done (if they ask for source code 🙂

Something to keep in mind when doing code test.

Categories
iPhone app

Streaming data, data streaming

Reading Time: < 1 minuteApache flink
SE-Radio Episode 346: Stephan Ewen on Streaming Architecture;
Software Engineering Daily Apache Flink with Stephan Ewen – Nov 2015; Spark and Streaming with Matei Zaharia – Feb 2018

AWS Streaming data

Categories
iPhone app

Database deployment automation

Reading Time: < 1 minuteDB deployment (schema or DDL, package)
Continuous integration and deployment of database is a main issue for many legacy monolithic web app. I came across this article recently, and I think it touched some good points.

On a related matter, Jeff Atwood (cofounder of stack overflow), has a good piece on database version control.

I understand the world is going microservice, and the monolithic relational database is not used as frequently as it’s being used in those legacy web apps. But nonetheless, it helps the dev team to be agile if version control / CI / CD can be applied to database update as well as the application update.

Tracking data changes in DB
This also reminds me of an app I worked in 2010/11, in which we have an DB audit log for many (if not most) database changes: add, update, delete. It’s usually achieved via trigger in Oracle, or interceptor in Java. I read an article from a startup engineering blog (credit karma? Or something like this), they detailed how this is implemented.

Categories
iPhone app

Working from home friendly companies

Reading Time: < 1 minuteOr companies that allows or encourages remoting.

Zapier (Emily Irish) The Remote Work Survival Guide: 9 Do’s & Don’ts Every Remote Worker Needs to Know

stackoverflow remote dev jobs:
e.g., MobyMax: this is very interesting because I learned about Mobymax because my daughter’s school has the subscription.

Top 30 Companies for Work-from-Anywhere Remote Jobs in the U.S.

Work From Home 2018: The Top 100 Companies For Remote Jobs

Last but not least, LinkedIn has the top startup list for 2017 and 2018. Note many startup like people to work onsite for more communication but there are some exceptions (InVision for one).