didgetmaster

↗ HN profile [ 72.6 ms ] full profile
Karma
0
Created
()
Submissions
0
  1. The up and down vote buttons next to each comment are very close together. It can be really tricky to hit the right one with your finger on a phone touch screen. There are numerous times when I just have to hope that…

  2. Criminals (especially murderers) are often convicted at least partially by matching their DNA to evidence left at the scene of the crime (hair, skin, blood, semen, etc). DNA labs are getting really good at matching…

  3. If you have relational data (stored in a table, a CSV file, or a Json file) there might be a need to mix it all up for testing or anonymity purposes. So you might have a table with 20 columns (e.g. name, address, city,…

  4. I am trying to get my Postgres server to run queries as fast as possible. I have a table with about 7.5M rows and 22 columns (Chicago crime data) and have created appropriate (I think) indexes on the columns I want to…

  5. HDDs and some SDDs are now big enough to store hundreds of millions of files. MacOS Spotlight, Windows Search, and Locate on Linux are just a few file indexers available. How many files can you index using them? What is…

  6. I use my phone for a small software business so I can't just block any unknown number. A call from a customer or potential customer could come from anywhere. I must get a dozen cold calls a day from spammers/scammers. I…

  7. It wasn't that long ago that you had to combine hard drives in an array to get enough space for 100M+ moderately-sized files. Now you can buy single drives with 20TB+ capacity which is big enough for about 200M files…

  8. Data Science and Serendipity (didgets.substack.com)
  9. As many people know, a database engine is usually designed and built to either do transactions well (OLTP) or analytic operations well (OLAP), but not both. There are a few databases on the market that claim to do both…

  10. I have worked a few jobs that required some DB tuning in order to get queries to run faster. One of the first things to do is to create and maintain indexes on relational tables. You spend time analyzing queries to…