>The license must not restrict anyone from making use of the program in a specific field of endeavor. For example, it may not restrict the program from being used in a business, or from being used for genetic research.
From the FSF's "What is free software?" page[1]:
>A free program must be available for commercial use, commercial development, and commercial distribution.
Licenses like CockroachDB's with restrictions on commercial use are "source available", which is a form of proprietary software.
The dominant mode of commercial software development is closed. Many commercial firms forbid the use of copyleft software components that might compel licensing choices about company work.
Copyleft means the license leaves the right-to-copy for the user. But copyleft (AGPL, GPL, LGPL) means that you can't remove the copyleft itself even from the new parts, whereas permissive (Apache, MIT) means that you can.
edit: I mixed up weak copyleft and permissive :o
weak copyleft would be things like MPL, that limit the modifications you have to share to only parts of the program.
CockroachDBs new license isn't even Open Source following the common OSI definition of the term.
The term you're looking for is "permissive license". [1]
[1] https://en.wikipedia.org/wiki/Permissive_software_license
Let's put licenses for public software projects into three general categories: permissive, copyleft, and noncommercial. MIT is a classic permissive license. GPLv2 is a classic copyleft license. Prosperity (https://licensezero.com/licenses/prosperity) is a recent noncommercial license.
Heavily simplifying, and ignoring a lot of details and variations:
Permissive licenses allow you to do more or less whatever you please with the software, as long as you make sure that copies of the software you share with others come along with copies of the permissive license terms and the developer's copyright notices.
Copyleft licenses are permissive licenses plus one extra rule: In at least some circumstances, you have to share and license your own software work the same way. When you have to share, and what code you have to share, varies by specific copyleft license.
Noncommercial licenses are permissive licenses plus a different rule: You may not use the software for commercial purposes.
So what's the deal with developers releasing code under copyleft licenses, and then charging individual customers for "commercial licenses"? To understand that, we have to read the licenses in context. It's not just about what the licenses say, but about how that fits into the broader picture of the software industry.
Most companies producing software insist on keeping their software closed, rather than releasing it in the open. That way they can sell access and permission to use it. These companies will not share their work alike. So they intentionally avoid and reject software under copyleft licenses that would require them to do otherwise.
However, sometimes these firms really want to use software under a copyleft license in their products. If possible, they'll often try to buy a license from the developer that allows them to ignore the copyleft rule, so they can have it both ways.
Meanwhile, these firms often use tons and tons of permissively licensed software. They're free to do that, without paying anyone, so long as they follow the rules about copies of license terms and copyright notices.
Hopefully that gives you a broad picture to work from. Good luck with your project.