{"id":112886,"date":"2024-01-13T11:28:03","date_gmt":"2024-01-13T09:28:03","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-firebird-5-0"},"modified":"2024-01-13T11:28:03","modified_gmt":"2024-01-13T09:28:03","slug":"vypusk-subd-firebird-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-firebird-5-0","title":{"rendered":"Firebird 5.0 datu b\u0101zes sist\u0113mas izlaidums","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u0113c divarpus gadu att\u012bst\u012bbas ir prezent\u0113ta rel\u0101ciju datub\u0101zes vad\u012bbas sist\u0113mas Firebird 5.0 izlai\u0161ana. Firebird turpina InterBase 6.0 datub\u0101zes vad\u012bbas sist\u0113mas koda att\u012bst\u012bbu, kuru 2000. gad\u0101 izlaida uz\u0146\u0113mums Borland. Firebird tiek izplat\u012bts zem br\u012bv\u0101s MPL licences un atbalsta ANSI SQL standartus, tostarp t\u0101das funkcijas k\u0101 triggeri, uzglab\u0101t\u0101s proced\u016bras un replik\u0101ciju. Bin\u0101r\u0101s versijas ir sagatavotas Linux, Windows, macOS un Android sist\u0113m\u0101m.    <\/p>\n<p>Galven\u0101s jaun\u0101s funkcijas:  <\/p>\n<ul>\n<li class=\"l\"> Ievie\u0161ta iesp\u0113ja veikt oper\u0101cijas daudzv\u0113rt\u012bg\u0101 re\u017e\u012bm\u0101. Paraleliz\u0101cija vair\u0101k\u0101s straum\u0113s ir piem\u0113rojama indeksu izveidei, atkritumu sav\u0101k\u0161anai (autom\u0101tiskas un manu\u0101las oper\u0101cijas sweep), rezerves kopiju izveidei un atjauno\u0161anai no t\u0101m. gfix -sweep -parallel 4 dbname gbak -b -par 4 -user username -pass password dbname backupname\n<li class=\"l\"> Ievesta da\u013c\u0113j\u0101 indeksu atbalsts, kas iek\u013cauj tikai atlases ierakstus, kas atbilst noteiktajiem nosac\u012bjumiem indeksu izveides laik\u0101. CREATE INDEX IT1_COL ON T1 (COL) WHERE COL &lt; 100;\n<li class=\"l\"> SELECT WITH LOCK, UPDATE un DELETE izteiksm\u0113s ir ieviests sintakse \u00abSKIP LOCKED\u00bb, kas \u013cauj izsl\u0113gt ierakstus, kuriem br\u012bd\u012b, kad tiek izsniegts piepras\u012bjums, ir uzlikta blo\u0137\u0113\u0161ana (piem\u0113ram, lai neb\u016btu j\u0101gaida, kam\u0113r blo\u0137\u0113\u0161ana tiek atbr\u012bvota, kad t\u0101 krustojas ar citu dar\u012bjumu).\n<li class=\"l\"> Ir pievienota iesp\u0113ja atjaunin\u0101t datub\u0101zi uz aktu\u0101lo starpposmu versiju (ODS \u2014 On-Disk Structure) tie\u0161saist\u0113 (inline update) bez nepiecie\u0161am\u012bbas izveidot un atjaunot no rezerves kopijas. Piem\u0113ram, tagad ir iesp\u0113jams tie\u0161saist\u0113 p\u0101rveidot datub\u0101zi no Firebird 4.0 form\u0101ta (ODS 13.0) uz Firebird 5.0 form\u0101tu (ODS 13.1).\n<li class=\"l\"> Ieviesa autom\u0101tiski apkalpotu kompil\u0113to SQL izteiksmju ke\u0161u (novecoju\u0161i ieraksti tiek dz\u0113sti p\u0113c vajadz\u012bbas). Ke\u0161a lielumu var noteikt, izmantojot parametru MaxStatementCacheSize fail\u0101 firebird.conf.\n<li class=\"l\"> Ievesta SQL un PSQL profil\u0113\u0161anas saskarne, kas \u013cauj nov\u0113rt\u0113t katra piepras\u012bjuma izpildes laiku, uzkr\u0101t statistiku par piepras\u012bjumu skaitu un noteikt veiktsp\u0113jas probl\u0113mas.\n<li class=\"l\"> MERGE izteiksm\u0113 ir pievienota atbalsts nosac\u012btajam blokam \u00abWHEN NOT MATCHED BY SOURCE\u00bb, kas aktiviz\u0113jas, kad avota ieraksts neatbilst nevienam m\u0113r\u0137a kopas ierakstam. MERGE INTO customers c USING new_customers nc ON (c.id = nc.id) WHEN MATCHED THEN UPDATE SET name = nc.name WHEN NOT MATCHED BY SOURCE THEN DELETE\n<li class=\"l\"> Ir nodro\u0161in\u0101ta iesp\u0113ja atgriezt vair\u0101kas rindas ar izteiksm\u0113m RETURNING, ja nor\u0101d\u012btais DML izteikums aptver vair\u0101kas rindas (agr\u0101k \u0161\u0101d\u0101s situ\u0101cij\u0101s tika izvad\u012bta k\u013c\u016bda \u00abmultiple rows in singleton select\u00bb).\n<li class=\"l\"> Pievienotas jaunas ieb\u016bv\u0113tas funkcijas: UNICODE_CHAR, kas atgrie\u017e Unicode simbolu, kas atbilst dotajam kodam, un UNICODE_VAL, lai atgrieztu kodu dotajam simbolam. Funkcij\u0101s EXTRACT, FIRST_DAY un LAST_DAY pievienots parametrs QUARTER, lai noteiktu ceturk\u0161\u0146a numuru.\n<li class=\"l\"> Pievienots jauns sist\u0113mas pakotne RDB$BLOB_UTIL ar oper\u0101ciju kopumu BLOB datu apstr\u0101dei PSQL modu\u013ciem.\n<li class=\"l\"> Uzlabota ierakstu saspie\u0161anas algoritma darb\u012bba, kas tagad izmanto main\u012bga garuma skait\u012bt\u0101ju efekt\u012bv\u0101kai atk\u0101rtotu datu sec\u012bbu iepako\u0161anai. Optimiz\u0101cija iev\u0113rojami palielin\u0101ja saspie\u0161anas pak\u0101pi nepiln\u012bb\u0101 aizpild\u012btu garo VARCHAR lauku, kuros ir UTF-8 kod\u0113juma dati.\n<li class=\"l\"> Pievienota iesp\u0113ja str\u0101d\u0101t ar divvirzienu kursoru (scrollable) piek\u013c\u016bstot datub\u0101zei att\u0101lin\u0101ti.\n<li class=\"l\"> Veikta veiktsp\u0113jas optimiz\u0101cija BLOB datu kop\u0113\u0161an\u0101.\n<li class=\"l\"> Ir pievienots piln\u012bgs atbalsts teikumu defin\u012bcijas sintaksei, kas aprakst\u012bta SQL standart\u0101. Piem\u0113ram, teikumi tagad var tikt p\u0101rtraukti ar koment\u0101riem vai atstarp\u0113m: select 'ab' \/* comment *\/ 'cd' from RDB$DATABASE; select 'ab' 'cd' from RDB$DATABASE;    <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60430\">opennet.lv<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0434\u0432\u0443\u0445 \u0441 \u043f\u043e\u043b\u043e\u0432\u0438\u043d\u043e\u0439 \u043b\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Firebird 5.0. Firebird \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u0442 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043a\u043e\u0434\u0430 \u0421\u0423\u0411\u0414 InterBase 6.0, \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0433\u043e \u0432 2000 \u0433\u043e\u0434\u0443 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Borland. Firebird \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u0441\u0432\u043e\u0431\u043e\u0434\u043d\u043e\u0439 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 MPL \u0438 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u044b ANSI SQL, \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0442\u0430\u043a\u0438\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438, \u043a\u0430\u043a \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u044b, \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b \u0438 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e. \u0411\u0438\u043d\u0430\u0440\u043d\u044b\u0435 \u0441\u0431\u043e\u0440\u043a\u0438 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f Linux, Windows, macOS \u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-112886","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0434\u0432\u0443\u0445 \u0441 \u043f\u043e\u043b\u043e\u0432\u0438\u043d\u043e\u0439 \u043b\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Firebird 5.0. Firebird \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u0442 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043a\u043e\u0434\u0430 \u0421\u0423\u0411\u0414 InterBase 6.0, \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0433\u043e \u0432 2000 \u0433\u043e\u0434\u0443 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Borland.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-firebird-5-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 Firebird 5.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0434\u0432\u0443\u0445 \u0441 \u043f\u043e\u043b\u043e\u0432\u0438\u043d\u043e\u0439 \u043b\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Firebird 5.0. Firebird \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u0442 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043a\u043e\u0434\u0430 \u0421\u0423\u0411\u0414 InterBase 6.0, \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0433\u043e \u0432 2000 \u0433\u043e\u0434\u0443 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Borland.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-firebird-5-0\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-01-13T09:28:03+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-13T09:28:03+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Firebird 5.0 DBMS izlai\u0161ana | ProHoster","description":"P\u0113c divarpus gadu izstr\u0101des prezent\u0113ts rel\u0101ciju DBMS Firebird 5.0. Firebird turpina att\u012bst\u012bt InterBase 6.0 datub\u0101zes kodu, kas 2000. gad\u0101 tika atv\u0113rts uz\u0146\u0113mum\u0101 Borland.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-firebird-5-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 Firebird 5.0 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0434\u0432\u0443\u0445 \u0441 \u043f\u043e\u043b\u043e\u0432\u0438\u043d\u043e\u0439 \u043b\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 Firebird 5.0. Firebird \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u0442 \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u043a\u043e\u0434\u0430 \u0421\u0423\u0411\u0414 InterBase 6.0, \u043e\u0442\u043a\u0440\u044b\u0442\u043e\u0433\u043e \u0432 2000 \u0433\u043e\u0434\u0443 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Borland.","og:url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-firebird-5-0","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2024-01-13T09:28:03+00:00","article:modified_time":"2024-01-13T09:28:03+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/112886","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=112886"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/112886\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=112886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=112886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=112886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}