Tag: database
All the articles with the tag "database".
-
Re-initializing Table Sequences in PostgreSQL
Updated:Learn how to reset and reinitialize table sequences in PostgreSQL safely, whether preserving existing data or starting fresh.
-
Recovering a MySQL Root Password
Updated:Forgetting a database password isn’t the end of the world. Here’s how to reset or recover the MySQL root password, with notes for modern MySQL versions.
-
Retrieving a Random Row in ActiveRecord
Updated:Learn different ways to fetch a random row in ActiveRecord, their trade-offs in PostgreSQL and MySQL, and which method to prefer for performance.
-
Connecting to Multiple Databases in a Rails App
Updated:Learn how to connect a Rails app to multiple databases using establish_connection, with context on modern Rails features for handling multi-DB setups.