Jerven added a comment.
I just want to note my experience running sparql.uniprot.org. Which is currently about 10 times the size of wikidata in number of triples. An old but still applicable slide set/video is https://www.youtube.com/watch?v=lSfeYdHfCGQ. We also have very large literals that would require blobs in most relational databases. Specifically regarding the feature list: most of these should be implemented in a custom front end. Which is what we do and is something we have started to open source and contribute to RDF4J an eclipse project as new spring-boot module. We implement readonly users for the sparql endpoint (plus double query parsing, again with RDF4J) so that only read sparql queries can be submitted. If that was broken we would still have the user permissions to protect the store (defence in depth). Dynamic runtime query time limit: is configurable and can be turned off. We have it on but on a much higher allowances than the current WQS settings. We also have a simple abuse protection based on IP and queries per second again in the middle. Extension can be done in the middle (servlet) (e.g. by query rewriting) or in virtuoso with custom functions. The front end can do proper http caching support that can be written to understand when the store actually changes. Our solution for clustering is just have more copies of the whole database. TASK DETAIL https://phabricator.wikimedia.org/T206561 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Jerven Cc: Jerven, Base, TomT0m, Akuckartz, GreenReaper, Addshore, Lucas_Werkmeister_WMDE, Aklapper, Smalyshev, Invadibot, MPhamWMF, maantietaja, CBogen, Nandana, Namenlos314, Lahi, Gq86, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
