Science Score: 10.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
â—‹CITATION.cff file
-
â—‹codemeta.json file
-
â—‹.zenodo.json file
-
â—‹DOI references
-
â—‹Academic publication links
-
✓Committers with academic emails
2 of 71 committers (2.8%) from academic institutions -
â—‹Institutional organization owner
-
â—‹JOSS paper metadata
-
â—‹Scientific vocabulary similarity
Low similarity (10.4%) to scientific vocabulary
Keywords
bigquery
clickhouse
data-engineering
data-science
duckdb
hive
jupyter
mysql
polars
postgres
presto
python
redshift
snowflake
spark-sql
sql
sqlite
trino
tsql
Keywords from Contributors
spec-0
mlops
closember
notebook
parquet
arrow
docs
ipython
repl
distributed
Last synced: 6 months ago
·
JSON representation
Repository
Better SQL in Jupyter. 📊
Basic Info
- Host: GitHub
- Owner: ploomber
- License: apache-2.0
- Language: Python
- Default Branch: master
- Homepage: https://jupysql.ploomber.io
- Size: 12.9 MB
Statistics
- Stars: 793
- Watchers: 8
- Forks: 79
- Open Issues: 87
- Releases: 0
Fork of catherinedevlin/ipython-sql
Topics
bigquery
clickhouse
data-engineering
data-science
duckdb
hive
jupyter
mysql
polars
postgres
presto
python
redshift
snowflake
spark-sql
sql
sqlite
trino
tsql
Created over 3 years ago
· Last pushed 11 months ago
Metadata Files
Readme
Changelog
Contributing
License
Codeowners
README.md
JupySQL
Join our community | Newsletter | Contact us | Docs | Blog | Website | YouTube
[!TIP] Deploy Streamlit and Dash apps for free on Ploomber Cloud!
Run SQL in Jupyter/IPython via a %sql and %%sql magics.
Features
- Pandas integration
- SQL composition (no more hard-to-debug CTEs!)
- Plot massive datasets without blowing up memory
- DuckDB integration
Installation
pip install jupysql
or:
conda install jupysql -c conda-forge
Documentation
Click here to see the documentation.
Security
To report security vulnerabilities, see SECURITY.md
Credits
This project is a fork of ipython-sql; the objective is to turn this project into a full-featured SQL client for Jupyter. We're looking for feedback and taking feature requests, so please join our community and enter the #jupysql channel.
Owner
- Name: Ploomber
- Login: ploomber
- Kind: organization
- Email: contact@ploomber.io
- Website: https://ploomber.io/
- Twitter: ploomber
- Repositories: 35
- Profile: https://github.com/ploomber
We develop tools to streamline Data Science.
GitHub Events
Total
- Issues event: 22
- Watch event: 86
- Delete event: 2
- Issue comment event: 30
- Push event: 32
- Pull request review event: 8
- Pull request review comment event: 6
- Pull request event: 16
- Fork event: 3
- Create event: 8
Last Year
- Issues event: 22
- Watch event: 86
- Delete event: 2
- Issue comment event: 30
- Push event: 32
- Pull request review event: 8
- Pull request review comment event: 6
- Pull request event: 16
- Fork event: 3
- Create event: 8
Committers
Last synced: almost 3 years ago
All Time
- Total Commits: 503
- Total Committers: 71
- Avg Commits per committer: 7.085
- Development Distribution Score (DDS): 0.521
Top Committers
| Name | Commits | |
|---|---|---|
| Eduardo Blancas | g****b@b****o | 241 |
| Catherine Devlin | c****n@g****m | 62 |
| Catherine Devlin | c****n@k****m | 32 |
| Tony Kuo | 1****r@u****m | 17 |
| Catherine Devlin | c****n@g****v | 15 |
| Olivier Le Thanh Duong | o****r@l****e | 10 |
| Ido M | m****o@g****m | 8 |
| Rodolfo Ferro | r****z@g****m | 5 |
| George Duncan | 1****n@u****m | 5 |
| meihkv | m****g@g****m | 5 |
| yafimvo | 1****o@u****m | 5 |
| Xiaochuan Yu | x****e@g****m | 4 |
| Eduardo Blancas | e****s@g****m | 4 |
| Palash Shah | 3****o@u****m | 4 |
| Jared Moore | j****e@g****m | 4 |
| Jonathan Larkin | j****n@c****g | 3 |
| Jacob Stoebel | j****l@g****m | 3 |
| Amjith Ramanujam | a****h@n****m | 3 |
| Catherine Devlin | c****n@d****m | 3 |
| Jens Albrecht | j****t@t****e | 3 |
| yafimvo | y****o@g****m | 3 |
| WSShawn | 5****n@u****m | 3 |
| yafim | i****o@g****m | 3 |
| Ayushmaan Shrotriya | 6****a@u****m | 2 |
| Andres Celis | a****s@o****m | 2 |
| Gil Raphaelli | g@r****m | 2 |
| WisdomWolf | w****f@g****m | 2 |
| Matthew Rocklin | m****n@g****m | 2 |
| Berton Earnshaw | b****w@g****m | 2 |
| Darik Gamble | d****e@g****m | 2 |
| and 41 more... | ||
Committer Domains (Top 20 + Academic)
getweave.com: 2
blancas.io: 1
kace.com: 1
gsa.gov: 1
lethanh.be: 1
columbia-imc.org: 1
netflix.com: 1
disneystreaming.com: 1
th-nuernberg.de: 1
raphaelli.com: 1
cs.princeton.edu: 1
contractor.p66.com: 1
benmabey.com: 1
columbia.edu: 1
cpan.org: 1
nes.ru: 1
microsoft.com: 1
nicholaswold.com: 1
sornars.com: 1
dpaw.wa.gov.au: 1
Issues and Pull Requests
Last synced: 6 months ago
All Time
- Total issues: 292
- Total pull requests: 228
- Average time to close issues: about 2 months
- Average time to close pull requests: 11 days
- Total issue authors: 76
- Total pull request authors: 36
- Average comments per issue: 2.52
- Average comments per pull request: 3.21
- Merged pull requests: 154
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 30
- Pull requests: 19
- Average time to close issues: 8 days
- Average time to close pull requests: 13 days
- Issue authors: 27
- Pull request authors: 8
- Average comments per issue: 1.07
- Average comments per pull request: 0.58
- Merged pull requests: 9
- Bot issues: 0
- Bot pull requests: 0
Top Authors
Issue Authors
- edublancas (110)
- idomic (26)
- neelasha23 (21)
- tonykploomber (9)
- nooodle-soup (8)
- mehtamohit013 (6)
- tekumara (4)
- maciejb (4)
- lfunderburk (4)
- psychemedia (3)
- dominijk (3)
- bbeat2782 (3)
- sqlreport (2)
- Zirescu (2)
- flaviomartins (2)
Pull Request Authors
- neelasha23 (46)
- edublancas (45)
- bbeat2782 (22)
- bryannho (18)
- mehtamohit013 (16)
- nooodle-soup (16)
- tonykploomber (13)
- anupam-tiwari (7)
- yafimvo (5)
- idomic (5)
- b1ackout (4)
- danielsparing (4)
- xofbd (4)
- laowantong (4)
- AnirudhVIyer (3)
Top Labels
Issue Labels
stash (17)
good first issue (14)
med complexity (11)
documentation (9)
bug (8)
high priority (6)
high complexity (1)
API change (1)
no-changelog (1)
Pull Request Labels
no-changelog (58)
allow-workflow-edits (15)
Owner: Eduardo (5)
bug (5)
Owner: Yafim (4)
Owner: Ido (4)
Owner: Tony (3)
feature (3)
Packages
- Total packages: 1
-
Total downloads:
- pypi 64,919 last-month
- Total docker downloads: 2,894
- Total dependent packages: 4
- Total dependent repositories: 10
- Total versions: 52
- Total maintainers: 2
pypi.org: jupysql
Better SQL in Jupyter
- Homepage: https://github.com/ploomber/jupysql
- Documentation: https://jupysql.readthedocs.io/
- License: Apache Software License
-
Latest release: 0.11.1
published 11 months ago
Rankings
Dependent packages count: 1.6%
Downloads: 2.4%
Docker downloads count: 2.8%
Stargazers count: 2.9%
Average: 3.3%
Dependent repos count: 4.7%
Forks count: 5.6%
Maintainers (2)
Last synced:
6 months ago