# Poli

**Repository Path**: zhanght_admin/Poli

## Basic Information

- **Project Name**: Poli
- **Description**: Poli是一个简单易用的开源BI软件
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 66
- **Created**: 2019-06-26
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# **Poli** `破力`

[![Version](https://img.shields.io/badge/Version-0.7.0-0065FF.svg)](#)
[![license: MIT](https://img.shields.io/badge/license-MIT-FF5630.svg)](https://opensource.org/licenses/MIT)
[![Download](https://img.shields.io/github/downloads/shzlw/poli/total.svg?color=6554C0)](https://github.com/shzlw/poli/releases)
[![Build Status](https://travis-ci.org/shzlw/poli.svg?branch=master)](https://travis-ci.org/shzlw/poli)
[![codecov](https://codecov.io/gh/shzlw/poli/branch/master/graph/badge.svg)](https://codecov.io/gh/shzlw/poli)

Poli is an easy-to-use SQL reporting application built for SQL lovers!

## Why Poli

#### :zap: Self-hosted & easy setup
Platform independent web application. Single JAR file + Single SQLite DB file. Run it everywhere.
#### :muscle: Connect to any database supporting JDBC drivers
PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it.
#### :bulb: SQL editor & schema viewer
No ETLs, no generated SQL, polish your own SQL query to transform data.
#### :fire: Rich and flexible styling<br/>
Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way.
#### :bookmark_tabs: Interactive Adhoc report<br/>
Utilize the power of dynamic SQL with query variables to connect Filters and Charts.
#### :hourglass: Canned report<br/>
Capture the snapshot of historical data. Free up space in your own database.
#### :santa: User management<br/>
Three system level role configurations + Group based report access control.
#### :moneybag: MIT license<br/>
Open and free for all usages.
#### :gem: Is that all?
Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.

## What's New ([latest v0.7.0](https://shzlw.github.io/poli/#/change-logs))

## Gallery

#### Slicer & Charts

![poli v0.5.0](http://66.228.42.235:8080/slicer.gif)

#### Move & Resize

![poli component reposition](http://66.228.42.235:8080/move.gif)

#### Color palette switch & export CSV

![poli v0.6.0](http://66.228.42.235:8080/v0.6.0_new.gif)

## Quick Installation

Windows/Linux

```sh
java -jar poli-0.7.0.jar
```

Docker

```sh
docker run -d -p 6688:6688 --name poli zhonglu/poli:0.7.0
```

Check [installation guide](https://shzlw.github.io/poli/#/installation) for more details.

## Download

[Download](https://github.com/shzlw/poli/releases) the latest version of Poli via the github release page.

## Documentation

Poli's documentation and other information can be found at [here](https://shzlw.github.io/poli/).

## License

MIT License

Copyright (c) 2019 Zhonglu Wang