Books: 22

SQLite

CoverTitleYear
Battle-Tested Strategies for Storing, Managing, and Sharing Android Data “Android™ Database Best Practices goes well beyond API documentation to offer strategic advice about how to handle data in an Android application and the tools needed to develop productively. This arms the developer with a trove more » of solutions to nearly any problem an application may face involving data. Mastering the concepts in this book are therefore essential for any developer who wants to create professional Android applications.” –Greg Milette, Android developer, Gradison Technologies, Inc. This is the first guide to focus on one of the most critical aspects of Android development: how to efficiently store, retrieve, manage, and share information from your app’s internal database. Through real-world code examples, which you can use in your own apps, you’ll learn how to take full advantage of SQLite and the database-related classes on Android. A part of Addison-Wesley’s Android™ Deep Dive series for experienced Android developers, Android Database Best Practices draws on Adam Stroud’s extensive experience leading cutting-edge app projects. Stroud reviews the core database theory and SQL techniques you need to efficiently build, manipulate, and read SQLite databases. He explores SQLite in detail, illuminates Android’s APIs for database interaction, and shares modern best practices for working with databases in the Android environment. Through a complete case study, you’ll learn how to design your data access layer to simplify all facets of data management and avoid unwanted technical debt. You’ll also find detailed solutions for common challenges in building data-enabled Android apps, including issues associated with threading, remote data access, and showing data to users. Extensive, up-to-date sample code is available for download at github.com/android-database-best-practices/device-database. You will * Discover how SQLite database differs from other relational databases * Use SQL DDL to add structure to a database, and use DML to manipulate data * Define and work with SQLite data types * Persist highly structured data for fast, efficient access * Master Android classes for create, read, update, and delete (CRUD) operations and database queries * Share data within or between apps via content providers * Master efficient UI strategies for displaying data, while accounting for threading issues * Use Android’s Intents API to pass data between activities when starting a new activity or service * Achieve two-way communication between apps and remote web APIs * Manage the complexities of app-to-server communication, and avoid common problems * Use Android’s new Data Binding API to write less code and improve performance « less
2016
Exploring the iOS SDK
Assuming little or no working knowledge of the Swift programming language, and written in a friendly, easy-to-follow style, this book offers a comprehensive course in iPhone and iPad programming. The book starts with the basics, walking through the process of downloading and installing Xcode and the more » iOS 10 SDK, and then guides you though the creation of your first simple application. In this third edition of the best selling book, you’ll learn how to integrate all the interface elements iOS users have come to know and love, such as buttons, switches, pickers, toolbars, and sliders. You’ll master a variety of design patterns, from the simplest single view to complex hierarchical drill-downs. The art of table building will be demystified, and you’ll learn how to save your data using the iOS file system. You’ll also learn how to save and retrieve your data using a variety of persistence techniques, including Core Data and SQLite. And there’s much more! Beginning iPhone Development with Swift 3 covers brand-new technologies, as well as significant updates to existing tools. You'll have everything you need to create your very own apps for the latest iOS devices. Every single sample app in the book has been rebuilt from scratch using the latest Xcode and the latest iOS 10-specific project templates, and designed to take advantage of the latest Xcode features. Everything you need to know to develop your own bestselling iPhone and iPad apps Utilizing Swift playgrounds Best practices for optimizing your code and delivering great user experiences - What data persistence is, and why it’s important - Get started with building cool, crisp user interfaces - How to display data in Table Views - How to draw to the screen using Core Graphics - How to use iOS sensor capabilities to map your world - How to get your app to work with iCloud and more Who This Book is For: Anyone who wants to start developing for iPhone and iPad. « less
2016
This book leads you through the essential concepts and new iOS 10 SDK and Swift 3 programming language APIs to build iPhone and iPad database driven applications using the defacto standard for data storage for mobile apps, SQLite. Readers will learn about SQL operations like selecting, inserting, more » updating and deleting data using various data types like text, numerical types, images and even audio/video data. After working through this book, you will gain an expert view of developing iOS apps using SQlite as a data storage using Objective-C and Swift. WithBuild iOS Database Apps with Swift and SQLiteyou will also gain expert knowledge on how to create databases at runtime, including creating or modifying indexes, triggers, tables, columns, and views. The examples use time-tested code from working applications. What You'll Learn: * How to create database and database applications using iOS and Swift * How to insert, select, edit, and delete records * How to extend SQLite * How to work with multi-database apps * How to use SQLite with Swift * How to backup online SQLite Databases and more Who This Book Is For: Experienced Apple iOS, Swift programmers and developers. « less
2016
Leverage the power of Xamarin to create stunning cross-platform and native apps
KEY FEATURES * Helps you get a clear practical understanding of creating professional-grade apps with Xamarin * Covers Xamarin.Forms, Xamarin Android, and Xamarin iOS * If you want to transform yourself from an amateur mobile developer into a professional app developer across multiple platforms, more » then this is the ideal book for you BOOK DESCRIPTION Do you want to create powerful, efficient, and independent apps from scratch that will leverage the Xamarin framework and code with C#? Well, look no further; you’ve come to the right place! This is a learn-as-you-build practical guide to building eight full-fledged applications using Xamarin.Forms, Xamarin Android, and Xamarin iOS. Each chapter includes a project, takes you through the process of building applications (such as a gallery Application, a text-to-speech service app, a GPS locator app, and a stock market app), and will show you how to deploy the application’s source code to a Google Cloud Source Repository. Other practical projects include a chat and a media-editing app, as well as other examples fit to adorn any developer’s utility belt. In the course of building applications, this book will teach you how to design and prototype professional-grade applications implementing performance and security considerations. WHAT YOU WILL LEARN * Discover eight different ways to create your own Xamarin applications * Improve app performance by using SQLite for data-intensive applications * Set up a simple web service to feed JSON data into mobile applications * Store files locally with Xamarin.Forms using dependency services * Use Xamarin extension libraries to create effective applications with less coding ABOUT THE AUTHOR Michael Williams is an Insightful, results-driven full stack developer with notable experience in cross-platform development using Xamarin and native languages for multiple platforms. He also builds and researches server-side architecture using CQRS and event-sourcing. He shares his knowledge on his personal blog at (www.imobservable.com). Also an entrepreneur, the owner of Flush Arcade, a company involved in developing creative, innovative, and ideative games (www.flusharcade.com). TABLE OF CONTENTS 1. Building a Gallery Application 2. Building a SpeechTalk Application 3. Building a GPS Locator Application 4. Building an Audio Player Application 5. Building a Stocklist Application 6. Building a Chat Application 7. Building a File Storage Application 8. Building a Camera Application « less
2016
Develop Android applications with one of the most widely used database engines, SQLite
ABOUT THIS BOOK * Develop database-driven Android applications and stay ahead of the curve * Explore the best techniques to use cursors and loaders to achieve optimum results * A step-by-step approach to use SQLite for building Android applications WHO THIS BOOK IS FOR This is an ideal book for more » Android programmers who want to explore SQLite databases based on Android applications. The general competency level expected of the reader is prior knowledge of developing applications and basic knowledge of Android and SQL. WHAT YOU WILL LEARN * Design and develop an Android SQLite database architecture * Learn the basic principles of a database and include them in your applications * Get familiar with Android support classes with examples highlighting their uses * Create cutting-edge, database-driven applications in no time * Use SQLiteOpenHelper and SQLiteDatabase methods with Android views * Make use of ContentProvider to share your data * Use Loaders and SimpleCursorAdapter in your applications IN DETAIL SQLite is an open source relational database management system. Android uses the SQLite database to store and retrieve data persistently. The driving force behind the platform is the database, enabling a myriad of choices for developers making cutting-edge applications. Android SQLite Essentials focuses on the core concepts behind building database-driven applications. This book covers the basic and advanced topics with equivalent simplicity and detail, in order to enable readers to quickly grasp and implement the concepts to build an application database. This book takes a hands-on, example-based approach to help readers understand the core topics of SQLite and Android database-driven applications. This book focuses on providing you with latent as well as widespread knowledge about practices and approaches towards development in an easily understandable manner. « less
2014
Exploit the power of data-centric and data-driven Android applications with this practical tutorial
Master the skills to build data-centric Android applications Go beyond just code by challenging yourself to think about practical use-cases with SQLite and others Focus on flushing out high level design concepts, before drilling down into different code examples In Detail We live in an increasingly more » data-centric and data-driven world. On top of that we live in a very mobile-centric world with the rise of Android smart phones and tablet devices and the surge in demand for the Android platform. Along with the demand for more data, there is a demand for efficient, "snappy" applications, and so developers need to have a strong understanding of when different data storage methods are appropriate and when they are not. Mastering how to use these two fields to successfully create a powerful application will help you boost your knowledge and skills in this area. "Android Database Programming" is designed to help developers create and design data-centric mobile applications on Google's Android platform. As the world goes increasingly mobile and as consumers' demand for data-centric applications rises, knowing how to combine the two effectively will become an increasingly important asset to have as a developer. The book starts by looking at the various local data storage methods on Android, and finishes off by examining external databases and ways you can utilize them from within an Android application. This book starts by looking at local data storage methods, focusing on writing SQLite databases for your application and also looking at ways to bind these databases to the user interface. The book, through its practical approach, strives to teach you by examples. Each chapter focuses on flushing out high level design concepts, before drilling down into different code examples. As you continue you will look at external databases « less
2012
Small. Fast. Reliable. Choose Any Three.
You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly more » into your application. With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. Using SQLite guides you every step of the way. « less
2010
Master the Android mobile development platform Build compelling Java-based mobile applications using the Android SDK and the Eclipse open-source software development platform. Android: A Programmer's Guide shows you, step-by-step, how to download and set up all of the necessary tools, build and tune more » dynamic Android programs, and debug your results. Discover how to provide web and chat functions, interact with the phone dialer and GPS devices, and access the latest Google services. You'll also learn how to create custom Content Providers and database-enable your applications using SQLite. * Install and configure Java, Eclipse, and Android plugin * Create Android projects from the Eclipse UI or command line * Integrate web content, images, galleries, and sounds * Deploy menus, progress bars, and auto-complete functions * Trigger actions using Android Intents, Filters, and Receivers * Implement GPS, Google Maps, Google Earth, and GTalk * Build interactive SQLite databases, calendars, and notepads * Test applications using the Android Emulator and Debug Bridge « less
2008
Covers PHP 5.3
Essential Skills--Made Easy! Learn how to build dynamic, data-driven Web applications using PHP. Covering the latest release of this cross-platform, open-source scripting language, PHP: A Beginner's Guide teaches you how to write basic PHP programs and enhance them with more advanced features such more » as MySQL and SQLite database integration, XML input, and third-party extensions. This fast-paced tutorial provides one-stop coverage of software installation, language syntax and data structures, flow control routines, built-in functions, and best practices. Designed for Easy Learning: * Key Skills & Concepts--Lists of specific skills covered in the chapter * Ask the Expert--Q&A sections filled with bonus information and helpful tips * Try This--Hands-on exercises that show how to apply your skills * Notes--Extra information related to the topic being covered * Tips--Helpful reminders or alternate ways of doing things * Cautions--Errors and pitfalls to avoid * Self-Tests--Chapter-ending quizzes to test your knowledge * Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated « less
2008
Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and more » can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management. « less
2006