9504 shaares
222 private links
222 private links
36 results
tagged
PostgreSQL
Everything is in it, but has to be found.
There are dedicated sections for SQL or DBA for example.
Find relevant indexes to set based on the usage of the postresSQL database.
Project challenges:
- Leadership disruption
- Poor Reputation
- Patent Attacks
- Identity Challenges
- Cloud Vendor Starvation
Competitive Challenges
- Decline of relational
- other solutions: embedded, document, columnar, data warehouse, full text search et time series
- rise of fork
Technical challenges
- write amplification
- cluster file encryption
- horizontal scaling
- obsolete toolchain (programming languages, support libraries, testing frameworks)
- drastic technology changes: new language, architecture or storage are difficult for Postgres to adopt
Inquiet de la perte de connaissance du métier de DBA. C'est une inquiétude qui me semble justifié.
Create webpages from SQL requests
Convert a Postgres SQL database directly into an HTTP API
Clever and efficient
TL;DR;
MySQL is a pretty poor database, and you should strongly consider using Postgres instead
Bien utiliser les indexes des systèmes de gestion de base de données. Plusieurs systèmes sont passées en revue.