 
      
    | You are here | shekhargulati.com | ||
| | | | | www.red-gate.com | |
| | | | | One of the most important aspects of data management is the ability to ensure that the data in your database is well defined and consistent. Some aspects of that are ensured through the relational data structures you design. Another piece of control is using the correct data type. Then, we get to constraints. A constraint is a way to validate data prior to adding it to your database. This is one more tool in the toolbox that helps you maintain good data. | |
| | | | | boringsql.com | |
| | | | | Changing PostgreSQL column types can be tricky. Avoid common pitfalls like table rewrites and locks, and follow best practices for safe, efficient migrations with minimal downtime. | |
| | | | | blog.miguelgrinberg.com | |
| | | | | miguelgrinberg.com | |
| | | | | curiousaboutdata.com | |
| | | I was privileged to host yet another T-SQL Tuesday, for the month of August, 2024. My topic was on Managing database code. I was worried about getting responses, given that most of the community is no longer on X/Twitter and my invite didn't seem to get much attention. I was wrong. People seem to keep... | ||