Sakin jadawali mai alaƙa DBMS EdgeDB 2.0

An gabatar da sakin EdgeDB 2.0 DBMS, wanda ke aiwatar da ƙirar bayanan jadawali da yaren tambayar EdgeQL, wanda aka inganta don aiki tare da hadaddun bayanan matsayi. An rubuta lambar a cikin Python da Rust (fassara da sassa masu mahimmanci) kuma ana rarraba su ƙarƙashin lasisin Apache 2.0. Ana haɓaka aikin azaman ƙari don PostgreSQL. An shirya ɗakunan karatu na abokin ciniki don Python, Go, Rust da TypeScript/Javascript. Yana ba da kayan aikin layin umarni don gudanarwa na DBMS da aiwatar da tambayoyin hulɗa (REPL).

Maimakon samfurin bayanan tushen tebur, EdgeDB yana amfani da tsarin sanarwa dangane da nau'ikan abu. Maimakon maɓallan ƙasashen waje, ana amfani da haɗin kai ta hanyar tunani don ayyana alaƙar da ke tsakanin nau'ikan (ana iya amfani da abu ɗaya azaman mallakar wani abu).

rubuta Mutum {sunan dukiya da ake buƙata -> str; } rubuta Fim { taken dukiya da ake buƙata -> str; Multi link 'yan wasan kwaikwayo -> Mutum; }

Ana iya amfani da fihirisa don hanzarta sarrafa tambaya. Hakanan ana samun goyan bayan fasalulluka kamar ƙaƙƙarfan buga kadara, ƙayyadaddun ƙimar kadarorin, kaddarorin ƙididdiga, da hanyoyin da aka adana. Siffofin tsarin ajiyar abubuwa na EdgeDB, wanda ke da ɗan tuno da ORM, sun haɗa da ikon haɗa makirci, abubuwan haɗin kai daga abubuwa daban-daban, da haɗaɗɗen tallafin JSON.

An samar da kayan aikin da aka gina don adana ƙaura na tsari - bayan canza tsarin da aka kayyade a cikin wani fayil ɗin esdl daban, kawai gudanar da umurnin "edgedb hijirar ƙirƙira" kuma DBMS za ta bincika bambance-bambance a cikin tsarin kuma tare da haɗin gwiwar samar da rubutun don ƙaura zuwa sabon tsari. Ana bin tarihin canje-canjen tsari ta atomatik.

Don samar da tambayoyin, duka harshen tambayar GraphQL da yaren EdgeDB na mallakar mallakar, wanda shine daidaitawar SQL don bayanan matsayi, ana tallafawa. Maimakon jeri, ana tsara sakamakon tambaya ta hanyar da aka tsara, kuma maimakon tambayoyi da JOINs, zaku iya tantance tambaya ta EdgeQL guda ɗaya azaman magana a cikin wata tambaya. Ana tallafawa ma'amaloli da zagayawa.

zaɓi Fim { take, ƴan wasan kwaikwayo: {suna } } tace .title = "The Matrix" saka Fim { take : = "Tashin Matrix", 'yan wasan kwaikwayo: = ( zaɓi Mutum tace .suna a cikin {'Keanu Reeves', 'Carrie- Anne Moss', 'Laurence Fishburne'})} don lamba a {0, 1, 2, 3} ƙungiyar ( zaɓi {lamba, lamba + 0.5});

A cikin sabon sigar:

  • An ƙara ginanniyar hanyar sadarwa ta yanar gizo don gudanar da bayanai, yana ba ku damar dubawa da shirya bayanai, gudanar da tambayoyin EdgeQL da nazarin tsarin ajiya da aka yi amfani da su. An ƙaddamar da ƙirar ta hanyar umarnin "edgedb ui", bayan haka yana samuwa lokacin shiga localhost.
    Sakin jadawali mai alaƙa DBMS EdgeDB 2.0
  • An aiwatar da furcin "GROUP", yana ba ku damar rarrabawa da tara bayanai da bayanan rukuni ta amfani da maganganun EdgeQL na sabani, kama da haɗawa cikin aikin SELECT.
  • Ikon sarrafa damar shiga a matakin abu. An ayyana dokokin shiga a matakin tsarin ma'ajiya kuma suna ba ku damar iyakance ikon amfani da takamaiman saitin abubuwa don ɗauko, saka, sharewa, da sabunta ayyukan. Misali, zaku iya ƙara ƙa'ida wacce ke bawa marubucin damar sabunta ɗaba'a.
  • Ƙara ikon yin amfani da masu canji na duniya a cikin tsarin ajiya. An gabatar da sabon mai canza canjin duniya current_user don ɗaure ga mai amfani.
  • Ƙara tallafi don nau'ikan da ke ayyana jeri na ƙima.
  • An shirya ɗakin karatu na abokin ciniki na hukuma don harshen Rust.
  • An daidaita ka'idar binary na EdgeDB, yana ba da damar aiwatar da lokuta daban-daban lokaci guda a cikin haɗin cibiyar sadarwa iri ɗaya, tura ta HTTP, ta amfani da masu canji na duniya da jahohin gida.
  • Ƙara goyon baya don kunna soket, wanda ke ba ku damar kiyaye mai kula da uwar garken a cikin ƙwaƙwalwar ajiya kuma gudanar da shi kawai lokacin ƙoƙarin kafa haɗin gwiwa (mai amfani don adana albarkatu akan tsarin haɓakawa).

source: budenet.ru

Add a comment