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 15,489 public repositories matching this topic...

dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

KristjanTammekivi
KristjanTammekivi commented Jan 11, 2021

Environment

Knex version: 0.21.12
Database + version: Postgres 13
OS: Linux

Bug

  1. Explain what kind of behaviour you are getting and how you think it should do

Combining .pluck() with .first() yields strange behaviors. If .first() is before .pluck(), then the result is an array of plucked elements. If .first() is before .pluck() then the result is object with the plucked key and

directus
cube.js
prisma
timsuchanek
timsuchanek commented Feb 3, 2021

I have a Postgres connection string of this form:

postgres://postgres:pw@lol.hello.eu-west-1.rds.amazonaws.com/my-db

When I do prisma db push, I get this:

Datasource "db": PostgreSQL database "my-db", schema "public" at "lol.hello.eu-west-1.rds.amazonaws.com:undefined"

It seems like we should fill in the default value for the port if it's not in the connection string.

dawid-nowak
dawid-nowak commented Nov 29, 2020

Is it supported at the moment to have 'serialize_as' and 'deserialize_as' on the single field in the sturcture as shown below?

#[derive(Identifiable, Queryable, PartialEq, Debug, Serialize, Deserialize, Insertable)]
#[table_name = "blah"]
pub struct Data {

    #[diesel(serialize_as = "SensitiveStringSerializer")]   
    #[diesel(deserialize_as = "SensitiveStringDeserializer")]

   

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 Dec 23, 2020
  • Python

Created by Michael Stonebraker

Released July 8, 1996

Repository
postgres/postgres
Website
www.postgresql.org
Wikipedia
Wikipedia