tpetry

33 ms·

391.
by tpetry 6y ago
Mysql 8 supports atomic ddl, which means if you drop two tables in a single DROP TABLE query either both are deleted or none. But it does not support postgresql‘s transactional ddl feature where you can start a transaction change the struct
392.
by tpetry 6y ago
The best part is transactional ddl statements. You can do your database migration in a transaction, if something fails the transaction is rolled back compared to an invalid state with mysql.
393.
by tpetry 6y ago
The article is missing one of the best features of iso 8601: it‘s string form is naturally sortable. You don‘t need any specific logic for sorting, so e.g. your filesystem will automatically sort files correctly if you prefix them with a is
394.
by tpetry 6y ago
The commercial virtualisation tools from Parallels and VMware support creating macOS guests on a macOS host by making a clean install, i guess from the macos recovery system/service? Are you planning on macOS guests too? It's some
395.
by tpetry 6y ago
And the single core performance benchmarks are exactly identical which would mean there would have not been any optimization compared to last gen. Not very realistic.
396.
by tpetry 6y ago
Something which is really missing is wifi support and the ability to pull a custom image to display from somewhere. You could then easily display status dashboards, calendars, whatever someone likes. If you have a library for easily buildin
397.
by tpetry 6y ago
The problem with the non-boring technology club is that programmers see what problem FAANG companies are solving and wanting to be on the edge on new technology too. But they don‘t have the same problems. Another problem is they want to sho
398.
by tpetry 6y ago
Yes, these comparisons are kind of senseless. But spending so much money on atomic weapons is kind of bullshit! These are weapons, if ever used again will probably take-out humanity because if some of those are flying to you, you will answe
399.
by tpetry 6y ago
A better tip would be to use something like time-ordered uuids: You can‘t misuse them for something different and the added bonus is that no one can iterate your db records by just incrementing the url.
400.
by tpetry 6y ago
In my opinion naming it global warming was the biggest mistake. People hear it‘s getting hotter, don‘t see this effect and „don‘t believe in it“. Events like this is another point why people don‘t believe in global warming, they see very co
401.
by tpetry 6y ago
https://chromeisbad.com/ I did not have time yet to schow whether the claims are true but i found this when searching why i have insanely high windowserver cpu activity. Seems chrome on mac is heading into a strange directi
402.
by tpetry 6y ago
Wait? Your can for example put an unicode string into integer or number columns? That can‘t be true? I mean, really? ...
403.
by tpetry 6y ago
These specific tricks do exist for every database. But there is no reason for mssql to not handle count(*) and count(1) the same, they are the same. Maybe they are already the same and it‘s just a very old trick which has been replaced by a
404.
by tpetry 6y ago
You do understand this wrong! The message is that any startup/company not in the valley will have a hard time finding employees. Until now every company paid a salary fitted for the locale the company is in: You are in an area with a l
405.
by tpetry 6y ago
This performance optimization is valid for most databases: COUNT(column) means in reality COUNT(column is NOT NULL), so if the column can have nulls the values need to be checked. But in most databases there is no difference in performance
406.
by tpetry 6y ago
These arguments are correct and repeated for many many years. Nevertheless in reality most of the stated reasons have almost no real practicability. They re correct in an "academic view" but most applications are CRUD and based on
407.
by tpetry 6y ago
You can‘t transfer single ips to aws, only complete networks. And then this networks is limited to a single region. So it sounds easy, but is only usefull for companies with multiple networks. But even then i guess aws is publishing that th
408.
by tpetry 6y ago
My statement was not correct, you are right. But every user/role in postgres has by default the rights to create objects in the public schema and to connect to every database [1]. The only way to remove this is to remove the rights on
409.
by tpetry 6y ago
Pypy isnt used that much because you may run into problems. And nobody wants to research strange runtime errors in production. But the speed improvements would be welcome if they were in cpython because you can be quite sure there will be n
410.
by tpetry 6y ago
Why does this not happen or anything like this? Ruby got MJT in a big effort to make Ruby a lot faster. PHP is constantly increasing it‘s performance and tries to change a lot to get faster (basic building blocks for JIT in PHP8). Why is py
411.
by tpetry 6y ago
Try the lock down e.g. a user to only allow reads. Not easy, when testing if it‘s working you will see so many „strange“ behaviours e.g. you can still create tables in public namespace, databases created before/after (dont remember whi
412.
by tpetry 6y ago
The conclusion you made may be wrong. You imply that all these $9 apps convert more than a handful of people. But if they convert the same your friend already applied successfully the „charge more“ concept as (s)he is getting more from ever
413.
by tpetry 6y ago
Wow, that are really high requirements. Stackoverflow was able to operate on a lot less servers in 2016, they had e.g. only 4 database servers. Is there any analysis why parler did have such high requirements? Or what they did exactly to ha
414.
Spamcop.net email blacklist domain expired making every IP blacklisted(twitter.com)
2 points by tpetry 6y ago|1 comments
415.
by tpetry 6y ago
Remove specific folders from the results. I stopped using Github Code Search because when i do it get dozens of pages for a match in unit tests and i don‘t find the single results in the real codebase.
416.
by tpetry 6y ago
Running docker with homebrew and on docker, no problems. I am not using antivirus as they produce many problems on mac (and are hellish slow), i guess the problem is really on triggered by antivirus software.
417.
by tpetry 6y ago
The vast webrtc traffic is in reality between a peer and a sfu (selective forwarding unit) on a server. There is almost none real p2p webrtc traffic happening in reality because most people don‘t have enough upload bandwidth to transmit the
418.
by tpetry 6y ago
Ups, yeah it should be lz4, but i can‘t change it anymore.
419.
by tpetry 6y ago
Zfs is so fast it should be the default for everything where a slight compression may benefit the system: disk io, network transfers, ...
420.
by tpetry 6y ago
Interestingly there is no product on the markt to collect feature ideas and classify them. Kanban boards etc. Are nice, but if you store many ideas you will completely lose focus. Ideas, which may or may not be implemented one day have so m

More ›