Asta Areti
LightNews LightNews
a43ti.bsky.social
Asta Areti
@a43ti.bsky.social
6 followers 17 following 54 posts
Programming student-almost-junior, nearly every day surprised by something new from professional realm
Posts Replies Media Videos
a43ti.bsky.social
chunk ids worked as intended - now no holes in #eez!
also I decided to simplify more for speed's sake, completely change from PreserveTopology to just ST_Simplify on first 2 zoom tiers + on 3rd for a few countries with the most complex shorelines

#buildinpublic #dev #postgis #geosky #maps #leaflet
January 22, 2026 at 10:12 PM
a43ti.bsky.social
comically bricky sea 🌊

(one of the attempts of applying more simplification to #eez on world and continental zooms because the loading speed could be better)

#buildinpublic #dev #gis #geosky #maps
i overdid with simplification this time, this loaded fast but look at these cracked tiles
January 22, 2026 at 3:04 PM
a43ti.bsky.social
yesterday I used http headers for passing info :000

in these wee few lines of code I learnt whole 2 facts
1 - nowadays we should prefix custom headers with app name, not X
2 - Expose-Headers doesn't work like true/false, we should pass header names to it 😅

#buildinpublic #web #dev #dotnet #http
putting custom headers in the response on backend side: first with necessary info, second - to enable browser to see the first checking for the custom header on the frontend a response example caught in devtools, that has my custom headers
January 22, 2026 at 10:01 AM
a43ti.bsky.social
did i tell y'all that the #ecommerce project has proper limitations on passwords? =))

- at least 8 characters
- no passwords from the top 50 most popular list (among 8+ characters)
- no reusing old passwords when recovering

last pic are my extra tables in identity db

#buildinpublic #dotnet #dev
comparison of registration forms filled with different password length, demonstrating that with a password less than 8 characters its impossible to operate example of a registration attempt rejected because of the password being from the top most common ones list example of a password change attempt rejected because in this account the proposed new password was used before columns and their types in custom extra tables in the project's IdentityDbContext necessary to implement password change codes, common password rejection and previously used password rejection
January 20, 2026 at 2:08 AM
a43ti.bsky.social
i'm adding individual ids to chunks of the #eez, without these their viewport presence isn't tracked properly:
- track by at least 1 chunk then eez are loaded incomplete
- track by only when all chunks are on map (its rare) and there will be duplicates

#buildinpublic #dev #gis #geosky #sql
screenshot of a script that creates a materialized view for economical zones on one of the zoom tiers. these queries differ only in the second argument of ST_ functions btw. one of the columns, the newly introduced chunk id, is enumerated from 1 along the whole table, making the records unique. in the query result fragment its demonstrated how a zone (identified by gid) can have either only one chunk or many
January 19, 2026 at 9:54 AM
a43ti.bsky.social
frens, how often in practice do you use git commit --amend? today I nearly used it, but found the pieces of code that i "forgot" to add in last commit existing since some time earlier 👀
at least it is my own pet project, since for teams --amend and --force push after it is a big ow no

#git #dev
January 18, 2026 at 9:46 PM
a43ti.bsky.social
I made #eez not reload from zero at every move across the map, I guess...

data about which eez are in viewport is saved in in #redis cache (posts below =) ), the set is identified by a session id. for this part I had to learn A LOT about cookies today (⁠ꏿ⁠﹏⁠ꏿ⁠;⁠)

#buildinpublic #dev #geosky #maps
January 17, 2026 at 9:15 PM
a43ti.bsky.social
unexpected devops adventure continues: I was having a hard time for more than a whole workday to make my firewall allow downloading packages to #WSL without disabling protection in general
so switched to actually using #redis in docker

#docker #devops #buildinpublic
console with pulling and running a Docker container with latest version of Redis, then a confirmation with a successful ping of the application working screenshot of a running Redis container in Docker Desktop gui, with a console opened and an example of an actual Redis' command in it
January 17, 2026 at 10:29 AM
a43ti.bsky.social
tried to run #redis on windows, reached for #WSL of course, but found this surprise

no sudo, no apt even, all information about version is just "Linux🙃" whaat 0vo

apparently my current #wsl distro is so minimal its basically just a backend for other programs...

#linux #dev #devops #docker
screenshot of windows command line where its found out that its impossible to install a package on WSL the usual way. turns out that basic packages like curl, sudo and apt are not found, all full name is just "Linux" and other "pretty" name is Docker Desktop. which means that the wsl distro is a minimal backend running in docker.
January 16, 2026 at 12:02 PM
a43ti.bsky.social
upd no crashes anymore!!1! 🎊 as you can see, the video in my previous post is already recorded from screen - with OBS studio
obsproject.com

it records already compressed data, just what's needed for unpredictable #maps

i wasn't paid i just googled alternatives to my main recorder

#software
January 15, 2026 at 11:06 PM
a43ti.bsky.social
zoom optimization - done ✅ :D

- no data loading when zooming in within the same zoom tier, but still loading on any zoom out
- discarding false moveend events triggered after zooms
- figured out how to cache zoom tier names AND not break architecture <(⁠￣⁠︶⁠￣⁠)>

#buildinpublic #dev #gis #mapsky
January 15, 2026 at 5:40 PM
a43ti.bsky.social
upd! I adopted this interesting way of #logging (its called source-generated :000) and thoroughly applied it to a practice #API from half a year ago 😉 mmm niiice a bit colorfulll console outputtt

tbh postponed adding logging to this api, posting here motivated me to :>

#dotnet #buildinpublic #dev
screenshot of logs of the api in question in which there is information about saving entities and retrieving them from external api. logs are coming from different parts of the program - controller and a few services screenshot of logs of the same api, direct continuation of the console on the previous image. shows information-level logs about saving, caching entities, retrieving them from an external api many times and once from cache. and one fail-level log entry about trying to get data by an impossible id. logs come, similarly to the previous screenshot, from a controller and a few services. screenshot from a code fragment of an api in question with source-generated logging methods in the controller class for both successful events (information) and slightly unexpected but otherwise not critical (warning) screenshot of a piece of code of a resource filter in the api in question. the resource filter is needed for turning the entity IDs in request to uppercase format because they are stored in database in this format. but for this post what matters more is that here the fact of said case change is logged, at the information level. a more direct way of just using the logger object's method is used here, because in a resource filter class it wasn't possible to resolve a logger via the constructor to later put it in a field which would then be used in source-generated logging methods.
January 14, 2026 at 9:52 PM
a43ti.bsky.social
optimization of #eez loading - here it goes! I implemented #streaming chunks one by one!💫 look how fast and bouncy it's gotten :>

for 3 zoom tiers out of 6 I decreased precision of coordinates, #postgis has such strange ways to do it

next should make it stay between zooms

#buildinpublic #dev #gis
January 13, 2026 at 10:17 PM
a43ti.bsky.social
about 2 months ago added to my #ecommerce pet project on #aspnetcore a possibility to change password via a code from email. was VERY excited to see the emails arrive, weee my project does a thing beyond the application! :D

I think i should also add password change via a code from #sms soon
January 13, 2026 at 11:47 AM
a43ti.bsky.social
today was a rare time that for downloading a #frontend library for a #fullstack project I used #LibMan... was nice, maybe I should use it more often

though getting libs manually I think a bit increases understanding of online repositories and #CDN (⁠人⁠ ⁠•͈⁠ᴗ⁠•͈⁠)
January 12, 2026 at 12:47 AM
a43ti.bsky.social
added marine exclusive economic zones ( #EEZ) to my #postgis project today! still laggy, a long way to optimize, and I know how to
it was a revelation that to not get ddosed by our own frontend, not debouncing was needed but vice versa - aborting previous requests if new ones come too fast
January 11, 2026 at 12:24 AM
a43ti.bsky.social
frens, what the most boring #programming task in your experience you can recall? either recently, or ever, I'm interested anyway :) In my case it was a #crud app for an abstract e-commerce shop with console interface - a royal flush of boredom, in a certain course where I know 85% stuff already...
January 9, 2026 at 10:54 PM
a43ti.bsky.social
behold my most Amazing task In Months! my first #Jenkins #CICD pipeline! took me 5 days instead of planned 1. though the website deployed is not mine I think my #devops skills singlehandedly elevated from this
- #AWS VMs
- #maven build
- #SonarQube quality gate
- #Nexus artifact
- #Slack integration
January 8, 2026 at 9:03 PM
a43ti.bsky.social
are u kidding me in #visualstudio there is another half of very interesting windows hidden in plain sight D:
(was looking for Endpoints explorer while making #MinimalAPI)
January 6, 2026 at 7:55 PM
a43ti.bsky.social
rested from difficult postgis related challenges today in my current big project, instead just check out the nice markers :) made with #Leaflet js ofc 🍃
I personally, looking at them and clicking across the world, feel a tiny bit thrilled as if from really travelling but on tiny scale, anyone else?
January 6, 2026 at 12:34 AM
a43ti.bsky.social
today I found out this practice in #.net to make #logging methods with [LoggerMessage]
partial methods without body (!), whose functionality is defined in attributes, and in some related documentation (link👇) they are referred to as delegates? am bamboozled...

learn.microsoft.com/en-us/dotnet...
January 4, 2026 at 11:36 PM
a43ti.bsky.social
does anyone know to what extent and in what order to better subdivide and simplify polygons of areas comparable to entire countries in #postgis? my poor browser explodes due to lack of memory at a retrieval of 20 such areas already while on my map there should be 285
January 3, 2026 at 10:27 PM
a43ti.bsky.social
today I Learnt about an attribute in #NUnit called TestCaseSource that allows to write test case Parameters of Any Type! as Array of arrays of objects per #testcase by Name!!
seriously, incredibly convenient way to overcome the limitation of usual TestCase attributes :D

#testing #unittesting
January 3, 2026 at 2:15 PM
a43ti.bsky.social
why don't #SQL DBMSes have a way to select all in a table but some column(s)? something like EXCEPT or EXCLUDE? that exists in less famous ones like DuckDb but why not #postgresql, #sqlserver or #mysql?
was working with postgis data today and so often had to select everything BUT geometry and/or gid
January 2, 2026 at 6:50 PM
a43ti.bsky.social
behold the task that made me want to start blogging -
running web apps in docker containers! 🤩
it was a month ago, not my first time using docker, but never before it was with websites
but when you enter the container address in browser and. See the Site - ✨its magic :D✨

(pt 1 - single container 👇)
January 1, 2026 at 10:18 PM