Sakin IvorySQL 2.1, ƙari na PostgreSQL don dacewa da Oracle

An buga sakin aikin na IvorySQL 2.1, yana haɓaka bugu na PostgreSQL DBMS, wanda ke ba da launi don tabbatar da dacewa da aikace-aikacen da aka tsara don aiki tare da Oracle DBMS. Ana haɓaka ƙarawa ta hanyar yin canje-canje zuwa sabon lambar lambar PostgreSQL kuma masu haɓakawa suna da'awar yiwuwar yin amfani da IvorySQL azaman canji na gaskiya don sabon sigar PostgreSQL, bambanci daga wanda ya sauko zuwa bayyanar saitin "compatible_db" , wanda ya haɗa da yanayin daidaitawa tare da Oracle. An rubuta lambar a cikin C kuma an rarraba ta ƙarƙashin lasisin Apache 2.0.

IvorySQL tana aiwatar da yaren tsari na PL/iSQL, wanda ke bin tsarin tsarin PL/SQL, kuma yana goyan bayan fakitin salon Oracle da ayyukan fakiti kamar "CREATE PACKAGE". IvorySQL kuma tana goyan bayan ƙayyadaddun ƙayyadaddun ƙayyadaddun Oracle don ayyuka, maganganu, da ALTER TABLE, DELETE, UPDATE, HAƊA TA, KURUNIYA BY, UNION, da maganganun MINUS, kuma yana ba da saitin ayyuka da nau'ikan Oracle masu jituwa. Don yin koyi da ayyukan Oracle, iri da fakiti, IvorySQL tana amfani da lamba daga ƙarawar Orafce PostgreSQL.

Sabuwar sigar IvorySQL tana ba da sauye-sauye zuwa tushe na lambar PostgreSQL 15.1 kuma yana aiwatar da tallafi don ƙayyadaddun alamomin duniya waɗanda aka kirkira ta amfani da kalmar "CREATE UNIQUE INDEX global_index ON idxpart (bid) GLOBAL". Ana iya amfani da irin waɗannan firikwensin don ƙirƙirar fihirisar keɓancewar a kan tebirin da aka raba wanda ya kasance na musamman a duk ɓangarori lokacin da maɓallin da ba a raba shi ya isa gare shi ba.

source: budenet.ru

Add a comment