Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/simple_sql/changes/?format=api&page=3
{ "count": 396, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/changes/?format=api&page=4", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/changes/?format=api&page=2", "results": [ { "unit": "https://weblate.osgeo.org/api/units/2338922/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008140Z", "action": 71, "target": "", "id": 2131161, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131161/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338921/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008092Z", "action": 71, "target": "", "id": 2131160, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131160/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338920/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008044Z", "action": 71, "target": "", "id": 2131159, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131159/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338919/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007996Z", "action": 71, "target": "", "id": 2131158, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131158/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338918/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007948Z", "action": 71, "target": "", "id": 2131157, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131157/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338917/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007900Z", "action": 71, "target": "", "id": 2131156, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131156/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338916/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007851Z", "action": 71, "target": "", "id": 2131155, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131155/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338915/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007803Z", "action": 71, "target": "", "id": 2131154, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131154/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338914/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007754Z", "action": 71, "target": "", "id": 2131153, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131153/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338913/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007706Z", "action": 71, "target": "", "id": 2131152, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131152/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338912/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007657Z", "action": 71, "target": "", "id": 2131151, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131151/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338911/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007610Z", "action": 71, "target": "", "id": 2131150, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131150/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338910/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007561Z", "action": 71, "target": "", "id": 2131149, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131149/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338909/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007513Z", "action": 71, "target": "", "id": 2131148, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131148/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338908/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007466Z", "action": 71, "target": "", "id": 2131147, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131147/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338907/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007417Z", "action": 71, "target": "", "id": 2131146, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131146/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338906/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007370Z", "action": 71, "target": "", "id": 2131145, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131145/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338905/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007322Z", "action": 71, "target": "", "id": 2131144, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131144/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338904/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007274Z", "action": 71, "target": "", "id": 2131143, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131143/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338903/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007226Z", "action": 71, "target": "", "id": 2131142, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131142/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338902/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007178Z", "action": 71, "target": "", "id": 2131141, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131141/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338901/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007129Z", "action": 71, "target": "", "id": 2131140, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131140/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338900/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007081Z", "action": 71, "target": "", "id": 2131139, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131139/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338899/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.007032Z", "action": 71, "target": "", "id": 2131138, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131138/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338898/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.006983Z", "action": 71, "target": "", "id": 2131137, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131137/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338897/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.006933Z", "action": 71, "target": "", "id": 2131136, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131136/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338896/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.006872Z", "action": 71, "target": "", "id": 2131135, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131135/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:15:05.737602Z", "action": 48, "target": "", "id": 2131134, "action_name": "Language added", "url": "https://weblate.osgeo.org/api/changes/2131134/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": null, "timestamp": "2025-06-04T08:15:05.730005Z", "action": 17, "target": "", "id": 2131133, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2131133/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2025-03-27T08:47:37.556458Z", "action": 17, "target": "", "id": 2042750, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2042750/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236600/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2025-03-27T07:16:10.045660Z", "action": 2, "target": "`avg(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_：PostgreSQL 聚合函数，用于计算数值列的平均值。", "id": 2042716, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2042716/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236600/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2025-03-27T07:16:10.044017Z", "action": 45, "target": "", "id": 2042715, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2042715/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": null, "author": null, "timestamp": "2025-03-14T05:47:36.833990Z", "action": 17, "target": "", "id": 2037610, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2037610/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:25:10.808703Z", "action": 1, "target": "", "id": 2037403, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2037403/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99269/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:25:10.758500Z", "action": 5, "target": "`stddev(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: Función de agregación de PostgreSQL que devuelve la desviación estándar de los valores de entrada.", "id": 2037402, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037402/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99268/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:24:37.035039Z", "action": 5, "target": "`char_length(cadena) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: Función de PostgreSQL que devuelve el número de caracteres de una cadena.", "id": 2037400, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037400/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99267/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:23:57.668007Z", "action": 5, "target": "`avg(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Función de agregación de PostgreSQL que devuelve la media de una columna numérica.", "id": 2037396, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037396/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99265/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:22:50.752908Z", "action": 5, "target": "Incluimos la columna ``boroname`` en el resultado de salida para poder determinar qué estadística se aplica a qué distrito. En una consulta agregada, sólo se pueden mostrar columnas que sean (a) miembros de la cláusula de agrupación o (b) funciones agregadas.", "id": 2037394, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037394/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99264/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:21:31.532021Z", "action": 5, "target": "\"¿Cuál es la media de la cantidad de letras en los nombres de todos los barrios de Nueva York, desglosado por distritos?\".", "id": 2037388, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037388/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99263/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:20:52.748376Z", "action": 5, "target": "Las funciones de agregación de nuestro último ejemplo se aplicaron a todas las filas del conjunto de resultados. ¿Qué ocurre si queremos que los resúmenes se realicen sobre grupos más pequeños dentro del conjunto de resultados global? Para ello añadimos una cláusula ``GROUP BY``. Las funciones agregadas a menudo necesitan una sentencia ``GROUP BY`` añadida para agrupar el conjunto de resultados por una o más columnas.", "id": 2037387, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037387/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99262/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:19:52.576002Z", "action": 2, "target": "\"¿Cuál es la media estándar de la longitud de letras en los nombres de todos los barrios de Brooklyn?\".", "id": 2037386, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2037386/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99262/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:19:36.595567Z", "action": 5, "target": "\"¿Cuál es la media estándar de la longitud de letras en los nombres de todos los barrios de Brooklyn?\".", "id": 2037385, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037385/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99260/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:18:32.963302Z", "action": 5, "target": "PostgreSQL dispone de una serie de funciones de agregación integradas, entre las que se incluyen :command:`avg()` para valores medios y :command:`stddev()` para desviaciones estándar.", "id": 2037383, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037383/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99259/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:18:05.067169Z", "action": 5, "target": "A menudo, no nos interesan las filas individuales sino una estadística que se aplique a todas ellas. Así, conocer la longitud de los nombres de los barrios puede ser menos interesante que conocer la longitud media de los nombres. Las funciones que toman varias filas y devuelven un único resultado se denominan funciones \"agregadas\" o de \"agregación\".", "id": 2037380, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037380/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99257/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:16:57.965463Z", "action": 5, "target": "Afortunadamente, PostgreSQL tiene una función que calcula la longitud de una cadena de texto, :command:`char_length(string)`.", "id": 2037379, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037379/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99256/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:16:11.268482Z", "action": 2, "target": "\"¿Cuántas letras tienen los nombres de cada uno de los barrios de Brooklyn?\".", "id": 2037378, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2037378/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99256/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:15:28.190547Z", "action": 5, "target": "\"¿Cuál es el número de letras de los nombres de todos los barrios de Brooklyn?\".", "id": 2037377, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037377/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99255/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:15:07.223988Z", "action": 5, "target": "A veces necesitaremos aplicar una función a los resultados de nuestra consulta. Por ejemplo,", "id": 2037376, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037376/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99254/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:14:35.633148Z", "action": 5, "target": "La consulta durará aún menos (mili)segundos y devolverá los 23 resultados.", "id": 2037374, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037374/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99253/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:14:14.699808Z", "action": 5, "target": "Volvemos a nuestra tabla ``nyc_neighborhoods`` pero utilizando un filtro. La tabla contiene todos los barrios de Nueva York, pero sólo queremos los de Brooklyn.", "id": 2037373, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037373/?format=api" } ] }