在python中存储列表的最好方法？

import pickle

my_list = [1, 2, 3, 4, 5]

# 保存列表到文件
with open('list.pkl', 'wb') as f:
    pickle.dump(my_list, f)

# 从文件中加载列表
with open('list.pkl', 'rb') as f:
    loaded_list = pickle.load(f)

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

import json

my_list = [1, 2, 3, 4, 5]

# 保存列表到文件
with open('list.json', 'w') as f:
    json.dump(my_list, f)

# 从文件中加载列表
with open('list.json', 'r') as f:
    loaded_list = json.load(f)

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

import sqlite3

my_list = [1, 2, 3, 4, 5]

# 连接到SQLite数据库
conn = sqlite3.connect('mydatabase.db')
cursor = conn.cursor()

# 创建表格
cursor.execute('CREATE TABLE IF NOT EXISTS mytable (value INTEGER)')

# 将列表中的元素插入表格
for item in my_list:
    cursor.execute('INSERT INTO mytable VALUES (?)', (item,))

# 提交更改并关闭连接
conn.commit()
conn.close()

# 从数据库中加载列表
conn = sqlite3.connect('mydatabase.db')
cursor = conn.cursor()

cursor.execute('SELECT value FROM mytable')
loaded_list = [row[0] for row in cursor.fetchall()]

conn.close()

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]