Moni, Habr! Mwinamwake, aliyense wa ife ali ndi fayilo yomwe timabisala chinthu chothandiza komanso chosangalatsa kwa ife tokha. Maulalo ena ku zolemba, mabuku, nkhokwe, zolemba. Awa akhoza kukhala ma bookmark a msakatuli kapenanso ma tabo otsegula omwe atsala mtsogolo. M'kupita kwa nthawi, zonsezi zimatupa, maulalo amasiya kutseguka, ndipo zida zambiri zimangokhala zachikale.

Bwanji ngati tigawana zabwinozi ndi anthu ammudzi ndikuyika fayiloyi pa GitHub? Ndiye ntchito yanu ikhoza kukhala yothandiza kwa wina, ndipo mutha kukhalabe ogwirizana pamodzi, kuvomereza zosintha kuchokera kwa iwo omwe akufuna kudzera ma PR abwino akale. Izi ndi zomwe polojekitiyi idapangidwira. Mndandanda wodabwitsa. Ikuphatikizidwa mu TOP 10 GitHub repositories, ili ndi nyenyezi za 138K, ndipo ulalo wantchito zanu ukhoza kuwonekera muzu wake README, womwe ungakope omvera ambiri kuntchito yanu. Zowona, izi zidzafuna kuyesetsa pang'ono. Ndikufuna kugawana nanu zomwe zandichitikira pakuchita izi.

Dzina langa ndine Maxim Gramin. Ku CROC ndimapanga Java Development and database research. Mu positi iyi ndikuuzani zomwe Awesome Lists ndi momwe mungapangire repo yanu yovomerezeka.

Kodi Awesome Lists ndi chiyani

Ndikayenera kudziwa ukadaulo watsopano kapena chilankhulo cha pulogalamu, chinthu choyamba chomwe ndimachita ndikupita apa - ndimapeza gawo loyenera, ndipo pali mapepala oyenera mmenemo. Ndipo potengera kuchuluka kwa nyenyezi ndi kukula kwawo kosalekeza, si ine ndekha amene ndimachita izi.

M'malo mwake, iyi ndi bala wamba readme.md, yomwe imakhala padera nkhokwe, ili pa nambala 8 pakati pa nkhokwe zonse za GitHub ndipo imaphatikizapo maulalo amasamba ena operekedwa pamutu uliwonse. Mwachitsanzo, mu gawo la Zinenero za Programming mutha kupeza masamba pa Awesome Python ndi Awesome Go, ndi Front-End Development ali ndi zida zambiri pakukula kwa WEB. Ndipo, ndithudi, - gawo zinasokoneza makompyuta (Tidzabweranso ku izi posachedwa). Ndipo inde, zonsezi sizingokhala mitu yaukadaulo. Mwachitsanzo, m'gawo la Zosangalatsa ndi Masewera mutha kupezanso zinthu zambiri zosangalatsa (ndinasangalala zodabwitsa-zongopeka).
Chinthu chachikulu ndi chakuti mapepala onsewa amasungidwa osati ndi wolemba payekha, koma ndi anthu ammudzi ndipo amapangidwa motsatira ndondomeko yapadera komanso yovuta kwambiri. kwambiri manifesto. Tsamba lililonse lotereli ndi gulu lodziyimira pawokha la akatswiri, limakhala moyo wawo lomwe ndipo limakhala lotseguka pazopempha zanu zomwe zingapangitse kuti zikhale zabwinoko. Komanso aliyense akhoza kupanga pepala lake ngati mutu wina sunafotokozedwe.

Wolemba lingaliro ndi wogwirizira bizinesi yonseyi ndi Sindre Sorhus wodziwika bwino, munthu woyamba pa GitHub, wolemba zambiri 1000 npm modules, ndipo ndi iye amene adzalandira ma PRs anu.

Momwe mungalowe mumndandanda wodabwitsa

Ngati mwadzidzidzi simunapeze pepala loyenera pamutu womwe umakusangalatsani, ndiye kuti ichi ndi chizindikiro choyamba chomwe muyenera kudzipangira nokha!

Ndidzakuuzani pogwiritsa ntchito chitsanzo cha ubongo wanga. Zida Zodabwitsa za Database - Kuchokera ku polojekiti kupita ku projekiti ndiyenera kugwira ntchito ndi nkhokwe zosiyanasiyana, ndichifukwa chake ndinayambitsa fayilo momwe ndidasonkhanitsa zida zothandiza zogwirira nawo ntchito, mitundu yonse ya osamukira ku database, ma IDE, mapanelo oyang'anira, zida zowunikira ndi mitundu yonse ya zinthu zosiyanasiyana. Zida zomwe ndakhala ndikugwiritsa ntchito kale kapena zomwe ndikukonzekera kuyamba kugwiritsa ntchito. Ndinagawana fayiloyi ndi anzanga ku CROC ndi kupitirira. Izi zinathandiza anthu ambiri ndipo zinali zosangalatsa. Chotsatira chake, ndinkafuna kutchuka kwambiri pamene tsiku lina ndinawona kuti mu gawo la Databases panalibe pepala pamutuwu. Ndipo ndinaganiza zoonjezera zanga kumeneko.

Kodi chofunikira ndi chiyani pamenepa?

1. Timalembetsa repo wamba wa GitHub wokhala ndi dzina ngati labwino-chilichonse. Kwa ine zinali zozizwitsa-database-zida
2. Timabweretsa pepala lathu kukhala labwino kwambiri, izi zitithandiza jenereta-zodabwitsa-mndandanda, yomwe idzapanga mafayilo onse ofunikira mumtundu wofunikira
3. Kukhazikitsa CI weniweni. zodabwitsa - lint ndipo travis ci itithandiza kulamulira kutsimikizika pepala lathu
4. Timadikirira masiku 30
5. Timawunikanso ma PR a anthu ena osachepera awiri
6. Ndipo pamapeto pake timapanga PR ku repo yayikulu, komwe timawonjezera ulalo ku repo yathu. Apa muyenera kuwerenga zonse mosamala ndikukwaniritsa zofunikira zonse za pepala latsopano ndi PR yokha.

Chophika changa choyamba zidakhala zotupa

Koma patapita nthawi, ndinasonkhanitsa zinthu zambiri, ndinayesetsa kulakwitsa ndipo ndinayesetsa kutero kuyesa kachiwiri.

Koma ndinayiwala za chinthu chofunika kwambiri, chimene chinandilozera mofatsa:

Sindinasamale kwambiri ndipo sindinawonjezere unicorn kuti nditsimikizire kuti zonse zakwaniritsidwa

Kenaka patapita nthawi pang'ono, kusintha pang'ono kutengera ndemanga, ndi zomwe zikuyembekezeredwa tweetkuti PR yanga idalandiridwa.

Kotero ine ndinakhala mlembi wa pepala langa loyamba, ndipo iwo anayamba kulandira PR ndi kuchokera kumudzi kuti muwonjezere zida zatsopano. Ndipo ambiri aiwo aphatikizidwa kale Zida Zodabwitsa za Database. Ngati ndinu waulesi kutsatira ulalo,

apa pali kusankha komwe kulipo panthawi yofalitsa positi

Zida Zodabwitsa za Database

Mndandanda woyendetsedwa ndi anthu wa zida za database

Apa tisonkhanitsa zambiri za zida zothandiza komanso zoyeserera zomwe zimasavuta ndi nkhokwe za DBA, DevOps, Madivelopa ndi anthu wamba.

Khalani omasuka kuwonjezera zambiri za zida zanu za db kapena zida zomwe mumakonda za gulu lachitatu.

Zamkatimu

• PANO
• Oyang'anira / Makasitomala a GUI
• Zida za CLI
• DB-schema navigation ndi zowonera
• Ojambula
• Zida zosamukira
• Zida zopangira ma code
• Wrappers
• Zida zosunga zobwezeretsera
• Replication/Data ntchito
• Makalata
• Monitoring/Statistics/Performance
  • Zabbix
• kuyezetsa
  • Jenereta wa data
