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'])
GitHub - asg017/sqlite-html: A SQLite extension for querying, manipulating, and creating HTML elements.
A SQLite extension for querying, manipulating, and creating HTML elements. Extract HTML or text from HTML with CSS selectors, like .querySelector(), .innerHTML, and .innerText Generate a table of matching elements from a CSS selector, like .querySelectorAll() Safely create HTML elements in a query, like .createElement() and .appendChild() sqlite-html's API is modeled after the official JSON1 SQLit
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
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 feature is part of sqlite-utils 3.10, which I released this morning. You can install it using brew install sqlite-utils or pip install
Bashing JSON into Shape with SQLite
Bashing JSON into Shape with SQLite Published on 01/04/2022, 1561 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.
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
Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal)
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 tha
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
SQLAR - SQLite Archiver This repository contains sources for the "SQLite Archiver" program. This program (named "sqlar") operates much like "zip", except that the compressed archive it builds is stored in an SQLite database instead of a ZIP archive. The motivation for this is to see how much larger an SQLite database file is compared to a ZIP archive containing the same content. The answer depends
GitHub - simonw/datasette: An open source multi-tool for exploring and publishing data
An open source multi-tool for exploring and publishing data Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size and publish that as an interactive, explorable website and accompanying API. Datasette is aimed at data journalists, museum curators, archivists, local governments, scientists, researchers and anyone else who has data that they wish to sh
1
ランã‚ング
メンテナンス
ãŠçŸ¥ã‚‰ã›
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
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 - benbjohnson/litestream: Streaming replication for SQLite.
GitHub - nalgeon/sqlean: The ultimate set of SQLite extensions
{{#tags}}- {{label}}
{{/tags}}