News for hackers. Stuff that matters.

fsajkdnjk

The title should be: "Insights is a tool to visually explore a PostgreSQL database"
Re:Transpiling between any programming languages (2019) on Sunday February 16, 2020 @08:29AM (#22341455)
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.
Re:Ask HN: How to tell if you're in a virtual machine? on Saturday February 15, 2020 @08:01AM (#22335042)
i think that if you get the hardware info you will be able to find out some virtual pieces listed in there.
Re:Ask HN: How much tracking is okay? on Saturday February 15, 2020 @07:59AM (#22335036)
none. tracking makes you into a cattle. a dumb product to profit off of.
Re:Ask HN: Do You Miss IRC? on Saturday February 15, 2020 @07:58AM (#22335033)
miss? no, not really. but slack ain't it either.
Re:Why do so many developers get DRY wrong? on Friday February 14, 2020 @09:15PM (#22332642)
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.

Re:Ask HN: What to consider when buying a business on Friday February 14, 2020 @08:19PM (#22332295)
the best thing you can do is hire a good accountant and go through their books.
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.
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.

Re:How to find and delete data Google keeps about you on Friday February 14, 2020 @10:56AM (#22327565)
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.

Re:How to find and delete data Google keeps about you on Friday February 14, 2020 @10:51AM (#22327529)
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.
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.
Re:Ask HN: What are your favourite news aggregators? on Friday February 14, 2020 @06:55AM (#22325833)
minds.com, bitchute.com :)

Ask HN: YouTube Scubscriptions with No Account?

I am in the process of degoogling myself and I am looking for FF extension or free website that would allow me to aggregate youtube channels I like and list latest videos from them, just like the standard subscriptions page on youtube for authenticated users.Is there such thing or bookmarks will have to do?

( Read More... | 2 comments | on HN )
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.

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 :(
"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.

Re:Firefox 73 on Tuesday February 11, 2020 @11:44AM (#22299872)
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.

Ask HN: How to disrupt the payment card industry?

The industry of payment cards is essentially an oligopoly of few companies that control the entire market(visa, mastercard, maestro and few minor ones).This has been possible due to the way the things worked in the past. But now when we have internet connectivity everywhere and most banks have public APIs, why do we need to bow down to these few selected companies and play by their rules?What...

( Read More... | 9 comments | 7 points | on HN )