📈

Apache Superset

Falanqaynta

Sahaminta xogta casriga ah iyo madal muuqaal ah oo loogu talagalay falanqaynta shirkadaha

Macluumaad ku saabsan soo dejinta

Hawlgalinta: 2-5 daqiiqo
qaybta: Falanqaynta
RAM-ka ugu yar: 2048MB
Taageerada: Tigidhada iyo email

Share this guide

Aragtida guud

Apache Superset waa platform business intelligence iyo baadhista xogta oo casri ah, oo diyaar u ah ganacsiga, kaas oo fududeeya isticmaaleyaasha dhammaan heerarka xirfadda inay baadhaan oo sawiraan xogtooda. Markii ugu horreysay waxaa laga horumariyay Airbnb, hadana waa mashruuc heer sare ah oo Apache Software Foundation. Superset wuxuu bixiyaa interface hodan ah oo fudud oo loogu talagalay dhisidda dashboards-ka, chart-yada iyo app-yada analytics-ka xogta, iyadoon u baahnayn SQL ballaaran ama xirfad barnaamijeed.

Qotada dhexe, Superset wuxuu ku dhisan yahay semantic layer xoog leh oo ku xidha ku dhawaad database kasta ama data warehouse oo SQL ku hadla. Taageeruhu wuxuu ku jiraa PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse, iyo dhowr kale oo ka yimid SQLAlchemy connectors. Isku-xidhkan caalamiga ah wuxuu u ogolaanayaa ururrada inay isku geeyaan analytics-ka xogta kala duwan iyada oo loo marayo interface keliya.

Platform-ku wuxuu leeyahay maktabad muuqaal oo ballaaran oo ka badan 40 nooc oo chart ah oo horay loo dhisay, oo ay ku jiraan chart-yada waqtiga, chart-yada bar-ka, chart-yada pie-ka, khariidadaha juqraafiga, heatmaps, pivot tables, iyo muuqaallo horumarsan sida Sankey diagrams iyo sunburst charts. Nooc kasta oo muuqaal ah wuu la habayn karaa interface-ka fudud, taasoo u ogolaanaysa falanqeeyayaasha inay u habeeyaan soo bandhigyada shuruudaha ganacsiga iyadoon code la qorin.

SQL Lab ee Superset wuxuu bixiyaa IDE xoog leh oo loogu talagalay baadhista xogta, oo ay ku jiraan taariikhda su'aalaha, su'aalaha la kaydiyay, qorshaynta su'aalaha, tabs badan, iyo horudhaca xogta ee la isku daray. Taageerada Jinja templating ee su'aalaha waxay ogolaanaysaa samaynta SQL ee firfircoon oo ku salaysan shaandhaynta dashboard-ka, taasoo abuurta waayo-aragnimo analytics oo isdhexgal leh. Natiijooyinka su'aalaha waxaa lagu dhoofin karaa CSV falanqayn dambe ama wadaagid.

VPS hosting-ka, Superset wuxuu u adeegaa sida alternative iskood loo martigeliyo oo ah platforms-ka BI ee ganacsiga sida Tableau, Looker ama Power BI, isagoo bixinaya shaqo la mid ah iyadoon kharash raxanaha isticmaale ama ku xirnaan bixiye la lahayn. Qaab-dhismeedka platform-ku wuxuu taageeraa baaxad-kordhin toosan oo loo marayo load balancing, waxayna maamuli kartaa culeyska heerka shirkadaha oo leh kumanaan isticmaale oo isku mar ah iyo milyanno safka xog ah.

Astaamaha amniga iyo maamulka waxaa ka mid ah xakamaynta gelitaanka ku salaysan doorarka (RBAC), amniga heerka dataset-ka iyo heerka safka, isku-xidhka OAuth providers-ka (Google, GitHub, Okta), xaqiijinta LDAP, iyo diiwaan-gelinta hanti-dhowrka oo dhamaystiran. Taageerada multi-tenancy-ku waxay awood u siinaysaa workspaces kala go'an oo waaxaha ama macaamiisha kala duwan gudaha hal Superset install.

