• Selecting, caching and displaying photos on the map

    • Translation

    In this article, I decided to describe how the functionality of selecting and displaying photos on a specific place on the map was implemented in our photo service gfranq.com. The photo service does not work now.



    Since we had a lot of photos in our service and sending requests to database every time the viewport changes was too resource-intensive, it was logical to divide the map into several areas that contain information about the retrieved data. For obvious reasons, these areas have rectangular shape (although hexagonal grid was considered too). As the areas become more spherical at large scales, elements of spherical geometry and tools for it were also considered.


    In this article, the following issues were raised:


    • Storing and retrieving photos from the database and caching them on the server (SQL, C#, ASP.NET).
    • Downloading necessary photos on the client side and saving them to the client cache (JavaScript).
    • Recalculation of photos that must be hidden or shown when the viewport changes.
    • Elements of spherical geometry.
    Read more →
  • Monitoring System for Windows servers on pure SQL, and how I had secretly dragged it into the Production

      A long time ago in a galaxy far, far away there was a company grown from a startup to something much bigger, but for a while the IT department was still compact and very efficient. That company hosted on prem hundreds of virtual Windows servers, and of course these servers were monitored. Even before I joined the company, NetIQ had been chosen as a monitoring solution.

      One of my new tasks was to support NetIQ. The person, who worked with NetIQ before, said a lot about his experience with NetIQ, unfortunately, if I try to put it here it would be just a long line of ‘****’ characters. Soon I realized why. Steve Jobs is probably spinning in his grave looking at the interface like this:

      image
      Read more →