Re:SQLite Release 3.42.0
by hnarn on Tuesday May 16, 2023 @12:28PM
(#35964167)
”You can set it before compiling” is such a foreign concept to the real world that it’s almost meaningless, if that is the only way to change the behavior it’s pretty crazy.
[ Parent
| on HN ]
I generally agree when it comes to standalone software, but not for libraries.
SQLite is both.
Setting a compiler flag is reasonable for the common case where it is included as a header file in a C/C++ application.
It is certainly inconvenient when you design with that feature in mind, but can't rely on it being part of the standard binary distributions.
Many applications use SQLite as an embedded library; that's how it's intended to be used anyway.
It doesn't really jibe all that well with things like Python though, where you typically don't do that. But it's certainly not a "foreign concept" or "almost meaningless".
For e.g. Python you can still just set the desired parameters when connecting, which should usually be handled by the database connector/driver for you.