Why Rails has multiple schema formats When you run migrations, Rails will write your current database schema into db/schema.rb. This...
PostgreSQL can cosplay as a full-text search engine. It doesn't have the features or fidelity of ElasticSearch or...
When debugging slow SQL queries, it’s helpful to understand the database engine's query plan. Whenever you execute a...
If you need to pre-generate a scram-sha256 password hash for use with postgres, e.g. for using it with...
While the main goal always is to prevent long-running queries in the first place, automatic timeouts can serve as...
You can improve your LIKE / ILIKE search queries in PostgreSQL by adding a GIN index with an operate class ("opclass...
Recently I needed to benchmark an Active Record query for performance measurements. I wrote a small script that runs each...
I was recently asked to optimize the response time of a notoriously slow JSON API endpoint that was backed by...
When you are using PgBouncer with e.g. a Ruby on Rails application which uses different application_names for the PostgreSQL...
Postgres works differently See PostgreSQL: Difference between text and varchar columns for PostgreSQL-specific info MySQL has 4 different column...
10.0.0 2024-03-07 Compatible changes console command: You can now globally disable the IRB multiline feature by setting irb...
The linked article suggests an interesting way to speed up tests of Rails + Postgres apps: PostgreSQL allows the creation of...
You can use pg_repack to do a VACUUM FULL without holding an exclusive lock during processing. There is still...
For some reason you have to pass the password hash if you want to create a role in postgres. To...
In CI test runs I noticed that string sorting order changed after switching from a debian-based PostgreSQL docker image...
Attention This is an edge-case. You probably don't want to mix different database dumps. It also requires that...
I found the linked article very helpful to refresh my understanding of database indexes. As a small bonus, it includes...
Maintaining larger projects makes it more difficult to balance refactoring and upgrade tasks according to its actual value. Consider to...
To retrieve only unique combinations of the selected attributes: You can omit rows, where all selected columns are equal with...
Mit SQL spricht man mit relationalen Datenbanken. Ziele Verstehe die folgenden SQL Befehle SELECT WHERE ORDER INNER JOIN, LEFT JOIN...
In diesem Kapitel wirst du eine Applikation in ein Containerimage verpacken und dieses via CI/CD bauen. Anschließend baust du die...
When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?
When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.
Erfülle die Aufgaben Zeige deinem Mentor in einer Live-Demo was du umgesetzt hast. Wenn du Aufgabe 4 betrachtest...