Asta Areti
LightNews LightNews
banner
a43ti.bsky.social
Asta Areti
@a43ti.bsky.social
9 followers 20 following 77 posts
Programming student-almost-junior, nearly every day surprised by something new from professional realm

https://fed.brid.gy
Posts Replies Media Videos
a43ti.bsky.social
I'm making a summary for the clicked point in the marine #gis project

it will display whatever different marine zone(s) the point is within

and will be situated in this cool freshly made side panel <⁠(⁠￣⁠︶⁠￣⁠)⁠> (post below👇)

backend endpoint works ✅

#buildinpublic #dotnet #webdev #api #geosky
example response when querying a point in an exclusive economic zone of a country example response when querying a point in a joint zone between several countries (can be up to 3) example response when querying a point in neutral waters example response when querying a point on land
February 6, 2026 at 10:05 PM
a43ti.bsky.social
yesterday I moved PostgreSQL data folder to another drive. each converted shapefile adds hundreds of Mb to it

moved postgres' /data folder contents, allowed Full control of Network service over new folder and modified service invocation command to refer to it

#database #postgres #sql #dev #windows
result of the moving - I freed approximately 2.5 Gb and to all the database the connection is successful again (⁠≧⁠▽⁠≦⁠) new folder for data, which I prepared by enabling every possible permission (full control) for user type Network Service - because postgres is a service changing the text of the command that starts postgresql service. what is changed in it is path to the data directory, after the -D flag. as you can see, done with window's sc config utility which manages parameters of Service control result of the Postgres service start command change - visible in its Properties in the familiar services.msc window. also notice that postgres is stopped - it has been the whole time, you absolutely must stop the service before managing its directories
February 6, 2026 at 2:44 PM
a43ti.bsky.social
implemented coordinates display of the clicked point, in decimal degrees and with minutes, like in NMEA 0138

data is sent from Leaflet map to Angular components via a Subject observable service

(there will be way more info on this side panel)

#gis #geosky #maps #angular #buildinpublic #webdev
February 4, 2026 at 12:18 PM
a43ti.bsky.social
css bloopers from new incoming feature of the maritime gis project! :DD

#css #buildinpublic #tailwind #web #webdev
these are text shadows from which I am going to compose outlines for the letters, I for some reason decided to set their offset in rem instead of px
February 3, 2026 at 3:23 PM
a43ti.bsky.social
i'm adding tailwind css to my #gis Angular project, wish me luck... (⁠・⁠–⁠・⁠;⁠)⁠ゞ

#tailwind #css #webdev #buildinpublic
demo screenshot with the first proof that tailwind is added successfully and classes work configuration files necessary to enable tailwind: .postcssrc.json with tailwindcss listed as a plugin, and an import in the global styles file installed tailwind related packages in the project's npm
February 1, 2026 at 2:04 PM
a43ti.bsky.social
68 posts of .NET & GIS grind and only 6 followers. is this thing on? 🔎
if you're into c#, sql, or mapping stuff, heart this or say hi. i'm not stopping anyway heh

#devlog #dotnet #gis #buildinpublic
January 31, 2026 at 11:17 AM
a43ti.bsky.social
in EF Core for non-nullable entity properties of Reference types - don't just assign a new default instance! 📢📢 it Doesn't Work the same as with string.Empty!📢

that default is added to DbContext too, creating ID conflicts especially (!) during addition

#dotnet #efcore #csharp #dev #entityframework
initial error case with an attempt to ensure non-nullability with a default instance. all tests in this project regard repositories, and they all identically failed on the preparation stage - during data seeding! successful case with null-forgiving operator. non-nullability implemented, no weird extra entities and all tests passed
January 31, 2026 at 1:06 AM
a43ti.bsky.social
today I migrated my #gis project to Angular and already bumped into common issue - map height. now in a component it collapsed

obvious workaround - set exact height in css - too sketchy

right answer - expanding component itself with shadow DOM (:host class)

#buildinpublic #angular #web #css #maps
situation in the web app right after migration to angular, no change in the frontend including css (though I separated custom css from html as it should be in angular) - div with the map collapses to 0 height possible workaround - setting exact height just on the map div - comes together with a hard time calculating the right height based on whatever else might I eventually want to add alongside the map better option of making the component tag, which is a container for the map div, bigger itself. :host pseudo class is the way of an element referring to self. still not perfect, I had to choose that value in vh over some tries, but at least easier to potentially calculate because its less nested than the map div
January 29, 2026 at 10:51 PM
a43ti.bsky.social
...I didn't expect that #OpenStreetMap tiles include military facilities (⁠•⁠ ⁠▽⁠ ⁠•⁠;⁠)

(look right in the middle)

(was randomly spinning the map, having fun with completed #eez, found these... danger zones or something)

mapcarta.com/W383490935 - on esd 138

#maps #OSM #geosky #geospatial #sea
look closer, right in the middle of this map fragment near denmark there is a rectangle inscripted ESD 138 and ESD 139. turns out these are military designated zones, where planes and ships are sometimes restricted. link about the first one is in the post, about the second one I could not even find info
January 28, 2026 at 1:09 AM
a43ti.bsky.social
final (!!!) adjustment to #eez streaming!🎉✨🌊
made the chunks streaming order make sense! :D

on world/continent zooms 1-4 - the closer to viewport center, the sooner on map

on the rest of the zooms - sorted by area: first big chunks, then little crevices

#buildinpublic #dev #geosky #maps #openseas
January 27, 2026 at 2:12 AM
a43ti.bsky.social
just bridged this account of mine to fediverse... i'm amazed by this ecosystem, so many apps and connections, probably I don't know a lot more yet 😅
and don't know maybe some frens will come here from mastodon :)

#fediverse #bridgyfed #bluesky #mastodon
to create the bridging, first select Bluesky account on the main page, then you'll see this one, where enter your existing account handle (1/2) (2/2) after OAuth authorization existing bridging account looks like this
January 27, 2026 at 12:52 AM
a43ti.bsky.social
here we go again, today I dockerized an app of another type - #api with external dependencies, including interaction with postgresql!
though at first there was a fail - a service that saves something into the db every N minutes, crashed the program..
(1/3)

#docker #postgresql #devops #buildinpublic
screenshot of logs of a recently run container of the api in question. a background service tried to connect to postgresql but connection refused, which crashed the api and stopped the container
January 26, 2026 at 6:19 PM
a43ti.bsky.social
#sonarqube linter has some beef with html labels 😦

had some labels, wanted to add text with js, so left them empty in markup - code smell⚠️

okay, added the pair of for + id, still⚠️

also tried nesting, nah⚠️

turns out without text they are not perceivable at all...

#aspnet #razor #dotnet #dev #web
fragment of a razor view markup after I just wrote it - I thought that identical "asp-for" are enough for the association tried the usual way to associate them by "for" attribute on label + "id" on input then I tried nesting the inputs inside the label tags in addition to the "for" + "id" the right answer turned out to be adding some actual text to labels + keeping the association by id. apparently without perceivable content (aka text) labels make no sense to static analyzers, and then even the association by id doesn't count. I guess I will just conceal the text with css
January 25, 2026 at 10:25 AM
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