Titlebook: Build iOS Database Apps with Swift and SQLite; Kevin Languedoc Book 2016 Kevin Languedoc 2016 iOS.Swift.database.build.apps.programming

細(xì)查

ostensible

Inserting Records,The SQL . statement in SQLite has some interesting features, such as being able to replace an existing record, just like the . statement in Oracle’s PL/SQL. The expression parameter can either be a literal or the return value from a function. We will explore these interesting features together.

流逝

調(diào)色板

輕彈

Deleting Records,In this chapter, we will discuss the . function in SQLite. In contrast to the other CRUD functions in SQLite, the . function API is the same as in other platforms and implements the basic SQL API, except for the . clause, which allows a developer to set a limit on the number of rows to delete.

弄皺

Searching for Records in SQLite,This chapter doesn’t show any new SQLite APIs. Rather, it focuses on how you can use the SQLite APIs to create an iOS iPhone app for searching for records in a SQLite database.

commensurate

Working with Multiple Databases,SQLite has a great feature for managing large volumes of data: multi-database apps. In this chapter, you‘ll see that by creating and attaching multiple databases to the same connection you can improve disk I/O performance and reliability.

Wernickes-area

真繁榮

Analyzing SQLite Databases,This last chapter will focus on the different tools the SQLite platform provides to help you analyze your app‘s databases. Except for the . statement, which can be executed with the . command, the other tools are external software programs. Specifically, in this chapter we will discuss and explore, through examples, the following technologies

babble