Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/schemas/es/units/?format=api
{ "count": 36, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "PostgreSQL Schemas" ], "previous_source": "", "target": [ "Esquemas en Postgresql" ], "id_hash": -8886816310691054916, "content_hash": -8886816310691054916, "location": "../../en/schemas.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/98038/?format=api", "priority": 100, "id": 98283, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=04abafa6591cbabc", "url": "https://weblate.osgeo.org/api/units/98283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.415703Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Production databases inevitably have a large number of tables and views, and managing them all in one schema can become unwieldy quickly. Fortunately, PostgreSQL_ includes the concept of a \"_Schema\"." ], "previous_source": "", "target": [ "Las bases de datos de producción inevitablemente tienen un gran número de tablas y vistas, y administrarlas puede volverse difícil. Afortunadamente, PostgreSQL_ incluye el concepto de \"_Schema\"." ], "id_hash": -1470311288627131034, "content_hash": -1470311288627131034, "location": "../../en/schemas.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/98039/?format=api", "priority": 100, "id": 98284, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=6b9867ac4c220d66", "url": "https://weblate.osgeo.org/api/units/98284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.417673Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Schemas are like folders, and can hold tables, views, functions, sequences and other relations. Every database starts out with one schema, the ``public`` schema." ], "previous_source": "", "target": [ "Los esquemas son como carpetas y pueden contener tablas, vistas, funciones, secuencias y otras relaciones. Toda base de datos comienza con un esquema, el esquema ``público``." ], "id_hash": -2590022651747296629, "content_hash": -2590022651747296629, "location": "../../en/schemas.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/98040/?format=api", "priority": 100, "id": 98285, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=5c0e641eea631a8b", "url": "https://weblate.osgeo.org/api/units/98285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.419641Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Inside that schema, the default install of PostGIS creates the ``geometry_columns``, ``geography_columns`` and ``spatial_ref_sys`` metadata relations, as well as all the types and functions used by PostGIS. So users of PostGIS always need access to the public schema." ], "previous_source": "", "target": [ "Dentro de ese esquema, la instalación predeterminada de PostGIS crea las relaciones de metadatos ``geometry_columns``, ``geography_columns`` y ``spatial_ref_sys``, así como todos los tipos y funciones utilizados por PostGIS. Así que los usuarios de PostGIS siempre necesitan acceder al esquema público." ], "id_hash": -1204846504760395790, "content_hash": -1204846504760395790, "location": "../../en/schemas.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://weblate.osgeo.org/api/units/98041/?format=api", "priority": 100, "id": 98287, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=6f47867ccae2b7f2", "url": "https://weblate.osgeo.org/api/units/98287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.421385Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "In the public schema you can also see all the tables we have created so far in the workshop." ], "previous_source": "", "target": [ "En el esquema público también puedes ver todas las tablas que hemos creado hasta ahora en el taller." ], "id_hash": 8695137541537991919, "content_hash": 8695137541537991919, "location": "../../en/schemas.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/98042/?format=api", "priority": 100, "id": 98289, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=f8ab558674890cef", "url": "https://weblate.osgeo.org/api/units/98289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.423191Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Why use Schemas?" ], "previous_source": "", "target": [ "¿Por qué usar esquemas?" ], "id_hash": 1052508970105633935, "content_hash": 1052508970105633935, "location": "../../en/schemas.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98043/?format=api", "priority": 100, "id": 98291, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=8e9b4354f60efc8f", "url": "https://weblate.osgeo.org/api/units/98291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.424917Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "There are two very good reasons for using schemas:" ], "previous_source": "", "target": [ "Hay dos buenas razones para utilizar esquemas:" ], "id_hash": -1635901640625452398, "content_hash": -1635901640625452398, "location": "../../en/schemas.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98044/?format=api", "priority": 100, "id": 98293, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=694c1c200f0a8a92", "url": "https://weblate.osgeo.org/api/units/98293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.426587Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "previous_source": "", "target": [ "A los datos que se gestionan en un esquema se puede aplicar acciones masivas con facilidad." ], "id_hash": -3225587216245516428, "content_hash": -3225587216245516428, "location": "../../en/schemas.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98045/?format=api", "priority": 100, "id": 98295, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=533c698447a51774", "url": "https://weblate.osgeo.org/api/units/98295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.428284Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "It's easier to back-up data that's in a separate schema: so volatile data can have a different back-up schedule from non-volatile data." ], "previous_source": "", "target": [ "Es más fácil hacer copias de seguridad de datos que están en un esquema separado: así, los datos volátiles pueden tener un programa de copias de seguridad diferente del de los datos no volátiles." ], "id_hash": 7678548437974895935, "content_hash": 7678548437974895935, "location": "../../en/schemas.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/98047/?format=api", "priority": 100, "id": 98297, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=ea8faf1f241fcd3f", "url": "https://weblate.osgeo.org/api/units/98297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.429948Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "It's easier to restore data that's in a separate schema: so application-oriented schemas can be separately restored and backed up for time travel and recovery." ], "previous_source": "", "target": [ "Es más fácil restaurar datos que están en un esquema separado: así, los esquemas orientados a aplicaciones pueden restaurarse por separado y se puede hacer una copia de seguridad de ellos para recuperarlos." ], "id_hash": -4853520692566493137, "content_hash": -4853520692566493137, "location": "../../en/schemas.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://weblate.osgeo.org/api/units/98048/?format=api", "priority": 100, "id": 98299, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=3ca4d4a52990f82f", "url": "https://weblate.osgeo.org/api/units/98299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.431768Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "It's easier to manage application differences when the application data is in a schema: so a new version of software can work off a table structure in a new schema, and cut-over involves a simple change to the schema name." ], "previous_source": "", "target": [ "Es más fácil gestionar los cambios en la aplicación cuando los datos de la aplicación están en un esquema: así, una nueva versión del software puede funcionar con una estructura de tablas en un nuevo esquema, y la transición implica un simple cambio en el nombre del esquema." ], "id_hash": 4703619327588052336, "content_hash": 4703619327588052336, "location": "../../en/schemas.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://weblate.osgeo.org/api/units/98050/?format=api", "priority": 100, "id": 98301, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=c1469cdb8b8c2d70", "url": "https://weblate.osgeo.org/api/units/98301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.433593Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Users can be restricted in their work to single schemas to allow isolation of analytical and test tables from production tables." ], "previous_source": "", "target": [ "El trabajo de los usuarios puede limitarse a esquemas únicos para aislar las tablas analíticas y de prueba de las tablas de producción." ], "id_hash": -1816223157841303210, "content_hash": -1816223157841303210, "location": "../../en/schemas.rst:28", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/98053/?format=api", "priority": 100, "id": 98303, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=66cb7aa92407e956", "url": "https://weblate.osgeo.org/api/units/98303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.435507Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "So for production purposes, keeping your application data separate in schemas improves management; and for user purposes, keeping your users in separate schemas keeps them from treading on each other." ], "previous_source": "", "target": [ "Así pues, a efectos de producción, mantener los datos de la aplicación separados en esquemas mejora la gestión; y a efectos de usuario, mantener a los usuarios en esquemas separados evita que la colisión no deseada de actividades entre ellos." ], "id_hash": 212467821786474283, "content_hash": 212467821786474283, "location": "../../en/schemas.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/98056/?format=api", "priority": 100, "id": 98305, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=82f2d65bb3c8a72b", "url": "https://weblate.osgeo.org/api/units/98305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.437241Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Creating a Data Schema" ], "previous_source": "", "target": [ "Creando un Esquema de Datos" ], "id_hash": 7568461229420045468, "content_hash": 7568461229420045468, "location": "../../en/schemas.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/98060/?format=api", "priority": 100, "id": 98307, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=e908936383e5e49c", "url": "https://weblate.osgeo.org/api/units/98307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.438960Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Let's create a new schema and move a table into it. First, create a new schema in the database:" ], "previous_source": "", "target": [ "Vamos a crear un nuevo esquema y mover una tabla dentro de él. Primero, crea un nuevo esquema en la base de datos:" ], "id_hash": -279613405728732838, "content_hash": -279613405728732838, "location": "../../en/schemas.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/98063/?format=api", "priority": 100, "id": 98309, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=7c1e9d16c51a095a", "url": "https://weblate.osgeo.org/api/units/98309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.440613Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "previous_source": "", "target": [ "A continuación, moveremos la tabla ``nyc_census_blocks`` al esquema ``census``:" ], "id_hash": 8464045524879258247, "content_hash": 8464045524879258247, "location": "../../en/schemas.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/98067/?format=api", "priority": 100, "id": 98311, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=f576548f7929b287", "url": "https://weblate.osgeo.org/api/units/98311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.442286Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "If you're using the :command:`psql` command-line program, you'll notice that ``nyc_census_blocks`` has disappeared from your table listing now! If you're using PgAdmin, you might have to refresh your view to see the new schema and the table inside it." ], "previous_source": "", "target": [ "Si estás usando el programa de línea de comandos :command:`psql`, notarás que ``nyc_census_blocks`` ha desaparecido de tu lista de tablas ahora! Si estás usando PgAdmin, puede que tengas que refrescar tu vista para ver el nuevo esquema y la tabla dentro de él." ], "id_hash": 1436805870175200359, "content_hash": 1436805870175200359, "location": "../../en/schemas.rst:48", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/98071/?format=api", "priority": 100, "id": 98313, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=93f08f538efd2467", "url": "https://weblate.osgeo.org/api/units/98313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.444009Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "You can access tables inside schemas in two ways:" ], "previous_source": "", "target": [ "Puedes acceder a las tablas dentro de los esquemas de dos maneras:" ], "id_hash": -8600915504822134896, "content_hash": -8600915504822134896, "location": "../../en/schemas.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98075/?format=api", "priority": 100, "id": 98315, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=08a368eaffed5790", "url": "https://weblate.osgeo.org/api/units/98315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.445799Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "by referencing them using ``schema.table`` notation" ], "previous_source": "", "target": [ "haciendo referencia a ellas usando la notación ``schema.table``" ], "id_hash": 4184222717610201623, "content_hash": 4184222717610201623, "location": "../../en/schemas.rst:52", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/98079/?format=api", "priority": 100, "id": 98317, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=ba11586488469217", "url": "https://weblate.osgeo.org/api/units/98317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.447492Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "by adding the schema to your ``search_path``" ], "previous_source": "", "target": [ "añadiendo el esquema a tu ``search_path``" ], "id_hash": 788069461238815375, "content_hash": 788069461238815375, "location": "../../en/schemas.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/98083/?format=api", "priority": 100, "id": 98319, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=8aefc8ffe7791a8f", "url": "https://weblate.osgeo.org/api/units/98319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.449220Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "previous_source": "", "target": [ "La referencia explícita es fácil, pero con el tiempo se vuelve tediosa de escribir:" ], "id_hash": 5451639701760265941, "content_hash": 5451639701760265941, "location": "../../en/schemas.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/98087/?format=api", "priority": 100, "id": 98321, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=cba81d6cbad64ed5", "url": "https://weblate.osgeo.org/api/units/98321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.450861Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Manipulating the ``search_path`` is a nice way to provide access to tables in multiple schemas without lots of extra typing." ], "previous_source": "", "target": [ "Manipular el ``search_path`` es una buena manera de proporcionar acceso a tablas en múltiples esquemas sin mucho tipeo adicional." ], "id_hash": -8766865489712415021, "content_hash": -8766865489712415021, "location": "../../en/schemas.rst:61", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/98091/?format=api", "priority": 100, "id": 98323, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=0655d649340f7ed3", "url": "https://weblate.osgeo.org/api/units/98323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.452509Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "previous_source": "", "target": [ "Puedes establecer el ``search_path`` en tiempo de ejecución usando el comando ``SET``:" ], "id_hash": 6261257118765750880, "content_hash": 6261257118765750880, "location": "../../en/schemas.rst:63", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/98095/?format=api", "priority": 100, "id": 98325, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=d6e4742d0b6b1a60", "url": "https://weblate.osgeo.org/api/units/98325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.454182Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "This ensures that all references to relations and functions are searched in both the ``census`` and the ``public`` schemas. Remember that all the PostGIS functions and types are in ``public`` so we don't want to drop that from the search path." ], "previous_source": "", "target": [ "Esto asegura que todas las referencias a relaciones y funciones sean buscadas tanto en los esquemas ``census`` como ``public``. Recuerda que todas las funciones y tipos de PostGIS están en ``public`` así que no queremos quitarlo del search path." ], "id_hash": -7875221711749531039, "content_hash": -7875221711749531039, "location": "../../en/schemas.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/98099/?format=api", "priority": 100, "id": 98327, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=12b59793efb9ba61", "url": "https://weblate.osgeo.org/api/units/98327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.455811Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Setting the search path every time you connect can get tiring too, but fortunately it's possible to permanently set the search path for a user:" ], "previous_source": "", "target": [ "Configurar el search path cada vez que te conectas también puede ser cansado, pero afortunadamente es posible establecerlo de forma permanente para un usuario:" ], "id_hash": -2639337842923577153, "content_hash": -2639337842923577153, "location": "../../en/schemas.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://weblate.osgeo.org/api/units/98103/?format=api", "priority": 100, "id": 98329, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=5b5f3037364b60bf", "url": "https://weblate.osgeo.org/api/units/98329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.457542Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "previous_source": "", "target": [ "Ahora el usuario postgres siempre tendrá el esquema ``census`` en su search path." ], "id_hash": -4405374113662166495, "content_hash": -4405374113662166495, "location": "../../en/schemas.rst:77", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98107/?format=api", "priority": 100, "id": 98331, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=42dcf79594771a21", "url": "https://weblate.osgeo.org/api/units/98331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.459250Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Creating a User Schema" ], "previous_source": "", "target": [ "Creación de un esquema de usuario" ], "id_hash": 3047927684053294564, "content_hash": 3047927684053294564, "location": "../../en/schemas.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/98111/?format=api", "priority": 100, "id": 98334, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=aa4c6a147d135de4", "url": "https://weblate.osgeo.org/api/units/98334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.460906Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Users like to create tables, and PostGIS users do so particularly: analysis operations with SQL demand temporary tables for visualization or interim results, so spatial SQL tends to require that users have CREATE privileges more than ordinary database workloads." ], "previous_source": "", "target": [ "A los usuarios les gusta crear tablas, y los usuarios de PostGIS en particular: las operaciones de análisis con SQL requieren tablas temporales para visualización o resultados intermedios, así que el SQL espacial tiende a requerir que los usuarios tengan privilegios de CREATE más que las cargas de trabajo ordinarias de bases de datos." ], "id_hash": -2034115669987581779, "content_hash": -2034115669987581779, "location": "../../en/schemas.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/98115/?format=api", "priority": 100, "id": 98337, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=63c55e934a55a0ad", "url": "https://weblate.osgeo.org/api/units/98337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.462516Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "By default, every role in Oracle is given a personal schema. This is a nice practice to use for PostgreSQL users too, and is easy to replicate using PostgreSQL roles, schemas, and search paths." ], "previous_source": "", "target": [ "De manera predeterminada, cada rol en Oracle recibe un esquema personal. Esta es una buena práctica para usar también con los usuarios de PostgreSQL, y es fácil de replicar usando roles, esquemas y search paths de PostgreSQL." ], "id_hash": -1237469761498094955, "content_hash": -1237469761498094955, "location": "../../en/schemas.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://weblate.osgeo.org/api/units/98119/?format=api", "priority": 100, "id": 98339, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=6ed39fceed9e6295", "url": "https://weblate.osgeo.org/api/units/98339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.464325Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "Create a new user with table creation privileges (see :ref:`security` for information about the ``postgis_writer`` role), then create a schema with that user as the authorization:" ], "previous_source": "", "target": [ "Crea un nuevo usuario con privilegios de creación de tablas (ver :ref:`security` para información sobre el rol ``postgis_writer``), luego crea un esquema con ese usuario como autorización:" ], "id_hash": 6955049323959501885, "content_hash": 6955049323959501885, "location": "../../en/schemas.rst:87", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/98123/?format=api", "priority": 100, "id": 98341, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=e0854c82bded443d", "url": "https://weblate.osgeo.org/api/units/98341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.466070Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "If you log in as that user, you'll find the default ``search_path`` for PostgreSQL is actually this:" ], "previous_source": "", "target": [ "Si inicias sesión como ese usuario, encontrarás que el ``search_path`` predeterminado para PostgreSQL es en realidad este:" ], "id_hash": 7750240245039702294, "content_hash": 7750240245039702294, "location": "../../en/schemas.rst:94", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/98127/?format=api", "priority": 100, "id": 98343, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=eb8e6270b9872116", "url": "https://weblate.osgeo.org/api/units/98343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.468256Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "The first schema on the search path us the user's named schema! So now the following conditions exist:" ], "previous_source": "", "target": [ "¡El primer esquema en el search path es el esquema con el nombre del usuario! Así que ahora existen las siguientes condiciones:" ], "id_hash": 3280979363715958380, "content_hash": 3280979363715958380, "location": "../../en/schemas.rst:106", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/98131/?format=api", "priority": 100, "id": 98345, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=ad88615911ad466c", "url": "https://weblate.osgeo.org/api/units/98345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.470475Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "The user exists, with the ability to create spatial tables." ], "previous_source": "", "target": [ "El usuario existe, con la capacidad de crear tablas espaciales." ], "id_hash": -2722499917199656732, "content_hash": -2722499917199656732, "location": "../../en/schemas.rst:108", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98134/?format=api", "priority": 100, "id": 98347, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=5a37bcbfee48b8e4", "url": "https://weblate.osgeo.org/api/units/98347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.472743Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "The user's named schema exists, and the user owns it." ], "previous_source": "", "target": [ "El esquema con el nombre del usuario existe, y el usuario es su propietario." ], "id_hash": 1323214385234670449, "content_hash": 1323214385234670449, "location": "../../en/schemas.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98137/?format=api", "priority": 100, "id": 98349, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=925d007901997371", "url": "https://weblate.osgeo.org/api/units/98349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.474992Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "The user's search path has the user schema first, so new tables are automatically created there, and queries automatically search there first." ], "previous_source": "", "target": [ "El search path del usuario tiene primero el esquema del usuario, por lo que las nuevas tablas se crean automáticamente allí, y las consultas buscan automáticamente allí primero." ], "id_hash": 4302773267715094602, "content_hash": 4302773267715094602, "location": "../../en/schemas.rst:110", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/98140/?format=api", "priority": 100, "id": 98351, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=bbb6857d6b34784a", "url": "https://weblate.osgeo.org/api/units/98351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.477165Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/es/?format=api", "source": [ "That's all there is to it, the user's default work area is now nicely separated from any tables in other schemas." ], "previous_source": "", "target": [ "Eso es todo, el área de trabajo predeterminada del usuario ahora está bien separada de cualquier tabla en otros esquemas." ], "id_hash": 898247385090668541, "content_hash": 898247385090668541, "location": "../../en/schemas.rst:112", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/98142/?format=api", "priority": 100, "id": 98354, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/es/?checksum=8c77373cd4c0b7fd", "url": "https://weblate.osgeo.org/api/units/98354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.479038Z" } ] }