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,140 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
aleksejssaburovs92
aleksejssaburovs92 commented Mar 9, 2021

Try to get error popup, add large content, popup is overflowing screen

Version: v9.0.0-rc.45
Installation and running: CLI (npx)
DB: mysql8

Suggestion:
add styles for v-card-text as example:
max-height: 60vh;
overflow: scroll;

<img width="1776" alt="Screenshot 2021-03-09 at 20 13 49" src="https://user-images.githubusercontent.com/12848012/110518019-457bc380-8114-11eb-9189-c65a71f

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

dzsquared
dzsquared commented Mar 8, 2021

For a user to be able to navigate the OE tree or look at another application while writing a new object/table/procedure name in SQL database projects, the input box needs to remain open on alternative focus.
the ignoreFocusOut: true property would allow the user more flexibility in writing the name
https://code.visualstudio.com/api/references/vscode-api#QuickInput

Created by Michael Stonebraker

Released July 8, 1996

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