920833 - update sqlite3 to v2.1.17 in all tools, because this version no longer needs c++ compiling

Status: RESOLVED FIXED

(Webmaker Graveyard :: Webmaker-suite, defect)

Description

[Pomax]

sqlite3 at version 2.1.7 as we use in our tools is proving a major stumbling block for contributors. The latest version no longer requires compiling, hosting precompiled binaries on AWS for the various platforms (hurray!) and it will be much fewer headaches and c++ stack installations (no xcode! no MSVC++!) if we update all our tools to 2.1.17. 

This bug has been filed as tracking bug for the other components.

Comment 1

[Pomax]

tracking goggles, popcorn, thimble, login and wm.org

Comment 2

[Ali Al Dallal [:alicoding]]

This can be be close now I guess, but will let the Master do it :P

Comment 3

[Pomax]

it needs a version forward for webmaker-suite too, because this changes the instructions for installation, too =D

Comment 4

[Pomax]

As it turns out, on a completely clean Win32 install 2.1.17 still has an issue with a "module.js" file, which fails the precompiled validation. https://github.com/developmentseed/node-sqlite3/issues/198 has been filed, if this gets fixed we can finish up this ticket, probably with another version-forward for sqlite3...

Comment 5

[Pomax]

the solution is that any windows that sqlite3 needs to be installed on has to have the vc++ redistributatble package installed, which means any windows machine that is actually being used for programs and/or games will typically already have that be the case. I will still add this information to the README for windows users, but it's not a more-often-than-not optional step. Great win!

Comment 6

[Pomax]

Attachment: https://github.com/mozilla/thimble.webmaker.org/pull/234

hotfix for thimble, which somehow lost the correct emulated check

Comment 7

[Scott [:thecount] Downe]

Comment on attachment 811352 [details] [review]
https://github.com/mozilla/thimble.webmaker.org/pull/234

Thanks, fixed!

Comment 8

[Pomax]

234 landed.

Comment 9

[Pomax]

all tools updated.