Share E-Book
Scan to open this page

Scan with your phone to open this page

AuthorJay A. Kreibich

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

AI Reading Assistant

Whole-book reading guide from stratified index samples; jump to passages in the text

AI guide
【One-Line Pitch】 A practical, example-driven guide to Go for developers who want to learn by doing—covering everything from installation and JSON parsing to concurrency, testing, and shipping Docker images—ideal for anyone building production-grade tools, CLIs, or microservices. 【Book Arc】 - **Opening (~0%–6%)**: Introduces the book's purpose and the author's background, framing it as a compilation of real-world Go techniques rather than a language reference. It sets expectations for a hands-on, fast-track learning style. - **Early (~6%–18%)**: Covers Go fundamentals and setup, including installation methods (system packages, package managers, tar archives), managing packages and paths, and understanding Go modules and vendoring. This stage solves the problem of getting a working Go environment and project structure. - **Middle (~24%–53%)**: Dives into core programming tasks: creating your first program, adding external dependencies, using flags, defining packages, cross-compiling, and handling HTTP/JSON. This is the "getting things done" phase, where you build functional code for common needs. - **Late (~59%–71%)**: Focuses on advanced and practical topics: writing unit tests with coverage and benchmarks, working with Goroutines and channels for concurrency, avoiding common concurrency mistakes, and storing data with databases. Also covers YAML config files and embedding data. - **Ending (~76%–88%)**: Moves to production concerns: building and releasing Go binaries, creating Docker container images, shipping via GitHub Actions, adding Prometheus metrics, and writing HTTP microservices. Concludes with guidance on contributing to open source and continuing your Go journey. 【Key Takeaways】 - **Go is built for production tooling** (Early): Its static compilation, cross-platform support, and strong standard library make it ideal for CLIs and server-side projects. This matters because you can distribute a single binary without runtime dependencies. - **Modules and vendoring are essential for dependency management** (Early): Understanding Go modules, package paths, and vendoring prevents the classic "works on my machine" problem and keeps builds reproducible. - **JSON and HTTP handling are streamlined in Go** (Middle): The `encoding/json` and `net/http` packages provide powerful, simple tools for fetching and parsing data, building servers, and even reverse proxies—reducing the need for third-party libraries. - **Concurrency is a built-in feature, not an afterthought** (Late): Goroutines, channels, Mutexes, and error groups let you write concurrent code safely. The book highlights common mistakes (like misuse of RWMutex) so you avoid deadlocks and race conditions. - **Testing is first-class and practical** (Late): Go's built-in test runner supports table-driven tests, statement coverage, HTML coverage reports, and benchmarks. You can even compile tests to a binary and run them in parallel for stress testing. - **Shipping is part of the development lifecycle** (Ending): From injecting version info into binaries to building multi-arch Docker images and releasing via GitHub Actions, the book covers the full path from code to production. - **The standard library is a hidden superpower** (Ending): Packages like `crypto`, `compress`, `text/template`, and `os` cover what other languages require external dependencies for, making Go self-sufficient for most tasks. 【Reading Tips】 - **Skim the early setup chapters** if you already have Go installed; focus on the modules and vendoring sections, which are critical for real projects. - **Deep-read the concurrency and testing chapters**—these are where the book's practical value shines, and the examples are directly applicable to production code. - **Treat the book as a recipe collection**: don't read it cover-to-cover; jump to the pattern you need (e.g., "write a CLI" or "add Prometheus metrics") and adapt the example. - **Pay attention to the "common mistakes" callouts**, especially around Goroutines and locking, as these are the pitfalls that trip up even experienced developers. - **The final chapters on Docker and GitHub Actions are skimmable** if you're not doing DevOps, but the version-injection and multi-arch tips are worth noting for any Go project. 【Coverage Limits】 The excerpts focus heavily on the book's table of contents, introduction, and early Go fundamentals; detailed content on SQLite (despite the title) is not covered in the sample. The guide reflects the Go-focused material actually present in the excerpts.
Excerpt 1
书名: Everyday Go - The Fast Track for Golang 1(Alex Ellis) (Z-Library) 作者: Alex Ellis Learn tools, techniques and patterns from real tools used in production....
View in text
Excerpt 2
ow to use the book Help the book to evolve Changelog Why Go?
View in text
Excerpt 3
to use the book Help the book to evolve Changelog Why Go?
View in text
Excerpt 4
use the book Help the book to evolve Changelog Why Go?
View in text
Excerpt 5
e the book Help the book to evolve Changelog Why Go?
View in text
Excerpt 6
custom metrics to your Prometheus data Building and releasing Go binaries The release-it example Releasing your binaries with a GitHub Action Releasing a Doc...
View in text
Excerpt 7
ire an additional runtime making them a very popular choice. My personal highlights for Go are: portability - static compilation for easy distribution cross-...
View in text
Excerpt 8
Getting started with Go There are three ways to install Go. Install Go using a system package - such as an msi (Windows) or pkg (MacOS) Install Go using a pa...
View in text
Tags
AI categories
GoProgramming LanguageDevOps
ISBN: 0596521189
Publisher: O'Reilly Media
Publish Year: 2010
Language: English
Pages: 503
File Format: PDF
File Size: 5.5 MB
Text Preview (First 20 pages)
Registered users can read the full content for free

Register as a Gaohf Library member to read the complete e-book online for free and enjoy a better reading experience.

Generating text preview…