Megjelent az AlaSQL 4.0 adatb\u00e1zis-kezel\u0151 rendszer, amely webalkalmaz\u00e1sokhoz, webtechnol\u00f3gi\u00e1kon alapul\u00f3 mobilalkalmaz\u00e1sokhoz, vagy Node.js alap\u00fa szerver-oldali feldolgoz\u00f3khoz k\u00e9sz\u00fclt. Az adatb\u00e1zis JavaScript k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban \u00e9rhet\u0151 el, \u00e9s t\u00e1mogatja az SQL nyelvet. T\u00e1mogatott a hagyom\u00e1nyos rel\u00e1ci\u00f3s t\u00e1bl\u00e1kban val\u00f3 adatkezel\u00e9s, illetve a rugalmas JSON strukt\u00far\u00e1k haszn\u00e1lata, amelyek nem ig\u00e9nyelnek szigor\u00fa t\u00e1rol\u00e1si sch\u00e9m\u00e1t. Az adatok parancssori manipul\u00e1l\u00e1s\u00e1hoz el\u00e9rhet\u0151 az alasql eszk\u00f6z. A projekt k\u00f3dja JavaScript nyelven \u00edr\u00f3dott, \u00e9s MIT licenc alatt terjesztik. <\/p>\n
Az AlaSQL t\u00e1mogatja a SQL-99 nyelv legnagyobb r\u00e9sz\u00e9t, valamint kieg\u00e9sz\u00edt\u00e9seket k\u00edn\u00e1l NoSQL st\u00edlus\u00fa feldolgoz\u00e1shoz (sch\u00e9ma meghat\u00e1roz\u00e1sa n\u00e9lk\u00fcl) \u00e9s gr\u00e1fokkal val\u00f3 manipul\u00e1ci\u00f3hoz. SQL lek\u00e9rdez\u00e9sekben v\u00e9gezhet\u0151k egyes\u00edt\u00e9si (JOIN), csoportos\u00edt\u00e1si (GROUP), uni\u00f3 (UNION) m\u0171veletek, haszn\u00e1lhat\u00f3k az alt lek\u00e9rdez\u00e9sek \u00e9s az ANY, ALL, IN kifejez\u00e9sek, alkalmazhat\u00f3k a ROLLUP(), CUBE() \u00e9s GROUPING SETS() f\u00fcggv\u00e9nyek. Korl\u00e1tozott t\u00e1mogat\u00e1s el\u00e9rhet\u0151 a tranzakci\u00f3khoz. T\u00e1mogatott a felhaszn\u00e1l\u00f3i f\u00fcggv\u00e9nyek defini\u00e1l\u00e1sa, amelyeket SQL lek\u00e9rdez\u00e9sekben haszn\u00e1lhatunk. A f\u00fcggv\u00e9nyek \u00e9s SQL kifejez\u00e9sek gyors h\u00edv\u00e1s\u00e1hoz el\u0151feldolgozva (a SQL PREPARE utas\u00edt\u00e1s lehet\u0151s\u00e9g\u00e9nek megfelel\u0151en) haszn\u00e1lhat\u00f3k. <\/p>\n
Az AlaSQL adatb\u00e1zis-kezel\u0151 rendszert az ETL (Extract, Transform, Load) paradigm\u00e1k \u00e9s az adatok manipul\u00e1l\u00e1s\u00e1ra tervezt\u00e9k import\u00e1l\u00e1s\/feldolgoz\u00e1s\/export\u00e1l\u00e1s form\u00e1j\u00e1ban. A t\u00e1rol\u00e1shoz, export\u00e1l\u00e1shoz \u00e9s import\u00e1l\u00e1shoz haszn\u00e1lhat\u00f3 form\u00e1tumok k\u00f6z\u00f6tt szerepel a localStorage, IndexedDB, CSV, TAB, TXT, JSON, SQLite \u00e9s Excel (.xls \u00e9s .xlsx). Felt\u00e9telezhet\u0151, hogy k\u00f6zvetlen lek\u00e9rdez\u00e9seket lehet v\u00e9grehajtani a megjel\u00f6lt form\u00e1tumokban t\u00e1rolt adatokon, vagy import\u00e1lni\/export\u00e1lni lehet az adatokat. A SELECT m\u0171velet az \u00f6sszes JavaScript objektumban tal\u00e1lhat\u00f3 adaton is v\u00e9grehajthat\u00f3. <\/p>\n
A k\u00f6nyvt\u00e1r eredetileg a mem\u00f3ri\u00e1ban t\u00f6rt\u00e9n\u0151 gyors adatfeldolgoz\u00e1sra lett optimaliz\u00e1lva az \u00fczleti analitika alkalmaz\u00e1sai sz\u00e1m\u00e1ra, \u00e9s t\u00e1mogatja az olyan optimaliz\u00e1l\u00e1sokat, mint a lek\u00e9rdez\u00e9sek gyors\u00edt\u00f3t\u00e1raz\u00e1sa el\u0151re ford\u00edtott funkci\u00f3k form\u00e1j\u00e1ban, a t\u00e1bl\u00e1k egyes\u00edt\u00e9si el\u0151zetes indexel\u00e9se \u00e9s a WHERE kifejez\u00e9sek sz\u0171r\u00e9se az egyes\u00edt\u00e9si m\u0171veletek el\u0151tt. \u00d6sszehasonl\u00edtva m\u00e1s hasonl\u00f3 projektekkel, az AlaSQL h\u00e1romszor gyorsabb volt a SUM, JOIN \u00e9s GROUP BY m\u0171veleteket tartalmaz\u00f3 lek\u00e9rdez\u00e9sek eset\u00e9n a SQL.js-hez k\u00e9pest, k\u00e9tszer gyorsabb a Linq-n\u00e1l a GROUP BY haszn\u00e1latakor, \u00e9s megk\u00f6zel\u00edt\u0151leg ugyanolyan szinten, mint a WebSQL API (amely az SQLite-ra \u00e9p\u00fcl \u00e9s hamarosan elt\u00e1vol\u00edtj\u00e1k a Chrome-b\u00f3l) a SUM, JOIN \u00e9s GROUP BY m\u0171veleteket tartalmaz\u00f3 lek\u00e9rdez\u00e9sek eset\u00e9n. \u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 AlaSQL 4.0, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0432 web-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435, \u0432 \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u043d\u0430 \u0431\u0430\u0437\u0435 web-\u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438\u043b\u0438 \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0445 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u0445 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b Node.js. \u0421\u0423\u0411\u0414 \u043e\u0444\u043e\u0440\u043c\u043b\u0435\u043d\u0430 \u0432 \u0432\u0438\u0434\u0435 JavaScript-\u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u044f\u0437\u044b\u043a SQL. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 \u0438\u043b\u0438 \u0432 \u0444\u043e\u0440\u043c\u0435 \u0432\u043b\u043e\u0436\u0435\u043d\u043d\u044b\u0445 JSON-\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440, \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u044e\u0449\u0438\u0445 \u0436\u0451\u0441\u0442\u043a\u043e\u0433\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0441\u0445\u0435\u043c\u044b \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f. \u0414\u043b\u044f […]<\/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-108405","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Megjelent az AlaSQL 4.0 adatb\u00e1zis-kezel\u0151 rendszer, amely a b\u00f6ng\u00e9sz\u0151kben \u00e9s a Node.js-ben val\u00f3 haszn\u00e1latra \u00f6sszpontos\u00edt | ProHoster","description":"Megjelent az AlaSQL 4.0 adatb\u00e1zis-kezel\u0151 rendszer, amely webalkalmaz\u00e1sokban, webtechnol\u00f3gi\u00e1kra \u00e9p\u00fcl\u0151 mobilalkalmaz\u00e1sokban vagy Node.js alap\u00fa szerverkezel\u0151kben val\u00f3 haszn\u00e1latra k\u00e9sz\u00fclt.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-alasql-4-0-naczelennoj-na-ispolzovanie-v-brauzerah-i-node-js","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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 AlaSQL 4.0, \u043d\u0430\u0446\u0435\u043b\u0435\u043d\u043d\u043e\u0439 \u043d\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430\u0445 \u0438 Node.js | ProHoster","og:description":"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 AlaSQL 4.0, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0432 web-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435, \u0432 \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 \u043d\u0430 \u0431\u0430\u0437\u0435 web-\u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438\u043b\u0438 \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0445 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u0445 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b Node.js.","og:url":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-alasql-4-0-naczelennoj-na-ispolzovanie-v-brauzerah-i-node-js","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":"2023-05-06T10:48:27+00:00","article:modified_time":"2023-05-09T09:00:33+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\/hu\/wp-json\/wp\/v2\/posts\/108405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=108405"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/108405\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=108405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=108405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=108405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
Forr\u00e1s: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"