Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Merge fixes from the 3.32 branch. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
bd3dff05f9900c4c1bea5e871fc6da44 |
| User & Date: | drh 2020-07-15 01:43:13 |
Context
|
2020-07-15
| ||
| 15:03 | Tweaks to the floatingpoint.html page. (check-in: dcd828be81 user: drh tags: trunk) | |
| 01:43 | Merge fixes from the 3.32 branch. (check-in: bd3dff05f9 user: drh tags: trunk) | |
| 01:42 | Update the change log. Typo fixes in the floating-point documentation. (check-in: 846fd3a3f7 user: drh tags: trunk) | |
|
2020-07-11
| ||
| 00:03 | Fix hyperlink problem in the lang.html page. (check-in: afb2b13396 user: drh tags: branch-3.32) | |
Changes
Changes to pages/lang.in.
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
{DELETE delete}
{UPDATE update}
{SELECT select}
{{WITH clause} withclause}
{comment comment}
{EXPLAIN explain}
{expression expr}
{{BEGIN TRANSACTION} transaction}
{{COMMIT TRANSACTION} transaction COMMIT}
{{END TRANSACTION} transaction COMMIT}
{{ROLLBACK TRANSACTION} transaction ROLLBACK}
{SAVEPOINT savepoint}
{{RELEASE SAVEPOINT} savepoint SAVEPOINT}
{PRAGMA pragma.html}
{{ON CONFLICT clause} conflict}
|
| |
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
{DELETE delete}
{UPDATE update}
{SELECT select}
{{WITH clause} withclause}
{comment comment}
{EXPLAIN explain}
{expression expr}
{{BEGIN TRANSACTION} transaction COMMIT}
{{COMMIT TRANSACTION} transaction COMMIT}
{{END TRANSACTION} transaction COMMIT}
{{ROLLBACK TRANSACTION} transaction ROLLBACK}
{SAVEPOINT savepoint}
{{RELEASE SAVEPOINT} savepoint SAVEPOINT}
{PRAGMA pragma.html}
{{ON CONFLICT clause} conflict}
|
Changes to pages/sharedcache.in.
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
...
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
|
serialize concurrent access attempts on a per-table basis. Tables support
two types of locks, "read-locks" and "write-locks". Locks are granted to
connections - at any one time, each database connection has either a
read-lock, write-lock or no lock on each database table.
</p>
<p>At any one time, a single table may have any number of active read-locks
or a single active write lock. To read data a table, a connection must
first obtain a read-lock. To write to a table, a connection must obtain a
write-lock on that table. If a required table lock cannot be obtained,
the query fails and SQLITE_LOCKED is returned to the caller.
</p>
<p>Once a connection obtains a table lock, it is not released until the
current transaction (read or write) is concluded.
................................................................................
<h1>Shared Cache And In-Memory Databases</h1>
<p>
Beginning with SQLite [version 3.7.13] ([dateof:3.7.13]),
shared cache can be used on
[in-memory databases], provided that the database is created using
a [URI filename]. For backwards compatibility, shared cache is always
disable for in-memory
databases if the unadorned name ":memory:" is used to open the database.
Prior to version 3.7.13, shared cache was always
disabled for in-memory databases regardless of the database name used,
current system shared cache setting, or query parameters or flags.
</p>
<p>
Enabling shared-cache for an in-memory database allows two or more
database connections in the same process to have access to the same
in-memory database. An in-memory database in shared cache is automatically
deleted and memory is reclaimed when the last connection to that database
closes.
</p>
|
|
|
|
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
...
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
|
serialize concurrent access attempts on a per-table basis. Tables support two types of locks, "read-locks" and "write-locks". Locks are granted to connections - at any one time, each database connection has either a read-lock, write-lock or no lock on each database table. </p> <p>At any one time, a single table may have any number of active read-locks or a single active write lock. To read data from a table, a connection must first obtain a read-lock. To write to a table, a connection must obtain a write-lock on that table. If a required table lock cannot be obtained, the query fails and SQLITE_LOCKED is returned to the caller. </p> <p>Once a connection obtains a table lock, it is not released until the current transaction (read or write) is concluded. ................................................................................ <h1>Shared Cache And In-Memory Databases</h1> <p> Beginning with SQLite [version 3.7.13] ([dateof:3.7.13]), shared cache can be used on [in-memory databases], provided that the database is created using a [URI filename]. For backwards compatibility, shared cache is always disabled for in-memory databases if the unadorned name ":memory:" is used to open the database. Prior to version 3.7.13, shared cache was always disabled for in-memory databases regardless of the database name used, current system shared cache setting, or query parameters or flags. </p> <p> Enabling shared-cache for an in-memory database allows two or more database connections in the same process to have access to the same in-memory database. An in-memory database in shared cache is automatically deleted and memory is reclaimed when the last connection to that database closes. </p> |