TERMS OF ACQUIRING AND DOWNLOAD pgModeler - PostgreSQL Database Modeler 1. INTRODUCTION The PostgreSQL Database Modeler (pgModeler) project is an open-source tool developed by Raphael Araújo e Silva. It is intended to create data models, manage databases, and execute additional tasks in PostgreSQL relational database management systems series 10 to 15. THERE IS NO SUPPORT FOR DISCONTINUED POSTGRESQL VERSIONS LIKE 9.x OR 8.x. The user has free access to the software's source code according to the terms of the General Public License (GPL) in its version 3. Additionally, the user can access packages in binary format (installer and pre-compiled) under electronic payment. The binary packages sold in the project's site are supported by the following platforms: GNU/Linux (64 bits), Microsoft Windows (64 bits), and macOS (64 bits) with a minimum version requirement described in the section (6) of this document. Also, there is no guarantee that the software will run on platforms other than those mentioned here. Even in machines with the mentioned systems, pgModeler cannot run properly due to the differences in particular aspects like the set of updates, the presence of antivirus or antimalware software, hardware settings, and many others. In that case, the user can ask for help in any of the communication channels. This document describes the process of acquiring and downloading any file in binary format distributed and describes any other services offered by the pgModeler project's web site (pgmodeler.io). It is understood by "file or package in the binary format" all files generated by a compilation process such as libraries, executables, and compressed files. The files in binary format distributed by the web site mentioned above are: compressed packages which extensions are .tgz and .dmg and installers which extensions are .run and .exe. 2. ACQUIRING THE DOWNLOAD CONCESSION The pgModeler packages are always retrieved in the current stable release listed on the download page. The user must select the desired platform(s) and the download concession validity that may vary from 6 (six) to 36 (thirty-six) months or, when available the purchase option, a perpetual validity. Note that no access will be granted for a platform that wasn't selected at purchase time. As a courtesy, the more the selected packages or the number of months, the bigger the discount given in the final purchasing price. When purchasing a package, the user will receive an access key representing his/her download concession. The access to the packages will last until the concession expires if the access key has a validity period. Once expired the download concession, the access to packages of versions newer than the one associated to the access key (fallback version) will be automatically blocked and the user might purchase a new set of packages to receive a new access key, and download the newer versions again. If there's a copy of the software already installed in the user's computer, it will continue to work even after the access key expiration because there's no mechanism that blocks its features after that period. A fallback version is a stable version permanently associated with an access key in its purchase time. For instance, if the user purchased an access key in which the stable version was 0.8.2, after the expiration date, only packages of that version (0.8.2) will be allowed to be downloaded for a limited time, even if packages of other stable or development versions newer than it (0.9.0, 0.9.1, 0.9.2 and so on) were downloaded in the past. The purchases are done through PayPal or Stripe online payments services or bitcoin transfer, being impossible payments through deposit or bank transfers, or even through any other financial transactions. In the case of using PayPal or Stripe, once confirmed the online transaction, an automatic email is sent to the user containing the generated access key and details about downloading the files. In some cases that the payment needs some hours or days to be concluded by payment service, the access key will be sent normally, but its usage will be blocked until the electronic payment is definitively processed. When using bitcoin transfers, an order is created and sent to the email specified in the purchase form. The order email contains the access key that can be used to download the packages once the bitcoin transfer is done by the user and confirmed by the Blockchain. All details on how to enable the access key are available on the purchase order message. Bitcoin prices are calculated based upon the current price of that cryptocurrency (in American Dollars - USD) provided by https://www.blockchain.com/en/prices The prices in the download page (https://pgmodeler.io/download) can be changed without prior notice. The prices are applied in American Dollars (USD) and already converted to Brazilian Reals (BRL) if the user wants to make an acquisition using that currency. The exchange rate used in the price conversion between American Dollars (USD) and Brazilian Reals (BRL) is the same as the one published by the Central Bank of Brazil and can be checked at the address http://www4.bcb.gov.br/pec/taxas/port/ptaxnpesq.asp?id=txcotacao The access key generated from the purchase is unique, individual, and untransferable and may be disabled if unauthorized usage of any nature is detected. 2.1 SOFTWARE VERSIONS Packages are sold in the form of "stable versions" but the user has access to "development versions" to test new features and fixes that will be released without any addition to the final purchasing price. Stable versions are those in which passed by all the development steps, where one or more failures previously reported were fixed, and new features were introduced. Packages of stable versions are numbered without any suffixes, e.g., the package "pgmodeler-0.8.2-linux64.tgz" indicates the stable version 0.8.2 for the GNU/Linux 64 bits. Development versions are the ones that have passed by the development and test processes but have several instabilities at the same time that introduce new features and bug fixes. Development versions give users the chance to test new resources without the need to wait until the release of stable versions, which can take months. Packages of development versions are numbered with key suffixes which identify an unstable version, "alpha" or "beta". For instance, the package "pgmodeler-0.9.0-alpha-linux64.tgz" indicates the development version 0.9.0 in "alpha" stage for the GNU/Linux 64 bits. For every stable version to be released at least 4 (four) development versions will be launched, thus, for the version 0.9.0 the following intermediate versions will be created: alpha, alpha1, beta, beta1. The release interval between each version will be at least of 20 (twenty) days, amounting at least 80 (eighty) days until the release of stable version. In some cases, more the 4 (four) development versions will be released but never less. 3. DOWNLOADING PACKAGES Once purchased a set of packages, it is granted to the user the unlimited downloads of packages of any version released during the validity period of the access key, until its expiration, as selected in the purchasing form as described in section (2), nevertheless, to avoid the excessive number of simultaneous connections on the web site causing instabilities on the hosting service, only 15 (fifteen) downloads can be done in a daily basis, being rejected any additional downloads in case the daily quota is exhausted. The daily quota applies to the total files downloaded in the current day, no matter their extensions (.run, .exe, .dmg, etc.). The download quota will be automatically renewed on the following day allowing the user to perform more downloads. To download a file, the user must access the download page (https://pgmodeler.io/download) and inform the access key in the indicated field to identify the payment. Once checked the purchase info, the files available for download will be presented to the user, being enough for him/her to pick the desired binary package. For each download started on the web site, a register is created in the download history for auditing purposes. The download history is accessible on the download page by using the access key. 4. CHARGEBACKS AND CONCESSION CANCELLATION A voluntary chargeback will happen only when the user committed a mistake while purchasing a binary package, e.g., the user wanted to buy the package for macOS and, by a mere lapse, acquired the package for Windows. In this case, the total value paid will be voluntarily returned to the user through prior contact with the software author via email. For this purpose, it is needed to send a message to the author reporting the mistake and attaching a snapshot of the purchase receipt or a report identifying a bitcoin transaction, depending on the chosen payment method. Once confirmed the user's mistake, the chargeback will be done without restrictions and contestations, on the same day or, when that is not possible, in at most 3 (three) business days. Chargebacks will be done through the PayPal or Stripe (for USD or BRL currencies), or Blockchain (for bitcoin transaction), so any technical issues that eventually harms the chargeback process will not be of pgModeler's author responsibility. In this case, it is recommended to contact the respective services to determine the best solution for the problem. Voluntary chargebacks will be done IF AND ONLY IF THE USER HAS NOT DOWNLOADED ANY FILE. Since the packages are digital products, the only guarantee that the user doesn't "use" it is through the absence of a download register. It is important to remember that the download system registers all downloaded files, so it is possible to know when and which files were downloaded by the user. Once done the chargeback, the concession (access key) related to it will be permanently canceled, being impossible to download any file in the future. Finally, we strongly recommend the downloading and testing of the demonstration version first in order to check eventual problems and incompatibilities, so the user can decide if the software is worth of purchase. 5. NOTE TO RESELLERS, PARTNERS, AND FINAL USERS Binary packages purchased at the pgModeler project's web site must not be resold using different prices other than those detailed in the purchase form to retrieve some profit. Resellers and partners can only intermediate the purchase process. Nevertheless, all information about prices, receipts, and any other must be delivered to their final users without modifications allowing them to download the files any time directly from the project's web site. Packages available at the project's website are exclusively for personal or corporate usage, and unauthorized redistribution, charged or not, through any kind of media (physical, electronic, third party servers, etc.) is prohibited and can lead to revocation of the download concession. Finally, there is no limit on the number of users, teams, or computers that will use the software. Once downloaded the files, they can be installed in any number of machines without injury to the present term or the download concession. 6. DISCLAIMER OF WARRANTIES AND LIABILITIES By being open-source, the software has no standard warranty. Its use is entirely at the user's risk. The author is not responsible for any material damage, data loss, or defects resulting from the software miss usage, in any circumstance. Additional terms and conditions of use of the open-source software can be found on the General Public License (GPL) in its version 3 and can be read in the following address http://www.gnu.org/licenses/gpl-3.0.html It is verified, even limitedly, that stable versions will run without problems on the operating systems: openSuse Leap 15.5 (64 bits), Windows 11 (64 bits), and macOS 13.4 Ventura (64 bits), as long as the requirements listed on the page https://pgmodeler.io/support/installation are fully satisfied. In any other operating system, pgModeler can run normally but, in some cases, can raise errors, show inconsistencies, or even fail to run. In this case, the user can contact the author to get support via email or by submitting an issue to the GitHub repository. It is verified, even limitedly, that all provided files are free from viruses, malware, or other forms of malicious code since the development environment used to create pgModeler is continuously checked and cleaned when needed. In case of any antivirus software owned by the user alerts about the presence of a virus in one or more components of pgModeler, it is recommended that the user immediately contacts the software's author, allowing him to do in-depth inspections in the files or the development environment as a whole. It is not guaranteed that the software is free from bugs or that its execution will be flawless in any computer. By being a product in constant development, faults may be discovered right after the release of a stable version. However, those failures will be fixed in future versions when possible. --- This document can be modified without prior notice. Palmas, Tocantins - Brazil - September, 28 2023 Raphael Araújo e Silva https://pgmodeler.io https://github.com/pgmodeler/pgmodeler