Can I use a later of version of sqlite3 with python?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







2















I am using python 3.5.1 which comes with an sqlite version of 3.8.11. I wonder if I could use another version of sqlite (say the latest one as of now) with my current python. If the answer is yes then how do I do that? Learning from here I tried this but it does not do anything:



pip install sqlite3 --upgrade


I am using sqlite3 in my django project that needs full-text search. So I was reading this, and at a point I was tempted to use the latest version of sqlite3 as it said it had some improvements over the previous versions, which seemed interesting to me. Anyway, is it possible to use later version of sqlite3 without upgrading python?





Note: the question is almost completely re-written, so many comments may seem irrelevant. Thanks to Alasdair, I came to know that the previous question didn't make any sense, hence I re-wrote it.










share|improve this question




















  • 1





    Sqlite3 comes as part of your Python installation, so upgrading Django won't make any difference.

    – Alasdair
    Jan 24 '16 at 19:07













  • Oops! Looks like the whole question is non-sense then. We can surely upgrade sqlite with pip, then that upgraded version obviously gets used by django. Didn't think of it when I wrote the question. What can I do with this question now @Alasdair, should I delete it? :-(

    – Sнаđошƒаӽ
    Jan 25 '16 at 11:41








  • 2





    sqlite3 is part of the Python installation, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me.

    – Alasdair
    Jan 25 '16 at 11:57













  • You don't have to delete the question, but you might want to edit it so that it mentions Python instead of Django. It might help if you explain why you want to upgrade sqlite3 as well.

    – Alasdair
    Jan 25 '16 at 11:59


















2















I am using python 3.5.1 which comes with an sqlite version of 3.8.11. I wonder if I could use another version of sqlite (say the latest one as of now) with my current python. If the answer is yes then how do I do that? Learning from here I tried this but it does not do anything:



pip install sqlite3 --upgrade


I am using sqlite3 in my django project that needs full-text search. So I was reading this, and at a point I was tempted to use the latest version of sqlite3 as it said it had some improvements over the previous versions, which seemed interesting to me. Anyway, is it possible to use later version of sqlite3 without upgrading python?





Note: the question is almost completely re-written, so many comments may seem irrelevant. Thanks to Alasdair, I came to know that the previous question didn't make any sense, hence I re-wrote it.










share|improve this question




















  • 1





    Sqlite3 comes as part of your Python installation, so upgrading Django won't make any difference.

    – Alasdair
    Jan 24 '16 at 19:07













  • Oops! Looks like the whole question is non-sense then. We can surely upgrade sqlite with pip, then that upgraded version obviously gets used by django. Didn't think of it when I wrote the question. What can I do with this question now @Alasdair, should I delete it? :-(

    – Sнаđошƒаӽ
    Jan 25 '16 at 11:41








  • 2





    sqlite3 is part of the Python installation, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me.

    – Alasdair
    Jan 25 '16 at 11:57













  • You don't have to delete the question, but you might want to edit it so that it mentions Python instead of Django. It might help if you explain why you want to upgrade sqlite3 as well.

    – Alasdair
    Jan 25 '16 at 11:59














2












2








2








I am using python 3.5.1 which comes with an sqlite version of 3.8.11. I wonder if I could use another version of sqlite (say the latest one as of now) with my current python. If the answer is yes then how do I do that? Learning from here I tried this but it does not do anything:



pip install sqlite3 --upgrade


I am using sqlite3 in my django project that needs full-text search. So I was reading this, and at a point I was tempted to use the latest version of sqlite3 as it said it had some improvements over the previous versions, which seemed interesting to me. Anyway, is it possible to use later version of sqlite3 without upgrading python?





Note: the question is almost completely re-written, so many comments may seem irrelevant. Thanks to Alasdair, I came to know that the previous question didn't make any sense, hence I re-wrote it.










share|improve this question
















I am using python 3.5.1 which comes with an sqlite version of 3.8.11. I wonder if I could use another version of sqlite (say the latest one as of now) with my current python. If the answer is yes then how do I do that? Learning from here I tried this but it does not do anything:



pip install sqlite3 --upgrade


I am using sqlite3 in my django project that needs full-text search. So I was reading this, and at a point I was tempted to use the latest version of sqlite3 as it said it had some improvements over the previous versions, which seemed interesting to me. Anyway, is it possible to use later version of sqlite3 without upgrading python?





Note: the question is almost completely re-written, so many comments may seem irrelevant. Thanks to Alasdair, I came to know that the previous question didn't make any sense, hence I re-wrote it.







python django sqlite3






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited May 23 '17 at 11:46









Community

11




11










asked Jan 24 '16 at 16:40









SнаđошƒаӽSнаđошƒаӽ

7,495104567




