Can SQLite3 be upgraded on Ubuntu?What's the best approach to triggering a distro upgrade for an OEM build?Is it good practice to backport source packages from newer Ubuntu releases?Could not calculate the upgrade, what happened?Upgrade from 10.04 to 14.04 ubuntu desktopHow to Exit sqlite3 in terminalLTS pre-release or 2-year old LTS than upgrade? Which has less headaches historically?How can I upgrade to the latest wpa_supplicant?Current version of `mitmproxy` for 14.04Upgrade got stuck. How can I fix this?Invalid output from pipe-menu "openbox-menu xfce-application menu

Why didn't Boeing produce its own regional jet?

Processor speed limited at 0.4 Ghz

Rotate ASCII Art by 45 Degrees

How to coordinate airplane tickets?

What Exploit Are These User Agents Trying to Use?

Avoiding the "not like other girls" trope?

What's the meaning of "Sollensaussagen"?

Do creatures with a speed 0ft., fly 30ft. (hover) ever touch the ground?

Unlock My Phone! February 2018

What is a Samsaran Word™?

Why was the shrink from 8″ made only to 5.25″ and not smaller (4″ or less)

How to install cross-compiler on Ubuntu 18.04?

What do you call someone who asks many questions?

What is the fastest integer factorization to break RSA?

How can I deal with my CEO asking me to hire someone with a higher salary than me, a co-founder?

Do Iron Man suits sport waste management systems?

Is it a bad idea to plug the other end of ESD strap to wall ground?

Sums of two squares in arithmetic progressions

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

Can a virus destroy the BIOS of a modern computer?

Different meanings of こわい

Does the Idaho Potato Commission associate potato skins with healthy eating?

Finding the reason behind the value of the integral.

How obscure is the use of 令 in 令和?



Can SQLite3 be upgraded on Ubuntu?


What's the best approach to triggering a distro upgrade for an OEM build?Is it good practice to backport source packages from newer Ubuntu releases?Could not calculate the upgrade, what happened?Upgrade from 10.04 to 14.04 ubuntu desktopHow to Exit sqlite3 in terminalLTS pre-release or 2-year old LTS than upgrade? Which has less headaches historically?How can I upgrade to the latest wpa_supplicant?Current version of `mitmproxy` for 14.04Upgrade got stuck. How can I fix this?Invalid output from pipe-menu "openbox-menu xfce-application menu













2















I would like to upgrade SQLite3 on my Ubuntu instance that is running version 3.8.2. The current release is 3.11.1.x. I wanted to know if there is any risk in doing so since SQLite3 is a core tool to Ubuntu and many apps use it.



If its safe to do, what is the best approach? Install from the Linux distribution or download source and build?



Thanks










