We were faced with this error while trying to install vnstat from source on one of our servers.
checking for sqlite3_prepare_v2 in -lsqlite3... no configure: error: could not find required sqlite3 library
As to what this error is about, well SQLite is a small, fast, self-contained, high-reliability, full-featured, SQL database engine. It is used by applications that need a database but don’t need dedicated database servers.
The fix for this is pretty straightforward, you need to install the libsqlite3x-devel library. Do so by issue the following at the terminal:
yum install libsqlite3x-devel
That’s it, you’re done!