SQLite is a relational database management system,
implemented in a small C library which can be linked directly into programs, and released into the
Although SQLite itself is developed in C, it can be used from a wide variety of programming
C, C++, Delphi, Java,
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.
Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
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
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
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!
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 in a Specific Location
Create database and populate it with tables from a file
Backup & Database
Chapter 3: Create, Alter, Drop Table
Add columns- Using ALTER TABLE Command
Insert value into a table
Chapter 4: Primary & Foreign Key
Not null constraint
What is a SQLite Foreign KEY?
Chapter 5: Data Types
Examples of storing data types in SQLite
Chapter 6: Select, Where, Limit, Count, Group By, Union
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 will help readers to take full advantage of SQLite's features.
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.
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.
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition
New full-color code examples help you see how SQL statements are structured
Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.
Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.
You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.
With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.
10 minutes is all you need to learn how to...
Use the major SQL statements
Construct complex SQL statements using multiple clauses and operators
Retrieve, sort, and format database contents
Pinpoint the data you need using a variety of filtering techniques
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
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.
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.
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
constitutes consent for this. For details, please see Privacy.