tpetry

16 ms·

181.
by tpetry 4y ago
Successfull serial founder or failed serial founder? Just wanting to get into space tech without any understanding of the topic, the problems and everything is really naive. Some tweets, podcasts or blog articles are not enough to learn abo
182.
by tpetry 4y ago
A docker compose file is also used for swarm mich is a multi-server deployment.
183.
by tpetry 4y ago
> Don't get me wrong, I still like it but I wouldn't want to run it with little expertise at hand. It's not something I would trust someone to run without production experience, which is difficult because there are very fe
184.
by tpetry 4y ago
I always get the feeling that grammarly adds to much commas. And so many of the sentence rewriting suggestions just provide glibberish.
185.
by tpetry 4y ago
It‘s one developer, one marketer and when I remember correctly two for support.
186.
by tpetry 4y ago
They don‘t have a sales team, so no cost. So it‘s barely sone SaaS they use by themselves (e.g. slack etc.) and server costs. As they are running very lean I expect at least 80% margin.
187.
by tpetry 4y ago
Custom functions and data types are great but what most people miss is custom aggregates! Some weeks ago I built tsvector_agg() in ~10 minutes to aggregate the fulltext search vectors of multiple rows into one. That‘s really magical and sho
188.
Sorted Tables for Faster Range-Scans(sqlfordevs.io)
2 points by tpetry 4y ago|0 comments
189.
by tpetry 4y ago
All these components/frameworks are build for websites, but a desktop application looks different. I haven‘t seen a maintained desktop application ui framework in years.
190.
by tpetry 4y ago
I‘ve seen an clever approach to do location-specific data at rest. Partitioning and postgres_fdw was combined to store specific data on specific clusters in some regions. And on top of it partioning was used to again get the global view. Re
191.
by tpetry 4y ago
Hashids sounds like hashing but it‘s just encoding and decoding the values. I shared that approach in the article. They have the drawback that you always need to decode manually the url when you e.g. want to lookup a record from an URL.
192.
UUIDs to Prevent Enumeration Attacks(sqlfordevs.io)
15 points by tpetry 4y ago|4 comments
193.
by tpetry 4y ago
You can write a custom data type in pure SQL for PostgreSQL which is just transforming a visible string to the more efficient uuid type. That‘s basically how the uuid type can be implemented: For storage it‘s binary(16) but all operations t
194.
by tpetry 4y ago
That‘s in my experience also the best approach. I wrote an article a few days ago about the exact thing: An integer auto incrementing PK with an UUID you use externally: https://sqlfordevs.io/uuid-prevent-enumeration-attack
195.
by tpetry 4y ago
Are AZ failovers not done automatically? Where can I read more about that?
196.
by tpetry 4y ago
* Paid vacation * Paid maternity leave for both parents * High job security (it's hard to fire someone) * Working health care system which doesn't cost you anything if you get sick These are big reasons for Germany. And with remot
197.
by tpetry 4y ago
I don't know how you or your friends/parents store important documents but everyone in my bubble has multiple document binders with critical paperwork to keep. Adding a single paper to them is no problem, and the paper is not lost
198.
by tpetry 4y ago
Sure, you don't have to stop at distributing just once copy…
199.
by tpetry 4y ago
The problem is more that you have to use Apple's 2FA which is linked to their devices. You lose them all at once because you are robbed? Good luck! There isn't any way to get a TOTP key you can store in a password manager.
200.
by tpetry 4y ago
That problem is solved by how 1Password works: * Your password vult is encrypted locally and stored on their servers (just an encrypted file!) * To unlock the vault, you need the password and the generated master code. * The master code is
201.
by tpetry 4y ago
How do you plan to start a PostgreSQL instance in less than 1 sec? Sounds interesting. I tried fast booting of PostgreSQL instances and it always took multiple seconds. So i am really curious!
202.
by tpetry 4y ago
I am happy to have helped you! Take a look at the other tips, i‘ve written about more gems.
203.
For each loops with LATERAL Joins(sqlfordevs.io)
5 points by tpetry 4y ago|2 comments
204.
by tpetry 4y ago
TablePlus for viewing and querying stuff and PgAdmin when you need deep PostgreSQL integration.
205.
by tpetry 4y ago
With ubuntu and the automatic security updates you don‘t have to spend any time maintaining it. I haven‘t done anything in months, the system is applying security updates automatically.
206.
by tpetry 4y ago
That‘s a good decision! Developers nowadays fear a failing machine so much because it‘s happening more often on the cloud than dedicated servers. I wouldn‘t use automatic failover too. Cleaning up the mess can take hours and days, a small d
207.
by tpetry 4y ago
His servers are distributed over multiple datacenters at the Falkenstein location of hetzner.
208.
by tpetry 4y ago
This is not really what you had been asking for but inertia.js is doing a spectacular approach of combining Laravel and a SPA. All the benefits you have with MPAs and no need to build APIs for the SPA view part. That‘s the only SPA model I
209.
by tpetry 4y ago
Completely agree. Their offering for running containers is great, but nobody wants to maintain a database. They should add DBaaS on their architecture with automatic backups etc.
210.
by tpetry 4y ago
I believe the parent didn't mean the Oracle DB but Oracle MySQL. This makes the most sense as Oracle's acquisition of MySQL (Sun) was discussed before.

More ›