Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara 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)) f3d4c96
Wangdapeng authored 10 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 26, 2025, 7:30 a.m.
Last author Wangdapeng
36 minutes ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 42 856 5,039
Translated 28% 12 26% 224 25% 1,262
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 2% 1 1% 2 1% 8
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 71% 30 73% 632 74% 3,777
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
2%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
If a record was deleted, when it was deleted and by whom.
若记录被删除，则记录其删除时间及操作者。
36 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Ranges can be very efficiently indexed using a GIST index, just like spatial data, as we will show below. This makes history queries very efficient.
时间范围字段可通过GIST索引实现高效检索——这与空间数据的索引机制类似（下文将具体演示）。该技术能显著提升历史查询效率。
38 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Similarly, the time range for a deleted record will be updated to include the current time as the end point of the time range.
同理，已删除记录的时间范围将被更新，将当前时间作为该时间范围的终止点。
44 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
The range for a new record will start at ``now()`` and have an open end point, so that the range covers all time from the current time into the future.
新记录的时间范围将从 ``now()`` 开始，并保持终点开放，从而使该范围涵盖从当前时间到未来的所有时间。
52 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Using TSTZRANGE
使用 TSTZRANGE 类型
2 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
If a record was updated, adding a deletion record (for the old state) and a creation record (for the new state).
如果一条记录被更新，则会添加一条删除记录（记录旧状态）和一条创建记录（记录新状态）。
2 hours ago
User avatar None

Changes committed

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

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
If a record was created, when it was added and by whom.
如果创建了一条记录，则记录其添加时间及操作者。
yesterday
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
History tracking works by keeping a history table that records, for every edit:
历史追踪通过维护一个历史表来记录每次编辑的操作，该表会保存：
yesterday
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Using the database and the trigger system, it's possible to add history tracking to any table, while maintaining simple "direct edit" access to the primary table.
通过数据库和触发器系统，可以为任何数据表添加历史追踪功能，同时保持对主表的"直接编辑"访问权限。
yesterday
Browse all translation changes