• Administration
• HA/Failover/Sharding
• Kubernetes
• Kusintha Kusintha
• DevOps
• Zitsanzo za Schema
• lipoti
• Kupereka
• Security
• Opanga ma code

PANO

• AnySQL Maestro - Chida chachikulu choyang'anira ntchito zambiri pakuwongolera, kuwongolera ndi chitukuko.
• Aqua Data Studio - Aqua Data Studio ndi pulogalamu yopangira ma Database Developers, DBAs, ndi Analysts.
• Database.net - Chida chowongolera ma database angapo chothandizira 20+ nkhokwe.
• datagrip - Cross-Platform IDE for Databases & SQL by JetBrains.
• dbeaver - Woyang'anira database waulere wapadziko lonse lapansi ndi kasitomala wa SQL.
• dbForge Studio ya MySQL - Universal IDE ya MySQL ndi MariaDB kasamalidwe ka database, kasamalidwe, ndi kasamalidwe.
• dbForge Studio ya Oracle - IDE Yamphamvu pakuwongolera, kuyang'anira, ndi chitukuko cha Oracle.
• dbForge Studio ya PostgreSQL - Chida cha GUI chowongolera ndi kupanga nkhokwe ndi zinthu.
• dbForge Studio ya SQL Server - Chitukuko champhamvu chophatikizika cha chitukuko cha SQL Server, kasamalidwe, kasamalidwe, kusanthula deta, ndi malipoti.
• dbKodi - Yamakono (JavaScript/Electron framework), IDE yotseguka ya MongoDB. Ili ndi mawonekedwe othandizira chitukuko, kasamalidwe ndi kukonza magwiridwe antchito pama database a MongoDB.
• Katswiri wa IBE - Chida chokwanira cha GUI cha Firebird ndi InterBase.
• HeidiSQL - Makasitomala opepuka owongolera MySQL, MSSQL ndi PostgreSQL, olembedwa ku Delphi.
• mysql workbench - MySQL Workbench ndi chida cholumikizira cha omanga ma database, omanga, ndi ma DBA.
• navicat - Chida chopangira nkhokwe chomwe chimakupatsani mwayi wolumikizana nthawi imodzi ndi MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, ndi SQLite database kuchokera pa pulogalamu imodzi.
• Wolemba Oracle SQL - Oracle SQL Developer ndi malo aulere, ophatikizika otukuka omwe amathandizira kasamalidwe ka Oracle Database mumayendedwe achikhalidwe komanso a Cloud.
• pgAdmin - Malo otchuka kwambiri komanso olemera a Open Source oyang'anira ndi chitukuko cha PostgreSQL, database yapamwamba kwambiri ya Open Source padziko lonse lapansi.
• pgAdmin3 - Kuthandizira Kwanthawi yayitali kwa pgAdmin3.
• Wopanga PL/SQL - IDE yomwe imayang'ana makamaka pakupanga magawo osungidwa a Oracle Databases.
• PostgreSQL Maestro - Chida chathunthu komanso champhamvu choyang'anira database, choyang'anira ndi chitukuko cha PostgreSQL.
• Chida - Toad ndiye yankho loyambira la database kwa opanga, ma admins ndi osanthula deta. Sinthani zosintha zovuta za database ndi chida chimodzi choyang'anira database.
• Toad Edge - Chida chosavuta chopangira database cha MySQL ndi Postgres.
• TORA - TOra ndi gwero lotseguka la SQL IDE la Oracle, MySQL ndi PostgreSQL dbs.
• Situdiyo ya Valentina - Pangani, perekani, funsani ndi kufufuza Valentina DB, MySQL, MariaDB, PostgreSQL ndi SQLite database KWAULERE.

Oyang'anira / Makasitomala a GUI

