Community Edition is official by Embarcadero, to developers begginers, students, and dont use advanced technology and Remote Database like MSSQL, Oracle, etc.. more simples apps with local Database (Embbed), for example. Then is not for "developers that need to use all techs currently", but would like learn the language, like "MS Windows Start or Home". understand?
You can buy components suite from another company for example, but is necessary know if it will works!
You want learn Object Pascal or CBuilder but dont need all resources initially.
But another limit is " IF you SALE your apps, your amount / years should be <= $5000.00 <--- important because Embarcadero will can block your license!
You license is Free for each year, then, it will be renewed each years - Free!
You can create apps VCL, FMX, Android etc.. but you dont have "remote Database components" understand?
Lite edition is normally, non-official version, or be, someone xpert like "Lsuper" release one "hacked" version with little resources or customized installation.
If you're begginer, then try Download the Community Edition (Delphi or CBuilder) in Embarcadero site.
NOTE: if you have one edition the same value than Community Edition, then you need un-install it. Because CE dont will install with another IDE the same value.
CE 10.3 = RAD Studio 10.3 Arch / Enterprise / Pro, etc...
But you can install in a VM for example.
more info in Embarcadero official site in Community Edition products!