Documentation Source Text

Check-in [27bb41c97d]
Login

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

Overview
Comment:Enhancements to the "cintro.html" document.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 27bb41c97d8a3d1ed4a421c69bf3d4dad11f41d0
User & Date: drh 2016-09-12 18:07:53
Context
2016-09-12
18:10
Update the news for the 3.14.2 release. check-in: 3270d5018f user: drh tags: trunk
18:07
Enhancements to the "cintro.html" document. check-in: 27bb41c97d user: drh tags: trunk
17:49
Minor wording improvements in the application file format document. check-in: 511e39cbb5 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/capi3ref.in.

456
457
458
459
460
461
462

463
464
465
466
467
468
469
470
471
472

473
474
475
476
477
478
479
...
483
484
485
486
487
488
489



490
491
492
493
494
495
496
hd_enable_main 1
hd_close_aux
hd_putsnl {<hr>}

# Do a table of contents for functions
#
set funclist {}

foreach c $content {
  foreach {key title type keywords body code} $c break
  if {$type!="function"} continue
  set keywords [lsort $keywords]
  set k [preferred_keyword $keywords]
  set s $supported($k)
  foreach kw $keywords {
    if {[regexp {^sqlite} $kw]} {
      lappend funclist [list $kw $kw $s]
      set uri [convert_keyword_to_uri $kw]

      dbtoc eval {INSERT INTO toc(name,type,status,title,uri)
                   VALUES($kw,'function',$s,$title,$uri)}
    }
  }
}
hd_open_aux c3ref/funclist.html
hd_header {List Of SQLite Functions}
................................................................................
hd_enable_main 1
</tcl>
<h2>List Of Functions:</h2>
<p>Note: Functions marked with "<small><i>(exp)</i></small>"
are [experimental] and functions whose names are
<s>struck through</s> are [deprecated].</p>
<tcl>



set funclist [lsort -index 1 $funclist]
hd_list_of_links {} 315 $funclist
hd_enable_main 0
hd_putsnl {<p>Other lists:
<a href="constlist.html">Constants</a> and
<a href="objlist.html">Objects</a> and
<a href="../rescode.html">Result Codes</a></p>}







>










>







 







>
>
>







456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
...
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
hd_enable_main 1
hd_close_aux
hd_putsnl {<hr>}

# Do a table of contents for functions
#
set funclist {}
unset -nocomplain funccnts
foreach c $content {
  foreach {key title type keywords body code} $c break
  if {$type!="function"} continue
  set keywords [lsort $keywords]
  set k [preferred_keyword $keywords]
  set s $supported($k)
  foreach kw $keywords {
    if {[regexp {^sqlite} $kw]} {
      lappend funclist [list $kw $kw $s]
      set uri [convert_keyword_to_uri $kw]
      incr funccnts($s)
      dbtoc eval {INSERT INTO toc(name,type,status,title,uri)
                   VALUES($kw,'function',$s,$title,$uri)}
    }
  }
}
hd_open_aux c3ref/funclist.html
hd_header {List Of SQLite Functions}
................................................................................
hd_enable_main 1
</tcl>
<h2>List Of Functions:</h2>
<p>Note: Functions marked with "<small><i>(exp)</i></small>"
are [experimental] and functions whose names are
<s>struck through</s> are [deprecated].</p>
<tcl>
hd_putsnl "<!-- number of functions: $funccnts(0) -->"
hd_putsnl "<!-- number of deprecated functions: $funccnts(2) -->"
hd_putsnl "<!-- number of experimental functions: $funccnts(1) -->"
set funclist [lsort -index 1 $funclist]
hd_list_of_links {} 315 $funclist
hd_enable_main 0
hd_putsnl {<p>Other lists:
<a href="constlist.html">Constants</a> and
<a href="objlist.html">Objects</a> and
<a href="../rescode.html">Result Codes</a></p>}

Changes to pages/cintro.in.

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
[sqlite3_column_int|sqlite3_column()], and [sqlite3_finalize()] for
a string of one or more SQL statements.
</ul>

<h1>Introduction</h1>

<p>
  SQLite currently has over 200 distinct APIs.
  This can be overwhelming to a new programmer.
  Fortunately, most of the interfaces are very specialized
  and need not be considered by beginners.
  The core API is small, simple, and easy to learn.
  This article summarizes the core API.
</p>

<p>
  A separate document, [capi3ref | The SQLite C/C++ Interface],
  provides detailed







|
|
<
|







52
53
54
55
56
57
58
59
60

61
62
63
64
65
66
67
68
[sqlite3_column_int|sqlite3_column()], and [sqlite3_finalize()] for
a string of one or more SQL statements.
</ul>

<h1>Introduction</h1>

<p>
  SQLite has more than 225 APIs.
  However, most of the APIs are optional and very specialized

  and can be ignored by beginners.
  The core API is small, simple, and easy to learn.
  This article summarizes the core API.
</p>

<p>
  A separate document, [capi3ref | The SQLite C/C++ Interface],
  provides detailed