• Wotsogolera - Kasamalidwe ka database mu fayilo imodzi ya PHP.
• Wowonongera - Chida cha Universal database cha opanga, ma DBA ndi owunika.
• Zithunzi za HouseOps - Enterprise ClickHouse Ops UI kuti muyankhe mafunso, kuyang'anira thanzi la ClickHouse ndikupangitsa ena ambiri kuganiza.
• JackDB - Kufikira kwachindunji kwa SQL kuzidziwitso zanu zonse, ziribe kanthu komwe kumakhala.
• OmniDB - Chida chapaintaneti chowongolera database.
• Pgweb - Msakatuli wapa intaneti wa PostgreSQL, wolembedwa mu Go ndikugwira ntchito pamakina a macOS, Linux ndi Windows.
• phpLiteAdmin - Chida choyang'anira database ya SQLite yochokera pa intaneti cholembedwa mu PHP mothandizidwa ndi SQLite3 ndi SQLite2.
• phpMyAdmin - Mawonekedwe a intaneti a MySQL ndi MariaDB.
• psequel - PSequel imapereka mawonekedwe oyera komanso osavuta kuti mugwire ntchito wamba za PostgreSQL mwachangu.
• PopSQL - Mkonzi wamakono, wothandizana wa SQL wa gulu lanu.
• Postico - Makasitomala Amakono a PostgreSQL a Mac.
• Robo 3T - Robo 3T (omwe kale anali Robomongo) ndi chida chowongolera cha MongoDB chokhazikika pa nsanja.
• Tsatirani Pro - Sequel Pro ndi pulogalamu yachangu, yosavuta kugwiritsa ntchito Mac yoyang'anira database yogwira ntchito ndi nkhokwe za MySQL & MariaDB.
• SQL Operations Studio - Chida chowongolera deta chomwe chimathandiza kugwira ntchito ndi SQL Server, Azure SQL DB ndi SQL DW kuchokera pa Windows, macOS ndi Linux.
• Katswiri wa SQLite - Mawonekedwe azithunzi amathandizira mawonekedwe onse a SQLite.
• sqlpad - Mkonzi wa SQL wozikidwa pa intaneti amayendetsa mumtambo wanu wachinsinsi.
• SQLPro - Woyang'anira wosavuta, wamphamvu wa Postgres wa macOS.
• SquirreL - Makasitomala a Graphical SQL olembedwa ku Java omwe angakupatseni mwayi wowona momwe nkhokwe yolumikizirana ndi JDBC, sakatulani zomwe zili pamatebulo, perekani malamulo a SQL etc.
• SQLTools - Kasamalidwe ka database kwa VSCode.
• SQLyog - Yathunthu komanso yosavuta kugwiritsa ntchito MySQL GUI.
• Tabix - SQL Editor & Open source intelligence yosavuta yamabizinesi a Clickhouse.
• GuluPlus - Chida chamakono, chachilengedwe, komanso chochezeka cha GUI pazosungidwa zaubale: MySQL, PostgreSQL, SQLite & zina.
• TeamPostgreSQL - PostgreSQL Web Administration GUI - gwiritsani ntchito nkhokwe zanu za PostgreSQL kuchokera kulikonse, ndi mawonekedwe a intaneti a AJAX olemera, othamanga kwambiri.

Zida za CLI

• ipython-sql - Lumikizani ku database kuti mupeze malamulo a SQL mkati mwa IPython kapena IPython Notebook.
• iredis - Cli ya Redis yokhala ndi AutoCompletion ndi Kuwunikira kwa Syntax.
• pgcenter - Chida choyang'ana chapamwamba cha PostgreSQL.
• pg_ntchito - Pamwamba ngati ntchito yowunikira zochitika za seva ya PostgreSQL.
• pg_pamwamba - 'pamwamba' kwa PostgreSQL.
• pspg -Postgres Pager
• sqlcl - Oracle SQL Developer Command Line (SQLcl) ndi mawonekedwe aulere a mzere wa Oracle Database.
• usql - Mawonekedwe a mzere wapadziko lonse lapansi wa PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, ndi ma database ena ambiri kuphatikiza NoSQL ndi nkhokwe zopanda ubale!

dbcli

• athenacl - AthenaCLI ndi chida cha CLI cha ntchito ya AWS Athena chomwe chimatha kumalizitsa ndi kuwunikira mawu.
• litecli - CLI ya ma Database a SQLite okhala ndi kumalizitsa komanso kuwunikira mawu.
• mssql-cli - Makasitomala a mzere wolamula wa SQL Server yokhala ndi kumalizitsa ndi kuwunikira mawu.
• mycli - Client Terminal Client ya MySQL yokhala ndi AutoCompletion ndi Syntax Highlighting.
• pgcli - Postgres CLI yokhala ndi kumalizitsa komanso kuwunikira mawu.
• vcli - Vertica CLI yokhala ndi kumalizitsa ndi kuwunikira mawu.

DB-schema navigation ndi zowonera

• dbdiagram.io - Chida chachangu komanso chosavuta chokuthandizani kujambula zithunzi zamaubwenzi anu ankhokwe ndikuyenda mwachangu pogwiritsa ntchito chilankhulo chosavuta cha DSL.
• ERAlchemy - Chida chopangira ma Entity Relation Diagrams.
• SchemaCrawler - Chida chaulere cha schema chaulere komanso chida chomvetsetsa.
• Schema Spy - Kupanga database yanu kukhala zolemba za HTML, kuphatikiza zojambula za Entity Relationship.
• tbls - Chida chothandizira CI cholembera nkhokwe, yolembedwa mu Go.

Ojambula

• Woyendetsa Zinthu wa Navicat - Chida champhamvu komanso chotsika mtengo chopangira database chomwe chimakuthandizani kuti mupange ma data apamwamba kwambiri, omveka bwino komanso owoneka bwino.
• Oracle SQL Developer Data Modeler - Oracle SQL Developer Data Modeler ndi chida chojambulira chaulere chomwe chimakulitsa zokolola komanso chimathandizira ntchito zofananira.
• pgmodeler - Chida chowonetsera deta chopangidwira PostgreSQL.

Zida zosamukira

• 2 basi - Chida chosinthira database-monga-code chomwe chimagwiritsa ntchito lingaliro lazolemba za DDL zopanda pake.
• njira yowulukira - Chida chosamuka cha database.
• uwu - Kusamuka kwa schema pa intaneti kwa MySQL.
• liquibase - Laibulale yodziyimira pawokha pa database yotsatirira, kuyang'anira ndikugwiritsa ntchito kusintha kwa schema ya database.
• amasamuka - Monga zosiyana koma za PostgreSQL schemas.
• node-pg-migrate - Kasamalidwe kakusamuka kwa database ya Node.js yopangidwira ma postgres okha. (Koma atha kugwiritsidwanso ntchito pa ma DB ena ogwirizana ndi SQL standard - mwachitsanzo CockroachDB.)
• Pyrseas - Imapereka zofunikira pofotokozera schema ya database ya PostgreSQL ngati YAML.
• SchemaHero - Wogwiritsa ntchito Kubernetes pakuwongolera schema database (gitops for database schemas).
• Skitch - Kuwongolera kosinthika kwa database-kwachilengedwe kwachitukuko chopanda chimango ndi kutumizidwa kodalirika.
• yuniql - Chida chinanso chosinthira schema ndi kusamuka chomwe changopangidwa ndi .NET Core 3.0+ ndipo mwachiyembekezo ndichabwino.

Zida zopangira ma code

• ddl-jenereta - Infers SQL DDL (Data Definition Language) kuchokera patebulo.
• ndondomeko2dl - Lamulirani mzere wotumizira kunja kwa Oracle schema kuti mukhazikitse zolemba za ddl init zokhoza kusefa zidziwitso zosafunikira, kulekanitsa DDL m'mafayilo osiyanasiyana, kutulutsa kokongola.

Wrappers

• Wotchuka - Tsamba lotseguka la REST API la mafoni, intaneti, ndi IoT.
• Injini ya Hasura GraphQL - Ma API a GraphQL achangu, anthawi yeniyeni pa Postgres okhala ndi njira zowongolera bwino, amayambitsanso ma webhooks pazochitika za database.
• jl-sql - SQL ya mitsinje ya JSON ndi CSV.
• mysql_fdw - PostgreSQL data yakunja kwa MySQL.
• Oracle REST Data Services - Pulogalamu ya Java yapakatikati, mamapu a ORDS amama verb za HTTP(S) (GET, POST, PUT, DELETE, etc.) ndikubweza zomwe zasinthidwa pogwiritsa ntchito JSON.
• Prisma - Prisma amasintha database yanu kukhala GraphQL API yeniyeni.
• Tumizani - REST API pa database iliyonse ya Postgres.
• chiwonetsero - Ndi njira yotumizira RESTful API kuchokera pazosungidwa zilizonse zolembedwa mu Go.
• restSQL - Jenereta ya SQL yokhala ndi Java ndi HTTP API, imagwiritsa ntchito RESTful HTTP API yokhala ndi XML kapena JSON serialization.
• resquel - Sinthani nkhokwe yanu ya SQL mosavuta kukhala REST API.
• mchenga 2 - Pangani zokha ntchito ya RESTful API pankhokwe yanu yacholowa.
• sql-boot - Advanced REST ndi UI wrapper pamafunso anu a SQL.

Zida zosunga zobwezeretsera

• pgbackrest - Zosungitsa Zodalirika za PostgreSQL & Bwezerani.
• Barman - Woyang'anira zosunga zobwezeretsera ndi Kubwezeretsa kwa PostgreSQL.

Replication/Data ntchito

• Seti ya data - Chida chofufuzira ndi kufalitsa deta.
• dtle - Distributed Data Transfer Service ya MySQL.
• pgsync - Gwirizanitsani data ya Postgres pakati pa nkhokwe.
• pg_chameleon - MySQL to PostgreSQL replica system yolembedwa mu Python 3. Dongosololi limagwiritsa ntchito laibulale ya mysql-replication kukoka zithunzi za mzere kuchokera ku MySQL zomwe zimasungidwa mu PostgreSQL monga JSONB.
• PGDeltaStream - Seva yapaintaneti ya Golang yosinthira Postgres imasintha kamodzi pamawebusayiti, pogwiritsa ntchito mawonekedwe a Postgres omveka bwino.
• repmgr - Woyang'anira Wodziwika Kwambiri Wobwereza wa PostgreSQL.

Makalata

• pgx_scripts - Zolemba zazing'ono zothandiza zowunikira ndikuwongolera ma database, opangidwa ndi gulu lathu ku PostgreSQL Akatswiri.
• pgsql-bloat-estimation - Mafunso oyezera kuchuluka kwa ziwerengero m'ma index ndi matebulo a PostgreSQL.
• pgWikiDont - Mayeso a SQL omwe amayang'ana ngati database yanu ikutsatira malamulo kuchokera https://wiki.postgresql.org/wiki/Don’t_Do_This.
• pg-zida - Zothandiza za PostgreSQL.
• Mapepala achinyengo a Postgres - Zothandiza SQL-scripts ndi malamulo ndi .
• postgres_dba - Zida zomwe zikusowa za Postgres DBAs ndi mainjiniya onse.
• postgres_queries_and_commands.sql - Mafunso Othandiza a PostgreSQL ndi Malamulo.
• TPT - Zolemba za sqlplus izi ndi za Oracle Database kukhathamiritsa & kuthetsa mavuto.

Monitoring/Statistics/Performance

