This week's sponsor

SaneBox

Clean Up Your Inbox Today (and Keep It That Way Forever)


Posts in news


SQLPro Studio: A Cross DB Management Tool for macOS [Sponsor]

Do you work on a Mac, but need to interface with Enterprise Databases such as Oracle or Microsoft SQL server? Are you tired of firing up a Windows virtual machine just to run a query? Have you ever wished for a native Mac client? SQLPro Studio is the answer you've been looking for.

SQLPro Studio is a native Mac application that works with MSSQL server (both on premise and in Azure), Oracle, MySQL, PostreSQL and SQLite. The interface is fast and responsive, just like you'd expect from a native Mac app. It should go without saying, but SQLPro Studio can connect to databases hosted on Windows, Mac or Linux operating systems and supports either direct connection, or tunneling over SSH.

Write and execute queries in the tabbed query interface, SQLPro Studio supports all the features you'd expect: drag and drop fields from the SQL browser on the left to the SQL editor, auto complete SQL statements including table and field names, even reformat your SQL code to make it 'pretty.'

You can easily export results as CSV, JSON or XML, and you can edit your results inline so long as you have a primary key on the table.

SQLPro Studio is your all in one solution for managing databases of all kinds, natively, from your Mac!

SQLPro Studio - macOS database management UI is available for $109.99, but MacStories readers can get 20% off by using the promo code MACSTORIES.

SQLPro Studio Studio is also available on the Mac App Store.


Apple Clarifies That Affiliate Program Changes Affect In-App Purchases Only

On April 24th, Apple sent an email to participants in the iTunes Affiliate Program that said:

Starting on May 1st 2017, commissions for all app and in-app content will be reduced from 7% to 2.5% globally. All other content types (music, movies, books, and TV) will remain at the current 7% commission rate in all markets. We will also continue to pay affiliate commissions on Apple Music memberships so there are many ways to earn commissions with the program.

The drastic cut in the rate on apps and In-App-Purchases and the short notice took participants in the program by surprise.

The May 1st deadline came and went seemingly without any change to the payout rate on apps. Apple has since posted a clarification to the iTunes Affiliate Resources website that says:

We’d like to clarify some changes being made to the Affiliate Program. Commissions for all iOS in-app purchases will be reduced from 7% to 2.5% globally, and all other content types (including music, movies, books, paid iOS apps and TV) will remain at the current 7%.

Anecdotal evidence since May 1st supports the clarification that the change to affiliate commissions affects In-App Purchases only. Links to apps and other content sold by Apple will continue to earn 7%, which is welcome news for websites and developers who rely on that revenue.


iTunes Connect’s App Analytics Adds Source and Referrer Data

Two years ago, Apple rolled out App Analytics on its iTunes Connect developer portal. Originally announced at WWDC in 2014, App Analytics gave developers a better understanding of how and when their apps were used, how many views their app’s page on the App Store received, and more. However, the original version of App Analytics did not report how customers got to the App Store.

Yesterday Apple announced an expansion to App Analytics that adds source and referral data. According to Apple’s developer news website:

App Analytics in iTunes Connect now provides insight on where customers discover your app, including App Store browsing and search, within other apps, or on the web. With key metrics based on source types, you can see your top referring apps and websites, making it easier to optimize your marketing campaigns.

Apple’s App Analytics page elaborates:

With App Analytics, you can see how many users discover your app while searching or browsing the App Store — including tapping on Search Ads for your app — to gain insight into how your marketing and metadata impact downloads.

App Analytics counts users who visit your app’s product page from a link within another app.

Blogs, websites, and other online sources that link to your app’s product page, are critical in driving user acquisition through word-of-mouth marketing and PR. With App Analytics, you can see which organic marketing channels drive the highest traffic, downloads, usage, and revenue for your app.

There is a lot of interesting new data for developers to digest in App Analytics that should help them market their apps more effectively. I particularly appreciate the ability to drill down into any source of App Store traffic to see how it has performed over time and from which countries those customers are coming.


Apple Q2 2017 Results: $52.9 Billion Revenue, 50.8 Million iPhones, 8.9 Million iPads Sold

Apple has just published its financial results for Q2 2017, which covered the period from January 1, 2017 through to April 1, 2017. The company posted revenue of $52.9 billion with a quarterly net profit of $11 billion. Apple sold 8.9 million iPads, 50.8 million iPhones, and 4.2 million Macs during the quarter.

“We are proud to report a strong March quarter, with revenue growth accelerating from the December quarter and continued robust demand for iPhone 7 Plus,” said Tim Cook, Apple’s CEO. “We’ve seen great customer response to both models of the new iPhone 7 (PRODUCT)RED Special Edition and we’re thrilled with the strong momentum of our Services business, with our highest revenue ever for a 13-week quarter. Looking ahead, we are excited to welcome attendees from around the world to our annual Worldwide Developers Conference next month in San Jose.”

Read more


Doo Adds Task Collaboration, Checklists in Version 2.0

When I wrote about Doo over a year ago, I called its methodology “daring and bold,” a sentiment expressed primarily due to its sparse interface and few features. Although I found its straightforwardness endearing, those looking for a more robust task manager were likely sent packing.

In version 2.0, though, Doo maintains its simplicity while growing into a more powerful productivity tool. The inclusion of task collaboration and checklists specifically makes the update a win, and the additions continue to be hits down the line: location reminders, morning and evening hours, and interface customization with font sizes.

The changes in Doo are well-integrated, too – while some apps might tack them on and make them seem out of place, Doo integrates them directly into the existing UI elements. Basically, you won’t have any problems finding or ignoring the new features, depending on what you’re looking to do.

Practically, using Doo's new tools can make a big difference in your workflow. For example, a task in Doo can now be broader, with more intricate steps listed in the checklists. With Task collaboration, store trips or packing for vacation can now be a shared breeze.

Both Doo for iPhone and Mac received the update, so owners of each should make sure to update to see the latest the Ciarlo Software team has to offer. And if you haven’t picked up Doo yet, check out my review posted above and download the app for iPhone here ($3.99) and Mac here ($9.99).


App Camp for Girls is Coming to Chicago

App Camp for Girls is making a big jump geographically this summer. The camp for middle schoolers who self-identify as female, trans (regardless of identity), or gender non-conforming, was founded in 2013 by Jean MacDonald and Grey Osten in Portland, Oregon to address the gender imbalance in technology professions. Since then, App Camp has started camps in other cities including Seattle and Phoenix, but the debut of a camp in Chicago, Illinois this summer marks the first time a camp has been held east of the Mississippi River.

Read more


Latest iWork Updates Bring Back Previously-Removed Numbers Features

Apple released updates to its iWork suite across iOS and macOS today. The changes largely consist of bug fixes and stability improvements, but a couple of notable improvements were made to Numbers.

In the last big update for Numbers, a new cell action menu was added to handle common tasks like copying/pasting, adding formulas, and more. But with the arrival of this cell menu, a couple subtractions were also made: the numeric keyboard on iPad was removed, along with the copy/paste menu that would appear when you selected a cell. Federico covered the details of those changes in his recent iPad Diaries story on Numbers. But with today's update, both of those items have now been restored to the app.

In the past when Apple has removed features from an app, those features often would never come back, or if they did it took a while. I'm thankful that Numbers users don't have to wait any longer to work in the app the way they're used to.