postgresql   32036

« earlier    

Using Kubernetes to Deploy PostgreSQL | Severalnines
Using Kubernetes to Deploy PostgreSQL - Added August 11, 2018 at 12:07PM
devops  kubernetes  postgresql  read2of 
19 hours ago by xenocid
Database Soup: Should I Run Postgres on Kubernetes? Part II
Should I Run Postgres on Kubernetes? Part II - Added July 19, 2018 at 12:01PM
kubernetes  postgresql  read2of 
yesterday by xenocid
[Video] Introduction to JSON data types in PostgreSQL |
[Video] Introduction to JSON data types in PostgreSQL - Added July 12, 2018 at 01:28PM
postgresql  read2of 
2 days ago by xenocid
pgFormatter
Free Online version of pgFormatter a PostgreSQL SQL syntax beautifier (no line limit here up to 100000 characters).
postgresql  sql 
2 days ago by f440
Just a Theory [Past]: Always Use TIMESTAMP WITH TIME ZONE
cropp • 6 years ago
I am slightly lost as to why setting the servers default session time zone to 'UTC' makes any sense if you never view your data in 'UTC'. Is this to protect someone trying to insert time without timezone into a timestamp with time zone field? I agree both the app inserting data and the app displaying data should make sure to set there timezone, but if every time I login with pg admin or command line I have to type 'set session time zone PST or PST8PDT' because that's how a business interacts with there data then it makes no sense.


•Share ›
Avatar
Basil Bourque cropp • 5 years ago
I too was confused by the sixth bullet:

If your app always needs data in some other time zone, have it SET timezone = 'UTC' on connection.
I assume that was a typo. Perhaps he meant something like:

If your app always needs data in some other time zone,
have it SET timezone = 'XXX' on connection, where XXX is the desired time zone.
1
•Share ›

Avatar
justatheory Mod Basil Bourque • 5 years ago
Yes, that's right.
postgresql 
3 days ago by initself

« earlier    

related tags

11  2018  201810  all  analytics  api  app  article  aurora  authentication  aws  caldav  calendar  case  check  classes  cli  client  clustering  code  commandline  commands  config  configuration  connection_pooling  connections  constraint  database  databases  datagrip  dbix_class  dev  devops  diagram  distributed  django  docker  documentation  drawing  dsl  echo  extension  format  formatter  game  games  geolocation  gis  graphql  heroku  howto  indexing  insert  jetbrains  json  jsonb  kubernetes  linux  lua  misc  monitoring  mssql  mysql  network  oct18  offline  ohlc  online  opensource  ops  optimization  oracle  performance  perl  php  plugin  pool  postgres  postgresweekly  profdev  programming  prometheus  proxy  psql  python  rails  rds  read2of  realestate  ruby  scale  schema  search  security  server  service  set  shapefiles  sql  sqlite  sqlserver  ssh  string  syntax  sysadmin  tips  tool  toread  tuning  tunnel  tutorial  video  visualization  wal  windows 

Copy this bookmark:



description:


tags: