{"id":149793,"date":"2025-11-27T17:11:54","date_gmt":"2025-11-27T15:11:55","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupny-ivorysql-5-0-i-synchdb-1-3-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd"},"modified":"2025-11-27T17:11:54","modified_gmt":"2025-11-27T15:11:55","slug":"dostupny-ivorysql-5-0-i-synchdb-1-3-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/dostupny-ivorysql-5-0-i-synchdb-1-3-nadstrojki-k-postgresql-dlya-vzaimodejstviya-s-drugimi-subd","title":{"rendered":"I disponuesh\u00ebm IvorySQL 5.0 dhe SynchDB 1.3, shtesa p\u00ebr PostgreSQL p\u00ebr nd\u00ebrveprim me sisteme t\u00eb tjera menaxhimi t\u00eb bazave t\u00eb dh\u00ebnash.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbshte publikuar posta e projektit IvorySQL 5.0, i cili zhvillon redaktimin e DBMS PostgreSQL, duke siguruar p\u00ebrputhshm\u00ebri me aplikacionet q\u00eb jan\u00eb optimizuar p\u00ebr t\u00eb punuar me DBMS Oracle. N\u00eb IvorySQL \u00ebsht\u00eb shpallur mund\u00ebsia p\u00ebr t\u00eb funksionuar si nj\u00eb z\u00ebvend\u00ebsim transparent p\u00ebr versionin m\u00eb t\u00eb fundit t\u00eb PostgreSQL, dallimi i t\u00eb cilit p\u00ebrfshin parametrin \"compatible_db\", i cili aktivizon modalitetin e p\u00ebrputhshm\u00ebris\u00eb me Oracle. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. <\/p>\n
IvorySQL implementon gjuh\u00ebn procedurale PL\/iSQL, e cila p\u00ebrs\u00ebrit sintaks\u00ebn e PL\/SQL n\u00eb Oracle, mb\u00ebshtet paketa n\u00eb stilin Oracle dhe operacione me paketa, si 'CREATE PACKAGE'. Ofron nj\u00eb grup funksionesh dhe tipash t\u00eb p\u00ebrshtatsh\u00ebm me Oracle, si dhe mb\u00ebshtetje p\u00ebr sintaks\u00ebn specifike t\u00eb Oracle p\u00ebr operacionet, shprehjet dhe operator\u00ebt, si 'ALTER TABLE', 'DELETE', 'UPDATE', 'CONNECT BY' (k\u00ebrkesa hierarkike), 'GROUP BY', 'UNION' dhe 'MINUS'. <\/p>\n
N\u00eb k\u00ebt\u00eb version t\u00eb ri: <\/p>\n
\n
P\u00ebrmir\u00ebsimi n\u00eb baz\u00ebn e kodit t\u00eb PostgreSQL 18 \u00ebsht\u00eb realizuar.\n
P\u00ebrmir\u00ebsuar \u00ebsht\u00eb kompatibiliteti me DBMS Oracle: \u00ebsht\u00eb implementuar mb\u00ebshtetje p\u00ebr n\u00ebnprograme t\u00eb nd\u00ebrlidhura, ROWID, parametra NLS dhe OUT, konvertimin e vargjeve t\u00eb zbraz\u00ebta n\u00eb NULL, nd\u00ebrrimin e parser\u00ebve n\u00eb lidhje me seancat, kodet GB18030, funksionet SYS_GUID, SYS_CONTEXT dhe USERENV.\n
Jan\u00eb shtuar operator\u00ebt e kompatib\u00ebl me Oracle INSTR, FORCE VIEW dhe LIKE.\n
Jan\u00eb zgjeruar mund\u00ebsit\u00eb e PL\/iSQL: \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr sintaks\u00ebn CALL, %ROWTYPE dhe %TYPE.\n
Mb\u00ebshtetje e plot\u00eb p\u00ebr Docker Compose, Docker Swarm dhe Kubernetes \u00ebsht\u00eb realizuar me menaxherin e paketave Helm. N\u00eb IvorySQL Operator 5.0 dhe IvorySQL Cloud 5.0 jan\u00eb shtuar mjete p\u00ebr menaxhimin vizual t\u00eb ciklit t\u00eb jet\u00ebs.\n
Jan\u00eb formuar paketat instalimi p\u00ebr arkitektur\u00ebn X86_64, ARM64, MIPS dhe LoongArch.\n
Nj\u00eb mjedis online p\u00ebr pun\u00eb me IvorySQL nga shfletuesi \u00ebsht\u00eb p\u00ebrgatitur, duke mund\u00ebsuar p\u00ebrdorimin pa instaluar IvorySQL n\u00eb sistemin tuaj. <\/ul>\n
P\u00ebr m\u00eb tep\u00ebr, mund t\u00eb theksohet l\u00ebshimi i zgjatjes SynchDB 1.3, e cila \u00ebsht\u00eb e destinuar p\u00ebr replikimin e t\u00eb dh\u00ebnave nga nj\u00eb ose disa DBMS t\u00eb jashtme, si MySQL, MS SQLServer dhe Oracle. K\u00ebto DBMS t\u00eb jashtme sh\u00ebrbejn\u00eb si burime t\u00eb dh\u00ebnash, t\u00eb cilat transferohen direkt n\u00eb nj\u00eb DB t\u00eb caktuar t\u00eb bazuar n\u00eb PostgreSQL, pa p\u00ebrdorur shtresa t\u00eb tjera p\u00ebr orkestrimin e procesit t\u00eb sinkronizimit t\u00eb t\u00eb dh\u00ebnave (t\u00eb gjitha operacionet e sinkronizimit p\u00ebrpunohen nga zgjatja SynchDB). Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebt C dhe Java, dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. <\/p>\n
Sistemi p\u00ebrfshin komponent\u00ebt: <\/p>\n
\n
Debezium Runner Engine \u2014 nj\u00eb motor n\u00eb Java, i cili ofron module p\u00ebr trajtimin e rrjedhave t\u00eb ndryshimeve t\u00eb t\u00eb dh\u00ebnave nga DBMS t\u00eb ndryshme (MySQL, MS SQLServer dhe Oracle) dhe konvertimin e t\u00eb dh\u00ebnave t\u00eb marra n\u00eb formatin universal JSON. <\/li>\n
SynchDB Launcher \u2014 krijon dhe p\u00ebrfundon operatoret SynchDB, duke p\u00ebrdorur API PostgreSQL p\u00ebr t\u00eb aktivizuar proceset q\u00eb funksionojn\u00eb n\u00eb sfond. <\/li>\n
Format Converter \u2014 analizon rrjedh\u00ebn e ndryshimeve n\u00eb formatin JSON, konverton tipat e t\u00eb dh\u00ebnave t\u00eb jashtme dhe k\u00ebrkesat DDL n\u00eb tipe dhe k\u00ebrkesa t\u00eb p\u00ebrputhshme me PostgreSQL. <\/li>\n
N\u00eb SynchDB 1.3 \u00ebsht\u00eb realizuar nj\u00eb motor i ri p\u00ebr formimin e snapshtesh, i ngritur mbi FDW (Foreign Data Wrapper) dhe i mb\u00ebshtetur p\u00ebr pun\u00eb me OpenLog Replicator. Krahasuar me motorin e vjet\u00ebr q\u00eb bazohej n\u00eb Debezium, motorin e ri lejon nj\u00eb rritje t\u00eb dukshme t\u00eb performanc\u00ebs dhe uljen e vonesave gjat\u00eb replikimit t\u00eb t\u00eb dh\u00ebnave nga BD t\u00eb m\u00ebdha Oracle. P\u00ebr m\u00eb tep\u00ebr, n\u00eb versionin e ri ofrohen pamje shtes\u00eb me statistik\u00eb (synchdb_genstats, synchdb_snapstats dhe synchdb_cdcstat), n\u00eb OpenLog Replicator \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr shprehjet MODIFY dhe DEFAULT ON NULL, \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr DBMS PostgreSQL 18 dhe IvorySQL 5. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
![\"I](\"\/wp-content\/uploads\/2025\/11\/a85fea82eb0aef9d31fc1468de846f8c.jpg\")
<\/center> <\/p>\n