Kutulutsidwa kwa pulojekiti ya IvorySQL 5.0 kwasindikizidwa, ndikupanga kope la PostgreSQL DBMS lomwe limapereka kuyanjana ndi mapulogalamu opangidwa kuti azigwira ntchito ndi Oracle DBMS. IvorySQL imati imatha kugwira ntchito ngati cholozera chowonekera chaposachedwa kwa PostgreSQL, kusiyana komwe kumatsikira ku mawonekedwe a "compatible_db", omwe amaphatikiza mawonekedwe ofananira ndi Oracle. Khodiyo idalembedwa mu C ndikugawidwa pansi pa layisensi ya Apache 2.0.
IvorySQL imagwiritsa ntchito chilankhulo cha PL/iSQL, chomwe chimatengera mawu a Oracle's PL/SQL, ndikuthandizira mapaketi amtundu wa Oracle ndi magwiridwe antchito monga "CREATE PACKAGE". Amapereka magwiridwe antchito ndi mitundu yogwirizana ndi Oracle, ndipo amathandizira mawu omveka a Oracle pamachitidwe, mawu, ndi mawu monga ALTER TABLE, DELETE, UPDATE, CONNECT BY (mafunso apamwamba), GROUP BY, UNION, ndi MINUS.
Mu mtundu watsopano:
- Kusintha kwa codebase ya PostgreSQL 18 kwatha.
- Kugwirizana kwabwino ndi Oracle DBMS: kuthandizira pazigawo zokhazikika, ROWID, NLS ndi OUT magawo, kumasulira kwa zingwe zopanda kanthu kukhala NULL, kusintha magawo omangirira gawo, GB18030 encoding, SYS_GUID, SYS_CONTEXT ndi USERENV ntchito.
- Onjezani Oracle-compatible INSTR, FORCE VIEW, ndi LIKE ogwiritsira ntchito.
- Maluso a PL/iSQL awonjezedwa: kuthandizira kwa mawu a CALL, %ROWTYPE, ndi %TYPE awonjezedwa.
- Thandizo lathunthu la Docker Compose, Docker Swarm, ndi Kubernetes ndi woyang'anira phukusi la Helm lakhazikitsidwa. Zida zoyang'anira zowonera moyo wawonjezedwa ku IvorySQL Operator 5.0 ndi IvorySQL Cloud 5.0.
- Thandizo pazowonjezera khumi za PostgreSQL zimaperekedwa: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check ndi pgvector.
- Maphukusi oyika adapangidwira X86_64, ARM64, MIPS, ndi LoongArch zomangamanga.
- Malo a pa intaneti ogwirira ntchito ndi IvorySQL kuchokera kwa osatsegula akonzedwa, kukulolani kuchita popanda kukhazikitsa IvorySQL pa dongosolo lanu.
Chofunikiranso ndikutulutsidwa kwa SynchDB 1.3, pulogalamu yowonjezera yopangidwira kubwereza deta kuchokera ku DBMS imodzi kapena zingapo zachitatu, monga MySQL, MS SQL Server, ndi Oracle, kupita ku PostgreSQL. Ma DBMS akunjawa amakhala ngati magwero a data, omwe amasamutsidwa mwachindunji ku database imodzi ya PostgreSQL, popanda kufunikira kwa zigawo zowonjezera kuti akonze njira yolumikizira deta (ntchito zonse zolumikizira zimayendetsedwa ndi plugin ya SynchDB). Khodi ya polojekitiyi imalembedwa mu C ndi Java ndipo imagawidwa pansi pa chilolezo cha Apache 2.0.
Dongosololi lili ndi zigawo zotsatirazi:
- Debezium Runner Engine ndi injini ya Java yomwe imapereka ma module osinthira kusintha kwa data kuchokera ku ma DBMS osiyanasiyana (MySQL, MS SQLServer ndi Oracle) ndikumasulira zomwe zalandilidwa mumtundu wa JSON.
- SynchDB Worker - imayambitsa zochitika za Debezium Runner Engine kuti ibwereze deta kuchokera ku DBMSs yeniyeni, imalandira zosintha kuchokera kwa iwo mu mtundu wa JSON ndikuzitumiza ku gawo la Format Converter.
- SynchDB Launcher - Imapanga ndikuyimitsa othandizira a SynchDB pogwiritsa ntchito PostgreSQL API kuyambitsa njira zakumbuyo.
- Format Converter - Parses amasintha mtsinje mumtundu wa JSON, amasintha mitundu ya data ya chipani chachitatu ndi mafunso a DDL kukhala mitundu ndi mafunso omwe amagwirizana ndi PostgreSQL.
- Replication Agent - Imakonza zotuluka za HeapTupleData kuchokera ku Format Converter ndikuyendetsa njira zosinthira deta mu PostgreSQL.
SynchDB 1.3 imabweretsa injini yatsopano yazithunzi yozikidwa pa FDW (Foreign Data Wrapper) ndipo imathandizira OpenLog Replicator. Poyerekeza ndi injini yapitayi ya Debezium, injini yatsopanoyi imapangitsa kuti ntchito ikhale yabwino komanso imachepetsa kuchedwa pamene mukubwereza deta kuchokera kuzinthu zazikulu za Oracle. Kuphatikiza apo, mtundu watsopanowu umapereka mawonedwe owonjezera a ziwerengero (synchdb_genstats, synchdb_snapstats, ndi synchdb_cdcstat), OpenLog Replicator tsopano imathandizira mawu a MODIFY ndi DEFAULT ON NULL, ndipo imathandizira PostgreSQL 18 ndi IvorySQL 5.
Source: opennet.ru
