An bayyana fitowar sabon juzu'i na TimescaleDB 1.7, sigar da kara tallafi don PostgreSQL 12 an haskaka, haka kuma a cikin gyare-gyaren wasu ayyuka. Ga wadanda basu sani ba LokaciDB, ya kamata su san hakan ita ce rumbun adana bayanai wanda aka tsara don adanawa da sarrafa bayanai a cikin tsarin jerin lokuta (sassan ƙididdigar ma'auni a lokacin da aka ba su, rijistar ta samar da lokaci da saitin ƙimomin da suka dace da wannan lokacin).
Wannan nau'i na ajiya shine mafi kyau ga aikace-aikace kamar tsarin sa ido, dandamali na kasuwanci, tsarin tattara ma'auni da yanayin firikwensin.
Game da TimescaleDB
Aikin TimescaleDB ana aiwatar dashi azaman ƙarawa PostgreSQL kuma an rarraba shi a ƙarƙashin lasisin Apache 2.0. Wasu lambobin tare da ingantattun fasali ana gabatar dasu a ƙarƙashin lasisi na lasisin Timescale (TSL), wanda baya bada izinin canje-canje, ya hana amfani da lamba a cikin samfuran ɓangare na uku, kuma baya bada izinin amfani dashi kyauta a cikin bayanan girgije (bayanai kamar sabis ).
Sashin ban sha'awa na TimescaleDB, shine ba ka damar amfani da cikakkun tambayoyin SQL don bincika bayanan da aka tara, hada sauƙin amfani wanda yake tattare da DBMS mai ma'ana tare da haɓakawa da damar da ke tattare da tsarin NoSQL na musamman.
Tsarin ajiya an inganta shi don samar da ƙimar tarin bayanai mai yawa. Tana goyan bayan bayanan tarin abubuwa, ta amfani da fihirisan da aka adana a cikin RAM, suna dawo da sassan tarihi da baya, suna aiwatar da ma'amaloli.
Babban fasalin TimescaleDB shine tallafi don atomatik bangarewani (bangare) na tsararrun bayanai. Ana rarraba rafin bayanan mai shigowa ta atomatik tsakanin teburin da aka raba.
Ana kirkirar sassan ne bisa lokaci (kowane sashi yana adana bayanai na wani lokaci) ko kuma suna da alaƙa da maɓallin keɓaɓɓu (misali mai gano na'urar, wuri, da sauransu). Za'a iya shimfida teburorin da aka raba a cikin ɗakuna daban-daban don haɓaka aikin.
Don tambayoyin, bayanan bayanan da aka raba suna kama da babban tebur, wanda ake kira hypertable. A hypertable wakilci ne na kama-da-wane na tebur daban-daban wanda aka tara bayanan mai shigowa a ciki.
Menene sabo a cikin TimescaleDB 1.7?
A cikin wannan sabon sigar tallafi don hadewa tare da PostgreSQL 12 DBMS, yayin da tallafi don PostgreSQL 9.6.x da 10.x ya ragu, kodayake don Timescale 2.0 goyan bayan PostgreSQL 11 + kawai zai kasance.
Har ila yau, ya tsaya a waje cewa canza halayyar tambayoyin tare da ci gaba da aiwatar da cikakken aiki (tara ci gaba mai shigowa data a ainihin lokacin).
Irin waɗannan tambayoyin yanzu suna haɗuwa da ra'ayoyin da aka samu tare da sababbin bayanan da basu shigo ba (a baya, tattara bayanan da aka riga aka riga aka bayyana) Ana amfani da sabon halin don sabbin abubuwan ci gaba da tarawa.
A gefe guda, wasu kayan aikin sarrafa rayuwa masu ci gaba an koma cikin sigar al'umma na bugun kasuwanci, gami da ikon tattara bayanai da kuma manufofin aiwatarwa don kawar da bayanan da suka gabata (ba ku damar adana bayanan yanzu kawai kuma ta atomatik share, ƙara, ko adana bayanan rikodin)
Yadda ake girka TimescaleDB akan Linux?
Ga wadanda suke da sha'awa don iya girka TimescaleDB akan tsarinkuZasu iya yin hakan ta bin umarnin da muka raba a ƙasa.
Game da wadanda suke Masu amfani da Ubuntu:
sudo echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c -s)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add – sudo add-apt-repository ppa:timescale/timescaledb-ppa sudo apt-get update sudo apt install timescaledb-postgresql-11
A cikin hali na Debian:
sudo sh -c "echo 'deb https://packagecloud.io/timescale/timescaledb/debian/ `lsb_release -c -s` main' > /etc/apt/sources.list.d/timescaledb.list" wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add - sudo apt-get update sudo apt-get install timescaledb-postgresql-11
RHEL / CentOS:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo tee /etc/yum.repos.d/timescale_timescaledb.repo <<EOL [timescale_timescaledb] name=timescale_timescaledb baseurl=https://packagecloud.io/timescale/timescaledb/el/7/\$basearch repo_gpgcheck=1 gpgcheck=0 enabled=1 gpgkey=https://packagecloud.io/timescale/timescaledb/gpgkey sslverify=1 sslcacert=/etc/pki/tls/certs/ca-bundle.crt metadata_expire=300 EOL
sudo yum update -y sudo yum install -y timescaledb-postgresql-11
Yanzu za mu saita bayanan bayanan tare da:
sudo timescaledb-tune
Anan ana iya yin gyare-gyare daban-daban, wanda zaka iya tuntuba A cikin mahaɗin mai zuwa.
A ƙarshe, kawai sake kunna sabis ɗin:
sudo service postgresql restart