/explore
|
You are here 
|
jkatz.github.io | ||
| | | | |
www.rorvswild.com
|
|
| | | | | Querying your database across associations can become a bottleneck in your Rails application. Julian Rubisch, our first guest author, explains why and suggests an efficient solution. | |
| | | | |
akorotkov.github.io
|
|
| | | | | [AI summary] A technical article demonstrates how to implement efficient faceted search for mailing list archives using a single PostgreSQL SQL query with window functions and CTEs. | |
| | | | |
blog.pamelafox.org
|
|
| | | | | I'm concerned by the number of times I've heard, "oh, we can do RAG with retriever X, here's the vector search query." Yes, your retrie... | |
| | | | |
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: | ||
