Question

我在10.6.8时将第3组升级。现有3.6.12版,安装在/usr/bin/和3.7.14版,安装在/usr/ local/bin/。这是安装这一系统的最佳方式吗?

mkdir ~/tempFolder
cd ~/tempFolder
curl https://www.sqlite.org/sqlite-autoconf-3071400.tar.gz | tar xvz
cd sqlite-autoconf-3071400
autoconf
./configure
make
sudo make install

如果不是的话,我应该做些什么来纠正? 最后,在我进入路程时,只有3.7.14点。我读到,如果我更新了《路况》,我可以简单地打上“qlite”3号,因为它将首先看上去。我也阅读了一些文章,说我需要更新,而如果我不把所有指挥都穿过炮弹的话,那么我就会大声疾呼。用什么最佳方法把 Apple子和 Apple子的 latest子打上像样的ll子? 简单地安装最新版本是否容易?

property databaseFolder : POSIX path of (path to public folder as text) & "Databases/"
property databaseName : "myDatabase"
property databasePath : quoted form of (databaseFolder & databaseName as text)
property table1 : "Main"

set xxx to do shell script "sqlite3 " & databasePath & " "select * from " & table1 & "; ""

Answer 1

Use the precompiled binary provided bykouite. a. 装箱,在码头操作:

$ cd folder_where_sqlite3_was_unpacked
$ ./sqlite3

As an alternative, install SQLite from MacPorts. MacPorts ist useful to install a lot of Un*x tools, not only SQLite.

Answer 2

Binary zip file may not be the best option. To upgrade my sqlite3 installation, i download the source bundle e.g. sqlite-snapshot-201707212031.tar.gz, untar it in temp folder, go there and do make, followed by make install . To check the installation, run sqlite3 command and observe the version shown.

Answer 3

这是我在SOSX Ventura(10.13.4)上是如何做到的:

我从以下来源汇编了自己的qlite3:。 https://www.sqlite.org/download.html。

configure prefix=/usr/local
make ; sudo make install

之后,我的道路上又加上了/usr/ local/bin。

之后,在我的布斯塔尔加了这段话(这似乎就是trick):

export DYLD_LIBRARY_PATH=/usr/local/lib:/usr/lib

This is my test python program it shows that the sqlite3 module is using the version I compiled and installed in /usr/local:

import sqlite3

print(sqlite3.sqlite_version)
print(sqlite3.sqlite_version_info)

conn = sqlite3.connect(":memory:")
cursor = conn.cursor()

cursor.execute("select * from pragma_compile_options()")
x = cursor.fetchall()
print(x)

友情链接