Command Line Shell For SQLite

About This Blog Post This blog post is a technical report of a presentation that I presented on June 10, 2022 for the second task of my Mobile Security course. I decided to investigate how WhatsApp backs up messages to the cloud with the “end-to-end encrypted backups” option toggled on and off. TL;DR at the bottom. Introduction & Motivation WhatsApp [1][2] is a cross-platform instant messaging app used by “more than 2 billion users in 180 countries” [3][5].

A framework for writing fast and performant SQLite extensions in Rust - asg017/sqlite-loadable-rs

If you have multiple Kindles you switch between, you will find that it is pretty much impossible to sync Kindles without using their cloud

A SQLite extension for efficient vector search, based on Faiss! - asg017/sqlite-vss

Jeff Huleatt's blog

This will be the third year of taking part in the SANS Holiday Hack Challenge, and like many, I have been looking forward to it since late November. I should really get round to publishing my unfinished attempt for 2016, seeing as it will complete this current series of blog posts… Cranberry Terminals First up, lets complete the Cranberry terminals in each of the snowball rolling games, to get us in the mood.

Babel functions for the `dsq` CLI tool by Multiprocess Labs.

A micro-benchmark framework to use with cargo bench - Canop/glassbench

Unofficial git mirror of SQLite sources (see link for build instructions) - mackyle/sqlite

SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of database files and other security features. - sqlcipher/sqlcipher

I like to share what I learn

Posts and writings by Roger Binns

I love simplicity. Complexity is our eternal enemy and Simplicity is beautiful; rarely something is as simple as SQLite: a single-file, in-process database. It runs inside our application, there is no need for a separate database server.

A step-by-step guide to migrating a Doctrine database from SQLite to MySQL in a Symfony application.

How to use Sqlite as a cache in Laravel

I been recently experimenting in using a different tool besides bitwarden for my password management needs. Nothing wrong with bitwarden,...

Discover how a messaging app restored users' messages, resolving database corruption using SQLite shell and innovative recovery strategies, enhancing user privacy and trust.

At work we’re having to wait an inordinate amount of time for Xcode to finish indexing our rather large Swift project. I’ve consequently spent a lot of time over the past few weeks digging into the internals of indexing. This is more or less a... | Space is Disorienting | Mobile Engineer

A SQLite extension for efficient vector search, based on Faiss! - asg017/sqlite-vss

Why DuckDB There are many database management systems (DBMS) out there. But there is no one-size-fits-all database system. All take different trade-offs to better adjust to specific use cases. DuckDB is no different. Here, we try to explain what goals DuckDB has and why and how we try to achieve those goals through technical means. To start with, DuckDB is a relational (table-oriented) DBMS that supports the Structured Query Language (SQL). Key Characteristics of DuckDB Simple SQLite is the world's most widely deployed DBMS. Simplicity in installation, and embedded in-process operation are central to its success. DuckDB adopts these ideas…

A SQLite extension for querying, manipulating, and creating HTML elements. - asg017/sqlite-html

One of the main pain points of using SQLite in production deployments or VMs is managing the database. There are lots of database GUIs, but only work with local SQLite databases. Managing an SQLite database remotely requires: Adding a new service to the deployment (like Adminer, sqlite-web or postlite) Giving the new service permissions to access the volume with the database Exposing a port to access the service The alternative is usually SSH’ing to the remote VM and use the sqlite3 CLI to manage or explore the database. With this in mind, I decided to build a remote SQLite management GUI that does not require running any service in the remote VM and only needs an SSH connection between you and the remote machine.