{"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\/sk\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","title":{"rendered":"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" src=\"\/wp-content\/uploads\/2020\/09\/41d7ca428261b80f365797a19c547000.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Ahoj, Habr! Pravdepodobne ka\u017ed\u00fd z n\u00e1s m\u00e1 tak\u00fd s\u00fabor, kam si skr\u00fdvame nie\u010do u\u017eito\u010dn\u00e9 a zauj\u00edmav\u00e9. R\u00f4zne odkazy na \u010dl\u00e1nky, knihy, repozit\u00e1re, pr\u00edru\u010dky. M\u00f4\u017eu to by\u0165 z\u00e1lo\u017eky v prehliada\u010di alebo dokonca jednoducho otvoren\u00e9 karty, ktor\u00e9 sme nechali na potom. S \u010dasom sa to v\u0161etko nahromad\u00ed, odkazy prestan\u00fa fungova\u0165 a v\u00e4\u010d\u0161ina materi\u00e1lov jednoducho zastar\u00e1va. <\/p>\n<p><\/p>\n<p>A \u010do keby ste sa o tento skvost podelili so komunitou a nahodili tento s\u00fabor na GitHub? Potom m\u00f4\u017eu by\u0165 va\u0161e snahy u\u017eito\u010dn\u00e9 aj in\u00fdm a udr\u017eiavanie aktu\u00e1lnosti m\u00f4\u017ee prebieha\u0165 spolo\u010dne, prij\u00edmaj\u00fac aktualiz\u00e1cie od z\u00e1ujemcov prostredn\u00edctvom star\u00fdch dobr\u00fdch PR. Presne na tento \u00fa\u010del je projekt ur\u010den\u00fd. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">Awesome lists<\/a><\/noindex>. Patr\u00ed medzi TOP-10 repozit\u00e1rov na GitHube, m\u00e1 138K hviezd a odkaz na va\u0161e dielo sa m\u00f4\u017ee objavi\u0165 priamo v jeho kore\u0148ovom README, \u010do pril\u00e1ka obrovsk\u00e9 publikum k va\u0161ej kreat\u00edvnej \u010dinnosti. Pravda, pre toto bude treba tro\u0161ku sa sna\u017ei\u0165. O svojich sk\u00fasenostiach v t\u00fdchto snah\u00e1ch sa chcem s vami podeli\u0165. <\/p>\n<p><\/p>\n<p>Vol\u00e1m sa Maxim Gramin. V KROK sa venujem Java v\u00fdvoju a v\u00fdskumu v oblasti datab\u00e1z. V tomto pr\u00edspevku v\u00e1m poviem, \u010do s\u00fa to Awesome lists a ako si vytvori\u0165 svoju skuto\u010dn\u00fa ofici\u00e1lnu awesome repo.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"chto-takoe-awesome-lists\">\u010co s\u00fa to Awesome lists<\/h2>\n<p><\/p>\n<p>Ke\u010f sa m\u00e1m s nie\u010d\u00edm nov\u00fdm technol\u00f3gie alebo jazyk programovania, prv\u00e9 \u010do rob\u00edm, je \u00eds\u0165 pr\u00e1ve sem \u2014 n\u00e1jdem potrebn\u00fa sekciu a v nej vhodn\u00e9 zoznamy. A pod\u013ea po\u010dtu hviezd a ich neust\u00e1leho rastu, tak nerob\u00edm len ja.<br \/>\n<img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" src=\"\/wp-content\/uploads\/2020\/09\/383d1f4d5126fe2a11d449cf5e83b576.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>V skuto\u010dnosti ide o be\u017en\u00fd ploch\u00fd readme.md, ktor\u00fd \u017eije v samostatnom <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">repozit\u00e1ri<\/a><\/noindex>, zauj\u00edma pritom 8. miesto medzi v\u0161etk\u00fdmi repozit\u00e1rmi GitHubu a zah\u0155\u0148a odkazy na in\u00e9 zoznamy venovan\u00e9 nejakej t\u00e9me. Napr\u00edklad v sekcii Programovacie jazyky m\u00f4\u017eete n\u00e1js\u0165 zoznamy Awesome Python a Awesome Go, a v Front-End Development je obrovsk\u00e9 mno\u017estvo zdrojov o WEB v\u00fdvoji. No a, samozrejme, \u2014 sekcia <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome#databases\">Databases<\/a><\/noindex> (k tomu sa e\u0161te vr\u00e1time nesk\u00f4r). A \u00e1no, v\u0161etko to nie je obmedzen\u00e9 iba na technick\u00e9 t\u00e9my. Napr\u00edklad v sekci\u00e1ch Entertainment a Gaming tie\u017e n\u00e1jdete mno\u017estvo zauj\u00edmav\u00e9ho (m\u0148a osobne pote\u0161il <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/RichardLitt\/awesome-fantasy\">awesome-fantasy<\/a><\/noindex>).<br \/>\nHlavn\u00e1 charakteristika spo\u010d\u00edva v tom, \u017ee v\u0161etky tieto zoznamy vedie nie osobne autor, ale komunita a s\u00fa zostaven\u00e9 pod\u013ea \u0161peci\u00e1lneho a ve\u013emi pr\u00edsneho <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/blob\/main\/awesome.md\">awesome manifesto<\/a><\/noindex>. Ka\u017ed\u00fd tak\u00fd zoznam je samostatnou komunitou odborn\u00edkov, \u017eije svoj\u00edm \u017eivotom a je otvoren\u00fd pre va\u0161e pull requesty, ktor\u00e9 ho urobia e\u0161te lep\u0161\u00edm. Ka\u017ed\u00fd z\u00e1ujemca m\u00f4\u017ee vytvori\u0165 svoj vlastn\u00fd zoznam, ak nebola nejak\u00e1 t\u00e9ma e\u0161te pokryt\u00e1.<\/p>\n<p><\/p>\n<p>Autor tejto my\u0161lienky a koordin\u00e1tor cel\u00e9ho tohto podniku \u2014 legend\u00e1rny Sindre S\u00f8rhus, <noindex><a rel=\"nofollow\" href=\"https:\/\/gitstar-ranking.com\/users\">prv\u00fd \u010dlovek na GitHub-e<\/a><\/noindex>, autor viac ako <noindex><a rel=\"nofollow\" href=\"https:\/\/www.npmjs.com\/~sindresorhus\">1000 npm modulov,<\/a><\/noindex>a pr\u00e1ve on bude prij\u00edma\u0165 va\u0161e PR.<br \/>\n<img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" 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\">Ako sa dosta\u0165 do awesome-list<\/h2>\n<p><\/p>\n<p>Ak ste n\u00e1hodou nena\u0161li vhodn\u00fd zoznam na zauj\u00edmav\u00fa t\u00e9mu, je to prv\u00fd sign\u00e1l, \u017ee by ste ho mali vytvori\u0165 sami!<\/p>\n<p><\/p>\n<p>Poviem to na pr\u00edklade svojho die\u0165a\u0165a <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools,<\/a><\/noindex> \u2014 Z projektu do projektu mus\u00edm pracova\u0165 s r\u00f4znymi datab\u00e1zami, a preto m\u00e1m tak\u00fd s\u00fabor, v ktorom som zhroma\u017e\u010foval u\u017eito\u010dn\u00e9 n\u00e1stroje na pr\u00e1cu s nimi, r\u00f4zne DB migr\u00e1tory, IDE, administr\u00e1torsk\u00e9 panely, sledovacie n\u00e1stroje a dr\u00f4t. N\u00e1stroje, ktor\u00e9 som u\u017e pou\u017e\u00edval alebo ich pl\u00e1noval za\u010da\u0165 pou\u017e\u00edva\u0165. Zdie\u013eal som tento s\u00fabor s kolegami v KROK-u a mimo neho. Pomohlo to mnoh\u00fdm a bolo to zauj\u00edmav\u00e9. Nakoniec som t\u00fa\u017eil po v\u00e4\u010d\u0161ej sl\u00e1ve, ke\u010f som raz postrehol, \u017ee v sekcii Databases ch\u00fdba zoznam na t\u00fato t\u00e9mu. A rozhodol som sa prida\u0165 svoj. <\/p>\n<p><\/p>\n<p><strong>\u010co na to treba?<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>Zaregistrujeme be\u017en\u00e9 GitHub repo s menom vo forme awesome-\u010do-to-je. V mojom pr\u00edpade to bolo awesome-database-tools,<\/li>\n<li>Uprav\u00edme svoj zoznam do form\u00e1tu awesome, na \u010do n\u00e1m pom\u00f4\u017ee <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dar5hak\/generator-awesome-list\">generator-awesome-list,<\/a><\/noindex>ktor\u00fd vygeneruje v\u0161etky potrebn\u00e9 s\u00fabory v po\u017eadovanom form\u00e1te.<\/li>\n<li>Nastav\u00edme skuto\u010dn\u00fd CI. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome-lint\">awesome-lint<\/a><\/noindex> a travis ci n\u00e1m pom\u00f4\u017eu kontrolova\u0165 <noindex><a rel=\"nofollow\" href=\"https:\/\/travis-ci.org\/github\/mgramin\/awesome-db-tools\">platnos\u0165<\/a><\/noindex> n\u00e1\u0161ho zoznamu.<\/li>\n<li>\u010cak\u00e1me 30 dn\u00ed, <\/li>\n<li>Rob\u00edme rev\u00edziu aspo\u0148 2 cudz\u00edch PR.<\/li>\n<li>A nakoniec rob\u00edme PR do hlavn\u00e9ho repa, kde prid\u00e1vame odkaz na svoje repo. Tu je potrebn\u00e9 v\u0161etko pozorne pre\u010d\u00edta\u0165 a d\u00f4kladne splni\u0165 v\u0161etky po\u010detn\u00e9 po\u017eiadavky na nov\u00fd zoznam a samotn\u00fd PR.<\/li>\n<\/ol>\n<p><\/p>\n<p>Moja prv\u00e1 sna\u017eenie <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1336\">sa uk\u00e1zala ako ne\u00faspe\u0161n\u00e1.<\/a><\/noindex><br \/>\n<img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" src=\"\/wp-content\/uploads\/2020\/09\/196dd3f494d5e91eaa7af49e16f74393.jpeg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nAle \u010das plynul, zhroma\u017edil som e\u0161te viac materi\u00e1lu, popracoval na chyb\u00e1ch a odv\u00e1\u017eil sa na <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1679\">druh\u00fa pokus.<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Ale zabudol som na jednu ve\u013emi d\u00f4le\u017eit\u00fa vec, na \u010do mi jemne nazna\u010dili:<br \/>\n<img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" src=\"\/wp-content\/uploads\/2020\/09\/0ec0a33b3c7bb15b6cce6bf076208f09.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Bol som nie ve\u013emi pozorn\u00fd a nezapracoval som jednoro\u017eca ako potvrdenie, \u017ee v\u0161etky podmienky s\u00fa splnen\u00e9.<br \/>\n<img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" src=\"\/wp-content\/uploads\/2020\/09\/3a69eb82ca26310c78bf5f6c3c8ef383.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Potom uplynulo e\u0161te trochu \u010dasu, \u010fal\u0161ie \u00fapravy pod\u013ea pozn\u00e1mok a objavil sa o\u010dak\u00e1van\u00fd <noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/awesome__re\/status\/1246779641475424256\">tweety,<\/a><\/noindex>\u017ee m\u00f4j PR bol prijat\u00fd.<\/p>\n<p><\/p>\n<p>Tak som sa stal autorom svojho prv\u00e9ho zoznamu a za\u010dal som dost\u00e1va\u0165 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools\/pulls?q=is%3Apr+is%3Aclosed\">PR<\/a><\/noindex> z komunity na pridanie nov\u00fdch n\u00e1strojov. A mnoh\u00e9 z nich u\u017e s\u00fa zahrnut\u00e9 v <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools,<\/a><\/noindex>. Ak nem\u00e1te chu\u0165 prech\u00e1dza\u0165 na odkaz, <\/p>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">tu je aktu\u00e1lna v \u010dase publikovania pr\u00edspevku zbierka<\/b><\/p>\n<h1 id=\"awesome-database-tools-awesomehttpsawesomerebadgesvghttpsawesomere\">Awesome Database Tools, <noindex><a rel=\"nofollow\" href=\"https:\/\/awesome.re\"><img decoding=\"async\" alt=\"Awesome-list vlastn\u00fdmi rukami, alebo GitHub namiesto bloknotu\" src=\"\/wp-content\/uploads\/2020\/09\/2951c443e95e3c56f93fb685afed6115.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/h1>\n<p><\/p>\n<blockquote><p>Zoznam n\u00e1strojov datab\u00e1z poh\u00e1\u0148an\u00fd komunitou<\/p><\/blockquote>\n<p>Tu budeme zhroma\u017e\u010fova\u0165 inform\u00e1cie o \u00fa\u017easn\u00fdch a u\u017eito\u010dn\u00fdch aj experiment\u00e1lnych n\u00e1strojoch, ktor\u00e9 zjednodu\u0161uj\u00fa pr\u00e1cu s datab\u00e1zami pre DBA, DevOps, v\u00fdvoj\u00e1rov a oby\u010dajn\u00fdch smrte\u013en\u00edkov.<\/p>\n<p><\/p>\n<p>Nev\u00e1hajte prida\u0165 inform\u00e1cie o svojich vlastn\u00fdch n\u00e1strojoch db alebo o svojich ob\u013e\u00faben\u00fdch n\u00e1strojoch tret\u00edch str\u00e1n db.<\/p>\n<p><\/p>\n<h2 id=\"contents\">Obsah<\/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 mana\u017e\u00e9ri\/klienti<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#cli-tools\">CLI n\u00e1stroje<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#db-schema-navigation-and-visualization\">Navig\u00e1cia a vizualiz\u00e1cia DB sch\u00e9my<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#modelers\">Model\u00e9ry<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#migration-tools\">N\u00e1stroje na migr\u00e1ciu<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-generation-tools\">N\u00e1stroje na generovanie k\u00f3du<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#wrappers\">Obalov\u00e9 n\u00e1stroje<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#backup-tools\">N\u00e1stroje na z\u00e1lohovanie<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#replicationdata-operation\">Replik\u00e1cia\/oper\u00e1cie s d\u00e1tami<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#scripts\">Skripty<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#monitoringstatisticsperfomance\">Monitorovanie\/\u0161tatistiky\/v\u00fdkon<\/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\">Testovanie<\/a><\/noindex>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#data-generator\">Gener\u00e1tor d\u00e1t<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#administration\">Administr\u00e1cia<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#hafailoversharding\">HA\/failover\/rozdelenie<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#kubernetes\">Kubernetes<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#configuration-tuning\">Ladenie konfigur\u00e1cie<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#devops\">DevOps<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#schema-samples\">Uk\u00e1\u017eky sch\u00e9m<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#reporting\">Reportovanie<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#distributions\">Distrib\u00facie<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#security\">Bezpe\u010dnos\u0165<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-formatters\">Form\u00e1tova\u010de k\u00f3du<\/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 P\u00f4sobiv\u00fd viac\u00fa\u010delov\u00fd administrat\u00edvny n\u00e1stroj pre spr\u00e1vu datab\u00e1z, kontrolu a v\u00fdvoj.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.aquafold.com\/aquadatastudio\">Aqua Data Studio<\/a><\/noindex> \u2014 Aqua Data Studio je produktivita softv\u00e9r pre v\u00fdvoj\u00e1rov datab\u00e1z, DBA a analytikov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/fishcodelib.com\/Database.htm\">Database .net<\/a><\/noindex> \u2014 N\u00e1stroj na spr\u00e1vu viacer\u00fdch datab\u00e1z so podporou pre 20+ datab\u00e1z.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jetbrains.com\/datagrip\">DataGrip<\/a><\/noindex> \u2014 IDE naprie\u010d platformami pre datab\u00e1zy &amp; SQL od JetBrains.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbeaver\/dbeaver\">DBeaver<\/a><\/noindex> \u2014 Bezplatn\u00fd univerz\u00e1lny spr\u00e1vca datab\u00e1z a SQL klient.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/studio\">dbForge Studio for MySQL<\/a><\/noindex> \u2014 Univerz\u00e1lne IDE na v\u00fdvoj, spr\u00e1vu a administr\u00e1ciu datab\u00e1z MySQL a MariaDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/studio\">dbForge Studio for Oracle<\/a><\/noindex> \u2014 V\u00fdkonn\u00e9 IDE na spr\u00e1vu, administr\u00e1ciu a v\u00fdvoj Oracle.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/postgresql\/studio\">dbForge Studio for PostgreSQL<\/a><\/noindex> \u2014 N\u00e1stroj GUI na spr\u00e1vu a v\u00fdvoj datab\u00e1z a objektov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/sql\/studio\">dbForge Studio for SQL Server<\/a><\/noindex> \u2014 V\u00fdkonn\u00e9 integrovan\u00e9 v\u00fdvojov\u00e9 prostredie na v\u00fdvoj, spr\u00e1vu, administr\u00e1ciu, anal\u00fdzu d\u00e1t a reportovanie SQL Server.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/SouthbankSoftware\/dbkoda\">dbKoda<\/a><\/noindex> \u2014 Modern\u00e9 (JavaScript\/Electron framework), open source IDE pre MongoDB. Podporuje v\u00fdvoj, administr\u00e1ciu a ladenie v\u00fdkonu datab\u00e1z MongoDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.ibexpert.net\/ibe\">IBExpert<\/a><\/noindex> \u2014 Komplexn\u00fd GUI n\u00e1stroj pre Firebird a InterBase.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HeidiSQL\/HeidiSQL\">HeidiSQL<\/a><\/noindex> \u2014 \u013dahk\u00fd klient na spr\u00e1vu MySQL, MSSQL a PostgreSQL, nap\u00edsan\u00fd v Delphi.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mysql.com\/products\/workbench\">MySQL Workbench<\/a><\/noindex> \u2014 MySQL Workbench je jednotn\u00fd vizu\u00e1lny n\u00e1stroj pre architektov datab\u00e1z, v\u00fdvoj\u00e1rov a DBA.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products#navicat\">Navicat<\/a><\/noindex> \u2014 N\u00e1stroj na v\u00fdvoj datab\u00e1z, ktor\u00fd umo\u017e\u0148uje s\u00fa\u010dasn\u00e9 pripojenie k MySQL, MariaDB, SQL Server, Oracle, PostgreSQL a SQLite datab\u00e1zam z jednej aplik\u00e1cie.<\/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 je bezplatn\u00e9, integrovan\u00e9 v\u00fdvojov\u00e9 prostredie, ktor\u00e9 zjednodu\u0161uje v\u00fdvoj a spr\u00e1vu Oracle Database v tradi\u010dn\u00fdch aj cloudov\u00fdch nasadeniach.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgadmin.org\">pgAdmin<\/a><\/noindex> \u2014 Najpopul\u00e1rnej\u0161ia a najkomplexnej\u0161ia Open Source administrat\u00edvna a v\u00fdvojov\u00e1 platforma pre PostgreSQL, najpokro\u010dilej\u0161iu Open Source datab\u00e1zu na svete.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\/pgadmin3\">pgAdmin3<\/a><\/noindex> \u2014 Dlho-term\u00ednov\u00e1 podpora pre pgAdmin3.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.allroundautomations.com\/products\/pl-sql-developer\">PL\/SQL Developer<\/a><\/noindex> \u2014 IDE, ktor\u00e9 je \u0161peci\u00e1lne zameran\u00e9 na v\u00fdvoj ulo\u017een\u00fdch programov\u00fdch jednotiek pre datab\u00e1zy Oracle.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlmaestro.com\/products\/postgresql\/maestro\">PostgreSQL Maestro<\/a><\/noindex> \u2014 Komplexn\u00fd a v\u00fdkonn\u00fd n\u00e1stroj na spr\u00e1vu datab\u00e1z, administr\u00e1ciu a v\u00fdvoj pre PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/toad\/\">Toad<\/a><\/noindex> \u2014 Toad je najlep\u0161\u00ed datab\u00e1zov\u00fd n\u00e1stroj pre v\u00fdvoj\u00e1rov, administr\u00e1torov a d\u00e1tov\u00fdch analytikov. Spravujte zlo\u017eit\u00fa zmenu datab\u00e1z s jedin\u00fdm n\u00e1strojom na spr\u00e1vu datab\u00e1z.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.toadworld.com\/products\/toad-edge\">Toad Edge<\/a><\/noindex> \u2014 Zjednodu\u0161en\u00fd n\u00e1stroj na v\u00fdvoj datab\u00e1z pre MySQL a Postgres.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tora-tool\/tora\">TOra<\/a><\/noindex> \u2014 TOra je open source SQL IDE pre Oracle, MySQL a PostgreSQL datab\u00e1zy.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.valentina-db.com\/en\/valentina-studio-overview\">Valentina Studio<\/a><\/noindex> \u2014 Vytvorte, spravujte, dotazujte a sk\u00famajte datab\u00e1zy Valentina DB, MySQL, MariaDB, PostgreSQL a SQLite zadarmo.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"gui-managersclients\">GUI mana\u017e\u00e9ri\/klienti<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vrana\/adminer\">Adminer<\/a><\/noindex> \u2014 Spr\u00e1va datab\u00e1z v jednom PHP s\u00fabore.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dbvis.com\">DbVisualizer<\/a><\/noindex> \u2014 Univerz\u00e1lny datab\u00e1zov\u00fd n\u00e1stroj pre v\u00fdvoj\u00e1rov, DBA a analytikov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HouseOps\/HouseOps\">HouseOps<\/a><\/noindex> \u2014 Podnikov\u00fd ClickHouse Ops UI pre sp\u00fa\u0161\u0165anie dotazov, monitorovanie zdravia ClickHouse a vykon\u00e1vanie mnoh\u00fdch \u010fal\u0161\u00edch vec\u00ed.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jackdb.com\">JackDB<\/a><\/noindex> \u2014 Priamy pr\u00edstup k SQL v\u0161etk\u00fdm va\u0161\u00edm d\u00e1tam, bez oh\u013eadu na to, kde sa nach\u00e1dzaj\u00fa.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/OmniDB\/OmniDB\">OmniDB<\/a><\/noindex> \u2014 Webov\u00fd n\u00e1stroj na spr\u00e1vu datab\u00e1z.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sosedoff\/pgweb\">Pgweb<\/a><\/noindex> \u2014 Webov\u00fd prehliada\u010d datab\u00e1z pre PostgreSQL, nap\u00edsan\u00fd v Go, ktor\u00fd funguje na macOS, Linux a Windows.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.phpliteadmin.org\">phpLiteAdmin<\/a><\/noindex> \u2014 Webov\u00fd n\u00e1stroj na spr\u00e1vu SQLite datab\u00e1z nap\u00edsan\u00fd v PHP s podporou pre SQLite3 a SQLite2.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/phpmyadmin\/phpmyadmin\">phpMyAdmin<\/a><\/noindex> \u2014 Webov\u00e9 rozhranie pre MySQL a MariaDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.psequel.com\">psequel<\/a><\/noindex> \u2014 PSequel poskytuje \u010dist\u00e9 a jednoduch\u00e9 rozhranie pre r\u00fdchle vykon\u00e1vanie be\u017en\u00fdch \u00faloh PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/popsql.com\">PopSQL<\/a><\/noindex> \u2014 Modern\u00fd, spolupracuj\u00faci SQL editor pre v\u00e1\u0161 t\u00edm.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/eggerapps.at\/postico\">Postico<\/a><\/noindex> \u2014 Modern\u00fd klient PostgreSQL pre Mac.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Studio3T\/robomongo\">Robo 3T<\/a><\/noindex> \u2014 Robo 3T (predt\u00fdm Robomongo) je shell-centric multiplatformov\u00fd n\u00e1stroj na spr\u00e1vu MongoDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sequelpro\/sequelpro\">Sequel Pro<\/a><\/noindex> \u2014 Sequel Pro je r\u00fdchla a jednoduch\u00e1 aplik\u00e1cia na spr\u00e1vu datab\u00e1z pre Mac, ur\u010den\u00e1 na pr\u00e1cu s datab\u00e1zami MySQL &amp; MariaDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\">SQL Operations Studio<\/a><\/noindex> \u2014 N\u00e1stroj na spr\u00e1vu d\u00e1t, ktor\u00fd umo\u017e\u0148uje pr\u00e1cu so SQL Serverom, Azure SQL DB a SQL DW na Windows, macOS a Linux.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqliteexpert.com\/index.html\">SQLite Expert<\/a><\/noindex> \u2014 Grafick\u00e9 rozhranie podporuje v\u0161etky funkcie SQLite.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rickbergfalk\/sqlpad\">sqlpad<\/a><\/noindex> \u2014 Webov\u00fd SQL editor funguj\u00faci vo va\u0161ej vlastnej s\u00fakromnej cloudovej infra\u0161trukt\u00fare.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.macpostgresclient.com\">SQLPro<\/a><\/noindex> \u2014 Jednoduch\u00fd, ale mocn\u00fd mana\u017e\u00e9r Postgres pre macOS.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/squirrel-sql\">SQuirreL<\/a><\/noindex> \u2014 Grafick\u00fd SQL klient nap\u00edsan\u00fd v Jave, ktor\u00fd v\u00e1m umo\u017en\u00ed zobrazi\u0165 \u0161trukt\u00faru datab\u00e1zy kompatibilnej s JDBC, prehliada\u0165 d\u00e1ta v tabu\u013ek\u00e1ch, vyd\u00e1va\u0165 SQL pr\u00edkazy at\u010f.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mtxr\/vscode-sqltools\">SQLTools<\/a><\/noindex> \u2014 Spr\u00e1va datab\u00e1z pre VSCode.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/sqlyog\">SQLyog<\/a><\/noindex> \u2014 Najkompletnej\u0161ie a najjednoduch\u0161ie pou\u017eite\u013en\u00e9 GUI pre MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tabixio\/tabix\">Tabix<\/a><\/noindex> \u2014 SQL editor &amp; open source jednoduch\u00e1 obchodn\u00e1 inteligencia pre Clickhouse.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/TablePlus\/TablePlus\">TablePlus<\/a><\/noindex> \u2014 Modern\u00fd, nat\u00edvny a priate\u013esk\u00fd GUI n\u00e1stroj pre rela\u010dn\u00e9 datab\u00e1zy: MySQL, PostgreSQL, SQLite &amp; \u010fal\u0161ie.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.teampostgresql.com\">TeamPostgreSQL<\/a><\/noindex> \u2014 Webov\u00e9 administra\u010dn\u00e9 GUI pre PostgreSQL \u2014 pou\u017e\u00edvajte svoje datab\u00e1zy PostgreSQL odkia\u013eko\u013evek s bohat\u00fdm, bleskovo r\u00fdchlym AJAX webov\u00fdm rozhran\u00edm.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"cli-tools\">CLI n\u00e1stroje<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ipython-sql\">ipython-sql<\/a><\/noindex> \u2014 Pripojte sa k datab\u00e1ze a vyd\u00e1vajte SQL pr\u00edkazy v IPythone alebo IPython Notebooku.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/laixintao\/iredis\">iredis<\/a><\/noindex> \u2014 CLI pre Redis s automatick\u00fdm dopl\u0148ovan\u00edm a zv\u00fdraznen\u00edm syntaxe.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/lesovsky\/pgcenter\">pgcenter<\/a><\/noindex> \u2014 N\u00e1stroj na spr\u00e1vu podobn\u00fd top pre PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/julmon\/pg_activity\">pg_activity<\/a><\/noindex> \u2014 Aplik\u00e1cia podobn\u00e1 top na sledovanie aktivity servera PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/markwkm\/pg_top\">pg_top<\/a><\/noindex> \u2014 'top' pre PostgreSQL.<\/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) je bezplatn\u00e9 rozhranie pr\u00edkazov\u00e9ho riadku pre Oracle Database.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql\">usql<\/a><\/noindex> \u2014 Univerz\u00e1lne pr\u00edkazov\u00e9 rozhranie pre PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql#database-support\">a mnoho \u010fal\u0161\u00edch datab\u00e1z<\/a><\/noindex> vr\u00e1tane NoSQL a nerela\u010dn\u00fdch datab\u00e1z!<\/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 je n\u00e1stroj CLI pre slu\u017ebu AWS Athena, ktor\u00fd m\u00f4\u017ee robi\u0165 automatick\u00fa komplet\u00e1ciu a zv\u00fdraznenie syntaxe.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/litecli\">litecli<\/a><\/noindex> \u2014 CLI pre SQLite datab\u00e1zy s automatick\u00fdm dopl\u0148ovan\u00edm a zv\u00fdraznen\u00edm syntaxe.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mssql-cli\">mssql-cli<\/a><\/noindex> \u2014 Klient pr\u00edkazov\u00e9ho riadku pre SQL Server s automatick\u00fdm dopl\u0148ovan\u00edm a zv\u00fdraznen\u00edm syntaxe.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mycli\">mycli<\/a><\/noindex> \u2014 Termin\u00e1lov\u00fd klient pre MySQL s automatick\u00fdm dopl\u0148ovan\u00edm a zv\u00fdraznen\u00edm syntaxe.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/pgcli\">pgcli<\/a><\/noindex> \u2014 Postgres CLI s automatick\u00fdm dopl\u0148ovan\u00edm a zv\u00fdraznen\u00edm syntaxe.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/vcli\">vcli<\/a><\/noindex> \u2014 Vertica CLI s automatick\u00fdm dopl\u0148ovan\u00edm a zv\u00fdraznen\u00edm syntaxe.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"db-schema-navigation-and-visualization\">Navig\u00e1cia a vizualiz\u00e1cia DB sch\u00e9my<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/dbdiagram.io\">dbdiagram.io<\/a><\/noindex> \u2014 R\u00fdchly a jednoduch\u00fd n\u00e1stroj, ktor\u00fd v\u00e1m pom\u00f4\u017ee kresli\u0165 diagramy vz\u0165ahov va\u0161ich datab\u00e1z a r\u00fdchlo vytv\u00e1ra\u0165 pomocou jednoduch\u00e9ho DSL jazyka.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Alexis-benoist\/eralchemy\">ERAlchemy<\/a><\/noindex> \u2014 N\u00e1stroj na generovanie diagramov entity-rela\u010dn\u00e9.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemacrawler\/SchemaCrawler\">SchemaCrawler<\/a><\/noindex> \u2014 Bezplatn\u00fd n\u00e1stroj na objavovanie a porozumenie sch\u00e9my datab\u00e1zy.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemaspy\/schemaspy\">Schema Spy<\/a><\/noindex> \u2014 Generovanie dokument\u00e1cie va\u0161ej datab\u00e1zy do HTML, vr\u00e1tane diagramov entity-rela\u010dn\u00e9.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/k1LoW\/tbls\">tbls<\/a><\/noindex> \u2014 N\u00e1stroj priate\u013esk\u00fd pre CI na dokument\u00e1ciu datab\u00e1zy, nap\u00edsan\u00fd v Go.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"modelers\">Model\u00e9ry<\/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 Siln\u00fd a n\u00e1kladovo efekt\u00edvny n\u00e1stroj na n\u00e1vrh datab\u00e1z, ktor\u00fd v\u00e1m pom\u00f4\u017ee vytvori\u0165 kvalitn\u00e9 koncep\u010dn\u00e9, logick\u00e9 a fyzick\u00e9 d\u00e1tov\u00e9 modely.<\/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 je bezplatn\u00fd grafick\u00fd n\u00e1stroj, ktor\u00fd zvy\u0161uje produktivitu a zjednodu\u0161uje \u00falohy modelovania d\u00e1t.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgmodeler\/pgmodeler\">pgmodeler<\/a><\/noindex> \u2014 N\u00e1stroj na modelovanie d\u00e1t navrhnut\u00fd pre PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"migration-tools\">N\u00e1stroje na migr\u00e1ciu<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CourseOrchestra\/2bass\">2bass<\/a><\/noindex> \u2014 N\u00e1stroj na konfigur\u00e1ciu datab\u00e1z ako k\u00f3d, ktor\u00fd vyu\u017e\u00edva koncept idempotentn\u00fdch DDL skriptov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/flyway\/flyway\">flyway<\/a><\/noindex> \u2014 N\u00e1stroj na migr\u00e1ciu datab\u00e1z.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/github\/gh-ost\">gh-ost<\/a><\/noindex> \u2014 Online migr\u00e1cia sch\u00e9my pre MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/liquibase\/liquibase\">liquibase<\/a><\/noindex> \u2014 Kni\u017enica nez\u00e1visl\u00e1 od datab\u00e1zy na sledovanie, spr\u00e1vu a aplik\u00e1ciu zmien sch\u00e9my datab\u00e1zy.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/djrobstep\/migra\">migra<\/a><\/noindex> \u2014 Podobn\u00e9 diff, ale pre sch\u00e9my PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/salsita\/node-pg-migrate\">node-pg-migrate<\/a><\/noindex> \u2014 Spr\u00e1va migr\u00e1ci\u00ed datab\u00e1zy pre Node.js vyvinut\u00e1 v\u00fdhradne pre postgres. (Ale m\u00f4\u017ee sa pou\u017e\u00edva\u0165 aj pre in\u00e9 DB, ktor\u00e9 zodpovedaj\u00fa SQL \u0161tandardu \u2014 napr. CockroachDB.)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/perseas\/Pyrseas\">Pyrseas<\/a><\/noindex> \u2014 Poskytuje n\u00e1stroje na opis sch\u00e9my datab\u00e1zy PostgreSQL ako YAML.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemahero\/schemahero\">SchemaHero<\/a><\/noindex> \u2014 Kubernetes oper\u00e1tor pre deklarat\u00edvnu spr\u00e1vu sch\u00e9my datab\u00e1zy (gitops pre sch\u00e9my datab\u00e1z).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqitchers\/sqitch\">Sqitch<\/a><\/noindex> \u2014 Rozumn\u00e9 spravovanie zmien na b\u00e1ze datab\u00e1zy pre v\u00fdvoj bez r\u00e1mca a spo\u013eahliv\u00e9 nasadenie.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rdagumampan\/yuniql\">yuniql<\/a><\/noindex> \u2014 E\u0161te jeden n\u00e1stroj na verziovanie sch\u00e9my a migr\u00e1ciu, vytvoren\u00fd v\u00fdhradne pre .NET Core 3.0+ a d\u00fafajme, \u017ee lep\u0161\u00ed.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-generation-tools\">N\u00e1stroje na generovanie k\u00f3du<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ddl-generator\">ddl-generator<\/a><\/noindex> \u2014 Odvodzuje SQL DDL (Data Definition Language) zo \u00fadajov tabuliek.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/qwazer\/scheme2ddl\">scheme2ddl<\/a><\/noindex> \u2014 Pr\u00edkazov\u00fd riadok na export Oracle sch\u00e9my na s\u00fabor nastavenia ddl skriptov s mo\u017enos\u0165ou filtrovania ne\u017eiaducich inform\u00e1ci\u00ed, oddelenia DDL do r\u00f4znych s\u00faborov, pekne naform\u00e1tovan\u00fd v\u00fdstup.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"wrappers\">Obalov\u00e9 n\u00e1stroje<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dreamfactorysoftware\/dreamfactory\">DreamFactory<\/a><\/noindex> \u2014 Open source REST API backend pre mobiln\u00e9, webov\u00e9 a IoT aplik\u00e1cie.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/graphql-engine\">Hasura GraphQL Engine<\/a><\/noindex> \u2014 R\u00fdchle, okam\u017eit\u00e9 realtime GraphQL API na Postgres s detailnou kontrolou pr\u00edstupu, tie\u017e sp\u00fa\u0161\u0165a webhooky na udalosti datab\u00e1zy.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/avz\/jl-sql\">jl-sql<\/a><\/noindex> \u2014 SQL pre JSON a CSV pr\u00fady.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/EnterpriseDB\/mysql_fdw\">mysql_fdw<\/a><\/noindex> \u2014 Zahrani\u010dn\u00fd d\u00e1tov\u00fd obal PostgreSQL pre MySQL.<\/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 Stredn\u00e1 Java aplik\u00e1cia, ORDS mapuje HTTP(S) pr\u00edkazy (GET, POST, PUT, DELETE, at\u010f.) na transakcie datab\u00e1zy a vracia ak\u00e9ko\u013evek v\u00fdsledky vo form\u00e1te JSON.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prismagraphql\/prisma\">Prisma<\/a><\/noindex> \u2014 Prisma premen\u00ed va\u0161u datab\u00e1zu na realtime GraphQL API.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgREST\/postgrest\">PostgREST<\/a><\/noindex> \u2014 REST API pre ak\u00fako\u013evek PostgreSQL datab\u00e1zu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prest\/prest\">prest<\/a><\/noindex> \u2014 Sp\u00f4sob, ako poskytn\u00fa\u0165 RESTful API pre ak\u00e9ko\u013evek datab\u00e1zy nap\u00edsan\u00e9 v Go.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/restsql\/restsql\">restSQL<\/a><\/noindex> \u2014 Gener\u00e1tor SQL s Java a HTTP API, pou\u017e\u00edva jednoduch\u00e9 RESTful HTTP API s XML alebo JSON serializ\u00e1ciou.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/formio\/resquel\">resquel<\/a><\/noindex> \u2014 Jednoducho preme\u0148te svoju SQL datab\u00e1zu na REST API.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jeffknupp\/sandman2\">sandman2<\/a><\/noindex> \u2014 Automaticky generujte RESTful API slu\u017ebu pre va\u0161u star\u0161iu datab\u00e1zu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CrocInc\/sql-boot\">sql-boot<\/a><\/noindex> \u2014 Pokro\u010dil\u00fd REST a UI wrapper pre va\u0161e SQL dotazy.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"backup-tools\">N\u00e1stroje na z\u00e1lohovanie<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgbackrest\/pgbackrest\">pgbackrest<\/a><\/noindex> \u2014 Spo\u013eahliv\u00e9 z\u00e1lohovanie a obnova PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndquadrant-it\/barman\">BaRMan<\/a><\/noindex> \u2014 Spr\u00e1vca z\u00e1lohovania a obnovy pre PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"replicationdata-operation\">Replik\u00e1cia\/oper\u00e1cie s d\u00e1tami<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/simonw\/datasette\">Datasette<\/a><\/noindex> \u2014 N\u00e1stroj na sk\u00famanie a publik\u00e1ciu \u00fadajov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/actiontech\/dtle\">dtle<\/a><\/noindex> \u2014 Distribuovan\u00e1 slu\u017eba na prenos \u00fadajov pre MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgsync\">pgsync<\/a><\/noindex> \u2014 Synchronizujte \u00fadaje Postgres medzi datab\u00e1zami.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/the4thdoctor\/pg_chameleon\">pg_chameleon<\/a><\/noindex> \u2014 Syst\u00e9m replik\u00e1cie MySQL do PostgreSQL nap\u00edsan\u00fd v Pythone 3. Syst\u00e9m pou\u017e\u00edva kni\u017enicu mysql-replication na z\u00edskavanie obrazov riadkov z MySQL, ktor\u00e9 s\u00fa ulo\u017een\u00e9 v PostgreSQL ako JSONB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/pgdeltastream\">PGDeltaStream<\/a><\/noindex> \u2014 Webov\u00fd server v Golangu na streamovanie zmien Postgres aspo\u0148 raz cez websockety, vyu\u017e\u00edvaj\u00faci funkciu logick\u00e9ho dek\u00f3dovania PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndQuadrant\/repmgr\">repmgr<\/a><\/noindex> \u2014 Najpopul\u00e1rnej\u0161\u00ed spr\u00e1vca replik\u00e1ci\u00ed pre PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"scripts\">Skripty<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgexperts\/pgx_scripts\">pgx_scripts<\/a><\/noindex> \u2014 Kolekcia u\u017eito\u010dn\u00fdch skriptov na anal\u00fdzu a spr\u00e1vu datab\u00e1z, vytvoren\u00fdch na\u0161\u00edm t\u00edmom expertov na PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ioguix\/pgsql-bloat-estimation\">pgsql-bloat-estimation<\/a><\/noindex> \u2014 Dotazy na meranie \u0161tatistick\u00e9ho pre\u0165a\u017eenia v indexoch a tabu\u013ek\u00e1ch pre PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/depesz\/pgWikiDont\">pgWikiDont<\/a><\/noindex> \u2014 Test SQL, ktor\u00fd kontroluje, \u010di va\u0161a datab\u00e1za dodr\u017eiava pravidl\u00e1 z <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 U\u017eite\u010dn\u00e9 n\u00e1stroje pre PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/postgrescheatsheet.com\">Postgres cheat sheet<\/a><\/noindex> \u2014 U\u017eite\u010dn\u00e9 SQL skripty a pr\u00edkazy od .<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/NikolayS\/postgres_dba\">postgres_dba<\/a><\/noindex> \u2014 Ch\u00fdbaj\u00faci s\u00fabor u\u017eito\u010dn\u00fdch n\u00e1strojov pre DBA Postgres a v\u0161etk\u00fdch in\u017einierov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gist.github.com\/rgreenjr\/3637525\">postgres_queries_and_commands.sql<\/a><\/noindex> \u2014 U\u017eite\u010dn\u00e9 dotazy a pr\u00edkazy PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tanelpoder\/tpt-oracle\">TPT<\/a><\/noindex> \u2014 Tieto sqlplus skripty s\u00fa pre optimaliz\u00e1ciu v\u00fdkonu datab\u00e1zy Oracle a odstra\u0148ovanie probl\u00e9mov.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"monitoringstatisticsperfomance\">Monitorovanie\/\u0161tatistiky\/v\u00fdkon<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/akardapolov\/ASH-Viewer\">ASH Viewer<\/a><\/noindex> \u2014 Poskytuje grafick\u00fd poh\u013ead na d\u00e1ta akt\u00edvnej hist\u00f3rie session v r\u00e1mci Oracle a PostgreSQL DB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/monyog\">Monyog<\/a><\/noindex> \u2014 Bezagentov\u00fd a n\u00e1kladovo efekt\u00edvny n\u00e1stroj na monitorovanie MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/mssql-monitoring\">mssql-monitoring<\/a><\/noindex> \u2014 Monitorujte v\u00fdkon v\u00e1\u0161ho SQL Server na Linuxe pomocou collectd, InfluxDB a Grafana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products\/navicat-monitor\">Navicat Monitor<\/a><\/noindex> \u2014 Bezpe\u010dn\u00fd, jednoduch\u00fd a bezagentov\u00fd n\u00e1stroj na vzdialen\u00e9 monitorovanie servera, ktor\u00fd je nabit\u00fd siln\u00fdmi funkciami pre efekt\u00edvne monitorovanie.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/pmm\">Percona Monitoring and Management<\/a><\/noindex> \u2014 Open source platform for managing and monitoring v\u00fdkon MySQL a MongoDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pganalyze\/collector\">pganalyze collector<\/a><\/noindex> \u2014 Zberate\u013e \u0161tatist\u00edk pganalyze na zhroma\u017e\u010fovanie metr\u00edk a logov PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/postgres-ai\/postgres-checkup\">postgres-checkup<\/a><\/noindex> \u2014 N\u00e1stroj novej gener\u00e1cie na diagnostiku, ktor\u00fd umo\u017e\u0148uje pou\u017e\u00edvate\u013eom vykon\u00e1va\u0165 h\u013abkov\u00fa anal\u00fdzu zdravia datab\u00e1z Postgres.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/wrouesnel\/postgres_exporter\">postgres_exporter<\/a><\/noindex> \u2014 Export\u00e9r Prometheus pre metriky servera PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgdash.io\">pgDash<\/a><\/noindex> \u2014 Meranie a sledovanie ka\u017ed\u00e9ho aspektu va\u0161ich datab\u00e1z PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pghero\">PgHero<\/a><\/noindex> \u2014 Dashboard v\u00fdkonu pre Postgres \u2014 kontroly zdravia, navr\u017een\u00e9 indexy a \u010fal\u0161ie.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rapidloop\/pgmetrics\">pgmetrics<\/a><\/noindex> \u2014 Zhroma\u017e\u010fuje a zobrazuje inform\u00e1cie a \u0161tatistiky z be\u017eiaceho servera PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgmustard.com\">pgMustard<\/a><\/noindex> \u2014 U\u017e\u00edvate\u013esk\u00e9 rozhranie pre pl\u00e1ny vysvetlenia Postgres, plus rady na zlep\u0161enie v\u00fdkonu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gleu\/pgstats\">pgstats<\/a><\/noindex> \u2014 Zhroma\u017e\u010fuje \u0161tatistiky PostgreSQL a bu\u010f ich uklad\u00e1 do CSV s\u00faborov, alebo ich vypisuje na stdout.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cybertec-postgresql\/pgwatch2\">pgwatch2<\/a><\/noindex> \u2014 Flexibiln\u00e9 samostatn\u00e9 rie\u0161enie na monitorovanie\/metriky PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/influxdata\/telegraf\/tree\/master\/plugins\/inputs\/postgresql\">Telegraf PostgreSQL plugin<\/a><\/noindex> \u2014 Poskytuje metriky pre va\u0161u datab\u00e1zu postgres.<\/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 Monitorovac\u00ed agent pre PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.smartmarmot.com\/wiki\/index.php?title=Orabbix\">Orabbix<\/a><\/noindex> \u2014 Orabbix je plugin navrhnut\u00fd na pr\u00e1cu so Zabbix Enterprise Monitor na poskytovanie mnohovrstvov\u00e9ho monitorovania, spr\u00e1vy v\u00fdkonu a dostupnosti pre Oracle datab\u00e1zy, spolu s metrikami v\u00fdkonu servera.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pg-monz\/pg_monz\">pg_monz<\/a><\/noindex> \u2014 Toto je monitorovacia \u0161abl\u00f3na Zabbix pre datab\u00e1zu PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/bicofino\/Pyora\">Pyora<\/a><\/noindex> \u2014 Skript v Pythone na monitorovanie datab\u00e1z Oracle.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/anetrusov\/ZabbixDBA\">ZabbixDBA<\/a><\/noindex> \u2014 ZabbixDBA je r\u00fdchly, flexibiln\u00fd a neust\u00e1le sa vyv\u00edjaj\u00faci plugin na monitorovanie va\u0161ich RDBMS.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"testing\">Testovanie<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbfit\/dbfit\">DbFit<\/a><\/noindex> \u2014 R\u00e1mec na testovanie datab\u00e1z, ktor\u00fd podporuje jednoduch\u00fd testovo riaden\u00fd v\u00fdvoj v\u00e1\u0161ho datab\u00e1zov\u00e9ho k\u00f3du.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dimitri\/regresql\">RegreSQL<\/a><\/noindex> \u2014 Regresn\u00e9 testovanie va\u0161ich SQL dotazov.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"data-generator\">Gener\u00e1tor d\u00e1t<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/benerator\">Databene Benerator<\/a><\/noindex> \u2014 Ide o r\u00e1mec na generovanie realistick\u00fdch a platn\u00fdch testovac\u00edch d\u00e1t v vysok\u00fdch objemoch pre v\u00e1\u0161 testovan\u00fd syst\u00e9m (vyh\u00fdbanie sa anti-patr\u00f3ne Datalite).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/data-generator\">dbForge Data Generator for MySQL<\/a><\/noindex> \u2014 Siln\u00fd GUI n\u00e1stroj na vytv\u00e1ranie mas\u00edvneho objemu realistick\u00fdch testovac\u00edch d\u00e1t.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/data-generator\">dbForge Data Generator for Oracle<\/a><\/noindex> \u2014 Mal\u00fd, ale mocn\u00fd GUI n\u00e1stroj na zaplnenie sch\u00e9m Oracle obrovsk\u00fdm mno\u017estvom realistick\u00fdch testovac\u00edch d\u00e1t.<\/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 Siln\u00fd GUI n\u00e1stroj na r\u00fdchlu gener\u00e1ciu zmyslupln\u00fdch testovac\u00edch d\u00e1t pre datab\u00e1zy.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"administration\">Administr\u00e1cia<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dalibo\/pgbadger\">pgbadger<\/a><\/noindex> \u2014 R\u00fdchly analyz\u00e1tor logov PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Squarespace\/pgbedrock\">pgbedrock<\/a><\/noindex> \u2014 Spravujte role, role \u010dlenstv\u00e1, vlastn\u00edctvo sch\u00e9my a privilegium clusters PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgslice\">pgslice<\/a><\/noindex> \u2014 Rozdelenie Postgres tak jednoduch\u00e9, ako kol\u00e1\u010d.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"hafailoversharding\">HA\/failover\/rozdelenie<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/citus\">Citus<\/a><\/noindex> \u2014 Roz\u0161\u00edrenie Postgres, ktor\u00e9 distribuuje va\u0161e d\u00e1ta a dotazy po viacer\u00fdch uzloch.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/patroni\">patroni<\/a><\/noindex> \u2014 \u0160abl\u00f3na pre vysok\u00fa dostupnos\u0165 PostgreSQL so ZooKeeper, etcd alebo Consul.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/percona-xtradb-cluster\">Percona XtraDB Cluster<\/a><\/noindex> \u2014 Rie\u0161enie vysok\u00e9 dostupnosti pre klustrovanie MySQL a vysok\u00fa dostupnos\u0165.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sorintlab\/stolon\">stolon<\/a><\/noindex> \u2014 Spr\u00e1vca PostgreSQL nat\u00edvny pre cloud pre vysok\u00fa dostupnos\u0165 PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/pg_auto_failover\">pg_auto_failover<\/a><\/noindex> \u2014 Roz\u0161\u00edrenie a slu\u017eba Postgres pre automatizovan\u00fd failover a vysok\u00fa dostupnos\u0165.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/aiven\/pglookout\">pglookout<\/a><\/noindex> \u2014 Monitorovanie replik\u00e1cie PostgreSQL a daemon na failover.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClusterLabs\/PAF\">PostgreSQL Automatic Failover<\/a><\/noindex> \u2014 Vysok\u00e1 dostupnos\u0165 pre Postgres, zalo\u017een\u00e1 na priemyseln\u00fdch referenci\u00e1ch Pacemaker a Corosync.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitabaks\/postgresql_cluster\">postgresql_cluster<\/a><\/noindex> \u2014 Vysokodostupnostn\u00fd cluster PostgreSQL (na z\u00e1klade \"Patroni\" a \"DCS(etcd)\"). Automatiz\u00e1cia nasadenia s Ansible.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitessio\/vitess\">Vitess<\/a><\/noindex> \u2014 Syst\u00e9m klustrovania datab\u00e1z pre horizont\u00e1lne \u0161k\u00e1lovanie MySQL prostredn\u00edctvom generalizovan\u00e9ho shardingu.<\/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 U\u013eah\u010denie prev\u00e1dzky datab\u00e1z v produk\u010dnej kvalite na Kubernetes.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/postgres-operator\">Postgres operator<\/a><\/noindex> \u2014 Postgres Operator umo\u017e\u0148uje vysoko dostupn\u00e9 klastre PostgreSQL na Kubernetes (K8s) poh\u00e1\u0148an\u00e9 Patroni.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/spilo\">Spilo<\/a><\/noindex> \u2014 HA PostgreSQL klustre s Dockerom.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/ongresinc\/stackgres\">StackGres<\/a><\/noindex> \u2014 Podnikov\u00fd pln\u00fd stoh PostgreSQL na Kubernetes.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"configuration-tuning\">Ladenie konfigur\u00e1cie<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/major\/MySQLTuner-perl\">MySQLTuner-perl<\/a><\/noindex> \u2014 Skript nap\u00edsan\u00fd v Perle, ktor\u00fd v\u00e1m umo\u017e\u0148uje r\u00fdchlo skontrolova\u0165 in\u0161tal\u00e1ciu MySQL a vykona\u0165 \u00fapravy na zv\u00fd\u0161enie v\u00fdkonu a stability.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgconfigurator.cybertec-postgresql.com\">PGConfigurator<\/a><\/noindex> \u2014 Bezplatn\u00fd online n\u00e1stroj na generovanie optimalizovan\u00e9ho <code>postgresql.conf<\/code>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gregs1104\/pgtune\">pgtune<\/a><\/noindex> \u2014 Sprievodca konfigur\u00e1ciou PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jfcoz\/postgresqltuner\">postgresqltuner.pl<\/a><\/noindex> \u2014 Jednoduch\u00fd skript na anal\u00fdzu konfigur\u00e1cie va\u0161ej datab\u00e1zy PostgreSQL a poskytovanie r\u00e1d na ladenie.<\/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> DBmaestro ur\u00fdch\u013euje procesy uvo\u013enenia a podporuje agilitu v celom IT ekosyst\u00e9me.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/products\/toad-devops-toolkit\/\">Toad DevOps Toolkit<\/a><\/noindex> Toad DevOps Toolkit vykon\u00e1va k\u013e\u00fa\u010dov\u00e9 funkcie v\u00fdvoja datab\u00e1z v r\u00e1mci v\u00e1\u0161ho DevOps pracovn\u00e9ho toku \u2014 bez ohrozenia kvality, v\u00fdkonu alebo spo\u013eahlivosti.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"schema-samples\">Uk\u00e1\u017eky sch\u00e9m<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/oracle\/db-sample-schemas\">Uk\u00e1\u017ekov\u00e9 sch\u00e9my datab\u00e1zy Oracle<\/a><\/noindex> Uk\u00e1\u017ekov\u00e9 sch\u00e9my datab\u00e1zy Oracle.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"reporting\">Reportovanie<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/shzlw\/poli\">Poli<\/a><\/noindex> Jednoduch\u00e1 aplik\u00e1cia na reportovanie SQL navrhnut\u00e1 pre milovn\u00edkov SQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"distributions\">Distrib\u00facie<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/datacharmer\/dbdeployer\">DBdeployer<\/a><\/noindex> N\u00e1stroj, ktor\u00fd jednoducho nasadzuje servery datab\u00e1z MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlcollaborative\/dbatools\">dbatools<\/a><\/noindex> Modul PowerShell, ktor\u00fd m\u00f4\u017eete pova\u017eova\u0165 za pr\u00edkazov\u00fd riadok SQL Server Management Studio.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgresApp\/PostgresApp\">Postgres.app<\/a><\/noindex> Kompletn\u00e1 in\u0161tal\u00e1cia PostgreSQL zabalen\u00e1 ako \u0161tandardn\u00e1 aplik\u00e1cia pre Mac.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\">BigSQL<\/a><\/noindex> Distrib\u00facia Postgres priate\u013esk\u00e1 pre v\u00fdvoj\u00e1rov.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/credativ\/elephant-shed\">Elephant Shed<\/a><\/noindex> Webov\u00e1 spr\u00e1va PostgreSQL so zoskupen\u00edm nieko\u013ek\u00fdch util\u00edt a aplik\u00e1ci\u00ed na pou\u017eitie s PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"security\">Bezpe\u010dnos\u0165<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cossacklabs\/acra\">Acra<\/a><\/noindex> \u2014 Bezpe\u010dnostn\u00fd bal\u00edk datab\u00e1z. Datab\u00e1zov\u00fd proxy so \u0161ifrovan\u00edm na \u00farovni pol\u00ed, vyh\u013ead\u00e1vanie v \u0161ifrovan\u00fdch d\u00e1tach, prevencia SQL injekci\u00ed, detekcia naru\u0161en\u00ed, honeypoty. Podporuje \u0161ifrovanie na strane klienta a proxy-side (\"transparentn\u00e9\"). SQL, NoSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-formatters\">Form\u00e1tova\u010de k\u00f3du<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/antlr\/codebuff\">CodeBuff<\/a><\/noindex> Jazykovo nez\u00e1visl\u00e9 pekn\u00e9 form\u00e1tovanie pomocou strojov\u00e9ho u\u010denia.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"contributing\">Prispievanie<\/h2>\n<p><\/p>\n<ul>\n<li>Va\u0161e pr\u00edspevky s\u00fa v\u017edy v\u00edtan\u00e9! Pros\u00edm, pre\u010d\u00edtajte si <noindex><a rel=\"nofollow\" href=\"http:\/\/contributing.md\">pokyny na pr\u00edspevky<\/a><\/noindex> najprv.<\/li>\n<\/ul>\n<p><\/p>\n<p>M\u00e1te n\u00e1lezy pre DB \u2014 pode\u013ete sa. Tie\u017e budem r\u00e1d za sp\u00e4tn\u00fa v\u00e4zbu \u2014 PR a hviezdi\u010dky. Ak m\u00e1te ot\u00e1zky t\u00fdkaj\u00face sa vytv\u00e1rania vlastn\u00fdch zoznamov \u2014 tie\u017e p\u00ed\u0161te.<\/p>\n<p>Zdroj: <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.4 - 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\/sk\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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\/sk\/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\u00da\u017easn\u00fd zoznam vlastnoru\u010dne, alebo GitHub namiesto zo\u0161ita | ProHoster","description":"Ahoj, Habr!","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/93089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=93089"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/93089\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/93090"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=93089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=93089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=93089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}