This file is indexed.

/usr/share/doc/python-apsw/html/changes.html is in python-apsw-doc 3.16.2-r1-2build2.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  49
  50
  51
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
  63
  64
  65
  66
  67
  68
  69
  70
  71
  72
  73
  74
  75
  76
  77
  78
  79
  80
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  91
  92
  93
  94
  95
  96
  97
  98
  99
 100
 101
 102
 103
 104
 105
 106
 107
 108
 109
 110
 111
 112
 113
 114
 115
 116
 117
 118
 119
 120
 121
 122
 123
 124
 125
 126
 127
 128
 129
 130
 131
 132
 133
 134
 135
 136
 137
 138
 139
 140
 141
 142
 143
 144
 145
 146
 147
 148
 149
 150
 151
 152
 153
 154
 155
 156
 157
 158
 159
 160
 161
 162
 163
 164
 165
 166
 167
 168
 169
 170
 171
 172
 173
 174
 175
 176
 177
 178
 179
 180
 181
 182
 183
 184
 185
 186
 187
 188
 189
 190
 191
 192
 193
 194
 195
 196
 197
 198
 199
 200
 201
 202
 203
 204
 205
 206
 207
 208
 209
 210
 211
 212
 213
 214
 215
 216
 217
 218
 219
 220
 221
 222
 223
 224
 225
 226
 227
 228
 229
 230
 231
 232
 233
 234
 235
 236
 237
 238
 239
 240
 241
 242
 243
 244
 245
 246
 247
 248
 249
 250
 251
 252
 253
 254
 255
 256
 257
 258
 259
 260
 261
 262
 263
 264
 265
 266
 267
 268
 269
 270
 271
 272
 273
 274
 275
 276
 277
 278
 279
 280
 281
 282
 283
 284
 285
 286
 287
 288
 289
 290
 291
 292
 293
 294
 295
 296
 297
 298
 299
 300
 301
 302
 303
 304
 305
 306
 307
 308
 309
 310
 311
 312
 313
 314
 315
 316
 317
 318
 319
 320
 321
 322
 323
 324
 325
 326
 327
 328
 329
 330
 331
 332
 333
 334
 335
 336
 337
 338
 339
 340
 341
 342
 343
 344
 345
 346
 347
 348
 349
 350
 351
 352
 353
 354
 355
 356
 357
 358
 359
 360
 361
 362
 363
 364
 365
 366
 367
 368
 369
 370
 371
 372
 373
 374
 375
 376
 377
 378
 379
 380
 381
 382
 383
 384
 385
 386
 387
 388
 389
 390
 391
 392
 393
 394
 395
 396
 397
 398
 399
 400
 401
 402
 403
 404
 405
 406
 407
 408
 409
 410
 411
 412
 413
 414
 415
 416
 417
 418
 419
 420
 421
 422
 423
 424
 425
 426
 427
 428
 429
 430
 431
 432
 433
 434
 435
 436
 437
 438
 439
 440
 441
 442
 443
 444
 445
 446
 447
 448
 449
 450
 451
 452
 453
 454
 455
 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
 482
 483
 484
 485
 486
 487
 488
 489
 490
 491
 492
 493
 494
 495
 496
 497
 498
 499
 500
 501
 502
 503
 504
 505
 506
 507
 508
 509
 510
 511
 512
 513
 514
 515
 516
 517
 518
 519
 520
 521
 522
 523
 524
 525
 526
 527
 528
 529
 530
 531
 532
 533
 534
 535
 536
 537
 538
 539
 540
 541
 542
 543
 544
 545
 546
 547
 548
 549
 550
 551
 552
 553
 554
 555
 556
 557
 558
 559
 560
 561
 562
 563
 564
 565
 566
 567
 568
 569
 570
 571
 572
 573
 574
 575
 576
 577
 578
 579
 580
 581
 582
 583
 584
 585
 586
 587
 588
 589
 590
 591
 592
 593
 594
 595
 596
 597
 598
 599
 600
 601
 602
 603
 604
 605
 606
 607
 608
 609
 610
 611
 612
 613
 614
 615
 616
 617
 618
 619
 620
 621
 622
 623
 624
 625
 626
 627
 628
 629
 630
 631
 632
 633
 634
 635
 636
 637
 638
 639
 640
 641
 642
 643
 644
 645
 646
 647
 648
 649
 650
 651
 652
 653
 654
 655
 656
 657
 658
 659
 660
 661
 662
 663
 664
 665
 666
 667
 668
 669
 670
 671
 672
 673
 674
 675
 676
 677
 678
 679
 680
 681
 682
 683
 684
 685
 686
 687
 688
 689
 690
 691
 692
 693
 694
 695
 696
 697
 698
 699
 700
 701
 702
 703
 704
 705
 706
 707
 708
 709
 710
 711
 712
 713
 714
 715
 716
 717
 718
 719
 720
 721
 722
 723
 724
 725
 726
 727
 728
 729
 730
 731
 732
 733
 734
 735
 736
 737
 738
 739
 740
 741
 742
 743
 744
 745
 746
 747
 748
 749
 750
 751
 752
 753
 754
 755
 756
 757
 758
 759
 760
 761
 762
 763
 764
 765
 766
 767
 768
 769
 770
 771
 772
 773
 774
 775
 776
 777
 778
 779
 780
 781
 782
 783
 784
 785
 786
 787
 788
 789
 790
 791
 792
 793
 794
 795
 796
 797
 798
 799
 800
 801
 802
 803
 804
 805
 806
 807
 808
 809
 810
 811
 812
 813
 814
 815
 816
 817
 818
 819
 820
 821
 822
 823
 824
 825
 826
 827
 828
 829
 830
 831
 832
 833
 834
 835
 836
 837
 838
 839
 840
 841
 842
 843
 844
 845
 846
 847
 848
 849
 850
 851
 852
 853
 854
 855
 856
 857
 858
 859
 860
 861
 862
 863
 864
 865
 866
 867
 868
 869
 870
 871
 872
 873
 874
 875
 876
 877
 878
 879
 880
 881
 882
 883
 884
 885
 886
 887
 888
 889
 890
 891
 892
 893
 894
 895
 896
 897
 898
 899
 900
 901
 902
 903
 904
 905
 906
 907
 908
 909
 910
 911
 912
 913
 914
 915
 916
 917
 918
 919
 920
 921
 922
 923
 924
 925
 926
 927
 928
 929
 930
 931
 932
 933
 934
 935
 936
 937
 938
 939
 940
 941
 942
 943
 944
 945
 946
 947
 948
 949
 950
 951
 952
 953
 954
 955
 956
 957
 958
 959
 960
 961
 962
 963
 964
 965
 966
 967
 968
 969
 970
 971
 972
 973
 974
 975
 976
 977
 978
 979
 980
 981
 982
 983
 984
 985
 986
 987
 988
 989
 990
 991
 992
 993
 994
 995
 996
 997
 998
 999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    
    <title>Change History &#8212; APSW 3.16.2-r1 documentation</title>
    
    <link rel="stylesheet" href="_static/classic.css" type="text/css" />
    <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
    
    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    './',
        VERSION:     '3.16.2-r1',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  true
      };
    </script>
    <script type="text/javascript" src="_static/jquery.js"></script>
    <script type="text/javascript" src="_static/underscore.js"></script>
    <script type="text/javascript" src="_static/doctools.js"></script>
    <link rel="index" title="Index" href="genindex.html" />
    <link rel="search" title="Search" href="search.html" />
    <link rel="copyright" title="Copyright" href="copyright.html" />
    <link rel="top" title="APSW 3.16.2-r1 documentation" href="index.html" />
    <link rel="prev" title="Copyright and License" href="copyright.html" />
 
<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-26815066-1']);
  _gaq.push(['_trackPageview']);
</script>

  </head>
  <body role="document">
    <div class="related" role="navigation" aria-label="related navigation">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="genindex.html" title="General Index"
             accesskey="I">index</a></li>
        <li class="right" >
          <a href="py-modindex.html" title="Python Module Index"
             >modules</a> |</li>
        <li class="right" >
          <a href="copyright.html" title="Copyright and License"
             accesskey="P">previous</a> |</li>
        <li class="nav-item nav-item-0"><a href="index.html">APSW 3.16.2-r1 documentation</a> &#187;</li> 
      </ul>
    </div>  

    <div class="document">
      <div class="documentwrapper">
        <div class="bodywrapper">
          <div class="body" role="main">
            
  <div class="section" id="change-history">