Balaadhinta platform-ka iyada oo loo marayo qaab-dhismeed plugin xoog leh ayaa u ogolaanaysa horumariyayaasha inay abuuraan muuqaallo gaar ah, database connectors-ka, iyo qaybaha dashboard-ka. Bulsho koraysa ayaa ku darta plugins iyo extensions, taasoo si joogto ah u balaadhinaysa awoodaha Superset iyo nidaamka isku-xidhka.

Sifooyinka muhiimka ah

Isku-xidhka Database-ka ee Caalamiga ah

Taageero asal ah oo ku saabsan 40+ database iyada oo loo marayo SQLAlchemy, oo ay ku jiraan PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse, iyo Presto si analytics midaysan loo helo.

Maktabadda Muuqaalka Hodanka ah

40+ nooc oo chart ah oo horay loo dhisay, oo ay ku jiraan waqtiga, khariidadaha juqraafiga, pivot tables, Sankey diagrams, iyo muuqaallo horumarsan oo leh ikhtiyaarro habayn oo ballaaran.

SQL Lab IDE

Tafatire SQL xoog leh oo leh taariikhda su'aalaha, su'aalaha la kaydiyay, interface tabs badan, Jinja templating, qorshaynta su'aalaha, iyo horudhaca xogta ee la isku daray baadhista.

Amniga iyo Maamulka Heerka Shirkadaha

Xakamaynta gelitaanka ku salaysan doorarka, amniga safka (row-level security), ogolaanshaha dataset-ka, isku-xidhka OAuth/LDAP, diiwaannada hanti-dhowrka oo dhamaystiran, iyo taageerada multi-tenancy.

Dashboards-ka Isdhexgalka ah

Dhisaha dashboard-ka ee drag-and-drop oo leh cross-filtering, drill-down, nidaamyo jawaab-celin ah, iyo cusboonaysiinta xogta waqtiga dhabta ah si analytics-ka firfircoon loo helo.

Qaab-dhismeedka La Baaxad-kordhin Karo

Naqshad baaxad-kordhin toosan oo taageerta load balancing, lakabyada cache-ka (Redis), fulinta su'aalaha asynchronous-ka (Celery), iyo isticmaaleyaasha isku mar ee heerka shirkadaha.

Waxyaabaha la isticmaalo

- Dashboards-ka Business Intelligence: Abuur dashboards-ka maamulka, kormeerka KPI-ga, analytics-ka iibka, iyo warbixinnada hawlgalka si loo gaaro go'aan-qaadasho ku salaysan xogta
- Baadhista iyo Falanqaynta Xogta: Awood u yeelo falanqeeyayaasha inay baadhaan dataset-yada, dhisaan su'aalo degdeg ah, iyo abuuraan muuqaallo iyadoon taageero injineer loo baahnayn
- Portal-yada Analytics-ka ee Macaamiisha: Dhis analytics lagu dhex-geliyo app-yada SaaS, si macaamiisha loogu siiyo aragti ku saabsan isticmaalkooda, waxqabadkooda iyo jihooyinkooda
- Kormeerka Waqtiga Dhabta ah: Kormeer metrics-ka app-ka, waxqabadka nidaamka, xogta sensorka IoT, iyo dhacdooyinka ganacsiga, oo leh dashboards-ka cusboonaysiinaya si toos ah
- Platform-ka BI ee Is-adeegga: Awood u yeelo isticmaaleyaasha ganacsiga ee waaxaha kala duwan inay abuuraan warbixinnadooda iyo muuqaalladooda dataset-yada la maamuusay
- Analytics-ka Multi-Tenant: Bixi deegaannada analytics-ka ee kala go'an macaamiisha, waaxaha ama unitiyada ganacsiga, oo leh amniga safka (row-level security)

Qoraalka rakibidda

