Der zuverlässige und perfomante Betrieb von relationalen Datenbanken kann sehr aufwendig und komplex sein. Dies gilt vor allem, wenn man...
If you use third party APT sources you might end up with unmaintained packages after removing the external source or...
If your postgres database is only accessible from inside a kubernetes cluster, e.g. if it's configured in AWS RDS...
SELECT pg_size_pretty(pg_database_size('some-database')); Example SELECT pg_size_pretty(pg_database_size('cards_p')); ----------------
When paginating records, we usually need to know the number of total records in order to render pagination links. Popular...
I recently wanted to add a model for address information but also wanted to add a unique index to those...
There is a way to use multiple databases in Rails. You may have asked yourself how you're able to...
Schau dir den unter Inhalte verlinkten Udemy Kurs an. Die Zugangsdaten für Udemy bekommst Du von deinem Mentor. Überspring Inhalte...
Sometimes we write plain SQL queries in migrations so we don't have to mock ActiveRecord classes. These two migrations...
The linked article points out that COUNT queries might be unexpectedly slow in PostgreSQL. If you just need to know...
When you repeat a subpattern with a *, + or {...} operator, you may choose between greedy, lazy and possessive modes. Switching modes...
PostgreSQL has partial indexes. With a partial index you tell Postgres to only index rows matching a given query.
We currently test most of our gems on Travis CI, but want to migrate those tests to Github Actions. This...
When loading a database dump created with pg_dump into your database, you might run into an error like
It sometimes happen that a database dump, that would want to insert into your development database, does not match the...
If you want to prevent that two processes run some code at the same time you can use the gem...
GoodJob is a new background worker gem. It's compatible with ActiveJob. We're huge fans of Sidekiq for its...
If you have a :string or :text field, you should pair it with a model validation that restricts its length...
PostgreSQL offers three character types for your columns: character varying(n) (also called varchar or just string): Contents are limited...
We can use ActiveRecord's where to add conditions to a relation. But sometimes our condition is not on the...
PostgreSQL and ActiveRecord have a good support for storing dynamic attributes (hashes) in columns of type JSONB. But sometimes you...
It's every developer's nightmare: SQL queries that get large and unwieldy. This can happen fairly quickly with the...
There is an issue with when restoring a PostgreSQL dump created with pg_dump < v11 with pg_restore > v10:
As an application exists, data accumulates. While you'll be loosely monitoring the main models' record count, some supportive database...