today's leftovers
-
How to Get Your Public IP in a Linux Bash Script
You’ll need your external IP address if you want to remotely connect to your computer. Finding it manually is easy, but here’s how to find your it from within a Linux script.
-
Audit your sharding database algorithm | Opensource.com
Thanks to the ShardingSphere community's continuous review and feedback to develop features such as data sharding and read/write splitting, our team found that some users create many shards when using the data sharding feature.
In such cases, there can be 1,000 physical tables corresponding to a sharding logical table, which disturbs users.
For instance, a SELECT * FROM t_order statement will lead to a full-route, which is obviously not the case for OLTP. This SQL can be placed in another Proxy to avoid blocking other requests.
However, if users are not familiar with Proxy or how to write a where condition and don't know that sharding is not supported in this condition, a full-route is still required.
A full-route can lower the performance of Proxy and even result in the failure of a reasonable request. Imagine that there are 1,000 shards in a physical database. If they are executed in parallel, 1,000 connections are needed, and if in serial, the request can lead to a timeout. For this reason, community users asked whether the unreasonable request could be intercepted directly.
Our team considered the issue for a while. One option is to simply block the full-route operation. Doing so requires a check in the code and adding a switch to the configuration file. On the other hand, if the user later needs to set a table to read-only or requires the update operation to carry a limit, does that mean the code and configuration change again? This approach obviously goes against the pluggable logic of Proxy.
In response to the above problems, the recently released Apache ShardingSphere 5.2.0 provides users with auditing for the SQL sharding function. The audit can either be an interception operation or a statistical operation. Similar to the sharding and unique key generation algorithms, the audit algorithm is plugin-oriented, user-defined, and configurable.
-
Sekoliko is An Open Source Free School Management System
Sekoliko is a free self-hosted web-based school management system. It is built on top of PHP and Symphony framework.
It offers a management layout for teachers to put their educational materials, online courses, reports, manage their classes, students, homework, and exams.
The school admins can manage teachers, employees, and management tasks with their own panels.
-
OpenPrinting keeps old printers working, even on Windows • The Register [Ed: Canonical is boosting Windows instead of Ubuntu]
The OpenPrinting project – together with Windows Services for Linux – enables printers that Windows no longer supports to work on Windows 11.
We know that some Reg readers still actually prefer Windows. Maybe it's like those hardcore users of Vi and Emacs in the 21st century: some sort of software-induced Stockholm Syndrome. If you are one of them, it's OK. The penguin is here for you. It can help and can aid Windows 11 users, in particular.