How to Add SQLite to Capacitor Apps for Offline Relational Data Storage

·2 views

Developers building Capacitor apps that outgrow simple key-value storage can turn to SQLite for a full relational database that runs on-device and works offline. Two actively maintained plugins are available: the free, open-source community plugin and the Capawesome team's plugin, which offers built-in encryption, schema migrations, full-text search, and ORM support. Unlike IndexedDB, which the operating system can clear under storage pressure, SQLite persists data in a real file on the device filesystem. The Capawesome plugin is distributed via a dedicated npm registry and supports Android, iOS, Web, and Electron platforms. Key capabilities covered in the tutorial include running SQL queries and transactions, applying versioned schema migrations, enabling full-text search via FTS5, and encrypting databases with SQLCipher.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Dinghy tool lets developers launch a Docusaurus site from one Markdown file

A tool called Dinghy reduces the setup process for Docusaurus-based documentation sites to a single folder, one MDX file, and one command. It ships a fully configured Docusaurus instance inside a Docker image, eliminating the need for package.json, node_modules, or manual configuration files. Developers can customise behaviour by adding a docusaurus.config.yml file, which Dinghy merges with its internal Docusaurus configuration. The tool also includes a built-in S3 deployment command that handles URL cleanup, gzip compression, and cache-control headers automatically. Dinghy follows a consistent pattern of sensible defaults with optional overrides across its start, build, and deploy lifecycle commands.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Build Production Observability with Python, Prometheus and Grafana

Modern distributed systems demand observability — understanding why and where failures occur — rather than simple uptime monitoring. A practical approach involves collecting three types of telemetry: metrics, logs, and traces, with metrics best structured around the RED method covering request rate, errors, and duration. Developers can instrument a Python FastAPI service using the prometheus_client library to expose custom metrics at a dedicated endpoint for Prometheus to scrape. The full observability stack, including Prometheus for data collection and Grafana for visualization, can be run locally via Docker Compose with minimal configuration. This setup enables engineering teams to detect, diagnose, and resolve production issues faster without relying on manual log searches.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Snap CD Runs Standard Terraform Commands Without Wrappers or Custom Formats

Snap CD is a continuous delivery tool for infrastructure that orchestrates Terraform deployments without modifying how Terraform itself operates. Unlike many CD tools, it does not introduce wrapper CLIs, proprietary plan formats, custom state backends, or domain-specific languages that lock teams into a vendor ecosystem. When deploying, Snap CD clones the user's Git repository into a local working directory and writes inputs using standard Terraform-compatible formats such as .tfvars files and environment variables. The tool then executes native terraform init, plan, and apply commands using real Terraform binaries rather than forks or shims. This approach is designed to keep infrastructure code portable and fully inspectable outside the tool's ecosystem.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Snap CD Launches Full Toolset With Terraform Provider, Docs, and Migration Support

Snap CD has released a comprehensive supporting ecosystem alongside its continuous deployment platform, including structured documentation, a Terraform provider, and deployment reference repositories. The documentation site at docs.snapcd.io covers quickstart guides, detailed resource references, and component architecture for both Cloud and Self-Hosted editions. The Terraform provider allows teams to manage all Snap CD configuration as code using HCL, enabling version-controlled, reproducible environment setups without manual UI interaction. A composition pattern supported by the provider lets platform teams define infrastructure once, allowing application teams to onboard self-service by simply adding entries to a configuration file. Snap CD components are distributed as Docker images and zipped binaries via GitHub Releases, with reference deployment repositories covering common infrastructure substrates.

0 comments Read more at DEV Community