Translation status

42 Strings 100%
Browse Translate
856 Words 100%
5,039 Characters 100%

Strings status

Strings Words Characters
42 856 5,039
All strings Browse Translate Zen
42 856 5,039
Translated strings Browse Translate Zen
1 4 83
Translated strings with dismissed checks Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
loading_data 0 0 0 0 0 0 0
about_data 0 0 0 0 0 0 0
simple_sql 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
geometries_exercises 0 0 0 0 1 0 0
spatial_relationships 0 0 0 0 0 0 0
joins 0 0 0 0 0 0 0
advanced_geometry_construction 0 0 0 0 0 0 0
index CC-BY-3.0-US 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jef User avatar komzpa User avatar yellow73 User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara
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 Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored yesterday
Last commit in Weblate Translated using Weblate (Spanish) 1964869
Paulo Cesar Coronado authored 2 months 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 April 1, 2025, 9:39 a.m.
Last author None
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 42 856 5,039
Translated 100% 42 100% 856 100% 5,039
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 0% 0 0% 0 0% 0
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 33 changes 0 changes 16 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
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

856
Hosted words
42
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

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

Translation completed

  1. postgis-workshop
  2. history_tracking
  3. Chinese (Simplified)
Translation completed 7 months 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>`_
7 months 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>`_
7 months 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>`_
7 months 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:
我们还可以创建仅显示特定用户所添加数据的视图，例如：
7 months 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分钟前（即编辑开始前的原始数据状态）的历史表视图。
7 months 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 **之后**才被删除的记录。
7 months 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之前创建且尚未删除的记录
7 months 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**的数据状态，需构建包含以下要素的查询：
7 months ago
Browse all translation changes