サクサク読めて、
アプリ限定の機能も多数!
アプリで開く
●はてなブックマークって?
●アプリ・拡張の紹介
●ユーザー登録
●ログイン
●ログアウト
トップへ戻る
総合
●人気
●新着
●
IT
●
最新ガジェット
●
自然科学
●
経済・金融
●
おもしろ
●
マンガ
●
ゲーム
●
はてなブログ︵総合︶
一般
●人気
●新着
●
社会ニュース
●
地域
●
国際
●
天気
●
グルメ
●
映画・音楽
●
スポーツ
●
はてな匿名ダイアリー
世の中
●人気
●新着
●
新型コロナウイルス
●
働き方
●
生き方
●
地域
●
医療・ヘルス
●
教育
●
はてな匿名ダイアリー
政治と経済
●人気
●新着
●
政治
●
経済・金融
●
企業
●
仕事・就職
●
マーケット
●
国際
●
はてなブログ︵政治と経済︶
暮らし
●人気
●新着
●
カルチャー・ライフスタイル
●
ファッション
●
運動・エクササイズ
●
結婚・子育て
●
住まい
●
グルメ
●
お金
●
はてなブログ︵暮らし︶
●
掃除・整理整頓
●
雑貨
●
買ってよかったもの
●
旅行
●
アウトドア
●
趣味
学び
●人気
●新着
●
人文科学
●
社会科学
●
自然科学
●
語学
●
ビジネス・経営学
●
デザイン
●
法律
●
本・書評
●
将棋・囲碁
●
はてなブログ︵学び︶
テクノロジー
●人気
●新着
●
IT
●
セキュリティ技術
●
はてなブログ︵テクノロジー︶
●
AI・機械学習
●
プログラミング
●
エンジニア
おもしろ
●人気
●新着
●
まとめ
●
ネタ
●
おもしろ
●
これはすごい
●
かわいい
●
雑学
●
癒やし
エンタメ
●人気
●新着
●
スポーツ
●
映画
●
音楽
●
アイドル
●
芸能
●
お笑い
●
サッカー
●
話題の動画
アニメとゲーム
●人気
●新着
●
マンガ
●
Webマンガ
●
ゲーム
●
任天堂
●
PlayStation
●
アニメ
●
バーチャルYouTuber
●
オタクカルチャー
●
おすすめ
Wikipedia
﹃SQLite Home Page﹄
●
人気
●
新着
●
すべて
205 users
www.sqlite.org
Note: Sections 2.0 and 3.0 of this article were added in response to comments on Hacker News and Reddit. Since its inception on 2000-05-29, SQLite has been implemented in generic C. C was and continues to be the best language for implementing a software library like SQLite. There are no plans to recode SQLite in any other programming language at this time. The reasons why C is the best language to
●
テクノロジー
●2023/09/20 18:42
●sqlite
●Rust
●C
●あとで読む
●programming
●performance
●C言語
●memory
●開発
●プログラミング
3users
www.sqlite.org
Overview Usually, SQLite allows at most one writer to proceed concurrently. The BEGIN CONCURRENT enhancement allows multiple writers to process write transactions simultanously if the database is in "wal" or "wal2" mode, although the system still serializes COMMIT commands. When a write-transaction is opened with "BEGIN CONCURRENT", actually locking the database is deferred until a COMMIT is execu
●
テクノロジー
●2023/07/28 10:08
3users
www.sqlite.org
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
●
テクノロジー
●2023/07/23 13:11
3users
www.sqlite.org
1. Introduction A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queries and updates on a virtual table invoke callback methods of the virtual table object instead of reading and writing on the database file. The virtual table mechani
●
テクノロジー
●2019/07/22 09:50
42users
www.sqlite.org
1. SQLite Is Serverless Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the process that wants to access the database reads and writes di
●
テクノロジー
●2018/12/26 00:37
●sqlite
●あとで読む
●サーバレス
●database
●techfeed
●ネタ
3users
www.sqlite.org
In-Memory Databases An SQLite database is normally stored in a single ordinary disk file. However, in certain circumstances, the database might be stored in memory. The most common way to force an SQLite database to exist purely in memory is to open the database using the special filename ":memory:". In other words, instead of passing the name of a real disk file into one of the sqlite3_open(), sq
●
テクノロジー
●2018/05/17 10:19
55users
www.sqlite.org
1. Summary SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite(). Furthermore, a single SQLite database holding 10-kilobyte blobs uses about 20% less disk space than storing the blobs in individual files. The performance difference arises (we believe) because when working
●
テクノロジー
●2017/06/14 13:12
●SQLite
●performance
●filesystem
●database
●あとで読む
●開発
●programming
3users
www.sqlite.org
General improvements: Enhanced WAL mode so that it works efficiently with transactions that are larger than the cache_size. Added the FTS5 detail option. Added the "EXTRA" option to PRAGMA synchronous that does a sync of the containing directory when a rollback journal is unlinked in DELETE mode, for better durability. The SQLITE_EXTRA_DURABLE compile-time option enables PRAGMA synchronous=EXTRA b
●
テクノロジー
●2016/02/18 22:53
●あとで読む
4users
www.sqlite.org
Policy Changes: The version numbering conventions for SQLite are revised to use the emerging standard of semantic versioning. New Features And Enhancements: Added the json1 extension module in the source tree, and in the amalgamation. Enable support using the SQLITE_ENABLE_JSON1 compile-time option. Added Full Text Search version 5 (FTS5) to the amalgamation, enabled using SQLITE_ENABLE_FTS5. FTS5
●
テクノロジー
●2015/10/15 14:25
●sqlite
36users
www.sqlite.org
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
●
テクノロジー
●2015/10/15 10:48
●SQLite
●json
●db
●Database
●tech
●javascript
5users
www.sqlite.org
SQLite As An Application File Format Executive Summary An SQLite database file with a defined schema often makes an excellent application file format. Here are a dozen reasons why this is so: Simplified Application Development Single-File Documents High-Level Query Language Accessible Content Cross-Platform Atomic Transactions Incremental And Continuous Updates Easily Extensible Performance Concur
●
テクノロジー
●2015/10/01 16:59
5users
www.sqlite.org
1. Overview of FTS5 FTS5 is an SQLite virtual table module that provides full-text search functionality to database applications. In their most elementary form, full-text search engines allow the user to efficiently search a large collection of documents for the subset that contain one or more instances of a search term. The search functionality provided to world wide web users by Google is, among
●
テクノロジー
●2015/08/10 10:20
8users
www.sqlite.org
Common Table Expressions or CTEs act like temporary views that exist only for the duration of a single SQL statement. There are two kinds of common table expressions: "ordinary" and "recursive". Ordinary common table expressions are helpful for making queries easier to understand by factoring subqueries out of the main SQL statement. Recursive common table expressions provide the ability to do hie
●
テクノロジー
●2014/08/04 17:25
●sqlite
●sql
3users
www.sqlite.org
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
●
テクノロジー
●2014/05/30 12:54
●SQLite
12users
www.sqlite.org
1. Getting Started The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive. This document provides a brief introduction on how to use the sqlite3 program. Start the sqlite3 program by typing "sqlite3" at the command prompt, optionally fol
●
テクノロジー
●2014/05/03 09:35
●SQLite
●DB
●あとで読む
5users
www.sqlite.org
Internal Versus External BLOBs in SQLite If you have a database of large BLOBs, do you get better read performance when you store the complete BLOB content directly in the database or is it faster to store each BLOB in a separate file and store just the corresponding filename in the database? To try to answer this, we ran 49 test cases with various BLOB sizes and SQLite page sizes on a Linux works
●
テクノロジー
●2013/12/09 15:41
●SQLite
●開発
25users
www.sqlite.org
Overview An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully automatic and does not require any action on the part of the user or the a
●
テクノロジー
●2013/10/20 00:21
●sqlite
●DB
●開発
●programming
●あとで読む
5users
www.sqlite.org
1. Introduction The task of the "query planner" is to figure out the best algorithm or "query plan" to accomplish an SQL statement. Beginning with SQLite version 3.8.0 (2013-08-26), the query planner component has been rewritten so that it runs faster and generates better plans. The rewrite is called the "next generation query planner" or "NGQP". This article overviews the importance of query plan
●
テクノロジー
●2013/08/27 10:36
●development
●*あとで
3users
www.sqlite.org
1. URI Filenames In SQLite Beginning with version 3.7.7 (2011-06-23), the SQLite database file argument to the sqlite3_open(), sqlite3_open16(), and sqlite3_open_v2() interfaces and to the ATTACH command can be specified either as an ordinary filename or as a Uniform Resource Identifier or URI. The advantage of using a URI filename is that query parameters on the URI can be used to control details
●
テクノロジー
●2013/08/05 15:51
●Tech
5users
www.sqlite.org
Memory-Mapped I/O The default mechanism by which SQLite accesses and updates database disk files is the xRead() and xWrite() methods of the sqlite3_io_methods VFS object. These methods are typically implemented as "read()" and "write()" system calls which cause the operating system to copy disk content between the kernel buffer cache and user space. Beginning with version 3.7.17 (2013-05-20), SQLi
●
テクノロジー
●2013/05/27 00:40
●sqlite
●mmap
●*あとで
3users
www.sqlite.org
Editorial Note: This document was written in 2004 as a guide to programmers who were transitioning from SQLite2 to SQLite3. It is retained as part of the historical record of SQLite. Modern programmers should refer to more up-to-date documentation on SQLite available elsewhere on this website. SQLite version 3.0 introduces important changes to the library, including: A more compact format for data
●
テクノロジー
●2012/11/11 00:42
●SQLite
●db
●開発
●プログラミング
5users
www.sqlite.org
This document describes and defines the on-disk database file format used by all releases of SQLite since version 3.0.0 (2004-06-18). 1. The Database File The complete state of an SQLite database is usually contained in a single file on disk called the "main database file". During a transaction, SQLite stores additional information in a second file called the "rollback journal", or if SQLite is in
●
テクノロジー
●2012/09/18 14:42
●sqlite
14users
www.sqlite.org
1.0 Executive Summary SQLite4 is a compact, self-contained, zero-adminstration, ACID database engine in a library, just like SQLite3, but with an improved interface and file format. The run-time environment is encapsulated in an object. A greatly simplified Key/Value storage engine is used: A single large key space - not separate key spaces for each table and index as in SQLite3. Keys sort in lexi
●
テクノロジー
●2012/06/28 05:32
●sqlite
●db
●Programming
4users
www.sqlite.org
Overview The best feature of SQL (in all its implementations, not just SQLite) is that it is a declarative language, not a procedural language. When programming in SQL you tell the system what you want to compute, not how to compute it. The task of figuring out the how is delegated to the query planner subsystem within the SQL database engine. For any given SQL statement, there might be hundreds o
●
テクノロジー
●2011/11/12 10:21
●SQLite
●DataBase
3users
www.sqlite.org
1. The EXPLAIN QUERY PLAN Command Warning: The data returned by the EXPLAIN QUERY PLAN command is intended for interactive debugging only. The output format may change between SQLite releases. Applications should not depend on the output format of the EXPLAIN QUERY PLAN command. Alert: As warned above, the EXPLAIN QUERY PLAN output format did change substantially with the version 3.24.0 release (2
●
テクノロジー
●2011/11/09 11:49
●DataBase
9users
www.sqlite.org
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
●
テクノロジー
●2011/07/30 06:06
●sqlite
●db
●database
3users
www.sqlite.org
The DELETE command removes records from the table identified by the qualified-table-name. If the WHERE clause is not present, all records in the table are deleted. If a WHERE clause is supplied, then only those rows for which the WHERE clause boolean expression is true are deleted. Rows for which the expression is false or NULL are retained. 2. Restrictions on DELETE Statements Within CREATE TRIGG
●
テクノロジー
●2010/12/09 18:00
13users
www.sqlite.org
1. Overview The default method by which SQLite implements atomic commit and rollback is a rollback journal. Beginning with version 3.7.0 (2010-07-21), a new "Write-Ahead Log" option (hereafter referred to as "WAL") is available. There are advantages and disadvantages to using WAL instead of a rollback journal. Advantages include: WAL is significantly faster in most scenarios. WAL provides more con
●
テクノロジー
●2010/07/22 12:10
●sqlite
●wal
●database
●algorithm
9users
www.sqlite.org
1. Introduction The reliability and robustness of SQLite is achieved in part by thorough and careful testing. As of version 3.42.0 (2023-05-16), the SQLite library consists of approximately 155.8 KSLOC of C code. (KSLOC means thousands of "Source Lines Of Code" or, in other words, lines of code excluding blank lines and comments.) By comparison, the project has 590 times as much test code and test
●
テクノロジー
●2010/04/22 01:03
●sqlite
●opensource
●testing
●test
次のページ
このページはまだ
ブックマークされていません
このページを最初にブックマークしてみませんか?
﹃SQLite Home Page﹄の新着エントリーを見る
キーボードショートカット一覧
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
●総合
●一般
●世の中
●政治と経済
●暮らし
●学び
●テクノロジー
●エンタメ
●アニメとゲーム
●おもしろ
●アプリ・拡張機能
●開発ブログ
●ヘルプ
●お問い合わせ
●ガイドライン
●利用規約
●プライバシーポリシー
●利用者情報の外部送信について
●ガイドライン
●利用規約
●プライバシーポリシー
●利用者情報の外部送信について
●公式アカウント
●ホットエントリー
●はてなブログ
●はてなブログPro
●人力検索はてな
●はてなブログ タグ
●はてなニュース
●ソレドコ
Copyright © 2005-2024 Hatena. All Rights Reserved.
設定を変更しましたx