SQLite User Forum

Best Version for Win XP/Win 10 compatibility
Login

Best Version for Win XP/Win 10 compatibility

(1) By anonymous on 2022-06-06 17:17:28 [source]

Hello,

I am in the process of adding sqlite features to an old program that needs to run on both Windows XP and Win 10 OS but am unsure of which version would best suit those needs. If someone could recommend the version or point me to where that type of documentation would be listed I would appreciate it.

Thank you for your time

(2) By Larry Brasfield (larrybr) on 2022-06-06 17:59:53 in reply to 1 [link] [source]

I think there is no such documentation.1

I would suggest trying to build the latest released version of the SQLite library using the tools you have for targeting Windows XP. I doubt you will run into a problem, but if you do, then knowing what goes wrong during the attempt will be a good starting point for discovering when such (now hypothetical) incompatibility arose during the evolution of the library.


  1. ^ As someone who looks at the SQLite documentation quite a bit, this is not a mere statement of ignorance.

(3) By Simon Slavin (slavin) on 2022-06-06 19:19:27 in reply to 1 [link] [source]

I understand your thought process, and are used to it in other programming, but it does not apply to SQLite, which is an unusual piece of software. Version changes in SQLite make little difference to the average programmer or user.

From version 3.0 there have been no major changes in database file format. Any version of SQLite released after version 3.31.0 (2020-01-22) can read or write the same files.

Use whichever version from that one onward are included with the OS, your development tools, or your language's popular libraries. If none of these include SQLite, use whatever version of the 'amalgamation' happens to be currently on SQLite's download page.

Good luck with your project.

(4) By anonymous on 2022-06-06 19:51:09 in reply to 2 [link] [source]

Thank you for the insight, I will proceed ahead knowing its unlikely to be wasted development time.

(5) By anonymous on 2022-06-06 19:56:50 in reply to 3 [link] [source]

Good to know I can proceed with development without the expectation of compatibility issues. Also thank you for the luck, I can always use it. :)