Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/knn/changes/?format=api
{ "count": 159, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": null, "user": null, "author": null, "timestamp": "2025-12-27T03:59:39.458319Z", "action": 47, "target": "", "id": 2257328, "action_name": "Alert triggered", "url": "https://weblate.osgeo.org/api/changes/2257328/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-10T01:40:54.486317Z", "action": 17, "target": "", "id": 2192327, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192327/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:21:25.705585Z", "action": 1, "target": "", "id": 2192230, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2192230/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360311/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:21:25.640121Z", "action": 5, "target": "План виконання показує цикл по станціях метро та сортування з підтримкою індексу всередині циклу, саме там, де це потрібно:", "id": 2192229, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192229/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360310/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:21:11.505066Z", "action": 5, "target": "Зверніть увагу, що CROSS JOIN LATERAL працює як внутрішня частина циклу, керованого таблицею метро. Кожен запис із таблиці метро по черзі передається в латеральний підзапит, тож ви отримуєте найближчий результат для кожного запису метро.", "id": 2192228, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192228/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360309/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:20:52.319682Z", "action": 5, "target": "Тут ми знайдемо найближчу вулицю до кожної станції метро:", "id": 2192227, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192227/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360308/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:20:35.992988Z", "action": 5, "target": "На щастя, у мові SQL є можливість виконувати запит багаторазово в циклі — це LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>_.", "id": 2192226, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192226/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360307/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:20:18.209146Z", "action": 5, "target": "Оператор сортування з підтримкою індексу має один суттєвий недолік: він працює лише з одним геометричним літералом з одного боку оператора. Це підходить для пошуку об’єктів, найближчих до одного запитного об’єкта, але не допомагає для просторового з’єднання, де мета — знайти найближчого сусіда для кожного об’єкта з повного набору кандидатів.", "id": 2192225, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192225/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360306/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:19:59.975565Z", "action": 5, "target": "З’єднання найближчих сусідів", "id": 2192224, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192224/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360305/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:19:43.106032Z", "action": 5, "target": "Це вивід команди EXPLAIN, зверніть увагу на сканування індексу під час виконання операції сортування (order by):", "id": 2192223, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192223/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360304/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:19:19.359570Z", "action": 5, "target": "Як ми можемо бути впевнені, що отримуємо запит з індексом? Варто перевірити вихідні дані ``EXPLAIN`` для запиту найближчого сусіда, оскільки можна отримати правильні відповіді з неіндексованого SQL, а відсутність індексу може бути непомітною, доки розмір таблиць не збільшиться.", "id": 2192222, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192222/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360303/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:19:02.366981Z", "action": 5, "target": "Ось 3 найближчі вулиці до станції метро «Broad St»:", "id": 2192221, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192221/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360302/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:18:51.263005Z", "action": 5, "target": "Оператор «order by distance» працює як для геометричних, так і для географічних типів. Єдина відмінність між цими двома типами полягає у значенні відстані, що повертається. Для геометрії ``<->`` повертає той самий результат, що і `ST_Distance`, який залежить від одиниць виміру використовуваної системи просторових координат. Для географії повертається значення відстані по сфері, а не більш точна сфероїдальна відстань, яку повертає ``ST_Distance(geography,geography)``.", "id": 2192220, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192220/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360301/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:16:11.063141Z", "action": 5, "target": "PostgreSQL вирішує проблему найближчого сусіда, вводячи оператор «order by distance» (``<->``), який змушує базу даних використовувати індекс для прискорення сортування набору результатів. За допомогою оператора «order by distance» запит на найближчого сусіда може повернути «N найближчих об'єктів», просто додавши сортування та обмеживши набір результатів до N записів.", "id": 2192219, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192219/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360300/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:15:51.539522Z", "action": 5, "target": "На відміну від пошуку за відстанню, пошук «найближчого сусіда» не включає жодних обмежень щодо відстані, на якій можуть знаходитися геометрії-кандидати. Будуть прийняті об'єкти, що знаходяться на будь-якій відстані, якщо вони є *найближчими*.", "id": 2192218, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192218/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360299/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:15:02.682792Z", "action": 5, "target": "Часто задається просторовий запит: «що є найближчим <кандидат-елемент> до <елемент запиту>?»", "id": 2192217, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192217/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360298/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:14:48.945790Z", "action": 5, "target": "Що таке пошук найближчого сусіда?", "id": 2192216, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192216/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360297/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:14:41.529367Z", "action": 5, "target": "Пошук найближчого сусіда", "id": 2192215, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192215/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:14:29.154368Z", "action": 0, "target": "", "id": 2192213, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/2192213/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360311/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154318Z", "action": 71, "target": "", "id": 2192212, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192212/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360310/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154270Z", "action": 71, "target": "", "id": 2192211, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192211/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360309/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154222Z", "action": 71, "target": "", "id": 2192210, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192210/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360308/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154173Z", "action": 71, "target": "", "id": 2192209, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192209/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360307/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154125Z", "action": 71, "target": "", "id": 2192208, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192208/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360306/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154076Z", "action": 71, "target": "", "id": 2192207, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192207/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360305/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.154028Z", "action": 71, "target": "", "id": 2192206, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192206/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360304/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153980Z", "action": 71, "target": "", "id": 2192205, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192205/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360303/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153932Z", "action": 71, "target": "", "id": 2192204, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192204/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360302/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153883Z", "action": 71, "target": "", "id": 2192203, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192203/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360301/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153835Z", "action": 71, "target": "", "id": 2192202, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192202/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360300/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153787Z", "action": 71, "target": "", "id": 2192201, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192201/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360299/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153738Z", "action": 71, "target": "", "id": 2192200, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192200/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360298/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153687Z", "action": 71, "target": "", "id": 2192199, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192199/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360297/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-09T21:14:29.153627Z", "action": 71, "target": "", "id": 2192198, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/2192198/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-09T21:14:29.042640Z", "action": 48, "target": "", "id": 2192197, "action_name": "Language added", "url": "https://weblate.osgeo.org/api/changes/2192197/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": null, "timestamp": "2025-08-09T21:14:29.038494Z", "action": 17, "target": "", "id": 2192196, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192196/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-19T23:50:40.196049Z", "action": 17, "target": "", "id": 2143953, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2143953/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340363/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/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-19T20:15:23.963954Z", "action": 2, "target": "Förklaringen visar slingan på tunnelbanestationerna och den indexassisterade ordningen genom att lägga in slingan där vi vill ha den:", "id": 2143945, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143945/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/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-19T20:14:00.453027Z", "action": 2, "target": "PostgreSQL löser det närmaste grannproblemet genom att införa en \"order by distance\" (``<->``) operator som inducerar databasen att använda ett index för att påskynda en sorterad returuppsättning. Med en \"order by distance\" -operator på plats kan en närmaste grannfråga returnera \"N närmaste funktioner\" bara genom att lägga till en ordning och begränsa resultatuppsättningen till N-poster.", "id": 2143940, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143940/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/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-19T20:10:32.413124Z", "action": 2, "target": "PostgreSQL löser det närmaste grannproblemet genom att införa en \"order by distance\" (``<->``) operatör som inducerar databasen att använda ett index för att påskynda en sorterad returuppsättning. Med en \"order by distance\" -operator på plats kan en närmaste grannfråga returnera \"N närmaste funktioner\" bara genom att lägga till en beställning och begränsa resultatuppsättningen till N-poster.", "id": 2143924, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143924/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": null, "author": null, "timestamp": "2025-06-18T09:58:49.198965Z", "action": 17, "target": "", "id": 2143894, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2143894/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104385/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:33:22.001939Z", "action": 2, "target": "Una pregunta espacial frecuente es: \"¿Cuál es la <<entidad>> más cercana a la <<entidad de consulta>>?\"", "id": 2143591, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143591/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:28:42.610155Z", "action": 1, "target": "", "id": 2143588, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2143588/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104399/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:28:42.524641Z", "action": 5, "target": "La explicación muestra el bucle en las estaciones de metro, y el orden asistido por índices dentro del bucle donde queramos:", "id": 2143587, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143587/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104397/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:27:28.636378Z", "action": 5, "target": "Observe cómo el ``CROSS JOIN LATERAL`` actúa como la parte interna de un bucle controlado por la tabla subways. Cada registro de la tabla subways se introduce en la subconsulta lateral, de uno en uno, de forma que se obtiene un resultado más cercano para cada registro de metro.", "id": 2143586, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143586/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104396/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:27:03.487202Z", "action": 5, "target": "Aquí encontrará la calle más cercana a cada estación de metro:", "id": 2143585, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143585/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104395/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:26:41.716876Z", "action": 5, "target": "Afortunadamente, existe una característica del lenguaje SQL que nos permite ejecutar una consulta en un bucle: el `LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>`_.", "id": 2143584, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143584/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104393/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:25:48.378805Z", "action": 5, "target": "El operador de ordenación por índice tiene un inconveniente importante: sólo funciona con **un único literal geométrico** en un lado del operador. Esto está bien para encontrar los objetos más cercanos a un objeto definido, pero no ayuda para un JOIN espacial, donde el objetivo es encontrar el vecino más cercano para cada uno de los objetos de un conjunto completo de candidatos.", "id": 2143583, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143583/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104392/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:24:30.107530Z", "action": 5, "target": "Join Vecino más próximo", "id": 2143582, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143582/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104391/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/knn/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/knn/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-06-18T09:23:46.778206Z", "action": 5, "target": "Esta es la salida de ``EXPLAIN``, observe la exploración del índice sobre el order by:", "id": 2143581, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143581/?format=api" } ] }