If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL...
For searching in large database tables we usually use PostgreSQL's fulltext search capabilities. While this works reasonably well for...
When restoring a PostgreSQL dump using pg_restore, you usually add the --clean flag to remove any existing data from...
To remove all tables from a database (but keep the database itself), you have two options. Option 1: Drop the...
If your app does not need to support IE11, you can use most ES6 features without a build step. Just...
Suggested Workflow Set the ruby version in .ruby-version to 2.3.5, then perform these steps one by one, fixing errors...
When your code does not behave as expected, you can use a debugger statement ("breakpoint") at any point in your...
When projects run for many years, they require special regular maintenance to stay fresh. This kind of maintenance is usually...
This repository was created with the intention of helping developers master their concepts in JavaScript. It is not a requirement...
In this example we assume that not only the storage gem changes but also the file structure on disc.
If you use transactional_fixtures or the database_cleaner gem with strategy :transaction, after_commit callbacks will not be fired...
Migrating data from a legacy into a new system can be a surprisingly large undertaking. We have done this a...
Background information about session storage in Rails Rails has a default mechanism to store the session in the CookieStore. This...
The 90s are calling: they want their tables back. Unfortunately, you need them all for laying out your HTML emails...
When you need to store structured data (like Ruby hashes) in a single database column with ActiveRecord, a simple way...
Create a user without password (recommended) Replace newuser with your desired username: mysql -uroot -p CREATE USER 'newuser'@'localhost' IDENTIFIED...
When you have a large PG database, you may want to find out which tables are consuming the most disk...
If freshclam updates are failing even though the update servers are available and you find error messages like the following...
The attached article explains options you have to store the order of items in a database table. The simplest solution...
Don't sum up columns with + in a sql-query if NULL-Values can be present. MySQL and PostgreSQL cannot...
geordi delete_dumps [directory] Recursively search for files ending in *.dump and offer to delete those. When no...
You might have some trouble running a Rails LTS 2 app with MySQL 5.7. If you don't want to...
MySQL and MariaDB have an SQL mode setting which changes how MySQL behaves. The SQL mode value is comprised of...
On your local system that only hosts non-critical development data and only you have access to, you can store...