7,495104567








  • 1





    Sqlite3 comes as part of your Python installation, so upgrading Django won't make any difference.

    – Alasdair
    Jan 24 '16 at 19:07













  • Oops! Looks like the whole question is non-sense then. We can surely upgrade sqlite with pip, then that upgraded version obviously gets used by django. Didn't think of it when I wrote the question. What can I do with this question now @Alasdair, should I delete it? :-(

    – Sнаđошƒаӽ
    Jan 25 '16 at 11:41








  • 2





    sqlite3 is part of the Python installation, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me.

    – Alasdair
    Jan 25 '16 at 11:57













  • You don't have to delete the question, but you might want to edit it so that it mentions Python instead of Django. It might help if you explain why you want to upgrade sqlite3 as well.

    – Alasdair
    Jan 25 '16 at 11:59














  • 1





    Sqlite3 comes as part of your Python installation, so upgrading Django won't make any difference.

    – Alasdair
    Jan 24 '16 at 19:07













  • Oops! Looks like the whole question is non-sense then. We can surely upgrade sqlite with pip, then that upgraded version obviously gets used by django. Didn't think of it when I wrote the question. What can I do with this question now @Alasdair, should I delete it? :-(

    – Sнаđошƒаӽ
    Jan 25 '16 at 11:41








  • 2





    sqlite3 is part of the Python installation, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me.

    – Alasdair
    Jan 25 '16 at 11:57













  • You don't have to delete the question, but you might want to edit it so that it mentions Python instead of Django. It might help if you explain why you want to upgrade sqlite3 as well.

    – Alasdair
    Jan 25 '16 at 11:59








1




1





Sqlite3 comes as part of your Python installation, so upgrading Django won't make any difference.

– Alasdair
Jan 24 '16 at 19:07







Sqlite3 comes as part of your Python installation, so upgrading Django won't make any difference.

– Alasdair
Jan 24 '16 at 19:07















Oops! Looks like the whole question is non-sense then. We can surely upgrade sqlite with pip, then that upgraded version obviously gets used by django. Didn't think of it when I wrote the question. What can I do with this question now @Alasdair, should I delete it? :-(

– Sнаđошƒаӽ
Jan 25 '16 at 11:41







Oops! Looks like the whole question is non-sense then. We can surely upgrade sqlite with pip, then that upgraded version obviously gets used by django. Didn't think of it when I wrote the question. What can I do with this question now @Alasdair, should I delete it? :-(

– Sнаđошƒаӽ
Jan 25 '16 at 11:41






2




2





sqlite3 is part of the Python installation, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me.

– Alasdair
Jan 25 '16 at 11:57







sqlite3 is part of the Python installation, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me.

– Alasdair
Jan 25 '16 at 11:57















You don't have to delete the question, but you might want to edit it so that it mentions Python instead of Django. It might help if you explain why you want to upgrade sqlite3 as well.

– Alasdair
Jan 25 '16 at 11:59





You don't have to delete the question, but you might want to edit it so that it mentions Python instead of Django. It might help if you explain why you want to upgrade sqlite3 as well.

– Alasdair
Jan 25 '16 at 11:59












1 Answer
1






active

oldest

votes


















2














After some googling I found a way to do this. You need to download the sqlite3.dll (pre-compiled binary) file from here. Then copy over this file in the DLLs folder in the python installation directory. You may want to make a backup of your old sqlite3.dll file just in case you may decide to revert.






share|improve this answer
























  • I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

    – Serge Norin
    Oct 13 '17 at 10:45











  • @SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

    – Sнаđошƒаӽ
    Oct 13 '17 at 12:29












Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f34978425%2fcan-i-use-a-later-of-version-of-sqlite3-with-python%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









2














After some googling I found a way to do this. You need to download the sqlite3.dll (pre-compiled binary) file from here. Then copy over this file in the DLLs folder in the python installation directory. You may want to make a backup of your old sqlite3.dll file just in case you may decide to revert.






share|improve this answer
























  • I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

    – Serge Norin
    Oct 13 '17 at 10:45











  • @SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

    – Sнаđошƒаӽ
    Oct 13 '17 at 12:29
















2














After some googling I found a way to do this. You need to download the sqlite3.dll (pre-compiled binary) file from here. Then copy over this file in the DLLs folder in the python installation directory. You may want to make a backup of your old sqlite3.dll file just in case you may decide to revert.






share|improve this answer
























  • I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

    – Serge Norin
    Oct 13 '17 at 10:45











  • @SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

    – Sнаđошƒаӽ
    Oct 13 '17 at 12:29














2












2








2







After some googling I found a way to do this. You need to download the sqlite3.dll (pre-compiled binary) file from here. Then copy over this file in the DLLs folder in the python installation directory. You may want to make a backup of your old sqlite3.dll file just in case you may decide to revert.






share|improve this answer













After some googling I found a way to do this. You need to download the sqlite3.dll (pre-compiled binary) file from here. Then copy over this file in the DLLs folder in the python installation directory. You may want to make a backup of your old sqlite3.dll file just in case you may decide to revert.







share|improve this answer












share|improve this answer



share|improve this answer










answered Jan 26 '16 at 10:26









SнаđошƒаӽSнаđошƒаӽ

7,495104567




7,495104567













  • I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

    – Serge Norin
    Oct 13 '17 at 10:45











  • @SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

    – Sнаđошƒаӽ
    Oct 13 '17 at 12:29



















  • I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

    – Serge Norin
    Oct 13 '17 at 10:45











  • @SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

    – Sнаđошƒаӽ
    Oct 13 '17 at 12:29

















I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

– Serge Norin
Oct 13 '17 at 10:45





I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"?

– Serge Norin
Oct 13 '17 at 10:45













@SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

– Sнаđошƒаӽ
Oct 13 '17 at 12:29





@SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows!

– Sнаđошƒаӽ
Oct 13 '17 at 12:29




















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f34978425%2fcan-i-use-a-later-of-version-of-sqlite3-with-python%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Xamarin.iOS Cant Deploy on Iphone

Glorious Revolution

Dulmage-Mendelsohn matrix decomposition in Python