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
GitHub - nalgeon/sqlean: The ultimate set of SQLite extensions
SQLite has few functions compared to other database management systems. SQLite authors see this as a feature rather than a problem, because SQLite has an extension mechanism in place. There are a lot of SQLite extensions out there, but they are incomplete, inconsistent and scattered across the internet. sqlean brings them together, neatly packaged into domain modules, documented, tested, and built
Cross-database queries in SQLite (and weeknotes)
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 makes them easy to create, copy and move around. All you need is a disk volume and you can create as many SQLite databases as you lik
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
An in-process SQL OLAP database management system
DuckDB is a fast in-process analytical database DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs Installation Documentation -- Get the top-3 busiest train stations SELECT station_name, count(*) AS num_services FROM train_services GROUP BY ALL ORDER BY num_services DESC LIMIT 3;
Dqlite - High-Availability SQLite | Dqlite
High-availability SQLite Dqlite is a fast, embedded, persistent SQL database with Raft consensus that is perfect for fault-tolerant IoT and Edge devices. Dqlite (distributed SQLite) extends SQLite across a cluster of machines, with automatic failover and high-availability to keep your application running. It uses C-Raft, an optimised Raft implementation in C, to gain high-performance transactional
DB Browser for SQLite
DB Browser for SQLite The Official home of the DB Browser for SQLite Screenshot What it is DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not hav
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
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 d
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
The JSON1 Extension | SQLite
1. Overview By default, SQLite supports sixteen 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 15 scalar functions and operators: json(json) json_array(value1,value2,...) json_array_length(json) json_array_length(json,path) json_error_position(json) json_extract(json,path,...) json -> path j
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 - lmatteis/torrent-net: Distributed search engines using BitTorrent and SQLite
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 - jcsalterego/historian: Command-line utility for managing shell history in a SQLite database.