Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/creating_db/changes/?format=api&page=3
{ "count": 248, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/changes/?format=api&page=4", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/changes/?format=api&page=2", "results": [ { "unit": "https://weblate.osgeo.org/api/units/104167/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-06-09T08:17:06.091572Z", "action": 9, "target": "関数リスト", "id": 1454277, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454277/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": null, "user": null, "author": null, "timestamp": "2023-03-26T22:34:33.650604Z", "action": 15, "target": "", "id": 1277694, "action_name": "Component unlocked", "url": "https://weblate.osgeo.org/api/changes/1277694/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": null, "user": null, "author": null, "timestamp": "2023-03-26T22:18:49.968250Z", "action": 14, "target": "", "id": 1277634, "action_name": "Component locked", "url": "https://weblate.osgeo.org/api/changes/1277634/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": null, "user": null, "author": null, "timestamp": "2023-03-26T22:18:49.963930Z", "action": 47, "target": "", "id": 1277633, "action_name": "Alert triggered", "url": "https://weblate.osgeo.org/api/changes/1277633/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104168/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:17:07.118152Z", "action": 5, "target": "`PostGIS_Full_Version <http://postgis.net/docs/PostGIS_Full_Version.html>`_: 完全な PostGIS のバージョン情報とコンフィギュレーション情報を報告します。", "id": 1097856, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1097856/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104168/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:16:50.310685Z", "action": 26, "target": "`PostGIS_Full_Version <http://postgis.net/docs/PostGIS_Full_Version.html>`_: Reports full PostGIS version and build configuration info.", "id": 1097855, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1097855/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104167/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:43.243780Z", "action": 7, "target": "関数リスト", "id": 1097854, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097854/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104166/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:40.193419Z", "action": 7, "target": "これで PostGIS 空間データベースの生成に成功しました!!", "id": 1097828, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097828/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104165/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:35.808608Z", "action": 7, "target": "PostGISをインストールされているか確認するには次の関数を実行します:", "id": 1097827, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097827/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104164/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:30.909509Z", "action": 7, "target": "「クエリの実行」にはツールバーの **Play** ボタンをクリックします (もしくは **F5** キーを押します)。", "id": 1097826, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097826/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104162/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:20.716693Z", "action": 7, "target": "次のクエリをクエリテキストフィールドに入力して PostGIS エクステンションをロードします。", "id": 1097825, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097825/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104161/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:17.480099Z", "action": 7, "target": "次に示すSQLクエリボタンをクリックします (もしくは *Tools > Query Tool* に移動します)。", "id": 1097824, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097824/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104160/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:14.262480Z", "action": 7, "target": "``nyc``データベースを選択して開くと、オブジェクトのツリーが表示されます。``public`` スキーマが表示されます。", "id": 1097823, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097823/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104159/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:10.382973Z", "action": 7, "target": "``postgres``", "id": 1097822, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097822/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104158/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:08.520915Z", "action": 7, "target": "**所有者**", "id": 1097821, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097821/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104157/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:06.776519Z", "action": 7, "target": "``nyc``", "id": 1097820, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097820/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104156/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:15:03.957331Z", "action": 7, "target": "**名前**", "id": 1097819, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097819/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104155/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:59.455136Z", "action": 7, "target": "``Create Database`` フォームに次に示すことを記入して **OK** をクリックします。", "id": 1097818, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097818/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104154/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:52.759359Z", "action": 7, "target": "``Databases`` を右クリックし、``New Database`` を選択します。", "id": 1097817, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097817/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104153/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:49.360553Z", "action": 7, "target": "データベースのツリーを開いて、現在有効なデータベースを確認します。``postgres`` データベースは、デフォルトユーザの postgres のデータベースですが、これは気にしません。", "id": 1097816, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097816/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104152/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:42.342290Z", "action": 7, "target": "データベースの作成", "id": 1097815, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097815/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104151/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:40.118736Z", "action": 7, "target": "**Port** は ``5432`` のままとし、**Maintenance database** と **Username** は ``postgres`` のままにしておきます。**Password** はローカルにインストールした時に指定した、あるいは、クラウドサービスで指定したパスワードを入れます。", "id": 1097814, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097814/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104150/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:29.160383Z", "action": 7, "target": "**PostGIS** という名前を付けておきます。Connection タブの ``Host name/address`` に入ります。ローカルにインストールした PostgreSQL で作業している場合には ``localhost`` を使うことができます。クラウドサービスを使っている場合には、アカウントからホスト名を取得できるはずです。", "id": 1097813, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097813/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104148/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:20.663786Z", "action": 7, "target": "pgAdmin の実行が初めての場合には、設定済みのサーバを持っていない可能性があります。ブラウザパネル内の ``Servers`` を右クリックします。", "id": 1097812, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097812/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104147/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:15.387552Z", "action": 7, "target": "pgAdmin を見つけて、起動します。", "id": 1097811, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097811/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/1514227/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:14:11.134018Z", "action": 7, "target": "PostgreSQLはいくつかの管理フロントエンドがあります。主要なものとしては、SQLクエリを入力するコマンドラインツールの `psql <https://www.postgresql.jp/document/current/html/app-psql.html>`_ があります。他の人気のある PostgreSQL フロントエンドとしては、フリーでオープンソースの GUI ツール `pgAdmin <http://www.pgadmin.org/>`_ があります。pgAdmin で実行された全てのクエリは、``psql`` でコマンドラインから実行することもできます。pgAdminはジオメトリビューア持っていて、PostGIS クエリの空間ビューに使うことができます。", "id": 1097810, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097810/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104145/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:33.569276Z", "action": 7, "target": "PgAdmin", "id": 1097809, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097809/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104144/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:30.349255Z", "action": 7, "target": "空間データベースの作成", "id": 1097808, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1097808/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104168/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.205778Z", "action": 4, "target": "`PostGIS_Full_Version <http://postgis.net/docs/PostGIS_Full_Version.html>`_: Reports full PostGIS version and build configuration info.", "id": 1097807, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097807/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104167/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.199980Z", "action": 4, "target": "関数リスト", "id": 1097806, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097806/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104166/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.194986Z", "action": 4, "target": "これで PostGIS 空間データベースの生成に成功しました!!", "id": 1097805, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097805/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104165/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.189777Z", "action": 4, "target": "PostGISをインストールされているか確認するには次の関数を実行します:", "id": 1097804, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097804/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104164/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.184063Z", "action": 4, "target": "「クエリの実行」にはツールバーの **Play** ボタンをクリックします (もしくは **F5** キーを押します)。", "id": 1097803, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097803/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104162/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.178589Z", "action": 4, "target": "次のクエリをクエリテキストフィールドに入力して PostGIS エクステンションをロードします。", "id": 1097802, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097802/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104161/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.173408Z", "action": 4, "target": "次に示すSQLクエリボタンをクリックします (もしくは *Tools > Query Tool* に移動します)。", "id": 1097801, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097801/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104160/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.167806Z", "action": 4, "target": "``nyc``データベースを選択して開くと、オブジェクトのツリーが表示されます。``public`` スキーマが表示されます。", "id": 1097800, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097800/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104159/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.162274Z", "action": 4, "target": "``postgres``", "id": 1097799, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097799/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104158/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.157525Z", "action": 4, "target": "**所有者**", "id": 1097798, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097798/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104157/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.152019Z", "action": 4, "target": "``nyc``", "id": 1097797, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097797/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104156/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.146634Z", "action": 4, "target": "**名前**", "id": 1097796, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097796/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104155/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.141675Z", "action": 4, "target": "``Create Database`` フォームに次に示すことを記入して **OK** をクリックします。", "id": 1097795, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097795/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104154/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.136209Z", "action": 4, "target": "``Databases`` を右クリックし、``New Database`` を選択します。", "id": 1097794, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097794/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104153/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.130386Z", "action": 4, "target": "データベースのツリーを開いて、現在有効なデータベースを確認します。``postgres`` データベースは、デフォルトユーザの postgres のデータベースですが、これは気にしません。", "id": 1097793, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097793/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104152/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.125036Z", "action": 4, "target": "データベースの作成", "id": 1097792, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097792/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104151/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.119820Z", "action": 4, "target": "**Port** は ``5432`` のままとし、**Maintenance database** と **Username** は ``postgres`` のままにしておきます。**Password** はローカルにインストールした時に指定した、あるいは、クラウドサービスで指定したパスワードを入れます。", "id": 1097791, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097791/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104150/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.113920Z", "action": 4, "target": "**PostGIS** という名前を付けておきます。Connection タブの ``Host name/address`` に入ります。ローカルにインストールした PostgreSQL で作業している場合には ``localhost`` を使うことができます。クラウドサービスを使っている場合には、アカウントからホスト名を取得できるはずです。", "id": 1097790, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097790/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104148/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.107400Z", "action": 4, "target": "pgAdmin の実行が初めての場合には、設定済みのサーバを持っていない可能性があります。ブラウザパネル内の ``Servers`` を右クリックします。", "id": 1097789, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097789/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104147/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.102150Z", "action": 4, "target": "pgAdmin を見つけて、起動します。", "id": 1097788, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097788/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/1514227/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.095917Z", "action": 4, "target": "PostgreSQLはいくつかの管理フロントエンドがあります。主要なものとしては、SQLクエリを入力するコマンドラインツールの `psql <https://www.postgresql.jp/document/current/html/app-psql.html>`_ があります。他の人気のある PostgreSQL フロントエンドとしては、フリーでオープンソースの GUI ツール `pgAdmin <http://www.pgadmin.org/>`_ があります。pgAdmin で実行された全てのクエリは、``psql`` でコマンドラインから実行することもできます。pgAdminはジオメトリビューア持っていて、PostGIS クエリの空間ビューに使うことができます。", "id": 1097787, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097787/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104145/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/creating_db/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/creating_db/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-01-18T08:13:21.089627Z", "action": 4, "target": "PgAdmin", "id": 1097786, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1097786/?format=api" } ] }