SQLite the only database you will ever need in most cases
Published on 2021-04-14. Modified on 2023-02-16. The name SQLite is a nice name, but the "lite" part is misleading, it sounds like it is only useful for tiny things - which is very wrong. SQLite should be named AwesomeSQL, because that is what it is. SQLite is probably the only database you will ever need in most cases. SQLite is a relational database management system contained in a C library. It
Cross-database queries in SQLite (and weeknotes)
Sponsored by: Honeycomb — AI agents behave unpredictably. Get the context you need to debug what actually happened. Read the blog 21st February 2021 I released Datasette 0.55 and sqlite-utils 3.6 this week with a common theme across both releases: supporting cross-database joins. Cross-database queries in Datasette SQLite databases are single files on disk. I really love this characteristic—it mak
GitHub - lmatteis/torrent-net: Distributed search engines using BitTorrent and SQLite
Distributed sites have gained much attention lately with systems such as ZeroNet and IPFS, which seem to improve on older systems like Freenet. Building search engines on top of these distributed systems is not quite feasible yet as users need to download the entire site database (usually several hundreds of gigabytes large) before running queries against it. TorrentNet allows you to build distrib
GitHub - lspgn/edge-sql: Cloudflare Workers providing a SQL API
I had an idea. Here's a little backstory. Many services provide a REST API on top of a SQL database. For certain datasources, flexibility in terms of queries is key. Often those use-cases are dashboard prototyping, for example with Grafana. This data is usually read-only statistical datasets where the user needs to run many queries in order to troubleshoot an issue or just find the best visualizat
DB Browser for SQLite
DB Browser for SQLiteDB Browser for SQLite (DB4S) is a high quality, visual, open source tool designed for people who want to create, search, and edit SQLite or SQLCipher database files. DB4S gives a familiar spreadsheet-like interface on the database in addition to providing a full SQL query facility. It works with Windows, macOS, and most versions of Linux and Unix. Documentation for the program
Why SQLite Does Not Use Git
1. Introduction SQLite does not use the Git version control system. SQLite uses Fossil instead, which is a version control system that was specifically designed and written to support SQLite. People often wonder why SQLite does not use the Git version control system like everybody else. This article attempts to answer that question. Also, in section 3, this article provides hints to Git users abou
Appropriate Uses For SQLite
SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem. Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual a
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
MySQL感覚でSQLiteを管理する
iPhone/iPad開発である程度のデータを扱う必要が出来た場合、真っ先にSQLiteの導入を考えたほうが良い。ややプログラミングの上での操作性に難はあるが、高速にデータを扱えるメリットを考えれば恩恵は非常に大きい。 以下はMySQLに慣れた人向けに、導入についてと、SQLiteデータベースを操作する上でのTipsなどを紹介。 導入 c/fe ここを見ればオールOK。iPhone/iPadへの組み込みから、プログラムからの操作まで教えてくれる。 taichino.com さらに詳しい内容。例も分かりやすかったのでひと通りここで紹介している順序で実装をやってみるといいかもしれない。 Command Line Shell For SQLite コマンドラインリファレンスが読みたい場合はこちら。 MySQL経験者向けTips コンソールからSQLiteデータベースへの接続（Mac） (MySQ
ディスクに空きがない時にSQLiteへINSERTしようとした場合の挙動 - terurouメモ
Androidでディスクに空きがない時にSQLiteへINSERTしようとした場合の挙動を確認してみた。てか、どんな挙動するのかぐらいドキュメントに書いとけよ＞Google 結果として、以下の2つのタイミングでSQLiteDiskIOExceptionが発生することが確認できた。 書き込み可能なDBを開こうとした（SQLiteDatabaseOpenHelper.getWritableDatabase()を呼んだ）タイミング。 つまりディスク容量が少ない時は書き込み可能なDBを開くことはできない。 データをコミットしようとした（SQLiteDatabase.endTransaction()を呼んだ）タイミング 明示的にトランザクションを開始していない場合は、INSERTしようとした時点で落ちると思う（試してない）。 DBを開く時点ではディスクが空いてたんだけど、書き込みをする時点でディスク
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
GitHub - nalgeon/sqlean: The ultimate set of SQLite extensions
An in-process SQL OLAP database management system
Canonical Dqlite | Canonical
GitHub - groue/GRDB.swift: A toolkit for SQLite databases, with a focus on application development
GitHub - kripken/sql.js
GitHub - dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
GitHub - aergoio/litetree: SQLite with Branches
GitHub - simonw/datasette: An open source multi-tool for exploring and publishing data
GitHub - jcsalterego/historian: Command-line utility for managing shell history in a SQLite database.