Home / Python / Database Drivers

A pandas.DataFrame-based ORM.

jardin jardin (noun, french) – garden, yard, grove. Jardin is a pandas.DataFrame-based ORM for Python applications. Installation $ pip install jardin or $ echo 'jardin' >> requirements.txt $ pip in
Information
Category: Python / Database Drivers
Watchers: 271
Star: 85
Fork: 9
Last update: Jun 25, 2022
Resource links
https://github.com/instacart/jardin-archived

jardin

jardin (noun, french) – garden, yard, grove.

Jardin is a pandas.DataFrame-based ORM for Python applications.

PyPI version

documentation

Build Status

Installation

$ pip install jardin

or

$ echo 'jardin' >> requirements.txt
$ pip install -r requirements.txt

Documentation

See full documentations and tutorials here.

0 Open More issues
Closed

Query from sql or file

see #5

opened Oct 6, 2017 by mathieuripert 8
Closed

Methods chaining

That would be great to be able to chain methods instead of one select method with multiple arguments.

Instead of

users = Users.select(select = ['id', 'name'], where = {'email': '[email protected]'}, order = 'id ASC', limit = 1)

what about:

users = Users.select(["id", "name"]).where({'email': '[email protected]'}).order('id ASC').limit(1)
enhancement 
opened Oct 6, 2017 by mathieuripert 4
Closed

Upgrade psycopg2

I think the rollbars we've been seeing on the model endpoints are the result of this issue: https://github.com/psycopg/psycopg2/issues/346

My thought is that we upgrade here and then simulate upgrading jardin in batching.

Not sure if we want to pin to 2.7.7 though -- thoughts? https://pypi.org/project/psycopg2/

opened May 20, 2020 by gjreda 3
Closed

Mathieu/pandas fixes

