Popularity

6.3

Growing

Activity

0.0

Declining

Stars 2,213

Watchers 35

Forks 265

Last Commit 6 days ago

Description

PyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting the flexibility of handwritten SQL. Designed with data analysis in mind, PyPika leverages the builder design pattern to construct queries to avoid messy string formatting and concatenation. It is also easily extended to take full advantage of specific features of SQL database vendors.

Programming language: Python

License: Apache License 2.0

Tags: Database ORM Relational Databases Scientific Engineering Information Analysis Mathematics

Latest version: v0.46.0

PyPika alternatives and similar packages

Based on the "Database" category.
Alternatively, view PyPika alternatives based on common mentions on social networks and blogs.

TinyDB

8.2 5.6 L5 PyPika VS TinyDB

TinyDB is a lightweight document oriented database optimized for your happiness :)
PipelineDB

6.6 0.0 L1 PyPika VS PipelineDB

High-performance time-series aggregation for PostgreSQL

Learn any GitHub repo in 59 seconds

Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.

Promo getonboard.dev

ZODB

4.3 0.0 L3 PyPika VS ZODB

Python object-oriented database
pickleDB

4.3 0.0 L5 PyPika VS pickleDB

pickleDB is an open source key-value store using Python's json module.
dbj

0.9 3.6 PyPika VS dbj

Simple embedded in memory json database
MerkavaDB

0.5 0.0 PyPika VS MerkavaDB

A fast ordered NoSQL database.
SSShelf

0.4 0.0 PyPika VS SSShelf

An ORM for S3