Tils

I’m currently reading Database Internals by Alex Petrov and came across the “Index Files” section. Primary and secondary indexes were being discussed and it was interesting to see how these indexes interact with data records. “A primary index is usually assigned to a primary key or a set of keys identified as primary. All other indexes are called secondary.” I never really thought about what a secondary index was referencing. Just that it was another way to optimize search for a record via secondary indexed column....

I’m reading about caching and the difference between temporal and spatial locality. Spatial locality: is the likelihood of accessing memory addresses near recently accessed locations. Example: MP3 data has strong spatial locality since you know you’re going to need t = 1s and then t = t + 1s (sequential traversal) and so forth as you listen to a track Code: related functions living close in memory Data: contiguous data structures (ie....

While reading “Release It!” by Michael T. Nygard, I came across the following line that had me pause: “The IP address used to create the connection will have moved from one host to another, but the current state of TCP connections will not carry over to the second database host.” Got me thinking about my understanding of database connections and in TCP/IP fundamentals in general. I’ve connected to databases a bunch of times, but I never really took the time to think about what’s happening under the hood....

Projects using Guice will have a Module class for reach module that will install dependencies. This installation adds all the @Provides methods from external dependencies to the dependency graph at runtime AND NOT at compile time. @Inject -> Guice uses reflection to find these annotations, creates / gets implementation instance, sets field value (amongst other things) @Named -> this is a particular instance of a class. Without it, it would be unclear where / who is injecting this implementation...

I’ve been learning Java recently and it’s my first time using it in a job setting, so still getting the hang of how certain things work. We have a company specific IntelliJ plugin that allows us to go from clicking a button “Generating run configs” to hitting the “Run” button and the deployable “just works” locally. Under the hood, it: Looks at the deployment files for the appropriate app setup (ie....

Today I learned that Java has virtual threads introduced in Project Loom. When I read about virtual threads, I instantly thought about go routines, which (in most basic terms) are “lightweight threads” that utilize less of the CPU’s resources than a traditional thread. A traditional thread in Java: is managed/scheduled by the OS is costly to create, so things like thread pools are introduced for realloc/dealloc of threads as needed (ie....