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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
= New Features
* A :cache_file plugin option has been added to the
pg_auto_constraint_validations plugin. This option specifies
a file to use to cache the metadata the plugin uses, so the
plugin does not need to run 5 queries per model at startup to
load the metadata. This can dramatically improve startup time
when using the plugin with a large number of models.
To create the metadata file, load the plugin into Sequel::Model
(or whatever class you are using as the base class for your
model classes) with the :cache_file option, and after loading
all of the subclasses of that class, run:
Sequel::Model.dump_pg_auto_constraint_validations_cache
As when using the schema_caching and index_caching extensions,
it is up to the user to ensure that the cached metadata matches
the current database schema. Sequel does no checking of this,
as checking would take more time, and the point of this plugin
is to improve startup performance.
* A static_cache_cache plugin has been added. This plugin allows
for caching rows for models using the static_cache plugin. This
prevents the need to issue a query at model creation time to
get the rows. This plugin should be loaded into Sequel::Model
(or whatever class you are using as the base class for your
model classes) before loading the models using the static_cache
plugin. To create the metadata file, after all subclasses of
that class have been loaded, run:
Sequel::Model.dump_static_cache_cache
* :unique_deferrable and :primary_key_deferrable column
options are now supported on PostgreSQL 9+ and Oracle. This
allows you to created deferrable unique and primary key
column constraints. You could already create deferrable
table constraints using the :deferrable option to the primary_key
and unique methods.
* A :generated_always_as column option is now supported on
PostgreSQL 12+, for creating generated columns.
* A Database#skip_logging? private method has been added. This
is designed for use in extensions, to force log timing even
when no loggers are configured.
= Other Improvements
* Sequel no longer sets the :host option to localhost by default
in the mysql2 adapter. This prevents Sequel from overriding
a host specified in the defaults_file.
* All database array types are converted to Ruby arrays in the
jdbc adapter. Previously, this was only done in the
jdbc/postgresql subadapter.
|
