1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
= New Features
* The pg_json_ops extension now supports the json_exists, json_value,
and json_query functions added in PostgreSQL 17:
Sequel.extension :pg_json_ops
j = Sequel.pg_json_op(:jsonb_column)
j.exists('$.foo') # json_exists(jsonb_column, '$.foo')
j.value('$.foo') # json_value(jsonb_column, '$.foo')
j.query('$.foo') # json_query(jsonb_column, '$.foo')
j.exists('$.foo', passing: {a: 1}) # json_exists(jsonb_column, '$.foo' PASSING 1 AS a)
j.value('$.foo', returning: Time) # json_value(jsonb_column, '$.foo' RETURNING timestamp)
j.query('$.foo', wrapper: true) # json_query(jsonb_column, '$.foo' WITH WRAPPER)
All clauses supported by PostgreSQL 17 are supported via options
(supported options differ per method):
* :on_error : ON ERROR
* :on_empty : ON EMPTY
* :passing : PASSING
* :returning : RETURNING
* :wrapper : WITH WRAPPER | OMIT QUOTES
* On SQLite, Database#create_table now supports a :using option to
create a virtual table:
DB.create_table(:t, using: 'fts5(email)')
# CREATE VIRTUAL TABLE t USING fts5(email)
= Other Improvements
* The gem size has been reduced 25% by removing documentation.
|
