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 21,543 public repositories matching this topic...

xaragen
xaragen commented Aug 10, 2021

Working on a project I ran into the documentation for customizing the Foreign Key.
The docs read:

// https://sequelize.org/master/manual/assocs.html
// For example, to use UUID as the foreign key data type instead of the default (INTEGER), you can simply do:

const { DataTypes } = require("Sequelize");

Foo.hasOne(Bar, {
  foreignKey: {
    // name: 'myFooId'
    type: D
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

supabase
MildTomato
MildTomato commented Nov 8, 2021

Chore

Describe the chore

There is basic titles and descriptions missing from many pages in www and web.

folders for these sites are:
www
web

an example of how we can improve

the supabase.io/support page has the following:
<img width="1178" alt="Screenshot 2021-11-08 at 15 45 55" src="https://user-images.githubusercontent.com/8291514/140702956-ef7a3b26-717a-410c-a3cf-

prisma
binary64
binary64 commented Aug 2, 2021

Bug description

On windows, I run prisma format and note the unusual file ending. The lines are all LF, but the very last line is CRLF.

This causes issue on my Linux CI where it formats it ending in LF's only, causing a diff to occur and the build to fail.

How to reproduce

  1. On windows do prisma format
  2. Open in HxD or similar
  3. See attached:

![image](https://user-images.g

directus
cube.js
leogodin217
leogodin217 commented Sep 17, 2021

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

  • All unquoted column names are treated as upper case
  • Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

questdb
TheTanc
TheTanc commented Nov 21, 2021

Is your feature request related to a problem?

I like to use the chart tab in the console. However, the chart scale is not customisable and starts at 0. This makes it hard to visualise data where the changes are relatively small.

Describe the solution you'd like.

Either

  • Dynamic scaling of the charts based on results values
  • Manual scaling by adding a range min/max input in the con

Created by Michael Stonebraker

Released July 8, 1996

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