Mercurial > hg > orthanc-databases
annotate PostgreSQL/NEWS @ 248:7a4f9bcb0bc2
PostgreSQL: Support of range reads from the storage area
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Wed, 14 Apr 2021 09:46:44 +0200 |
| parents | f5dc59c56e65 |
| children | 3bc442765b88 |
| rev | line source |
|---|---|
| 0 | 1 Pending changes in the mainline |
| 2 =============================== | |
| 3 | |
|
248
7a4f9bcb0bc2
PostgreSQL: Support of range reads from the storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
243
diff
changeset
|
4 * 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
|
5 * Support of range reads for the storage area, from Orthanc SDK 1.9.0 |
|
195
53bd9022c58b
Support of "OrthancPluginRegisterStorageArea2()" from Orthanc SDK 1.9.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
179
diff
changeset
|
6 |
|
179
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
7 |
|
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
8 Release 3.3 (2020-12-14) |
|
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
9 ======================== |
|
9b500ad566c0
OrthancPostgreSQL-3.3
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
172
diff
changeset
|
10 |
|
134
cc3dc759c989
Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
132
diff
changeset
|
11 * 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
|
12 * 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
|
13 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
|
14 * 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
|
15 * 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
|
16 - openssl 1.1.1g |
|
8c7bb94adff7
trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
156
diff
changeset
|
17 - libpq 13.1 |
|
134
cc3dc759c989
Added an advisory lock to avoid race conditions during database setup
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
132
diff
changeset
|
18 |
|
132
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
19 |
|
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
20 Release 3.2 (2019-03-01) |
|
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
21 ======================== |
|
5c69c2a14c97
OrthancPostgreSQL-3.2
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
130
diff
changeset
|
22 |
|
130
2d2b268799a2
Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
125
diff
changeset
|
23 * Explicit deallocation of prepared statements |
|
2d2b268799a2
Explicit deallocation of prepared statements
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
125
diff
changeset
|
24 |
|
125
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
25 |
|
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
26 Release 3.1 (2019-02-08) |
|
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
27 ======================== |
|
b85d672afcb5
OrthancPostgreSQL-3.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
121
diff
changeset
|
28 |
| 103 | 29 * 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
|
30 * 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
|
31 * Implementation of new extensions: LookupResourceAndParent and GetAllMetadata |
|
121
0886da5b4816
integration pg-tcp-nodelay->mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
117
diff
changeset
|
32 * Performance: Defining option "TCP_NODELAY" if libpq is linked statically |
| 103 | 33 |
| 100 | 34 |
| 35 Release 3.0 (2019-01-21) | |
| 36 ======================== | |
| 37 | |
|
81
515a783630df
injecting fix to issue 105 into the mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
56
diff
changeset
|
38 * 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
|
39 * 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
|
40 * 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
|
41 * Fix Debian issue #906771 (Uncaught exception prevents db intialization |
|
4f66bc893fc3
Fix Debian issue #906771
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
48
diff
changeset
|
42 (likely related to pg_trgm)) |
| 48 | 43 * Fix: Catching exceptions in destructors |
| 44 | |
| 33 | 45 |
| 42 | 46 Release 2.2 (2018-07-16) |
| 33 | 47 ======================== |
| 48 | |
| 29 | 49 !! Important remark when upgrading from an older version of the plugin: |
| 50 | |
| 51 The plugin will create a new index to improve search performance. | |
| 52 This can take several minutes at the first Orthanc startup. Orthanc | |
| 53 will not be available during this period. On a PostgreSQL database | |
| 54 with 100,000 studies, we have observed that updating the index took | |
| 55 around 10 minutes. | |
| 19 | 56 |
| 0 | 57 * Migration into the "orthanc-databases" repository |
| 58 * Full refactoring to share code with MySQL | |
| 59 * Fix issue 41 (Additional range IdentifierConstraintType in Orthanc) | |
| 33 | 60 !! This fix requires Orthanc version >= 1.4.0 |
| 0 | 61 * Fix issue 47 (Index improvements for PG plugin) |
| 62 * Fix issue 76 (PG connection shall reconnect/retry in case it loses | |
| 63 the connection to the server) | |
| 64 | |
| 65 | |
| 66 Release 2.1 (2018-04-20) | |
| 67 ======================== | |
| 68 | |
| 69 * Running transactions in "Serializable" isolation level to avoid | |
| 70 inconsistencies if multiple Orthanc are writing to the same DB | |
| 71 * Upgrade to PostgreSQL 9.6.1 client library for static builds | |
| 72 * Performance warning if runtime debug assertions are turned on | |
| 73 * Fix issue 62 (use correct type for lo_read() value) | |
| 74 * Fix issue 63 (allow to connect without specifing username and/or port) | |
| 75 * Fix issue 68 (PostgreSQL plugin needs extra flags to compile) | |
| 76 * Resort to Orthanc framework | |
| 77 * Support of Linux Standard Base, OpenBSD and FreeBSD | |
| 78 | |
| 79 | |
| 80 Release 2.0 (2015-12-02) | |
| 81 ======================== | |
| 82 | |
| 83 => Minimum SDK version: 0.9.5 <= | |
| 84 => Supported database versions: 5 (upgrade only) and 6 <= | |
| 85 | |
| 86 * Support version 6 of the database schema | |
| 87 * The "value" column of tables "MainDicomTags" and "DicomIdentifiers" are now TEXT instead of BYTEA | |
| 88 | |
| 89 | |
| 90 Release 1.3 (2015-10-07) | |
| 91 ======================== | |
| 92 | |
| 93 => Minimum SDK version: 0.9.4 <= | |
| 94 => Supported database versions: 5 <= | |
| 95 | |
| 96 * Fix build with Orthanc plugin SDK 0.9.4 | |
| 97 * Implementation of "GetAllPublicIdsWithLimit" extension | |
| 98 * Implementation of "UpgradeDatabase" extension | |
| 99 | |
| 100 | |
| 101 Release 1.2 (2015-08-02) | |
| 102 ======================== | |
| 103 | |
| 104 => Minimum SDK version: 0.9.1 <= | |
| 105 | |
| 106 * Inject version information into Windows binaries | |
| 107 * CMake flag to prevent compiling the unit tests (if no PostgreSQL test server is available) | |
| 108 * Update to Boost 1.58.0 for static and Windows builds | |
| 109 * Support of OS X compilation | |
| 110 | |
| 111 | |
| 112 Release 1.1 (2015-07-03) | |
| 113 ======================== | |
| 114 | |
| 115 * Fixes | |
| 116 * Support of Visual Studio 2008 | |
| 117 * Support of FreeBSD thanks Mikhail <mp39590@gmail.com> | |
| 118 | |
| 119 | |
| 120 Release 1.0 (2015-02-27) | |
| 121 ======================== | |
| 122 | |
| 123 * Use of advisory locks | |
| 124 * Support of connection URI in PostgreSQL | |
| 125 * Options "EnableIndex" and "EnableStorage" to explicitly enable PostgreSQL | |
| 126 | |
| 127 | |
| 128 2015-02-06 | |
| 129 ========== | |
| 130 | |
| 131 * Initial release |