Copyright © 2015
Tag - Database
On Friday, Apple notified developers that it was expanding a feature of CloudKit to allow for server-to-server web service requests. "In addition to providing a web interface for users to access the same data as your app, you can now easily read and write to the CloudKit public database from a server-side process or script with a server-to-server key," Apple said in its announcement. Previously, interaction with the CloudKit public database was limited to apps and web only.https://developer.apple.com/news/?id=02042016a
It all sounded so easy one week ago when we revealed that we were going to make a Job Book database in FileMaker Pro and for the most part, it has been very easy. We took a deep dive into fields on Wednesday which meant absorbing terms that might be new and using database calculations that –– to us anyway –– felt like Sudoku puzzles to be solved. Otherwise, though, it was a pretty smooth ride from idea to final working database. That's the key thing here: the database is working. It's a real database that we truly are using every day and as we keep saying, the way to learn something is to have a real project to do.
There is one thing we haven't mentioned in this entire project: we're here to make a Job Book database that records our commissions, but it is only useful if we can actually use it. All the planning we did, and then all of yesterday's detail work about fields and records -- what we want to note about the work we do -- is for nothing if we don't use the database. Full disclosure: sometimes we haven't. So, in this chapter, we're making the database not just usable, but pleasant to use, reducing the excuses to not use it.
Previously on this MacNN project, we realized we had a problem, and that a database would be the solution. To our mind, that means a FileMaker Pro solution. It means FileMaker in part because we've used that application in one-man companies and international media ones; it also means that because we've learned how flexible it is.
First, we realized we needed a database. Then, it took about a picosecond to realize that what we need is FileMaker Pro 14. This is a tool for making databases, from simple ones like ours up on to the tools that international corporations use. Whether you're a corporate level user or starting out, though, the steps involved in creating and using a new database are the same -- they're the steps and considerations we're using in this project to build a Job Book database.
We're building a Job Book in FileMaker Pro: a database that we are genuinely using in freelance work to log and do some basic tracking of the commissions we get. Last week we explained what this was about, and why we know it's the way to take a productive deep dive into the very powerful database app. Today we're doing something that might not sound right: we're leaving FileMaker Pro.
It says a lot about the old Bento personal database app for OS X that people still refer to new, comparatively basic databases as being Bento-like or Bento-style. If only as many people used it as talked about, we might still have that software around, and there'd be little place for alternatives. However, Bento is gone, and for some users, Steward 1.0 is going to be a viable alternative.
We have written previously in our Pointers column, about Smart Things in OS X -- by which we mean Smart Folders (usually found in the Finder), Smart Albums (found mostly in iPhoto or Photos, and other photo-oriented programs), and Smart Playlists (commonly seen in iTunes). We forgot to mention another one -- Smart Groups in Contacts (formerly Address Book), but then it's good to understand Groups first, so here we go.
Here's the thing. FileMaker Pro is a quietly spectacular app: it's for creating databases but for three decades now it has also created careers. There are people whose entire working lives have been devoted to creating databases in FileMaker Pro and they do it for lone freelancers, corner shop businesses and even corporations. Now a new FileMaker Pro 14 has been released for the app's 30th anniversary and, with one caveat, it is hugely recommended. Check our full review to see what we liked, and what we didn't.
In parallel with the Apple spin-off's 30th anniversary of its flagship product, FileMaker on Tuesday announced Filemaker 14, its flagship database program for OS X, Windows, and iOS. New features in the update include a new Script Workspace to speed up common business processes, and also includes a redesigned WebDirect optimization for tablet browsers, a Launch Center for more app-like visual icons for FM-based programs, an enhanced iOS experience, and general speed and interface enhancements.
Now AAPL Stock: 94.87 ( + 0.85 )
Apple Music in Taiwan, now up to 113 countries
Apple Music has now added its 113th country, Taiwan, to its expanding list of areas where it offers its paid subscription service. The price in the country will start at NT$150 (about $4.50 US) for an individual subscription, and that now includes (as it does in the rest of the world) the formerly free-but-ad-supported iTunes Radio feature, which as in other countries will be customized somewhat to offer channels of locally-popular music styles. Apple Music is now available in 16 countries and regions -- including China, India, Russia, and Japan -- where Spotify has not yet arrived.
Invisible wall mount for iPad Pro, mini
Computing hardware mounting company Wall-Smart has announced the availability the new "invisible" wall mount, with models for the iPad Pro, iPad Air 2 and iPad mini 4 -- all with no bezel. The invisible mount includes Power Over Ethernet to USB, which allows charging while in-wall, and is available for both drywall and solid surfaces such as solid wood panels or partition walls. Prices vary widely by iPad model, and required mounting hardware. http://bit.ly/1SE5jCO
Kingston buys IronKey secure USB tech
Kingston Digital today announced it has acquired the USB technology and assets of IronKey from Imation. In addition to Kingston's acquisition, encryption services leader DataLocker has purchased the IronKey Enterprise Management Services platform which provides centralized management to encrypted USB drives. Kingston and DataLocker claim that there will be no interruption in service provided, or available products as a result of the consolidations. http://bit.ly/1QQk9SZ
View-Master VR device in Apple Store
Apple has started to sell a Google Cardboard-style VR headset modeled on a classic Mattel toy. Initially launched early last year, the View-Master Virtual Reality Starter Pack for $30 is designed to use an iPhone as a display, with a Preview Reel and lever system mimicking the toy's switching between images to take users between different VR apps and scenes. http://bit.ly/1RhJW8y
Apple brings iTunes Movie Trailers app to Canada
After five years, Apple has expanded its iTunes Movie Trailers app for iOS to Canada. As of Saturday, the free app allows movie buffs to see HD movie trailers for new studio and independent features, and explore some other movie-related extras such as photos, behind-the-scenes footage, or clips from upcoming films. Users can save trailers for quick access, read reviews from RottenTomatoes.com within the app, use AirPlay to send them to an Apple TV, share trailers, and peruse the top movie charts. http://apple.co/1UUKtwr
Apple expands CloudKit API, provides web interface
On Friday, Apple notified developers that it was expanding a feature of CloudKit to allow for server-to-server web service requests. "In addition to providing a web interface for users to access the same data as your app, you can now easily read and write to the CloudKit public database from a server-side process or script with a server-to-server key," Apple said in its announcement. Previously, interaction with the CloudKit public database was limited to apps and web only. http://apple.co/20h1RwP
Remote S for Tesla Apple Watch app drives car out
Developer Allen Wong has created the Remote S for Tesla app, which can be used to remotely activate the Model S electric car via an Apple Watch, and drive it a short distance. Aside from providing data about the car and some basic function controls, the unofficial app uses the manufacturer's Summon command to allow the car to turn on, exit the garage, and park near to the user's location. The app is available to purchase from the App Store for $10. http://apple.co/1PprF4t