share|improve this question


























    2















    I would like to upgrade SQLite3 on my Ubuntu instance that is running version 3.8.2. The current release is 3.11.1.x. I wanted to know if there is any risk in doing so since SQLite3 is a core tool to Ubuntu and many apps use it.



    If its safe to do, what is the best approach? Install from the Linux distribution or download source and build?



    Thanks










    share|improve this question
























      2












      2








      2








      I would like to upgrade SQLite3 on my Ubuntu instance that is running version 3.8.2. The current release is 3.11.1.x. I wanted to know if there is any risk in doing so since SQLite3 is a core tool to Ubuntu and many apps use it.



      If its safe to do, what is the best approach? Install from the Linux distribution or download source and build?



      Thanks










      share|improve this question














      I would like to upgrade SQLite3 on my Ubuntu instance that is running version 3.8.2. The current release is 3.11.1.x. I wanted to know if there is any risk in doing so since SQLite3 is a core tool to Ubuntu and many apps use it.



      If its safe to do, what is the best approach? Install from the Linux distribution or download source and build?



      Thanks







      upgrade sqlite3






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Sep 23 '15 at 15:13









      J.D. CorbinJ.D. Corbin

      1112




      1112




















          4 Answers
          4






          active

          oldest

          votes


















          3














          I am afraid nobody can possibly tell you that it is safe. That would mean that we can be 100% sure that the changes made after 3.8.2 will not affect your installation. That is obviously impossible. The prudent way would be to test the new version on a test system that is not used for production, and if nothing goes wrong as far as you can see, upgrading your production system.



          It might be wise to read the release notes though.






          share|improve this answer






























            1














            I doubt that any major changes would be made in a minor release change from 3.8.2 - 3.8.11.



            If SQLite uses Semantic Versioning like many projects do, the only time major changes that would affect compatibility are made is between major versions (eg. 3.x.x -> 4.x.x in this case). Thus, you should be okay to upgrade it, but of course you should read over the changelogs for confirmation.



            As for the proper way to do it, if you keep your system up to date, then you will have the most up to date version of SQLite3 available to your Ubuntu release available in the official repositories. You can make sure of this by running sudo apt-get update && sudo apt-get upgrade && sudo apt-get dist-upgrade.



            As it stands currently, the newest version of SQLite3 available to 14.04 LTS is 3.8.2, as per this page. The latest version available through official repositories period is the 3.8.11.1 release, available to the 15.10 release.



            Thus, if you want to use 3.11.x on your system, you will have to do it manually from sources provided by SQlite.






            share|improve this answer






























              1














              If everything works fine for you on 3.8.2 I advise you to not upgrade. Take a look to the change-log to see if any change important to you has been done.




              SQLite 3.8.2 is the latest stable and supported version for Ubuntu 14.04.



              SQLite 3.11.1 is the package aimed at Ubuntu 15.04 and is currently only present in the Vivid Vervet repository.



              Refer here for more information.




              If you still want to upgrade :



              On Ubuntu 15.04 you simply need to run the following command to update your SQLite package :



              sudo apt-get update 
              sudo apt-get upgrade



              On Ubuntu 14.04 you have to download and install Precompiled Binaries for Linux available on SQLite website.






              share|improve this answer
































                1














                Yes, it can



                Just follow instructions at the last lines in this dockerfile https://github.com/disarticulate/docker-python-sqlite and fresh libsqlite3.so will be installed to /usr/lib



                Then discover actual placement of system wide libsqlite3.so (/usr/lib/x86_64-linux-gnu, for ex) and correct symlinks to be pointed to /usr/lib/libsqlite3.so been compiled earlier






                share|improve this answer








                New contributor




                Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.




















                  Your Answer








                  StackExchange.ready(function()
                  var channelOptions =
                  tags: "".split(" "),
                  id: "89"
                  ;
                  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%2faskubuntu.com%2fquestions%2f677528%2fcan-sqlite3-be-upgraded-on-ubuntu%23new-answer', 'question_page');

                  );

                  Post as a guest















                  Required, but never shown

























                  4 Answers
                  4






                  active

                  oldest

                  votes








                  4 Answers
                  4






                  active

                  oldest

                  votes









                  active

                  oldest

                  votes






                  active

                  oldest

                  votes









                  3














                  I am afraid nobody can possibly tell you that it is safe. That would mean that we can be 100% sure that the changes made after 3.8.2 will not affect your installation. That is obviously impossible. The prudent way would be to test the new version on a test system that is not used for production, and if nothing goes wrong as far as you can see, upgrading your production system.



                  It might be wise to read the release notes though.






                  share|improve this answer



























                    3














                    I am afraid nobody can possibly tell you that it is safe. That would mean that we can be 100% sure that the changes made after 3.8.2 will not affect your installation. That is obviously impossible. The prudent way would be to test the new version on a test system that is not used for production, and if nothing goes wrong as far as you can see, upgrading your production system.



                    It might be wise to read the release notes though.






                    share|improve this answer

























                      3












                      3








                      3







                      I am afraid nobody can possibly tell you that it is safe. That would mean that we can be 100% sure that the changes made after 3.8.2 will not affect your installation. That is obviously impossible. The prudent way would be to test the new version on a test system that is not used for production, and if nothing goes wrong as far as you can see, upgrading your production system.



                      It might be wise to read the release notes though.






                      share|improve this answer













                      I am afraid nobody can possibly tell you that it is safe. That would mean that we can be 100% sure that the changes made after 3.8.2 will not affect your installation. That is obviously impossible. The prudent way would be to test the new version on a test system that is not used for production, and if nothing goes wrong as far as you can see, upgrading your production system.



                      It might be wise to read the release notes though.







                      share|improve this answer












                      share|improve this answer



                      share|improve this answer










                      answered Sep 23 '15 at 15:19









                      JosJos

                      14.7k54052




                      14.7k54052























                          1














                          I doubt that any major changes would be made in a minor release change from 3.8.2 - 3.8.11.



                          If SQLite uses Semantic Versioning like many projects do, the only time major changes that would affect compatibility are made is between major versions (eg. 3.x.x -> 4.x.x in this case). Thus, you should be okay to upgrade it, but of course you should read over the changelogs for confirmation.



                          As for the proper way to do it, if you keep your system up to date, then you will have the most up to date version of SQLite3 available to your Ubuntu release available in the official repositories. You can make sure of this by running sudo apt-get update && sudo apt-get upgrade && sudo apt-get dist-upgrade.



                          As it stands currently, the newest version of SQLite3 available to 14.04 LTS is 3.8.2, as per this page. The latest version available through official repositories period is the 3.8.11.1 release, available to the 15.10 release.



                          Thus, if you want to use 3.11.x on your system, you will have to do it manually from sources provided by SQlite.






                          share|improve this answer



























                            1














                            I doubt that any major changes would be made in a minor release change from 3.8.2 - 3.8.11.



                            If SQLite uses Semantic Versioning like many projects do, the only time major changes that would affect compatibility are made is between major versions (eg. 3.x.x -> 4.x.x in this case). Thus, you should be okay to upgrade it, but of course you should read over the changelogs for confirmation.



                            As for the proper way to do it, if you keep your system up to date, then you will have the most up to date version of SQLite3 available to your Ubuntu release available in the official repositories. You can make sure of this by running sudo apt-get update && sudo apt-get upgrade && sudo apt-get dist-upgrade.



                            As it stands currently, the newest version of SQLite3 available to 14.04 LTS is 3.8.2, as per this page. The latest version available through official repositories period is the 3.8.11.1 release, available to the 15.10 release.



                            Thus, if you want to use 3.11.x on your system, you will have to do it manually from sources provided by SQlite.






                            share|improve this answer

























                              1












                              1








                              1







                              I doubt that any major changes would be made in a minor release change from 3.8.2 - 3.8.11.



                              If SQLite uses Semantic Versioning like many projects do, the only time major changes that would affect compatibility are made is between major versions (eg. 3.x.x -> 4.x.x in this case). Thus, you should be okay to upgrade it, but of course you should read over the changelogs for confirmation.



                              As for the proper way to do it, if you keep your system up to date, then you will have the most up to date version of SQLite3 available to your Ubuntu release available in the official repositories. You can make sure of this by running sudo apt-get update && sudo apt-get upgrade && sudo apt-get dist-upgrade.



                              As it stands currently, the newest version of SQLite3 available to 14.04 LTS is 3.8.2, as per this page. The latest version available through official repositories period is the 3.8.11.1 release, available to the 15.10 release.



                              Thus, if you want to use 3.11.x on your system, you will have to do it manually from sources provided by SQlite.






                              share|improve this answer













                              I doubt that any major changes would be made in a minor release change from 3.8.2 - 3.8.11.



                              If SQLite uses Semantic Versioning like many projects do, the only time major changes that would affect compatibility are made is between major versions (eg. 3.x.x -> 4.x.x in this case). Thus, you should be okay to upgrade it, but of course you should read over the changelogs for confirmation.



                              As for the proper way to do it, if you keep your system up to date, then you will have the most up to date version of SQLite3 available to your Ubuntu release available in the official repositories. You can make sure of this by running sudo apt-get update && sudo apt-get upgrade && sudo apt-get dist-upgrade.



                              As it stands currently, the newest version of SQLite3 available to 14.04 LTS is 3.8.2, as per this page. The latest version available through official repositories period is the 3.8.11.1 release, available to the 15.10 release.



                              Thus, if you want to use 3.11.x on your system, you will have to do it manually from sources provided by SQlite.







                              share|improve this answer












                              share|improve this answer



                              share|improve this answer










                              answered Sep 23 '15 at 15:23









                              RPiAwesomenessRPiAwesomeness

                              6,561196197




                              6,561196197





















                                  1














                                  If everything works fine for you on 3.8.2 I advise you to not upgrade. Take a look to the change-log to see if any change important to you has been done.




                                  SQLite 3.8.2 is the latest stable and supported version for Ubuntu 14.04.



                                  SQLite 3.11.1 is the package aimed at Ubuntu 15.04 and is currently only present in the Vivid Vervet repository.



                                  Refer here for more information.




                                  If you still want to upgrade :



                                  On Ubuntu 15.04 you simply need to run the following command to update your SQLite package :



                                  sudo apt-get update 
                                  sudo apt-get upgrade



                                  On Ubuntu 14.04 you have to download and install Precompiled Binaries for Linux available on SQLite website.






                                  share|improve this answer





























                                    1














                                    If everything works fine for you on 3.8.2 I advise you to not upgrade. Take a look to the change-log to see if any change important to you has been done.




                                    SQLite 3.8.2 is the latest stable and supported version for Ubuntu 14.04.



                                    SQLite 3.11.1 is the package aimed at Ubuntu 15.04 and is currently only present in the Vivid Vervet repository.



                                    Refer here for more information.




                                    If you still want to upgrade :



                                    On Ubuntu 15.04 you simply need to run the following command to update your SQLite package :



                                    sudo apt-get update 
                                    sudo apt-get upgrade



                                    On Ubuntu 14.04 you have to download and install Precompiled Binaries for Linux available on SQLite website.






                                    share|improve this answer



























                                      1












                                      1








                                      1







                                      If everything works fine for you on 3.8.2 I advise you to not upgrade. Take a look to the change-log to see if any change important to you has been done.




                                      SQLite 3.8.2 is the latest stable and supported version for Ubuntu 14.04.



                                      SQLite 3.11.1 is the package aimed at Ubuntu 15.04 and is currently only present in the Vivid Vervet repository.



                                      Refer here for more information.




                                      If you still want to upgrade :



                                      On Ubuntu 15.04 you simply need to run the following command to update your SQLite package :



                                      sudo apt-get update 
                                      sudo apt-get upgrade



                                      On Ubuntu 14.04 you have to download and install Precompiled Binaries for Linux available on SQLite website.






                                      share|improve this answer















                                      If everything works fine for you on 3.8.2 I advise you to not upgrade. Take a look to the change-log to see if any change important to you has been done.




                                      SQLite 3.8.2 is the latest stable and supported version for Ubuntu 14.04.



                                      SQLite 3.11.1 is the package aimed at Ubuntu 15.04 and is currently only present in the Vivid Vervet repository.



                                      Refer here for more information.




                                      If you still want to upgrade :



                                      On Ubuntu 15.04 you simply need to run the following command to update your SQLite package :



                                      sudo apt-get update 
                                      sudo apt-get upgrade



                                      On Ubuntu 14.04 you have to download and install Precompiled Binaries for Linux available on SQLite website.







                                      share|improve this answer














                                      share|improve this answer



                                      share|improve this answer








                                      edited Sep 23 '15 at 15:26

























                                      answered Sep 23 '15 at 15:18









                                      hg8hg8

                                      9,934125591




                                      9,934125591





















                                          1














                                          Yes, it can



                                          Just follow instructions at the last lines in this dockerfile https://github.com/disarticulate/docker-python-sqlite and fresh libsqlite3.so will be installed to /usr/lib



                                          Then discover actual placement of system wide libsqlite3.so (/usr/lib/x86_64-linux-gnu, for ex) and correct symlinks to be pointed to /usr/lib/libsqlite3.so been compiled earlier






                                          share|improve this answer








                                          New contributor




                                          Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                          Check out our Code of Conduct.
























                                            1














                                            Yes, it can



                                            Just follow instructions at the last lines in this dockerfile https://github.com/disarticulate/docker-python-sqlite and fresh libsqlite3.so will be installed to /usr/lib



                                            Then discover actual placement of system wide libsqlite3.so (/usr/lib/x86_64-linux-gnu, for ex) and correct symlinks to be pointed to /usr/lib/libsqlite3.so been compiled earlier






                                            share|improve this answer








                                            New contributor




                                            Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                            Check out our Code of Conduct.






















                                              1












                                              1








                                              1







                                              Yes, it can



                                              Just follow instructions at the last lines in this dockerfile https://github.com/disarticulate/docker-python-sqlite and fresh libsqlite3.so will be installed to /usr/lib



                                              Then discover actual placement of system wide libsqlite3.so (/usr/lib/x86_64-linux-gnu, for ex) and correct symlinks to be pointed to /usr/lib/libsqlite3.so been compiled earlier






                                              share|improve this answer








                                              New contributor




                                              Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                              Check out our Code of Conduct.










                                              Yes, it can



                                              Just follow instructions at the last lines in this dockerfile https://github.com/disarticulate/docker-python-sqlite and fresh libsqlite3.so will be installed to /usr/lib



                                              Then discover actual placement of system wide libsqlite3.so (/usr/lib/x86_64-linux-gnu, for ex) and correct symlinks to be pointed to /usr/lib/libsqlite3.so been compiled earlier







                                              share|improve this answer








                                              New contributor




                                              Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                              Check out our Code of Conduct.









                                              share|improve this answer



                                              share|improve this answer






                                              New contributor




                                              Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                              Check out our Code of Conduct.









                                              answered 2 hours ago









                                              BelegnarBelegnar

                                              1111




                                              1111




                                              New contributor




                                              Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                              Check out our Code of Conduct.





                                              New contributor





                                              Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                              Check out our Code of Conduct.






                                              Belegnar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                                              Check out our Code of Conduct.



























                                                  draft saved

                                                  draft discarded
















































                                                  Thanks for contributing an answer to Ask Ubuntu!


                                                  • 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%2faskubuntu.com%2fquestions%2f677528%2fcan-sqlite3-be-upgraded-on-ubuntu%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

                                                  Are there any comparative studies done between Ashtavakra Gita and Buddhim?How is it wrong to believe that a self exists, or that it doesn't?Can you criticise or improve Ven. Bodhi's description of MahayanaWas the doctrine of 'Anatta', accepted as doctrine by modern Buddhism, actually taught by the Buddha?Relationship between Buddhism, Hinduism and Yoga?Comparison of Nirvana, Tao and Brahman/AtmaIs there a distinction between “ego identity” and “craving/hating”?Are there many differences between Taoism and Buddhism?Loss of “faith” in buddhismSimilarity between creation in Abrahamic religions and beginning of life in Earth mentioned Agganna Sutta?Are there studies about the difference between meditating in the morning versus in the evening?Can one follow Hinduism and Buddhism at the same time?Are there any prohibitions on participating in other religion's practices?Psychology of 'flow'

                                                  fallocate: fallocate failed: Text file busy in Ubuntu 17.04? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)defragmenting and increasing performance of old lubuntu system with swap partitionIssue with increasing the root partition from the swapthis /usr/bin/dpkg returned error || ubuntu-16.04, 64bitDefault 17.04 swap file locationHow to Resize Ubuntu 17.04 Zesty Swap file size?Ubuntu freezes from online formsMy Laptop is not starting after upgrade ubuntu 16.04 (Kernel 4.8.0-38 to 04.10.0-36)hcp: ERROR: FALLOCATE FAILED!Not sure my swap is being usedWine 3.0 asking for more virtual free swap

                                                  Where is the suspend/hibernate button in GNOME Shell? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)No suspend option in UI on Bionic BeaverHow can I set sleep mode in ubuntu18.04 LTS and what is the short cut key to do so?17.10 suspend not availableUbuntu 18.04 LTS missing sleep optionUbuntu 18.04 LTS - missing suspend option when power button is pressedHow to put Thinkpad X1 Extreme to sleep in Ubuntu 18.10?Suspend Button in interactive power button menu18.04 - Keep programs running after logging outway to disable Hibernate from within gconf-editor so button disappears?How can I hibernate from GNOME Shell?How can I hibernate/suspend from the command line and do so at a specific timeNo permission to suspend/hibernate after upgrading to 12.10MATE - Missing Suspend and Hibernate buttons, pressing power button shutdowns system immediatelyUbuntu 14.04: Suspend, Hibernate and Suspend-hybrid in the menu?Change “power-button-action” comand for “hibernate” option in GNOME 3.18Shutdown / Power off button does always go to suspend on 17.10Hibernate after suspend stopped working in 17.10Why doesn't the keyboard screenshot button work on Ubuntu with GNOME shell?