SQLite is a relational database management system,
implemented in a small C library which can be linked directly into programs, and released into the
public domain.
Although SQLite itself is developed in C, it can be used from a wide variety of programming
languages including
C, C++, Delphi, Java,
Perl,
PHP,
Python, R, Smalltalk and Tcl.
Here are some books about SQLite ;
Disclosure: Products details and descriptions provided by Amazon.com. Our company may receive a payment if you purchase products from them after following a link from this website.
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!
What you’ll learn
Deploy SQLite as the database engine for iPhone and Android applications.
Interact with SQLite from Java, C++, PHP, and other key languages.
Create robust database designs, taking advantage of support for primary and foreign key constraints.
Embed zero-maintenance databases directly within applications that you write.
Improve performance through a good understanding of SQLite internals.
Exploit features such as the shared cache, the SQL Logic Test Suite, the Unlock and Notify APIs, and query plan improvements.
Who this book is for
The Definitive Guide to SQLite is for developers needing a zero-maintenance database solution to deploy as an embedded component within their product. The book is especially useful for mobile developers delivering applications to run on the iPhone, or on the Android platform. PHP developers will also find the book useful if they are using the default database delivered as part of a PHP installation.
Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
Product Description:
Application developers, take note: databases aren't just for the IS group any more. 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 into your application.
With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.
Learn how to maintain localized storage in a single file that requires no configuration
Build your own SQLite library or use a precompiled distribution in your application
Get a primer on SQL, and learn how to use several language functions and extensions
Work with SQLite using a scripting language or a C-based language such as C# or Objective-C
Understand the basics of database design, and learn how to transfer what you already know to 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.
Product Description: This book is about iPhone database programming. It provides a set of hands-on, step-by-step exercises.
The goal is to help you learn and master iPhone database programming quickly and easily.
Native iPhone OS database applications make use of the embedded SQLite database engine framework. Hence, learning iPhone database programming is learning how to use the embedded SQLite database engine.
The hands-on nature of these exercises is unique. True learning happens when you take action by performing hands-on exercises. That is what this book is about.
Here are the key iPhone Database Programming skills that you will learn:
Is this book for you? To find out, perform these two steps.
Step 1. Scan the Table of Contents, reading the title of each exercise. Each exercise focuses on a specific skill, and if the exercises look interesting to you, then this book is for you.
Step 2. Read through the first Exercise, and see if the clear, step-by-step instructions make sense to you. If so, then this book is for you.
If you have access to a Mac OS X system, along with the iPhone OS SDK (Software Developers Kit), then you can read each exercise, and perform each step, using the iPhone OS SDK.
However, even if you do not have a Mac OS X system with the iPhone OS SDK, you can still read and follow along "in your mind". When you do have access to a Mac, you'll know exactly what to do.
These days, applications are expected to efficiently manage an ever growing range of data. Yet it's rarely practical to embed a traditional relational database such as Oracle or MySQL within an application, due to not only size constraints but also because of the additional administrative overhead these databases require. While embeddable databases are small enough to ensure little additional total increase in application size, they often have little to offer by way of capabilities and power. So what's a developer to do?
For many, the answer is SQLite (http://www.sqlite.org/), an open source embeddable database with an amazingly small footprint (less than 250 Kb) but packing a powerful array of features. Capable of handling databases as large as 2 terabytes, SQLite offers a flexible set of datatypes, the ability to perform transactions, and is supported by languages such as C, PHP, Perl, and Python. Furthermore, because SQLite's databases are completely file-based, privileges are granted at the operating system-level, allowing for easy and fast user management.
The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. Offering experienced database developers a thorough overview of its capabilities and APIs, yet cognizant of newcomers who may be making their first foray into the database environment with SQLite, this book acts as both an ideal tutorial and reference guide.
Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
Product Description:
Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the "cool" features.
SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper (ORM) that lets you map "plain old Python objects" (POPOs) to database tables without substantially changing your existing Python code. Essential SQLAlchemy demonstrates how to use the library to create a simple database application, walks you through simple queries, and explains how to use SQLAlchemy to connect to multiple databases simultaneously with the same Metadata. You also learn how to:
Create custom types to be used in your schema, and when it's useful to use custom rather than built-in types
Run queries, updates, and deletes with SQLAlchemy's SQL expression language
Build an object mapper with SQLAlchemy, and understand the differences between this and active record patterns used in other ORMs
Create objects, save them to a session, and flush them to the database
Use SQLAlchemy to model object oriented inheritance
Provide a declarative, active record pattern for use with SQLAlchemy using the Elixir extension
Use the SQLSoup extension to provide an automatic metadata and object model based on database reflection
In addition, you'll learn how and when to use other extensions to SQLAlchemy, including AssociationProxy, OrderingList, and more.
Essential SQLAlchemy is the much-needed guide for every Python developer using this code library. Instead of a feature-by-feature documentation, this book takes an "essentials" approach that gives you exactly what you need to become productive with SQLAlchemy right away.
Product Description: SQLite is a small, fast, embeddable, SQL-based database server. It is easy to install, needs no management, and is open source. This book describes SQLite in detail. With hundreds of examples, plus a proven approach and structure, the book teaches you how to use SQLite efficiently and effectively. It contains a complete description of the SQL dialect as implemented in SQLite version 3.6. The book can be seen as a tutorial and a reference book. Source code for the numerous SQL examples and exercises included in this book can be downloaded from www.r20.nl.
Answers 2000 Limited has no opinion about any stories or content of, or
views expressed in, any linked news resource or website.
Information about companies, organizations, products and services
was believed to be correct at the time it was first published on this website,
but may out of date by the time you read this website. For current
information about any company or organization,
readers are advised to check with the applicable company or organization.
Answers 2000 Limited expresses no opinion about any company or
organization (including expressing no opinion on any investments in, with, or relating to, any company or organization),
product or service. This website is not intended as investment or
financial advice.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Disclosure:
Our company's websites' content (including this website's content) includes advertisements for
our own company's websites, products, and services,
and for other organization's websites, products, and services.
In the case of links to other organization's websites,
our company may receive a payment, (1) if you purchase products or services,
or (2) if you sign-up for third party offers, after following links from this website.
Unless specifically otherwise stated, information about other organization's products and services,
is based on information provided by that organization,
the product/service vendor, and/or publicly available information - and should
not be taken to mean that we have used the product/service in question.
Additionally, our company's websites contain some adverts which we are paid
to display, but whose content is not selected by us, such as Google AdSense ads. For more
detailed information, please see Advertising/Endorsements Disclosures