Ku rakib Apache Superset Ubuntu VPS-ka adoo isticmaalaya pip gudaha Python virtual environment. Samee database gaar ah (PostgreSQL waa la taliyaa) oo loogu talagalay kaydinta metadata-ka Superset. Rakib Redis si loo kaydiyo oo loo taageero su'aalaha asynchronous-ka.

Abuur virtual environment adoo isticmaalaya python3 -m venv venv, shaqee, kadibna rakib xirmada superset adoo isticmaalaya pip install apache-superset. Bilow database-ka adoo isticmaalaya superset db upgrade, kadibna samee isticmaale admin ah adoo isticmaalaya superset fab create-admin.

Soo rar xogta tusaalaha ah oo bilow Superset adoo isticmaalaya amarka superset init. Habee superset_config.py oo leh SECRET_KEY, xadhkaha ku xidhka database-ka, iyo settings-ka Redis cache-ka. Deji Celery workers si loo fuliyo su'aalaha asynchronous-ka ah ee datasets-ka waaweyn.

Habee web server-ka (Gunicorn) iyo reverse proxy-ga (Nginx) geynta production-ka. Awood u yeelo HTTPS adoo isticmaalaya shatiyada Let's Encrypt. Deji systemd services-ka web server-ka Superset iyo Celery workers-ka si ay si toos ah u bilaabmaan oo loo kormeeri karo.

Geynta high-availability ah, socodsii web server-yo Superset oo badan oo ka dambeeya load balancer, habee database-ka metadata-ka ee la wadaago iyo Redis cache-ka, oo geyso pool-ka Celery worker ee gaarka u ah fulinta su'aalaha. Kormeer waxqabadka oo baaxadi workers-ka iyadoo lagu salaynayo culeyska su'aalaha.

Talooyin qaabeynta

Habaynta Superset waxaa lagu maamulaa faylka superset_config.py ee PYTHONPATH. Deji SECRET_KEY si loogu sirto session-ka (u samee openssl rand -base64 42), SQLALCHEMY_DATABASE_URI kaydinta metadata-ka, iyo CACHE_CONFIG Redis caching-ka.

Deji xiriirrada database-ka interface-ka ama amarka superset set_database_uri. Habee row-level security (RLS) adoo qeexaya SQL filters oo lagu dabaqo datasets-ka iyadoo ku salaysan doorarka isticmaalaha. Awood u yeelo dashboards-ka dadweynaha adoo isticmaalaya PUBLIC_ROLE_LIKE = "Gamma" wadaagista dibadda.

Habee xaqiijinta adoo habaynaya AUTH_TYPE (DATABASE, OAUTH, LDAP, ama REMOTE_USER) iyo settings-ka AUTH_CONFIG ee la xidhiidha. Isku-xidh OAuth providers-ka (Google, GitHub, Okta) ama enterprise LDAP/Active Directory si loo helo SSO.

Hab-fiican waxaa ka mid ah in la awood u yeelo ilaalinta CSRF, in CORS la habeeyo dashboards-ka la dhex-geliyay, in timeouts-ka su'aalaha la dejiyo si looga hortago su'aalaha dheer ee socda, in qiimeynta kharashka su'aalaha la awood u yeelo, in email alerts-ka lagu habeeyo warbixinnada la qorsheeyay, iyo in istaraatijiyad backup-ka database-ka metadata-ka la hirgeliyo. Isticmaal environment variables macluumaadka xasaasiga ah, halkii aad ku qori lahayd config faylka.

Waxyaabaha loo baahan yahay

U baahan yahay nidaamka

  • Xusuusta: 20481 MB RAM

Qiimee Maqaalkan

★★★★★
-
La soo dejinayo...

Diyaar ma u tahay inaad Codsigaaga geliso? Apache Superset?

Bilaaw daqiiqado leh habkayaga fudud ee VPS

Deploy in ku saabsan 2 daqiiqo • Full root access • taageero by tigidh iyo email