/* Code Comments */5 posts tagged with "databases"
databases: one-to-many becomes many-to-many
2022-11-28
|~2 min read
|376 words
I’ve been thinking a lot about evolving data models recently. One problem that seems common is when a relationship that was assumed to be…
dbms keys: comparing compound and composite keys
2022-11-28
|~2 min read
|277 words
https://www.guru99.com/dbms-keys.html What is the Compound key? COMPOUND KEY has two or more attributes that allow you to uniquely recognize…
preventing sql injection
2022-11-28
|~2 min read
|372 words
I’ve known for a while that one of the ways to prevent SQL injection attacks is to use parameterized queries - but I never really understood…
adding indexes to mongo + a case study
2022-11-28
|~4 min read
|702 words
I’ve been working on projects with larger data sets recently and have begun to notice that not all queries resolve in one or two…
indexing databases - a postgres example
2022-11-28
|~3 min read
|509 words
A short review of when and how to index a Postgres database. Common Commands Why Index Your Postgres Table The two most common reasons to…