The total amount of Objective-C code responsible for doing the work? About 25 lines. OSQL in 25 lines of codeĪs an example of how to use the API, I put together a very simple app that allowed the user to enter one or more SQL statements, and displayed the results in a rather primitively formatted text field. This client library handles all the network communication, and provides a clean API. However, rather than writing a web service for every app that needs data access, we made the web service generic, serving only as a proxy between the SQL Server and a client library integrated into the iPhone or iPad app. It turns out a web service remained a sensible idea: HTTP is much more suited to the Big Bad Internet than SQL Server’s native TDS protocol, removing the need for complex configuration, firewall configuration, and the like. And so the iSql SDK was born: sitting between SQL Server and your iOS apps, it provides the simple API you’re used to if you’ve been developing desktop apps using the Microsoft SQL Native Client. Working along the lines of “if you do something more than once, make it shared,” we set about coming up with a better solution for the general case. Desktop applications interact with the SQL Server directly – why should mobile apps be any different? The better answer: the iSql SDK But what does this process gain?įor a well-designed database with a solid security model, and business logic in the database, writing a custom web service on top of this just to access some of the data from a different platform seems inefficient and unnecessary. Look at any of the questions on this topic asked in Internet discussion forums, and you’ll inevitably see the answer, “just write a web service and use that!”. With a huge amount of existing business data residing in Microsoft SQL Server databases, and an ever-increasing drive to make more and more available to mobile users, how do you marry the rather separate worlds of Microsoft’s SQL Server and Apple’s iOS devices? The classic answer: write a web service layer The interface is cleverly designed to resemble its hand held ancestor, letting you quickly accommodate, with the possibility to export results to easily include in other projects or process later on.Accessing SQL Server data from iOS apps - Simple Talk Skip to contentĪlmost all mobile apps need access to external data to be valuable. To sum it up, Free42 is one of the tools you need to keep around if your computer work implies complex calculus and precision. Amongst basic calculus, the application is capable of processing, sin, cos, tan, matrix, conversions, sums and a lot more. In case you've never got the pleasure of putting a HP-42S calculator to good use, this is your chance to meet a virtual one. Capable of processing complex expressions You can choose to keep the application on top of every other window, which comes in handy when frequently using it along with other development tools. What's more, it's also possible to get ahold of a GIF file with the same info, as well as to simply copy values and quickly have them inserted where needed. In other words, export options enable you to save expressions for later importing and processing, as well as an options to automatically have a log of operations saved to a text file under a custom name and path. Several export optionsīesides only displaying several digits influenced by the function buttons you combine, the application also gives you the possibility to put the result to good use. Another element of surprise is that there are two calculators, one decimal and one binary. What's more, there's even an implemented skin which fully resembles the HP-42S.Ī neat advantage is that you can take the application everywhere you go, since it does not require an installation process. Includes a binary and decimal calculatorīased on the powerful HP-42S RPN scientific hand held calculator, the application does a pretty good job at replicating all of its functions, thus making it available on your desktop. When it comes to computing speed, utilities like Free42 save you the time needed to calculate complex math expressions, with export options to aid you in your work. With computers nowadays being suitable testing grounds and development environments for every major project, specialized applications are more and more user friendly to enhance efficiency.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |