Update sqlite version for Windows build

[BigStone]

BPO	27883
Nosy	@pfmoore, @tjguk, @zware, @zooba

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2016-09-05.19:36:04.917>
created_at = <Date 2016-08-28.11:18:09.649>
labels = ['type-feature', 'OS-windows']
title = 'Update sqlite version for Windows build'
updated_at = <Date 2016-09-13.18:18:04.149>
user = 'https://bugs.python.org/BigStone'

bugs.python.org fields:

activity = <Date 2016-09-13.18:18:04.149>
actor = 'Big Stone'
assignee = 'none'
closed = True
closed_date = <Date 2016-09-05.19:36:04.917>
closer = 'zach.ware'
components = ['Windows']
creation = <Date 2016-08-28.11:18:09.649>
creator = 'Big Stone'
dependencies = []
files = []
hgrepos = []
issue_num = 27883
keywords = []
message_count = 7.0
messages = ['273821', '273823', '274285', '274424', '274425', '274427', '276316']
nosy_count = 6.0
nosy_names = ['paul.moore', 'tim.golden', 'python-dev', 'zach.ware', 'steve.dower', 'Big Stone']
pr_nums = []
priority = 'normal'
resolution = 'fixed'
stage = 'resolved'
status = 'closed'
superseder = None
type = 'enhancement'
url = 'https://bugs.python.org/issue27883'
versions = ['Python 3.6']

[BigStone]

Sqlite-3.14.1 includes a lot of fixes since sqlite-38.11, including some for windows ;-) . it would be nice to upgrade

[BigStone]

remark: since sqlite 3.11.0, sqlite.org default sqlite3.dll includes FTS3, FTS5, RTREE, DBSTAT, JSON1, and RBU extensions, causing sqlite3.dll to jump to 1646Ko size instead of 756Ko current (windows 64).

This works well over Python3.5.2 64 bit, but you may prefer a version with not all these extensions. I don't know the respective size of each one.

the JSON1 extension would be nice if we can keep it:

• web technology,
• similar to postgresql, so good to go at schools.

[zware]

I agree, we should update our sqlite version. I'll try to get to this next week, but it shouldn't be a big deal if it misses beta 1 since it's not a new feature.

[python-dev]

New changeset 792e7a8dddb8 by Zachary Ware in branch 'default':
Issue bpo-27883: Update sqlite to 3.14.1 on Windows
https://hg.python.org/cpython/rev/792e7a8dddb8

[zware]

Updated. I don't know what extensions are or are not included, please open additional issue(s) if something should be added or removed.

[BigStone]

thanks! I suppose I have to wait official python3.6b1 for windows to tell you what you included.

[BigStone]

well, json extension is not included in 3.6.0b1 . not a drama, yet a small deception