/explore
|
You are here 
|
mccue.dev | ||
| | | | |
coussej.github.io
Thoughts and Ideas |
|
| | | | | ||
| | | | |
www.brightball.com
Continuing with our theme of trying to push Elixir and Phoenix a little on this site rebuild, we will move our site search inside of a PostgreSQL function and experiment with different ways to call it from Ecto. |
|
| | | | | ||
| | | | |
newvick.com
Tables with polymorphic associations can be quite annoying to query. Use views to make it much easier. |
|
| | | | | ||
| | | | |
johnjr.dev
When we study transactions in relational databases, one of the first things we learn are the guarantees that a transaction must provide. ACID(Atomicity, Consistency, Isolation, Durability) are the properties that we desire. Here, I will discuss the Isolation level in more detail and show that atomicity alone is not enough when handling concurrency. One classic example of the importance of atomicity is moving money between accounts. So, imagine that we have two accounts and we would like to transfer the total amount from one account to another one. In a relational database, what we need to do is three steps: |
|
| | | |||
