The Wayback Machine - https://web.archive.org/web/20210324081752/https://github.com/topics/postgresql
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,344 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().
})
psychobunny
psychobunny commented Dec 31, 2020

https://docs.nodebb.org/installing/os/osx-mavericks/

Though we do have iOS devices for mobile testing, our core team doesn't actually own a mac (fight this war somewhere else :P). Would anyone with access to one mind testing and updating this page please? :)

More importantly the instructions for redis should be switched to mongo as it is our default recommended install; you can look at the

directus
rijkvanzanten
rijkvanzanten commented Mar 23, 2021

Currently, we're relying on path.normalize for normalizing the root configuration:

https://github.com/directus/directus/blob/2f163a91b440e753216fcfe5f5d1aea8687f23c4/packages/drive-azure/src/AzureBlobWebServices.ts#L48

However, this causes trouble under Windows, as these third party services rely on Unix paths exclusively (eg / instead of \).

For Azure, GCS, and S3, we should rely o

cube.js
uulwake
uulwake commented Mar 11, 2021

Describe the bug
I want to connect to Redis Memory store in GCP and got the following error:

Error: Redis connection to <port> failed - unable to verify the first certificate at TLSSocket.onConnectSecure
(_tls_wrap.js:1502:34) at TLSSocket.emit (events.js:314:20) at TLSSocket._finishInit (_tls_wrap.js:937:8) at
TLSWrap.ssl.onhandshakedone (_tls_wrap.js:711:12) 

*To Reproduce

prisma
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

dragonismcode
dragonismcode commented Mar 21, 2021

Describe the bug
When creating a scheduled room, you'll have the Edit & Delete button there because you own the scheduled room. But, the Add to Calendar button is moved to the side.

To Reproduce
Steps to reproduce the behavior:

  1. Go to the Scheduled Rooms button
  2. Schedule a test room or see an already scheduled room that you own
  3. See error

Expected behavior
Make the "A

Created by Michael Stonebraker

Released July 8, 1996

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