6891 shaares
15 results
tagged
PostgreSQL
- pg_trunk is a package manager for PostgresSQL databases.
- stored procedures allows to put logic into the postgres database
- extensions can generate JWT tokens, auth, ...
- caching with K/V stores: pg_cron & h_store
- pub/sub: PSQL notify/listen
- message queue with pgmg
- NoSQL databases are moving to support SQL (or mimic such a language)
- Time series with TimescaleDB
- Search terms with full-text search
- Rest API with PostgREST.
- Omnigres to create a complete platform
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.
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.