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. DuckDB v1.1.0 was released in September 2024. 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;
Canonical Dqlite | Canonical 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 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 - 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.
{{#tags}}- {{label}}
{{/tags}}