{"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\/lv\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","title":{"rendered":"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" src=\"\/wp-content\/uploads\/2020\/09\/41d7ca428261b80f365797a19c547000.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Sveiki, Habr! Dro\u0161i vien, ka katram no mums ir t\u0101da datne, kur m\u0113s pieglab\u0101jam kaut ko noder\u012bgu un interesantu sev. Da\u017eas saites uz rakstiem, gr\u0101mat\u0101m, repozitorijiem, rokasgr\u0101mat\u0101m. Tas var b\u016bt p\u0101rl\u016bka gr\u0101matz\u012bmes vai pat vienk\u0101r\u0161i atv\u0113rtas cilnes, atst\u0101tas v\u0113l\u0101kam laikam. Ar laiku viss tas ataug, saites p\u0101rst\u0101j darboties, bet liela da\u013ca materi\u0101lu vienk\u0101r\u0161i noveco. <\/p>\n<p><\/p>\n<p>Bet ja dal\u012bsimies ar \u0161o saturu kopien\u0101 un aug\u0161upiel\u0101d\u0113sim \u0161o failu GitHub? Tad j\u016bsu darbs var b\u016bt noder\u012bgs citiem, un uztur\u0113t aktualit\u0101ti var kop\u012bgi, pie\u0146emot atjaunin\u0101jumus no tiem, kuri v\u0113las, izmantojot vecos labos PR. Tie\u0161i \u0161im nol\u016bkam ir paredz\u0113ts projekts <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">Awesome lists<\/a><\/noindex>. Tas ir iek\u013cauts TOP-10 repozitoriju sarakst\u0101 GitHub, tam ir 138K zvaig\u017e\u0146u, un saite uz j\u016bsu darbu var b\u016bt tie\u0161i t\u0101l\u0101k j\u016bsu galvenaj\u0101 README, kas piesaist\u012bs milz\u012bgu auditoriju j\u016bsu rado\u0161ajam darbam. Paties\u012bb\u0101, lai to izdar\u012btu, b\u016bs nedaudz j\u0101piestr\u0101d\u0101. Par savu pieredzi \u0161ajos centienos v\u0113los padal\u012bties ar jums. <\/p>\n<p><\/p>\n<p>Mans v\u0101rds ir Maksims Grami\u0146\u0161. KROP es nodarbojos ar Java izstr\u0101di un p\u0113t\u012bjumiem datub\u0101zu jom\u0101. \u0160aj\u0101 ierakst\u0101 es past\u0101st\u012b\u0161u, kas ir Awesome Lists un k\u0101 izveidot savu \u012bsto ofici\u0101lo awesome-repo.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"chto-takoe-awesome-lists\">Kas ir Awesome Lists<\/h2>\n<p><\/p>\n<p>Kad man j\u0101izp\u0113ta k\u0101da jauna tehnolo\u0123ija vai programm\u0113\u0161anas valoda, es vispirms dodos tie\u0161i \u0161eit \u2014 atrodam vajadz\u012bgo sada\u013cu, un taj\u0101 piem\u0113rotos sarakstus. Un, \u0146emot v\u0113r\u0101 zvaig\u017e\u0146u skaitu un to past\u0101v\u012bgo pieaugumu, t\u0101 daru ne tikai es.<br \/>\n<img decoding=\"async\" alt=\"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" src=\"\/wp-content\/uploads\/2020\/09\/383d1f4d5126fe2a11d449cf5e83b576.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Paties\u012bb\u0101 \u2014 tas ir parasts plakanas readme.md, kas eksist\u0113 atsevi\u0161\u0137\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\">repozitorij\u0101<\/a><\/noindex>, ie\u0146emot 8. vietu starp visiem GitHub re\u0123istriem un ietverot saites uz citiem sarakstiem, kas velt\u012bti k\u0101dai t\u0113mai. Piem\u0113ram, programm\u0113\u0161anas valodu sada\u013c\u0101 var atrast sarakstus Awesome Python un Awesome Go, savuk\u0101rt Front-End Development ir milz\u012bgs resursu apjoms WEB izstr\u0101dei. Un, protams, \u2014 sada\u013ca <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome#databases\">Databases<\/a><\/noindex> (uz to m\u0113s v\u0113l atgriez\u012bsimies nedaudz v\u0113l\u0101k). Un j\u0101, viss \u0161is neierobe\u017eojas tikai ar tehnisk\u0101m t\u0113m\u0101m. Piem\u0113ram, sada\u013c\u0101s Izklaide un Sp\u0113les ar\u012b var atrast daudz interesanta (mani person\u012bgi iepriecin\u0101ja <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/RichardLitt\/awesome-fantasy\">awesome-fantasy<\/a><\/noindex>).<br \/>\nGalven\u0101 iez\u012bme ir t\u0101, ka visi \u0161ie saraksti tiek veidoti nevis person\u012bgi no autora puses, bet gan kopienas un sast\u0101d\u012bti saska\u0146\u0101 ar \u012bpa\u0161u un \u013coti stingru <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/blob\/main\/awesome.md\">awesome manifestu<\/a><\/noindex>. Katrs \u0161\u0101ds saraksts ir patst\u0101v\u012bga speci\u0101listu kopiena, dz\u012bvo savu dz\u012bvi un ir atv\u0113rts j\u016bsu pull requestiem, kas to padar\u012bs v\u0113l lab\u0101ku. Ikviens, kas v\u0113las, var izveidot savu sarakstu, ja k\u0101da t\u0113ma v\u0113l nav apskat\u012bta.<\/p>\n<p><\/p>\n<p>Idejas autors un visa \u0161\u012b pas\u0101kuma koordinators ir le\u0123end\u0101rais Sindre Sorhus, <noindex><a rel=\"nofollow\" href=\"https:\/\/gitstar-ranking.com\/users\">pirmais cilv\u0113ks GitHub<\/a><\/noindex>, autora vair\u0101k nek\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.npmjs.com\/~sindresorhus\">1000 npm modu\u013cu,<\/a><\/noindex>un tie\u0161i vi\u0146\u0161 pie\u0146ems j\u016bsu PR.<br \/>\n<img decoding=\"async\" alt=\"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" 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\">K\u0101 non\u0101kt awesome-list<\/h2>\n<p><\/p>\n<p>Ja nu j\u016bs neatrad\u0101t piem\u0113rotu sarakstu par jums interes\u0113jo\u0161o t\u0113mu, tad tas ir pirmais sign\u0101ls, ka to j\u0101izveido pa\u0161am!<\/p>\n<p><\/p>\n<p>Past\u0101st\u012b\u0161u uz sava projekti\u0146a piem\u0113ra <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools<\/a><\/noindex> \u2014 no projekta uz projektu man n\u0101kas str\u0101d\u0101t ar visda\u017e\u0101d\u0101kaj\u0101m datub\u0101z\u0113m, un t\u0101p\u0113c man rad\u0101s \u0161\u0101ds failis, kur\u0101 es v\u0101cu noder\u012bgas r\u012bkus darbam ar t\u0101m, vis\u0101das datub\u0101\u017eu migr\u0101cijas, IDE, administr\u0101cijas pane\u013ci, uzraudz\u012bbas r\u012bki un vis\u0101di cit\u0101di. R\u012bki, kurus es jau izmantoju vai tikai pl\u0101noju s\u0101kt lietot. Es dal\u012bjos ar \u0161o failu ar kol\u0113\u0123iem KROK un aiz t\u0101 robe\u017e\u0101m. Tas \u013coti daudziem pal\u012bdz\u0113ja un bija interesanti. Galu gal\u0101 es v\u0113l\u0113jos liel\u0101ku slavu, kad k\u0101du reizi iev\u0113roju, ka sada\u013c\u0101 Databases tie\u0161i nav saraksta par \u0161o t\u0113mu. Un es nol\u0113mu pievienot tur savu. <\/p>\n<p><\/p>\n<p><strong>Ko tam vajag?<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>Re\u0123istr\u0113jam parasto GitHub repozitoriju ar nosaukumu awesome-kaut kas. Man\u0101 gad\u012bjum\u0101 t\u0101 bija awesome-database-tools.<\/li>\n<li>P\u0101rveidojam savu sarakstu awesome form\u0101t\u0101, \u0161aj\u0101 mums pal\u012bdz\u0113s <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dar5hak\/generator-awesome-list\">generator-awesome-list,<\/a><\/noindex>kas \u0123ener\u0113s visus nepiecie\u0161amos failus vajadz\u012bgaj\u0101 form\u0101t\u0101.<\/li>\n<li>Iestat\u0101m \u012bstu CI. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome-lint\">awesome-lint<\/a><\/noindex> un travis ci pal\u012bdz\u0113s mums uzraudz\u012bt <noindex><a rel=\"nofollow\" href=\"https:\/\/travis-ci.org\/github\/mgramin\/awesome-db-tools\">saraksta<\/a><\/noindex> validit\u0101ti.<\/li>\n<li>Gaid\u0101m 30 dienas. <\/li>\n<li>Veicam p\u0101rskatu vismaz par 2 citu PR<\/li>\n<li>Un visbeidzot veicam PR galvenaj\u0101 repozitorij\u0101, kur pievienojam saiti uz savu repozitoriju. \u0160eit ir j\u0101izlasa viss uzman\u012bgi un r\u016bp\u012bgi j\u0101izpilda visi daudzie nosac\u012bjumi jaunajam sarakstam un pa\u0161am PR.<\/li>\n<\/ol>\n<p><\/p>\n<p>Mans pirmais b\u013cins <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1336\">izr\u0101d\u012bj\u0101s k\u013c\u016bda.<\/a><\/noindex><br \/>\n<img decoding=\"async\" alt=\"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" src=\"\/wp-content\/uploads\/2020\/09\/196dd3f494d5e91eaa7af49e16f74393.jpeg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nBet pag\u0101ja nedaudz laika, es sav\u0101cu v\u0113l vair\u0101k materi\u0101lu, str\u0101d\u0101ju pie k\u013c\u016bd\u0101m un uzdro\u0161in\u0101jos uz <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sindresorhus\/awesome\/pull\/1679\">otro m\u0113\u0123in\u0101jumu.<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>Bet es aizmirsu par \u013coti svar\u012bgu lietu, par ko man maigi nor\u0101d\u012bja:<br \/>\n<img decoding=\"async\" alt=\"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" src=\"\/wp-content\/uploads\/2020\/09\/0ec0a33b3c7bb15b6cce6bf076208f09.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Es nebija \u013coti uzman\u012bgs un nepievienoju vienradzi k\u0101 apstiprin\u0101jumu tam, ka visi nosac\u012bjumi ir izpild\u012bti.<br \/>\n<img decoding=\"async\" alt=\"Awesome saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" src=\"\/wp-content\/uploads\/2020\/09\/3a69eb82ca26310c78bf5f6c3c8ef383.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>P\u0113c tam pag\u0101ja v\u0113l nedaudz laika, v\u0113l nedaudz labojumu p\u0113c nor\u0101d\u0113m, un par\u0101d\u012bj\u0101s gaid\u012btais <noindex><a rel=\"nofollow\" href=\"https:\/\/twitter.com\/awesome__re\/status\/1246779641475424256\">tv\u012bts,<\/a><\/noindex>ka mans PR tika pie\u0146emts.<\/p>\n<p><\/p>\n<p>T\u0101 es k\u013cuvu par sava pirm\u0101 saraksta autoru, un man s\u0101ka n\u0101kt <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools\/pulls?q=is%3Apr+is%3Aclosed\">PR<\/a><\/noindex> no kopienas par jaunu r\u012bku pievieno\u0161anu. Un daudzi no tiem jau ir iek\u013cauti <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mgramin\/awesome-db-tools#readme\">Awesome Database Tools<\/a><\/noindex>. Ja negribas doties uz saiti, <\/p>\n<p><\/p>\n<p>                        <b class=\"spoiler_title\">l\u016bk aktu\u0101ls saraksts public\u0113\u0161anas br\u012bd\u012b<\/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 saraksts ar sav\u0101m rok\u0101m, vai GitHub viet\u0101 piez\u012bmju gr\u0101mati\u0146a\" src=\"\/wp-content\/uploads\/2020\/09\/2951c443e95e3c56f93fb685afed6115.jpeg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/h1>\n<p><\/p>\n<blockquote><p>Kopienas veidots datub\u0101zu r\u012bku saraksts<\/p><\/blockquote>\n<p>\u0160eit m\u0113s apkoposim inform\u0101ciju par br\u012bni\u0161\u0137\u012bgiem noder\u012bgiem un br\u012bni\u0161\u0137\u012bgiem eksperiment\u0101liem r\u012bkiem, kas atvieglo darbu ar datub\u0101z\u0113m DBA, DevOps, izstr\u0101d\u0101t\u0101jiem un parastiem cilv\u0113kiem.<\/p>\n<p><\/p>\n<p>Br\u012bvi pievienojiet inform\u0101ciju par sav\u0101m datub\u0101z\u0113m vai saviem m\u012b\u013c\u0101kajiem tre\u0161o pu\u0161u datub\u0101zu r\u012bkiem.<\/p>\n<p><\/p>\n<h2 id=\"contents\">Saturs<\/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 p\u0101rvaldnieki\/klienti<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#cli-tools\">CLI r\u012bki<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#db-schema-navigation-and-visualization\">DB-sh\u0113mas navig\u0101cija un vizualiz\u0101cija<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#modelers\">Model\u0113t\u0101ji<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#migration-tools\">Migr\u0101cijas r\u012bki<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-generation-tools\">Koda \u0123ener\u0113\u0161anas r\u012bki<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#wrappers\">Aptin\u0113ji<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#backup-tools\">Dubl\u0113\u0161anas r\u012bki<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#replicationdata-operation\">Replik\u0101cija\/datu oper\u0101cijas<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#scripts\">Skripti<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#monitoringstatisticsperfomance\">Uzraudz\u012bba\/statistika\/veiktsp\u0113ja<\/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\">Test\u0113\u0161ana<\/a><\/noindex>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"#data-generator\">Datu \u0123enerators<\/a><\/noindex><\/li>\n<\/ul>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#administration\">Administr\u0101cija<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#hafailoversharding\">HA\/nep\u0101rtraukt\u012bba\/segment\u0113\u0161ana<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#kubernetes\">Kubernetes<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#configuration-tuning\">Konfigur\u0101cijas uzlabo\u0161ana<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#devops\">DevOps<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#schema-samples\">Sh\u0113mas paraugi<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#reporting\">Zi\u0146o\u0161ana<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#distributions\">Izplat\u012bjumi<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#security\">Dro\u0161\u012bba<\/a><\/noindex><\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#code-formatters\">Koda format\u0113t\u0101ji<\/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 Vado\u0161ais visp\u0101r\u0113jais administr\u0113\u0161anas r\u012bks datub\u0101zu p\u0101rvald\u012bbai, kontrolei un izstr\u0101dei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.aquafold.com\/aquadatastudio\">Aqua Data Studio<\/a><\/noindex> \u2014 Aqua Data Studio ir produktivit\u0101tes programmat\u016bra datub\u0101zu izstr\u0101d\u0101t\u0101jiem, DBA un anal\u012bti\u0137iem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/fishcodelib.com\/Database.htm\">Database .net<\/a><\/noindex> \u2014 Daudzdatub\u0101zu p\u0101rvald\u012bbas r\u012bks ar atbalstu 20+ datub\u0101z\u0113m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jetbrains.com\/datagrip\">DataGrip<\/a><\/noindex> \u2014 KrCross-Platform IDE datub\u0101z\u0113m &amp; SQL no JetBrains.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbeaver\/dbeaver\">DBeaver<\/a><\/noindex> \u2014 Bezmaksas univers\u0101ls datub\u0101zu p\u0101rvaldnieks un SQL klients.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/studio\">dbForge Studio for MySQL<\/a><\/noindex> \u2014 Univers\u0101ls IDE MySQL un MariaDB datub\u0101zu izstr\u0101dei, p\u0101rvald\u012bbai un administr\u0113\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/studio\">dbForge Studio for Oracle<\/a><\/noindex> \u2014 Jaud\u012bgs IDE Oracle p\u0101rvald\u012bbai, administr\u0113\u0161anai un izstr\u0101dei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/postgresql\/studio\">dbForge Studio for PostgreSQL<\/a><\/noindex> \u2014 GUI r\u012bks datub\u0101zu un objektu p\u0101rvald\u012bbai un izstr\u0101dei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/sql\/studio\">dbForge Studio for SQL Server<\/a><\/noindex> \u2014 Jaud\u012bga integr\u0113ta izstr\u0101des vide SQL Server izstr\u0101dei, p\u0101rvald\u012bbai, administr\u0113\u0161anai, datu anal\u012bzei un zi\u0146o\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/SouthbankSoftware\/dbkoda\">dbKoda<\/a><\/noindex> \u2014 M\u016bsdienu (JavaScript\/Electron ietvaros), atv\u0113rt\u0101 koda IDE MongoDB. Tam ir funkcijas atbalst\u012bt izstr\u0101di, administr\u0113\u0161anu un snieguma uzlabo\u0161anu MongoDB datub\u0101z\u0113m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.ibexpert.net\/ibe\">IBExpert<\/a><\/noindex> \u2014 Visaptvero\u0161s GUI r\u012bks Firebird un InterBase.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HeidiSQL\/HeidiSQL\">HeidiSQL<\/a><\/noindex> \u2014 Viegls klients MySQL, MSSQL un PostgreSQL p\u0101rvald\u012b\u0161anai, rakst\u012bts Delphi valod\u0101.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mysql.com\/products\/workbench\">MySQL Workbench<\/a><\/noindex> \u2014 MySQL Workbench ir vienots vizu\u0101ls r\u012bks datub\u0101zu arhitektiem, izstr\u0101d\u0101t\u0101jiem un DBA.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products#navicat\">Navicat<\/a><\/noindex> \u2014 Datub\u0101zu izstr\u0101des r\u012bks, kas \u013cauj vienlaikus savienoties ar MySQL, MariaDB, SQL Server, Oracle, PostgreSQL un SQLite datub\u0101z\u0113m no vienas lietojumprogrammas.<\/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 ir bezmaksas, integr\u0113ta izstr\u0101des vide, kas vienk\u0101r\u0161o Oracle datub\u0101zu izstr\u0101di un p\u0101rvald\u012bbu gan tradicion\u0101los, gan m\u0101ko\u0146pakalpojumu izmantojumos.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgadmin.org\">pgAdmin<\/a><\/noindex> \u2014 Vispopul\u0101r\u0101k\u0101 un funkcij\u0101m bag\u0101t\u0101k\u0101 atv\u0113rt\u0101 koda administr\u0113\u0161anas un izstr\u0101des platforma PostgreSQL, visatt\u012bst\u012bt\u0101kajai atv\u0113rt\u0101 koda datub\u0101zei pasaul\u0113.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\/pgadmin3\">pgAdmin3<\/a><\/noindex> \u2014 Ilgtermi\u0146a atbalsts pgAdmin3.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.allroundautomations.com\/products\/pl-sql-developer\">PL\/SQL Developer<\/a><\/noindex> \u2014 IDE, kas ir \u012bpa\u0161i paredz\u0113ta Oracle datub\u0101zu uzglab\u0101tu programmu izstr\u0101dei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlmaestro.com\/products\/postgresql\/maestro\">PostgreSQL Maestro<\/a><\/noindex> \u2014 Pabeigta un jaud\u012bga datub\u0101zu p\u0101rvald\u012bbas, administr\u0113\u0161anas un izstr\u0101des r\u012bks PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/toad\/\">Toad<\/a><\/noindex> \u2014 Toad ir galvenais datub\u0101zu risin\u0101jums izstr\u0101d\u0101t\u0101jiem, administratoriem un datu anal\u012bti\u0137iem. P\u0101rvaldiet sare\u017e\u0123\u012btus datub\u0101zu izmai\u0146as ar vienu datub\u0101zu p\u0101rvald\u012bbas r\u012bku.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.toadworld.com\/products\/toad-edge\">Toad Edge<\/a><\/noindex> \u2014 Vienk\u0101r\u0161ots datub\u0101zu izstr\u0101des r\u012bks MySQL un Postgres.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tora-tool\/tora\">TOra<\/a><\/noindex> \u2014 TOra ir atv\u0113rt\u0101 koda SQL IDE Oracle, MySQL un PostgreSQL datub\u0101z\u0113m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.valentina-db.com\/en\/valentina-studio-overview\">Valentina Studio<\/a><\/noindex> \u2014 Izveidojiet, administr\u0113jiet, vaic\u0101jiet un apskatiet Valentina DB, MySQL, MariaDB, PostgreSQL un SQLite datub\u0101zes BEZMaksas.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"gui-managersclients\">GUI p\u0101rvaldnieki\/klienti<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vrana\/adminer\">Adminer<\/a><\/noindex> \u2014 Datub\u0101zu p\u0101rvald\u012bba vien\u0101 PHP fail\u0101.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.dbvis.com\">DbVisualizer<\/a><\/noindex> \u2014 Univers\u0101ls datub\u0101zu r\u012bks izstr\u0101d\u0101t\u0101jiem, DBA un anal\u012bti\u0137iem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/HouseOps\/HouseOps\">HouseOps<\/a><\/noindex> \u2014 Uz\u0146\u0113m\u0113jdarb\u012bbas ClickHouse Ops UI, kas \u013cauj veikt vaic\u0101jumus, uzraudz\u012bt ClickHouse st\u0101vokli un veikt daudz citu uzdevumu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.jackdb.com\">JackDB<\/a><\/noindex> \u2014 Tie\u0161\u0101 SQL piek\u013cuve visiem j\u016bsu datiem, neatkar\u012bgi no t\u0101, kur tie atrodas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/OmniDB\/OmniDB\">OmniDB<\/a><\/noindex> \u2014 T\u012bmek\u013ca r\u012bks datub\u0101zu p\u0101rvald\u012bbai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sosedoff\/pgweb\">Pgweb<\/a><\/noindex> \u2014 T\u012bmek\u013ca datub\u0101zu p\u0101rl\u016bkprogramma PostgreSQL, kas uzrakst\u012bta Go valod\u0101 un darbojas macOS, Linux un Windows ma\u0161\u012bn\u0101s.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.phpliteadmin.org\">phpLiteAdmin<\/a><\/noindex> \u2014 T\u012bmek\u013ca r\u012bks SQLite datub\u0101zu administr\u0113\u0161anai, kas uzrakst\u012bts PHP valod\u0101 un atbalsta SQLite3 un SQLite2.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/phpmyadmin\/phpmyadmin\">phpMyAdmin<\/a><\/noindex> \u2014 T\u012bmek\u013ca saskarne MySQL un MariaDB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.psequel.com\">psequel<\/a><\/noindex> \u2014 PSequel nodro\u0161ina skaidru un vienk\u0101r\u0161u saskarni, lai j\u016bs var\u0113tu veikt parastus PostgreSQL uzdevumus \u0101tri.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/popsql.com\">PopSQL<\/a><\/noindex> \u2014 M\u016bsdien\u012bgs, sadarb\u012bgs SQL redaktors j\u016bsu komandai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/eggerapps.at\/postico\">Postico<\/a><\/noindex> \u2014 M\u016bsdien\u012bga PostgreSQL klienta programma Mac datoriem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Studio3T\/robomongo\">Robo 3T<\/a><\/noindex> \u2014 Robo 3T (agr\u0101k Robomongo) ir shell-centrisks, daudzplatformu MongoDB p\u0101rvald\u012bbas r\u012bks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sequelpro\/sequelpro\">Sequel Pro<\/a><\/noindex> \u2014 Sequel Pro ir \u0101tra, lieto\u0161anai \u0113rt\u0101 Mac datub\u0101zu p\u0101rvald\u012bbas lietotne, kas str\u0101d\u0101 ar MySQL un MariaDB datub\u0101z\u0113m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\">SQL Operations Studio<\/a><\/noindex> \u2014 Datu p\u0101rvald\u012bbas r\u012bks, kas \u013cauj str\u0101d\u0101t ar SQL Server, Azure SQL DB un SQL DW no Windows, macOS un Linux.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.sqliteexpert.com\/index.html\">SQLite Expert<\/a><\/noindex> \u2014 Grafisk\u0101 saskarne atbalsta visas SQLite funkcijas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rickbergfalk\/sqlpad\">sqlpad<\/a><\/noindex> \u2014 T\u012bmek\u013ca SQL redaktors, kuru varat darbin\u0101t sav\u0101 priv\u0101taj\u0101 m\u0101kon\u012b.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.macpostgresclient.com\">SQLPro<\/a><\/noindex> \u2014 Vienk\u0101r\u0161s, jaud\u012bgs Postgres p\u0101rvaldnieks macOS.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/squirrel-sql\">SQuirreL<\/a><\/noindex> \u2014 Grafiskais SQL klients, kas uzrakst\u012bts Java, \u013cauj jums skat\u012bt JDBC sader\u012bgas datub\u0101zes strukt\u016bru, p\u0101rl\u016bkot datus tabul\u0101s, izsniegt SQL komandas utt.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/mtxr\/vscode-sqltools\">SQLTools<\/a><\/noindex> \u2014 Datub\u0101zu p\u0101rvald\u012bba VSCode.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/sqlyog\">SQLyog<\/a><\/noindex> \u2014 Vispiln\u012bg\u0101k\u0101 un viegli lietojam\u0101 MySQL GUI.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tabixio\/tabix\">Tabix<\/a><\/noindex> \u2014 SQL redaktors un atv\u0113rt\u0101 avota vienk\u0101r\u0161\u0101 biznesa inteli\u0123ence Clickhouse.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/TablePlus\/TablePlus\">TablePlus<\/a><\/noindex> \u2014 M\u016bsdien\u012bgs, viet\u0113jais un draudz\u012bgs GUI r\u012bks rel\u0101ciju datub\u0101z\u0113m: MySQL, PostgreSQL, SQLite un citiem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.teampostgresql.com\">TeamPostgreSQL<\/a><\/noindex> \u2014 PostgreSQL t\u012bmek\u013ca administr\u0101cijas GUI \u2014 izmantojiet savas PostgreSQL datub\u0101zes no jebkuras vietas, ar bag\u0101tu, zibens \u0101tru AJAX t\u012bmek\u013ca saskarni.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"cli-tools\">CLI r\u012bki<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ipython-sql\">ipython-sql<\/a><\/noindex> \u2014 Piek\u013c\u016bstiet datub\u0101zei, lai izsniegtu SQL komandas IPython vai IPython Notebook vid\u0113.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/laixintao\/iredis\">iredis<\/a><\/noindex> \u2014 Cli r\u012bks Redis ar autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/lesovsky\/pgcenter\">pgcenter<\/a><\/noindex> \u2014 Top tipam l\u012bdz\u012bgs administr\u0101cijas r\u012bks PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/julmon\/pg_activity\">pg_activity<\/a><\/noindex> \u2014 Top tipam l\u012bdz\u012bga lietojumprogramma PostgreSQL servera aktivit\u0101tes uzraudz\u012bbai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/markwkm\/pg_top\">pg_top<\/a><\/noindex> \u2014 'top' for 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) ir bezmaksas komandrindas saskarne Oracle datub\u0101zei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql\">usql<\/a><\/noindex> \u2014 Univers\u0101la komandrindas saskarne PostgreSQL, MySQL, Oracle datub\u0101zei, SQLite3, Microsoft SQL Server, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/xo\/usql#database-support\">un daudzas citas datub\u0101zes<\/a><\/noindex> ieskaitot NoSQL un ne-rel\u0101ciju datub\u0101zes!<\/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 ir CLI r\u012bks AWS Athena pakalpojumam, kas var dar\u012bt autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/litecli\">litecli<\/a><\/noindex> \u2014 CLI SQLite datub\u0101z\u0113m ar autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mssql-cli\">mssql-cli<\/a><\/noindex> \u2014 Komandrindas klients SQL Server ar autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/mycli\">mycli<\/a><\/noindex> \u2014 Termin\u0101la klients MySQL ar autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/pgcli\">pgcli<\/a><\/noindex> \u2014 Postgres CLI ar autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbcli\/vcli\">vcli<\/a><\/noindex> \u2014 Vertica CLI ar autom\u0101tisko pabeig\u0161anu un sintakses izcel\u0161anu.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"db-schema-navigation-and-visualization\">DB-sh\u0113mas navig\u0101cija un vizualiz\u0101cija<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/dbdiagram.io\">dbdiagram.io<\/a><\/noindex> \u2014 \u0100trs un vienk\u0101r\u0161s r\u012bks, kas pal\u012bdz jums uzz\u012bm\u0113t savus datub\u0101zu attiec\u012bbu diagrammas un pl\u016bsmu \u0101tri, izmantojot vienk\u0101r\u0161u DSL valodu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Alexis-benoist\/eralchemy\">ERAlchemy<\/a><\/noindex> \u2014 Entit\u0101\u0161u attiec\u012bbu diagrammu \u0123ener\u0113\u0161anas r\u012bks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemacrawler\/SchemaCrawler\">SchemaCrawler<\/a><\/noindex> \u2014 Bezmaksas datub\u0101zu sh\u0113mas atkl\u0101\u0161anas un izpratnes r\u012bks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemaspy\/schemaspy\">Schema Spy<\/a><\/noindex> \u2014 J\u016bsu datub\u0101zes HTML dokument\u0101cijas \u0123ener\u0113\u0161ana, tostarp entit\u0101\u0161u attiec\u012bbu diagrammas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/k1LoW\/tbls\">tbls<\/a><\/noindex> \u2014 CI-draudz\u012bgs r\u012bks datub\u0101zes dokument\u0113\u0161anai, uzrakst\u012bts Go valod\u0101.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"modelers\">Model\u0113t\u0101ji<\/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 Jaud\u012bgs un izmaksu efekt\u012bvs datub\u0101zu dizaina r\u012bks, kas pal\u012bdz jums izveidot augstas kvalit\u0101tes konceptu\u0101los, lo\u0123iskos un fiziskos datu mode\u013cus.<\/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 ir bezmaksas grafiskais r\u012bks, kas uzlabo produktivit\u0101ti un vienk\u0101r\u0161o datu model\u0113\u0161anas uzdevumus.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgmodeler\/pgmodeler\">pgmodeler<\/a><\/noindex> \u2014 Datu model\u0113\u0161anas r\u012bks, kas izstr\u0101d\u0101ts PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"migration-tools\">Migr\u0101cijas r\u012bki<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CourseOrchestra\/2bass\">2bass<\/a><\/noindex> \u2014 Datub\u0101zu konfigur\u0101cijas k\u0101 koda r\u012bks, kas izmanto idempotentu DDL skriptu koncepciju.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/flyway\/flyway\">flyway<\/a><\/noindex> \u2014 Datub\u0101zu migr\u0101cijas r\u012bks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/github\/gh-ost\">gh-ost<\/a><\/noindex> \u2014 Online sh\u0113mas migr\u0101cija MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/liquibase\/liquibase\">liquibase<\/a><\/noindex> \u2014 Datu b\u0101zei neatkar\u012bga bibliot\u0113ka datu b\u0101zu sh\u0113mas izmai\u0146u izseko\u0161anai, p\u0101rvald\u012b\u0161anai un piem\u0113ro\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/djrobstep\/migra\">migra<\/a><\/noindex> \u2014 L\u012bdz\u012bgi k\u0101 diff, bet PostgreSQL sh\u0113m\u0101m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/salsita\/node-pg-migrate\">node-pg-migrate<\/a><\/noindex> \u2014 Node.js datu b\u0101zu migr\u0101cijas p\u0101rvald\u012bba, kas izstr\u0101d\u0101ta tikai PostgreSQL. (Bet var tikt izmantota ar\u012b cit\u0101m datu b\u0101z\u0113m, kas atbilst SQL standartiem \u2014 piem\u0113ram, CockroachDB.)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/perseas\/Pyrseas\">Pyrseas<\/a><\/noindex> \u2014 Nodro\u0161ina r\u012bkus, lai aprakst\u012btu PostgreSQL datu b\u0101zes sh\u0113mu k\u0101 YAML.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/schemahero\/schemahero\">SchemaHero<\/a><\/noindex> \u2014 Kubernetes operators deklarat\u012bvas datu b\u0101zes sh\u0113mas p\u0101rvald\u012bbas nodro\u0161in\u0101\u0161anai (gitops datu b\u0101zes sh\u0113m\u0101m).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqitchers\/sqitch\">Sqitch<\/a><\/noindex> \u2014 Sapr\u0101t\u012bga datu b\u0101zei specifiska izmai\u0146u p\u0101rvald\u012bba bez ietvariem un uzticama izvieto\u0161ana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rdagumampan\/yuniql\">yuniql<\/a><\/noindex> \u2014 V\u0113l viena sh\u0113mas versiju un migr\u0101cijas r\u012bks, izstr\u0101d\u0101ts ar native .NET Core 3.0+ un, cerams, lab\u0101ks.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-generation-tools\">Koda \u0123ener\u0113\u0161anas r\u012bki<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/catherinedevlin\/ddl-generator\">ddl-generator<\/a><\/noindex> \u2014 Inference SQL DDL (Datu defin\u012bcijas valoda) no tabulu datiem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/qwazer\/scheme2ddl\">scheme2ddl<\/a><\/noindex> \u2014 Komandrindas r\u012bks, lai eksport\u0113tu Oracle sh\u0113mu uz DDL inicializ\u0101cijas skriptu komplektu ar sp\u0113ju filtr\u0113t nev\u0113lamo inform\u0101ciju, atsevi\u0161\u0137i sagatavot DDL da\u017e\u0101d\u0101s failos, skaist\u0101 form\u0101t\u0101.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"wrappers\">Aptin\u0113ji<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dreamfactorysoftware\/dreamfactory\">DreamFactory<\/a><\/noindex> \u2014 Atv\u0113rt\u0101 pirmkoda REST API backend mobilaj\u0101m, t\u012bmek\u013ca un IoT lietojumprogramm\u0101m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/graphql-engine\">Hasura GraphQL Engine<\/a><\/noindex> \u2014 \u0100trs, t\u016bl\u012bt\u0113js p\u0101rrealiz\u0113jams GraphQL API uz PostgreSQL ar s\u012bku piek\u013cuves kontroli, ar\u012b izsaucot webhooks datu b\u0101zes notikumu laik\u0101.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/avz\/jl-sql\">jl-sql<\/a><\/noindex> \u2014 SQL kombin\u0101cijai ar JSON un CSV pl\u016bsm\u0101m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/EnterpriseDB\/mysql_fdw\">mysql_fdw<\/a><\/noindex> \u2014 PostgreSQL \u0101r\u0113jais datu aplokas wrappers 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 Vid\u0113ja l\u012bme\u0146a Java lietojumprogramma, ORDS karte HTTP(S) darb\u012bbas (GET, POST, PUT, DELETE utt.) uz datu b\u0101zes transakcij\u0101m un atgrie\u017e jebk\u0101dus rezult\u0101tus JSON form\u0101t\u0101.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prismagraphql\/prisma\">Prisma<\/a><\/noindex> \u2014 Prisma p\u0101rv\u0113r\u0161 j\u016bsu datu b\u0101zi re\u0101llaika GraphQL API.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgREST\/postgrest\">PostgREST<\/a><\/noindex> \u2014 REST API jebkurai PostgreSQL datu b\u0101zei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/prest\/prest\">prest<\/a><\/noindex> \u2014 Veids, k\u0101 sniegt RESTful API no jebkur\u0101m datu b\u0101z\u0113m, kas rakst\u012btas Go.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/restsql\/restsql\">restSQL<\/a><\/noindex> \u2014 SQL \u0123eneratoru ar Java un HTTP API, izmantojot vienk\u0101r\u0161u RESTful HTTP API ar XML vai JSON serializ\u0101ciju.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/formio\/resquel\">resquel<\/a><\/noindex> \u2014 Viegli p\u0101rv\u0113rst j\u016bsu SQL datu b\u0101zi par REST API.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jeffknupp\/sandman2\">sandman2<\/a><\/noindex> \u2014 Autom\u0101tiski \u0123ener\u0113t RESTful API pakalpojumu j\u016bsu mantojuma datu b\u0101zei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/CrocInc\/sql-boot\">sql-boot<\/a><\/noindex> \u2014 Uzlabots REST un UI apvalks j\u016bsu SQL vaic\u0101jumiem.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"backup-tools\">Dubl\u0113\u0161anas r\u012bki<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pgbackrest\/pgbackrest\">pgbackrest<\/a><\/noindex> \u2014 Uzticama PostgreSQL dubl\u0113\u0161ana un atjauno\u0161ana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndquadrant-it\/barman\">BaRMan<\/a><\/noindex> \u2014 Dubl\u0113\u0161anas un atjauno\u0161anas p\u0101rvaldnieks PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"replicationdata-operation\">Replik\u0101cija\/datu oper\u0101cijas<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/simonw\/datasette\">Datasette<\/a><\/noindex> \u2014 R\u012bks datu izp\u0113tei un public\u0113\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/actiontech\/dtle\">dtle<\/a><\/noindex> \u2014 Distribu\u0113ts datu p\u0101rraides pakalpojums MySQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgsync\">pgsync<\/a><\/noindex> \u2014 Sinhroniz\u0113t Postgres datus starp datu b\u0101z\u0113m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/the4thdoctor\/pg_chameleon\">pg_chameleon<\/a><\/noindex> \u2014 MySQL uz PostgreSQL replik\u0101cijas sist\u0113ma, kas rakst\u012bta Python 3. Sist\u0113ma izmanto mysql-replication bibliot\u0113ku, lai ieg\u016btu rindu att\u0113lus no MySQL, kas tiek glab\u0101ti PostgreSQL k\u0101 JSONB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/hasura\/pgdeltastream\">PGDeltaStream<\/a><\/noindex> \u2014 Golang t\u012bmek\u013ca serveris, lai straum\u0113tu Postgres izmai\u0146as vismaz vienu reizi, izmantojot PostgreSQL lo\u0123isk\u0101s dekod\u0113\u0161anas funkcionalit\u0101ti.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/2ndQuadrant\/repmgr\">repmgr<\/a><\/noindex> \u2014 Vispopul\u0101r\u0101kais replik\u0101cijas p\u0101rvaldnieks PostgreSQL.<\/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 Noder\u012bgu mazu skriptu kolekcija datu b\u0101zes anal\u012bzei un administr\u0113\u0161anai, kas izstr\u0101d\u0101ti m\u016bsu komand\u0101 PostgreSQL ekspertiem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ioguix\/pgsql-bloat-estimation\">pgsql-bloat-estimation<\/a><\/noindex> \u2014 Vaic\u0101jumi, lai noteiktu statistiskos p\u0101rliekumus indeksos un tabul\u0101s PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/depesz\/pgWikiDont\">pgWikiDont<\/a><\/noindex> \u2014 SQL tests, kas p\u0101rbauda, vai j\u016bsu datu b\u0101ze iev\u0113ro noteikumus no <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 Noder\u012bgi PostgreSQL r\u012bki.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/postgrescheatsheet.com\">Postgres cheat sheet<\/a><\/noindex> \u2014 Noder\u012bgi SQL skripti un komandas no .<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/NikolayS\/postgres_dba\">postgres_dba<\/a><\/noindex> \u2014 Tr\u016bksto\u0161ais noder\u012bgu r\u012bku komplekts PostgreSQL DBA un visiem in\u017eenieriem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gist.github.com\/rgreenjr\/3637525\">postgres_queries_and_commands.sql<\/a><\/noindex> \u2014 Noder\u012bgi PostgreSQL vaic\u0101jumi un komandas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tanelpoder\/tpt-oracle\">TPT<\/a><\/noindex> \u2014 \u0160ie sqlplus skripti ir paredz\u0113ti Oracle datu b\u0101zes veiktsp\u0113jas optimiz\u0101cijai un probl\u0113mu nov\u0113r\u0161anai.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"monitoringstatisticsperfomance\">Uzraudz\u012bba\/statistika\/veiktsp\u0113ja<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/akardapolov\/ASH-Viewer\">ASH Viewer<\/a><\/noindex> \u2014 Nodro\u0161ina grafisku skat\u012bjumu uz akt\u012bvo sesiju v\u0113sturi datiem Oracle un PostgreSQL DB.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.webyog.com\/product\/monyog\">Monyog<\/a><\/noindex> \u2014 A\u0123entam neintervences un izmaksu efekt\u012bvs MySQL uzraudz\u012bbas r\u012bks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/microsoft\/mssql-monitoring\">mssql-monitoring<\/a><\/noindex> \u2014 Uzraudziet j\u016bsu SQL Server veiktsp\u0113ju Linux oper\u0113t\u0101jsist\u0113m\u0101, izmantojot collectd, InfluxDB un Grafana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.navicat.com\/en\/products\/navicat-monitor\">Navicat Monitor<\/a><\/noindex> \u2014 Dro\u0161a, vienk\u0101r\u0161a un beza\u0123enta t\u0101lvad\u012bbas servera uzraudz\u012bbas r\u012bks, kas ir bag\u0101ts ar jaud\u012bg\u0101m funkcij\u0101m, lai padar\u012btu j\u016bsu uzraudz\u012bbu p\u0113c iesp\u0113jas efekt\u012bv\u0101ku.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/pmm\">Percona Monitoring and Management<\/a><\/noindex> \u2014 Atv\u0113rt\u0101 koda platforma MySQL un MongoDB snieguma p\u0101rvald\u012b\u0161anai un uzraudz\u012b\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pganalyze\/collector\">pganalyze collector<\/a><\/noindex> \u2014 Pganalyze statistikas kolektors PostgreSQL metriku un \u017eurn\u0101ldatu v\u0101k\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/postgres-ai\/postgres-checkup\">postgres-checkup<\/a><\/noindex> \u2014 Jaun\u0101s paaudzes diagnostikas r\u012bks, kas \u013cauj lietot\u0101jiem veikt dzi\u013cu anal\u012bzi par Postgres datu b\u0101zu vesel\u012bbu.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/wrouesnel\/postgres_exporter\">postgres_exporter<\/a><\/noindex> \u2014 Prometheus eksport\u0113t\u0101js PostgreSQL servera metrik\u0101m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgdash.io\">pgDash<\/a><\/noindex> \u2014 M\u0113ra un izseko katru aspektu j\u016bsu PostgreSQL datu b\u0101z\u0113m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pghero\">PgHero<\/a><\/noindex> \u2014 Veiktsp\u0113jas panelis Postgres \u2014 vesel\u012bbas p\u0101rbaudes, ieteiktie indeksi un daudz kas cits.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rapidloop\/pgmetrics\">pgmetrics<\/a><\/noindex> \u2014 V\u0101c un att\u0113lo inform\u0101ciju un statistiku no darbojo\u0161\u0101s PostgreSQL servera.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.pgmustard.com\">pgMustard<\/a><\/noindex> \u2014 Lietot\u0101ja saskarne Postgres izskaidrojuma pl\u0101niem, k\u0101 ar\u012b padomi veiktsp\u0113jas uzlabo\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gleu\/pgstats\">pgstats<\/a><\/noindex> \u2014 V\u0101c PostgreSQL statistiku un vai nu saglab\u0101 to CSV failos, vai izdruk\u0101 uz stdout.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cybertec-postgresql\/pgwatch2\">pgwatch2<\/a><\/noindex> \u2014 Elast\u012bgs, pa\u0161pietiekams PostgreSQL metrikas uzraudz\u012bbas\/pane\u013ca risin\u0101jums.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/influxdata\/telegraf\/tree\/master\/plugins\/inputs\/postgresql\">Telegraf PostgreSQL plugin<\/a><\/noindex> \u2014 Nodro\u0161ina metriku par j\u016bsu postgres datu b\u0101zi.<\/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 Uzraugo\u0161ais a\u0123ents PostgreSQL.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/www.smartmarmot.com\/wiki\/index.php?title=Orabbix\">Orabbix<\/a><\/noindex> \u2014 Orabbix ir spraudnis, kas izstr\u0101d\u0101ts, lai str\u0101d\u0101tu ar Zabbix Enterprise Monitor, nodro\u0161inot vair\u0101ku l\u012bme\u0146u uzraudz\u012bbu, veiktsp\u0113jas un pieejam\u012bbas zi\u0146o\u0161anu un m\u0113r\u012bjumus Oracle datu b\u0101z\u0113m, k\u0101 ar\u012b servera veiktsp\u0113jas metrik\u0101m.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pg-monz\/pg_monz\">pg_monz<\/a><\/noindex> \u2014 Tas ir Zabbix uzraudz\u012bbas veidne PostgreSQL datu b\u0101zei.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/bicofino\/Pyora\">Pyora<\/a><\/noindex> \u2014 Python skripts Oracle datu b\u0101zu uzraudz\u012bbai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/anetrusov\/ZabbixDBA\">ZabbixDBA<\/a><\/noindex> \u2014 ZabbixDBA ir \u0101trs, elast\u012bgs un nep\u0101rtraukti att\u012bsto\u0161s spraudnis, lai uzraudz\u012btu j\u016bsu RDBMS.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"testing\">Test\u0113\u0161ana<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dbfit\/dbfit\">DbFit<\/a><\/noindex> \u2014 Datu b\u0101zu test\u0113\u0161anas ietvars, kas atbalsta vieglu testu vad\u012btu att\u012bst\u012bbu j\u016bsu datu b\u0101zes kodam.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dimitri\/regresql\">RegreSQL<\/a><\/noindex> \u2014 Atk\u0101rtotas p\u0101rbaudes j\u016bsu SQL vaic\u0101jumiem.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"data-generator\">Datu \u0123enerators<\/h3>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/sourceforge.net\/projects\/benerator\">Databene Benerator<\/a><\/noindex> \u2014 Tas ir ietvars, lai \u0123ener\u0113tu re\u0101listiskus un der\u012bgus liela apjoma test\u0113\u0161anas datus j\u016bsu test\u0113jamajai sist\u0113mai (izvair\u012b\u0161an\u0101s no Datalite pretparauga).<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/mysql\/data-generator\">dbForge Data Generator for MySQL<\/a><\/noindex> \u2014 Jaud\u012bgs GUI r\u012bks mas\u012bvu re\u0101listisku test\u0113\u0161anas datu rad\u012b\u0161anai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.devart.com\/dbforge\/oracle\/data-generator\">dbForge Data Generator for Oracle<\/a><\/noindex> \u2014 Mazs, bet jaud\u012bgs GUI r\u012bks Oracle sh\u0113mu piepild\u012b\u0161anai ar daudz re\u0101listiskiem test\u0113\u0161anas datiem.<\/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 Jaud\u012bgs GUI r\u012bks noz\u012bm\u012bgu test\u0113\u0161anas datu \u0101trai \u0123ener\u0113\u0161anai datu b\u0101z\u0113m.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"administration\">Administr\u0101cija<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/dalibo\/pgbadger\">pgbadger<\/a><\/noindex> \u2014 \u0100trs PostgreSQL \u017eurn\u0101la analizators.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Squarespace\/pgbedrock\">pgbedrock<\/a><\/noindex> \u2014 P\u0101rvaldiet PostgreSQL klastera lomas, lomu dal\u012bbas, sh\u0113mas pieder\u012bbu un privil\u0113\u0123ijas.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ankane\/pgslice\">pgslice<\/a><\/noindex> \u2014 Postgres sadal\u012b\u0161ana tik viegli k\u0101 p\u012br\u0101gs.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"hafailoversharding\">HA\/nep\u0101rtraukt\u012bba\/segment\u0113\u0161ana<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/citus\">Citus<\/a><\/noindex> \u2014 Postgres papla\u0161in\u0101jums, kas izklied\u0113 j\u016bsu datus un vaic\u0101jumus pa vair\u0101kiem mezgliem.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/patroni\">patroni<\/a><\/noindex> \u2014 Paraugs PostgreSQL augst\u0101kai pieejam\u012bbai ar ZooKeeper, etcd vai Consul.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/percona\/percona-xtradb-cluster\">Percona XtraDB Cluster<\/a><\/noindex> \u2014 Augstas m\u0113rogojam\u012bbas risin\u0101jums MySQL klasteriem un augstai pieejam\u012bbai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sorintlab\/stolon\">stolon<\/a><\/noindex> \u2014 Cloud native PostgreSQL p\u0101rvaldnieks PostgreSQL augstai pieejam\u012bbai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/citusdata\/pg_auto_failover\">pg_auto_failover<\/a><\/noindex> \u2014 Postgres papla\u0161in\u0101jums un pakalpojums automatiz\u0113tai pieejam\u012bbas nodro\u0161in\u0101\u0161anai un augstai pieejam\u012bbai.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/aiven\/pglookout\">pglookout<\/a><\/noindex> \u2014 PostgreSQL replic\u0113\u0161anas uzraudz\u012bba un atkop\u0161anas demonis.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClusterLabs\/PAF\">PostgreSQL Automatic Failover<\/a><\/noindex> \u2014 Augsta pieejam\u012bba Postgres, pamatojoties uz nozares atsauc\u0113m Pacemaker un Corosync.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitabaks\/postgresql_cluster\">postgresql_cluster<\/a><\/noindex> \u2014 PostgreSQL augstas pieejam\u012bbas klasteris (balst\u012bts uz \"Patroni\" un \"DCS(etcd)\"). Autom\u0101tiska izvieto\u0161ana ar Ansible.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/vitessio\/vitess\">Vitess<\/a><\/noindex> \u2014 Datu b\u0101zu klasteru sist\u0113ma, lai horizont\u0101li m\u0113rogotu MySQL, izmantojot visp\u0101r\u0113ju sadal\u012b\u0161anu.<\/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 Ra\u017eo\u0161anu gatavu datu b\u0101zu darb\u012bba Kubernetes platform\u0101 ir vienk\u0101r\u0161a.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/postgres-operator\">Postgres operator<\/a><\/noindex> \u2014 Postgres operators nodro\u0161ina augsti pieejamus PostgreSQL klasterus Kubernetes (K8s), ko jaudina Patroni.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/zalando\/spilo\">Spilo<\/a><\/noindex> \u2014 HA PostgreSQL klasteri ar Docker.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/gitlab.com\/ongresinc\/stackgres\">StackGres<\/a><\/noindex> \u2014 Uz\u0146\u0113m\u0113jdarb\u012bbas l\u012bme\u0146a, pilna kaudze PostgreSQL uz Kubernetes.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"configuration-tuning\">Konfigur\u0101cijas uzlabo\u0161ana<\/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 valod\u0101 sarakst\u012bts skripts, kas \u013cauj \u0101tri apskat\u012bt MySQL instal\u0101ciju un veikt piel\u0101gojumus, lai palielin\u0101tu veiktsp\u0113ju un stabilit\u0101ti.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/pgconfigurator.cybertec-postgresql.com\">PGConfigurator<\/a><\/noindex> \u2014 Bezmaksas tie\u0161saistes r\u012bks, lai \u0123ener\u0113tu optimiz\u0113tu <code>postgresql.conf<\/code>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/gregs1104\/pgtune\">pgtune<\/a><\/noindex> \u2014 PostgreSQL konfigur\u0101cijas r\u012bks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jfcoz\/postgresqltuner\">postgresqltuner.pl<\/a><\/noindex> \u2014 Vienk\u0101r\u0161s skripts, lai analiz\u0113tu j\u016bsu PostgreSQL datub\u0101zes konfigur\u0101ciju un sniegtu ieteikumus par uzlabo\u0161anu.<\/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 pa\u0101trina izlai\u0161anas ciklus un atbalsta elast\u012bbu vis\u0101 IT ekosist\u0113m\u0101.<\/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 veic galven\u0101s datub\u0101zu izstr\u0101des funkcijas j\u016bsu DevOps darba pl\u016bsm\u0101, nep\u0101rk\u0101pjot kvalit\u0101ti, veiktsp\u0113ju vai uzticam\u012bbu.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"schema-samples\">Sh\u0113mas paraugi<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/oracle\/db-sample-schemas\">Oracle Database Sample Schemas<\/a><\/noindex> \u2014 Oracle Database Sample Schemas.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"reporting\">Zi\u0146o\u0161ana<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/shzlw\/poli\">Poli<\/a><\/noindex> \u2014 Viegli lietojama SQL p\u0101rskatu lietotne, kas izstr\u0101d\u0101ta SQL m\u012b\u013cot\u0101jiem.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"distributions\">Izplat\u012bjumi<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/datacharmer\/dbdeployer\">DBdeployer<\/a><\/noindex> \u2014 R\u012bks, kas viegli instal\u0113 MySQL datub\u0101zes serverus.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlcollaborative\/dbatools\">dbatools<\/a><\/noindex> \u2014 PowerShell modulis, kuru varat uzskat\u012bt par komandrindas SQL Server Management Studio.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/PostgresApp\/PostgresApp\">Postgres.app<\/a><\/noindex> \u2014 Pilnas funkcionalit\u0101tes PostgreSQL instal\u0101cija, kas iepakota k\u0101 standarta Mac lietotne.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.bigsql.org\">BigSQL<\/a><\/noindex> \u2014 Izstr\u0101d\u0101t\u0101jam draudz\u012bga Postgres izplat\u012b\u0161ana.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/credativ\/elephant-shed\">Elephant Shed<\/a><\/noindex> \u2014 T\u012bmek\u013ca b\u0101z\u0113ta PostgreSQL p\u0101rvald\u012bbas saskarne, kas apvieno vair\u0101kas util\u012btas un lietotnes, lai izmantotu ar PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"security\">Dro\u0161\u012bba<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/cossacklabs\/acra\">Acra<\/a><\/noindex> \u2014 Datub\u0101zu dro\u0161\u012bbas komplekts. Datub\u0101zu starpprotokols ar lauka l\u012bme\u0146a \u0161ifr\u0113\u0161anu, mekl\u0113\u0161ana \u0161ifr\u0113tos datos, SQL injekciju nov\u0113r\u0161ana, uzbrukumu atkl\u0101\u0161ana, lentas. Atbalsta klienta puses un starpprotokola ('caursp\u012bd\u012bg\u0101') \u0161ifr\u0113\u0161anu. SQL, NoSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"code-formatters\">Koda format\u0113t\u0101ji<\/h2>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/antlr\/codebuff\">CodeBuff<\/a><\/noindex> \u2014 Valodas neatkar\u012bga skaisto izdruk\u0101\u0161ana, izmantojot ma\u0161\u012bnm\u0101c\u012b\u0161anos.<\/li>\n<\/ul>\n<p><\/p>\n<h2 id=\"contributing\">Ieguld\u012bjumi<\/h2>\n<p><\/p>\n<ul>\n<li>J\u016bsu ieguld\u012bjumi vienm\u0113r ir laipni gaid\u012bti! L\u016bdzu, izlasiet <noindex><a rel=\"nofollow\" href=\"http:\/\/contributing.md\">ieguld\u012bjumu vadl\u012bnijas<\/a><\/noindex> vispirms.<\/li>\n<\/ul>\n<p><\/p>\n<p>Ir atradumi datub\u0101z\u0113m \u2014 dalieties. T\u0101pat b\u016b\u0161u priec\u012bgs sa\u0146emt atsauksmes \u2014 PR un zvaigzn\u012btes. Ja ir jaut\u0101jumi par savu sarakstu veido\u0161anu \u2014 ar\u012b rakstiet.<\/p>\n<p>Avots: <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.5 - 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\/lv\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\/lv\/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\udd47Lielisks saraksts ar rok\u0101m, vai GitHub k\u0101 piez\u012bmju gr\u0101mati\u0146a | ProHoster","description":"Sveiki, Habr!","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/awesome-list-svoimi-rukami-ili-github-vmesto-bloknota","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/93089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=93089"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/93089\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media\/93090"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=93089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=93089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=93089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}