Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/schemas/changes/?format=api
https://weblate.osgeo.org/api/components/postgis-workshop/schemas/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "user": null, "author": null, "timestamp": "2025-09-04T23:47:42.056712Z", "action": 17, "target": "", "id": 2217834, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2217834/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:01:49.219284Z", "action": 1, "target": "", "id": 2217762, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2217762/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98354/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:01:49.164386Z", "action": 5, "target": "Eso es todo, el área de trabajo predeterminada del usuario ahora está bien separada de cualquier tabla en otros esquemas.", "id": 2217761, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217761/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:01:40.343362Z", "action": 5, "target": "El search path del usuario tiene primero el esquema del usuario, por lo que las nuevas tablas se crean automáticamente allí, y las consultas buscan automáticamente allí primero.", "id": 2217760, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217760/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98349/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:01:03.251486Z", "action": 5, "target": "El esquema con el nombre del usuario existe, y el usuario es su propietario.", "id": 2217759, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217759/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98347/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:00:51.034990Z", "action": 5, "target": "El usuario existe, con la capacidad de crear tablas espaciales.", "id": 2217758, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217758/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98345/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:00:45.448705Z", "action": 5, "target": "¡El primer esquema en el search path es el esquema con el nombre del usuario! Así que ahora existen las siguientes condiciones:", "id": 2217757, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217757/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98343/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:00:37.845423Z", "action": 5, "target": "Si inicias sesión como ese usuario, encontrarás que el ``search_path`` predeterminado para PostgreSQL es en realidad este:", "id": 2217756, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217756/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98341/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:00:30.086615Z", "action": 5, "target": "Crea un nuevo usuario con privilegios de creación de tablas (ver :ref:`security` para información sobre el rol ``postgis_writer``), luego crea un esquema con ese usuario como autorización:", "id": 2217755, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217755/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98339/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:00:24.178758Z", "action": 5, "target": "De manera predeterminada, cada rol en Oracle recibe un esquema personal. Esta es una buena práctica para usar también con los usuarios de PostgreSQL, y es fácil de replicar usando roles, esquemas y search paths de PostgreSQL.", "id": 2217754, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217754/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98337/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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:00:06.844393Z", "action": 5, "target": "A los usuarios les gusta crear tablas, y los usuarios de PostGIS en particular: las operaciones de análisis con SQL requieren tablas temporales para visualización o resultados intermedios, así que el SQL espacial tiende a requerir que los usuarios tengan privilegios de CREATE más que las cargas de trabajo ordinarias de bases de datos.", "id": 2217753, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217753/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98334/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:59.992627Z", "action": 5, "target": "Creación de un esquema de usuario", "id": 2217752, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217752/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98331/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:54.499302Z", "action": 5, "target": "Ahora el usuario postgres siempre tendrá el esquema ``census`` en su search path.", "id": 2217751, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217751/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98329/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:45.930970Z", "action": 5, "target": "Configurar el search path cada vez que te conectas también puede ser cansado, pero afortunadamente es posible establecerlo de forma permanente para un usuario:", "id": 2217750, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217750/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98327/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:39.357192Z", "action": 5, "target": "Esto asegura que todas las referencias a relaciones y funciones sean buscadas tanto en los esquemas ``census`` como ``public``. Recuerda que todas las funciones y tipos de PostGIS están en ``public`` así que no queremos quitarlo del search path.", "id": 2217749, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217749/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98325/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:30.655863Z", "action": 5, "target": "Puedes establecer el ``search_path`` en tiempo de ejecución usando el comando ``SET``:", "id": 2217748, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217748/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98323/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:24.124392Z", "action": 5, "target": "Manipular el ``search_path`` es una buena manera de proporcionar acceso a tablas en múltiples esquemas sin mucho tipeo adicional.", "id": 2217747, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217747/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98321/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:11.829702Z", "action": 5, "target": "La referencia explícita es fácil, pero con el tiempo se vuelve tediosa de escribir:", "id": 2217746, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217746/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98319/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:59:03.545764Z", "action": 5, "target": "añadiendo el esquema a tu ``search_path``", "id": 2217745, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217745/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98317/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:58:53.916624Z", "action": 5, "target": "haciendo referencia a ellas usando la notación ``schema.table``", "id": 2217744, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217744/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98315/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:58:46.977074Z", "action": 5, "target": "Puedes acceder a las tablas dentro de los esquemas de dos maneras:", "id": 2217743, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217743/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98313/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:58:39.955784Z", "action": 5, "target": "Si estás usando el programa de línea de comandos :command:`psql`, notarás que ``nyc_census_blocks`` ha desaparecido de tu lista de tablas ahora! Si estás usando PgAdmin, puede que tengas que refrescar tu vista para ver el nuevo esquema y la tabla dentro de él.", "id": 2217742, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217742/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98311/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:58:30.924483Z", "action": 5, "target": "A continuación, moveremos la tabla ``nyc_census_blocks`` al esquema ``census``:", "id": 2217741, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217741/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98309/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:58:19.988238Z", "action": 5, "target": "Vamos a crear un nuevo esquema y mover una tabla dentro de él. Primero, crea un nuevo esquema en la base de datos:", "id": 2217740, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2217740/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98309/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T21:58:19.974751Z", "action": 45, "target": "", "id": 2217739, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2217739/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T17:47:40.596638Z", "action": 17, "target": "", "id": 2135657, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2135657/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340427/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.393832Z", "action": 9, "target": "Det är allt som behövs, användarens standardarbetsområde är nu snyggt separerat från alla tabeller i andra scheman.", "id": 2135223, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135223/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340426/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.373953Z", "action": 9, "target": "Användarens sökväg har användarens schema först, så nya tabeller skapas automatiskt där och frågor söker automatiskt där först.", "id": 2135222, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135222/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340425/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.352095Z", "action": 9, "target": "Användarens namngivna schema finns och användaren äger det.", "id": 2135221, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135221/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340424/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.330559Z", "action": 9, "target": "Användaren finns, med möjlighet att skapa spatiala tabeller.", "id": 2135220, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135220/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340423/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.309087Z", "action": 9, "target": "Det första schemat på sökvägen är användarens namngivna schema! Så nu finns följande villkor:", "id": 2135219, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135219/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340422/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.287646Z", "action": 9, "target": "Om du loggar in som den användaren kommer du att upptäcka att standard ``search_path`` för PostgreSQL faktiskt är detta:", "id": 2135218, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135218/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340421/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.265449Z", "action": 9, "target": "Skapa en ny användare med behörighet att skapa tabeller (se :ref:`security` för information om rollen ``postgis_writer``) och skapa sedan ett schema med den användaren som behörig:", "id": 2135217, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135217/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340420/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.243358Z", "action": 9, "target": "Som standard får varje roll i Oracle ett personligt schema. Detta är en trevlig praxis att använda för PostgreSQL-användare också, och det är lätt att replikera med PostgreSQL-roller, scheman och sökvägar.", "id": 2135216, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135216/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340419/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.221483Z", "action": 9, "target": "Användare gillar att skapa tabeller, och PostGIS-användare gör det särskilt: analysoperationer med SQL kräver temporära tabeller för visualisering eller tillfälliga resultat, så spatial SQL tenderar att kräva att användare har CREATE-rättigheter mer än vanliga databasarbetsbelastningar.", "id": 2135215, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135215/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340418/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.198638Z", "action": 9, "target": "Skapa ett användarschema", "id": 2135214, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135214/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340417/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.179261Z", "action": 9, "target": "Nu kommer postgres-användaren alltid att ha schemat ``census`` i sin sökväg.", "id": 2135213, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135213/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340416/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.159776Z", "action": 9, "target": "Att ställa in sökvägen varje gång du ansluter kan också bli tröttsamt, men lyckligtvis är det möjligt att permanent ställa in sökvägen för en användare:", "id": 2135212, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135212/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340415/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.139682Z", "action": 9, "target": "Detta säkerställer att alla referenser till relationer och funktioner söks i både ``census`` och ``public`` schemat. Kom ihåg att alla PostGIS-funktioner och -typer finns i ``public`` så vi vill inte ta bort dem från sökvägen.", "id": 2135211, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135211/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340414/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.118796Z", "action": 9, "target": "Du kan ställa in ``search_path`` vid körning med kommandot ``SET``:", "id": 2135210, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135210/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340413/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.098951Z", "action": 9, "target": "Manipulering av ``search_path`` är ett bra sätt att ge åtkomst till tabeller i flera scheman utan en massa extra typning.", "id": 2135209, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135209/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340412/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.078758Z", "action": 9, "target": "Explicit hänvisning är enkelt, men det blir tröttsamt att skriva efter ett tag:", "id": 2135208, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135208/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340411/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.058886Z", "action": 9, "target": "genom att lägga till schemat i din ``search_path``", "id": 2135207, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135207/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340410/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.039053Z", "action": 9, "target": "genom att referera till dem med hjälp av ``schema.table``-notation", "id": 2135206, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135206/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340409/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:34.019770Z", "action": 9, "target": "Du kan komma åt tabeller i scheman på två sätt:", "id": 2135205, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135205/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340408/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:33.999952Z", "action": 9, "target": "Om du använder kommandoradsprogrammet :command:`psql` kommer du att märka att ``nyc_census_blocks`` har försvunnit från din tabellista nu! Om du använder PgAdmin kan du behöva uppdatera din vy för att se det nya schemat och tabellen i det.", "id": 2135204, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135204/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340407/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:33.978967Z", "action": 9, "target": "Därefter flyttar vi tabellen ``nyc_census_blocks`` till schemat ``census``:", "id": 2135203, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135203/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340406/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:33.959334Z", "action": 9, "target": "Låt oss skapa ett nytt schema och flytta en tabell till det. Skapa först ett nytt schema i databasen:", "id": 2135202, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135202/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340405/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:33.939073Z", "action": 9, "target": "Skapa ett dataschema", "id": 2135201, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135201/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340404/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/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-04T15:20:33.917779Z", "action": 9, "target": "Så för produktionsändamål förbättras hanteringen om du håller dina applikationsdata åtskilda i scheman; och för användarändamål förhindrar du att dina användare trampar på varandra genom att hålla dem i separata scheman.", "id": 2135200, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2135200/?format=api" } ] }{ "count": 226, "next": "