Mercurial > hg > orthanc-databases
annotate PostgreSQL/NEWS @ 569:f18e46d7dbf8 attach-custom-data
merged find-refactoring -> attach-custom-data
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Tue, 24 Sep 2024 15:04:21 +0200 |
| parents | cd9521e04249 12f1c5265081 |
| children |
| rev | line source |
|---|---|
|
499
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
1 Pending changes in the mainline |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
2 =============================== |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
3 |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
4 DB schema revision: 2 |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
5 Minimum plugin SDK (for build): 1.12.3 |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
6 Minimum Orthanc runtime: 1.12.3 |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
7 |
| 500 | 8 * Fix updates from plugin version 3.3 to latest version |
| 535 | 9 * Added support for ExtendedChanges: |
|
501
594859656a06
Added support for ExtendedApiV1: /changes
Alain Mazy <am@orthanc.team>
parents:
500
diff
changeset
|
10 - changes?type=...&to=... |
|
366
cd9521e04249
DatabaseBackendAdapterV4: added support for customData + revision when not already done
Alain Mazy <am@osimis.io>
parents:
276
diff
changeset
|
11 * Added support for customData in AttachedFiles |
|
522
c49136b34891
use a prepared statement for InsertOrUpdateMetadata
Alain Mazy <am@orthanc.team>
parents:
501
diff
changeset
|
12 * Performance optimizations (to be summarized before release): |
|
c49136b34891
use a prepared statement for InsertOrUpdateMetadata
Alain Mazy <am@orthanc.team>
parents:
501
diff
changeset
|
13 - using more prepared SQL statements: |
|
c49136b34891
use a prepared statement for InsertOrUpdateMetadata
Alain Mazy <am@orthanc.team>
parents:
501
diff
changeset
|
14 - InsertOrUpdateMetadata |
|
523
9413451fd984
ExecuteSetResourcesContentTags is now using a cached prepared statement
Alain Mazy <am@orthanc.team>
parents:
522
diff
changeset
|
15 - ExecuteSetResourcesContentTags |
|
524
48aba35fe64e
merged BEGIN and SET TRANSACTION statements
Alain Mazy <am@orthanc.team>
parents:
523
diff
changeset
|
16 - merged BEGIN and SET TRANSACTION statements |
|
522
c49136b34891
use a prepared statement for InsertOrUpdateMetadata
Alain Mazy <am@orthanc.team>
parents:
501
diff
changeset
|
17 - reduced the number of round-trips between Orthanc and the PostgreSQL server: |
| 535 | 18 - e.g: when receiving an instance in an existing series, reduced the number of SQL queries from 13 to 9 |
| 528 | 19 * Fixed a memory leak when executing non cached SQL statements (rarely used) |
|
499
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
20 |
|
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
21 |
| 494 | 22 Release 6.2 (2024-03-25) |
| 23 ======================== | |
| 493 | 24 |
| 25 DB schema revision: 2 | |
|
499
0974a58fdc76
Fix updates from version plugin version 3.3 to latest version
Alain Mazy <am@osimis.io>
parents:
494
diff
changeset
|
26 Minimum plugin SDK (for build): 1.12.3 |
| 493 | 27 Minimum Orthanc runtime: 1.12.3 |
| 28 | |
| 29 * Fix check of Orthanc runtime version | |
| 30 | |
| 31 | |
| 474 | 32 Release 6.1 (2024-02-14) |
| 33 ======================== | |
| 472 | 34 |
|
473
15e609c439d1
Fixed the MaximumStorageSize & MaximumPatientCount.
Alain Mazy <am@osimis.io>
parents:
472
diff
changeset
|
35 DB schema revision: 2 |
|
15e609c439d1
Fixed the MaximumStorageSize & MaximumPatientCount.
Alain Mazy <am@osimis.io>
parents:
472
diff
changeset
|
36 |
|
490
b3876cbb93a2
Fix check of Orthanc runtime version
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
474
diff
changeset
|
37 * Fix handling of MaximumStorageSize & MaximumPatientCount. |
|
473
15e609c439d1
Fixed the MaximumStorageSize & MaximumPatientCount.
Alain Mazy <am@osimis.io>
parents:
472
diff
changeset
|
38 |
| 472 | 39 |
| 471 | 40 Release 6.0 (2024-02-08) |
| 41 ======================== | |
| 42 | |
| 43 DB schema revision: 2 | |
|
429
dbf811b1bb43
new configuration 'EnableVerboseLogs' to log SQL statements being executed
Alain Mazy <am@osimis.io>
parents:
427
diff
changeset
|
44 |
| 471 | 45 * The DB schema has been updated to Revision 2. If you need to reinstall the previous |
| 46 version of the plugin, you should run this script: | |
| 47 https://orthanc.uclouvain.be/hg/orthanc-databases/file/tip/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql | |
| 468 | 48 * Transaction Mode: |
| 471 | 49 Introduced a new configuration "TransactionMode" to select the transaction isolation level. |
|
467
ff84104f7842
renamed v6.2 to REV2 + removed 'default' TransactionMode + renamed 'READ COMMITTED' into 'ReadCommitted'
Alain Mazy <am@osimis.io>
parents:
432
diff
changeset
|
50 Allowed values: "Serializable", "ReadCommitted". |
|
ff84104f7842
renamed v6.2 to REV2 + removed 'default' TransactionMode + renamed 'READ COMMITTED' into 'ReadCommitted'
Alain Mazy <am@osimis.io>
parents:
432
diff
changeset
|
51 The "Serializable" mode was the only available value up to now. It is still the default |
|
432
8b7c1c423367
new 'TransactionMode' config + rewrote ResourceDeletedFunc to avoid IF/THEN/ELSE pattern
Alain Mazy <am@osimis.io>
parents:
430
diff
changeset
|
52 value now. |
| 468 | 53 The "ReadCommitted" is possible now due to rewrites of SQL queries and notably improves |
| 54 the Orthanc ability to ingest data from multiple sources in parallel. | |
| 430 | 55 * New "EnableVerboseLogs" configuration to show SQL statements being executed. |
| 56 | |
| 57 | |
| 58 Release 5.1 (2023-06-27) | |
| 59 ======================== | |
|
418
a7f0f27fe33c
wip: advisory lock around CreateInstance: not ok see WO-139
Alain Mazy <am@osimis.io>
parents:
417
diff
changeset
|
60 |
| 471 | 61 DB schema revision: 1 |
| 62 | |
|
415
7e123f047771
LookupResources optimization continued
Alain Mazy <am@osimis.io>
parents:
412
diff
changeset
|
63 * Optimization of LookupResources mainly used in tools/find, C-Find and QIDO-RS. |
|
410
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
64 |
|
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
65 Release 5.0 (2023-04-15) |
|
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
66 ======================== |
|
614031f7a16d
OrthancPostgreSQL-5.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
400
diff
changeset
|
67 |
| 412 | 68 * Added support for labels |
| 386 | 69 * Compatibility with Orthanc SDK 1.12.0 (communications between the |
| 70 Orthanc core and the database plugin using Google Protocol Buffers) | |
|
358
1280b40d6696
switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
276
diff
changeset
|
71 * Upgraded dependencies for static builds (notably on Windows and LSB): |
|
400
897253c21208
support for labels in mysql
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
386
diff
changeset
|
72 - openssl 3.1.0 |
|
358
1280b40d6696
switch to OpenSSL 3.0.x
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
276
diff
changeset
|
73 |
|
276
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
74 |
|
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
75 Release 4.0 (2021-04-22) |
|
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
76 ======================== |
|
b783063f51f1
OrthancPostgreSQL-4.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
269
diff
changeset
|
77 |
|
253
3bc442765b88
new configuration option: "IndexConnectionsCount"
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
248
diff
changeset
|
78 * New option "IndexConnectionsCount" to control how many simultaneous |
|
3bc442765b88
new configuration option: "IndexConnectionsCount"
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
248
diff
changeset
|
79 connections to the PostgreSQL database are used by the index plugin |
|
266
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
253
diff
changeset
|
80 * Support of revisions for metadata and attachments |
|
248
7a4f9bcb0bc2
PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
243
diff
changeset
|
81 * Support of multiple readers/writers, by handling retries from Orthanc SDK 1.9.2 |
|
7a4f9bcb0bc2
PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
243
diff
changeset
|
82 * Support of range reads for the storage area, from Orthanc SDK 1.9.0 |
| 267 | 83 * Fix issue #193 (LSB binaries crash with PostgreSQL + SSL) by changeset |
|
426
d700c8f9fc24
migration to UCLouvain servers
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
419
diff
changeset
|
84 in OrthancFramework: https://orthanc.uclouvain.be/hg/orthanc/rev/9a9118406484 |
|
269
567761f0c1ea
fix issue #151: support of retries in the storage area plugins to deal with multiple writers
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
268
diff
changeset
|
85 * Fix issue #151 (Storage failures when running with two instances and PG_LOCK=false) |
|
195
53bd9022c58b
Support of "OrthancPluginRegisterStorageArea2()" from Orthanc SDK 1.9.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
179
diff
changeset
|
86 |
|
179
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
87 |
|
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
88 Release 3.3 (2020-12-14) |
|
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
89 ======================== |
|
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
90 |
|
134
cc3dc759c989
Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
132
diff
changeset
|
91 * Added an advisory lock to avoid race conditions during database setup |
|
141
0b3e9ee53c46
Added 'MaximumConnectionRetries' & 'ConnectionRetryInterval' to configure the retries when connecting to the DB at startup
Alain Mazy <alain@mazy.be>
parents:
134
diff
changeset
|
92 * Added "MaximumConnectionRetries" & "ConnectionRetryInterval" to configure |
|
0b3e9ee53c46
Added 'MaximumConnectionRetries' & 'ConnectionRetryInterval' to configure the retries when connecting to the DB at startup
Alain Mazy <alain@mazy.be>
parents:
134
diff
changeset
|
93 the retries when connecting to the DB at startup |
|
156
710537acb488
dynamic linking against the system-wide Orthanc framework library
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
141
diff
changeset
|
94 * Support of dynamic linking against the system-wide Orthanc framework library |
|
172
8c7bb94adff7
trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
156
diff
changeset
|
95 * Upgraded dependencies for static builds (notably on Windows and LSB): |
|
8c7bb94adff7
trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
156
diff
changeset
|
96 - openssl 1.1.1g |
| 268 | 97 - libpq 13.1 (replacing libpq 9.6.1) |
|
134
cc3dc759c989
Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
132
diff
changeset
|
98 |
|
132
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
99 |
|
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
100 Release 3.2 (2019-03-01) |
|
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
101 ======================== |
|
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
102 |
|
130
2d2b268799a2
Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
125
diff
changeset
|
103 * Explicit deallocation of prepared statements |
|
2d2b268799a2
Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
125
diff
changeset
|
104 |
|
125
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
105 |
|
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
106 Release 3.1 (2019-02-08) |
|
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
107 ======================== |
|
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
108 |
| 103 | 109 * Fix build on Debian Buster |
|
106
b559af8fe6e0
Remove "ASSERT" in SQL for compatibility with older releases of PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
103
diff
changeset
|
110 * Remove "ASSERT" in SQL for compatibility with older releases of PostgreSQL |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
106
diff
changeset
|
111 * Implementation of new extensions: LookupResourceAndParent and GetAllMetadata |
|
121
0886da5b4816
integration pg-tcp-nodelay->mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
117
diff
changeset
|
112 * Performance: Defining option "TCP_NODELAY" if libpq is linked statically |
| 103 | 113 |
| 100 | 114 |
| 115 Release 3.0 (2019-01-21) | |
| 116 ======================== | |
| 117 | |
|
81
515a783630df
injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
56
diff
changeset
|
118 * New configuration option: "EnableSsl" |
|
80
16df1a6ea452
Fix issue 105 (Unable to connect to PostgreSQL database using SSL)
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
119 * Database optimizations by implementing new primitives of Orthanc SDK 1.5.2 |
|
81
515a783630df
injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
56
diff
changeset
|
120 * Fix issue 105 (Unable to connect to PostgreSQL database using SSL) |
|
56
4f66bc893fc3
Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
48
diff
changeset
|
121 * Fix Debian issue #906771 (Uncaught exception prevents db intialization |
|
4f66bc893fc3
Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
48
diff
changeset
|
122 (likely related to pg_trgm)) |
| 48 | 123 * Fix: Catching exceptions in destructors |
| 124 | |
| 33 | 125 |
| 42 | 126 Release 2.2 (2018-07-16) |
| 33 | 127 ======================== |
| 128 | |
| 29 | 129 !! Important remark when upgrading from an older version of the plugin: |
| 130 | |
| 131 The plugin will create a new index to improve search performance. | |
| 132 This can take several minutes at the first Orthanc startup. Orthanc | |
| 133 will not be available during this period. On a PostgreSQL database | |
| 134 with 100,000 studies, we have observed that updating the index took | |
| 135 around 10 minutes. | |
| 19 | 136 |
| 0 | 137 * Migration into the "orthanc-databases" repository |
| 138 * Full refactoring to share code with MySQL | |
| 139 * Fix issue 41 (Additional range IdentifierConstraintType in Orthanc) | |
| 33 | 140 !! This fix requires Orthanc version >= 1.4.0 |
| 0 | 141 * Fix issue 47 (Index improvements for PG plugin) |
| 142 * Fix issue 76 (PG connection shall reconnect/retry in case it loses | |
| 143 the connection to the server) | |
| 144 | |
| 145 | |
| 146 Release 2.1 (2018-04-20) | |
| 147 ======================== | |
| 148 | |
| 149 * Running transactions in "Serializable" isolation level to avoid | |
| 150 inconsistencies if multiple Orthanc are writing to the same DB | |
| 151 * Upgrade to PostgreSQL 9.6.1 client library for static builds | |
| 152 * Performance warning if runtime debug assertions are turned on | |
| 153 * Fix issue 62 (use correct type for lo_read() value) | |
| 154 * Fix issue 63 (allow to connect without specifing username and/or port) | |
| 155 * Fix issue 68 (PostgreSQL plugin needs extra flags to compile) | |
| 156 * Resort to Orthanc framework | |
| 157 * Support of Linux Standard Base, OpenBSD and FreeBSD | |
| 158 | |
| 159 | |
| 160 Release 2.0 (2015-12-02) | |
| 161 ======================== | |
| 162 | |
| 163 => Minimum SDK version: 0.9.5 <= | |
| 164 => Supported database versions: 5 (upgrade only) and 6 <= | |
| 165 | |
| 166 * Support version 6 of the database schema | |
| 167 * The "value" column of tables "MainDicomTags" and "DicomIdentifiers" are now TEXT instead of BYTEA | |
| 168 | |
| 169 | |
| 170 Release 1.3 (2015-10-07) | |
| 171 ======================== | |
| 172 | |
| 173 => Minimum SDK version: 0.9.4 <= | |
| 174 => Supported database versions: 5 <= | |
| 175 | |
| 176 * Fix build with Orthanc plugin SDK 0.9.4 | |
| 177 * Implementation of "GetAllPublicIdsWithLimit" extension | |
| 178 * Implementation of "UpgradeDatabase" extension | |
| 179 | |
| 180 | |
| 181 Release 1.2 (2015-08-02) | |
| 182 ======================== | |
| 183 | |
| 184 => Minimum SDK version: 0.9.1 <= | |
| 185 | |
| 186 * Inject version information into Windows binaries | |
| 187 * CMake flag to prevent compiling the unit tests (if no PostgreSQL test server is available) | |
| 188 * Update to Boost 1.58.0 for static and Windows builds | |
| 189 * Support of OS X compilation | |
| 190 | |
| 191 | |
| 192 Release 1.1 (2015-07-03) | |
| 193 ======================== | |
| 194 | |
| 195 * Fixes | |
| 196 * Support of Visual Studio 2008 | |
| 197 * Support of FreeBSD thanks Mikhail <mp39590@gmail.com> | |
| 198 | |
| 199 | |
| 200 Release 1.0 (2015-02-27) | |
| 201 ======================== | |
| 202 | |
| 203 * Use of advisory locks | |
| 204 * Support of connection URI in PostgreSQL | |
| 205 * Options "EnableIndex" and "EnableStorage" to explicitly enable PostgreSQL | |
| 206 | |
| 207 | |
| 208 2015-02-06 | |
| 209 ========== | |
| 210 | |
| 211 * Initial release |