Use SQLite as a key:value store
Even if there exists modules that do this (see other answer), I tried to write one simple, self-contained version. Here is a class KeyValueStore (key and value are strings) that works like this: Demo from sqlitekeyvaluestore import KeyValueStore kv = KeyValueStore('test.db') # uses SQLite print(len(kv)) # 0 item kv['hello1'] = 'you1' kv['hello2'] = 'you2' kv['hello3'] = 'you3' print(kv['hello1'])
sqlite-zstd: Transparent dictionary-based row-level compression for SQLite - An sqlite extension written in Rust to reduce the database size without losing functionality - phiresky's blog
data is a json blob from the perspective of SQLite, but it is parsed into a strictly typed structure in the Rust application code. After a year of collecting data, the SQLite database is already 7.6 GByte in size. Of course this is an extreme example of redundancy, but storing similar redundant data in databases is pretty common. SQLite doesn’t have any compression features, so of course I had to
Joining CSV and JSON data with an in-memory SQLite database
Sponsored by: Honeycomb — AI agents behave unpredictably. Get the context you need to debug what actually happened. Read the blog 19th June 2021 The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables. sqlite-utils memory The new feat
Bashing JSON into Shape with SQLite
Published on 2022-01-04, 1640 words, 6 minutes to read It is clear that most of the world has decided that they want to use JSON for their public-facing API endpoints. However, most of the time you will need to deal with storage engines that don't deal with JSON very well. This can be confusing to deal with because you need to fit a square peg into a round hole. However, SQLite added JSON function
Fossil: A Coherent Software Configuration Management System
Fossil is a simple, high-reliability, distributed SCM system with these advanced features: Project Management — In addition to doing distributed version control like Git and Mercurial, Fossil also supports bug tracking, wiki, forum, email alerts, chat, and technotes. Built-in Web Interface — Fossil has a built-in, themeable, extensible, and intuitive web interface with a rich variety of informatio
GitHub - phiresky/sql.js-httpvfs: Hosting read-only SQLite databases on static file hosters like Github Pages
See my blog post for an introduction: https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/ sql.js is a light wrapper around SQLite compiled with EMScripten for use in the browser (client-side). This repo is a fork of and wrapper around sql.js to provide a read-only HTTP-Range-request based virtual file system for SQLite. It allows hosting an SQLite database on a static fi
GitHub - benbjohnson/litestream: Streaming replication for SQLite.
Litestream is a standalone disaster recovery tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database. If you need support or have ideas for improving Litestream, please visit GitHub Issues. Please visit the Litestream web site for installa
Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal)
Expensify has an unusual technology stack in many ways. For example, we don't use DNS internally — just configuration-managed /etc/hosts files — and it works great. Similarly, we only make limited use of AWS — instead hosting our own hardware for the web and database layer — and it works great. But most surprising of all is that we don't use MySQL or Postgres — instead using none other than SQL
The JSON1 Extension | SQLite
1. Overview By default, SQLite supports thirty functions and two operators for dealing with JSON values. There are also two table-valued functions that can be used to decompose a JSON string. There are twenty-six scalar functions and operators: json(json) jsonb(json) json_array(value1,value2,...) jsonb_array(value1,value2,...) json_array_length(json) json_array_length(json,path) json_error_positio
SQLite Archiver: Documentation
SQLITE_NOTICE(283): recovered 2 frames from WAL file /Fossils/sar.fossil-wal
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
GitHub - asg017/sqlite-html: A SQLite extension for querying, manipulating, and creating HTML elements.
GitHub - asg017/sqlite-lines: A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)
The Incubator · Issue #27 · nalgeon/sqlean
GitHub - nalgeon/sqlean: The ultimate set of SQLite extensions
GitHub - simonw/datasette: An open source multi-tool for exploring and publishing data