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 16,061 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

yodhcn
yodhcn commented Feb 13, 2021

Feature request

Is there any chance to have a Knex native way to set "DEFERRABLE INITIALLY DEFERRED" on a table with foreign key constraints ?

knex.schema.table('users', function (table) {
  table.integer('user_id').unsigned()
  table.foreign('user_id').references('Items.user_id_in_items').deferred().
})
directus
cube.js
zameschua
zameschua commented Feb 24, 2021

As per the title

I wanted to use cubejs backend-server with an existing expressjs deployment, so I'm trying to avoid adding too many environment variables because they can be hard to keep track of (there are already many environment variables in the existing project) and I just thought it'd be a natural progression since most of the env configs can already be set from code :)

prisma
jasonkuhrt
jasonkuhrt commented Feb 6, 2021

I am intentionally making this issue specific but I assume it could be expanded to include much more of the API.

Problem

I do not have the entire Prisma Client API perfectly (let alone roughly) committed to memory.

When I go to use it to query for many results the operations tell me nothing about what and why they will do. I only have types to work with.

I don't want to open my br

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")]

   
supabase
AronBe
AronBe commented Feb 18, 2021

It happened to me I deleted a column that had a foreign key constraint and for someone not working with databases, I didn't know it is a nono. It resulted in having multiple foreign keys after I added a new one to replace it.

Maybe we could either prevent it or warn the user that the foreign key should be first removed on the dropped column? Or remove the constraint with the column? Also, why c

Created by Michael Stonebraker

Released July 8, 1996

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