Skip to content
#

PostgreSQL

postgresql logo

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

Here are 2,237 public repositories matching this topic...

macOS development environment setup: Easy-to-understand instructions with automated setup scripts for developer tools like Vim, Sublime Text, Bash, iTerm, Python data analysis, Spark, Hadoop MapReduce, AWS, Heroku, JavaScript web development, Android development, common data stores, and dev-based OS X defaults.

  • Updated Jun 20, 2020
  • Python
hyperknot
hyperknot commented Nov 20, 2019

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

usernein
usernein commented May 29, 2020

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...

ZuluPro
ZuluPro commented Aug 15, 2016

Signals could be a good way to let developers interact with DBBackup's actions. I imagine the following:

  • pre_dbbackup & post_dbbackup
  • pre_dbrestore & post_dbrestore
  • pre_mediabackup & post_mediabackup
  • pre_mediarestore & post_mediarestore

I imagine to make a lock or flush something before backup.

Created by Michael Stonebraker

Released July 8, 1996

Repository
postgres/postgres
Website
www.postgresql.org
Wikipedia
Wikipedia
You can’t perform that action at this time.