<h1>Change History<a class="headerlink" href="#change-history" title="Permalink to this headline"></a></h1>
<div class="section" id="r1">
<h2>3.16.2-r1<a class="headerlink" href="#r1" title="Permalink to this headline"></a></h2>
<p>Python 3.6 builds added.</p>
<p>Added SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE and SQLITE_FCNTL_PDB constants.</p>
</div>
<div class="section" id="id1">
<h2>3.15.2-r1<a class="headerlink" href="#id1" title="Permalink to this headline"></a></h2>
<p>No APSW changes.</p>
</div>
<div class="section" id="id2">
<h2>3.15.1-r1<a class="headerlink" href="#id2" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_FCNTL_WIN32_GET_HANDLE constant.</p>
</div>
<div class="section" id="id3">
<h2>3.15.0-r1<a class="headerlink" href="#id3" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_DBCONFIG_MAINDBNAME constant.</p>
</div>
<div class="section" id="id4">
<h2>3.14.1-r1<a class="headerlink" href="#id4" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_DBSTATUS_CACHE_USED_SHARED and SQLITE_OK_LOAD_PERMANENTLY constants.</p>
</div>
<div class="section" id="id5">
<h2>3.13.0-r1<a class="headerlink" href="#id5" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION constant.</p>
<p>Added a <a class="reference internal" href="download.html#really-want-pip"><span class="std std-ref">pip command line</span></a> in the <a class="reference internal" href="download.html"><span class="doc">Download</span></a> page.</p>
</div>
<div class="section" id="id6">
<h2>3.12.2-r1<a class="headerlink" href="#id6" title="Permalink to this headline"></a></h2>
<p>Call <a class="reference external" href="https://www.python.org/dev/peps/pep-0393/#new-api">PyUnicode_READY</a> for
Python 3.3 onwards.  Fixes <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/208">APSW issue 208</a>, <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/132">APSW issue 132</a>, <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/168">APSW issue 168</a>.</p>
<p>SQLite 3.12 completely changed the semantics of <a class="reference internal" href="vfs.html#apsw.VFS.xGetLastError" title="apsw.VFS.xGetLastError"><code class="xref py py-meth docutils literal"><span class="pre">VFS.xGetLastError()</span></code></a> in an
incompatible way.  This required a rewrite of the relevant C, Python and test
code.  If you implement or use this method then you have to rewrite your code
too.  Also note that running the test suite from an earlier version of APSW
against this or future SQLite versions will result in consuming all memory, swap
or address space (an underlying integer changed meaning).</p>
<p>Added SQLITE_CONFIG_STMTJRNL_SPILL and SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
constants.</p>
<p>Added support for SQLITE_CONFIG_STMTJRNL_SPILL in <a class="reference internal" href="apsw.html#apsw.config" title="apsw.config"><code class="xref py py-meth docutils literal"><span class="pre">apsw.config()</span></code></a>.</p>
</div>
<div class="section" id="id7">
<h2>3.11.1-r1<a class="headerlink" href="#id7" title="Permalink to this headline"></a></h2>
<p>setup.py attempts to use setuptools if present, before falling back to
distutils. This allows setuptools only commands such as bdist_wheel to work. You
can force use of distutils by setting the environment variable
APSW_FORCE_DISTUTILS to any value. Note that setuptools may also affect the
output file names. (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/207">APSW issue 207</a>)</p>
</div>
<div class="section" id="id8">
<h2>3.11.0-r1<a class="headerlink" href="#id8" title="Permalink to this headline"></a></h2>
<p>The shell dump command now outputs the page size and user version.  They were
both output before as comments.</p>
<p>Updated SQLite download logic for 2016 folder.</p>
<p>Updated VFS test suite due to changes in SQLite default VFS implemented methods.</p>
<p>Added SQLITE_INDEX_CONSTRAINT_LIKE, SQLITE_INDEX_CONSTRAINT_REGEXP,
SQLITE_INDEX_CONSTRAINT_GLOB, SQLITE_IOERR_AUTH, SQLITE_FCNTL_JOURNAL_POINTER,
and SQLITE_FCNTL_VFS_POINTER constants.</p>
<p>Allow <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> subclasses for backup api (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/199">APSW issue 199</a>).</p>
<p><a class="reference external" href="https://www.sqlite.org/fts5.html">FTS5</a> and <a class="reference external" href="https://www.sqlite.org/json1.html">JSON1</a> extensions are now built by default for
<a class="reference internal" href="build.html"><span class="doc">&#8211;enable-all-extensions</span></a>.  It is recommended you wait a few more
releases for these extensions to mature.</p>
<p>Added a mapping for <a class="reference external" href="https://sqlite.org/c3ref/c_index_scan_unique.html">virtual table scan flags</a></p>
<p>Use <a class="reference external" href="https://www.sqlite.org/compile.html#enable_api_armor">SQLITE_ENABLE_API_ARMOR</a> for extra error
checking.</p>
</div>
<div class="section" id="id9">
<h2>3.9.2-r1<a class="headerlink" href="#id9" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_IOERR_VNODE constant.</p>
<p>Windows builds for Python 3.5 are now provided.</p>
</div>
<div class="section" id="id10">
<h2>3.8.11.1-r1<a class="headerlink" href="#id10" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_FCNTL_RBU and SQLITE_FCNTL_ZIPVFS constants.</p>
<p>setup&#8217;s fetch command can now get arbitrary fossil versions.  For
example specify <code class="docutils literal"><span class="pre">fossil-e596a6b6</span></code>.</p>
<p>Update tests due to a change in Python 3.5 (exception returned with
invalid strings for system calls changed from TypeError to
ValueError).</p>
<p>Adjusted some internal detection related to the <a class="reference internal" href="apsw.html#apsw.fork_checker" title="apsw.fork_checker"><code class="xref py py-func docutils literal"><span class="pre">fork</span> <span class="pre">checker</span></code></a></p>
</div>
<div class="section" id="id11">
<h2>3.8.10.1-r1<a class="headerlink" href="#id11" title="Permalink to this headline"></a></h2>
<p>Added deterministic parameter to
<a class="reference internal" href="connection.html#apsw.Connection.createscalarfunction" title="apsw.Connection.createscalarfunction"><code class="xref py py-func docutils literal"><span class="pre">Connection.createscalarfunction()</span></code></a> (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/187">APSW issue 187</a>)</p>
<p>Switched to new SQLite API returning 64 bit values for <a class="reference internal" href="apsw.html#apsw.status" title="apsw.status"><code class="xref py py-func docutils literal"><span class="pre">status()</span></code></a>
(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/191">APSW issue 191</a>)</p>
</div>
<div class="section" id="id12">
<h2>3.8.9-r1<a class="headerlink" href="#id12" title="Permalink to this headline"></a></h2>
<p>Fixed column description caching which could be preserved between
multiple statements in the same execution (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/186">APSW issue 186</a>)</p>
<p>Updated documentation building tool to use new database of information
from the SQLite site.  This is simpler and more reliable.  (Previously
used site scraping.)</p>
<p>Added SQLITE_AUTH_USER, SQLITE_FCNTL_LAST_ERRNO,
SQLITE_FCNTL_WAL_BLOCK, SQLITE_FCNTL_GET_LOCKPROXYFILE, and
SQLITE_FCNTL_SET_LOCKPROXYFILE constants.</p>
<p>Removed SQLITE_GET_LOCKPROXYFILE, SQLITE_SET_LOCKPROXYFILE,
SQLITE_LAST_ERRNO file control constants.  These are deprecated - use
the versions with FCNTL in their name (eg
SQLITE_FCNTL_GET_LOCKPROXYFILE).</p>
<p>Added <a class="reference internal" href="apsw.html#sqliteconstants"><span class="std std-ref">mappings</span></a> for conflict resolution modes,
virtual table configuration options and xShmLock VFS flags.</p>
</div>
<div class="section" id="id13">
<h2>3.8.8.2-r1<a class="headerlink" href="#id13" title="Permalink to this headline"></a></h2>
<p>No APSW changes.</p>
</div>
<div class="section" id="id14">
<h2>3.8.8.1-r1<a class="headerlink" href="#id14" title="Permalink to this headline"></a></h2>
<p>The column description is now cached on first request during a query
so getting it is quick if called for every row.</p>
<p>Added SQLITE_CONFIG_PCACHE_HDRSZ and SQLITE_CONFIG_PMASZ constants, and
support for them in <a class="reference internal" href="apsw.html#apsw.config" title="apsw.config"><code class="xref py py-func docutils literal"><span class="pre">config()</span></code></a>.</p>
<p>Added SQLITE_CHECKPOINT_TRUNCATE constant.</p>
<p>Update year in various places to 2015.</p>
</div>
<div class="section" id="id15">
<h2>3.8.7.3-r1<a class="headerlink" href="#id15" title="Permalink to this headline"></a></h2>
<p>No APSW changes.</p>
</div>
<div class="section" id="id16">
<h2>3.8.7.2-r1<a class="headerlink" href="#id16" title="Permalink to this headline"></a></h2>
<p>Fixed parsing of icu-config flags</p>
</div>
<div class="section" id="id17">
<h2>3.8.7.1-r1<a class="headerlink" href="#id17" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_LIMIT_WORKER_THREADS constant</p>
</div>
<div class="section" id="id18">
<h2>3.8.6-r1<a class="headerlink" href="#id18" title="Permalink to this headline"></a></h2>
<p>Updated test suite for Python 3.4 unittest garbage collection changes
(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/164">APSW issue 164</a> <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/169">APSW issue 169</a>)</p>
<p>Using the <a class="reference internal" href="build.html#recommended-build"><span class="std std-ref">recommended</span></a> build option of
<strong>&#8211;enable-all-extensions</strong> turns on <a class="reference external" href="https://sqlite.org/compile.html#enable_stat4">STAT4</a>.  Windows binaries
include this too.</p>
</div>
<div class="section" id="id19">
<h2>3.8.5-r1<a class="headerlink" href="#id19" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_IOCAP_IMMUTABLE and SQLITE_FCNTL_WIN32_SET_HANDLE
constants.</p>
</div>
<div class="section" id="id20">
<h2>3.8.4.3-r1<a class="headerlink" href="#id20" title="Permalink to this headline"></a></h2>
<p>Added <a class="reference internal" href="cursor.html#apsw.Cursor.fetchone" title="apsw.Cursor.fetchone"><code class="xref py py-meth docutils literal"><span class="pre">Cursor.fetchone()</span></code></a></p>
</div>
<div class="section" id="id21">
<h2>3.8.4.2-r1<a class="headerlink" href="#id21" title="Permalink to this headline"></a></h2>
<p>No APSW code changes.  Rebuild due to updated SQLite version.</p>
</div>
<div class="section" id="id22">
<h2>3.8.4.1-r1<a class="headerlink" href="#id22" title="Permalink to this headline"></a></h2>
<p>Windows 64 bit binary builds for Python 3.3+ are back - thanks to
Mike C. Fletcher for <a class="reference external" href="http://blog.vrplumber.com/b/2014/02/12/step-2-get-amd64-compatible-vs-2010/">pointing the way</a></p>
<p>Correct detection of current SQLite version from download page for
<a class="reference internal" href="build.html"><span class="doc">setup.py</span></a> fetch command</p>
<p>Tested against Python 3.4 and binaries for Windows.</p>
</div>
<div class="section" id="id23">
<h2>3.8.3.1-r1<a class="headerlink" href="#id23" title="Permalink to this headline"></a></h2>
<p>Updated <a class="reference internal" href="shell.html"><span class="doc">Shell</span></a> completions for keywords, functions and pragmas.</p>
</div>
<div class="section" id="id24">
<h2>3.8.3-r1<a class="headerlink" href="#id24" title="Permalink to this headline"></a></h2>
<p>APSW is now hosted at Github - <a class="reference external" href="https://github.com/rogerbinns/apsw">https://github.com/rogerbinns/apsw</a></p>
<p>Added SQLITE_RECURSIVE, SQLITE_READONLY_DBMOVED,
SQLITE_FCNTL_COMMIT_PHASETWO, SQLITE_FCNTL_HAS_MOVED and
SQLITE_FCNTL_SYNC constants.</p>
</div>
<div class="section" id="id25">
<h2>3.8.2-r1<a class="headerlink" href="#id25" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_CONFIG_WIN32_HEAPSIZE, SQLITE_CONSTRAINT_ROWID and
SQLITE_FCNTL_TRACE constants.</p>
</div>
<div class="section" id="id26">
<h2>3.8.1-r1<a class="headerlink" href="#id26" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_CANTOPEN_CONVPATH and SQLITE_IOERR_CONVPATH extended
error codes.</p>
<p>Updated pysqlite urls to point to github.</p>
<p>Various minor build/download documentation updates.</p>
</div>
<div class="section" id="id27">
<h2>3.8.0.2-r1<a class="headerlink" href="#id27" title="Permalink to this headline"></a></h2>
<p>No APSW code changes.  Rebuild due to updated SQLite version.</p>
<p>Updated documentation tips to show how to <a class="reference internal" href="tips.html#diagnostics-tips"><span class="std std-ref">get detailed
diagnostics</span></a>.</p>
</div>
<div class="section" id="id28">
<h2>3.8.0.1-r1<a class="headerlink" href="#id28" title="Permalink to this headline"></a></h2>
<p>No APSW changes.  Rebuild due to updated SQLite version.</p>
<p>Windows binaries for Python 3.3 64 bit are no longer available as a
Visual Studio update obliterated the ability to compile them, and I
have no patience left to fight Microsoft&#8217;s tools.</p>
</div>
<div class="section" id="r2">
<h2>3.8.0-r2<a class="headerlink" href="#r2" title="Permalink to this headline"></a></h2>
<p>No APSW changes - updated checksums because SQLite changed the
released archive to address an autoconf issue on some platforms</p>
</div>
<div class="section" id="id29">
<h2>3.8.0-r1<a class="headerlink" href="#id29" title="Permalink to this headline"></a></h2>
<p>Windows binaries for Python 3.3 64 bit are now available after
managing to get several pieces of Microsoft software to cooperate.</p>
<p>Fixed shell dump issue when system routines (eg timestamp, username,
hostname) couldn&#8217;t automatically be promoted to unicode.  They are
used in comments in the output.  (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/142">APSW issue 142</a>)</p>
<p>Added SQLITE_DBSTATUS_DEFERRED_FKS, SQLITE_IOERR_GETTEMPPATH,
SQLITE_WARNING_AUTOINDEX and SQLITE_BUSY_SNAPSHOT constants.</p>
</div>
<div class="section" id="id30">
<h2>3.7.17-r1<a class="headerlink" href="#id30" title="Permalink to this headline"></a></h2>
<p>Removed tests that checked directly calling VFS read/write with
negative offsets or amounts returns errors.  This version of SQLite no
longer returns errors in those circumstances and typically crashes
instead.</p>
<p>Various new constants.</p>
</div>
<div class="section" id="id31">
<h2>3.7.16.2-r1<a class="headerlink" href="#id31" title="Permalink to this headline"></a></h2>
<p>No APSW changes - just a binary rebuild.  Windows users are
recommended to upgrade their SQLite version.</p>
</div>
<div class="section" id="id32">
<h2>3.7.16.1-r1<a class="headerlink" href="#id32" title="Permalink to this headline"></a></h2>
<p>Updated tables of functions and pragmas in the <a class="reference internal" href="shell.html"><span class="doc">Shell</span></a> to match
current SQLite version.</p>
</div>
<div class="section" id="id33">
<h2>3.7.16-r1<a class="headerlink" href="#id33" title="Permalink to this headline"></a></h2>
<p>Adjust to different SQLite download URLs</p>
<p>Added SQLITE_CONSTRAINT_* and SQLITE_READONLY_ROLLBACK <a class="reference external" href="https://www.sqlite.org/c3ref/c_abort_rollback.html">extended error
codes</a></p>
<p>Removed CouchDB virtual table</p>
</div>
<div class="section" id="id34">
<h2>3.7.15.2-r1<a class="headerlink" href="#id34" title="Permalink to this headline"></a></h2>
<p>No APSW changes - binary rebuild to pickup new SQLite version</p>
</div>
<div class="section" id="id35">
<h2>3.7.15.1-r1<a class="headerlink" href="#id35" title="Permalink to this headline"></a></h2>
<p>Use https (SSL) for SQLite web site references (downloads and
documentation links).  On some platforms/versions/SSL libraries,
Python&#8217;s SSL module <a class="reference external" href="https://www.google.com/webhp?q=python%20ssl%20EOF%20occurred%20in%20violation%20of%20protocol">doesn&#8217;t work</a>
with the SQLite website so a fallback to http is used - the downloads
still have their checksum verified.</p>
</div>
<div class="section" id="id36">
<h2>3.7.15-r1<a class="headerlink" href="#id36" title="Permalink to this headline"></a></h2>
<p>Work around changed semantics for error handling when the VFS xDelete
method is asked to delete a file that does not exist.</p>
<p>Completely removed all <a class="reference external" href="https://sqlite.org/asyncvfs.html">AsyncVFS</a> related code.  This extension
is <a class="reference external" href="https://sqlite.org/src/info/3d548db7eb">no longer maintained nor supported</a> by the SQLite team.
<a class="reference external" href="https://sqlite.org/wal.html">WAL</a> is a good way of getting
similar functionality.</p>
<p>Added <a class="reference internal" href="apsw.html#apsw.config" title="apsw.config"><code class="xref py py-func docutils literal"><span class="pre">config()</span></code></a> support for SQLITE_CONFIG_COVERING_INDEX_SCAN.</p>
<p>Added several new constants: SQLITE_CONFIG_COVERING_INDEX_SCAN,
SQLITE_CONFIG_SQLLOG, SQLITE_FCNTL_BUSYHANDLER,
SQLITE_FCNTL_TEMPFILENAME, SQLITE_CANTOPEN_FULLPATH,
SQLITE_IOERR_DELETE_NOENT</p>
</div>
<div class="section" id="id37">
<h2>3.7.14.1-r1<a class="headerlink" href="#id37" title="Permalink to this headline"></a></h2>
<p>Updated setup and test suite so that all files are explicitly closed
instead of relying on garbage collection.</p>
<p>Added Windows binaries for Python 3.3.  (Only 32 bit as Python doesn&#8217;t
provide a free way of making 64 bit Windows binaries.)</p>
<p>Updated setup.py to work with changed SQLite download page formatting
when detecting latest version.</p>
<p>Due to a <a class="reference external" href="http://bugs.python.org/issue16145">Python 3.3.0 regression bug</a> using the csv ouput mode in the
shell can result in bad data or Python crashing.  The bug has been
fixed for Python 3.3.1 which is due in November 2012.</p>
</div>
<div class="section" id="id38">
<h2>3.7.14-r2<a class="headerlink" href="#id38" title="Permalink to this headline"></a></h2>
<p>Fixed an issue with the GIL in the destructor for functions.  The bug
would be encountered if you create a function with the same name as an
existing function and are using an upcoming version of Python (eg
2.7.4).  Thanks to Arfrever Frehtes Taifersar Arahesis for finding it
(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/134">APSW issue 134</a>).</p>
<p>Added shell .print command to match upcoming SQLite shell changes.</p>
</div>
<div class="section" id="id39">
<h2>3.7.14-r1<a class="headerlink" href="#id39" title="Permalink to this headline"></a></h2>
<p>Added support for <a class="reference internal" href="connection.html#apsw.Connection.status" title="apsw.Connection.status"><code class="xref py py-meth docutils literal"><span class="pre">Connection.status()</span></code></a> (calls <a class="reference external" href="https://sqlite.org/c3ref/db_status.html">sqlite3_db_status</a>).</p>
<p>The legacy Windows <a class="reference external" href="http://en.wikipedia.org/wiki/Microsoft_Compiled_HTML_Help">Compiled Help Format</a>
documentation is no longer produced - the help compiler setup program
can&#8217;t cope with modern machines.</p>
</div>
<div class="section" id="id40">
<h2>3.7.13-r1<a class="headerlink" href="#id40" title="Permalink to this headline"></a></h2>
<p>Do not free a structure on failure to register a virtual table module
as SQLite does that anyway.</p>
<p>Added SQLITE_OPEN_MEMORY constant.</p>
</div>
<div class="section" id="id41">
<h2>3.7.12.1-r1<a class="headerlink" href="#id41" title="Permalink to this headline"></a></h2>
<p>No changes to APSW.  Binary rebuilds due to SQLite bugfixes.</p>
</div>
<div class="section" id="id42">
<h2>3.7.12-r1<a class="headerlink" href="#id42" title="Permalink to this headline"></a></h2>
<p>Re-enabled the asyncvfs.</p>
<p>Added <a class="reference internal" href="cursor.html#apsw.Cursor.description" title="apsw.Cursor.description"><code class="xref py py-attr docutils literal"><span class="pre">Cursor.description</span></code></a> to make DB API interoperability a
little easier (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/131">APSW issue 131</a>).</p>
<p>Added SQLITE_DBSTATUS_CACHE_WRITE and SQLITE_CANTOPEN_ISDIR constants.</p>
</div>
<div class="section" id="id43">
<h2>3.7.11-r1<a class="headerlink" href="#id43" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_ABORT_ROLLBACK and SQLITE_FCNTL_PRAGMA constants.</p>
<p>Added <a class="reference internal" href="connection.html#apsw.Connection.readonly" title="apsw.Connection.readonly"><code class="xref py py-meth docutils literal"><span class="pre">Connection.readonly()</span></code></a>.</p>
<p>Changed <a class="reference internal" href="connection.html#apsw.Connection.filename" title="apsw.Connection.filename"><code class="xref py py-attr docutils literal"><span class="pre">Connection.filename</span></code></a> which used to return the string
used to open the database and now returns the absolute pathname.</p>
<p>Added <a class="reference internal" href="connection.html#apsw.Connection.db_filename" title="apsw.Connection.db_filename"><code class="xref py py-meth docutils literal"><span class="pre">Connection.db_filename()</span></code></a>.</p>
</div>
<div class="section" id="id44">
<h2>3.7.10-r1<a class="headerlink" href="#id44" title="Permalink to this headline"></a></h2>
<p>The default sector size returned in VFS routines is 4,096 to match
SQLite&#8217;s new default.</p>
<p>Several links to SQLite tickets and documentation were updated
(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/122">APSW issue 122</a>).</p>
<p>The async vfs is disabled due to a bug in its code that leads to
random memory reads when dealing with filenames.</p>
<p>Added SQLITE_CONFIG_GETPCACHE2, SQLITE_CONFIG_GETPCACHE2,
SQLITE_FCNTL_POWERSAFE_OVERWRITE, SQLITE_FCNTL_VFSNAME and
SQLITE_IOCAP_POWERSAFE_OVERWRITE constants.</p>
<p>Fix shell dumping when SQLite doesn&#8217;t strip trailing comments from
view declarations (<a class="reference external" href="https://sqlite.org/src/info/c04a8b8a4f">discussed here</a>)</p>
<p>Added a <a class="reference internal" href="vfs.html#apsw.URIFilename" title="apsw.URIFilename"><code class="xref py py-class docutils literal"><span class="pre">URIFilename</span></code></a> class to encapsulate how SQLite provides
URI parameters to VFS routines (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/124">APSW issue 124</a>).</p>
<p>Compatibility break: Depending on flags your VFS xOpen method may get
a <a class="reference internal" href="vfs.html#apsw.URIFilename" title="apsw.URIFilename"><code class="xref py py-class docutils literal"><span class="pre">URIFilename</span></code></a> or a string for the filename.  You can still
pass either to the <a class="reference internal" href="vfs.html#apsw.VFSFile" title="apsw.VFSFile"><code class="xref py py-class docutils literal"><span class="pre">VFSFile</span></code></a>.</p>
<p>Compatibility break: The <a class="reference internal" href="vfs.html"><span class="doc">Virtual File System (VFS)</span></a> code used to always run strings
you provided through <a class="reference internal" href="vfs.html#apsw.VFS.xFullPathname" title="apsw.VFS.xFullPathname"><code class="xref py py-meth docutils literal"><span class="pre">VFS.xFullPathname()</span></code></a>.  This isn&#8217;t possible
with URI pathnames so that code has been removed.  If you construct
filenames for <a class="reference internal" href="vfs.html#apsw.VFS.xOpen" title="apsw.VFS.xOpen"><code class="xref py py-meth docutils literal"><span class="pre">VFS.xOpen()</span></code></a> directly (ie bypassing the SQLite
database open call) then you must call <a class="reference internal" href="vfs.html#apsw.VFS.xFullPathname" title="apsw.VFS.xFullPathname"><code class="xref py py-meth docutils literal"><span class="pre">VFS.xFullPathname()</span></code></a>
yourself first to ensure relative pathnames are turned into absolute
pathnames.  The SQLite API guarantees that filenames passed to
<a class="reference internal" href="vfs.html#apsw.VFS.xOpen" title="apsw.VFS.xOpen"><code class="xref py py-meth docutils literal"><span class="pre">VFS.xOpen()</span></code></a> are exactly what was returned from
<a class="reference internal" href="vfs.html#apsw.VFS.xFullPathname" title="apsw.VFS.xFullPathname"><code class="xref py py-meth docutils literal"><span class="pre">VFS.xFullPathname()</span></code></a>.</p>
</div>
<div class="section" id="id45">
<h2>3.7.9-r1<a class="headerlink" href="#id45" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_DBSTATUS_CACHE_HIT, SQLITE_DBSTATUS_CACHE_MISS and
SQLITE_FCNTL_OVERWRITE constants.</p>
</div>
<div class="section" id="id46">
<h2>3.7.8-r1<a class="headerlink" href="#id46" title="Permalink to this headline"></a></h2>
<p>Updated documentation and tests due to an undocumented change in VFS
xDelete semantics.</p>
<p>Added SQLITE3_FCNTL_PERSIST_WAL and SQLITE3_FCNTL_WIN32_AV_RETRY <a class="reference external" href="https://sqlite.org/c3ref/c_fcntl_chunk_size.html">file
controls</a>.</p>
<p>Wrapped sqlite3_sourceid (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/120">APSW issue 120</a>)</p>
</div>
<div class="section" id="id47">
<h2>3.7.7.1-r1<a class="headerlink" href="#id47" title="Permalink to this headline"></a></h2>
<p>Added <a class="reference external" href="https://sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiguri">SQLITE_CONFIG_URI</a>
and support for it in <a class="reference internal" href="apsw.html#apsw.config" title="apsw.config"><code class="xref py py-meth docutils literal"><span class="pre">config()</span></code></a>, and the open flag
<a class="reference external" href="https://sqlite.org/c3ref/c_open_autoproxy.html">SQLITE_OPEN_URI</a>.  This makes it
easy to use <a class="reference external" href="https://sqlite.org/uri.html">URI filenames</a>.</p>
<p>The <a class="reference internal" href="shell.html#shell"><span class="std std-ref">Shell</span></a> now uses <a class="reference external" href="https://sqlite.org/uri.html">URI filenames</a> by default.</p>
<p>New <a class="reference external" href="https://sqlite.org/c3ref/c_busy_recovery.html">extended error constants</a>:
SQLITE_CORRUPT_VTAB, SQLITE_IOERR_SEEK, SQLITE_IOERR_SHMMAP,
SQLITE_READONLY_CANTLOCK and SQLITE_READONLY_RECOVERY.</p>
<p>64 bit platforms
(<a class="reference external" href="http://en.wikipedia.org/wiki/64-bit#Specific_C-language_data_models">LP64 - most non-Windows</a>)
and Python 2: The Python int type is returned for 64 bit integers
instead of Python long type.</p>
</div>
<div class="section" id="id48">
<h2>3.7.6.3-r1<a class="headerlink" href="#id48" title="Permalink to this headline"></a></h2>
<p>When invoking the shell by calling <a class="reference internal" href="apsw.html#apsw.main" title="apsw.main"><code class="xref py py-func docutils literal"><span class="pre">apsw.main()</span></code></a> it will not
become interactive if you supply SQL commands as command line
arguments.  This is to have the same behaviour as the SQLite shell
(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/115">APSW issue 115</a>).</p>
<p>The shell has a <em>.find</em> command making it easy to search for values
across all columns of some or all tables.</p>
<p>The shell has a <em>.autoimport</em> command making it easy to import a data
file automatically deducing separators, column names and data types.</p>
<p>Detect attempted use of a cursor as input data for itself.</p>
</div>
<div class="section" id="id49">
<h2>3.7.6.2-r1<a class="headerlink" href="#id49" title="Permalink to this headline"></a></h2>
<p>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/117">APSW issue 117</a> where the
shell could report an I/O error on changing output target for some
operating systems.  Thanks to Edzard Pasma for finding and diagnosing
this.</p>
<p>Added support for VFS version 3 which allows redirecting <a class="reference internal" href="vfs.html#apsw.VFS.xSetSystemCall" title="apsw.VFS.xSetSystemCall"><code class="xref py py-meth docutils literal"><span class="pre">system</span>
<span class="pre">calls</span></code></a> used by some VFS implementations (eg for
testing or sandboxing).</p>
<p><a class="reference internal" href="exceptions.html#apsw.NotFoundError" title="apsw.NotFoundError"><code class="xref py py-exc docutils literal"><span class="pre">NotFoundError</span></code></a> exception added.</p>
<p>Added <a class="reference internal" href="connection.html#apsw.Connection.config" title="apsw.Connection.config"><code class="xref py py-meth docutils literal"><span class="pre">Connection.config()</span></code></a>.</p>
<p>Updated <a class="reference internal" href="connection.html#apsw.Connection.wal_checkpoint" title="apsw.Connection.wal_checkpoint"><code class="xref py py-meth docutils literal"><span class="pre">Connection.wal_checkpoint()</span></code></a> to use <a class="reference external" href="https://sqlite.org/c3ref/wal_checkpoint_v2.html">sqlite3_wal_checkpoint_v2</a> which provides
more fine grained control over checkpointing and returns useful
information.</p>
</div>
<div class="section" id="id50">
<h2>3.7.5-r1<a class="headerlink" href="#id50" title="Permalink to this headline"></a></h2>
<p>Backwards incompatible change in SQLite 3.7.5 for handling of
<a class="reference internal" href="vfs.html#apsw.VFSFile.xFileControl" title="apsw.VFSFile.xFileControl"><code class="xref py py-meth docutils literal"><span class="pre">xFileControl()</span></code></a>.  If you implement this method in a VFS
then you must return True or False to indicate if the operation was
understood.  <a class="reference internal" href="connection.html#apsw.Connection.filecontrol" title="apsw.Connection.filecontrol"><code class="xref py py-meth docutils literal"><span class="pre">Connection.filecontrol()</span></code></a> now returns that value.
(Previously you could not tell the difference between an op being
understood and an error resulting, or the op not being understood at
all.)</p>
<p>Windows Python 3.2 binaries now available.</p>
</div>
<div class="section" id="id51">
<h2>3.7.4-r1<a class="headerlink" href="#id51" title="Permalink to this headline"></a></h2>
<p>Binary downloads for Windows 64 bit Python versions 2.6 and above
including Python 3 are now available.</p>
<p><a class="reference internal" href="apsw.html#apsw.softheaplimit" title="apsw.softheaplimit"><code class="xref py py-meth docutils literal"><span class="pre">apsw.softheaplimit()</span></code></a> now uses <a class="reference external" href="https://sqlite.org/c3ref/soft_heap_limit64.html">sqlite3_soft_heap_limit64</a> so you can
provide values larger than 2GB.  It is now also able to return the
previous value instead of None.</p>
<p>Improve getting shell timer information for 64 bit Windows.</p>
<p><a class="reference internal" href="blob.html#apsw.blob.reopen" title="apsw.blob.reopen"><code class="xref py py-meth docutils literal"><span class="pre">blob.reopen()</span></code></a> is implemented.</p>
<p>FTS4 is enabled and in the binary builds.  Note that it is an
augmentation of FTS3 rather than totally separate code and described
in the <a class="reference external" href="https://sqlite.org/fts3.html#fts4">SQLite documentation</a>.</p>
</div>
<div class="section" id="id52">
<h2>3.7.3-r1<a class="headerlink" href="#id52" title="Permalink to this headline"></a></h2>
<p>You can read blobs into pre-existing buffers using
<a class="reference internal" href="blob.html#apsw.blob.readinto" title="apsw.blob.readinto"><code class="xref py py-meth docutils literal"><span class="pre">blob.readinto()</span></code></a>.  (This is more efficient than allocating new
buffers as <a class="reference internal" href="blob.html#apsw.blob.read" title="apsw.blob.read"><code class="xref py py-meth docutils literal"><span class="pre">blob.read()</span></code></a> does and then copying.)  (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/109">APSW issue 109</a>).</p>
<p>Fixed bug with unicode output in CSV mode in the shell.</p>
<p><a class="reference external" href="https://sqlite.org/c3ref/create_function.html">sqlite_create_function_v2</a> now means that some
housekeeping APSW did can be pushed back onto SQLite and the
consequent deletion of some code</p>
</div>
<div class="section" id="id53">
<h2>3.7.2-r1<a class="headerlink" href="#id53" title="Permalink to this headline"></a></h2>
<p>No changes to APSW.  Upgrading to this version of SQLite is
<a class="reference external" href="https://sqlite.org/releaselog/3_7_2.html">recommended</a>.</p>
</div>
<div class="section" id="id54">
<h2>3.7.1-r1<a class="headerlink" href="#id54" title="Permalink to this headline"></a></h2>
<p>Updated various constants including <a class="reference external" href="https://sqlite.org/c3ref/c_fcntl_chunk_size.html">SQLITE_FCNTL_CHUNK_SIZE</a> used with
<a class="reference internal" href="connection.html#apsw.Connection.filecontrol" title="apsw.Connection.filecontrol"><code class="xref py py-meth docutils literal"><span class="pre">Connection.filecontrol()</span></code></a>.</p>
<p>Fixed Unicode output with some file objects from the shell (<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/108">APSW issue 108</a>).</p>
<p>With the shell, you can specify handling of characters not present in
the output encoding (eg replace to use &#8216;?&#8217; or similar, ignore,
xmlcharrefreplace etc).  For example:</p>
<div class="highlight-default"><div class="highlight"><pre><span class="o">.</span><span class="n">encoding</span> <span class="n">cp437</span><span class="p">:</span><span class="n">replace</span>
</pre></div>
</div>
</div>
<div class="section" id="id55">
<h2>3.7.0.1-r1<a class="headerlink" href="#id55" title="Permalink to this headline"></a></h2>
<p>Fixed issue when using a tracer and a context manager fails to commit.</p>
</div>
<div class="section" id="id56">
<h2>3.7.0-r1<a class="headerlink" href="#id56" title="Permalink to this headline"></a></h2>
<p>Added several new constants.</p>
<p><a class="reference external" href="https://sqlite.org/wal.html">Write Ahead Logging</a> is
<a class="reference internal" href="tips.html#wal"><span class="std std-ref">supported</span></a>.  You can make all databases automatically use
WAL mode if available by using <a class="reference internal" href="tips.html#wal"><span class="std std-ref">connection hooks</span></a>.</p>
<p>Added <a class="reference internal" href="apsw.html#apsw.format_sql_value" title="apsw.format_sql_value"><code class="xref py py-meth docutils literal"><span class="pre">format_sql_value()</span></code></a> for generating a SQL syntax string from
a value.  This is implemented in C and is significantly faster than
doing the same formatting in Python.</p>
<p>Using the above function and other tweaks the <a class="reference internal" href="shell.html#shell"><span class="std std-ref">Shell</span></a> dumper is
now three to four times faster.  Thanks to Nikolaus Rath for pointing
out the problem and providing test data.</p>
<p>The shell now does colour highlighting making it easy to visually
distinguish prompts, errors, headers and value types when outputting
to a terminal.  See the <code class="xref std std-option docutils literal"><span class="pre">--no-colour</span></code> argument and <strong>.colour</strong>
command.  Those of you in the two countries that have not adopted the
metric system may also omit the &#8216;u&#8217;.  For Windows users you won&#8217;t get
colour output unless you install <a class="reference external" href="http://pypi.python.org/pypi/colorama">colorama</a></p>
<p>When using the context manager (with statement) of a
<a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> and the exit commit had an error, then the
transaction is rolled back.  This could occur if SQLite had buffered
the transaction entirely in memory and a non-eager transaction lock
had been obtained.  Thanks to Geoff Ness for finding the problem.
(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/98">APSW issue 98</a>).</p>
<p>Fixed bug when an error is returned creating an instance of a virtual
table (eg an invalid column name).  Before the fix you would get the
previous error message or a crash.  Thanks to Jose Gomes for finding
the problem.  <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/103">APSW issue 103</a></p>
<p>There is now a PPA for Ubuntu users that is kept up to date with APSW
and SQLite at <a class="reference external" href="https://launchpad.net/~ubuntu-rogerbinns/+archive/apsw">https://launchpad.net/~ubuntu-rogerbinns/+archive/apsw</a>
which has the latest SQLite embedded statically inside (ie system
SQLite is ignored) and has all the extensions enabled: FTS3, RTree,
ICU, asyncvfs</p>
<p>If you open VFS files directly then the filename is always run through
xFullPathname first.  SQLite guarantees this behaviour but the
existing VFS code was not doing that for direct opens.  Opens from
SQLite were doing it.</p>
<p>Fixed error where <a class="reference internal" href="apsw.html#apsw.connection_hooks" title="apsw.connection_hooks"><code class="xref py py-attr docutils literal"><span class="pre">apsw.connection_hooks</span></code></a> were being run before
the <a class="reference internal" href="execution.html#statementcache"><span class="std std-ref">statement cache</span></a> was initialised which would
result in a crash if any hooks executed SQL code.</p>
</div>
<div class="section" id="id57">
<h2>3.6.23.1-r1<a class="headerlink" href="#id57" title="Permalink to this headline"></a></h2>
<p>Shell CSV output under Python 3.1 is corrected (work around Python 3.1
StringIO bug/incompatibility with other Python versions).</p>
<p>Simplified access to the shell&#8217;s <a class="reference internal" href="shell.html#apsw.Shell.db" title="apsw.Shell.db"><code class="xref py py-attr docutils literal"><span class="pre">database</span></code></a> from the
API.</p>
<p>Added a shell <a class="reference internal" href="example.html#example-shell"><span class="std std-ref">example</span></a>.</p>
</div>
<div class="section" id="id58">
<h2>3.6.23-r1<a class="headerlink" href="#id58" title="Permalink to this headline"></a></h2>
<p>If setup is downloading files and an error occurs then it retries up
to 5 times.</p>
<p>Added SQLITE_CONFIG_LOG and SQLITE_OPEN_AUTOPROXY constants.</p>
<p>Added <a class="reference internal" href="apsw.html#apsw.compile_options" title="apsw.compile_options"><code class="xref py py-attr docutils literal"><span class="pre">compile_options</span></code></a> which tells you what compilation defines
SQLite was compiled with.</p>
<p>Added <a class="reference internal" href="apsw.html#apsw.log" title="apsw.log"><code class="xref py py-meth docutils literal"><span class="pre">log()</span></code></a> to call the SQLite logging interface, and updated
<a class="reference internal" href="apsw.html#apsw.config" title="apsw.config"><code class="xref py py-meth docutils literal"><span class="pre">config()</span></code></a> so you can set log destination function.</p>
</div>
<div class="section" id="id59">
<h2>3.6.22-r1<a class="headerlink" href="#id59" title="Permalink to this headline"></a></h2>
<p>Made it possible to run distutils &#8216;sdist&#8217; from an already produced
source that was made from &#8216;sdist&#8217;.  This was necessary for some Python
virtual package environments.  Note that the recursive result does not
include the HTML help as distutils has no way of including content in
a reparented location.  <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/89">APSW issue 89</a></p>
<p>Various settings are output as pragma statements when making a dump
such as page size, encoding, auto_vacuum etc.  The pragmas are
commented out.  <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/90">APSW issue 90</a></p>
</div>
<div class="section" id="id60">
<h2>3.6.21-r1<a class="headerlink" href="#id60" title="Permalink to this headline"></a></h2>
<p>Source and binary files are now digitally signed which means you can
verify they have not been tampered with.  See <a class="reference internal" href="download.html#verifydownload"><span class="std std-ref">Verifying your download</span></a>
for instructions.</p>
<p>The pragmas generated for a shell dump are emitted outside the
transaction as they have no effect inside the transaction.</p>
<p>Removed some unintentional logging code left in CouchDB virtual
table code.</p>
</div>
<div class="section" id="id61">
<h2>3.6.20-r1<a class="headerlink" href="#id61" title="Permalink to this headline"></a></h2>
<p>Support for Python 3.0 has been dropped as it has been <a class="reference external" href="http://www.python.org/download/releases/3.0.1/">end of lifed</a>.  Use Python 3.1
onwards.</p>
<p>Changes to how some statements are <a class="reference external" href="https://sqlite.org/c3ref/prepare.html">prepared</a> to allow the new RANGE and
LIKE optimisations with bound variables introduced in SQLite 3.6.20 to
be used.  See <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/85">APSW issue 85</a> for the long and gory details.</p>
<p>You can now access <a class="reference external" href="http://couchdb.apache.org">CouchDB</a> using a
virtual table.  This lets you easily bidirectionally transfer data
between SQLite and CouchDB as well as work on data in both sources at
the same time.  Other example uses are in the documentation.</p>
<p><a class="reference internal" href="shell.html#shell"><span class="std std-ref">Shell</span></a> changes:</p>
<ul class="simple">
<li>.dump command now outputs views in the order they were created
rather than alphabetical as views could reference each
other. <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/82">APSW issue 82</a></li>
<li>.dump command now outputs the <a class="reference external" href="https://sqlite.org/pragma.html#version">user_version</a> as a comment.  It is
used by some programs (such as Firefox) to keep track of the schema
version.</li>
<li>Can now output in <a class="reference external" href="http://json.org">JSON</a>.</li>
<li>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/83">APSW issue 83</a> - exception if history file didn&#8217;t exist</li>
<li>You can right justify output in column mode by specifying negative
widths. <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/84">APSW issue 84</a></li>
<li>You no longer get a traceback doing completions if there is a
virtual table in the database but the module is not loaded.
<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/86">APSW issue 86</a></li>
<li>You can now get detailed tracebacks including local variables using
the &#8221;.exception ON&#8221; command.  This is useful when developing
virtual tables and similar functionality.</li>
<li>You can now terminate a SQL statement with &#8220;go&#8221; or &#8220;/&#8221; on a line
by itself.</li>
</ul>
</div>
<div class="section" id="id62">
<h2>3.6.19-r1<a class="headerlink" href="#id62" title="Permalink to this headline"></a></h2>
<p><strong>Backwards incompatible change</strong> Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/72">APSW issue 72</a> where APSW wasn&#8217;t
zero basing virtual table <a class="reference internal" href="vtable.html#apsw.VTTable.BestIndex" title="apsw.VTTable.BestIndex"><code class="xref py py-meth docutils literal"><span class="pre">BestIndex()</span></code></a> constraints
returned as documented.  If you have working BestIndex code then you
need to update it for this release.  Thanks to Lefteris for finding
this issue.</p>
<p><strong>Backwards incompatible change</strong> The <a class="reference internal" href="apsw.html#apsw.complete" title="apsw.complete"><code class="xref py py-meth docutils literal"><span class="pre">complete()</span></code></a> method
has moved from <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> to <a class="reference internal" href="apsw.html#module-apsw" title="apsw: Python access to SQLite database library"><code class="xref py py-mod docutils literal"><span class="pre">apsw</span></code></a> where it should have
been all along.  You should now call <a class="reference internal" href="apsw.html#apsw.complete" title="apsw.complete"><code class="xref py py-meth docutils literal"><span class="pre">apsw.complete()</span></code></a> instead.  (It
even had an example showing it to be part of the module and not a
specific connection!)</p>
<p>There is now an <a class="reference internal" href="shell.html#apsw.Shell" title="apsw.Shell"><code class="xref py py-class docutils literal"><span class="pre">interactive</span> <span class="pre">shell</span></code></a> very similar to
that <a class="reference external" href="https://sqlite.org/sqlite.html">provided by SQLite</a>.  You
can embed it in your own program, inherit from it to provide more
commands and output modes, or just run it like this:</p>
<div class="highlight-default"><div class="highlight"><pre>$ python -c &quot;import apsw ; apsw.main()&quot;
</pre></div>
</div>
<p>Added the <a class="reference external" href="https://sqlite.org/c3ref/c_limit_attached.html">SQLITE_LIMIT_TRIGGER_DEPTH</a>,
<a class="reference external" href="https://sqlite.org/c3ref/c_open_autoproxy.html">SQLITE_OPEN_PRIVATECACHE</a> and
<a class="reference external" href="https://sqlite.org/c3ref/c_open_autoproxy.html">SQLITE_OPEN_SHAREDCACHE</a> constants.</p>
<p>The <code class="file docutils literal"><span class="pre">setup.py</span></code> file now has the various options available made
applicable to appropriate commands only.  Read the <a class="reference internal" href="build.html#setup-py-flags"><span class="std std-ref">updated
documentation</span></a>.</p>
<p>You can now specify <code class="xref std std-option docutils literal"><span class="pre">build</span> <span class="pre">--enable=stat2</span></code> to <code class="file docutils literal"><span class="pre">setup.py</span></code>
to enable <a class="reference external" href="https://sqlite.org/compile.html#enable_stat2">advanced statistics gathering</a> for query
planning.</p>
<p><code class="file docutils literal"><span class="pre">setup.py</span></code> can automatically fetch the asyncvfs
extension for you.  If the source is present when APSW is built then
it will be automatically included and the <code class="xref py py-meth docutils literal"><span class="pre">API</span></code> provided.</p>
<p>A <a class="reference internal" href="apsw.html#apsw.fork_checker" title="apsw.fork_checker"><code class="xref py py-meth docutils literal"><span class="pre">fork_checker()</span></code></a> is available which turns on detection when you
have used SQLite objects across a fork (a <strong>very</strong> bad thing).  This
is possible on Unix like operating systems, especially if you use the
<a class="reference external" href="http://docs.python.org/library/multiprocessing.html">multiprocessing module</a>.</p>
<p>Extension loading is now compiled in by default when using the
amalgamation and compiled out when using existing libraries.  This is
more likely to match your machine.  You can use
<code class="xref std std-option docutils literal"><span class="pre">--omit=load_extension</span></code> or <code class="xref std std-option docutils literal"><span class="pre">--enable=load_extension</span></code>
to the build/build_ext commands to explicitly disable/enable extension
loading.  <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/67">APSW issue 67</a></p>
<p><a class="reference internal" href="build.html#building"><span class="std std-ref">setup.py</span></a> will now abort on a download that has no
checksum.  See <a class="reference internal" href="build.html#fetch-checksums"><span class="std std-ref">more information</span></a> on checksums.</p>
<p><a class="reference internal" href="build.html#setup-py-flags"><span class="std std-ref">setup.py</span></a> can also fetch the version of SQLite
currently under development before a release.  Use
<code class="xref std std-option docutils literal"><span class="pre">--version=fossil</span></code>.</p>
<p>Updated which code uses <a class="reference external" href="https://sqlite.org/c3ref/experimental.html">experimental SQLite APIs</a> based on changes in
SQLite.  The test suite will also work correctly with experimental on
or off.  (It is on by default.)</p>
</div>
<div class="section" id="id63">
<h2>3.6.18-r1<a class="headerlink" href="#id63" title="Permalink to this headline"></a></h2>
<p>The APSW license has been updated to allow you (at your option) to use
any <a class="reference external" href="http://opensource.org/licenses/alphabetical">OSI approved license</a>.</p>
<p>The <a class="reference internal" href="benchmarking.html#speedtest"><span class="std std-ref">speedtest</span></a> has been updated to (optionally) use unicode
characters and to (optionally) increase the sizes of data items.</p>
<p>Fixed error handling code to not record SQLite error strings in some
situations where it was not necessary.  This results in the code
executing a little faster.</p>
</div>
<div class="section" id="id64">
<h2>3.6.17-r1<a class="headerlink" href="#id64" title="Permalink to this headline"></a></h2>
<p>APSW has migrated from Subversion to <a class="reference external" href="http://mercurial.selenic.com/wiki/">Mercurial</a> for source code control.
Hosting remains at <a class="reference external" href="https://code.google.com/p/apsw/">Google Code</a></p>
<p>Updated a test due to VFS xUnlock errors now being ignored sometimes
by SQLite (<a class="reference external" href="https://sqlite.org/cvstrac/tktview?tn=3946">SQLite ticket #3946</a>).</p>
<p>The downloads page in the help didn&#8217;t mention the Windows Python 3.1
installer.</p>
<p>Running the test suite is now integrated into <code class="file docutils literal"><span class="pre">setup.py</span></code> so you
can do the building and testing all in one go.  Sample command line:</p>
<div class="highlight-default"><div class="highlight"><pre>$ python setup.py install test
</pre></div>
</div>
<p>The test suite will now check the functionality of the FTS3, RTree and
ICU extensions if they were included.  (The Windows binary distribution
includes FTS3 and RTree by default.)</p>
<p>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/55">APSW issue 55</a> where FTS3 was unintentionally omitted from the
Windows binary distribution.</p>
<p>Various documentation updates.</p>
</div>
<div class="section" id="id65">
<h2>3.6.16-r1<a class="headerlink" href="#id65" title="Permalink to this headline"></a></h2>
<p>Windows binary distribution includes Python 3.1.</p>
<p>Trivial tweaks to keep MSVC happy.</p>
</div>
<div class="section" id="id66">
<h2>3.6.15-r1<a class="headerlink" href="#id66" title="Permalink to this headline"></a></h2>
<p>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/50">APSW issue 50</a> where <a class="reference internal" href="blob.html#apsw.blob.read" title="apsw.blob.read"><code class="xref py py-meth docutils literal"><span class="pre">blob.read()</span></code></a> was returning <code class="xref py py-const docutils literal"><span class="pre">None</span></code>
on end of file instead of the documented (and correct) empty
string/bytes.</p>
<p>Corrected spelling of option in <a class="reference internal" href="execution.html#apswtrace"><span class="std std-ref">apswtrace</span></a> and only
output CURSORFROM if SQL tracing is on.</p>
</div>
<div class="section" id="id67">
<h2>3.6.14.2-r1<a class="headerlink" href="#id67" title="Permalink to this headline"></a></h2>
<p>Updated test code because SQLite 3.6.15 returns a different error code
on trying to register a function with too many arguments (see
<a class="reference external" href="https://sqlite.org/cvstrac/tktview?tn=3875">SQLite ticket #3875</a>).</p>
</div>
<div class="section" id="id68">
<h2>3.6.14.1-r1<a class="headerlink" href="#id68" title="Permalink to this headline"></a></h2>
<p>Changed some internal symbol names so they won&#8217;t clash with similar
new ones used by SQLite in the amalgamation.</p>
<p>Added <a class="reference internal" href="apsw.html#apsw.using_amalgamation" title="apsw.using_amalgamation"><code class="xref py py-attr docutils literal"><span class="pre">apsw.using_amalgamation</span></code></a> so you can tell if APSW was
compiled using the <a class="reference external" href="https://sqlite.org/cvstrac/wiki?p=TheAmalgamation">SQLite amalgamation</a>.  Using the
amalgamation means that SQLite shared libraries are not used and will
not affect your code.</p>
<p>Added a checksums file so that when <code class="file docutils literal"><span class="pre">setup.py</span></code> downloads SQLite,
we know it hasn&#8217;t been tampered with.  (The <a class="reference internal" href="build.html#setup-py-flags"><span class="std std-ref">&#8211;fetch-sqlite</span></a> argument can be used to automatically download
SQLite.)</p>
</div>
<div class="section" id="id69">
<h2>3.6.13-r1<a class="headerlink" href="#id69" title="Permalink to this headline"></a></h2>
<p>Added SQLITE_LOCKED_SHAREDCACHE <a class="reference external" href="https://sqlite.org/c3ref/c_ioerr_access.html">extended error code</a>.</p>
<p>Updated tests as the VFS delete error handling code in SQLite now
returns the same high level error code between Windows and
non-Windows.</p>
<p>The CHM format help file produced by the Windows HTML Help Compiler is
viewable again under Windows HTML Help Viewer.</p>
</div>
<div class="section" id="id70">
<h2>3.6.11-r1<a class="headerlink" href="#id70" title="Permalink to this headline"></a></h2>
<p>You can now use the <a class="reference external" href="https://sqlite.org/backup.html">hot backup functionality</a> introduced in SQLite 3.6.11.</p>
<p>Updated a VFS test to reflect changes in SQLite underlying error
handling.  (Previously SQLite almost always returned <a class="reference internal" href="exceptions.html#apsw.FullError" title="apsw.FullError"><code class="xref py py-exc docutils literal"><span class="pre">FullError</span></code></a>
on any write that had an error but now returns <a class="reference internal" href="exceptions.html#apsw.SQLError" title="apsw.SQLError"><code class="xref py py-exc docutils literal"><span class="pre">SQLError</span></code></a>.)</p>
<p>Changed close methods so that Connections can be released earlier.</p>
<p>In prior releases a <a class="reference internal" href="cursor.html#apsw.Cursor.close" title="apsw.Cursor.close"><code class="xref py py-meth docutils literal"><span class="pre">closed</span> <span class="pre">cursor</span></code></a> could still be used
(reincarnated).  That is no longer the case and you will get
<a class="reference internal" href="exceptions.html#apsw.CursorClosedError" title="apsw.CursorClosedError"><code class="xref py py-exc docutils literal"><span class="pre">CursorClosedError</span></code></a>.</p>
</div>
<div class="section" id="id71">
<h2>3.6.10-r1<a class="headerlink" href="#id71" title="Permalink to this headline"></a></h2>
<p>You can use the database as a <a class="reference external" href="http://docs.python.org/reference/datamodel.html#with-statement-context-managers">context manager</a>
as defined in <span class="target" id="index-0"></span><a class="pep reference external" href="https://www.python.org/dev/peps/pep-0343"><strong>PEP 0343</strong></a>.  When you use <em>with</em> a transaction is
started.  If the block finishes with an exception then the transaction
is rolled back, otherwise it is committed.  See <a class="reference internal" href="connection.html#apsw.Connection.__enter__" title="apsw.Connection.__enter__"><code class="xref py py-meth docutils literal"><span class="pre">Connection.__enter__()</span></code></a>
for an example.</p>
<p>Behind the scenes the <a class="reference external" href="https://sqlite.org/lang_savepoint.html">savepoint</a> functionality introduced
in SQLite 3.6.8 is used.  Consequently <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> <em>with</em>
blocks can be nested.  If you use Connection level <a class="reference internal" href="execution.html#executiontracer"><span class="std std-ref">execution
tracers</span></a> then they will be called with the savepoint
SQL statements.</p>
<p>You can also use <a class="reference internal" href="blob.html#apsw.blob" title="apsw.blob"><code class="xref py py-class docutils literal"><span class="pre">blobs</span></code></a> as a context manager which
ensures it is always closed when finished using it.  See
<a class="reference internal" href="blob.html#apsw.blob.__enter__" title="apsw.blob.__enter__"><code class="xref py py-meth docutils literal"><span class="pre">blob.__enter__()</span></code></a> for an example.</p>
<p>Added <a class="reference internal" href="apsw.html#sqliteconstants"><span class="std std-ref">constants</span></a>:</p>
<blockquote>
<div><ul class="simple">
<li>SQLITE_SAVEPOINT (authorizer code)</li>
<li>SQLITE_IOERR_CLOSE (extended result code)</li>
<li>SQLITE_IOERR_DIR_CLOSE (extended result code)</li>
<li>New mapping: SQLITE_FCNTL_LOCKSTATE, SQLITE_GET_LOCKPROXYFILE, SQLITE_SET_LOCKPROXYFILE, SQLITE_LAST_ERRNO.  SQLite does not document the purpose of these except the first one.</li>
</ul>
</div></blockquote>
<p>Updated <a class="reference internal" href="vfs.html#vfs"><span class="std std-ref">Virtual File System (VFS)</span></a> test code.  SQLite&#8217;s routines that call
<a class="reference internal" href="vfs.html#apsw.VFSFile.xTruncate" title="apsw.VFSFile.xTruncate"><code class="xref py py-meth docutils literal"><span class="pre">VFSFile.xTruncate()</span></code></a> used to ignore errors but now return an
error to the caller.  <a class="reference internal" href="vfs.html#apsw.VFSFile.xFileControl" title="apsw.VFSFile.xFileControl"><code class="xref py py-meth docutils literal"><span class="pre">VFSFile.xFileControl()</span></code></a> is now called so a
user implemented one must call any base it inherits from for SQLite to
function normally.</p>
<p>Updated the xDlSym VFS routine to have the different but compatible
type signature as changed in SQLite 3.6.7 to deal with pedantic
compiler warnings.</p>
<p>Fixed bug in <a class="reference internal" href="execution.html#apswtrace"><span class="std std-ref">apswtrace</span></a> that could result in poorly
formatted times.  Leading comments are also stripped for queries
printed in the final reports.  You can also request subsets of the
reports.</p>
<p>The <a class="reference internal" href="benchmarking.html#speedtest"><span class="std std-ref">speedtest</span></a> script will now fallback to the Python builtin
sqlite3 module if it can&#8217;t find an externally installed pysqlite.</p>
</div>
<div class="section" id="id72">
<h2>3.6.6.2-r1<a class="headerlink" href="#id72" title="Permalink to this headline"></a></h2>
<p>Windows binary download for Python 3.0 is <a class="reference internal" href="download.html#source-and-binaries"><span class="std std-ref">available</span></a>.</p>
<p>Various changes in data structures and containers to reduce code size.</p>
<p>Changed the code to handle SQLite errors to only use Python
functionality and no operating system functionality (thread local
storage).  This also addresses <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/36">APSW issue 36</a> where Vista was not binary
compatible with XP.  Thanks to Rudolf Gaertner for assistance in
detecting and diagnosing this issue.</p>
<p><a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connections</span></code></a>, <a class="reference internal" href="cursor.html#apsw.Cursor" title="apsw.Cursor"><code class="xref py py-class docutils literal"><span class="pre">cursors</span></code></a> and
<a class="reference internal" href="blob.html#apsw.blob" title="apsw.blob"><code class="xref py py-class docutils literal"><span class="pre">blobs</span></code></a> can be used by <a class="reference external" href="http://docs.python.org/library/weakref.html">weak references</a>.</p>
<p>You can now install <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> wide <a class="reference internal" href="connection.html#apsw.Connection.setexectrace" title="apsw.Connection.setexectrace"><code class="xref py py-meth docutils literal"><span class="pre">execution</span></code></a> and <a class="reference internal" href="connection.html#apsw.Connection.setrowtrace" title="apsw.Connection.setrowtrace"><code class="xref py py-meth docutils literal"><span class="pre">row</span></code></a>
<a class="reference internal" href="execution.html#tracing"><span class="std std-ref">tracers</span></a>.</p>
<p>The callbacks for execution and row tracers have a different signature
to include the cursor the execution or row happened on.  This is a
backwards incompatible change.  See <a class="reference internal" href="execution.html#tracing"><span class="std std-ref">tracing</span></a> for
details.</p>
<p>Due to popular demand, added <a class="reference internal" href="cursor.html#apsw.Cursor.fetchall" title="apsw.Cursor.fetchall"><code class="xref py py-meth docutils literal"><span class="pre">Cursor.fetchall()</span></code></a>.  This is a
longer way of typing <code class="docutils literal"><span class="pre">list(cursor)</span></code>.</p>
<p>Added attributes to the <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> class -
<a class="reference internal" href="connection.html#apsw.Connection.filename" title="apsw.Connection.filename"><code class="xref py py-attr docutils literal"><span class="pre">filename</span></code></a>, <a class="reference internal" href="connection.html#apsw.Connection.open_flags" title="apsw.Connection.open_flags"><code class="xref py py-attr docutils literal"><span class="pre">open_flags</span></code></a> and
<a class="reference internal" href="connection.html#apsw.Connection.open_vfs" title="apsw.Connection.open_vfs"><code class="xref py py-attr docutils literal"><span class="pre">open_vfs</span></code></a>.  These let you track how the database
was opened.</p>
<p>Added a <a class="reference internal" href="execution.html#apswtrace"><span class="std std-ref">apswtrace</span></a> script to allow easy SQL tracing
without having to modify your code.</p>
<p>Revert to using older SQLite APIs in order to work around
<a class="reference external" href="https://sqlite.org/cvstrac/tktview?tn=2158">SQLite ticket #2158</a>.  (This also saves a little bit of SQLite memory
usage).  The user visible effect was that you could get different
exceptions and error text depending on whether a query was already in
the <a class="reference internal" href="execution.html#statementcache"><span class="std std-ref">statement cache</span></a> or if you were
multi-threading.  As an example, if you have a query that used an
unknown collation then SQLite&#8217;s <a class="reference external" href="https://sqlite.org/c3ref/prepare.html">prepare</a> returns
<code class="xref py py-const docutils literal"><span class="pre">SQLITE_ERROR</span></code> with error text about the bad collation.  If a
query had already been prepared, the collation removed and then <a class="reference external" href="https://sqlite.org/c3ref/step.html">run</a> the new SQLite routines are
returning <code class="xref py py-const docutils literal"><span class="pre">SQLITE_SCHEMA</span></code> and generic <code class="docutils literal"><span class="pre">schema</span> <span class="pre">changed</span></code> error
text.  Changing user defined functions could also cause a previously
correct query to become invalid.</p>
</div>
<div class="section" id="id73">
<h2>3.6.5-r1<a class="headerlink" href="#id73" title="Permalink to this headline"></a></h2>
<p>The distribution now includes a <a class="reference internal" href="benchmarking.html#speedtest"><span class="std std-ref">speedtest</span></a> script.  You can use
this to see how APSW performs relative to pysqlite, or to track
performance differences between SQLite versions.  The underlying
queries are derived from <a class="reference external" href="https://sqlite.org/src/finfo?name=tool/mkspeedsql.tcl">SQLite&#8217;s speed test</a></p>
<p>The statement cache was completely rewritten.  It uses less memory and
scales significantly better.</p>
<p>It was possible to get a deadlock between the Python GIL and the
SQLite database mutex when using the same <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> across
multiple threads.  Fixed by releasing the GIL in more places and added
test that inspects the source to verify GIL/mutex handling.  Thanks to
amicitas reporting this as <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/31">APSW issue 31</a></p>
<p>SQLite&#8217;s API has been extended in 3.6.5 so that errors can be
retrieved in a thread safe manner.  APSW now uses this API.</p>
<p>As a consequence of the prior two changes it is now possible and safe
to use the same <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> across as many threads as you want
<a class="reference external" href="https://sqlite.org/threadsafe.html">concurrently</a>.</p>
<p>Documentation is now done using <a class="reference external" href="http://sphinx.pocoo.org">Sphinx</a>
which was adopted by Python 2.6 and 3.  This has allowed for richer
documentation and more output formats such as PDF and <a class="reference external" href="http://en.wikipedia.org/wiki/Microsoft_Compiled_HTML_Help">Windows CHM</a> format.</p>
<p>The binary distribution for Windows includes the <a class="reference external" href="https://sqlite.org/fts3.html">full text search</a> (FTS) and <a class="reference external" href="https://sqlite.org/src/finfo?name=ext/rtree/README">Rtree</a> extensions.
See also <a class="reference internal" href="build.html#setup-py-flags"><span class="std std-ref">Additional setup.py flags</span></a>.</p>
<p>The source structure and files were reorganized to make it clearer
where things are implemented and to make automatic extraction of
documentation easier.</p>
</div>
<div class="section" id="id74">
<h2>3.6.3-r1<a class="headerlink" href="#id74" title="Permalink to this headline"></a></h2>
<p>You can now write your own <a class="reference internal" href="vfs.html#vfs"><span class="std std-ref">Virtual File System (VFS)</span></a> in Python. You can also inherit
from an existing VFS making it easy to augment or override small bits
of behaviour without having to code everything else. See the
<a class="reference internal" href="example.html#example-vfs"><span class="std std-ref">example</span></a> where database files are obfuscated by
XORing their contents.</p>
<p><code class="file docutils literal"><span class="pre">setup.py</span></code> now takes an optional <code class="xref std std-option docutils literal"><span class="pre">--fetch-sqlite[=ver]</span></code>
argument to automatically download and use the latest SQLite
amalgamation (or a specified version). On non-Windows platforms it
will also work out what compile flags SQLite needs (for example
<code class="xref py py-const docutils literal"><span class="pre">HAVE_USLEEP</span></code>, <code class="xref py py-const docutils literal"><span class="pre">HAVE_LOCALTIME_R</span></code>). Several other
options to <code class="file docutils literal"><span class="pre">setup.py</span></code> are also available to control
enabling/omitting certains features and functionality. See
<a class="reference internal" href="build.html#building"><span class="std std-ref">building</span></a> for further details.</p>
<p>APSW checks that SQLite was compiled to be <a class="reference external" href="https://sqlite.org/c3ref/threadsafe.html">threadsafe</a></p>
<p>Added new constants:</p>
<ul class="simple">
<li><code class="xref py py-const docutils literal"><span class="pre">SQLITE_IOERR_ACCESS</span></code>, <code class="xref py py-const docutils literal"><span class="pre">SQLITE_IOERR_CHECKRESERVEDLOCK</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_IOERR_LOCK</span></code> extended result codes</li>
<li><code class="xref py py-const docutils literal"><span class="pre">SQLITE_OPEN_NOMUTEX</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_OPEN_FULLMUTEX</span></code> open flags</li>
<li>Several new <code class="xref py py-const docutils literal"><span class="pre">SQLITE_CONFIG</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_STATUS</span></code> codes</li>
</ul>
<p>Wrapped several new SQLite apis:</p>
<ul class="simple">
<li><a class="reference external" href="https://sqlite.org/c3ref/config.html">sqlite3_config</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/initialize.html">sqlite3_initialize/sqlite3_shutdown</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/memory_highwater.html">sqlite3_memory_used/sqlite3_memory_highwater</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/status.html">sqlite3_status</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/soft_heap_limit.html">sqlite3_soft_heap_limit</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/release_memory.html">sqlite3_release_memory</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/randomness.html">sqlite3_randomness</a></li>
</ul>
<p>The following experimental apis are not wrapped as there is nothing
useful you can do with them (yet):</p>
<ul class="simple">
<li><a class="reference external" href="https://sqlite.org/c3ref/db_config.html">sqlite3_db_config</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/db_status.html">sqlite3_db_status</a></li>
</ul>
<p>Restored prior behaviour regarding Python ints and longs returning int
for numbers fitting in signed 32 bit. This only affects Python 2 as
Python 3 uses long exclusively. Thanks to Joe Pham for reporting this
as <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/24">APSW issue 24</a></p>
<p>Added <code class="xref py py-meth docutils literal"><span class="pre">Connection.getsqlite3pointer()</span></code> method to help with
<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/26">APSW issue 26</a></p>
</div>
<div class="section" id="id75">
<h2>3.5.9-r2<a class="headerlink" href="#id75" title="Permalink to this headline"></a></h2>
<p>APSW now works with Python 3 (you need 3.0b1 or later).</p>
<p>(<a class="reference external" href="https://github.com/rogerbinns/apsw/issues/17">APSW issue 17</a>)
Removed the <code class="xref py py-const docutils literal"><span class="pre">SQLITE_MAX_*</span></code> constants since they could be
unreliable (eg APSW can&#8217;t tell what a shared library was compiled
with). A workaround is documented in <a class="reference internal" href="connection.html#apsw.Connection.limit" title="apsw.Connection.limit"><code class="xref py py-func docutils literal"><span class="pre">Connection.limit()</span></code></a>.</p>
</div>
<div class="section" id="id76">
<h2>3.5.9-r1<a class="headerlink" href="#id76" title="Permalink to this headline"></a></h2>
<p>APSW is now hosted at <a class="reference external" href="https://code.google.com/p/apsw">https://code.google.com/p/apsw</a></p>
<p>You can use this with SQLite 3.5.9 onwards.</p>
<p>SQLite now provides the source all <a class="reference external" href="https://sqlite.org/cvstrac/wiki?p=TheAmalgamation">amalgamated</a> into one file
which improves performance and makes compilation and linking of SQLite
far easier. The build instructions are updated.</p>
<p><code class="xref py py-const docutils literal"><span class="pre">SQLITE_COPY</span></code> authorizer code and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_PROTOCOL</span></code>
error code are no longer used by SQLite, but the values are left in
apsw for backwards compatibility</p>
<p><code class="xref py py-const docutils literal"><span class="pre">SQLITE_IOERR_DELETE</span></code>, <code class="xref py py-const docutils literal"><span class="pre">SQLITE_IOERR_BLOCKED</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_IOERR_NOMEM</span></code></p>
<p><a class="reference internal" href="connection.html#apsw.Connection.interrupt" title="apsw.Connection.interrupt"><code class="xref py py-func docutils literal"><span class="pre">Connection.interrupt()</span></code></a> can be called from any thread</p>
<p>SQLite has implementation limits on string and blob lengths (roughly
constrained to fitting within a signed 32 bit integer - less than 2GB)
which weren&#8217;t checked. Using a 64 bit Python 2.5+ (as I do) it would
have been possible to destroy memory and crash the
program. Consequently APSW has length checks to ensure it doesn&#8217;t
happen.  SQLite now has further <a class="reference external" href="https://sqlite.org/limits.html">limits checking</a> which cover other things as well
such as maximum number of virtual machine opcodes, maximum number of
variables etc. These are very useful if you are taking in SQL
statements from elsewhere. Call <a class="reference internal" href="connection.html#apsw.Connection.limit" title="apsw.Connection.limit"><code class="xref py py-func docutils literal"><span class="pre">Connection.limit()</span></code></a></p>
<p>A rename method was added for virtual tables.</p>
<p>SQLite 3.5 removed the requirement that all operations on a connection
be done in the same thread. Consequently all code that enforced the
restriction has been removed from APSW.</p>
<p>You no longer have to call <a class="reference internal" href="connection.html#apsw.Connection.close" title="apsw.Connection.close"><code class="xref py py-func docutils literal"><span class="pre">Connection.close()</span></code></a>. This was
previously a requirement to ensure that the correct thread was used
(destructors otherwise run in any thread). It is however still a good
idea to do so since you can catch exceptions when close is called
but not if you let the destructor do the closing.</p>
<p>SQLite now has incremental <a class="reference internal" href="blob.html#blobio"><span class="std std-ref">blob I/O</span></a></p>
<p><a class="reference external" href="https://github.com/rogerbinns/apsw/issues/4">APSW issue 4</a> which could lead to generic error messages was fixed in
SQLite 3.5.9.</p>
<p>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/1">APSW issue 1</a> error in example code for virtual tables which caused
filename errors on Windows.</p>
<p>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/15">APSW issue 15</a> releasing the GIL around calls to sqlite3_prepare.</p>
<p>Fixed <a class="reference external" href="https://github.com/rogerbinns/apsw/issues/7">APSW issue 7</a> ensuring that extension module filenames are
converted to utf8.</p>
<p>Use the <a class="reference external" href="https://sqlite.org/c3ref/open.html">sqlite3_open_v2</a>
interface which allows specifying which vfs to use. This release does
not allow you to write your own vfs as the SQLite vfs interface is
being changed for SQLite 3.6.</p>
<p>Used new SQLite functions that keep track of when virtual tables and
collations are no longer used so they can be released. Previously APSW
also had to keep track duplicating effort.</p>
<p>Improved test coverage a few more percent.</p>
<p>The statement cache now defaults to the same number of entries as
pysqlite (100). You can however specify more or less as needed.</p>
<p><a class="reference internal" href="connection.html#apsw.Connection.collationneeded" title="apsw.Connection.collationneeded"><code class="xref py py-func docutils literal"><span class="pre">Connection.collationneeded()</span></code></a> was implemented.</p>
</div>
<div class="section" id="id77">
<h2>3.3.13-r1<a class="headerlink" href="#id77" title="Permalink to this headline"></a></h2>
<p>As of this release, APSW is now co-hosted with pysqlite meaning there
is one site to go to for your Python SQLite bindings. (Both projects
subsequently moved to Google Code.)</p>
<p>You can use this with SQLite 3.3.13 onwards. There were no API changes
in SQLite 3.3.10 to 3.3.13 although some internal bugs were fixed and
the 3.3.13 release is recommended over the earlier version.</p>
<p>Thanks to Ed Pasma for highlighting these issues:</p>
<ul class="simple">
<li><a class="reference internal" href="connection.html#apsw.Connection.interrupt" title="apsw.Connection.interrupt"><code class="xref py py-func docutils literal"><span class="pre">Connection.interrupt()</span></code></a> can be safely called from any thread.</li>
<li>Empty statements or those consisting entirely of whitespace do not
cause misuse errors (internally SQLite started returned NULL pointers
for those statements, and <a class="reference external" href="https://sqlite.org/c3ref/step.html">sqlite3_step</a> didn&#8217;t like being passed the
NULL pointer).</li>
<li>Changed special handling of <code class="xref py py-const docutils literal"><span class="pre">SQLITE_BUSY</span></code> error to be the same
as other errors. The special handling previously let you restart on
receiving busy, but also hung onto statements which could result in
other statements getting busy errors.</li>
</ul>
</div>
<div class="section" id="id78">
<h2>3.3.10-r1<a class="headerlink" href="#id78" title="Permalink to this headline"></a></h2>
<p>You can use this with SQLite 3.3.10 onwards.</p>
<p>Added a statement cache that works in conjunction with the
<a class="reference external" href="https://sqlite.org/c3ref/prepare.html">sqlite3_prepare_v2</a> API. A
few issues were exposed in SQLite and hence you must use SQLite 3.3.10
or later.</p>
</div>
<div class="section" id="id79">
<h2>3.3.9-r1<a class="headerlink" href="#id79" title="Permalink to this headline"></a></h2>
<p>You can use this with SQLite 3.3.9 onwards.</p>
<p>SQLite added <a class="reference external" href="https://sqlite.org/c3ref/prepare.html">sqlite3_prepare_v2</a> API. The net effect of this
API update is that you will not get SQLITE_SCHEMA any more. SQLite
will handle it internally.</p>
</div>
<div class="section" id="id81">
<h2>3.3.8-r1<a class="headerlink" href="#id81" title="Permalink to this headline"></a></h2>
<p>You can use this with SQLite 3.3.8 onwards. There was an incompatible
API change for virtual tables in SQLite 3.3.8.</p>
<p>Virtual tables updated for new api.</p>
<p>You must call <a class="reference internal" href="connection.html#apsw.Connection.close" title="apsw.Connection.close"><code class="xref py py-func docutils literal"><span class="pre">close()</span></code></a> on connections. You can
also call <a class="reference internal" href="cursor.html#apsw.Cursor.close" title="apsw.Cursor.close"><code class="xref py py-func docutils literal"><span class="pre">close()</span></code></a> on cursors, but it usually isn&#8217;t
necessary.</p>
<p>All strings are returned as unicode.</p>
<p><code class="xref py py-func docutils literal"><span class="pre">PyErr_WriteUnraisable()</span></code> was used for errors in
destructors. Unfortunately it is almost completely useless, merely
printing <code class="xref py py-func docutils literal"><span class="pre">str()</span></code> of the object and exception. This doesn&#8217;t help in
finding where in your code the issue arose so you could fix it. An
internal APSW implementation generates a traceback and calls
<code class="xref py py-func docutils literal"><span class="pre">sys.excepthook()</span></code>, the default implementation of which prints the
exception and the traceback to sys.stderr.</p>
<blockquote>
<div><div class="admonition note">
<p class="first admonition-title">Note</p>
<p class="last">The line number reported in the traceback is often off by
1. This is because the destructors run &#8220;between&#8221; lines of
code and so the following line is reported as the current
location.</p>
</div>
</div></blockquote>
<p>Authorizer codes <code class="xref py py-const docutils literal"><span class="pre">SQLITE_CREATE_VTABLE</span></code>,
<code class="xref py py-const docutils literal"><span class="pre">SQLITE_DROP_VTABLE</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_FUNCTION</span></code> added.</p>
<p>SQLite <a class="reference external" href="https://sqlite.org/cvstrac/wiki?p=ExtendedResultCodes">extended result codes</a> are
available - see <a class="reference internal" href="exceptions.html#exceptions"><span class="std std-ref">Exceptions</span></a> for more detail.</p>
<p><code class="xref py py-data docutils literal"><span class="pre">Connection.hooks</span></code> added so you can easily register functions,
virtual tables or similar items with each Connection as it is created.</p>
<p>Added <a class="reference internal" href="apsw.html#sqliteconstants"><span class="std std-ref">mapping dicts</span></a> which makes it easy to
map the various constants between strings and ints.</p>
</div>
<div class="section" id="id82">
<h2>3.3.7-r1<a class="headerlink" href="#id82" title="Permalink to this headline"></a></h2>
<p>Never released as 3.3.8 came along.</p>
<p>You can use this release against SQLite 3.3.7. There were no changes
in the SQLite 3.3.6 API from 3.3.5. In SQLite 3.3.7 an API was added
that allowed removing a chunk of duplicate code. Also added were
<a class="reference external" href="https://sqlite.org/cvstrac/wiki?p=VirtualTables">Virtual Tables</a>
and loading of external modules (shared libraries).</p>
<p>APSW had the following changes:</p>
<ul class="simple">
<li>Even more test cases added (you can&#8217;t have too many tests :-)</li>
<li>When exceptions occur, dummy frames are added to the traceback in the
C code. This makes it a lot easier to tell why code was called if you
encounter an exception. See <a class="reference internal" href="exceptions.html#augmentedstacktraces"><span class="std std-ref">augmented stack traces</span></a> for details.</li>
<li>String values (traditional and Unicode) work correctly if they have
embedded NULL characters (ie not truncated at the NULL).</li>
<li>You can load SQLite shared library extensions.</li>
</ul>
</div>
<div class="section" id="id83">
<h2>3.3.5-r1<a class="headerlink" href="#id83" title="Permalink to this headline"></a></h2>
<p>You can use this release against any release of SQLite 3 from 3.3.5
onwards. A bug was also fixed when reporting an error during the
cleanup of an aggregate function if there had also been an error in
the step function.  (<code class="xref py py-func docutils literal"><span class="pre">PyErr_WriteUnraisable(NULL)()</span></code> crashed on
some versions of Python but not others.)</p>
<p>SQLite added several functions for returning metadata about result
column sets. You have to compile SQLite with
<code class="xref py py-const docutils literal"><span class="pre">SQLITE_ENABLE_COLUMN_METADATA</span></code> to get them. This is not the
default for SQLite. I don&#8217;t believe these are generally useful except
in some corner cases and so they aren&#8217;t wrapped. However please shout
if you do need them.  Note that <a class="reference internal" href="cursor.html#apsw.Cursor.getdescription" title="apsw.Cursor.getdescription"><code class="xref py py-func docutils literal"><span class="pre">Cursor.getdescription()</span></code></a> will
already give you generally useful information. (Also see the <a class="reference external" href="https://sqlite.org/pragma.html">pragmas</a>)</p>
<p>The test code has been converted into using the unittest module. Run
<strong class="command">python tests.py -v</strong> to get the tests run. There should be no
errors.</p>
<p>Updated code to work correctly with new <code class="xref c c-type docutils literal"><span class="pre">Py_ssize_t</span></code> introduced
in Python 2.5. See <a class="reference internal" href="execution.html#x64bitpy25"><span class="std std-ref">64 bit hosts, Python 2.5+</span></a> for
more details on how Python and SQLite handle 64 bit sized items.</p>
<p>The following functions were added to SQLite and are wrapped. They are
all functions defined on the <a class="reference internal" href="connection.html#apsw.Connection" title="apsw.Connection"><code class="xref py py-class docutils literal"><span class="pre">Connection</span></code></a> object or <a class="reference internal" href="apsw.html#module-apsw" title="apsw: Python access to SQLite database library"><code class="xref py py-mod docutils literal"><span class="pre">apsw</span></code></a>
module:</p>
<ul class="simple">
<li><a class="reference external" href="https://sqlite.org/c3ref/update_hook.html">sqlite3_update_hook</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/commit_hook.html">sqlite3_rollback_hook</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/enable_shared_cache.html">sqlite3_enable_shared_cache</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/get_autocommit.html">sqlite3_get_autocommit</a></li>
<li><a class="reference external" href="https://sqlite.org/c3ref/profile.html">sqlite3_profile</a> This
callback is run at the end of each statement execution telling you how
long it took.</li>
</ul>
</div>
<div class="section" id="id84">
<h2>3.2.7-r1<a class="headerlink" href="#id84" title="Permalink to this headline"></a></h2>
<p>You can use this release against any release of SQLite 3.</p>
<p>SQLite 3.2.7 has several bug fixes. The undocumented experimental
function <code class="xref py py-func docutils literal"><span class="pre">sqlite3_profile()</span></code> was added, but it not present in apsw
yet.</p>
<p>The author of pysqlite has improved it considerably since APSW was
originally written. The differences section has been updated to
reflect those improvements in pysqlite.</p>
<p><code class="xref py py-const docutils literal"><span class="pre">SQLITE_INTERNAL</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_NOTFOUND</span></code> error codes are
not used according to 3.2.7 header file. They are still present in
APSW for backwards compatibility.</p>
<p>Changed the build instructions so configure is run on non-Windows
platforms.</p>
<p>Fixed a bug caused by an overly helpful error message trying to tell
you how many bindings you supplied that crashed if you didn&#8217;t supply
any.</p>
<p>Changed when an error in the step function for an aggregate is
reported due to limitations in SQLite.</p>
</div>
<div class="section" id="id85">
<h2>3.2.2-r1<a class="headerlink" href="#id85" title="Permalink to this headline"></a></h2>
<p>You can use this release against any release of SQLite 3.</p>
<p>SQLite 3.2.2 API removed <code class="xref py py-func docutils literal"><span class="pre">sqlite3_global_recover()</span></code>. That function
was not wrapped in APSW. Note that SQLite 3.2.2 contains a bug fix
that applies when you use 64 bit integer primary keys (32 bit ints are
fine).</p>
</div>
<div class="section" id="id86">
<h2>3.2.1-r1<a class="headerlink" href="#id86" title="Permalink to this headline"></a></h2>
<p>You can use this release against any release of SQLite 3.</p>
<p>There are no changes in APSW except to correct an error in the example
code (collations are registered against the connection not the cursor)</p>
<p>SQLite 3.2.1 had one addition in the stable C API, which was a new
function named <code class="xref py py-func docutils literal"><span class="pre">sqlite3_global_recover()</span></code>. That function is not
applicable for wrapping in APSW.</p>
</div>
<div class="section" id="id87">
<h2>3.1.3-r1<a class="headerlink" href="#id87" title="Permalink to this headline"></a></h2>
<p>You can use this release against any release of SQLite 3.</p>
<p>The text string returned by apsw.Error used to say
&#8220;apsw.APSWException&#8221; and has been changed to &#8220;apsw.Error&#8221;.  This is
purely cosmetic and helps make clear what the class is. (The old
string was what the original class name was in an earlier version of
the code.)</p>
<p>Added <code class="xref py py-const docutils literal"><span class="pre">SQLITE_ALTER_TABLE</span></code> and <code class="xref py py-const docutils literal"><span class="pre">SQLITE_REINDEX</span></code>
constants for the authorizer function.  (These constants were
introduced in SQLite 3.1.3).</p>
<p>Changed various C++-isms into standard C (eg // comments and the
placing of some <code class="xref c c-macro docutils literal"><span class="pre">CHECK_THREAD</span></code> macro calls).</p>
<p>Added module level function <a class="reference internal" href="apsw.html#apsw.apswversion" title="apsw.apswversion"><code class="xref py py-meth docutils literal"><span class="pre">apswversion()</span></code></a> which returns
the version of APSW.</p>
<p>SQLite 3.1.3 had no changes in the stable C API other than what is
mentioned above. There were some new experimental functions added
which are not currently documented on the SQLite website, which are
not wrapped by APSW.  Please contact me if you believe they will
remain in SQLite and you would like them wrapped:</p>
<ul class="simple">
<li><code class="xref c c-func docutils literal"><span class="pre">sqlite3_sleep()</span></code> An alternative function which sleeps for a
specified number of milliseconds can be provided. By default SQLite
just uses the standard operating system call.</li>
<li><code class="xref c c-func docutils literal"><span class="pre">sqlite3_expired()</span></code> This function is internal to statement
execution. It would apply to the implementation of
<a class="reference internal" href="cursor.html#apsw.Cursor.executemany" title="apsw.Cursor.executemany"><code class="xref py py-meth docutils literal"><span class="pre">Cursor.executemany()</span></code></a> and could in theory provide a marginal
improvement in performance.</li>
<li>A global variable <code class="xref c c-data docutils literal"><span class="pre">sqlite3_temp_directory</span></code> can be used before
any databases are opened to set where temporary files are created. By
default SQLite just uses the standard operating system mechanisms.</li>
</ul>
</div>
<div class="section" id="r3">
<h2>3.0.8-r3<a class="headerlink" href="#r3" title="Permalink to this headline"></a></h2>
<p>There are no functional changes. The only changes were to correct some
variable names in the example code (they were cut and pasted from the
test code which used different names) and to make the source zip file
extract its contents into a sub-directory which is the more typical
way of packaging that sort of thing.</p>
</div>
<div class="section" id="id88">
<h2>3.0.8-r2<a class="headerlink" href="#id88" title="Permalink to this headline"></a></h2>
<p>All remaining functionality in the C API for SQLite 3.0.8 is now
available.</p>
<p>Finished this documentation.</p>
</div>
<div class="section" id="id89">
<h2>3.0.8-r1<a class="headerlink" href="#id89" title="Permalink to this headline"></a></h2>
<p>Initial release</p>
</div>
</div>


          </div>
        </div>
      </div>
      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
        <div class="sphinxsidebarwrapper">
  <h3><a href="index.html">Table Of Contents</a></h3>
  <ul>
<li><a class="reference internal" href="#">Change History</a><ul>
<li><a class="reference internal" href="#r1">3.16.2-r1</a></li>
<li><a class="reference internal" href="#id1">3.15.2-r1</a></li>
<li><a class="reference internal" href="#id2">3.15.1-r1</a></li>
<li><a class="reference internal" href="#id3">3.15.0-r1</a></li>
<li><a class="reference internal" href="#id4">3.14.1-r1</a></li>
<li><a class="reference internal" href="#id5">3.13.0-r1</a></li>
<li><a class="reference internal" href="#id6">3.12.2-r1</a></li>
<li><a class="reference internal" href="#id7">3.11.1-r1</a></li>
<li><a class="reference internal" href="#id8">3.11.0-r1</a></li>
<li><a class="reference internal" href="#id9">3.9.2-r1</a></li>
<li><a class="reference internal" href="#id10">3.8.11.1-r1</a></li>
<li><a class="reference internal" href="#id11">3.8.10.1-r1</a></li>
<li><a class="reference internal" href="#id12">3.8.9-r1</a></li>
<li><a class="reference internal" href="#id13">3.8.8.2-r1</a></li>
<li><a class="reference internal" href="#id14">3.8.8.1-r1</a></li>
<li><a class="reference internal" href="#id15">3.8.7.3-r1</a></li>
<li><a class="reference internal" href="#id16">3.8.7.2-r1</a></li>
<li><a class="reference internal" href="#id17">3.8.7.1-r1</a></li>
<li><a class="reference internal" href="#id18">3.8.6-r1</a></li>
<li><a class="reference internal" href="#id19">3.8.5-r1</a></li>
<li><a class="reference internal" href="#id20">3.8.4.3-r1</a></li>
<li><a class="reference internal" href="#id21">3.8.4.2-r1</a></li>
<li><a class="reference internal" href="#id22">3.8.4.1-r1</a></li>
<li><a class="reference internal" href="#id23">3.8.3.1-r1</a></li>
<li><a class="reference internal" href="#id24">3.8.3-r1</a></li>
<li><a class="reference internal" href="#id25">3.8.2-r1</a></li>
<li><a class="reference internal" href="#id26">3.8.1-r1</a></li>
<li><a class="reference internal" href="#id27">3.8.0.2-r1</a></li>
<li><a class="reference internal" href="#id28">3.8.0.1-r1</a></li>
<li><a class="reference internal" href="#r2">3.8.0-r2</a></li>
<li><a class="reference internal" href="#id29">3.8.0-r1</a></li>
<li><a class="reference internal" href="#id30">3.7.17-r1</a></li>
<li><a class="reference internal" href="#id31">3.7.16.2-r1</a></li>
<li><a class="reference internal" href="#id32">3.7.16.1-r1</a></li>
<li><a class="reference internal" href="#id33">3.7.16-r1</a></li>
<li><a class="reference internal" href="#id34">3.7.15.2-r1</a></li>
<li><a class="reference internal" href="#id35">3.7.15.1-r1</a></li>
<li><a class="reference internal" href="#id36">3.7.15-r1</a></li>
<li><a class="reference internal" href="#id37">3.7.14.1-r1</a></li>
<li><a class="reference internal" href="#id38">3.7.14-r2</a></li>
<li><a class="reference internal" href="#id39">3.7.14-r1</a></li>
<li><a class="reference internal" href="#id40">3.7.13-r1</a></li>
<li><a class="reference internal" href="#id41">3.7.12.1-r1</a></li>
<li><a class="reference internal" href="#id42">3.7.12-r1</a></li>
<li><a class="reference internal" href="#id43">3.7.11-r1</a></li>
<li><a class="reference internal" href="#id44">3.7.10-r1</a></li>
<li><a class="reference internal" href="#id45">3.7.9-r1</a></li>
<li><a class="reference internal" href="#id46">3.7.8-r1</a></li>
<li><a class="reference internal" href="#id47">3.7.7.1-r1</a></li>
<li><a class="reference internal" href="#id48">3.7.6.3-r1</a></li>
<li><a class="reference internal" href="#id49">3.7.6.2-r1</a></li>
<li><a class="reference internal" href="#id50">3.7.5-r1</a></li>
<li><a class="reference internal" href="#id51">3.7.4-r1</a></li>
<li><a class="reference internal" href="#id52">3.7.3-r1</a></li>
<li><a class="reference internal" href="#id53">3.7.2-r1</a></li>
<li><a class="reference internal" href="#id54">3.7.1-r1</a></li>
<li><a class="reference internal" href="#id55">3.7.0.1-r1</a></li>
<li><a class="reference internal" href="#id56">3.7.0-r1</a></li>
<li><a class="reference internal" href="#id57">3.6.23.1-r1</a></li>
<li><a class="reference internal" href="#id58">3.6.23-r1</a></li>
<li><a class="reference internal" href="#id59">3.6.22-r1</a></li>
<li><a class="reference internal" href="#id60">3.6.21-r1</a></li>
<li><a class="reference internal" href="#id61">3.6.20-r1</a></li>
<li><a class="reference internal" href="#id62">3.6.19-r1</a></li>
<li><a class="reference internal" href="#id63">3.6.18-r1</a></li>
<li><a class="reference internal" href="#id64">3.6.17-r1</a></li>
<li><a class="reference internal" href="#id65">3.6.16-r1</a></li>
<li><a class="reference internal" href="#id66">3.6.15-r1</a></li>
<li><a class="reference internal" href="#id67">3.6.14.2-r1</a></li>
<li><a class="reference internal" href="#id68">3.6.14.1-r1</a></li>
<li><a class="reference internal" href="#id69">3.6.13-r1</a></li>
<li><a class="reference internal" href="#id70">3.6.11-r1</a></li>
<li><a class="reference internal" href="#id71">3.6.10-r1</a></li>
<li><a class="reference internal" href="#id72">3.6.6.2-r1</a></li>
<li><a class="reference internal" href="#id73">3.6.5-r1</a></li>
<li><a class="reference internal" href="#id74">3.6.3-r1</a></li>
<li><a class="reference internal" href="#id75">3.5.9-r2</a></li>
<li><a class="reference internal" href="#id76">3.5.9-r1</a></li>
<li><a class="reference internal" href="#id77">3.3.13-r1</a></li>
<li><a class="reference internal" href="#id78">3.3.10-r1</a></li>
<li><a class="reference internal" href="#id79">3.3.9-r1</a></li>
<li><a class="reference internal" href="#id81">3.3.8-r1</a></li>
<li><a class="reference internal" href="#id82">3.3.7-r1</a></li>
<li><a class="reference internal" href="#id83">3.3.5-r1</a></li>
<li><a class="reference internal" href="#id84">3.2.7-r1</a></li>
<li><a class="reference internal" href="#id85">3.2.2-r1</a></li>
<li><a class="reference internal" href="#id86">3.2.1-r1</a></li>
<li><a class="reference internal" href="#id87">3.1.3-r1</a></li>
<li><a class="reference internal" href="#r3">3.0.8-r3</a></li>
<li><a class="reference internal" href="#id88">3.0.8-r2</a></li>
<li><a class="reference internal" href="#id89">3.0.8-r1</a></li>
</ul>
</li>
</ul>

  <h4>Previous topic</h4>
  <p class="topless"><a href="copyright.html"
                        title="previous chapter">Copyright and License</a></p>
  <div role="note" aria-label="source link">
    <h3>This Page</h3>
    <ul class="this-page-menu">
      <li><a href="_sources/changes.txt"
            rel="nofollow">Show Source</a></li>
    </ul>
   </div>
<div id="searchbox" style="display: none" role="search">
  <h3>Quick search</h3>
    <form class="search" action="search.html" method="get">
      <div><input type="text" name="q" /></div>
      <div><input type="submit" value="Go" /></div>
      <input type="hidden" name="check_keywords" value="yes" />
      <input type="hidden" name="area" value="default" />
    </form>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
        </div>
      </div>
      <div class="clearer"></div>
    </div>
    <div class="related" role="navigation" aria-label="related navigation">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="genindex.html" title="General Index"
             >index</a></li>
        <li class="right" >
          <a href="py-modindex.html" title="Python Module Index"
             >modules</a> |</li>
        <li class="right" >
          <a href="copyright.html" title="Copyright and License"
             >previous</a> |</li>
        <li class="nav-item nav-item-0"><a href="index.html">APSW 3.16.2-r1 documentation</a> &#187;</li> 
      </ul>
    </div>

    <div class="footer" role="contentinfo">
        &#169; <a href="copyright.html">Copyright</a> 2004-2016, Roger Binns &lt;rogerb@rogerbinns.com&gt;.
      Last updated on Jan 14, 2017.
      Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.4.8.
    </div>

  </body>
</html>