Tag - Database
This may be a first for us: we're examining a new software release in not one, but two separate reviews. It's not because this is going too long, either. It's because this software is FileMaker Pro 15 and it's less an app, more a whole world. If you are an existing user, then you probably love it -- but you also know that any upgrade has to earn its keep, so you'll be looking for details of what's new. Yet if you've never touched it before, the differences between this and the previous version 14 won't really tell you whether it's worth your time and money. So do this for us, please: if you have never tried FileMaker Pro, carry on reading this; if you're an old hand, read the other review -- that one's for you.
We used to think it was an Excel thing that other people would forget it was a spreadsheet and instead use it as a kind of rudimentary database where they listed text in the columns instead of numbers. Now we have to face the fact that it isn't other people who do this, it's us –– and we're doing it all over again in Apple's Numbers. We know we're wasting its strengths, we know, but it's handy and there is a way to both speed it up and to make us feel like we're fine not going off to create databases all the time. You can use popup forms in Numbers.
Like every app covered in Developer Insight so far, FileMaker Pro is deeply popular and a very longstanding success -- but in every other way, it is completely different. Most apps are bought by people who need them to do a certain job, but if you buy FileMaker Pro, you're actually buying it in order to then create your own solution to a job or a problem. It is a development tool just as much as it is a consumer one, and that has advantages and disadvantages -- but it also attracts a gigantic degree of loyalty from its users.
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.
Now AAPL Stock: 143.79 ( + 0.11 )
Cirrus creates Lightning-headphone dev kit
Apple supplier Cirrus Logic has introduced a MFi-compliant new development kit for companies interested in using Cirrus' chips to create Lightning-based headphones, which -- regardless of whether rumors about Apple dropping the analog headphone jack in its iPhone this fall -- can offer advantages to music-loving iOS device users. The kit mentions some of the advantages of an all-digital headset or headphone connector, including higher-bitrate support, a more customizable experience, and support for power and data transfer into headphone hardware. Several companies already make Lightning headphones, and Apple has supported the concept since June 2014. http://bit.ly/29giiZj
Apple Store app offers Procreate Pocket
The Apple Store app for iPhone, which periodically rewards users with free app gifts, is now offering the iPhone "Pocket" version of drawing app Procreate for those who have the free Apple Store app until July 28. Users who have redeemed the offer by navigating to the "Stores" tab of the app and swiping past the "iPhone Upgrade Program" banner to the "Procreate" banner have noted that only the limited Pocket (iPhone) version of the app is available free, even if the Apple Store app is installed and the offer redeemed on an iPad. The Pocket version currently sells for $3 on the iOS App Store. [32.4MB]
Porsche adds CarPlay to 2017 Panamera
Porsche has added a fifth model of vehicle to its CarPlay-supported lineup, announcing that the 2017 Panamera -- which will arrive in the US in January -- will include Apple's infotainment technology, and be seen on a giant 12.3-inch touchscreen as part of an all-new Porsche Communication Management system. The luxury sedan starts at $99,900 for the 4S model, and scales up to the Panamera Turbo, which sells for $146,900. Other vehicles that currently support CarPlay include the 2016 911 and the 2017 models of Macan, 718 Boxster, and 718 Cayman. The company did not mention support for Google's corresponding Android Auto in its announcement. http://bit.ly/295ZQ94
Apple employees testing wheelchair features
New features included in the forthcoming watchOS 3 are being tested by Apple retail store employees, including a new activity-tracking feature that has been designed with wheelchair users in mind. The move is slightly unusual in that, while retail employees have previously been used to test pre-release versions of OS X and iOS, this marks the first time they've been included in the otherwise developer-only watchOS betas. The company is said to have gone to great lengths to modify the activity tracker for wheelchair users, including changing the "time to stand" notification to "time to roll" and including two wheelchair-centric workout apps. http://bit.ly/2955JDa
SanDisk reveals two 256GB microSDXC cards
SanDisk has introduced two 256GB microSDXC cards. Arriving in August for $150, the Ultra microSDXC UHS-I Premium Edition card offers transfer speeds of up to 95MB/s for reading data. The Extreme microSDXC UHS-I card can read at a fast 100MB/s and write at up to 90MB/s, and will be shipping sometime in the fourth quarter for $200. http://bit.ly/294Q1If
Apple's third-quarter results due July 26
Apple has advised it will be issuing its third-quarter results on July 26, with a conference call to answer investor and analyst queries about the earnings set to take place later that day. The stream of the call will go live at 2pm PT (5pm ET) via Apple's investor site, with the results themselves expected to be released roughly 30 minutes before the call commences. Apple's guidance for the quarter put revenue at between $41 billion and $43 billion. http://apple.co/1oi1Pbm
Twitter stickers slowly roll out to users
Twitter has introduced "stickers," allowing users to add extra graphical elements to their photos before uploading them to the micro-blogging service. A library of hundreds of accessories, props, and emoji will be available to use as stickers, which can be resized, rotated, and placed anywhere on the photograph. Images with stickers will also become searchable with viewers able to select a sticker to see how others use the same graphic in their own posts. Twitter advises stickers will be rolling out to users over the next few weeks, and will work on both the mobile apps and through the browser. http://bit.ly/29bbwUE