Translation status

42 Strings 69%
Browse Translate
856 Words 71%
5,039 Characters 70%

Strings status

Strings Words Characters
42 856 5,039
All strings Browse Translate Zen
29 613 3,549
Translated strings Browse Translate Zen
13 243 1,490
Unfinished strings Browse Translate Zen
13 243 1,490
Untranslated strings Browse Translate Zen
13 243 1,490
Unfinished strings without suggestions Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geography_exercises 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 0 0 0
advanced_geometry_construction 50% 29 642 3,987 29 0 0 0
simple_sql_exercises 0 0 0 0 0 0 0
license 0 0 0 0 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
clusterindex 0 0 0 0 0 0 0
postgis-functions 87% 5 68 436 5 0 0 0
loading_data 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar cvvergara User avatar jsanz User avatar andischi User avatar yellow73 User avatar astrid_emde User avatar jef
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://github.com/postgis/postgis-workshops.git
Repository branch master
Last remote commit Merge pull request #140 from ThomasPrioul/patch-2 0a18451
Regina Obe authored 3 weeks ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) a4ae1fb
Wangdapeng authored 22 hours ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/history_tracking.po
Translation file Download postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/history_tracking.po
Last change March 27, 2025, 8:47 a.m.
Last author None
22 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 42 856 5,039
Translated 69% 29 71% 613 70% 3,549
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 30% 13 28% 243 29% 1,490
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb

Quick numbers

856
Hosted words
42
Hosted strings
35%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
+33%
Translated
+2%
+100%
Contributors
—
User avatar None

Changes committed

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Changes committed 22 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Now that the history table is enabled, we can make edits on the main table and watch the log entries appear in the history table.
历史表启用后，对主表执行的所有编辑操作将自动生成日志条目并记录至历史表中。
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Editing the Table
表数据编辑操作
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
For an update, we first mark the active history record as deleted, then insert a new record for the updated state.
对于更新操作，系统会执行两步处理：首先将当前活跃的历史记录标记为已删除状态，随后插入一条新记录以存储更新后的数据状态。
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
For a deletion, we just mark the currently active history record (the one with a NULL deletion time) as deleted.
对于删除操作，我们只需将当前活跃的历史记录（即删除时间为 NULL 的记录）标记为已删除状态。
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
**valid_range** the time range within which the record was "live"
**valid_range** （有效时间范围）：记录作为"当前有效数据"存在的时间区间
23 hours ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
See Also
或者你看看另请参阅
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
For an insert, we just add a new record into the history table with the creation time/user.
对于插入操作（INSERT），我们仅需在历史表中新增一条记录，并标注创建时间及创建者信息。
23 hours ago
User avatar None

Changes committed

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Changes committed yesterday
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Now we need three triggers on the active table, for INSERT, DELETE and UPDATE actions. First we create the trigger functions, then bind them to the table as triggers.
当前需在活跃表上创建三个触发器，分别响应 INSERT、DELETE 和 UPDATE 操作。首先创建触发器函数，随后将其绑定至目标表。
yesterday
Browse all translation changes