Search Results for: caching

Yet more caching

I’m pretty sure I want to implement more caching on FreshPorts. My first thought was to write the files to disk and then remove them when they need updating. I recall a caching program that either works with PostgreSQL is is implemented in PostgreSQL. Putting to cache into a database would be interesting. It’s not […]

Yet more caching Read More »

If packages and ports are cached separately, how is one included in the middle of the other?

A new FreshPorts features is being developed. I’m trying to determine if packages for a port can be cached separately from the port itself. I will explain. When you visit a port page, if it’s not cached, the page is built and then cached. Not the whole page, just the parts pertaining to that port.

If packages and ports are cached separately, how is one included in the middle of the other? Read More »

Updating the packages table – INSERT, UPDATE, DELETE – plus some ZFS configuration

In the previous post I documented how the packages_raw table is updated to populate the abi_id and port_id columns. This post will discuss how that data is then pushed into the packages table. Thoughts When updates arrive, they arrive in quantity. The latest update was 30474 records. From that, we will have some new packages,

Updating the packages table – INSERT, UPDATE, DELETE – plus some ZFS configuration Read More »

Using DEFERRABLE INITIALLY DEFERRED on constraints

This post is another in the packages series. It documents how the data is transformed from the raw form (pacakges_raw) into normalized data (packages). The Packages – how is this data stored? post may be useful reading. The primary purpose of this blog post is documentation of the above mentioned transformation process. Along the way

Using DEFERRABLE INITIALLY DEFERRED on constraints Read More »

Scroll to Top