Ruby on Rails has an `Model.upsert` method relying on table constraints to throw errors. It uses Postgres database constraints to throw errors on duplicate. With Rails you can see the query run for any command. You can even copy / paste that SQL and run it for yourself.

Winter Postgres cleanup: add constraints for stricter data integrity next year. Don't want null values coming from the application? Not-null constraint is the go to for adding a strict policy. ALTER TABLE public.reservations ALTER COLUMN start_time SET NOT NULL;

"Postgres compatible" - No views/triggers/sequences - No foreign key constraints - No extensions - No NOTIFY ("ERROR: Function pg_notify not supported") - No nested transactions - No JSONB What, what IS it compatible with?

If you are not using exclusion constraints in your Postgres tables in 2023, you're FALLING BEHIND. 🧵 1/666 jk lol, but this is a cool feature that only PG has. Video by yours truly, including the bassline. If you don't write the basslines for your videos, you're FALLING BEHIND.

Sometimes it's more convenient to use a check constraints instead of enums in Postgres. Check constraints are flexible/portable to add/remove from the list at the expense of some db type safety/perf/storage Rails supports both without resorting to a structure.sql

Postgres has json support! You can lock up the schema of the json columns by adding a constraint using pg_jsonschema extension like the image 👇 This is a relatively simple example, but you can have nested objects, dependencies, and many more constraints to meet your needs 😎

not as versatile as app code validations with a tool like zod, but pretty cool that postgres and mysql can do some amount of schema validation for json columns via check constraints

congrats to the @PostgreSQL contributors 🐘 ◆ asynchronous I/O ◆ UUIDv7 ◆ virtual generated columns ◆ temporal constraints ◆ oauth authentication ◆ improved text search ◆ parallel streaming in replication ◆ new wire protocol (first new protocol version since 2003)

We are seeing rise of Agentic Postgress. Both Neon and Tiger Data are seeing rise in their usability. Traditional Postgres is fantastically reliable - just not optimized for autonomous, programmatic workflows at the velocity and safety constraints of agents. Agentic Postgres

Adding proper constraints in your database is critical for keeping your data clean. Learn 4 techniques you can use with check constraints in Postgres 👇

Some of the most important updates in #PostgreSQL happen deep in the code. #PG18 reworks how NOT NULL constraints are stored and validated, modernizing decades-old logic while keeping perfect compatibility. More in our blog: https://t.co/pFPHT4wf6l

Range columns are one of my favorite features of Postgres! It allows you to represent a start and an end of something like timestamps, and apply constraints to prevent overlaps with various conditions. Learn how you can use them in your applications in this video 👇

Most people who use Postgres take this feature for granted. Just before a new feature goes into production, data migrations have to run: new tables, new columns, new relationships, and new constraints. Most migrations succeed. What would happen if half the migrations are

Why I chose Postgres over MongoDB: strong consistency, complex queries, data integrity with constraints, mature ecosystem. NoSQL flexibility wasn't worth the tradeoffs. What do you use?

One of the things that makes Postgres so awesome for software development is the incredibly useful system of constraints. Constraints are a way to tell Postgres which kinds of data can be inserted into tables, columns, or rows. As an application developer, you're going to build

PSA: For the holidays, friends don't let friends use their database without constraints. Constraints? One of the things that makes Postgres so awesome for software development is the incredibly useful system of constraints. Constraints are a way to tell Postgres which kinds of

For relational data with strong constraints, Postgres wins every time.

What You Should Know About Constraints in Postgres | #Postgres #DB

Last week, @benediktdeicke and @andatki Postgres, Rails, database constraints, and more.

Little joys in life: Getting into Postgres Weekly with your blog 🎉 🔗 https://t.co/mFDaeSDd4N 🐘 https://t.co/5LBgZUEsqn