all AI news
Constraints
Dec. 8, 2023, 2 p.m. | Nikolay Samokhvalov and Michael Christofides
Postgres FM postgres.fm
Nikolay and Michael discuss PostgreSQL constraints — the six different types we have, how to add and modify them, including on large tables with high TPS.
Here are some links to things they mentioned:
- Constraints (docs) https://www.postgresql.org/docs/current/ddl-constraints.html
- Unique index vs unique constraint issue (2017) https://www.postgresql.org/message-id/flat/CANNMO%2B%2B7%2BuVMj%2BZPGKB_zuRpKE0sNthy2Z-_oKSS%3DoE3_rN7QA%40mail.gmail.com
- Our episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown
- Advanced Int to Bigint Conversions (talk by Robert Treat) https://www.youtube.com/watch?v=_IieyXzdmcM
- Use BIGINT in Postgres (blog post by Ryan Lambert) https://blog.rustprooflabs.com/2021/06/postgres-bigint-by-default
- How to add a foreign key (Tweet by Nikolay) https://twitter.com/samokhvalov/status/1732056107483636188 …
More from postgres.fm / Postgres FM
Jobs in AI, ML, Big Data
Data Engineer
@ Michelin | Pune
Senior Research Analyst, Global Analytics & Measurement
@ NBCUniversal | London, United Kingdom
Research Scientist
@ Meta | Menlo Park, CA
NLP Speech Research Intern
@ Tencent | UK-London
Junior Senior Reliability Engineer
@ NielsenIQ | Bogotá, Colombia
[Job - 15712] Vaga Afirmativa para Mulheres - QA (Automation), SR
@ CI&T | Brazil