How should I tell DBD::SQLite to use a newer binary?

Cody Fendant has asked for the wisdom of the Perl Monks concerning the following question:

I have DBD::SQLite installed.

It's using /usr/bin/sqlite3 which is old, and I'd like it to use /opt/bin/sqlite3 which is much newer.

How do I get it to use the newer binary? Reinstall, presumably? I can't see anything obvious by looking through the Makefile or other files in the distribution which would show me how it finds, or chooses, a particular path.

Comment on How should I tell DBD::SQLite to use a newer binary? Select or Download Code

Replies are listed 'Best First'.
Re: How should I tell DBD::SQLite to use a newer binary? by soonix (Chancellor) on Dec 15, 2023 at 07:18 UTC
From DBD::SQLite itself: DBD::SQLite is a Perl DBI driver for SQLite, that includes the entire thing in the distribution. This means it uses its own ~~binary~~ library. I see that the repository contains an updated version of sqlite3, but DBD::SQLite (the distribution) seemingly doesn't (yet). If all else fails, download the tarball, replace the sqlite3 files there, and (re)install manually.	[reply]
Re^2: How should I tell DBD::SQLite to use a newer binary? by Cody Fendant (Hermit) on Jan 03, 2024 at 20:08 UTC
Thanks!	[reply]