Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/simple_sql/es/changes/?format=api
{ "count": 58, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/es/changes/?format=api&page=2", "previous": null, "results": [ { "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-09-04T23:47:42.497008Z", "action": 17, "target": "", "id": 2217836, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2217836/?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/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T22:07:48.646772Z", "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": 2217775, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217775/?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/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T22:07:45.489661Z", "action": 2, "target": "\"¿Cuántas letras tienen los nombres de cada uno de los barrios de Brooklyn?\"", "id": 2217774, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217774/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99252/?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/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-09-04T22:07:42.003763Z", "action": 2, "target": "\"¿Cuál es el nombre de los barrios de Brooklyn?\"", "id": 2217773, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2217773/?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-07-28T06:04:22.502706Z", "action": 0, "target": "", "id": 2186245, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/2186245/?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-07-01T05:08:32.853545Z", "action": 17, "target": "", "id": 2174641, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2174641/?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/robe/?format=api", "author": "https://weblate.osgeo.org/api/users/robe/?format=api", "timestamp": "2025-07-01T03:48:53.789524Z", "action": 2, "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": 2174640, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2174640/?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/robe/?format=api", "author": "https://weblate.osgeo.org/api/users/robe/?format=api", "timestamp": "2025-07-01T03:48:53.757751Z", "action": 45, "target": "", "id": 2174639, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2174639/?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-06-18T09:58:47.417873Z", "action": 17, "target": "", "id": 2143879, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2143879/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99235/?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/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:48:10.106716Z", "action": 2, "target": "\"¿Cómo se llaman los barrios de Nueva York?\"", "id": 2143826, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143826/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99235/?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/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:48:10.105222Z", "action": 45, "target": "", "id": 2143825, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2143825/?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" }, { "unit": "https://weblate.osgeo.org/api/units/99252/?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:13:22.999196Z", "action": 2, "target": "\"¿Cuál es el nombre de los barrios de Brooklyn?\".", "id": 2037372, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2037372/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99252/?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:12:39.808902Z", "action": 5, "target": "\"¿Cómo se llaman todos los barrios de Brooklyn?\".", "id": 2037371, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037371/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99251/?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:12:16.891312Z", "action": 5, "target": "``some_columns`` puede ser nombres de columnas o funciones que se aplican a los valores de las columnas . ``some_data_source`` puede ser una tabla o una tabla compuesta a partir de \"juntar\" dos tablas usando una llave o una condición. ``some_condition`` es un filtro que restringe el número de filas retornadas.", "id": 2037370, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037370/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99250/?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:08:08.839386Z", "action": 5, "target": "Para una sinopsis de todos los parámetros ``SELECT``, véase la documentación `PostgresSQL <http://www.postgresql.org/docs/current/interactive/sql-select.html>`_.", "id": 2037367, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037367/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99249/?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:07:48.249692Z", "action": 2, "target": "Una consulta SELECT suele tener la forma::", "id": 2037366, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2037366/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99249/?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:07:33.760529Z", "action": 5, "target": "Una consulta select suele tener la forma::", "id": 2037365, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037365/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99248/?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:06:59.466815Z", "action": 5, "target": "Consultas SELECT", "id": 2037364, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037364/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99247/?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:06:41.764447Z", "action": 5, "target": "Trabajaremos casi exclusivamente con ``SELECT`` para hacer preguntas a tablas utilizando funciones espaciales.", "id": 2037363, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037363/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99245/?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:06:22.834527Z", "action": 5, "target": "``DELETE``, elimina filas de una tabla", "id": 2037362, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037362/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99244/?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:06:04.022337Z", "action": 5, "target": "``UPDATE``, modifica las filas existentes en una tabla", "id": 2037361, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037361/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99242/?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:05:34.678949Z", "action": 5, "target": "``INSERT``, añade nuevas filas a una tabla", "id": 2037360, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037360/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99241/?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:05:13.981389Z", "action": 5, "target": "``SELECT``, devuelve las filas que cumplen los criterios de una consulta", "id": 2037359, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037359/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99240/?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:04:29.158513Z", "action": 5, "target": "Pero, ¿qué ha ocurrido exactamente? Para entenderlo, empecemos por los cuatro \"verbos\" de SQL,", "id": 2037358, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037358/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99239/?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:04:05.327492Z", "action": 5, "target": "La consulta se ejecutará durante unos (mili)segundos y devolverá los 129 resultados.", "id": 2037356, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037356/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99238/?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:03:32.207721Z", "action": 5, "target": "y haga clic en el botón **Ejecutar consulta** (el botón Play).", "id": 2037355, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037355/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99237/?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:02:47.202454Z", "action": 5, "target": "Luego, introduzca la siguiente consulta en la ventana de consulta", "id": 2037354, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037354/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99236/?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:02:16.191615Z", "action": 5, "target": "Abra la ventana de consulta SQL en pgAdmin haciendo clic en el botón \"Herramienta de consulta\".", "id": 2037353, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037353/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99235/?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:00:10.292629Z", "action": 5, "target": "\"¿Cómo se llaman los barrios de Nueva York?\".", "id": 2037351, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037351/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99234/?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-14T03:59:39.472567Z", "action": 5, "target": "Pero ésa era una pregunta sobre la base de datos. Ahora que hemos cargado datos en nuestra base de datos, vamos a utilizar SQL para hacer preguntas a los datos. Por ejemplo,", "id": 2037350, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037350/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99233/?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-14T03:58:38.276325Z", "action": 5, "target": ":term:`SQL`, o \"Lenguaje de consulta estructurado\", es un medio para formular preguntas y actualizar datos en bases de datos relacionales. Ya has visto SQL cuando creamos nuestra primera base de datos. Recuerde:", "id": 2037349, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037349/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99232/?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-14T03:58:04.231235Z", "action": 5, "target": "SQL Básico", "id": 2037348, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037348/?format=api" } ] }