Posted on

Adding More Sharing Permissions to ONLYOFFICE Doc Editors

ONLYOFFICE is an open source office suite that contains docx, xlsx, pptx editors for integration with other apps. Previously, we wrote some articles on how to integrate the editors with document management systems in PHP, Node.js, Python, etc. In this article, we will show you how to add more sharing permissions to DMS + editors combos.

That means more flexible access rights management: apart from basic reading and editing rights, you will be able to bring about commenting, reviewing, filling form rights, and also restrict downloading files.

Posted on

A Guide to Resolving the Cross-Database Query Problem with A Single SQL Statement

Recently, an e-commerce user experienced a sharp increase in access volume due to rapid business development, resulting in bottlenecks in database capacity and performance. To reduce the database size and improve performance, the user decided to implement vertical sharding on the architecture. Sharding is performed by table, which results in less of an impact on applications and supports clear and simple sharding rules.

The user vertically divided data into three databases according to members, commodities, and orders. After the vertical sharding was performed, the data was distributed to different database instances, reducing the data volume in each database and increasing the number of instances. This process seems simple but is difficult to implement. This is because once sharding is introduced, a query originally implemented in one database instance will now be implemented across two database instances.