Oh no I executed the query on production again!!?
As developers we all have to deal with databases. And when we do it’s never just one database, right? There is one for production, one for acceptance, probably one for some dev or test environment… …before you know it your database connections window in IntelliJ…
Storing lengthy titles in Oracle database
Recently we ran into a bug in our software. We couldn’t store long titles because our database columns are constrained to 180 characters. Until then we hadn’t anticipated on, nor entered titles this long. To store the records in the database again, we truncated the…