DuckDB 1.4新增功能提前知道

计划在9月10日发布,从github的提交信息可以看出:
1.增加了copy to 'file.blob’功能#18840
测试用例如下

# name: test/sql/copy/copy_blob.test
# group: [copy]
statement error
COPY (select 'foo') TO '__TEST_DIR__/test.blob' (FORMAT BLOB);
----
Binder Error: "COPY (FORMAT BLOB)" only supports a single BLOB column
statement error
COPY (select 'foo'::BLOB, 10) TO '__TEST_DIR__/test.blob' (FORMAT BLOB);
----
Binder Error: "COPY (FORMAT BLOB)" only supports a single BLOB column
statement ok
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test.blob' (FORMAT BLOB);
query III
select filename LIKE '%test.blob', content, size from read_blob('__TEST_DIR__/test.blob');
----
true	foo	3
statement error
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test.blob.gz' (FORMAT BLOB, ASDFGH);
----
Binder Error: Unrecognized option for COPY (FORMAT BLOB): "ASDFGH"
# With compression
statement ok
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test.blob.gz' (FORMAT BLOB);
query II
select filename LIKE '%test.blob.gz', size from read_blob('__TEST_DIR__/test.blob.gz');
----
true	26
# With explicit compression
statement ok
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test2.blob' (FORMAT BLOB, COMPRESSION 'GZIP');
query II
select filename LIKE '%test2.blob', size from read_blob('__TEST_DIR__/test2.blob');
----
true	26

这个功能可以用数据库保存任何格式的文件,要用的时候就用copy to到文件的方式取回,而不用依赖自己编程的方式,比如在里面保存另一个数据库,然后attach,保存一个插件,然后load,把查询结果保存成json或csv文件,然后根据条件输出为文件,还可以支持压缩。

2.增加了数据库加密模式

Add more encryption modes CTR and CBC #18619
We add support for additional AES modes CTR and CBC with the new
ATTACH flag ENCRYPTION_CIPHER.

ATTACH '...' (ENCRYPTION_KEY 'asdf'); -- will use GCM, the default and recommended
ATTACH '...' (ENCRYPTION_KEY 'asdf', ENCRYPTION_CIPHER 'GCM'); 
ATTACH '...' (ENCRYPTION_KEY 'asdf', ENCRYPTION_CIPHER 'CTR');
ATTACH '...' (ENCRYPTION_KEY 'asdf', ENCRYPTION_CIPHER 'CBC');

We also add support for querying the encryption mode from SQL with two
new columns encrypted (BOOLEAN) and cipher (VARCHAR):

ATTACH 'encrypted.duckdb' (ENCRYPTION_KEY 'asdf', ENCRYPTION_CIPHER 'CTR'); 
SELECT database_name, encrypted, cipher FROM duckdb_databases();
database_nameencryptedcipher
encryptedtrueCTR
memoryfalseNULL
systemfalseNULL
tempfalseNULL
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值