Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 0 0 0
Chinese (Simplified) 0 0 0 0 0 0 0
German 2% 41 854 5,031 41 0 0 0
Japanese 0 0 0 0 0 0 0
Spanish 2% 41 854 5,031 41 0 0 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar yellow73 User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara 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 #141 from osgeoweblate/weblate-postgis-workshop-index 742f800
Regina Obe authored 10 days ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) 0e176c7
Wangdapeng authored 2 weeks ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/history_tracking.po
yesterday

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 210 4,280 25,195
Source 42 856 5,039
Translated 60% 128 60% 2,572 60% 15,133
Needs editing 0% 0 0% 0 0% 0
Read-only 20% 42 20% 856 20% 5,039
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 39% 82 39% 1,708 39% 10,062
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 84 changes 1 change 0 changes 0 changes 0 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 33 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

4,280
Hosted words
210
Hosted strings
60%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
+19%
Translated
+41%
+100%
Contributors
—
User avatar None

Changes committed

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

Translation completed

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Translation completed 2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
`PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_
`PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
`QGIS open source GIS <http://qgis.org>`_
`QGIS 开源地理信息系统 <http://qgis.org>`_
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
We can also create views that show just what a particular used has added, for example:
我们还可以创建仅显示特定用户所添加数据的视图，例如：
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
We can use this logic to create a query, or a view, of the state of the data in the past. Since presumably all your test edits have happened in the past couple minutes, let's create a view of the history table that shows the state of the table 10 minutes ago, **before you started editing** (so, the original data).
我们可以利用这一逻辑创建历史数据查询或视图。假设您的测试编辑操作均在最近几分钟内完成，现在创建一个显示10分钟前（即编辑开始前的原始数据状态）的历史表视图。
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
All records created before T, but deleted **after** T.
所有在时间点 T 之前创建，但在 T **之后**才被删除的记录。
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
All records created before T, and not yet deleted; and also
需包含所有在时间点T之前创建且尚未删除的记录
2 weeks ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Now that we have a history table, what use is it? It's useful for time travel! To travel to a particular time **T**, you need to construct a query that includes:
历史表的核心价值在于实现"时间旅行"查询。要回溯特定时间点**T**的数据状态，需构建包含以下要素的查询：
2 weeks ago
Browse all component changes