0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Learning SQLite for iOS

You're reading from Learning SQLite for iOS Extend SQLite with mobile development skills to build great apps for iOS devices

Product type Paperback

Published in Mar 2016

Publisher

ISBN-13 9781785288975

Length 154 pages

Edition 1st Edition

Languages

Objective-C

Tools

iOS

Concepts

iOS Development

Author (1):

Gene Da Rocha

View More author details

Table of Contents (10) Chapters

Preface

1. Introduction to SQL and SQLite FREE CHAPTER

2. Database Design Concepts

3. Administering the Database

4. Essentials of SQL

5. Exposing the C API

6. Using Swift with iOS and SQLite

7. iOS Development with PhoneGap and HTML5

8. More Features and Advances in SQLite

Index

About SQL

In June 1970, a research paper was published by Dr. E.F. Codd called A Relational Model of Data for Large Shared Data Banks. The Association of Computer Machinery (ACM) accepted Codd's data and technology model, which has become the standard of the RDBMS today. IBM Corporation had invented the language called Structured English Query Language (SEQUEL), where the word "English" was dropped to become SQL.

SQL has become the standard for the RDMS, which is used by databases such as Oracle, Sybase, and Microsoft's SQL Server.

Today, there are American National Standards Institute (ANSI) standards for SQL, and there are many variations of this technology. Among the mentioned manufacturers, there are also others available in the open source world, for example, an SQL query engine, such as Presto.

Presto is the distribution engine for SQL under open source, which is made to execute interactive analytic queries. Presto queries are run under databases from a variety of data source sizes—gigabytes to petabytes.

Companies such as Facebook and Dropbox use the Presto SQL engine for their queries and analytics in data warehouse and related applications.

SQL is made up of data manipulation and definition language built with tuple and algebra calculation in a relational format. This language has a variety of statements but most would recognize the INSERT, SELECT, UPDATE, and DELETE statements. These statements form a part of the database schema management process and aid the data and security accesses. SQL includes procedural elements as a part of its setup.

You have been reading a chapter from

Learning SQLite for iOS

Published in: Mar 2016

Publisher:

ISBN-13: 9781785288975

© 2016 Packt Publishing Limited All Rights Reserved

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Gene Da Rocha

Gene Da Rocha

Please write your Author Biography here using the following guidelines. Please save this file as ISBN_Author Bio_Author Name. The author bio should be written in the third person. For convenience, you can structure the bio along the following lines: 1. Description of yourself, your background and your experience. Gene Da Rocha is a successful Senior Test Consultant with Testing, SQL, DevOps, App Support and Project Management experience and has worked within a full software development lifecycle, including mobile and web technologies. He has been educated on three continents like Africa, India and Europe (UK) and has over twenty-five years of IT experience. Gene just learned and mastered technology over the years, but decided to pursue getting a degree. A few years ago he finished a BSc (Hons) in Computer Science and now an MSc in Computer Science with Mobile Technology at the University of Hertfordshire, UK. Gene has been in charge of a variety of IT Projects for different businesses and has led them to a successful conclusion. Gene also has: Strong analytical skills; Ability to coordinate and interact effectively with in-house and 3rd party resources. Gene has worked within a complex environment between multiple business teams and systems. He has designed mobile systems using his programming background with architectural skills, coupled with the innovation and the need to success and deliver requirements to clients. Gene effectively utilises his strong client facing skills, wide range of IT experience, architect qualities and project management experience to improve the organisations' business operations. Recently Testing has included regression, functional, system testing, integration and CI (continuous integration). 2. Some mention of your employers, or your own company, if relevant or you want to. (You don't have to and sometimes people can't mention their employers for contractual reasons). Gene in his long career has worked for a variety of companies in different industries like Barclays Bank, Reuters, Deutche Bank, Paribas Bank on a variety of projects and assignments. He has also worked for the Association for Project Management, QAWorks and more recently DigitasLBI among many others. 3. Other books you may have worked on. This is my first Book and it is aimed for the Computing Industry. It is aimed at introducing new people to IOS and Swift or existing computing professionals to get an idea or information to learning SQLite with IOS. 4. Acknowledgements - people you'd like to thank for their help in producing this book, (friends, family, etc) - this part is written in the first person. I would especially like to thank my family, especially my wife who have put up with my loss of family time researching the subject matter, writing and collating it with the publisher PactIT. It has been difficult especially after completing a BSc, MSc and now an IT book. So thanks for the kind patience in this project, that I wanted to do for sometime.

See other products by Gene Da Rocha