Asta Areti
LightNews LightNews
banner
a43ti.bsky.social
Asta Areti
@a43ti.bsky.social
8 followers 20 following 80 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
yesterday I used source generated JSON deserialization

it completely removes the reflection stage which *really* *significantly* improves performance

very relevant for me, as I'm getting barraged with up to couple hundred AIS messages per second

#dotnet #buildinpublic #ais #geosky
ais position message entity class with a json serializer context class configured for this entity. the nested structure may be weird looking, but I'm merely repeating after the messages I receive from API (next pic) AIS API position message structure from documentation
February 10, 2026 at 12:26 PM
a43ti.bsky.social
AAAA I CONNECTED TO REAL MARINE TRAFFIC! 🎉🎉(⁠╯⁠°⁠□⁠°⁠）⁠╯⁠︵⁠ ⁠┻⁠━⁠┻

(these are real AIS messages from a public source, connected with websocket)
aisstream.io 👈

#maritime #navigation #geosky #buildinpublic #dotnet
AIS data just straight up written from every message received from the web socket
February 8, 2026 at 6:32 PM
a43ti.bsky.social
frontend part of the point summary done ✅

and optimized endpoint response from 4 s to ~250 ms!
due to:
- querying only GID for intersection, doing it with raw sql
- using EF to find the EEZ by gid
- removed now unneeded geometry field from entity

#buildinpublic #geosky #dotnet #angular #efcore
comparison of different summaries of points somewhere in the sea (or even not) optimized repository method: intersection with a searched point is found with a raw sql query, a formatted string command. ef core's mapping is used only to find an entity by already known gid (geographical id) history difference of the EEZ entity: i removed the geometry field. apparently it was the problem, EF Core took time mapping geometries to entities in code, and oh have you seen these EEZ geometries when not simplified... (⁠๑⁠•⁠﹏⁠•⁠) so as target DTO of what is to be shown on the frontend panel definitely doesn't need geometry, and intersection check is moved from code to raw sql - geometry field could be safely removed 👍
February 8, 2026 at 11:29 AM
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
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
(3/3)
so I added both connection strings into the api's appsettings.json

and environment detection logic by the Docker variable in the api's Program.cs part by which the right string is chosen

heh the console logging added earlier came in handy

#docker #devops #dotnet #postgresql #buildinpublic
updated section in the appsettings.json configuration that contains both connection strings now - for local launch and for usage in docker new code fragment of the api's program.cs, where its determined by the docker's environment variable, is the api running containerized now or not. then the respective configuration section name is selected, the section is deserialized into a settings object according to Options pattern and registered in the dependency container screenshot of logs of a running container with the api, from the image that was rebuilt after environment detection was added. docker environment is correctly detected analogy to the previous screenshot: console logs of the api running locally after environment detection was added. environment is correctly detected as not docker
January 26, 2026 at 6:19 PM
a43ti.bsky.social
(2/3)
turned out that postgres connection string was the culprit. its Host part had value "localhost". it made the api, to no avail, search for DBMS within the container

the right value is host.docker.internal

also re-ran the container with port mappings

#docker #postgresql #devops #buildinpublic
updated connection string for postgresql that has Docker url for host the first succesful request I made to the containerized api, via mapped http port. showing that both port mapping and postgresql connection finally worked properly such requests include not only database interaction, but also fetching data from external other public apis - which all worked successfully too such requests involve interaction with the aforementioned background service. which basically is the db interaction again with some chance (like this particular request), or memory cache. still, i wanted to access and test this endpoint too to be sure
January 26, 2026 at 6:19 PM
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
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
upd I'm now a proud owner of a Debian on WSL))

earlier when learning devops I always practiced on Ubuntu, this time chose an alternative just as popular to work with because why not

mind blown to see a. Linux in Windows. like Usual App to Open and Pin to taskbar.. (⁠゜⁠o⁠゜⁠;

#linux #debian #dev
screenshot of a windows console with Debian installation to WSL and creation of the main user, ending with Debian's terminal having opened in this console screenshot of Debian available like a usual app in Windows screenshot of windows console with the terminal of Debian in WSL with information about the OS version gotten from reading /etc/os-release file
January 16, 2026 at 1:32 PM