Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 1 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 0 0 0 0 0 0 0
Swedish 0 0 0 0 0 0 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jef User avatar komzpa User avatar astrid_emde User avatar yellow73 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 13 days ago
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
4 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 252 5,136 30,234
Source 42 856 5,039
Translated 83% 211 83% 4,282 83% 25,203
Needs editing 0% 0 0% 0 0% 0
Read-only 16% 42 16% 856 16% 5,039
Failing checks 1% 1 1% 4 1% 83
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 16% 41 16% 854 16% 5,031
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 94 changes 1 change 0 changes 0 changes 0 changes 0 changes 47 changes 0 changes 0 changes
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

5,136
Hosted words
252
Hosted strings
83%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. history_tracking
  3. Spanish
Changes committed 2 months ago
User avatar paulo

Translation changed

  1. postgis-workshop
  2. history_tracking
  3. Spanish
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
`Rangos de los tTipos de datos Range en PostgreSQL <https://www.postgresql.org/docs/current/rangetypes.html>`_
2 months ago
User avatar paulo

Translation completed

  1. postgis-workshop
  2. history_tracking
  3. Spanish
Translation completed 2 months ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Spanish
`PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_
`Rangos de los tipos de datos en PostgreSQL <https://www.postgresql.org/docs/current/rangetypes.html>`_
2 months ago
User avatar paulo

Translation changed

  1. postgis-workshop
  2. history_tracking
  3. Spanish
`PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_
`Triggers en PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_
2 months ago
User avatar paulo

Translation changed

  1. postgis-workshop
  2. history_tracking
  3. Spanish
`QGIS open source GIS <http://qgis.org>`_
`QGIS open source SIG de código abierto QGIS <http://qgis.org>`_
2 months ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Spanish
`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 months ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Spanish
`QGIS open source GIS <http://qgis.org>`_
`QGIS open source GIS <http://qgis.org>`_
2 months ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Spanish
We can also create views that show just what a particular used has added, for example:
También podemos crear vistas que muestren solo lo que un usuario particular ha añadido, por ejemplo:
2 months ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. history_tracking
  3. Spanish
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).
Podemos usar esta lógica para crear una consulta, o una vista, del estado de los datos en el pasado. Como presumiblemente todas tus ediciones de prueba ocurrieron en los últimos minutos, creemos una vista de la tabla de historial que muestre el estado de la tabla hace 10 minutos, **antes de que empezaras a editar** (es decir, los datos originales).
2 months ago
Browse all component changes