{"id":93089,"date":"2020-09-03T01:42:16","date_gmt":"2020-09-02T23:42:16","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota"},"modified":"2020-09-03T01:42:16","modified_gmt":"2020-09-02T23:42:16","slug":"awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","title":{"rendered":"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/41d7ca428261b80f365797a19c547000.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tere, Habr! Ilmselt on iga\u00fchel meist olemas fail, kuhu me peidame midagi kasulikku ja huvitavat. Need v\u00f5ivad olla lingid artiklitele, raamatutele, hoidlatele, k\u00e4siraamatutele. Need v\u00f5ivad olla j\u00e4rjehoidjad brauseris v\u00f5i isegi lihtsalt avatud vahekled, mis on j\u00e4etud hilisemaks. Aja jooksul kasvab kogu see kogus ja lingid lakkavad t\u00f6\u00f6tamast, ent suur osa materjalist lihtsalt ajab vanaks. <\/p>\n<p><\/p>\n<p>\u0410 \u0447\u0442\u043e \u0435\u0441\u043b\u0438 \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u044d\u0442\u043e\u0439 \u0433\u043e\u0434\u043d\u043e\u0442\u043e\u0439 \u0441 \u0441\u043e\u043e\u0431\u0449\u0435\u0441\u0442\u0432\u043e\u043c \u0438 \u0432\u044b\u043b\u043e\u0436\u0438\u0442\u044c \u044d\u0442\u043e\u0442 \u0444\u0430\u0439\u043b\u0438\u043a \u043d\u0430 \u0433\u0438\u0442\u0445\u0430\u0431? \u0422\u043e\u0433\u0434\u0430 \u0432\u0430\u0448\u0438 \u0442\u0440\u0443\u0434\u044b \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u043f\u043e\u043b\u0435\u0437\u043d\u044b \u0435\u0449\u0435 \u043a\u043e\u043c\u0443-\u043d\u0438\u0431\u0443\u0434\u044c, \u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0442\u044c \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u043c\u043e\u0436\u043d\u043e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e, \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u044f \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u043e\u0442 \u0436\u0435\u043b\u0430\u044e\u0449\u0438\u0445 \u0447\u0435\u0440\u0435\u0437 \u0441\u0442\u0430\u0440\u044b\u0435 \u0434\u043e\u0431\u0440\u044b\u0435 PR&#8217;\u044b. \u0418\u043c\u0435\u043d\u043d\u043e \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d \u043f\u0440\u043e\u0435\u043a\u0442 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">Awesome lists<\/a><\/noindex>. See on one of the top 10 Github repositories, possessing 138K stars, and a link to your work could appear directly in its root README, attracting a huge audience to your creativity. However, this will require a bit of effort. I want to share my experience of such efforts with you. <\/p>\n<p><\/p>\n<p>Minu nimi on Maksim Gramin. KROK-is tegelen Java-arenduse ja andmebaasiuuringutega. Selles postituses r\u00e4\u00e4gin, mis on Awesome Lists ja kuidas luua oma t\u00f5eline ametlik awesome-hoidla.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"chto-takoe-awesome-lists\">Mis on Awesome Lists<\/h2>\n<p><\/p>\n<p>Kui mul tuleb selgeks teha m\u00f5ni uus tehnoloogia v\u00f5i programmeerimiskeel, suundun ma k\u00f5igepealt just siia \u2014 leian vajaliku sektsiooni ja seal sobivad listid. Ja nagu n\u00e4htub t\u00e4htede arvust ja nende pidevast kasvust, ei tee seda ainult mina.<br \/>\n<img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/383d1f4d5126fe2a11d449cf5e83b576.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tegelikult on see tavaline lame readme.md, mis elab eraldi <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">hoidlad<\/a><\/noindex>, \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442 \u043f\u0440\u0438 \u044d\u0442\u043e\u043c 8-\u0435 \u043c\u0435\u0441\u0442\u043e \u0441\u0440\u0435\u0434\u0438 \u0432\u0441\u0435\u0445 \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0435\u0432 GitHub&#8217;\u0430 \u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u0434\u0440\u0443\u0433\u0438\u0435 \u043b\u0438\u0441\u0442\u044b, \u043f\u043e\u0441\u0432\u044f\u0449\u0435\u043d\u043d\u044b\u0435 \u043a\u0430\u043a\u043e\u0439-\u043b\u0438\u0431\u043e \u0442\u0435\u043c\u0430\u0442\u0438\u043a\u0435. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0440\u0430\u0437\u0434\u0435\u043b\u0435 Programming Languages \u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0439\u0442\u0438 \u043b\u0438\u0441\u0442\u044b Awesome Python \u0438 Awesome Go, \u0430 \u0432 Front-End Development \u0435\u0441\u0442\u044c \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0435 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432 \u043f\u043e WEB-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0435. \u041d\u0443 \u0438, \u043a\u043e\u043d\u0435\u0447\u043d\u043e \u0436\u0435, \u2014 \u0440\u0430\u0437\u0434\u0435\u043b <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome#databases\">Andmebaasid<\/a><\/noindex> (kui me sinna hiljem tagasi p\u00f6\u00f6rdume). Ja jah, kogu see ei piirdu ainult tehniliste teemadega. N\u00e4iteks Meelelahutuse ja M\u00e4ngude sektsioonides v\u00f5ib samuti leida palju huvitavat (mina isiklikult olin r\u00f5\u00f5mus <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/RichardLitt\/awesome-fantasy\">awesome-fantasy<\/a><\/noindex>).<br \/>\nPeamine omadus on see, et k\u00f5ik need listid ei ole koostatud isiklikult autori poolt, vaid kogukonna poolt ja need on koosk\u00f5lastatud spetsiaalse ja v\u00e4ga range <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/blob\/main\/awesome.md\">awesome manifesto<\/a><\/noindex>. \u041a\u0430\u0436\u0434\u044b\u0439 \u0442\u0430\u043a\u043e\u0439 \u043b\u0438\u0441\u0442 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0430\u043c\u043e\u0441\u0442\u043e\u044f\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u0441\u0442\u0432\u043e\u043c \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u043e\u0432, \u0436\u0438\u0432\u0435\u0442 \u0441\u0432\u043e\u0435\u0439 \u0436\u0438\u0437\u043d\u044c\u044e \u0438 \u043e\u0442\u043a\u0440\u044b\u0442 \u0434\u043b\u044f \u0432\u0430\u0448\u0438\u0445 pull request&#8217;\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0441\u0434\u0435\u043b\u0430\u044e\u0442 \u0435\u0433\u043e \u0435\u0449\u0435 \u043b\u0443\u0447\u0448\u0435. \u0410 \u0442\u0430\u043a\u0436\u0435 \u043b\u044e\u0431\u043e\u0439 \u0436\u0435\u043b\u0430\u044e\u0449\u0438\u0439 \u043c\u043e\u0436\u0435\u0442 \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0441\u0432\u043e\u0439 \u0441\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043b\u0438\u0441\u0442, \u0435\u0441\u043b\u0438 \u043a\u0430\u043a\u0430\u044f-\u0442\u043e \u0442\u0435\u043c\u0430 \u0435\u0449\u0435 \u043d\u0435 \u0431\u044b\u043b\u0430 \u043e\u0441\u0432\u0435\u0449\u0435\u043d\u0430.<\/p>\n<p><\/p>\n<p>Idee autor ja kogu selle tegevuse koordinaator on legendaarne Sindre S\u00f8rhus, <noindex><a rel=\"nofollow\" href=\"https:\/\/gitstar-ranking.com\/users\">\u043f\u0435\u0440\u0432\u044b\u0439 \u0447\u0435\u043b\u043e\u0432\u0435\u043a \u043d\u0430 GitHub&#8217;\u0435<\/a><\/noindex>, \u00fcle <noindex><a rel=\"nofollow\" href=\"https:\/\/www.npmjs.com\/~sindresorhus\">1000 npm-mooduli autor,<\/a><\/noindex>ja just tema v\u00f5tab vastu teie PR-id.<br \/>\n<img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/6e5e9416b5f97ef4c0c9f00a3fb21f19.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<h2 id=\"kak-popast-v-awesome-list\">Kuidas p\u00e4\u00e4seda awesome-listi<\/h2>\n<p><\/p>\n<p>Kui te ei leidnud sobivat nimekirja huvipakkuva teema kohta, siis see on esimene m\u00e4rk, et tuleb see ise luua!<\/p>\n<p><\/p>\n<p>R\u00e4\u00e4gin oma projekti n\u00e4itel, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools,<\/a><\/noindex> \u2014 Projektist projekti pean t\u00f6\u00f6tama k\u00f5ige erinevamate andmebaasidega, seet\u00f5ttu olen koostanud sellise faili, kuhu kogusin kasulikke t\u00f6\u00f6riistu nende haldamiseks, erinevaid DB-migratoreid, IDE-sid, admin-paneele, j\u00e4lgimise vahendeid ja muud. T\u00f6\u00f6riistad, mida olen juba kasutanud v\u00f5i alles plaanisin hakata kasutama. Jagasin seda faili kolleegidega KROK'is ja ka v\u00e4ljaspool seda. See aitas paljusid ja oli huvitav. L\u00f5puks soovis ma suuremat kuulsust, kui m\u00e4rkasin, et andmebaaside osas ei olnud selle teema kohta nimekirja. Ja otsustasin sinna oma lisada. <\/p>\n<p><\/p>\n<p><strong>Mida selleks on vaja?<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>Registreerime tavalise GitHub'i repo nimega awesome- midagigi. Minu puhul oli see awesome-database-tools.<\/li>\n<li>Viime oma nimekirja awesome formaati, siin aitab meid <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dar5hak\/generator-awesome-list\">generator-awesome-list,<\/a><\/noindex>, mis genereerib k\u00f5ik vajalikud failid soovitud formaadis.<\/li>\n<li>Seame \u00fcles t\u00f5elise CI. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome-lint\">awesome-lint<\/a><\/noindex> ja travis ci aitavad meil kontrollida <noindex><a rel=\"nofollow\" href=\"https:\/\/travis-ci.org\/github\/mgramin\/awesome-db-tools\">meie nimekirja<\/a><\/noindex> kehtivust.<\/li>\n<li>Ootame 30 p\u00e4eva, <\/li>\n<li>\u0414\u0435\u043b\u0430\u0435\u043c \u0440\u0435\u0432\u044c\u044e \u043a\u0430\u043a \u043c\u0438\u043d\u0438\u043c\u0443\u043c \u043d\u0430 2 \u0447\u0443\u0436\u0438\u0445 PR&#8217;\u0430<\/li>\n<li>Ja l\u00f5puks teeme PR-i peamise repo juurde, kuhu lisame lingi oma repo juurde. Siin on vajalik hoolikalt k\u00f5ik l\u00e4bi lugeda ja t\u00e4ita k\u00f5ik arvukad n\u00f5udmised uue nimekirja ja PR-i suhtes.<\/li>\n<\/ol>\n<p><\/p>\n<p>Minu esimene katse <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1336\">oli eba\u00f5nnestunud.<\/a><\/noindex><br \/>\n<img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/196dd3f494d5e91eaa7af49e16f74393.jpeg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nKuid m\u00f6\u00f6dus natuke aega, kogusin veel rohkem materjali, t\u00f6\u00f6tasin vigade kallal ja julgesin <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1679\">teise katse.<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Kuid unustasin \u00fche v\u00e4ga olulise asja, millest mulle pehmelt vihjati:<br \/>\n<img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/0ec0a33b3c7bb15b6cce6bf076208f09.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Olin mitte eriti t\u00e4helepanelik ja ei lisanud \u00fchtegi \u00fckssarvikut, et kinnitada, et k\u00f5ik n\u00f5uded on t\u00e4idetud.<br \/>\n<img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/3a69eb82ca26310c78bf5f6c3c8ef383.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Seej\u00e4rel m\u00f6\u00f6dus veel natuke aega, veel m\u00f5ned parandused m\u00e4rkuste p\u00f5hjal ja tuli kauaoodatud <noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/awesome__re\/status\/1246779641475424256\">tviit,<\/a><\/noindex>, et minu PR oli vastu v\u00f5etud.<\/p>\n<p><\/p>\n<p>Nii, ma sain oma esimese nimekirja autoriks ja hakkasid mulle tulema <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools\/pulls?q=is%3Apr+is%3Aclosed\">PR&#8217;\u044b<\/a><\/noindex> koosolekust uusi t\u00f6\u00f6riistu lisada. Ja paljud neist on juba kaasatud <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools,<\/a><\/noindex>. Kui ei viitsi lingile minna, <\/p>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">siin on ajakohane valik postituse avaldamise hetkel<\/b><\/p>\n<h1 id=\"awesome-database-tools-awesomehttpsawesomerebadgesvghttpsawesomere\">Awesome Database Tools, <noindex><a rel=\"nofollow\" href=\"https:\/\/awesome.re\"><img decoding=\"async\" alt=\"K\u00e4esolev nimekiri ise loomulikult, v\u00f5i GitHub kui alternatiiv\" src=\"\/wp-content\/uploads\/2020\/09\/2951c443e95e3c56f93fb685afed6115.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/h1>\n<p><\/p>\n<blockquote><p>Kogukonna juhitud andmebaasit\u00f6\u00f6riistade loend<\/p><\/blockquote>\n<p>Siia kogume teavet suurep\u00e4raste ja kasulike ning eksperimentaalsete t\u00f6\u00f6riistade kohta, mis lihtsustavad andmebaasidega t\u00f6\u00f6tamist DBA-de, DevOpsi, arendajate ja tavainimeste jaoks.<\/p>\n<p><\/p>\n<p>\u00c4ra k\u00f5hkle lisada teavet oma andmebaasit\u00f6\u00f6riistade v\u00f5i lemmik kolmandate osapoolte andmebaasit\u00f6\u00f6riistade kohta.<\/p>\n<p><\/p>\n<h2 id=\"contents\">Sisu<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#ide\">IDE<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#gui-managersclients\">GUI juhid \/ kliendid<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#cli-tools\">CLI t\u00f6\u00f6riistad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#db-schema-navigation-and-visualization\">Andmebaasi skeemide navigeerimine ja visualiseerimine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#modelers\">Mudelite loomine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#migration-tools\">R\u00e4nde t\u00f6\u00f6riistad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-generation-tools\">Koodigeneratsioonit\u00f6\u00f6riistad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#wrappers\">Katted<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#backup-tools\">Varundust\u00f6\u00f6riistad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#replicationdata-operation\">Replikatsioon \/ andmete toimingud<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#scripts\">Skripti<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#monitoringstatisticsperfomance\">J\u00e4lgimine \/ statistika \/ j\u00f5udlus<\/a><\/noindex>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#zabbix\">Zabbix<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#testing\">Testimine<\/a><\/noindex>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#data-generator\">Andmete genereerimine<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#administration\">Haldamine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#hafailoversharding\">HA \/ failover \/ sharding<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#kubernetes\">Kubernetes<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#configuration-tuning\">Seadistuse timmimine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#devops\">DevOps<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#schema-samples\">Skeemi n\u00e4idised<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#reporting\">Aruandlus<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#distributions\">Jaotused<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#security\">Turve<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-formatters\">Koodi vormindajad<\/a><\/noindex><\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"ide\">IDE<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlmaestro.com\/products\/anysql\/maestro\">AnySQL Maestro<\/a><\/noindex> \u2014 Tipptasemel mitmeotstarbeline haldust\u00f6\u00f6riist andmebaaside haldamiseks, kontrollimiseks ja arendamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.aquafold.com\/aquadatastudio\">Aqua Data Studio<\/a><\/noindex> \u2014 Aqua Data Studio on tootlikkustarkvara andmebaasi arendajatele, DBA-dele ja anal\u00fc\u00fctikutele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/fishcodelib.com\/Database.htm\">Database .net<\/a><\/noindex> \u2014 Mitme andmebaasi haldust\u00f6\u00f6riist, mis toetab rohkem kui 20 andmebaasi.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jetbrains.com\/datagrip\">DataGrip<\/a><\/noindex> \u2014 Platvormide\u00fclene IDE andmebaasidele ja SQL-ile JetBrainsilt.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbeaver\/dbeaver\">DBeaver<\/a><\/noindex> \u2014 Tasuta universaalne andmebaasi haldur ja SQL klient.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/studio\">dbForge Studio for MySQL<\/a><\/noindex> \u2014 \u00dcks universaalne IDE MySQL ja MariaDB andmebaasi arendamiseks, haldamiseks ja administreerimiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/studio\">dbForge Studio for Oracle<\/a><\/noindex> \u2014 T\u00f5hus IDE Oracle'i haldamiseks, administreerimiseks ja arendamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/postgresql\/studio\">dbForge Studio for PostgreSQL<\/a><\/noindex> \u2014 GUI-t\u00f6\u00f6riist andmebaaside ja objektide haldamiseks ja arendamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/sql\/studio\">dbForge Studio for SQL Server<\/a><\/noindex> \u2014 T\u00f5hus integreeritud arenduskeskkond SQL Serveri arendamiseks, haldamiseks, administreerimiseks, andmeanal\u00fc\u00fcsiks ja aruandluseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/SouthbankSoftware\/dbkoda\">dbKoda<\/a><\/noindex> \u2014 Kaasaegne (JavaScript \/ Electron raamistik), avatud l\u00e4htekoodiga IDE MongoDB jaoks. Sellel on funktsioonid, mis toetavad MongoDB andmebaaside arendust, administreerimist ja j\u00f5udluse timmimist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.ibexpert.net\/ibe\">IBExpert<\/a><\/noindex> \u2014 Ulatuslik GUI-t\u00f6\u00f6riist Firebird ja InterBase jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HeidiSQL\/HeidiSQL\">HeidiSQL<\/a><\/noindex> \u2014 Kerge klient MySQL, MSSQL ja PostgreSQL haldamiseks, kirjutatud Delphi's.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mysql.com\/products\/workbench\">MySQL Workbench<\/a><\/noindex> \u2014 MySQL Workbench on ainulaadne visuaalne t\u00f6\u00f6riist andmebaasi arhitektidele, arendajatele ja DBA-dele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products#navicat\">Navicat<\/a><\/noindex> \u2014 Andmebaasi arendust\u00f6\u00f6riist, mis v\u00f5imaldab teil samal ajal \u00fchendada MySQL, MariaDB, SQL Serveri, Oracle'i, PostgreSQLi ja SQLite andmebaase \u00fchest rakendusest.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\">Oracle SQL Developer<\/a><\/noindex> \u2014 Oracle SQL Developer on tasuta integreeritud arenduskeskkond, mis lihtsustab Oracle'i andmebaasi arendamist ja haldamist nii traditsioonilistes kui ka pilvep\u00f5histes rakendustes.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgadmin.org\">pgAdmin<\/a><\/noindex> \u2014 K\u00f5ige populaarsem ja funktsioonirikam avatud l\u00e4htekoodiga haldus- ja arendusplatvorm PostgreSQL jaoks, mis on k\u00f5ige arenenum avatud l\u00e4htekoodiga andmebaas maailmas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\/pgadmin3\">pgAdmin3<\/a><\/noindex> \u2014 Pikajaline tugi pgAdmin3 jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.allroundautomations.com\/products\/pl-sql-developer\">PL\/SQL Developer<\/a><\/noindex> \u2014 IDE, mis on suunatud spetsiaalselt salvestatud programmide arendamisele Oracle'i andmebaaside jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlmaestro.com\/products\/postgresql\/maestro\">PostgreSQL Maestro<\/a><\/noindex> \u2014 T\u00e4ielik ja v\u00f5imas andmebaasi haldamise, administraatori ja arendust\u00f6\u00f6riist PostgreSQL jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/toad\/\">Toad<\/a><\/noindex> \u2014 Toad on tipptasemel andmebaasi lahendus arendajatele, administraatoritele ja andmeanal\u00fc\u00fctikutele. Halda keerukaid andmebaasi muudatusi koos \u00fche andmebaasi haldust\u00f6\u00f6riistaga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.toadworld.com\/products\/toad-edge\">Toad Edge<\/a><\/noindex> \u2014 Lihtsustatud andmebaasi arendust\u00f6\u00f6riist MySQL ja Postgres jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tora-tool\/tora\">TOra<\/a><\/noindex> \u2014 TOra on avatud l\u00e4htekoodiga SQL IDE Oracle'i, MySQL ja PostgreSQL andmebaaside jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.valentina-db.com\/en\/valentina-studio-overview\">Valentina Studio<\/a><\/noindex> \u2014 Loo, halda, p\u00e4ring ja uuri Valentina DB, MySQL, MariaDB, PostgreSQL ja SQLite andmebaase TASUTA.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"gui-managersclients\">GUI juhid \/ kliendid<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vrana\/adminer\">Adminer<\/a><\/noindex> \u2014 Andmebaasi haldus \u00fche PHP faili kaudu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dbvis.com\">DbVisualizer<\/a><\/noindex> \u2014 Universaalne andmebaasi t\u00f6\u00f6riist arendajatele, DBA-dele ja anal\u00fc\u00fctikutele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HouseOps\/HouseOps\">HouseOps<\/a><\/noindex> \u2014 Ettev\u00f5tte ClickHouse'i Ops UI, et saaksite p\u00e4ringuid teha, j\u00e4lgida ClickHouse'i tervist ja teha palju muid asju.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jackdb.com\">JackDB<\/a><\/noindex> \u2014 Otsene SQL-iga juurdep\u00e4\u00e4s kogu oma andmetele, s\u00f5ltumata nende asukohast.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/OmniDB\/OmniDB\">OmniDB<\/a><\/noindex> \u2014 Veebit\u00f6\u00f6riist andmebaasi haldamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sosedoff\/pgweb\">Pgweb<\/a><\/noindex> \u2014 Veebip\u00f5hine andmebaasi brauser PostgreSQL jaoks, kirjutatud Go-s ja t\u00f6\u00f6tab macOS, Linuxi ja Windowsi masinatel.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.phpliteadmin.org\">phpLiteAdmin<\/a><\/noindex> \u2014 Veebip\u00f5hine SQLite andmebaasi haldust\u00f6\u00f6riist, kirjutatud PHP-s, toetab SQLite3 ja SQLite2.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/phpmyadmin\/phpmyadmin\">phpMyAdmin<\/a><\/noindex> \u2014 Veebiliides MySQL ja MariaDB jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.psequel.com\">psequel<\/a><\/noindex> \u2014 PSequel pakub puhtat ja lihtsat liidest, millega saate kiiresti teha tavalisi PostgreSQL \u00fclesandeid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/popsql.com\">PopSQL<\/a><\/noindex> \u2014 Kaasaegne, koost\u00f6\u00f6line SQL redaktor teie meeskonnale.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/eggerapps.at\/postico\">Postico<\/a><\/noindex> \u2014 Kaasaegne PostgreSQL klient Macile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Studio3T\/robomongo\">Robo 3T<\/a><\/noindex> \u2014 Robo 3T (endise nimega Robomongo) on shell-keskselt t\u00f6\u00f6tav MultuDB haldust\u00f6\u00f6riist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sequelpro\/sequelpro\">Sequel Pro<\/a><\/noindex> \u2014 Sequel Pro on kiire ja lihtne Maci andmebaasi haldamise rakendus, mis t\u00f6\u00f6tab MySQL ja MariaDB andmebaasidega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\">SQL Operations Studio<\/a><\/noindex> \u2014 Andmehaldusvahend, mis v\u00f5imaldab t\u00f6\u00f6tada SQL Serveri, Azure SQL DB ja SQL DW-ga Windowsis, macOS-is ja Linuxis.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqliteexpert.com\/index.html\">SQLite Expert<\/a><\/noindex> \u2014 Graafiline liides toetab k\u00f5iki SQLite funktsioone.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rickbergfalk\/sqlpad\">sqlpad<\/a><\/noindex> \u2014 Veebip\u00f5hine SQL redaktor, mis t\u00f6\u00f6tab teie enda privaatses pilves.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.macpostgresclient.com\">SQLPro<\/a><\/noindex> \u2014 Lihtne ja v\u00f5imas Postgresi haldur macOS-il.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/squirrel-sql\">SQuirreL<\/a><\/noindex> \u2014 Graafiline SQL klient, kirjutatud Java-s, mis v\u00f5imaldab teil vaadata JDBC \u00fchilduva andmebaasi struktuuri, sirvida tabeleid, v\u00e4lja anda SQL-k\u00e4sklusi jne.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mtxr\/vscode-sqltools\">SQLTools<\/a><\/noindex> \u2014 Andmebaasi haldus VSCode jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/sqlyog\">SQLyog<\/a><\/noindex> \u2014 K\u00f5ige terviklikum ja h\u00f5lpsamini kasutatav MySQL GUI.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tabixio\/tabix\">Tabix<\/a><\/noindex> \u2014 SQL redaktor ja avatud l\u00e4htekoodiga lihtne \u00e4riintellekti t\u00f6\u00f6riist Clickhouse'i jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/TablePlus\/TablePlus\">TablePlus<\/a><\/noindex> \u2014 Kaasaegne, lokaalset ja s\u00f5bralik GUI t\u00f6\u00f6riist relaatsiooniliste andmebaaside jaoks: MySQL, PostgreSQL, SQLite ja palju muud.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.teampostgresql.com\">TeamPostgreSQL<\/a><\/noindex> \u2014 PostgreSQL veebihaldus GUI \u2014 kasutage oma PostgreSQL andmebaase k\u00f5ikjalt, rikkaliku ja \u00fclikiire AJAX veebiliidese kaudu.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"cli-tools\">CLI t\u00f6\u00f6riistad<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ipython-sql\">ipython-sql<\/a><\/noindex> \u2014 \u00dchendage andmebaasi, et v\u00e4lja anda SQL-k\u00e4sklusi IPythonis v\u00f5i IPython Notebooks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/laixintao\/iredis\">iredis<\/a><\/noindex> \u2014 CLI Redis jaoks automaatse t\u00e4itmise ja s\u00fcntaksihighlightinguga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/lesovsky\/pgcenter\">pgcenter<\/a><\/noindex> \u2014 Topi sarnane haldust\u00f6\u00f6riist PostgreSQL-ile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/julmon\/pg_activity\">pg_activity<\/a><\/noindex> \u2014 Topi sarnane rakendus PostgreSQL serveri tegevuse j\u00e4lgimiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/markwkm\/pg_top\">pg_top<\/a><\/noindex> \u2014 &#8216;top&#8217; for PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/okbob\/pspg\">pspg<\/a><\/noindex> \u2014 Postgresi pager.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sqlcl\/overview\/index.html\">SQLcl<\/a><\/noindex> \u2014 Oracle SQL arendaja k\u00e4surea t\u00f6\u00f6riist (SQLcl) on tasuta k\u00e4surea liides Oracle andmebaasi jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql\">usql<\/a><\/noindex> \u2014 Universaalne k\u00e4surea liides PostgreSQL-i, MySQL-i, Oracle andmebaasi, SQLite3, Microsoft SQL Serveri ja paljude teiste andmebaaside jaoks, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql#database-support\">ja paljude teiste andmebaaside<\/a><\/noindex> sealhulgas NoSQL ja mitte-struutitud andmebaase!<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"dbcli\">dbcli<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/athenacli\">athenacli<\/a><\/noindex> \u2014 AthenaCLI on CLI t\u00f6\u00f6riist AWS Athena teenuse jaoks, mis suudab automaatset t\u00e4itmist ja s\u00fcntaksihighlightingut.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/litecli\">litecli<\/a><\/noindex> \u2014 CLI SQLite andmebaaside jaoks automaatse t\u00e4itmise ja s\u00fcntaksihighlightinguga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mssql-cli\">mssql-cli<\/a><\/noindex> \u2014 K\u00e4surea klient SQL Serveri jaoks automaatse t\u00e4itmise ja s\u00fcntaksihighlightinguga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mycli\">mycli<\/a><\/noindex> \u2014 Terminali klient MySQL-i jaoks automaatse t\u00e4itmise ja s\u00fcntaksihighlightinguga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/pgcli\">pgcli<\/a><\/noindex> \u2014 Postgres CLI automaatse t\u00e4itmise ja s\u00fcntaksihighlightinguga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/vcli\">vcli<\/a><\/noindex> \u2014 Vertica CLI automaatse t\u00e4itmise ja s\u00fcntaksihighlightinguga.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"db-schema-navigation-and-visualization\">Andmebaasi skeemide navigeerimine ja visualiseerimine<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/dbdiagram.io\">dbdiagram.io<\/a><\/noindex> \u2014 Kiire ja lihtne t\u00f6\u00f6riist, mis aitab teil kiiresti joonistada oma andmebaasi seose diagramme ja vooge lihtsa DSL keele abil.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Alexis-benoist\/eralchemy\">ERAlchemy<\/a><\/noindex> \u2014 Entiteedi seose diagrammide genereerimise t\u00f6\u00f6riist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemacrawler\/SchemaCrawler\">SchemaCrawler<\/a><\/noindex> \u2014 Tasuta andmebaasi skeemi avastamise ja m\u00f5istmise t\u00f6\u00f6riist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemaspy\/schemaspy\">Schema Spy<\/a><\/noindex> \u2014 Teie andmebaasi genereerimine HTML dokumentatsiooniks, sealhulgas entiteedi suhete diagrammid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/k1LoW\/tbls\">tbls<\/a><\/noindex> \u2014 CI-s\u00f5bralik t\u00f6\u00f6riist andmebaasi dokumenteerimiseks, kirjutatud Go-s.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"modelers\">Mudelite loomine<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products\/navicat-data-modeler\">Navicat Data Modeler<\/a><\/noindex> \u2014 T\u00f5hus ja kuluefektiivne andmebaasi kujundamise t\u00f6\u00f6riist, mis aitab teil luua kvaliteetseid kontseptsioonilisi, loogilisi ja f\u00fc\u00fcsilisi andmemudeleid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/datamodeler\/overview\/index.html\">Oracle SQL Developer Data Modeler<\/a><\/noindex> \u2014 Oracle SQL Developer Data Modeler on tasuta graafiline t\u00f6\u00f6riist, mis suurendab tootlikkust ja lihtsustab andme mudelimise \u00fclesandeid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgmodeler\/pgmodeler\">pgmodeler<\/a><\/noindex> \u2014 Andme mudelimise t\u00f6\u00f6riist PostgreSQL jaoks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"migration-tools\">R\u00e4nde t\u00f6\u00f6riistad<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CourseOrchestra\/2bass\">2bass<\/a><\/noindex> \u2014 Andmebaasi konfigureerimise t\u00f6\u00f6riist, mis kasutab idempotentsete DDL skriptide kontsepti.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/flyway\/flyway\">flyway<\/a><\/noindex> \u2014 Andmebaasi migratsioonit\u00f6\u00f6riist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/github\/gh-ost\">gh-ost<\/a><\/noindex> \u2014 Veebip\u00f5hine skeemi migratsioon MySQL-i jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/liquibase\/liquibase\">liquibase<\/a><\/noindex> \u2014 Andmebaasist s\u00f5ltumatu teek andmebaasi skeemi muudatuste j\u00e4lgimiseks, haldamiseks ja rakendamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/djrobstep\/migra\">migra<\/a><\/noindex> \u2014 Nagu diff, kuid PostgreSQL skeemide jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/salsita\/node-pg-migrate\">node-pg-migrate<\/a><\/noindex> \u2014 Node.js andmebaasi migreerimise haldamine, mis on ehitatud eksklusiivselt Postgrese jaoks. (Kuid seda saab kasutada ka teiste andmebaasidega, mis vastavad SQL standardile \u2014 n\u00e4iteks CockroachDB.)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/perseas\/Pyrseas\">Pyrseas<\/a><\/noindex> \u2014 Pakub utiliite PostgreSQL andmebaasi skeemi kirjeldamiseks YAML formaadis.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemahero\/schemahero\">SchemaHero<\/a><\/noindex> \u2014 Kubernetes'i operaator deklaratiivseks andmebaasi skeemi haldamiseks (gitops andmebaasi skeemide jaoks).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqitchers\/sqitch\">Sqitch<\/a><\/noindex> \u2014 M\u00f5istlik andmebaasi kohandatud muutuste haldamine raamistikuvabas arenduses ja usaldusv\u00e4\u00e4rses juurutamises.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rdagumampan\/yuniql\">yuniql<\/a><\/noindex> \u2014 Veel \u00fcks skeemi versioonimise ja migreerimise t\u00f6\u00f6riist, mis on loodud ainult .NET Core 3.0+ jaoks ja loodetavasti parema kvaliteediga.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-generation-tools\">Koodigeneratsioonit\u00f6\u00f6riistad<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ddl-generator\">ddl-generator<\/a><\/noindex> \u2014 Inffer SQL DDL (Andme Definitsiooni Keel) tabeli andmete p\u00f5hjal.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/qwazer\/scheme2ddl\">scheme2ddl<\/a><\/noindex> \u2014 K\u00e4skude rea utiliit Oracle'i skeemi eksportimiseks ddl algskriptide komplekti, koos v\u00f5imalusega filtreerida soovimatut teavet, eraldada DDL erinevatesse failidesse, ja vormindada v\u00e4ljund ilusaks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"wrappers\">Katted<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dreamfactorysoftware\/dreamfactory\">DreamFactory<\/a><\/noindex> \u2014 Avatud l\u00e4htekoodiga REST API tagaosa mobiilsete, veebip\u00f5histe ja IoT rakenduste jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/graphql-engine\">Hasura GraphQL Engine<\/a><\/noindex> \u2014 \u00c4\u00e4rmiselt kiire, kohene reaalajas GraphQL API Postgrese jaoks, millel on peen juurdep\u00e4\u00e4su kontroll, samuti webhooks'i aktiveerimine andmebaasi s\u00fcndmustel.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/avz\/jl-sql\">jl-sql<\/a><\/noindex> \u2014 SQL JSONi ja CSV voogude jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/EnterpriseDB\/mysql_fdw\">mysql_fdw<\/a><\/noindex> \u2014 PostgreSQLi v\u00e4lise andmebaasi m\u00e4his MySQL jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/rest-data-services\">Oracle REST Data Services<\/a><\/noindex> \u2014 Vahekihti Java rakendus, ORDS seondab HTTP(S) tehteid (GET, POST, PUT, DELETE jne.) andmebaasi tehingutega ja tagastab k\u00f5ik tulemused JSONi kasutades.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prismagraphql\/prisma\">Prisma<\/a><\/noindex> \u2014 Prisma muudab teie andmebaasi reaalajas GraphQL API-ks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgREST\/postgrest\">PostgREST<\/a><\/noindex> \u2014 REST API igasugustele Postgres andmebaasidele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prest\/prest\">prest<\/a><\/noindex> \u2014 Viis, kuidas teenindada RESTful API-d igasugustelt andmebaasidest Go keeles.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/restsql\/restsql\">restSQL<\/a><\/noindex> \u2014 SQL generaator Java ja HTTP API-dega, kasutab lihtsat RESTful HTTP API-d XML v\u00f5i JSON serialiseerimisega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/formio\/resquel\">resquel<\/a><\/noindex> \u2014 Lihtsalt muuda oma SQL andmebaas REST API-ks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jeffknupp\/sandman2\">sandman2<\/a><\/noindex> \u2014 Automaatselt genereerib RESTful API teenuse teie p\u00e4randandmebaasi jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CrocInc\/sql-boot\">sql-boot<\/a><\/noindex> \u2014 T\u00e4iustatud REST ja UI wrapper teie SQL-p\u00e4ringutele.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"backup-tools\">Varundust\u00f6\u00f6riistad<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgbackrest\/pgbackrest\">pgbackrest<\/a><\/noindex> \u2014 Usaldusv\u00e4\u00e4rne PostgreSQL varundus ja taastamine.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndquadrant-it\/barman\">BaRMan<\/a><\/noindex> \u2014 PostgreSQLi varundamise ja taastamise haldur.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"replicationdata-operation\">Replikatsioon \/ andmete toimingud<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/simonw\/datasette\">Datasette<\/a><\/noindex> \u2014 T\u00f6\u00f6riist andmete uurimiseks ja avaldamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/actiontech\/dtle\">dtle<\/a><\/noindex> \u2014 Jaotatud andmete \u00fclekandeteenus MySQL jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgsync\">pgsync<\/a><\/noindex> \u2014 S\u00fcnkroniseerib Postgrese andmeid andmebaaside vahel.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/the4thdoctor\/pg_chameleon\">pg_chameleon<\/a><\/noindex> \u2014 MySQL to PostgreSQL replika s\u00fcsteem, mis on kirjutatud Python 3. See s\u00fcsteem kasutab mysql-replication raamatukogu, et t\u00f5mmata rea pilte MySQL-ist, mis salvestatakse PostgreSQL-isse JSONB vormingus.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/pgdeltastream\">PGDeltaStream<\/a><\/noindex> \u2014 Golangi veebiserver, mis edastab Postgrese muudatusi v\u00e4hemalt kord \u00fcle websocketide, kasutades Postgrese loogilise dekodeerimise omadust.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndQuadrant\/repmgr\">repmgr<\/a><\/noindex> \u2014 K\u00f5ige populaarsem replikeerimise haldur PostgreSQL-i jaoks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"scripts\">Skripti<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgexperts\/pgx_scripts\">pgx_scripts<\/a><\/noindex> \u2014 Kasulikud v\u00e4iksed skriptid andmebaasi anal\u00fc\u00fcsi ja halduse jaoks, loodud PostgreSQL Expertsi meie tiimi poolt.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ioguix\/pgsql-bloat-estimation\">pgsql-bloat-estimation<\/a><\/noindex> \u2014 P\u00e4ringud statistiliste bloatide m\u00f5\u00f5tmiseks PostgreSQLi indeksites ja tabelites.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/depesz\/pgWikiDont\">pgWikiDont<\/a><\/noindex> \u2014 SQL test, mis kontrollib, kas teie andmebaas j\u00e4rgib reegleid <noindex><a rel=\"nofollow\" href=\"https:\/\/wiki.postgresql.org\/wiki\/Don&#039;t_Do_This\">https:\/\/wiki.postgresql.org\/wiki\/Don&#8217;t_Do_This<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dataegret\/pg-utils\">pg-utils<\/a><\/noindex> \u2014 Kasulikud PostgreSQL utiliidid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/postgrescheatsheet.com\">Postgres cheat sheet<\/a><\/noindex> \u2014 Kasulikud SQL-skriptid ja k\u00e4sud &lt;timescale.com&gt; poolt.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/NikolayS\/postgres_dba\">postgres_dba<\/a><\/noindex> \u2014 Puuduv kasulike t\u00f6\u00f6riistade komplekt Postgres DBA-dele ja k\u00f5igile inseneridele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gist.github.com\/rgreenjr\/3637525\">postgres_queries_and_commands.sql<\/a><\/noindex> \u2014 Kasulikud PostgreSQL p\u00e4ringud ja k\u00e4sud.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tanelpoder\/tpt-oracle\">TPT<\/a><\/noindex> \u2014 Need sqlplus skriptid on Oracle andmebaasi j\u00f5udluse optimeerimise ja t\u00f5rkeotsingu jaoks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"monitoringstatisticsperfomance\">J\u00e4lgimine \/ statistika \/ j\u00f5udlus<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/akardapolov\/ASH-Viewer\">ASH Viewer<\/a><\/noindex> \u2014 Pakub graafilist vaadet aktiivse sessiooni ajaloo andmetele Oracle'i ja PostgreSQL DB-s.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/monyog\">Monyog<\/a><\/noindex> \u2014 Agentev ja kuluefektiivne MySQL j\u00e4lgimise t\u00f6\u00f6riist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/mssql-monitoring\">mssql-monitoring<\/a><\/noindex> \u2014 J\u00e4lgi oma SQL Serveri j\u00f5udlust Linuxis, kasutades collectd, InfluxDB ja Grafana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products\/navicat-monitor\">Navicat Monitor<\/a><\/noindex> \u2014 Turvaline, lihtne ja agendivaba kaugserveri j\u00e4lgimise t\u00f6\u00f6riist, mis on t\u00e4idetud v\u00f5imsate funktsioonidega, et muuta teie j\u00e4lgimise v\u00f5imalikult efektiivseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/pmm\">Percona J\u00e4lgimine ja Haldusehaldus<\/a><\/noindex> \u2014 Avatud l\u00e4htekoodiga platvorm MySQL ja MongoDB j\u00f5udluse haldamiseks ja j\u00e4lgimiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pganalyze\/collector\">pganalyze kollektsioneerija<\/a><\/noindex> \u2014 Pganalyze statistika kogumise t\u00f6\u00f6riist PostgreSQLi metrika ja logi andmete kogumiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/postgres-ai\/postgres-checkup\">postgres-checkup<\/a><\/noindex> \u2014 Uue p\u00f5lvkonna diagnostikavahend, mis v\u00f5imaldab kasutajatel Postgresi andmebaaside tervise s\u00fcvitsi anal\u00fc\u00fcsi teha.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/wrouesnel\/postgres_exporter\">postgres_exporter<\/a><\/noindex> \u2014 Prometheuse eksportija PostgreSQLi serveri metrika jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgdash.io\">pgDash<\/a><\/noindex> \u2014 M\u00f5\u00f5dab ja j\u00e4lgib iga aspekti sinu PostgreSQLi andmebaasidest.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pghero\">PgHero<\/a><\/noindex> \u2014 Postgresi j\u00f5udluse juhtpaneel \u2014 tervise kontrollid, soovitatavad indeksid ja palju muud.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rapidloop\/pgmetrics\">pgmetrics<\/a><\/noindex> \u2014 Kogub ja kuvab teavet ning statistikat t\u00f6\u00f6tavast PostgreSQLi serverist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgmustard.com\">pgMustard<\/a><\/noindex> \u2014 Kasutajaliides Postgresi selgitusplaanide jaoks, pluss n\u00e4pun\u00e4idete andmine j\u00f5udluse parandamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gleu\/pgstats\">pgstats<\/a><\/noindex> \u2014 Kogub PostgreSQLi statistikat, salvestades need kas CSV-failidesse v\u00f5i kuvades stdout-s.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cybertec-postgresql\/pgwatch2\">pgwatch2<\/a><\/noindex> \u2014 Paindlik iseseisev PostgreSQLi metrika j\u00e4lgimise\/juhtpaneeli lahendus.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/influxdata\/telegraf\/tree\/master\/plugins\/inputs\/postgresql\">Telegraf PostgreSQLi pistikprogramm<\/a><\/noindex> \u2014 Pakub metrikaid sinu postgres andmebaasi jaoks.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"zabbix\">Zabbix<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">Mamonsu<\/a><\/noindex> \u2014 PostgreSQLi j\u00e4lgimisagent.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.smartmarmot.com\/wiki\/index.php?title=Orabbix\">Orabbix<\/a><\/noindex> \u2014 Orabbix on pistikprogramm, mis on kavandatud toimima Zabbix Enterprise Monitoriga, et pakkuda mitmekihilist j\u00e4lgimist, j\u00f5udluse ja k\u00e4ttesaadavuse raportite ning m\u00f5\u00f5tmise jaoks Oracle andmebaasidele, koos serveri j\u00f5udluse metrikatega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pg-monz\/pg_monz\">pg_monz<\/a><\/noindex> \u2014 See on Zabbixi j\u00e4lgimismall PostgreSQLi andmebaasi jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/bicofino\/Pyora\">Pyora<\/a><\/noindex> \u2014 Pythoni skript Oracle andmebaaside j\u00e4lgimiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/anetrusov\/ZabbixDBA\">ZabbixDBA<\/a><\/noindex> \u2014 ZabbixDBA on kiire, paindlik ja pidevalt arenev pistikprogramm sinu RDBMS-i j\u00e4lgimiseks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"testing\">Testimine<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbfit\/dbfit\">DbFit<\/a><\/noindex> \u2014 Andmebaaside katsetamise raamistik, mis toetab sinu andmebaasikoodi lihtsat testip\u00f5hist arendamist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dimitri\/regresql\">RegreSQL<\/a><\/noindex> \u2014 SQL p\u00e4ringute regressioonitestimine.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"data-generator\">Andmete genereerimine<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/benerator\">Databene Benerator<\/a><\/noindex> \u2014 See on raamistik, mis genereerib sinu testitavale s\u00fcsteemile reaalset ja valideeritud k\u00f5rge mahuga testandmeid (v\u00e4ldib Datalite antipatterni).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/data-generator\">dbForge Data Generator for MySQL<\/a><\/noindex> \u2014 Tugev GUI-t\u00f6\u00f6riist, mis loob tohutul hulgal realistlikku testandmeid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/data-generator\">dbForge Data Generator for Oracle<\/a><\/noindex> \u2014 V\u00e4ike, kuid v\u00f5imas GUI-t\u00f6\u00f6riist, mis t\u00e4idab Oracle'i skeeme tohutu hulga realistliku testandmega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/sql\/data-generator\">dbForge Data Generator for SQL Server<\/a><\/noindex> \u2014 Tugev GUI-t\u00f6\u00f6riist andmebaaside m\u00f5istlike testandmete kiireks genereerimiseks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"administration\">Haldamine<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dalibo\/pgbadger\">pgbadger<\/a><\/noindex> \u2014 Kiire PostgreSQL logi anal\u00fcsaator.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Squarespace\/pgbedrock\">pgbedrock<\/a><\/noindex> \u2014 Manage a Postgres cluster&#8217;s roles, role memberships, schema ownership, and privileges.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgslice\">pgslice<\/a><\/noindex> \u2014 Postgresi partitsioneerimine sama lihtne kui pirukas.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"hafailoversharding\">HA \/ failover \/ sharding<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/citus\">Citus<\/a><\/noindex> \u2014 Postgresi laiendus, mis jaotab sinu andmed ja p\u00e4ringud mitme s\u00f5lme vahel.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/patroni\">patroni<\/a><\/noindex> \u2014 Mall PostgreSQL k\u00f5rge k\u00e4ttesaadavuse jaoks koos ZooKeeperi, etcd v\u00f5i Consuliga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/percona-xtradb-cluster\">Percona XtraDB Cluster<\/a><\/noindex> \u2014 K\u00f5rge skaleeritavuse lahendus MySQLi klastreerimiseks ja k\u00f5rge k\u00e4ttesaadavuse saavutamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sorintlab\/stolon\">stolon<\/a><\/noindex> \u2014 Pilvep\u00f5hine PostgreSQLi juhtimislahendus PostgreSQLi k\u00f5rge k\u00e4ttesaadavuse jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/pg_auto_failover\">pg_auto_failover<\/a><\/noindex> \u2014 Postgresi laiendus ja teenus automaatseks v\u00f5tmete vahetamiseks ja k\u00f5rge k\u00e4ttesaadavuse tagamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/aiven\/pglookout\">pglookout<\/a><\/noindex> \u2014 PostgreSQLi replikeerimise j\u00e4lgimise ja juhusliku programmi daemon.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClusterLabs\/PAF\">PostgreSQL Automaatne V\u00f5tmete Vahetus<\/a><\/noindex> \u2014 K\u00f5rge k\u00e4ttesaadavus Postgresi jaoks, tuginedes t\u00f6\u00f6stuse viidetele Pacemaker ja Corosync.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitabaks\/postgresql_cluster\">postgresql_cluster<\/a><\/noindex> \u2014 PostgreSQL High-Availability Cluster (based on &quot;Patroni&quot; and &quot;DCS(etcd)&quot;). Automating deployment with Ansible.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitessio\/vitess\">Vitess<\/a><\/noindex> \u2014 Andmebaasi klastreerimise s\u00fcsteem MySQLi horisontaalse skaleerimise jaoks \u00fcldistatud jagamise kaudu.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"kubernetes\">Kubernetes<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/kubedb.com\">KubeDB<\/a><\/noindex> \u2014 Muutes tootmisstandardiga andmebaaside k\u00e4itamise Kubernetesel lihtsaks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/postgres-operator\">Postgres operaatore<\/a><\/noindex> \u2014 Postgresi operaator v\u00f5imaldab k\u00f5rge k\u00e4ttesaadavusega PostgreSQLi klastri seadistamist Kubernetesel (K8s), mida toetab Patroni.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/spilo\">Spilo<\/a><\/noindex> \u2014 HA PostgreSQLi klastrid Dockeris.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/ongresinc\/stackgres\">StackGres<\/a><\/noindex> \u2014 Ettev\u00f5tte tasemel, t\u00e4iskomplektne PostgreSQL Kubernetesel.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"configuration-tuning\">Seadistuse timmimine<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/major\/MySQLTuner-perl\">MySQLTuner-perl<\/a><\/noindex> \u2014 Perl'is kirjutatud skript, mis v\u00f5imaldab sul kiirelt \u00fcle vaadata MySQLi installatsiooni ja teha muudatusi j\u00f5udluse ja stabiilsuse suurendamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgconfigurator.cybertec-postgresql.com\">PGConfigurator<\/a><\/noindex> \u2014 Tasuta veebit\u00f6\u00f6riist optimeeritud genereerimiseks <code>postgresql.conf<\/code>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gregs1104\/pgtune\">pgtune<\/a><\/noindex> \u2014 PostgreSQLi konfigureerimise juhend.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jfcoz\/postgresqltuner\">postgresqltuner.pl<\/a><\/noindex> \u2014 Lihtne skript sinu PostgreSQL andmebaasi konfiguratsiooni anal\u00fc\u00fcsimiseks ja h\u00e4\u00e4lestusn\u00f5uannete andmiseks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"devops\">DevOps<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dbmaestro.com\">DBmaestro<\/a><\/noindex> \u2014 DBmaestro kiirendab vabastamise ts\u00fckleid ja toetab agiilsust kogu IT-\u00f6kos\u00fcsteemis.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/products\/toad-devops-toolkit\/\">Toad DevOps Toolkit<\/a><\/noindex> \u2014 Toad DevOps Toolkit teostab olulisi andmebaasi arenduse funktsioone teie DevOps t\u00f6\u00f6voos \u2014 kvaliteeti, j\u00f5udlust v\u00f5i usaldusv\u00e4\u00e4rsust ohverdamata.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"schema-samples\">Skeemi n\u00e4idised<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/oracle\/db-sample-schemas\">Oracle Database Sample Schemas<\/a><\/noindex> \u2014 Oracle Database Sample Schemas.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"reporting\">Aruandlus<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/shzlw\/poli\">Poli<\/a><\/noindex> \u2014 Lihtne SQL-i raportite rakendus, mis on loodud SQL-i armastajate jaoks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"distributions\">Jaotused<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/datacharmer\/dbdeployer\">DBdeployer<\/a><\/noindex> \u2014 T\u00f6\u00f6riist, mis lihtsustab MySQL andmebaasi serverite juurutamist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlcollaborative\/dbatools\">dbatools<\/a><\/noindex> \u2014 PowerShelli moodul, mida v\u00f5ite m\u00f5elda kui k\u00e4surea SQL Serveri haldusportaalina.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgresApp\/PostgresApp\">Postgres.app<\/a><\/noindex> \u2014 T\u00e4isfunktsionaalne PostgreSQL-i installatsioon, pakitud standardse Maci rakendusena.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\">BigSQL<\/a><\/noindex> \u2014 Arendajas\u00f5bralik PostgreSQL jaotamine.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/credativ\/elephant-shed\">Elephant Shed<\/a><\/noindex> \u2014 Veebip\u00f5hine PostgreSQL-i haldustarkvara, mis sisaldab mitmeid utiliite ja rakendusi PostgreSQL-i kasutamiseks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"security\">Turve<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cossacklabs\/acra\">Acra<\/a><\/noindex> \u2014 Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side (&quot;transparent&quot;) encryption. SQL, NoSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-formatters\">Koodi vormindajad<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/antlr\/codebuff\">CodeBuff<\/a><\/noindex> \u2014 Keele\u00fcksusest s\u00f5ltumatud kauni vormindamise v\u00f5imalused masin\u00f5ppe abil.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"contributing\">Contributing<\/h2>\n<p><\/p>\n<ul>\n<li>Teie panus on alati teretulnud! Palun lugege <noindex><a rel=\"nofollow\" href=\"http:\/\/contributing.md\">panustamisjuhiseid<\/a><\/noindex> esiteks.<\/li>\n<\/ul>\n<p><\/p>\n<p>\u0415\u0441\u0442\u044c \u043d\u0430\u0445\u043e\u0434\u043a\u0438 \u0434\u043b\u044f \u0411\u0414 \u2014 \u0434\u0435\u043b\u0438\u0442\u0435\u0441\u044c. \u0422\u0430\u043a\u0436\u0435 \u0431\u0443\u0434\u0443 \u0440\u0430\u0434 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u043e\u0431\u0440\u0430\u0442\u043d\u0443\u044e \u0441\u0432\u044f\u0437\u044c \u2014 PR&#8217;\u044b \u0438 \u0437\u0432\u0435\u0437\u0434\u043e\u0447\u043a\u0438. \u041e\u0441\u0442\u0430\u043b\u0438\u0441\u044c \u0432\u043e\u043f\u0440\u043e\u0441\u044b \u043f\u043e \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044e \u0441\u0432\u043e\u0438\u0445 \u043b\u0438\u0441\u0442\u043e\u0432 \u2014 \u0442\u043e\u0436\u0435 \u043f\u0438\u0448\u0438\u0442\u0435.<\/p>\n<p>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/croc\/blog\/496594\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041d\u0430\u0432\u0435\u0440\u043d\u043e\u0435, \u0443 \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u0438\u0437 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c \u0442\u0430\u043a\u043e\u0439 \u0444\u0430\u0439\u043b\u0438\u043a, \u043a\u0443\u0434\u0430 \u043c\u044b \u043f\u0440\u0438\u043f\u0440\u044f\u0442\u044b\u0432\u0430\u0435\u043c \u0447\u0442\u043e-\u0442\u043e \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0435 \u0438 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e\u0435 \u0434\u043b\u044f \u0441\u0435\u0431\u044f. \u041a\u0430\u043a\u0438\u0435-\u0442\u043e \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u0441\u0442\u0430\u0442\u044c\u0438, \u043a\u043d\u0438\u0433\u0438, \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0438, \u043c\u0430\u043d\u0443\u0430\u043b\u044b. \u042d\u0442\u043e \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u0437\u0430\u043a\u043b\u0430\u0434\u043a\u0438 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u0438\u043b\u0438 \u0434\u0430\u0436\u0435 \u043f\u0440\u043e\u0441\u0442\u043e \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0435 \u0432\u043a\u043b\u0430\u0434\u043a\u0438, \u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u0430 \u043f\u043e\u0442\u043e\u043c. \u0421\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c \u0432\u0441\u0435 \u044d\u0442\u043e \u0440\u0430\u0437\u0431\u0443\u0445\u0430\u0435\u0442, \u0441\u0441\u044b\u043b\u043a\u0438 \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u044e\u0442 \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0442\u044c\u0441\u044f, \u0430 \u0431\u043e\u043b\u044c\u0448\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u043e\u0432 \u043f\u0440\u043e\u0441\u0442\u043e \u0443\u0441\u0442\u0430\u0440\u0435\u0432\u0430\u0435\u0442. \u0410 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":93090,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-93089","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47Awesome-\u043b\u0438\u0441\u0442 \u0441\u0432\u043e\u0438\u043c\u0438 \u0440\u0443\u043a\u0430\u043c\u0438, \u0438\u043b\u0438 GitHub \u0432\u043c\u0435\u0441\u0442\u043e \u0431\u043b\u043e\u043a\u043d\u043e\u0442\u0430 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-09-02T23:42:16+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-02T23:42:16+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47\u00c4ge nimekiri oma k\u00e4tega, v\u00f5i GitHub asemel m\u00e4rkmik | ProHoster","description":"Tere, Habr!","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47Awesome-\u043b\u0438\u0441\u0442 \u0441\u0432\u043e\u0438\u043c\u0438 \u0440\u0443\u043a\u0430\u043c\u0438, \u0438\u043b\u0438 GitHub \u0432\u043c\u0435\u0441\u0442\u043e \u0431\u043b\u043e\u043a\u043d\u043e\u0442\u0430 | ProHoster","og:description":"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-09-02T23:42:16+00:00","article:modified_time":"2020-09-02T23:42:16+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"93089","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 11:55:35","updated":"2022-09-28 06:26:02","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/93089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=93089"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/93089\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/93090"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=93089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=93089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=93089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}