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,172 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
keepsimple1
keepsimple1 commented Mar 12, 2021

https://github.com/diesel-rs/diesel/blob/c2366e8a0ba7d97c6824b6e0cd5705c9710e0cc1/diesel/src/connection/mod.rs#L41

The current doc does not mention what happens if the database_url does not exist. Should the method create a new database automatically? Or, is it implementation-dependent? It seems like SQLite3 driver does create a new database if not exists yet, mostly because of its C FFI. But

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