PostgreSQL

PostgreSQL is a database management system that is object-relational. PostgreSQL originated from the Ingres project at the University of California, Berkeley.

Introduction 📝 📈 🔧 🏗️

This tutorial should go over training a model using MindsDB that predicts Machine Failure. Example dataset can be found here.

Tutorial summary 🧾

The tutorial should follow the below steps 🔢 :

Connect

Example of usage:

users = await User.filter(first_name__ilike="c%r")

I know this can be done with startswith and endswith, but there are cases where using the LIKE operator is better:

users = await User.filter(first_name__ilike="j_r%")

This would be used to match Jeremy, Jorge, Jordan...

I am using PG server in a certificate pinned environment. In Python / SQLAlchemy, this is the following code needed to connect:

pg_certs = {
    'sslcert': 'certs_dir/client-cert.pem',
    'sslkey': 'certs_dir/client-key.pem',
    'sslrootcert': 'certs_dir/server-ca.pem',
}

create_engine(pg_url, connect_args={'sslmode': 'require', **pg_certs}, ...)

Does Migra support this? I

It would be nice if there was a new clause which can be added to queries called callback.

For example:

def callback_handler(success, value):
    if success:
        print(f'The query was successful and returned {value}')
    else:
        print("The query failed")

Band.select().callback(callback_handler).run_sync()

The callback could be a function or coroutine, wh

Mar	APR	May
	09
2021	2022	2023

PostgreSQL

Here are 3,955 public repositories matching this topic...

getredash / redash

dbcli / pgcli

tiangolo / full-stack-fastapi-postgresql

mindsdb / mindsdb

Introduction 📝 📈 🔧 🏗️

Tutorial summary 🧾

donnemartin / dev-setup

MagicStack / asyncpg

zalando / patroni

wal-e / wal-e

ponyorm / pony

tortoise / tortoise-orm

formspree / formspree

djrobstep / migra

mara / mara-pipelines

tarunkant / Gopherus

nsidnev / fastapi-realworld-example-app

ibis-project / ibis

dalibo / pg_activity

EnterpriseDB / barman

aio-libs / aiopg

fofapro / fapro

aiven / pghoard

twtrubiks / docker-tutorial

zalando / spilo

Alexis-benoist / eralchemy

bram2w / baserow

piccolo-orm / piccolo

zenodo / zenodo

05bit / peewee-async

ycd / manage-fastapi

psycopg / psycopg