SQLite Books

OSgram.com   >   Shopping   >   Books   >   SQLite
Shop for books about SQLite.

Other web sites about SQLite:Additional pages on this web site, which may be of interest: 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.

Using SQLite: Small. Fast. Reliable. Choose Any Three.

By Jay A. Kreibich

Brand: O'Reilly Media
Paperback (530 pages)

Using SQLite: Small. Fast. Reliable. Choose Any Three.
List Price: $49.99*
Lowest New Price: $33.06*
Lowest Used Price: $33.08*
Usually ships in 24 hours*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
  • ISBN13: 9780596521189
  • 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
  • Take advantage of virtual tables and modules

"Complex SQL concepts explained clearly."

--D. Richard Hipp, creator of SQLite

Getting Started with SQL: A Hands-On Approach for Beginners

By Thomas Nield

Released: 2016-02-18
Paperback (134 pages)

Getting Started with SQL: A Hands-On Approach for Beginners
List Price: $33.99*
Lowest New Price: $21.34*
Lowest Used Price: $19.10*
Usually ships in 24 hours*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
Product Description:

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.

Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs.

You’ll also learn how to:

  • Explore relational databases, including lightweight and centralized models
  • Use SQLite and SQLiteStudio to create lightweight databases in minutes
  • Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
  • Join tables to get a more complete view of your business data
  • Build your own tables and centralized databases by using normalized design principles
  • Manage data by learning how to INSERT, DELETE, and UPDATE records

Learn SQLite in 1 Day: Definitive Guide to Learn SQLite for Beginners

By Krishna Rungta

Independently published
Paperback (102 pages)

Learn SQLite in 1 Day: Definitive Guide to Learn SQLite for Beginners
List Price: $9.99*
Lowest New Price: $9.99*
Usually ships in 24 hours*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
Product Description:

SQLite is a very lightweight database, with no installation required, zero configuration, and no server required. SQLite is widely used as a database of choice in mobile apps, camera, home electronic devices and other embedded systems.

This book is designed for beginners with little or no prior database experience.

Here is what you will learn:

Chapter 1: Introduction

Chapter 2: Create Database

CREATE Database

CREATE Database in a Specific Location

Create database and populate it with tables from a file

Backup & Database

Drop Database

Chapter 3: Create, Alter, Drop Table

Create table

Drop table

Alter table

Add columns- Using ALTER TABLE Command

Insert value into a table

Chapter 4: Primary & Foreign Key

SQLite constraint

Primary Key

Not null constraint

DEFAULT Constraint

UNIQUE constraint

What is a SQLite Foreign KEY?

Chapter 5: Data Types

Storage Classes

Affinity Type

Examples of storing data types in SQLite

Chapter 6: Select, Where, Limit, Count, Group By, Union

Reading data with select


Limiting and Ordering

Group BY

Query & Subquery

Set Operations -UNION,Intersect

Conditional results

Advanced queries

Chapter 7: Joins

Introduction to SQLite JOIN Clause










Conflict clause

Chapter 9: Index, Trigger & View




Chapter 10: SQLite Functions

Finding the LENGTH of a string

UPPER Function and LOWER Function

TRIM Function

TYPEOF Function


SQLite library

User-defined functions

