Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove MySQL support #6014

Closed
koppor opened this issue Feb 25, 2020 · 1 comment
Closed

Remove MySQL support #6014

koppor opened this issue Feb 25, 2020 · 1 comment

Comments

@koppor
Copy link
Member

koppor commented Feb 25, 2020

At Oracle (refs #6013) and Postgres (refs #4461), updates from other users come in automatically to the local database: A pub-sub mechanism is offered by that databases.

At MySQL, that is not available. This is "OK" since in a "normal" architecture, this is done by a messaging system (https://ultimate-comparisons.github.io/ultimate-message-broker-comparison/ ). - Nevertheless, the user experience is not that good. It is "OK" for a single user setup as no updates from other users come in at a single user setting. However, if a second user joins, they have to manually (!) pull remote changes.

We implemented a setting that for each write at MySQL, the changes are pulled from the server. Thus, if both users constantly change the database, both JabRef instances are in synch.

Moreover, MySQL seems to be slow: #3736

Nevertheless, maintenance of MySQL code costs time. (JabRef code, SQL code, testing MySQL).

@koppor
Copy link
Member Author

koppor commented Feb 26, 2020

MySQL is still the leading platform offered by the Cloud providers.

We need to add Telemetry on that. --> Future Work.

@koppor koppor closed this as completed Feb 26, 2020
koppor pushed a commit that referenced this issue Apr 15, 2022
9ff3112 Update bibtex.csl (#6021)
68ed5f7 Don't initialize with hyphen in Vancouver/NLM (#6022)
80206ad Update american-physics-society.csl (#5934)
cfbdba6 Update csl style (#6003)
546ee88 Update institut-francais-darcheologie-orientale-en.csl (#6018)
1153e3e Update institut-francais-darcheologie-orientale-etudes-arabes.csl (#6019)
42d5031 Update institut-francais-darcheologie-orientale-arab-studies.csl (#6020)
2e10c7a Update institut-francais-darcheologie-orientale.csl (#6015)
0c7d6a1 Create science-china-materials.csl (#6017)
0eb4bc7 Update frontiers.csl (#6014)
0fd9cc2 Update urad-rs-za-makroekonomske-analize-in-razvoj.csl (#5963)
1393837 Update harvard-university-of-the-west-of-england.csl (#6013)
4474b0e Update frontiers-of-biogeography.csl (#6010)
736c6df Render status field (for forthcoming, in press, etc.) to date groups (#6005)
51ff3dc Create journal-of-contemporary-water-research-and-education.csl (#5912)
7387ed3 cell.csl: Add a macro for DOI and webpage accessed date. (#5999)
21e2177 Create respiratory-care-journal.csl (#5998)
d0a2846 Update archaeonautica.csl (#5987)
664784e Update cardiff-university-harvard.csl (#5982)
07ce91e improve journal-of-avian-biology.csl (#5984)
349a5d6 update based on latest version of ISO 690 standard (#5976)
d8c3725 Update mary-ann-liebert-vancouver.csl (#5981)
7b2e70d Update style-manual-australian-government.csl (#5975)
bebf50c Create extracellular-vesicles-and-circulating-nucleic-acids.csl (#5979)
cabcdd4 Update united-states-international-trade-commission.csl (#5967)
948c48a Update cardiff-university-harvard.csl (#5977)
d6bf535 Add name to label gun
cf0d930 Test label gun
2f40fcd Update the-journal-of-egyptian-archaeology.csl (#5964)
aa023e1 Create materials-research-society-bulletin.csl (#5917)
ea31783 Changed quotation marks to Spanish ones (#5968)
27245f9 AJA: Add "." suffix to citation layout. (#5971)
7726a40 Update american-medical-association.csl (#5970)

git-subtree-dir: buildres/csl/csl-styles
git-subtree-split: 9ff3112
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant