PgSQL Visual Manager

Turn L.L.C

Mayelana nalolu hlelo lokusebenza

I-PgSQL Visual Manager iyiklayenti le-PostgreSQL eligcwele izici elakhelwe onjiniyela, ama-DBA, kanye nonjiniyela bedatha abadinga indlela ehlanzekile nelula yokusebenzisa iselula yokuphatha izizindalwazi zabo — ngaphandle kokuthinta i-terminal.

Xhuma kunoma iyiphi iseva ye-PostgreSQL bese uhlola ama-schema akho, amathebula, kanye nokubukwa ngokushesha. Sebenzisa imibuzo ye-SQL engahluziwe ngomhleli ohlakaniphile, phequlula futhi uhlele imigqa ngokubona, bese uthumela imiphumela ngemizuzwana.

──────────────────────────────
🔌 UKUXHUMANA
───────────────────────────────────────
• Londoloza ukuxhumana okuningi okuqanjwe ngamagama ngamalebula ombala ngokwezifiso
• Ukusekelwa komhubhe we-SSH — xhuma ngeseva yokugxuma ngephasiwedi noma ukhiye oyimfihlo
• Ukubethela kwe-SSL/TLS ngezitifiketi zeklayenti ozikhethela (i-Root CA, i-Client Cert, i-Client Key)
• Hlola noma yikuphi ukuxhumana ngaphambi kokulondoloza
• Isitoreji semininingwane sendawo esivikelekile — amaphasiwedi akho awalokothi aphume kudivayisi yakho

──────────────────────────────────────
🗂️ I-DATABASE EXPLORER
──────────────────────────────────────
• Phequlula wonke ama-schema, amathebula, kanye nokubukwa kusakhiwo sebha eseceleni esihlanzekile
• Shintsha izizindalwazi ekuxhumaneni okusebenzayo ngaphandle kokuxhuma kabusha
• Hlunga amathebula nge-schema noma usesho ngegama ngesikhathi sangempela
• Umehluko obonakalayo phakathi kwamathebula nokubukwa
• Kwenzelwe kokubili osayizi besikrini sefoni nethebhulethi

─────────────────────────────────────────
📊 UMBUKELI WETABLE NOMHLELI
──────────────────────────────────────
• Igridi yedatha efakwe amakhasi angu-25 / 50 / 100 / 200 imigqa ngekhasi ngalinye
• Hlunga nganoma iyiphi ikholomu ngokuthepha okukodwa
• Hlunga imigqa usebenzisa ibha yesigaba se-WHERE — efana nethuluzi lakho ledeskithophu olithandayo
• Faka imigqa emisha ngezilawuli ezihlakaniphile ngekholomu ngayinye:
— Izikhethi zosuku, isikhathi, kanye nesikhathi samakholomu esikhashana
— Ukuguqula okungu-NULL kwezinkambu ezingasebenziseki
— Amakhibhodi ezinombolo ezinhlobo zezinombolo
— Izinkambu zokhiye eziyinhloko zikhiyiwe kwimodi yokuhlela
• Hlela futhi ususe imigqa ngokuqinisekisa
• Cindezela isikhathi eside noma yiliphi iseli ukuze ukopishe inani lalo ebhodini lokunamathisela

────────────────────────────────────────
✍️ UMBUZO UMHLELI
───────────────────────────────────────
• Umhleli we-SQL ogqanyiswe nge-syntax onezinombolo zomugqa (i-Atom One Dark/Light)
• Ukuqedela ngokuzenzakalela kokuqukethwe ngezindlela ezi-3:
— Amagama angukhiye e-SQL nemisebenzi (SELECT, WHERE, COALESCE, ROW_NUMBER…)
— Amagama ethebula ngemva kwe-FROM, JOIN, UPDATE, INTO
— Amagama ekholomu ngemva kwe-WHERE, SETHA, SELECT — athathwe bukhoma kusuka ku-schema yakho
• Isikhathi sokusebenza, imigqa ethintekile, kanye nenani lemigqa eliboniswa ngemva kwemibuzo ngayinye
• Thumela imiphumela ku-CSV noma ku-JSON ngeyodwa thepha

────────────────────────────────
🔒 UKUPHEPHA KUQALA
─────────────────────────────────────────────
• Zonke iziqinisekiso zigcinwe nge-Flutter Secure Storage (Keystore / Keychain)
• Izindlela ze-SSL: zikhutshaziwe, zidinga, ziqinisekisa-iseva
• Ukuthungelwa kwe-SSH okugcwele ngokusekelwa kwefayela lokhiye wangasese
• Ukugcina ngokuzenzakalelayo kuphile futhi kuxhunywe kabusha — ukuxhumana okungasebenzi hlala uphila

─────────────────────────────────
🎨 YAKHIWE UKUSETSHENZISWA KWANSUKU ZONKE
─────────────────────────────────────────────
• Ukusekelwa kwetimu emnyama nekhanyayo egcwele
• Ukwakheka okuphendulayo — i-sidebar kumathebulethi, idrowa kumafoni
• Ifonti ye-Monospace yonke ukuze ifundeke
• Umklamo we-Clean Material 3 onemibala ehlukene uxhumano
• Kopisha noma yiliphi inani ebhodini lokunamathisela ngokuthepha okukodwa

────────────────────────────────────
KUPHELELE KUKHO
──────────────────────────────────────────────────────────────────────
✔ Abathuthukisi be-Backend kanye nabagcwele
✔ Abaphathi bedatha baphatha amaseva akude
✔ Onjiniyela be-DevOps badinga ukufinyelela okusheshayo ohambweni
✔ Abahlaziyi bedatha abasebenzisa imibuzo ye-ad-hoc
✔ Noma ubani ofuna Ukufinyelela ezingeni le-pgAdmin kusuka ocingweni lwabo

I-PgSQL Visual Manager ivulekile, ilula, futhi yakhiwe nge-Flutter — iletha ulwazi lwendabuko ku-Android ngaphandle kokukhuhla noma ukubhalisa okudingekayo.

Yini entsha

Small Changes