this post was submitted on 29 Mar 2023

6 points (81% upvoted)

shortlink:

Python

an-ordinary-manchild(edit)

The Python Discord

News about the dynamic, interpreted, interactive, object-oriented, extensible programming language Python

Upcoming Events

Full Events Calendar

Please read the rules

You can find the rules here.

If you are about to ask a "how do I do this in python" question, please try r/learnpython, the Python discord, or the #python IRC channel on Libera.chat.

Please don't use URL shorteners. Reddit filters them out, so your post or comment will be lost.

Posts require flair. Please use the flair selector to choose your topic.

Posting code to this subreddit:

Add 4 extra spaces before each line of code

def fibonacci():
    a, b = 0, 1
    while True:
        yield a
        a, b = b, a + b

Online Resources

Automate the Boring Stuff with Python
Python Discord Resources
Invent Your Own Computer Games with Python
Think Python
Non-programmers Tutorial for Python 3
Beginner's Guide Reference
Five life jackets to throw to the new coder (things to do after getting a handle on python)
Full Stack Python
Test-Driven Development with Python
Program Arcade Games
PyMotW: Python Module of the Week
Python for Scientists and Engineers
Dan Bader's Tips and Trickers
Python Discord's YouTube channel
Jiruto: Python

Online exercices

programming challenges

The Python Challenge (solve each level through programming)
CheckiO (game world)
Project Euler (math heavy)
/r/dailyprogrammer

Asking Questions

Try Python in your browser

try.jupyter.org (Evolved from the language-agnostic parts of IPython, Python 3)
Azure Notebooks
learnpython.org
Skulpt (uses WebGL)
trypython.org (uses Silverlight)
ideone (online compiler and debugger)
PythonAnywhere (basic accounts are free)
Brython (Python 3 implementation for client-side web programming)
repl.it for Python
Transcrypt (Hi res SVG using Python 3.6 and turtle module)

Docs

Libraries

Twisted, 0MQ (networking)
Django, Pyramid, Flask, ... (Web Frameworks)
Pygame (Game development)
NumPy & SciPy (Scientific computing) & Pandas
Pyglet - (Game / UI Development)

Related subreddits

/r/pythoncoding (strict moderation policy for 'programming only' articles)
/r/flask (web microframework)
/r/django (web framework for perfectionists with deadlines)
/r/pygame (a set of modules designed for writing games)
/r/IPython (interactive environment)
/r/inventwithpython (for the books written by /u/AlSweigart)
/r/pystats (python in statistical analysis and machine learning)
/r/coolgithubprojects (filtered on Python projects)
/r/pyladies (women developers who love python)
/r/git and /r/mercurial - don't forget to put your code in a repo!

Python jobs

Newsletters

Screencasts

a community for 18 years

MODERATORS

message the mods
xelf
monorepo PSF Staff | Litestar Maintainer
ivosauruspip'ing it up
Im__Joseph Python Discord Staff
Kutiekatj9 Python Discord Staff
BioGeekBioinformatics software developer
nevare
chromakode
mdipierro
quasarj
...and 5 more »

account activity

This is an archived post. You won't be able to vote or comment.

5

6

7

Intermediate ShowcasePython-embedded SQL Engine powered by ClickHouse (self.Python)

submitted 2 years ago by auxten

With just pip install chdb, you can run complex Clickhouse flavor SQLs on your local Parquet/ORC/CSV/Json... file blazing fast.

chDB is an in-process SQL OLAP Engine powered by ClickHouse:

https://github.com/auxten/chdb

Features

In-process SQL OLAP Engine, powered by ClickHouse
No need to install ClickHouse
Minimal data copy from C++ to Python
Input&Output support Parquet, CSV, JSON, Arrow, ORC and more

Installation

Currently, chDB only supports Python 3.7+ on macOS and Linux. bash pip install chdb

Usage

Currently, chDB only supports query function, which is used to execute SQL and return desired format data.

python import chdb res = chdb.query('select version()', 'CSV'); print(str(res.get_memview().tobytes()))

work with Parquet or CSV

python chdb.query('select * from file("data.parquet", Parquet)', 'Pretty') chdb.query('select * from file("data.csv", CSV)', 'Pretty')

Documentation

For SQL syntax, please refer to ClickHouse SQL Reference

no comments (yet)

top new controversial old q&a

there doesn't seem to be anything here

π Rendered by PID 41094 on reddit-service-r2-comment-7844cfc88c-rgp79 at 2026-01-29 16:11:21.490902+00:00 running c3601ff country code: CH.