toto444 (u/toto444) - Readit News

toto444 commented on Risk and Regret collabfund.com/blog/risk-... · Posted by u/yarapavan

toto444 · 3 years ago

I came here to see if anyone discussed this quote : “The purpose of life is to experience things for which you will later experience nostalgia.”

I can totally relate to it but it might be because I'm in a mid life crisis.

toto444 commented on Toward a Digital Comics Praxis digitalcomics.co/... · Posted by u/solarized

hummus_bae · 3 years ago

That’s really neat! I’ve been looking for inspiration for a design idea like this, but CSS animation + images can get clunky. How are you handling transitions between “pages”?

toto444 · 3 years ago

Thanks. Right now it's all static. To go from one page to the other you can click 次and 前 . It would be easy to move the characters within the images using a bit of javascript. That's a plan I have for the future.

If you need inspiration you can take a look at this as well made using REXPaint. https://preview.redd.it/vxfohcwxywt71.png?width=1458&format=...

It's all ASCII art so in theory one should be able to convert it to HTML. I have a project to make a story using REXPaint to HTML in a near future.

If you need more info, feel free to contat me raising an issue on github.

toto444 commented on Toward a Digital Comics Praxis digitalcomics.co/... · Posted by u/solarized

toto444 · 3 years ago

I am creating a fully digital comic in HTML & CSS only. Even the illustrations are CSS generated pixel art. In case someone's interested you can find it here : https://drdru.github.io/twc/twc_save_aryn/02_on_the_way_to_k... .

toto444 commented on Everything You Can’t Have collabfund.com/blog/every... · Posted by u/_solr

antisceptic · 3 years ago

I'd imagine a healthier version of something like: "Simpletons, relying on consumerism for their dopamine rush, they're no different from ants! Meanwhile I am a /creator/ of things!"

toto444 · 3 years ago

I'd say my version does not include comparison to others. I actually wish more people try their best to create great things even if what their creations are much better than mine.

My version would be more like :

"Owning a car is very circumstantial. It means you temporarily have some property right on it. It can break, it can be taken away from you. If you create something it's yours forever. Its existence is not independant of your will.".

At the end of their lives some people will have owned ten cars, others will have written ten books.

toto444 commented on Everything You Can’t Have collabfund.com/blog/every... · Posted by u/_solr

amelius · 3 years ago

How do you trick your brain into this? How do you ignore friends who buy a new car every year?

toto444 · 3 years ago

I can ask you the same question :

How do you ignore friends who write a new book every year?

toto444 commented on Everything You Can’t Have collabfund.com/blog/every... · Posted by u/_solr

toto444 · 3 years ago

I have found that instead of wanting things I don't own, wanting to see created things I haven't created yet very liberating.

Since it makes my goals very personal, I can't compare myself on an objective metric with other people and as a result feel less frustrated about not earning more.

toto444 commented on Tell HN: Heroku 2FA Scam · Posted by u/arionhardison

toto444 · 3 years ago

Authentication now requires a smartphone or a security key. I have neither...

toto444 commented on The unequal treatment of demographic groups by ChatGPT/OpenAI content moderation davidrozado.substack.com/... · Posted by u/barry-cotter

toto444 · 3 years ago

It reminds me of the day I typed in Google : 'why are women so patronizing?'.

All the results were about men patronizing women. I just checked and it's still the case.

toto444 commented on Ask HN: How do you test SQL? · Posted by u/pcarolan

efxhoy · 3 years ago

I write mostly batch ETL stuff. All plain psql and bash. We don’t have a good testing setup to be honest. What we do use instead:

Plenty of constraints, uniques and foreign keys and not nulls. Enum types.

Visuals, dump to csv and plot some graphs. Much easier to find gaps and strange distributions visually.

Asserts in DO blocks, mostly counts being equal.

Build tables in a a _next suffix schema and swap when done.

Never mutating the source data.

Using psqls ON_ERROR_STOP setting.

Avoid all but the most trivial CTEs, preferring intermediate tables that can be inspected. Constraints and assertions on the intermediate tables.

“Wasting” machine resources and always rebuilding from scratch when feasible. CREATE TABLE foo AS SELECT is much simpler than figuring out which row to UPDATE. Also ensures reproducibility, if you’re always reproducing from scratch it’s always easy. State is hard.

Overall i’m quite happy with the workflow and very rarely do we make mistakes that unit tests would have caught. Our source data is complex and not always well understood (10+ years of changing business logic) so writing good tests would be very hard. Because we never touch the raw source data any errors we inevitably make are recoverable.

This talk by Dr Martin Loetzsch helped a lot: https://youtu.be/whwNi21jAm4

toto444 · 3 years ago

I admit it's not the best but I do almost like you. Graphs are definitely helpful.

I also have a few 'test' queries that insert there results into a 'test_results' table. Most of the queries check the cardinality of the table since to me wrong cardinality is where the biggest errors come from. I do something like :

insert into test_table

select case when count(*) = count(distinct users) then 'pass' else 'fail' end as result, 'test_cardinality_temporary_table_a' as test_name from temporary_table_a