01-26-2022, 05:34 PM
(This post was last modified: 01-26-2022, 05:35 PM by TheOldPresbyope.
Edit Reason: typo
)
@jass199012
Looks pretty trivial to build sqlite3 from source. Here's what I did as a test.
where the lines beginning "pi@CM4:~xxx $ " contain the commands I entered. This all too less than a minute or two on my CM4 connected wirelessly to a reasonably fast ISP.
Regards,
Kent
Looks pretty trivial to build sqlite3 from source. Here's what I did as a test.
Code:
pi@CM4:~ $ wget https://www.sqlite.org/2022/sqlite-amalgamation-3370200.zip
--2022-01-26 12:29:19-- https://www.sqlite.org/2022/sqlite-amalgamation-3370200.zip
Resolving www.sqlite.org (www.sqlite.org)... 2600:3c00::f03c:91ff:fe96:b959, 45.33.6.223
Connecting to www.sqlite.org (www.sqlite.org)|2600:3c00::f03c:91ff:fe96:b959|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2502722 (2.4M) [application/zip]
Saving to: ‘sqlite-amalgamation-3370200.zip’
sqlite-amalgamation 100%[===================>] 2.39M 2.07MB/s in 1.2s
2022-01-26 12:29:21 (2.07 MB/s) - ‘sqlite-amalgamation-3370200.zip’ saved [2502722/2502722]
pi@CM4:~ $ unzip sqlite-amalgamation-3370200.zip
Archive: sqlite-amalgamation-3370200.zip
creating: sqlite-amalgamation-3370200/
inflating: sqlite-amalgamation-3370200/sqlite3.c
inflating: sqlite-amalgamation-3370200/shell.c
inflating: sqlite-amalgamation-3370200/sqlite3ext.h
inflating: sqlite-amalgamation-3370200/sqlite3.h
pi@CM4:~ $ cd sqlite-amalgamation-3370200
pi@CM4:~/sqlite-amalgamation-3370200 $ gcc shell.c sqlite3.c -lpthread -ldl -lm -o sqlite3
pi@CM4:~/sqlite-amalgamation-3370200 $ ./sqlite3
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>where the lines beginning "pi@CM4:~xxx $ " contain the commands I entered. This all too less than a minute or two on my CM4 connected wirelessly to a reasonably fast ISP.
Regards,
Kent
