A preliminary edition of this book was published from O'Reilly (ISBN 9780596550066). SQLite is a small, embeddable, SQL-based, relational database management system. It has been widely used in low- to medium-tier database applications, especially in embedded devices. This book provides a comprehensive description of SQLite database system. It describes design principles, engineering trade-offs, implementation issues, and operations of SQLite.
Author: Ivan Litovski
Publisher: John Wiley & Sons
Release Date: 2010-02-18
This is the definitive guide for Symbian C++ developers looking to use Symbian SQL in applications or system software. Since Symbian SQL and SQLite are relatively new additions to the Symbian platform, Inside Symbian SQL begins with an introduction to database theory and concepts, including a Structured Query Language (SQL) tutorial. Inside Symbian SQL also provides a detailed overview of the Symbian SQL APIs. From the outset, you will “get your hands dirty” writing Symbian SQL code. The book includes snippets and examples that application developers can immediately put to use to get started quickly. For device creators and system software developers, Inside Symbian SQL offers a unique view into the internals of the implementation and a wealth of practical advice on how to make best and most efficient use of the Symbian SQL database. Several case studies are presented – these are success stories 'from the trenches', written by Symbian engineers. Special Features: The book assumes no prior knowledge of databases Includes detailed and approachable explanations of database concepts Easy to follow SQL tutorial with SQLite examples Unique view into the Symbian SQL internals Troubleshooting section with solutions to common problems Written by the Symbian engineers who implemented SQLite on Symbian, with more than 40 years combined Symbian C++ experience, this book is for anyone interested in finding out more about using a database on Symbian.
Author: Grant Allen
Release Date: 2011-01-26
Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite—an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite’s capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!
If you’re an app developer with a solid foundation in Objective-C, this book is an absolute must—chances are very high that your company’s iOS applications are vulnerable to attack. That’s because malicious attackers now use an arsenal of tools to reverse-engineer, trace, and manipulate applications in ways that most programmers aren’t aware of. This guide illustrates several types of iOS attacks, as well as the tools and techniques that hackers use. You’ll learn best practices to help protect your applications, and discover how important it is to understand and strategize like your adversary. Examine subtle vulnerabilities in real-world applications—and avoid the same problems in your apps Learn how attackers infect apps with malware through code injection Discover how attackers defeat iOS keychain and data-protection encryption Use a debugger and custom code injection to manipulate the runtime Objective-C environment Prevent attackers from hijacking SSL sessions and stealing traffic Securely delete files and design your apps to prevent forensic data leakage Avoid debugging abuse, validate the integrity of run-time classes, and make your code harder to trace
This brief book is an introduction to SQLite for both iOS and Android developers. The book includes an optional introduction to SQL, a discussion of when to use SQLite, and chapters devoted to using SQLite with the most likely programming languages and then goes through adding a simple database to an Android or iOS app and finally a chapter on managing the app’s life cycle. What You Will Learn: • The basics of SQLite• The SQL you need to use SQLite effectively• How to integrate a database into your mobile app.• How to maintain the app Who this book is for: This book is for Android or iOS developers who wish to use a lightweight but flexible database for their applications. It mobile development experience but does not assume anything but very basic database knowledge.
This is the first book to devote complete coverage to the most recent release of the popular embedded open source database SQLite. The book acts as both an ideal tutorial and reference guide. It offers experienced database developers a thorough overview of its capabilities and APIs, yet is mindful of newcomers who may be making their first foray into the database environment with SQLite. Readers are presented with introductions to the SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl.
Application developers, take note: databases aren't just for the IS group any more. Whether you're developing applications for the desktop, the Web, embedded systems, or operating systems, the SQLite database provides an alternative to heavy-duty client-server databases such as Oracle and MySQL. With this book, you'll get complete guidance for using this small and lightweight database effectively. You'll learn how to make SQLite an integral part of your application to help contain the size and complexity of your project. And you'll discover how much simpler it is to build database-backed applications with SQLite than the database tools you've been using. Get a crash course in data modeling Learn how to use SQLite with scripting languages such as Perl, Python, and Ruby Become familiar with the subset of SQL supported by SQLite
SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases. In SQLite, author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.
What will you learn from this book? If you have an idea for a killer Android app, this book will help you build your first working application in a jiffy. You’ll learn hands-on how to structure your app, design interfaces, create a database, make your app work on various smartphones and tablets, and much more. It’s like having an experienced Android developer sitting right next to you! All you need is some Java know-how to get started. Why does this book look so different? Based on the latest research in cognitive science and learning theory, Head First Android Development uses a visually rich format to engage your mind, rather than a text-heavy approach that puts you to sleep. Why waste your time struggling with new concepts? This multi-sensory learning experience is designed for the way your brain really works.
This is an ideal book for 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.
Pro Android 2 shows how to build real-world and fun mobile applications using Google's latest Android software development kit. This new edition is updated for Android 2, covering everything from the fundamentals of building applications for embedded devices to advanced concepts such as custom 3D components, OpenGL, and touchscreens including gestures. While other Android development guides simply discuss topics, Pro Android 2 offers the combination of expert insight and real sample applications that work. Discover the design and architecture of the Android SDK through practical examples, and how to build mobile applications using the Android SDK. Explore and use the Android APIs, including those for media and Wi-Fi. Learn about Android 2's integrated local and web search, handwriting gesture UI, Google Translate, and text-to-speech features. Pro Android 2 dives deep, providing you with all the knowledge and techniques you need to build mobile applications ranging from games to Google apps, including add-ons to Google Docs. You'll be able to extend and run the new Google Chrome APIs on the G1, the G2, and other next-generation Google phones and Android-enabled devices.
Author: Michael Burton
Publisher: John Wiley & Sons
Release Date: 2015-02-23
The updated edition of the bestselling guide to Android app development If you have ambitions to build an Android app, this hands-on guide gives you everything you need to dig into the development process and turn your great idea into a reality! In this new edition of Android App Development For Dummies, you'll find easy-to-follow access to the latest programming techniques that take advantage of the new features of the Android operating system. Plus, two programs are provided: a simple program to get you started and an intermediate program that uses more advanced aspects of the Android platform. Android mobile devices currently account for nearly 80% of mobile phone market share worldwide, making it the best platform to reach the widest possible audience. With the help of this friendly guide, developers of all stripes will quickly find out how to install the tools they need, design a good user interface, grasp the design differences between phone and tablet applications, handle user input, avoid common pitfalls, and turn a "meh" app into one that garners applause. Create seriously cool apps for the latest Android smartphones and tablets Adapt your existing apps for use on an Android device Start working with programs and tools to create Android apps Publish your apps to the Google Play Store Whether you're a new or veteran programmer, Android App Development For Dummies will have you up and running with the ins and outs of the Android platform in no time.
Pro Android 3 starts with the basics, giving you a firm foundation in Android development. It then builds on this foundation to teach you how to build real-world and fun mobile applications using the new Android 3.0 SDK. This book covers advanced concepts in detail including maps, geocoding, services, live folders, drag and drop, touchscreens, and the new Android 3.0 features: fragments and ActionBar. Pro Android 3 is uniquely comprehensive: it covers sensors, text to speech, OpenGL, live widgets, search, and the audio and video APIs. Using the code-heavy tutorials and expert advice, you'll quickly be able to build cool mobile apps and run them on dozens of Android-based smartphones. You'll explore and use the Android APIs, including those for media, sensors, and long-running services. And you'll check out what's new with Android 3.0, including the improved UI across all Android platforms, drag and drop, fragment dialogs, and more, giving you the knowledge to create stunning, cutting-edge apps, while keeping you agile enough to respond to changes in the future.