• ASH Viewer - Imapereka chithunzithunzi chazomwe zikuchitika mu Oracle ndi PostgreSQL DB.
• Monyog - Chida Choyang'anira MySQL Chopanda Agent & Chotsika mtengo.
• mssql-kuwunika - Yang'anirani SQL Server yanu pa Linux ntchito pogwiritsa ntchito zosonkhanitsidwa, InfluxDB ndi Grafana.
• Navicat Monitor - Chida chotetezeka, chosavuta komanso chopanda ntchito chowunikira ma seva akutali chomwe chili ndi zinthu zamphamvu kuti kuwunika kwanu kukhale kogwira mtima momwe mungathere.
• Percona Monitoring ndi Management - Tsegulani nsanja yoyang'anira ndikuwunika magwiridwe antchito a MySQL ndi MongoDB.
• pganalyze wosonkhanitsa - Osonkhanitsa ziwerengero za Pganalyze kuti asonkhanitse ma metric a PostgreSQL ndi zipika.
• postgres-kufufuza - Chida chowunikira cham'badwo watsopano chomwe chimalola ogwiritsa ntchito kusanthula mozama za thanzi la ma database a Postgres.
• postgres_exporter - Wotumiza kunja kwa Prometheus kwa ma metric a seva ya PostgreSQL.
• pgDash - Yesani ndikutsata mbali zonse za nkhokwe yanu ya PostgreSQL.
• PgHero - Dashboard yogwira ntchito ya Postgres - macheke azaumoyo, ma index omwe aperekedwa, ndi zina zambiri.
• pgmetrics - Sungani ndikuwonetsa zambiri ndi ziwerengero kuchokera pa seva ya PostgreSQL yomwe ikuyenda.
• pgMustard - Mawonekedwe a ogwiritsa ntchito a Postgres amafotokoza mapulani, kuphatikiza maupangiri owongolera magwiridwe antchito.
• pgstats - Imasonkhanitsa ziwerengero za PostgreSQL, ndikuzisunga m'mafayilo a CSV kapena kuzisindikiza pa stdout.
• pgwat2 - Yosinthika yokhayokha ya PostgreSQL metrics monitoring/dashboarding solution.
• Pulogalamu ya Telegraf PostgreSQL - Amapereka ma metric a database yanu ya postgres.

Zabbix

• Mamonsu - Woyang'anira PostgreSQL.
• Orabbix - Orabbix ndi pulogalamu yowonjezera yomwe idapangidwa kuti igwire ntchito ndi Zabbix Enterprise Monitor kuti ipereke kuwunika kwamitundu ingapo, magwiridwe antchito ndi kupezeka komanso kuyeza kwa Oracle Databases, limodzi ndi ma metrics a seva.
• pg_mz - Ichi ndiye template yowunikira ya Zabbix ya PostgreSQL Database.
• Pyora - Python script kuyang'anira Oracle Databases.
• ZabbixDBA - ZabbixDBA ndiyofulumira, yosinthika, komanso imapanga pulogalamu yowonjezera kuti iwunikire RDBMS yanu.

kuyezetsa

• DbFit - Dongosolo loyesa nkhokwe lomwe limathandizira kukulitsa kosavuta koyeserera kwa khodi yanu ya database.
• RegreSQL - Regression Kuyesa mafunso anu a SQL.

Jenereta wa data

• Databene Benerator - Ndi chimango chopangira zoyeserera zenizeni komanso zovomerezeka zamakina apamwamba kwambiri pakompyuta yanu poyesedwa (kupewa mawonekedwe odana ndi Datalite).
• dbForge Data Generator kwa MySQL - Chida champhamvu cha GUI chopanga milingo yayikulu yamayeso oyeserera.
• dbForge Data Generator kwa Oracle - Chida chaching'ono koma champhamvu cha GUI chodzaza ma Oracle schemas okhala ndi matani a data yoyeserera.
• dbForge Data Generator ya SQL Server - Chida champhamvu cha GUI cham'badwo wofulumira wama data yoyesera yama database.

Administration

• pgbadger -PostgreSQL Log Analyzer yachangu.
• pgbedrock - Sinthani maudindo a gulu la Postgres, umembala, umwini wa schema, ndi mwayi.
• pgslice - Kugawa kwa Postgres kosavuta ngati chitumbuwa.

HA/Failover/Sharding

