I have a Mac Mini (Apple M1) with Sonoma 14.4.1 and sqlite 3.43.2 installed.
eloy@Eloys-Mac-mini ~ % sqlite3 -version
3.43.2 2023-10-10 13:08:14 1b37c146ee9ebb7acd0160c0ab1fd11017a419fa8a3187386ed8cb32b709aapl (64-bit)
I’m trying to open a database running on 3.42.0 with DB Browser for SQLite but I get an error:
malformed database schema (messages_on_insert_insert_mentions) - near ">>": syntax error
I’ve searching how to downgrade the SQLite version with brew install and brew execute and I was trying to compile the source code myself but I couldn’t find the amalgamation.
I’m stuck here and I don’t know how to go on.
Thanks in advance for your help.