tpetry

9 ms·

121.
by tpetry 4y ago
You need to start somewhere. It is easier to start with the super-rich because average Joe has no problem with it. And then you can try to trickle down until average Joe is also affected with the reasoning that not only the super rich are a
122.
by tpetry 4y ago
Crypto is still a solution that is searching for the problem it wants to solve.
123.
by tpetry 4y ago
> It's also the constant stream of digital nomad influencers on Twitter who sell extremely distorted, rosy, and often times false dreams to indie entrepreneurs like myself. They make it seem like building a successful startup is eas
124.
by tpetry 4y ago
Like pgsql-http? https://github.com/pramsey/pgsql-http
125.
by tpetry 4y ago
They are correct. If the pay would be better more people would learn to do it.
126.
by tpetry 4y ago
With a trigram index in PostgreSQL you can even do index-supported leading wildcard searches.
127.
by tpetry 4y ago
Fsyncs can be combined. You don‘t need 40k fsyncs for 40k inserts. While one fsync is running multiple inserts are queued and fsnced together when e.g. the last fsync is done.
128.
by tpetry 4y ago
> I was considering something similar and then found this: https://gist.github.com/frozenice/fafb1565f8299a888f94d11137 ... (benchmarking Hetzner's cloud volumes, with unfavorable comments from people trying PG
129.
by tpetry 4y ago
Exactly, I constantly write full-length articles I share with subscribers. If you don‘t want it just unsubscribe, I am not mad at you.
130.
by tpetry 4y ago
I‘ll send you an email when I have written more full-length articles like the ones under „Tips“ in the navigation.
131.
by tpetry 4y ago
Gmail started to mark the email with the PDF as spam. It worked perfectly before this trended on hn. I guess I triggered some rate-limiting rule. If you activate the subscription again you now get a download link. And I will look at the sta
132.
by tpetry 4y ago
Gmail started to mark the email with the PDF as spam. It worked perfectly before this trended on hn. I guess I triggered some rate-limiting rule. If you activate the subscription again you now get a download link. And I will look at the sta
133.
by tpetry 4y ago
I am already writing every tip as a blog post. But those blog posts take a full day to write as they are much more detailled compared to the short summary in the ebook. My time is limited like yours, and the short ebook is the best way to s
134.
by tpetry 4y ago
Gmail now started to classify the email with the ebook attachment as spam. After having worked without any problems before. I am now changing my code, give me a few minutes. Fixed
135.
by tpetry 4y ago
These index choices are solid. But I suggest for the second one to swap the movie_id and user_id because in most cases you want to get all the watchlist entries for a user and not all users having the movie on the watchlist. Therefore all m
136.
by tpetry 4y ago
To be honest. Just subscribe and the next time I wrote a free article and share it with you unsubscribe. I don‘t spam you. Ans I don‘t mind when you only want to grab the ebook.
137.
by tpetry 4y ago
Thank you both. But correctly filling taxes for those donations would be more effort than it is worth. So i‘ll just keep it free :)
138.
by tpetry 4y ago
I‘ve used ibis https://github.com/themsaid/ibis
139.
by tpetry 4y ago
You are not alone. Databases are so easy to use, and that is very good! But due to that simplicity most devs never learn more than the basic statements, but there is so much more that can be used.
140.
by tpetry 4y ago
In isolation because of Corona last year, I started to share many lesser-known database tricks I know on Twitter (@tobias_petry). Although I thought that only a few people would be interested in something like this, it became a matter of co
141.
Show HN: I wrote a free eBook about many lesser-known/secret database tricks(sqlfordevs.com)
865 points by tpetry 4y ago|174 comments
142.
by tpetry 4y ago
This is for SSO reasons. When you enter your email address they check whether SSO is activated for your email address (or whole company domain) and will redirect you. It is better for usability than requiring your users to enter some random
143.
by tpetry 4y ago
Solutions like gitpod or Github Codespace are going exactly in that direction. Sure, they are not on your machine. But thats exactly why they can make it reproducible, no side effects with other installed software or configurations.
144.
by tpetry 4y ago
Thanks for sharing! I was looking for a M1 solution weeks ago snd couldn‘t find any working one. Will try that one now! Looking around for servers with GPUs etc. resulted in stopping me at playing around with it as i got overwhelmed with op
145.
Multiple Aggregates in One SQL Query(sqlfordevs.com)
2 points by tpetry 4y ago|0 comments
146.
by tpetry 4y ago
And it is starting an additional emulated x86/amd64 vm that is emulated. The battery takes a big hit. Now imagine you can run wasm that doesn‘t need an extra vm and doesn‘t drain your battery much faster.
147.
by tpetry 4y ago
At that scale you also have engineers with the only purpose of managing AWS things.
148.
by tpetry 4y ago
Most parallel operations in PG are implemented by simple merge the dataset, work independently and merge the results. I expect the new distinct to behave the same and not work on a shared data structure.
149.
by tpetry 4y ago
Or all the regex DoS vulnerabilities in the dev part of my package json. The worst that can happen is my build process hanging forever if someone commits special code to trigger the issue…
150.
by tpetry 4y ago
How much storage overhead does the process take? pg_repack needs size for a full copy minus bloat. Is pg_squeeze the same?

More ›