Constraint — Entidade

stokerpostgresql.blogspot.com·há 4 meses

PostgreSQL, Timezones, and DBeaver

Time zones are an unfortunately complex subject when dealing with PostgreSQL. You may be running your local time zone on your on-premises server or on your own laptop. Or you may be using the time zon

stokerpostgresql.blogspot.com·há 4 meses

Postgres Conference 2026

Postgres Conference 2026 was held in San Jose, California, and once again, I was lucky to be invited to speak. This is a great show for the 'hallway track' where you talk to members of the community a

pvangoor.github.io·há 5 meses

MSCEqF: A Multi State Constraint Equivariant Filter for Vision-Aided Inertial Navigation

This letter re-visits the problem of visual-inertial navigation system (VINS) and presents a novel filter design we dub the multi state constraint equivariant filter (MSCEqF, in analogy to the well kn

stokerpostgresql.blogspot.com·há 7 meses

Is the future of MySQL PostgreSQL (Or MariaDB, or TiDB, or ...)?

I am not intentionally trying to upset anyone with this blog post or minimize the efforts of many brilliant people whom I admire. However, I connected with several people over the 2025 holidays who al

stokerpostgresql.blogspot.com·há 9 meses

DBeaver's Visual Query Builder

Quick! You need to create a complex query, but you don't remember how to join the tables. And you need to get it done ASAP. You are in luck if you have an enterprise edition of DBeaver handy. You ca

stokerpostgresql.blogspot.com·há 9 meses

CSV Loading Error Fix: Data Too Long Or Value Too Long

You are trying to load a CSV file into a database, and almost inevitably, you run into an ERROR: value too long for type character varying 64 if you are using PostgreSQL. Or SQL Error [1406] [22001]:

stokerpostgresql.blogspot.com·há 9 meses

Loading The Titanic Dataset Into PostgreSQL With DBeaver Part 3

In the previous post, we asked AI to make recommendations to help clean up the data loaded directly from a CSV file. The initial data load for the Name failed because a VARCHAR(64) was estimated to be

stokerpostgresql.blogspot.com·há 10 meses

Migration From MySQL To PostgreSQL In Five Steps Using DBeaver

I wrote a post in my MySQL blog on migrating from MySQL to PostgreSQL using DBeaver. You can pass it along to your acquaintances who want to get off the Dolphin and on the Elephant. Not only will DBe