two pandas fixes: 1- pandas.tslib.NaTType is deprecated and can be replaced by using type(pandas.NaT) 2- use pandas.DataFrame.from_records() (see issue https://github.com/instacart/jardin/issues/34)

also, i could not fix the isssue with freezegun and pandas >= 0.23 so i restricted the pandas version to be lower than 0.23, until we find a fix

cc @neutralino1

opened Sep 24, 2018 by mathieuripert 3
Closed

type(pd.NaT) instead of pd._libs.tslib.NaTType

The type import pandas.tslib.NaTType is deprecated and can be replaced by using type(pandas.NaT) (GH16146)

It is breaking when using jardin with latest pandas 0.23.

from https://pandas-docs.github.io/pandas-docs-travis/whatsnew.html https://github.com/pandas-dev/pandas/pull/16146

bug 
opened May 23, 2018 by mathieuripert 3
Closed

[Step 4] Make the global list of datasources thread-safe

There were 2 problems here:

  1. reset_session() changes the active database connection as if the program was single-threaded (which was true until event-driven matching came along)
  2. the list of database configurations was initialized lazily, but there was nothing to protect against multiple threads racing to do the initialization.

The first problem was solved by storing the database connections in a thread-local. This allowed me to simplify BaseClient since now it can act like it lives in a single-threaded world.

The second problem was solved by using a lock to guard initialization.

opened Dec 18, 2020 by klazuka 2

0.22.10(Oct 21, 2021)

0.22.9(Oct 15, 2021)

0.22.8(Sep 28, 2021)

0.22.1(Mar 5, 2021)

0.21.1(Feb 13, 2021)

0.21.0(Jan 12, 2021)

Contents

    nv-legate Legate Pandas is a distributed and accelerated drop-in replacement of Pandas
    IntelPython Intel® Scalable Dataframe Compiler for Pandas*
    dotnetcore FreeSql is a powerful O/RM component, supports .NET Core 2.1+, .NET Framework 4.0+, and Xamarin.
    mm-mansour Benchmark for different operations in pandas against various dataframe sizes.
    modin-project Modin: Speed up your Pandas workflows by changing a single line of code
    jmcarpenter2 A package which efficiently applies any function to a pandas dataframe or series in the fastest available manner
    chris1610 sidetable builds simple but useful summary tables of your data
    lolipopshock Seamlessly Connecting Notion Database with Python Pandas DataFrame
    scikit-learn-contrib Pandas integration with sklearn
    Wackymax Content Provider Orm - This is a little orm that functions by using android content providers
    analogueorm Analogue ORM : Data Mapper ORM for Laravel/PHP
    Kitura An ORM for Swift, built on Codable
    tortoise Familiar asyncio ORM for python, built with relations in mind
    vuex-orm vuex-orm-apollo - Apollo/GraphQL integration for Vuex-ORM.
    altair-viz Interactive plotting for Pandas using Vega-Lite
    dovpanda-dev Directions overlay for working with pandas in an analysis environment
    ajcr 100 data puzzles for pandas, ranging from short and simple to super tricky (60% complete)
    sky-uk A Python library for time series forecasting
    artemkulick EVA ORM - Simple asynchronous ORM for SQL databases
    dotcoo ORM library for Go Golang
    onyb Python without ifs and buts - an ORM layer for Python objects, inspired by Django
    Share this repo

    Related Repos


    Database Drivers
    3
    Apache Cassandra Live Metrics Monitoring Dashboard.
    oslabs-beta Apache Cassandra Live Metrics Monitoring Dashboard. Features: An application built in Electron that offers performance metrics and visual graphs for c
     
    Database Drivers
    28
    Migrate data from SQL to NoSQL easily
    facundopadilla Migrate data from SQL to NoSQL easily
     
    Database Drivers
    27
    PartyBid is a collector DAO that lets individuals pool capital, bid on Mirror's reserve au...
    Anish-Agnihotri PartyBid is a collector DAO that lets individuals pool capital, bid on Mirror's reserve auctions, and resell NFTs.
     
    Database Drivers
    4.4k
    A SQL linter and auto-formatter for Humans
    sqlfluff Bored of not having a good SQL linter that works with whichever dialect you're working with? SQLFluff is an extensible and modular linter designed to help you write good SQL and catch errors before it hits your database. SQLFluff can auto-fix most linting errors too.
     
    Database Drivers
    30
    A very simple asynchronous wrapper that makes you can access to Oracle in asyncio programs...
    GoodManWEN A very simple asynchronous wrapper that makes you can access to Oracle in asyncio programs.
     
    Database Drivers
    12
    A Python client for accessing OpenNeuro datasets.
    hoechenberger A Python client for accessing OpenNeuro datasets.
     
    Database Drivers
    1k
    Simple SQL in Python
    nackjicholson SQL is code, you should be able to write it, version control it, comment it, and run it using files. Writing your SQL code in Python programs as strings doesn't allow you to easily reuse your SQL in database GUI tools or CLI tools like psql
     
    Database Drivers
    41
    SQLi Query Tampering extends and adds custom Payload Generator/Processor in Burp Suite's I...
    xer0days SQLi Query Tampering extends and adds custom Payload Generator/Processor in Burp Suite's Intruder. This extension gives you the flexibility of manual testing with many powerful evasion techniques.
     
    Database Drivers
    992
    walrus - Lightweight Python utilities for working with Redis
    coleifer walrus - Lightweight Python utilities for working with Redis
     
    Database Drivers
    78
    A one-of-a-kind, stupid fast, Python API using Redis Protocol and MsgPack
    hansonkd Tino is a framework to remotely call functions. It builds both clients and servers.
     
    Database Drivers
    4
    [WIP] Empowering you to use complex SQL, but without writing them directly.
    StephenKevin Zugh [WIP] Access to database in pythonic way Zugh Status Required Licence Install Usage Connection Config Pool Database Table Query Object Insert
     
    Database Drivers
    67
    MySQL Backup and Point-in-time Recovery service
    aiven MyHoard MyHoard is a daemon for creating, managing and restoring MySQL backups. The backup data can be stored in any of the supported cloud object storages. It is functionally similar to pghoard backup daemon for PostgreSQL.
     
    Database Drivers
    3
    Another free MongoDB schema analyser based on PyMongo and wxPython.
    HanseyLee PyMonSchema Another free MongoDB schema analyser based on PyMongo and wxPython. Fast and Effective by using MongoDB MapReduce to analyse collection schema, simple yet powerful. Author: HanseyLee Screeshot
     
    Popular
    Database Drivers
    5.6k
    The Database Toolkit for Python
    sqlalchemy SQLAlchemy The Python SQL Toolkit and Object Relational Mapper Introduction SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
     
    Database Drivers
    85
    A pandas.DataFrame-based ORM.
    instacart jardin jardin (noun, french) – garden, yard, grove. Jardin is a pandas.DataFrame-based ORM for Python applications. Installation $ pip install jardin or $ echo 'jardin' >> requirements.txt $ pip in