• Citus - Zowonjezera za Postgres zomwe zimagawa deta yanu ndi mafunso anu m'malo angapo.
• patroni - Template ya PostgreSQL High Kupezeka ndi ZooKeeper, etcd, kapena Consul.
• Percona XtraDB Cluster - A High Scalability Solution ya MySQL Clustering ndi Kupezeka Kwapamwamba.
• stolon - Woyang'anira wa Cloud wa PostgreSQL wa kupezeka kwakukulu kwa PostgreSQL.
• pg_auto_failover - Kukula kwa Postgres ndi ntchito zolephera zokha komanso kupezeka kwakukulu.
• pglookout - Kuwunika kubwereza kwa PostgreSQL ndi daemon ya failover.
• PostgreSQL Automatic Failover -Kupezeka Kwapamwamba kwa Postgres, kutengera maumboni amakampani Pacemaker ndi Corosync.
• postgresql_cluster - PostgreSQL High-Availability Cluster (yochokera pa "Patroni" ndi "DCS(etcd)"). Automating deployment ndi Ansible.
• Vitess - Dongosolo lophatikizira la database pakukulitsa kopingasa kwa MySQL kudzera mu sharding wamba.

Kubernetes

• KubeDB - Kupangitsa kuti nkhokwe zopanga zopanga zikhale zosavuta pa Kubernetes.
• Wothandizira wa Postgres - The Postgres Operator imathandizira magulu a PostgreSQL omwe amapezeka kwambiri pa Kubernetes (K8s) oyendetsedwa ndi Patroni.
• Masewera - Magulu a HA PostgreSQL okhala ndi Docker.
• Zithunzi za StackGres - Enterprise-grade, Full Stack PostgreSQL pa Kubernetes.

Kusintha Kusintha

• MySQLTuner-perl - Script yolembedwa ku Perl yomwe imakupatsani mwayi wowunikiranso kukhazikitsa kwa MySQL mwachangu ndikupanga zosintha kuti muwonjezere magwiridwe antchito ndi bata.
• PGConfigurator - Chida chaulere chapaintaneti kuti mupange kukhathamiritsa postgresql.conf.
• pgtune - PostgreSQL kasinthidwe wizard.
• postgresqltuner.pl - Zolemba zosavuta kusanthula kasinthidwe ka database yanu ya PostgreSQL, ndikupereka upangiri wokonzekera.

DevOps

• DBmaestro - DBmaestro imafulumizitsa kutulutsa & imathandizira kulimba mu chilengedwe chonse cha IT.
• Toad DevOps Toolkit - Toad DevOps Toolkit imagwira ntchito zazikuluzikulu zopangira nkhokwe mkati mwamayendedwe anu a DevOps - popanda kusokoneza mtundu, magwiridwe antchito kapena kudalirika.

Zitsanzo za Schema

• Oracle Database Sample Schemas - Zitsanzo za Oracle Database Schemas.

lipoti

• opukutidwa - Pulogalamu yosavuta kugwiritsa ntchito ya SQL yopangira okonda SQL.

Kupereka

• DBdeployer - Chida chomwe chimatumiza ma seva a MySQL database mosavuta.
• dbatools - PowerShell module yomwe mungaganizire ngati situdiyo yoyang'anira SQL Server Management.
• Postgres.app - Kuyika kwathunthu kwa PostgreSQL komwe kumayikidwa ngati pulogalamu yokhazikika ya Mac.
• BigSQL - Kugawa kochezeka kwa Postgres.
• Khodi la Njovu - Kumapeto kwapaintaneti kwa PostgreSQL koyang'anira komwe kumadzaza zida zingapo ndikugwiritsa ntchito ndi PostgreSQL.

Security

• Accra - Database chitetezo suite. Woyimira pa database wokhala ndi kubisa kwapamunda, fufuzani kudzera mu data yosungidwa, kupewa jakisoni wa SQL, kuzindikira kulowerera, miphika ya uchi. Imathandizira kubisa kwa kasitomala ndi proxy-side ("transparent"). SQL, NoSQL.

Opanga ma code

• CodeBuff - Language-agnostic wokongola-kusindikiza kudzera makina kuphunzira.

Kuthandiza

• Zopereka zanu ndizolandiridwa nthawi zonse! Chonde werengani malangizo othandizira choyamba.

Ngati muli ndi zomwe mwapeza pa database, chonde gawani. Ndidzakhalanso wokondwa kulandira mayankho - ma PR ndi nyenyezi. Ngati muli ndi mafunso okhudza kupanga mapepala anuanu, alembeninso.

Source: www.habr.com