The Definitive Guide to SQLite (Expert's Voice in Open Source)

By Grant Allen

Allen Grant Owens Mike
Paperback (368 pages)

The Definitive Guide to SQLite (Expert s Voice in Open Source)
List Price: $54.99*
Lowest New Price: $43.99*
Lowest Used Price: $34.47*
Usually ships in 24 hours*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
  • The Definitive Guide to SQLite
Product Description:

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!

The Definitive Guide to SQLite

By Mike Owens

Mike Owens
Hardcover (440 pages)

The Definitive Guide to SQLite
List Price: $59.99*
Lowest New Price: $48.03*
Lowest Used Price: $9.11*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
  • The Definitive Guide to SQLite
Product Description:

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.

Using SQLite to Bypass the 2 GB .DBF Filesize Limit

By Whil Hentzen

Hentzenwerke Publishing
Mass Market Paperback (106 pages)

Using SQLite to Bypass the 2 GB .DBF Filesize Limit
List Price: $19.95*
Lowest New Price: $19.95*
Usually ships in 24 hours*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
Product Description:
The .DBF file format has been a standard for desktop applications for over 30 years. Pretty much every data-oriented application can read and write to a .DBF file. Back in the day when the format was created, the days of 180 kb floppies, sometime later surpassed by 1.44 MB 3 1/2 inch disks, and, eventually those monster hard disks that held hundreds of or even a thousand megabytes, its 2 GB limit was not a concern.

Even in the mid-2010s, the xBase family of applications are excellent tools for manipulating data. One common use is to import data from other formats, such as text files, and, once stored in a .DBF, slice and dice that data as desired. Over the past decade, though, it's become commonplace to run into data sets exceeding the 2 GB limit. This can happen due to accumulation of data over decades of use of an application or dumps from large SQL databases. Once such a data dump grows larger than two gigabytes, though, dealing with them with the Xbase tools becomes a problem, since they can't be directly imported into a DBF.

What is needed is intermediate data storage that can import a raw text file of any size and then allow the user to slice and dice the data as needed. Enter SQLite. This book will show you how to use SQLite, a fast, free, high-quality database for such intermediate data storage.

The SQL Guide to SQLite

By Rick F. van der Lans

Paperback (542 pages)

The SQL Guide to SQLite
List Price: $42.36*
Lowest New Price: $42.36*
Lowest Used Price: $38.32*
Usually ships in 24 hours*
*(As of 18:50 Pacific 20 Feb 2018 More Info)

Click Here
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.

Data Science in Python. Volume 3: Plots and Charts with Matplotlib, Data Analysis with Python and SQLite

By Alexander Stepanov

Released: 2016-04-25
Kindle Edition (91 pages)

Data Science in Python. Volume 3: Plots and Charts with Matplotlib, Data Analysis with Python and SQLite
Product Description:
This volume describes data visualization with Python and using SQL database for data analysis. I assume you are familiar with Python 3, have scientific Python 3 distribution installed and know how to start IPython notebook that is used for all examples in this book. If you need help setting up scientific Python on your machine be sure to check out introductory volume 1 of this series. You might also want to look at volume 2 that deals with reading and writing tabular data, interactive data exploration with IPython notebook, GUI programming, deployment and high performance computations in Python.

Data visualization is one of the strongest points of scientific Python stack. Matplotlib library makes it easy to do both quick data exploration and creating publication quality graphs. It has ready made routines for drawing wide variety of plots, from classical line and bar plots to modern violin plots. It allows users to annotate plots or create novel plot types. Matplotlib's ability to export drawings in numerous graphic formats, including pdf, svg, animated gif or mp4 video makes it useful for interactive data exploration, web applications or drawing high quality diagrams. It is way more flexible than any GUI plotting software and will benefit any student's or scientist's tool box. This book is intended to get you started with Matplotlib.
SQL databases is a science of its own. Usually database is associated with data storage, but in this book I use it for data analysis. SQL is more expressive, clear and powerful than any spreadsheet application can ever be.
SQLite database is used for all examples. Python is used to load realistic bioinformatic data, but most of the queries can be run in GUI database management software you can download from the internet.
In a final chapter I combine Python, Matplotlib and SQL to solve a realistic problem - identify genes that are frequently mentioned together in scientific publications and draw a network showing how many papers mention each pair of genes.

  Run multiple operating systems on your machine!

   Open Source




ATI Echo Server for Linux

News Resources








Contact Us   Privacy   Terms Of Use   Advertising/Endorsements Disclosures

Copyright © 2006-2015, Answers 2000 Limited.

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.

In Association With Amazon.com
Answers 2000 Limited is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.


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

Our sites use cookies, some of which may already be set on your computer. Use of our site constitutes consent for this. For details, please see Privacy.