Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/simple_sql/changes/?format=api&page=2
{ "count": 396, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/changes/?format=api&page=3", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/changes/?format=api", "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/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-05T13:50:31.320961Z", "action": 17, "target": "", "id": 2136011, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2136011/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338897/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-05T13:48:35.888459Z", "action": 2, "target": ":term:`SQL`, eller \"Structured Query Language\", är ett sätt att ställa frågor till och uppdatera data i relationsdatabaser. Du har redan sett SQL när vi skapade vår första databas. Kom ihåg det:", "id": 2136008, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136008/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338921/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-05T13:48:07.161851Z", "action": 2, "target": "PostgreSQL har en serie inbyggda aggregerade funktioner, inklusive det allmänna syftet :command:`avg()` för medelvärden och :command:`stddev()` för standardavvikelser.", "id": 2136007, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136007/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-05T13:18:03.258155Z", "action": 17, "target": "", "id": 2135994, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2135994/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338913/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-05T13:17:34.887128Z", "action": 2, "target": "``some_columns`` är antingen kolumnnamn eller funktioner av kolumnvärden. ``some_data_source`` är antingen en enskild tabell eller en sammansatt tabell som skapats genom att två tabeller sammanfogats med en nyckel eller ett villkor. ``some_condition`` är ett filter som begränsar antalet rader som ska returneras.", "id": 2135989, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2135989/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338926/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.469402Z", "action": 29, "target": "Funktionslista", "id": 2135744, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135744/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T17:47:48.443222Z", "action": 17, "target": "", "id": 2135679, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2135679/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338929/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.395812Z", "action": 9, "target": "`stddev(uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: PostgreSQL-aggregatfunktion som returnerar standardavvikelsen för ingångsvärden.", "id": 2131333, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131333/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338928/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.367436Z", "action": 9, "target": "`char_length (sträng) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL-strängfunktion som returnerar antalet tecken i en sträng.", "id": 2131332, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131332/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338927/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.344880Z", "action": 9, "target": "`avg (uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL-aggregatfunktion som returnerar medelvärdet för en numerisk kolumn.", "id": 2131331, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131331/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338926/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.322419Z", "action": 9, "target": "Funktionslista", "id": 2131330, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131330/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338925/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.279396Z", "action": 9, "target": "Vi inkluderar kolumnen ``boroname`` i utdataresultatet så att vi kan avgöra vilken statistik som gäller för vilken stadsdel. I en aggregerad fråga kan du bara mata ut kolumner som antingen är (a) medlemmar i grupperingsklausulen eller (b) aggregerade funktioner.", "id": 2131329, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131329/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338924/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.256862Z", "action": 9, "target": "\"Vad är det genomsnittliga antalet bokstäver i namnen på alla stadsdelar i New York City, redovisat per stadsdel?\"", "id": 2131328, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131328/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338923/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.234538Z", "action": 9, "target": "De aggregerade funktionerna i vårt förra exempel tillämpades på varje rad i resultatuppsättningen. Vad händer om vi vill att sammanfattningarna ska utföras över mindre grupper inom den totala resultatuppsättningen? För det lägger vi till en ``GROUP BY``-klausul. Aggregerade funktioner behöver ofta en extra ``GROUP BY``-sats för att gruppera resultatuppsättningen efter en eller flera kolumner.", "id": 2131327, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131327/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338922/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.201018Z", "action": 9, "target": "\"Vad är det genomsnittliga antalet bokstäver och standardavvikelsen för antalet bokstäver i namnen på alla stadsdelar i Brooklyn?\"", "id": 2131326, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131326/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338921/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.179063Z", "action": 9, "target": "PostgreSQL har en serie inbyggda aggregerade funktioner, inklusive det allmänna syftet :command:`avg() ` för medelvärden och :command:`stddev() ` för standardavvikelser.", "id": 2131325, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131325/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338920/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.151065Z", "action": 9, "target": "Ofta är vi mindre intresserade av de enskilda raderna än av en statistik som gäller för dem alla. Att veta längden på grannskapsnamnen kan alltså vara mindre intressant än att veta den genomsnittliga längden på namnen. Funktioner som tar in flera rader och returnerar ett enda resultat kallas \"aggregerade\" funktioner.", "id": 2131324, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131324/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338919/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.129932Z", "action": 9, "target": "Lyckligtvis har PostgreSQL en stränglängdsfunktion, :command:`char_length(string)`.", "id": 2131323, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131323/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338918/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.106750Z", "action": 9, "target": "\"Vad är antalet bokstäver i namnen på alla stadsdelar i Brooklyn?\"", "id": 2131322, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131322/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338917/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.084785Z", "action": 9, "target": "Ibland behöver vi tillämpa en funktion på resultatet av vår fråga. Det kan till exempel vara", "id": 2131321, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131321/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338916/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.062643Z", "action": 9, "target": "Frågan kommer att köras under ännu färre (milli)sekunder och ge 23 resultat.", "id": 2131320, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131320/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338915/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.036051Z", "action": 9, "target": "Vi återvänder till vår tabell ``nyc_neighborhoods`` med ett filter i handen. Tabellen innehåller alla stadsdelar i New York, men vi vill bara ha dem i Brooklyn.", "id": 2131319, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131319/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338914/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:17.015272Z", "action": 9, "target": "\"Vad heter alla stadsdelar i Brooklyn?\"", "id": 2131318, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131318/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338913/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.994340Z", "action": 9, "target": "``some_columns`` är antingen kolumnnamn eller funktioner av kolumnvärden. ```ome_data_source`` är antingen en enskild tabell eller en sammansatt tabell som skapats genom att två tabeller sammanfogats med en nyckel eller ett villkor. ```ome_condition`` är ett filter som begränsar antalet rader som ska returneras.", "id": 2131317, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131317/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338912/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.973423Z", "action": 9, "target": "För en sammanfattning av alla ``SELECT`` parametrar, se `PostgresSQL-dokumentationen <http://www.postgresql.org/docs/current/interactive/sql-select.html>`_.", "id": 2131316, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131316/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338911/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.953286Z", "action": 9, "target": "En select-fråga är i allmänhet av formen::", "id": 2131315, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131315/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338910/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.933368Z", "action": 9, "target": "SELECT-frågor", "id": 2131314, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131314/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338909/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.899092Z", "action": 9, "target": "Vi kommer nästan uteslutande att arbeta med ``SELECT`` för att ställa frågor om tabeller med hjälp av spatiala funktioner.", "id": 2131313, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131313/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338908/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.877551Z", "action": 9, "target": "``DELETE``, tar bort rader från en tabell", "id": 2131312, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131312/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338907/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.856089Z", "action": 9, "target": "``UPDATE``, ändrar befintliga rader i en tabell", "id": 2131311, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131311/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338906/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.834225Z", "action": 9, "target": "``INSERT``, lägger till nya rader i en tabell", "id": 2131310, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131310/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338905/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.812522Z", "action": 9, "target": "``SELECT``, returnerar rader som svar på en fråga", "id": 2131309, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131309/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338904/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.791243Z", "action": 9, "target": "Men vad var det egentligen som hände här? För att förstå det måste vi börja med de fyra \"verben\" i SQL,", "id": 2131308, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131308/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338903/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.769576Z", "action": 9, "target": "Frågan körs i några (milli)sekunder och returnerar de 129 resultaten.", "id": 2131307, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131307/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338902/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.747668Z", "action": 9, "target": "och klicka på knappen **Execute Query** (den gröna triangeln).", "id": 2131306, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131306/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338901/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.725304Z", "action": 9, "target": "ange sedan följande fråga i frågefönstret", "id": 2131305, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131305/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338900/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.700738Z", "action": 9, "target": "Öppna SQL-frågefönstret i pgAdmin genom att klicka på knappen \"Query Tool\".", "id": 2131304, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131304/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338899/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.676787Z", "action": 9, "target": "\"Vad heter alla stadsdelar i New York City?\"", "id": 2131303, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131303/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338898/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.652844Z", "action": 9, "target": "Men det var en fråga om databasen. Nu när vi har laddat in data i vår databas kan vi använda SQL för att ställa frågor om data! Ett exempel,", "id": 2131302, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131302/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338897/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.627390Z", "action": 9, "target": "sammanfattning : term:`SQL`, eller \"Structured Query Language\", är ett sätt att ställa frågor till och uppdatera data i relationsdatabaser. Du har redan sett SQL när vi skapade vår första databas. Kom ihåg det:", "id": 2131301, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131301/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338896/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:20:16.593346Z", "action": 9, "target": "Enkel SQL", "id": 2131300, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2131300/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338926/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-06-04T08:15:36.386389Z", "action": 4, "target": "Funktionslista", "id": 2131236, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/2131236/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T08:15:06.008532Z", "action": 0, "target": "", "id": 2131169, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/2131169/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338929/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008481Z", "action": 71, "target": "", "id": 2131168, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131168/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338928/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008428Z", "action": 71, "target": "", "id": 2131167, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131167/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338927/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008380Z", "action": 71, "target": "", "id": 2131166, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131166/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338926/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008332Z", "action": 71, "target": "", "id": 2131165, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131165/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338925/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008284Z", "action": 71, "target": "", "id": 2131164, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131164/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338924/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008236Z", "action": 71, "target": "", "id": 2131163, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131163/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2338923/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T08:15:06.008189Z", "action": 71, "target": "", "id": 2131162, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2131162/?format=api" } ] }