{"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\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"K\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" src=\"\/wp-content\/uploads\/2020\/09\/41d7ca428261b80f365797a19c547000.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tere, Habr! T\u00f5en\u00e4oliselt on meil k\u00f5igil olemas fail, kuhu peidame midagi kasulikku ja huvitavat. Need v\u00f5ivad olla lingid artiklitele, raamatutele, repositooriumitele, juhenditele. Need v\u00f5ivad olla j\u00e4rjehoidjad brauseris v\u00f5i isegi lihtsalt avatud vahekaartidel, mis on j\u00e4etud hilisemaks. Aja jooksul k\u00f5ik see paisub, lingid lakavad t\u00f6\u00f6tamast ja suur osa materjalidest muutub lihtsalt vananenuks. <\/p>\n<p><\/p>\n<p>Mis oleks, kui jagada seda headust kogukonnaga ja laadida see fail GitHubi? Siis v\u00f5ivad teie pingutused olla kasulikud ka kellegile teisele ning hoidke sisu ajakohasena koos, saades uuendusi soovijatelt vanade head PR-de kaudu. Just selleks on see projekt m\u00f5eldud. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">Aja listid<\/a><\/noindex>. See on GitHubi TOP-10 repositooriumi hulgas, omab 138K t\u00e4hte ja teie t\u00f6\u00f6de link v\u00f5ib sattuda otse tema juurkatalooge README\u2019sse, mis t\u00f5mbab teie loomingule tohutu publiku. Siiski, selleks tuleb natuke vaeva n\u00e4ha. Jagada oma kogemusi selliste pingutuste kohta tahan teile. <\/p>\n<p><\/p>\n<p>Minu nimi on Maxim Gramin. KROKis teen Java-arendust ja uurimusi andmebaaside alal. Selles postituses r\u00e4\u00e4gin, mis on Awesome Lists ja kuidas luua oma t\u00f5eline ametlik awesome-repos.<\/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 pean tutvuma uue tehnoloogia v\u00f5i programmeerimiskeelega, siis esimene koht, kuhu l\u00e4hen, on just see \u2014 leian vajaliku sektsiooni ja seal sobivad loendid. Ja arvestades t\u00e4htede arvu ja nende pidevat kasvu, ei tee seda ainult mina.<br \/>\n<img decoding=\"async\" alt=\"K\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" src=\"\/wp-content\/uploads\/2020\/09\/383d1f4d5126fe2a11d449cf5e83b576.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tegelikult on see tavaline lihtne readme.md, mis elab eraldi <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">repositoriis<\/a><\/noindex>, olles samas 8. kohal k\u00f5igi GitHubi hoidlate seas ja sisaldades linke teistele lehtedele, mis k\u00e4sitlevad mingit teemat. N\u00e4iteks sektsioonis Programming Languages leiate lehti Awesome Python ja Awesome Go, ning Front-End Development osas on tohutult ressursse veebiarenduse kohta. Ja muidugi, \u2014 sektsioon <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome#databases\">Andmebaasid<\/a><\/noindex> (tagasi j\u00f5uame selle juurde natuke hiljem). Ja jah, see k\u00f5ik ei piirdu ainult tehniliste teemadega. N\u00e4iteks sektsioonides Meelelahutus ja M\u00e4ngud v\u00f5ib samuti leida palju huvitavat (mulle endale meeldis <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/RichardLitt\/awesome-fantasy\">awesome-fantasy<\/a><\/noindex>).<br \/>\nPeamine omadus on see, et k\u00f5ik need nimekirjad ei ole koostatud autori poolt isiklikult, vaid kogukonna poolt ning need on koostatud vastavalt erilise ja v\u00e4ga range <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/blob\/main\/awesome.md\">awesome manifesto<\/a><\/noindex>. Iga selline leht on iseseisev spetsialistide kogukond, elab oma elu ja on avatud teie pull request'ide jaoks, mis teevad selle veelgi paremaks. Samuti v\u00f5ib iga soovija luua oma lehe, kui m\u00f5ni teema pole veel kajastatud.<\/p>\n<p><\/p>\n<p>Selle idee autor ja kogu selle asja koordinaator on legendaarne Sindre Sorhus, <noindex><a rel=\"nofollow\" href=\"https:\/\/gitstar-ranking.com\/users\">esimene inimene GitHubis<\/a><\/noindex>, rohkem kui <noindex><a rel=\"nofollow\" href=\"https:\/\/www.npmjs.com\/~sindresorhus\">1000 npm-mooduli<\/a><\/noindex>, ja just tema v\u00f5tab vastu teie PR-id.<br \/>\n<img decoding=\"async\" alt=\"K\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" 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 saada awesome-list'i<\/h2>\n<p><\/p>\n<p>Kui te ei leidnud sobivat nimekirja teile huvipakkuva teema kohta, siis on see esimene m\u00e4rk sellest, et tuleb see ise teha!<\/p>\n<p><\/p>\n<p>R\u00e4\u00e4gin oma lastest <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools<\/a><\/noindex> \u2014 Erinevates projektides olen pidanud t\u00f6\u00f6tama erinevate andmebaasidega ja seet\u00f5ttu olen loonud sellise faili, kuhu kogusin kasulikke t\u00f6\u00f6riistu nende haldamiseks, erinevad andmebaasi migraatorid, IDE-d, halduspaneelid, j\u00e4lgimise t\u00f6\u00f6riistad ja muud sellist. T\u00f6\u00f6riistad, mida olen juba kasutanud v\u00f5i alles kavatsemas hakata kasutama. Jagasin seda faili kolleegidega KROKi sees ja v\u00e4ljaspool. See aitas paljusid ja oli huvitav. L\u00f5puks tahtsin suuremat tunnustust, kui m\u00e4rkasin, et Databases jaotises puudus selle teema puhul nimekiri. Otsustasin sellele oma nimekirja lisada. <\/p>\n<p><\/p>\n<p><strong>Mida selleks vajate?<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>Registreerime tavalise GitHub-i repo nimega awesome- midagi. Minu puhul oli see awesome-database-tools.<\/li>\n<li>Viime oma nimekirja awesome formaati, selles 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 \u00f5iges 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>Teeme \u00fclevaate v\u00e4hemalt 2 teise PR-ist<\/li>\n<li>Ja l\u00f5puks teeme PR peamine repo, kuhu lisame lingi oma repo. Siin tuleb k\u00f5ik hoolikalt l\u00e4bi lugeda ja t\u00e4ita k\u00f5ik paljude n\u00f5udmistega uue lehe ja PR-i kohta.<\/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\u00f5nnestumine<\/a><\/noindex><br \/>\n<img decoding=\"async\" alt=\"K\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" src=\"\/wp-content\/uploads\/2020\/09\/196dd3f494d5e91eaa7af49e16f74393.jpeg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nAga p\u00e4rast natuke aega kogusin veel rohkem materjali, t\u00f6\u00f6tasin vigade kallal ja julgesin teha <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 \u00f5rnalt vihjati:<br \/>\n<img decoding=\"async\" alt=\"K\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" src=\"\/wp-content\/uploads\/2020\/09\/0ec0a33b3c7bb15b6cce6bf076208f09.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Olin liiga t\u00e4helepanematu ja ei lisanud \u00fckssarvikut, et kinnitada, et k\u00f5ik tingimused on t\u00e4idetud<br \/>\n<img decoding=\"async\" alt=\"K\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" 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 veidi aega, veel veidi parandusi m\u00e4rkuste p\u00f5hjal ja ilmnes kauaoodatud <noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/awesome__re\/status\/1246779641475424256\">tweet<\/a><\/noindex>, et minu PR oli vastu v\u00f5etud.<\/p>\n<p><\/p>\n<p>Nii sain ma oma esimese lehe autoriks ja hakkasin saama <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools\/pulls?q=is%3Apr+is%3Aclosed\">PR-id<\/a><\/noindex> kogukonnalt uute t\u00f6\u00f6riistade lisamiseks. Ja paljud neist on juba lisatud <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools<\/a><\/noindex>. Kui on laisk minna lingile, <\/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\u00e4sitsi koostatud Awesome-nimekiri v\u00f5i GitHub asemel m\u00e4rkmik.\" src=\"\/wp-content\/uploads\/2020\/09\/2951c443e95e3c56f93fb685afed6115.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/h1>\n<p><\/p>\n<blockquote><p>Kogukonna loodud andmebaasi t\u00f6\u00f6riistade loend<\/p><\/blockquote>\n<p>Siin kogume teavet h\u00e4mmastavate kasulike ning eksperimentaalsete t\u00f6\u00f6riistade kohta, mis lihtsustavad andmebaasidega t\u00f6\u00f6tamist DBA-dele, DevOpsile, arendajatele ja tavalistele inimestele.<\/p>\n<p><\/p>\n<p>\u00c4rge kartke lisada teavet oma andmebaasi t\u00f6\u00f6riistade v\u00f5i oma lemmik kolmandate osapoolte andmebaasi t\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 haldajad\/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\">DB-skeemi navigeerimine ja visualiseerimine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#modelers\">Modelleerijad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#migration-tools\">Migratsioonit\u00f6\u00f6riistad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-generation-tools\">Koodi genereerimise t\u00f6\u00f6riistad<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#wrappers\">M\u00e4hised<\/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\/andmeoperatsioon<\/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\/Tulemused<\/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 generaator<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#administration\">Administratsioon<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#hafailoversharding\">HA\/Failover\/Jagamine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#kubernetes\">Kubernetes<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#configuration-tuning\">Seadistamise h\u00e4\u00e4lestamine<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#devops\">DevOps<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#schema-samples\">Schema 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\">Turvalisus<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-formatters\">Koodi formateerijad<\/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 Esmaklassiline mitmekesine 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 20+ andmebaasi.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jetbrains.com\/datagrip\">DataGrip<\/a><\/noindex> \u2014 Platvormidevaheline IDE andmebaaside ja SQL jaoks JetBrains'ilt.<\/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 \u00dcksk\u00f5ik milline IDE MySQL ja MariaDB andmebaasi arendamiseks, haldamiseks ja haldamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/studio\">dbForge Studio for Oracle<\/a><\/noindex> \u2014 V\u00f5imas IDE Oracle'i haldamiseks, haldamiseks 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 V\u00f5imas arenduskeskkond SQL Serveri arendamiseks, haldamiseks, haldamiseks, andmete anal\u00fc\u00fcsimiseks 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. See sisaldab arendamise, haldamise ja j\u00f5udluse h\u00e4\u00e4lestamise toetamiseks m\u00f5eldud funktsioone.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.ibexpert.net\/ibe\">IBExpert<\/a><\/noindex> \u2014 K\u00f5ikeh\u00f5lmav GUI t\u00f6\u00f6riist Firebirdi ja InterBase'i 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 Delphiga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mysql.com\/products\/workbench\">MySQL Workbench<\/a><\/noindex> \u2014 MySQL Workbench on \u00fchtne visuaalne t\u00f6\u00f6riist andmebaasi arhitektide, arendajate ja DBA-de jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products#navicat\">Navicat<\/a><\/noindex> \u2014 Andmebaasi arendamise t\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 pilvearendustes.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgadmin.org\">pgAdmin<\/a><\/noindex> \u2014 K\u00f5ige populaarsem ja funktsionaalsem avatud l\u00e4htekoodiga haldus- ja arendusplatvorm PostgreSQL jaoks, mis on maailma k\u00f5ige arenenum avatud l\u00e4htekoodiga andmebaas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\/pgadmin3\">pgAdmin3<\/a><\/noindex> \u2014 pikaajaline toetus pgAdmin3-le.<\/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 spetsiaalselt suunatud salvestatud programmide arendamisele Oracle 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 haldus-, administratsiooni- 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. Hallake keerulisi andmebaasi muutusi \u00fche andmebaasi haldust\u00f6\u00f6riista abil.<\/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\u2019i, 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 Looge, haldage, p\u00e4rige ja uurige Valentina DB, MySQL, MariaDB, PostgreSQL ja SQLite andmebaase TASUTA.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"gui-managersclients\">GUI haldajad\/kliendid<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vrana\/adminer\">Adminer<\/a><\/noindex> \u2014 Andmebaasi haldamine \u00fches PHP-failis.<\/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 ops UI, et jooksutada p\u00e4ringuid, j\u00e4lgida ClickHouse'i olekut ja teha palju muid asju.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jackdb.com\">JackDB<\/a><\/noindex> \u2014 Otsene SQL-juurdep\u00e4\u00e4s k\u00f5igile teie 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 sirvija PostgreSQL jaoks, kirjutatud Go-s ja t\u00f6\u00f6tavad 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, mis on kirjutatud PHP-s ja 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 lihtsat ja selget liidest, et kiiresti teha tavalisi PostgreSQL\u2019i \u00fclesandeid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/popsql.com\">PopSQL<\/a><\/noindex> \u2014 Kaasaegne, koost\u00f6\u00f6p\u00f5hine 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 (endine Robomongo) on shell- keskne ristplatvormi MongoDB 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 lihtsasti kasutatav andmebaasi haldust\u00f6\u00f6riist MySQL ja MariaDB andmebaasidega t\u00f6\u00f6tamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\">SQL Operations Studio<\/a><\/noindex> \u2014 Andmehalduse t\u00f6\u00f6riist, mis v\u00f5imaldab t\u00f6\u00f6tada SQL Serveri, Azure SQL DB ja SQL DW-ga Windowsi, macOS-i ja Linuxi platvormidel.<\/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, mida kasutatakse teie enda privaatpilves.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.macpostgresclient.com\">SQLPro<\/a><\/noindex> \u2014 Lihtne ja v\u00f5imas Postgresi haldur macOS-ile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/squirrel-sql\">SQuirreL<\/a><\/noindex> \u2014 Graafiline SQL klient, mis on kirjutatud Java-s ja v\u00f5imaldab vaadata JDBC-ga \u00fchilduva andmebaasi struktuuri, sirvida tabelite andmeid, k\u00e4ivitada SQL k\u00e4ske jne.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mtxr\/vscode-sqltools\">SQLTools<\/a><\/noindex> \u2014 Andmebaasi haldus VSCode'ile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/sqlyog\">SQLyog<\/a><\/noindex> \u2014 K\u00f5ige t\u00e4ielikum ja kasutajas\u00f5bralikum MySQL GUI.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tabixio\/tabix\">Tabix<\/a><\/noindex> \u2014 SQL redaktor ja avatud allika lihtne \u00e4rianal\u00fc\u00fcs Clickhouse'ile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/TablePlus\/TablePlus\">TablePlus<\/a><\/noindex> \u2014 Kaasaegne, kohalikke ja s\u00f5bralik GUI t\u00f6\u00f6riist relatiivsete andmebaaside jaoks: MySQL, PostgreSQL, SQLite jne.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.teampostgresql.com\">TeamPostgreSQL<\/a><\/noindex> \u2014 PostgreSQL veebihaldust\u00f6\u00f6riist \u2014 kasutage oma PostgreSQL andmebaase \u00fchestkust, koos rikkaliku, kiiresti t\u00f6\u00f6tlus AJAX veebiliidestega.<\/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 Andmebaasiga \u00fchendamine SQL k\u00e4skude esitamist IPythonis v\u00f5i IPython Notebookis.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/laixintao\/iredis\">iredis<\/a><\/noindex> \u2014 Redis-i CLI koos automaatse t\u00e4itmise ja s\u00fcntaksv\u00e4rvusega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/lesovsky\/pgcenter\">pgcenter<\/a><\/noindex> \u2014 PostgreSQL-i haldust\u00f6\u00f6riist sarnane Top-le.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/julmon\/pg_activity\">pg_activity<\/a><\/noindex> \u2014 PostgreSQL serveri tegevuse j\u00e4lgimiseks m\u00f5eldud rakendus, mis sarnaneb Top-ile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/markwkm\/pg_top\">pg_top<\/a><\/noindex> \u2014 'top' PostgreSQL-i jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/okbob\/pspg\">pspg<\/a><\/noindex> \u2014 Postgres 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 Developer Command Line (SQLcl) on tasuta k\u00e4surealiides Oracle andmebaasi jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql\">usql<\/a><\/noindex> \u2014 \u00dcksikasjalik k\u00e4surealiides PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Serveri ja paljude teiste andmebaaside jaoks, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql#database-support\">sealhulgas NoSQL ja mitte-relatiivsed andmebaasid!<\/a><\/noindex> sealdes NoSQL ja mitte-suhteandmebaasid!<\/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 toetab automaatset t\u00e4itmist ja s\u00fcntaksv\u00e4rvumist.<\/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\u00fcntaksv\u00e4rvusega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mssql-cli\">mssql-cli<\/a><\/noindex> \u2014 K\u00e4surealiides SQL Serveri jaoks automaatse t\u00e4itmise ja s\u00fcntaksv\u00e4rvusega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mycli\">mycli<\/a><\/noindex> \u2014 MySQL jaoks terminali klient automaatse t\u00e4iendamise ja s\u00fcntaksi esilet\u00f5stmisega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/pgcli\">pgcli<\/a><\/noindex> \u2014 Postgres CLI automaatse t\u00e4iendamise ja s\u00fcntaksi esilet\u00f5stmisega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/vcli\">vcli<\/a><\/noindex> \u2014 Vertica CLI automaatse t\u00e4iendamise ja s\u00fcntaksi esilet\u00f5stmisega.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"db-schema-navigation-and-visualization\">DB-skeemi 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 joonistada andmebaasi seoseid ja vooge kiiresti, kasutades lihtsat DSL keelt.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Alexis-benoist\/eralchemy\">ERAlchemy<\/a><\/noindex> \u2014 Entiteedi suhete 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 Generoi oma andmebaasi HTML-dokumendiks, 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 keeles.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"modelers\">Modelleerijad<\/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 V\u00f5imas ja taskukohane andmebaasi kujundamise t\u00f6\u00f6riist, mis aitab teil luua kvaliteetseid kontseptuaalseid, 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 andmemudelite \u00fclesandeid.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgmodeler\/pgmodeler\">pgmodeler<\/a><\/noindex> \u2014 Andmemudelite t\u00f6\u00f6riist, mis on m\u00f5eldud PostgreSQL jaoks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"migration-tools\">Migratsioonit\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 konfiguratsiooni kui koodi t\u00f6\u00f6riist, mis kasutab idempotentsete DDL skriptide kontseptsiooni.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/flyway\/flyway\">flyway<\/a><\/noindex> \u2014 Andmebaasi r\u00e4nde t\u00f6\u00f6riist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/github\/gh-ost\">gh-ost<\/a><\/noindex> \u2014 Veebip\u00f5hine skeemi r\u00e4nde t\u00f6\u00f6riist MySQL 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, aga 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 r\u00e4nde haldus, mis on loodud eksklusiivselt PostgreSQL jaoks. (Kuid saab kasutada ka teiste SQL-standardi j\u00e4rgi vastavates andmebaasides \u2014 nt 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-is.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemahero\/schemahero\">SchemaHero<\/a><\/noindex> \u2014 Kubernetes\u2019i operaator deklaratiivse 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 kohane muudatuste 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 r\u00e4nde t\u00f6\u00f6riist, valmistatud puhtalt .NET Core 3.0+ jaoks ja loodetavasti parem.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-generation-tools\">Koodi genereerimise t\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 Tulet SQL DDL-i (Andmete M\u00e4\u00e4ratlemise Keel) tabeli andmetest.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/qwazer\/scheme2ddl\">scheme2ddl<\/a><\/noindex> \u2014 K\u00e4skude rida utiliit Oracle skeemi eksportimiseks DDL algs\u00fcsteemide komplekti, mis suudab filtreerida soovimatut teavet, eraldada DDL erinevatesse failidesse, vormindada v\u00e4ljundit kenasti.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"wrappers\">M\u00e4hised<\/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 mobiili-, veeb- ja IoT rakenduste jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/graphql-engine\">Hasura GraphQL Engine<\/a><\/noindex> \u2014 \u00dclikiired, kohesed reaalaja GraphQL API-d Postgres'is, mis pakuvad peenelt reguleeritud juurdep\u00e4\u00e4su kontrolli ja k\u00e4ivitavad ka veebip\u00f5hised v\u00e4likutsed andmebaasi s\u00fcndmustel.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/avz\/jl-sql\">jl-sql<\/a><\/noindex> \u2014 SQL JSON 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\u00e4lisandmete wrapper MySQL-i 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 Kesktaseme Java rakendus, ORDS kaardistab HTTP(S) verbid (GET, POST, PUT, DELETE jne) andmebaasi toimingutele ja tagastab tulemused, mis on vormindatud JSON-is.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prismagraphql\/prisma\">Prisma<\/a><\/noindex> \u2014 Prisma muudab teie andmebaasi reaalaja GraphQL API-ks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgREST\/postgrest\">PostgREST<\/a><\/noindex> \u2014 REST API igale Postgres andmebaasile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prest\/prest\">prest<\/a><\/noindex> \u2014 On viis teenindada RESTful API-d mis tahes andmebaasidest, mis on kirjutatud 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-i v\u00f5i JSONi serialiseerimisega.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/formio\/resquel\">resquel<\/a><\/noindex> \u2014 Lihtsalt teisendage oma SQL andmebaas REST API-ks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jeffknupp\/sandman2\">sandman2<\/a><\/noindex> \u2014 Automaatne RESTful API teenuse genereerimine 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\u00e4ringute jaoks.<\/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 varukoopia 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\/andmeoperatsioon<\/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-ile.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgsync\">pgsync<\/a><\/noindex> \u2014 Postgres andmete s\u00fcnkroniseerimine andmebaaside vahel.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/the4thdoctor\/pg_chameleon\">pg_chameleon<\/a><\/noindex> \u2014 MySQL-i ja PostgreSQL-i replika s\u00fcsteem, mis on kirjutatud Python 3-s. S\u00fcsteem kasutab raamatukogu mysql-replication, et t\u00f5mmata ridade pilte MySQL-ist, mis salvestatakse PostgreSQL-i kui JSONB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/pgdeltastream\">PGDeltaStream<\/a><\/noindex> \u2014 Golangi veebiserver Postgres muutuste voogesitamiseks v\u00e4hemalt korra \u00fcle websocketide, kasutades Postgresi loomuliku dekodeerimise omadust.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndQuadrant\/repmgr\">repmgr<\/a><\/noindex> \u2014 K\u00f5ige populaarsem replikatsiooni haldur PostgreSQL-is.<\/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 Kasutamiseks m\u00f5eldud kasulikud skriptid andmebaasi anal\u00fc\u00fcsi ja haldamise jaoks, loodud meie meeskonna poolt PostgreSQL ekspertide seas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ioguix\/pgsql-bloat-estimation\">pgsql-bloat-estimation<\/a><\/noindex> \u2014 K\u00fcsitlused, et m\u00f5\u00f5ta statistilist paisumist indeksites ja tabelites PostgreSQLis.<\/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, mis on toodud <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-skripted 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 Puuduolev komplekt kasulikest t\u00f6\u00f6riistadest Postgres DBA-dele ja k\u00f5ikidele inseneridele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gist.github.com\/rgreenjr\/3637525\">postgres_queries_and_commands.sql<\/a><\/noindex> \u2014 Kasulikud PostgreSQLi 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 m\u00f5eldud Oracle'i andmebaasi j\u00f5udluse optimeerimiseks ja t\u00f5rkeotsinguks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"monitoringstatisticsperfomance\">J\u00e4lgimine\/Statistika\/Tulemused<\/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 grafikut aktiivse seansi ajaloo andmete vaatamiseks Oracle'i ja PostgreSQLi andmebaasi sees.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/monyog\">Monyog<\/a><\/noindex> \u2014 Agendivaba ja kulut\u00f5hus MySQLi 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\u00e4lgige 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 Ohutu, lihtne ja agendivaba kaugserveri j\u00e4lgimise t\u00f6\u00f6riist, mis on varustatud t\u00f5husate funktsioonidega, et muuta teie j\u00e4lgimine v\u00f5imalikult t\u00f5husaks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/pmm\">Percona Monitoring and Management<\/a><\/noindex> \u2014 Avatud l\u00e4htekoodiga platvorm MySQLi ja MongoDB j\u00f5udluse haldamiseks ja j\u00e4lgimiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pganalyze\/collector\">pganalyze collector<\/a><\/noindex> \u2014 Pganalyze statistika koguja PostgreSQLi meetrite ja logiandmete 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 teha s\u00fcgavat anal\u00fc\u00fcsi Postgres andmebaaside tervisest.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/wrouesnel\/postgres_exporter\">postgres_exporter<\/a><\/noindex> \u2014 Prometheus eksportija PostgreSQL serveri m\u00f5\u00f5dikute jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgdash.io\">pgDash<\/a><\/noindex> \u2014 Mitu ja j\u00e4lgige iga aspekti oma PostgreSQL andmebaasidest.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pghero\">PgHero<\/a><\/noindex> \u2014 J\u00f5udluse armatuurlaud Postgresile \u2014 tervisekontrollid, soovitatud indeksid ja palju muud.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rapidloop\/pgmetrics\">pgmetrics<\/a><\/noindex> \u2014 Koguge ja kuvage teavet ja statistikat t\u00f6\u00f6tavast PostgreSQL serverist.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgmustard.com\">pgMustard<\/a><\/noindex> \u2014 Kasutajaliides Postgresi seletusplaanide jaoks, lisaks n\u00e4pun\u00e4ited j\u00f5udluse parandamiseks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gleu\/pgstats\">pgstats<\/a><\/noindex> \u2014 Kogub PostgreSQL statistikat, salvestab need kas CSV-failides v\u00f5i prindib need stdout-i.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cybertec-postgresql\/pgwatch2\">pgwatch2<\/a><\/noindex> \u2014 Paindlik iseseisev PostgreSQL statistikate j\u00e4lgimise\/juhtpaneeli lahendus.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/influxdata\/telegraf\/tree\/master\/plugins\/inputs\/postgresql\">Telegraf PostgreSQL plugin<\/a><\/noindex> \u2014 Pakub m\u00f5\u00f5dikuid teie 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 J\u00f5udluse j\u00e4lgimise agent PostgreSQL-i jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.smartmarmot.com\/wiki\/index.php?title=Orabbix\">Orabbix<\/a><\/noindex> \u2014 Orabbix on plugin, mis on loodud t\u00f6\u00f6tama Zabbix Enterprise Monitoriga, et pakkuda mitmetasandilist j\u00e4lgimist, j\u00f5udluse ja k\u00e4ttesaadavuse aruandlust ning m\u00f5\u00f5tmist Oracle andmebaaside jaoks koos serveri j\u00f5udluse m\u00f5\u00f5dikute registreerimisega.<\/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 PostgreSQL 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 plugin teie 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 Andmebaasi testimise raamistik, mis toetab teie andmebaasi koodi lihtsat testip\u00f5hist arendust.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dimitri\/regresql\">RegreSQL<\/a><\/noindex> \u2014 Teie SQL-p\u00e4ringute regressiooni testimine.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"data-generator\">Andmete generaator<\/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 teie testitavale s\u00fcsteemile realistlikke ja kehtivaid suure mahuga testandmeid (v\u00e4ltides Datalite anti-mustri).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/data-generator\">dbForge Data Generator for MySQL<\/a><\/noindex> \u2014 V\u00f5imas GUI-t\u00f6\u00f6riist, millega luua suuri koguseid realistlikke 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 Oracle'i skeemide t\u00e4itmiseks tohutu hulga realistlike testandmetega.<\/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 V\u00f5imas GUI-t\u00f6\u00f6riist andmebaaside jaoks m\u00f5testatud testandmete kiireks genereerimiseks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"administration\">Administratsioon<\/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 Hallake PostgreSQL klastrite rolle, rolli liikmeid, skeemi omandit ja \u00f5igusi.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgslice\">pgslice<\/a><\/noindex> \u2014 PostgreSQL-i partitsioneerimine sama lihtne kui pirukas.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"hafailoversharding\">HA\/Failover\/Jagamine<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/citus\">Citus<\/a><\/noindex> \u2014 PostgreSQL laiendus, mis jaotab teie andmed ja p\u00e4ringud erinevatele s\u00f5lmedele.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/patroni\">patroni<\/a><\/noindex> \u2014 Mall PostgreSQL k\u00f5rge k\u00e4ttesaadavuse jaoks 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 MySQL klastri ja k\u00f5rge k\u00e4ttesaadavuse jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sorintlab\/stolon\">stolon<\/a><\/noindex> \u2014 Pilvep\u00f5hine PostgreSQL haldur 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 automatiseeritud eba\u00f5nnestumise ja k\u00f5rge k\u00e4ttesaadavuse jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/aiven\/pglookout\">pglookout<\/a><\/noindex> \u2014 PostgreSQL replikatsiooni j\u00e4lgimise ja eba\u00f5nnestumise daemon.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClusterLabs\/PAF\">PostgreSQL Automaatne Eba\u00f5nnestumine<\/a><\/noindex> \u2014 K\u00f5rge k\u00e4ttesaadavus Postgresi jaoks, p\u00f5hinedes 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 k\u00f5rge k\u00e4ttesaadavuse klasster (p\u00f5hineb \"Patroni\" ja \"DCS(etcd)\"). Automaatne juurutamine Ansible'i abil.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitessio\/vitess\">Vitess<\/a><\/noindex> \u2014 Andmebaasi klasterdamise s\u00fcsteem MySQL horisontaalse skaalautumise saavutamiseks \u00fchisest sharding'ist.<\/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 Toimivates tootmisandmebaasides Kuberneteses lihtsustamine.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/postgres-operator\">Postgres operator<\/a><\/noindex> \u2014 Postgresi operaator v\u00f5imaldab k\u00f5rgelt k\u00e4ttesaadavaid PostgreSQLi klastreid Kuberneteses (K8s), mida toetab Patroni.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/spilo\">Spilo<\/a><\/noindex> \u2014 HA PostgreSQL klastrid Dockeris.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/ongresinc\/stackgres\">StackGres<\/a><\/noindex> \u2014 Ettev\u00f5tte tasemel, T\u00e4isfunktsionaalne PostgreSQL Kuberneteses.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"configuration-tuning\">Seadistamise h\u00e4\u00e4lestamine<\/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 keeles kirjutatud skript, mis v\u00f5imaldab kiiresti \u00fcle vaadata MySQLi installatsiooni ja teha kohandusi, et suurendada j\u00f5udlust ja stabiilsust.<\/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 PostgreSQL konfiguratsiooni n\u00f5ustaja.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jfcoz\/postgresqltuner\">postgresqltuner.pl<\/a><\/noindex> \u2014 Lihtne skript teie PostgreSQL andmebaasi konfiguratsiooni anal\u00fc\u00fcsimiseks ja seadete n\u00f5ustamiseks.<\/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 v\u00e4ljaandmise ts\u00fckleid ja toetab paindlikkust 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 t\u00e4idab olulisi andmebaasi arendamise funktsioone teie DevOpsi t\u00f6\u00f6voos \u2014 kvaliteeti, j\u00f5udlust ega usaldusv\u00e4\u00e4rsust ohverdamata.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"schema-samples\">Schema 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'i andmebaasi n\u00e4idis skeemid.<\/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 kasutada SQL-i aruandlusrakendus, 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 paigaldab MySQLi andmebaasi serverid lihtsalt.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlcollaborative\/dbatools\">dbatools<\/a><\/noindex> \u2014 PowerShelli moodul, mida v\u00f5ite m\u00f5elda nagu k\u00e4sklusrida SQL Serveri haldustootest.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgresApp\/PostgresApp\">Postgres.app<\/a><\/noindex> \u2014 T\u00e4isfunktsionaalne PostgreSQLi installatsioon, mis on pakitud tavalise Mac rakendusena.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\">BigSQL<\/a><\/noindex> \u2014 Arendajas\u00f5bralik Postgres'i jaotamine.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/credativ\/elephant-shed\">Elephant Shed<\/a><\/noindex> \u2014 Veebip\u00f5hine PostgreSQL haldustarkvara, mis sisaldab mitmeid utiliite ja rakendusi PostgreSQL-i kasutamiseks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"security\">Turvalisus<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cossacklabs\/acra\">Acra<\/a><\/noindex> \u2014 Andmebaasi turvapakett. Andmebaasi vahekollektor, mis toetab v\u00e4lja taseme kr\u00fcpteerimist, otsingut kr\u00fcpteeritud andmete kaudu, SQL-i r\u00fcnnakute ennetamist, sissemurdmise avastamist, meeletage. Toetab kliendi- ja vahekollektiivset (\"l\u00e4bipaistev\") kr\u00fcpteerimist. SQL, NoSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-formatters\">Koodi formateerijad<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/antlr\/codebuff\">CodeBuff<\/a><\/noindex> \u2014 Keele-s\u00f5ltumatu kaunis vormindamine masin\u00f5ppe kaudu.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"contributing\">Oma panus<\/h2>\n<p><\/p>\n<ul>\n<li>Teie panused on alati oodatud! Palun lugege <noindex><a rel=\"nofollow\" href=\"http:\/\/contributing.md\">panustamisjuhiseid<\/a><\/noindex> edaspoole.<\/li>\n<\/ul>\n<p><\/p>\n<p>On leide andmebaasi jaoks \u2014 jagage. Samuti olen t\u00e4nulik tagasiside eest \u2014 PR-id ja t\u00e4hed. Kui on k\u00fcsimusi oma lehtede loomise kohta \u2014 kirjutage samuti.<\/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.0.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.0.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\udd47K\u00e4e j\u00e4rgi koostatud Awesome-list v\u00f5i GitHub alternatiivina 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}]}}