LinkedIn
GitHub profile
Проекты
Advertisement
RSS
.NET Framework .NET C# VB.NET LINQ ASP.NET Web API REST SignalR Windows Forms WPF WCF RabbitMQ PHP SQL Server MySQL PostgreSQL MariaDB SQLite MongoDB ADO.NET ORM Entity Framework Dapper XML JSON HTML5 CSS3 Bootstrap JavaScript jQuery Angular React TypeScript NPM Blazor UI/UX Responsive Web Design Redis Elasticsearch GraphQL Grafana Agile Scrum Kanban Windows Server IIS PowerShell Active Directory TFS Azure Automation Software Reverse Engineering Performance Optimization Git Jira/Confluence CI/CD TeamCity SOLID KISS DRY YAGNI
Books for developers
Always will be ready notify the world about expectations as easy as possible: job change page


The Definitive Guide to SQLite, Second Edition

The Definitive Guide to SQLite, Second Edition

Author: Grant Allen, Mike Owens
Year: 2010
Format: PDF
Pages: 369
Views: 692

5.56 MB
Description

The Definitive Guide to SQLite, Second Edition is your one-stop resource for integrating one of the most advanced and innovative open source database management systems into your development projects. SQLite is freely-available and comes with an amazingly small foot print of less than 300 kilobytes for a full-blown implementation. It’s perfect for mobile and other embedded implementations, including the iPhone and Android platforms. It’s also the default database distributed with PHP.

In The Definitive Guide to SQLite, Second Edition, Authors Grant Allen and Mike Owen provide complete coverage of SQLite’s powerful array of features. You’ll learn to use SQLite with PHP, C++, Java, and more. You’ll see how SQLite’s file-based approach can easily handle databases as large as two terabytes. You’ll also enjoy complete coverage of the API, and learn to embed SQLite within mobile applications on the iPhone, and on Android platforms.

Demonstrates SQLite’s use in iPhone and Android development.
Helps you integrate with popular languages such as PHP, C++, Java, and more.
Serves as an excellent tutorial, and ongoing reference.

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 new 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 new 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.

Similar
MongoDB in Action
Автор: Kyle Banker
Год: 2011
Страниц: 311
MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples...
Apps and Services with .NET 7
Автор: Mark J. Price
Год: 2022
Страниц: 815
Bestselling author Mark Price is back to guide you through the coolest and most common technologies a .NET developer should know: Blazor, .NET MAUI, gRPC, GraphQL, SQL Server, Cosmos DB, OData, SignalR, Azure Functions, and more!Key Features ...
Dynamic SQL, Second Edition
Автор: Edward Pollack
Год: 2019
Страниц: 508
This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It’s also useful in generating value-lists, in dynamic pivoting of data...
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
Автор: Simon Riggs, Gianni Ciolli, Gabriele Bartolini
Год: 2017
Страниц: 556
PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational,...
Send message
Email
Your name
*Message


© 1999–2023 WebDynamics
1980–... Sergey Drozdov
Area of interests: .NET | .NET Core | C# | ASP.NET | Windows Forms | WPF | Windows Phone | HTML5 | CSS3 | jQuery | AJAX | MS SQL Server | Transact-SQL | ADO.NET | Entity Framework | IIS | OOP | OOA | OOD | WCF | WPF | MSMQ | MVC | MVP | MVVM | Design Patterns | Enterprise Architecture | Scrum | Kanban