Documentation Source Text

Check-in [cecf106465]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Further refinement to the loadable extension documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: cecf106465fc162e22c95e846e12df0430ca42a7
User & Date: drh 2017-03-15 20:32:08
Context
2017-03-15
20:51
Update the details of when the LIKE optimization is allowed, due to enhancements to the LIKE optimization logic in 3.18.0. check-in: 7c122e0975 user: drh tags: trunk
20:32
Further refinement to the loadable extension documentation. check-in: cecf106465 user: drh tags: trunk
15:59
Improvements to CLI documentation. Expand the Examples section of the loadable extension document. check-in: d2d3de4f3f user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/loadext.in.

248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
[https://www.sqlite.org/src/file/ext/misc/series.c|series.c] —
Implementation of the generate_series [virtual table] and
[table-valued function].  This is a relatively simple example of a
virtual table implementation which can serve as a template for writing
new virtual tables.
</ul>




<tcl>hd_fragment persist {persistent loadable extensions}</tcl>
<h1>Persistent Loadable Extensions</h1>

<p>The default behavior for a loadable extension is that it is unloaded
from process memory when the database connection that originally invoked
[sqlite3_load_extension()] closes.  (In other words, the xDlUnload method 







|
|







248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
[https://www.sqlite.org/src/file/ext/misc/series.c|series.c] &mdash;
Implementation of the generate_series [virtual table] and
[table-valued function].  This is a relatively simple example of a
virtual table implementation which can serve as a template for writing
new virtual tables.
</ul>

<p>Other and more complex extensions can be found in subfolders
under [https://www.sqlite.org/src/file/ext|ext/] other than ext/misc/.

<tcl>hd_fragment persist {persistent loadable extensions}</tcl>
<h1>Persistent Loadable Extensions</h1>

<p>The default behavior for a loadable extension is that it is unloaded
from process memory when the database connection that originally invoked
[sqlite3_load_extension()] closes.  (In other words, the xDlUnload method