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
HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 226,
    "next": "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"
        }
    ]
}