Veze, linkovi
Kompjuter biblioteka
Korpa

Preporučujemo

SQL kuvar

SQL kuvar

SQL for Data Analysis

SQL for Data Analysis

Postgres Weekly 171

Pregleda (30 dana / ukupno): 17 / 992

Postgres is packed with great datatypes, one of them that may not get quite as much attention as JSONB is the Array type. This post starts with the basics then digs into some more advanced uses and operators of it to make things more practical.
RYAN KELLY
If you’re not familiar with concurrent indexing in Postgres, first off you should give them a look. Second, you should know they’re not without their issues which are walked through here.
KEN ALEX FASSONE   #TUTORIAL 
Several European institutions have cited complex licences from their traditional proprietary suppliers as an important reason to deploy PostgreSQL instead.
ADRIAN OFFERMAN   #NEWS 
You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies.
HIRED.​COM    #SPONSORED 
Citus 5.2 is out which is an extension which makes it simple to shard your database, allowing you to scale out. The 5.2 release includes better ORM support, broader SQL coverage, and improved transactional semantics on a single shard.
CITUS DATA   #NEWS 
An intro to indexes, what they are, how to create, as well as some more customized approaches. All of this with a focus on improving your apps performance.
REDPANTHERS   #TUTORIAL 
Generating random data isn’t too hard, but generating a realistic sampling based on some weighting can be. This post walks you through how to do this in SQL, perfect for fake datasets.
MARCO SANTONI   #TUTORIAL 
With support for Postgres 9.5, Walbouncer is a standalone replication proxy, enabling selective replication by forwarding data only for specific databases/tablespaces to the connected replicas.
KAAREL MOPPEL   #TOOLS 
PAPERTRAIL-1
Make the most of log_min_duration_statement. Get notified instantly or receive a daily summary (free).
PAPERTRAIL   #TOOLS  #SPONSORED 
POSTGRES PROFESSIONAL   #CODE 

 

         
Twitter Facebook Linkedin Pinterest Email
         

Budite prvi koji će ostaviti komentar.

Ostavite komentar Ostavite komentar

 

 

 

Veze, linkovi
Linkedin Twitter Facebook
 
     
 
© Sva prava pridržana, Kompjuter biblioteka, Beograd, Obalskih radnika 4a, Telefon: +381 11 252 0 272