HNHacker News
TopNewBestAskShowJobs

fsajkdnjk

-1 karma · joined February 11, 2020

submissionscomments
fsajkdnjk··on Insights – Open-Source Self-Hosted Business Intelligence Platform
The title should be: "Insights is a tool to visually explore a PostgreSQL database"
fsajkdnjk··on Transpiling between any programming languages (2019)
sound great, doesn't work. if it would work, we would have perfect translations for spoken languages already. and google(translate) with it's massive computing, financial and brain power still hasn't figured it out.
fsajkdnjk··on Ask HN: How to tell if you're in a virtual machine?
i think that if you get the hardware info you will be able to find out some virtual pieces listed in there.
fsajkdnjk··on Ask HN: How much tracking is okay?
none. tracking makes you into a cattle. a dumb product to profit off of.
fsajkdnjk··on Ask HN: Do You Miss IRC?
miss? no, not really. but slack ain't it either.
fsajkdnjk··on Why do so many developers get DRY wrong?
nowadays, as golang dev, i don't even know how DRY looks like :D

what I've learnt throughout many years of coding is that purest mantra one should follow is YAGNI. devs think like devs and strive for perfect code. but that goes directly against the business. the majority of the entire world is being run on really bad code. but that bad code works. and that is what is important.

in a way, you should treat things like blackboxes with strict interfaces. no one should care how the box works, as long as its interface works like it is supposed to.

PS: the dangers of DRY are introduction of deep dependencies that might, and probably will, bite you in the ass along the way. DRY should be used only for libraries, not for business logic - ever.

fsajkdnjk··on Ask HN: What to consider when buying a business
the best thing you can do is hire a good accountant and go through their books.
fsajkdnjk··on Ask HN: Not-so-rich not-so-poor folks on HN, how do you spend your money?
it used to go to my "fuck you" pile of cash but now i put it all into stock market. cash is just dead value that depreciates with inflation. i keep some for bad times but the rest is in equities.
fsajkdnjk··on Ask HN: What are some examples of good database schema designs?
the stored events are called event but they are actually envelopes. the true changes("event"), or payload of the envelope, is stored as serialized field. the envelope holds metadata like dates, domain, aggregate type and id, event name, correlation, causation, user/account, event schema version(this is what you are asking about) and so on. i am using protocol buffers so they are backwards compatible and event schema can evolve in time. but you can use any type of format as long as you keep the schema version within the envelope and only add new fields to the objects.

then, when you are parsing the events(hydrating or replaying) you just check the schema version in the envelope and handle the changes/payload accordingly.

it's actually very trivial once you put it all together.

fsajkdnjk··on How to find and delete data Google keeps about you
assuming no smartphone in this scenario, every time you visit any o their services you are being tracked via ip and headers you sent(referrer for example). this way they can build a profile, even if they do not have your personal details. you think you are "safe" if you do not use their services but 99% of websites use their google analytics, cdn or social widgets/sharing buttons... which allows them to track you. so the only way to avoid this breach of privacy is to keep your hosts file updated and never let your browser access any of their websites. i would also be concerned with their dns over http now.

facebook is the same but due to its nature it does it only via its social sharing widgets that people put on their websites and the embedded comments and things like that.

google's cdn is the most dangerous of these things.

fsajkdnjk··on How to find and delete data Google keeps about you
you are 100% correct. one day i found my 5 months old comments on youtube, which i deleted. i expect someone had restored a backup due to some kind of failure. so yeah, 100% breach of GDPR right there. but an individual, that is the product here, cannot do shit about it, that's just a illusion. only government have the power to actually fix this mess.
fsajkdnjk··on Ask HN: What are some examples of good database schema designs?
i have been working with eventsourcing for the past few years and a design i have implemented in the repositories(db) lately is to have one table for events and one table for snapshots(ie. the objects in the current state in serialized form). then, depending on the needs of the application(ie. what queries will be run) I will create tables that will serve as pure indices by which I can then lookup the aggregates(object) I need. This gives me incredible flexibility and I do not need to bother with complex schema at all. I use event reactors within transaction context(imagine pre-save trigger per object) to fill these tables with data(or remove data). and from now on i think this is the way to go for me for anything. having your sql schema matching your objects/entities is very restricting and not flexible for future development. with this approach i have the full data available(snapshots) so i don't need to hydrate each aggregate from the event stream and i also have the ability to filter the aggregates as i need and also have highly optimized schema for any query i desire. when something changed in the future, i can simply play through the entire event stream and fill in new indices or whatever is needed. machines are fast these days so storing the entire object as snapshot in serialized form is nothing and it beats having to load tens of fields/columns and parse it into objects manually.
fsajkdnjk··on Ask HN: What are your favourite news aggregators?
minds.com, bitchute.com :)
fsajkdnjk··on Ask HN: YouTube Scubscriptions with No Account?
this is awesome https://addons.mozilla.org/en-US/firefox/addon/feedbroreader...

you can get your subscriptions via https://www.youtube.com/subscription_manager

fsajkdnjk··on Becoming a high performing software developer working from your bedroom
i made a website for renting and selling real estate - worldwide. visually close to airbnb(ie. big map on the screen) and quite unique filtering mechanism for the ads(i've yet to see anything close to it). essentially the point was to connect buyers and sellers directly because i think real estate agents are just leeches that have no place in 21st century. it was completely free and the goal was to sell ad space. it had not only homes and flats but warehouses, offices and anything else you can think of. one of the things i made point of having was exactly what we are talking about - a rentable desk space. unfortunately, these days, these types of projects live and die with how much money you are willing and able to put into advertising. it is not like in early 2000s or 2010s where a good idea could make it. today, everything has been done and everything has top players(whether service or software). so innovation won't do shit anymore. your success is solely based on ads and getting the name out there(essentially brute-forcing your way to the market). so in the end i killed the project.

though one thing i began working on was my own map tile rendering. i had a free provider(since google and others are insanely expensive for this specific type of project) but i wanted to make my own, for fun. and recently i quit working on a one of my big projects so with a ton of free time on my hands i am thinking of trying again and relaunching the project.

fsajkdnjk··on Becoming a high performing software developer working from your bedroom
The best for me was working out of co-working space BUT not the one you imagine. It was actually from an office of a company I worked for before. About 5 people, modern, spacious, 15 minutes walking distance from my home. Literally not a single con. I just paid for my old desk space and that was it. I always suggest people to do the same - don't go to dedicated co-working space. I never understood that concept. Try to find a company that would rent you out a desk, in a walking distance from your home. Ideally with 24/7 access ass well. I had my screen there and only carried my notebook. Unfortunately after years, the moved to smaller space and there was no space for me, which sucks. I haven't worked outside home since :(
fsajkdnjk··on Dynamically changing, partially-stateful data-flow database written in Rust
"Essentially a database that updates continuously materialized views upon write"

I do that now in my event-sourced application with stupid simple mysql. It is trivial to implement such functionality into the app layer and not into the storage where you are limited by the third party sw itself.

fsajkdnjk··on Firefox 73
it would be nice if firefox would stop sending unapproved requests on the background to mozilla's infra. i am tired of blacklisting all those domains in my hosts file. also the famous welcome screen full of google and other trackers... epic joke on the users.

also, still not having custom search engines via keywords in the url bar, like chrome, is so lame.