Mercurial > hg > orthanc-databases
comparison README @ 366:cd9521e04249 attach-custom-data
DatabaseBackendAdapterV4: added support for customData + revision when not already done
author | Alain Mazy <am@osimis.io> |
---|---|
date | Thu, 15 Sep 2022 18:12:34 +0200 |
parents | 8f109cfbfc5d |
children | f18e46d7dbf8 |
comparison
equal
deleted
inserted
replaced
365:7671fa7f099e | 366:cd9521e04249 |
---|---|
47 Releases <= 2.1 of the PostgreSQL plugins can still be found in the | 47 Releases <= 2.1 of the PostgreSQL plugins can still be found in the |
48 following legacy repository: | 48 following legacy repository: |
49 https://hg.orthanc-server.com/orthanc-postgresql/ | 49 https://hg.orthanc-server.com/orthanc-postgresql/ |
50 | 50 |
51 | 51 |
52 Development | |
53 ----------- | |
54 | |
55 PostgreSQL | |
56 ========== | |
57 | |
58 To quickly start a test PG server: | |
59 | |
60 docker run -p 5432:5432 --rm --env POSTGRES_HOST_AUTH_METHOD=trust postgres:13.4 | |
61 | |
62 And use this Orthanc configuration: | |
63 "PostgreSQL": { | |
64 "EnableIndex": true, | |
65 "EnableStorage": false, // DICOM files are stored in the Orthanc container in /var/lib/orthanc/db/ | |
66 "Host": "localhost", // the name of the PostgreSQL container | |
67 "Database": "postgres", // default database name in PostgreSQL container (no need to create it) | |
68 "Username": "postgres", // default user name in PostgreSQL container (no need to create it) | |
69 "Password": "postgres" | |
70 }, | |
71 | |
72 MySQL | |
73 ===== | |
74 | |
75 To quickly start a test MySQL server: | |
76 | |
77 docker run -p 3306:3306 --rm --env MYSQL_PASSWORD=orthanc --env MYSQL_USER=orthanc --env MYSQL_DATABASE=orthanc --env MYSQL_ROOT_PASSWORD=pwd-root mysql:8.0 mysqld --default-authentication-plugin=mysql_native_password --log-bin-trust-function-creators=1 | |
78 | |
79 And use this Orthanc configuration: | |
80 "MySQL": { | |
81 "EnableIndex": true, | |
82 "EnableStorage": false, | |
83 "Host": "localhost", | |
84 "Database": "orthanc", | |
85 "Username": "orthanc", | |
86 "Password": "orthanc", | |
87 "UnixSocket": "" | |
88 }, | |
89 | |
90 | |
91 ODBC (SQL Server) | |
92 ================= | |
93 | |
94 To quickly start a test MySQL server: | |
95 | |
96 docker run -e "ACCEPT_EULA=Y" --rm --env "SA_PASSWORD=yourStrong-Password" --entrypoint=bash -it -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest | |
97 | |
98 Then: | |
99 (sleep 15s && /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P yourStrong-Password -Q 'CREATE DATABASE orthanctest') & /opt/mssql/bin/sqlservr | |
100 | |
101 And use this Orthanc configuration: | |
102 "Odbc" : { | |
103 "IndexConnectionString": "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanctest;Uid=sa;Pwd=yourStrong-Password;Encrypt=yes;TrustServerCertificate=yes;Connection Timeout=30;", | |
104 "EnableIndex": true, | |
105 "EnableStorage": false | |
106 } | |
107 | |
108 | |
109 SQLite | |
110 ====== | |
111 | |
112 To quickly test the SQLite plugin, simply run orthanc and load the plugin (no configuration required). | |
113 | |
114 | |
52 Licensing | 115 Licensing |
53 --------- | 116 --------- |
54 | 117 |
55 The database plugins for Orthanc are licensed under the AGPL license. | 118 The database plugins for Orthanc are licensed under the AGPL license. |
56 | 119 |