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