For history sake: I committed localpostnew.
After a discussion (on dev ML or somewhere else? Unfortunately I can't find) it was commonly agreed that we should merge localpostnew in localpostgres
and then remove localpostnew.
Later we commonly decided http://markmail.org/message/op2yl3pcbj3lgxpg to
revert some changes in the new (merged) localpostgres
Feel free to use localpostnew. We could even put it back in, as suggested
Nicolas, but I believe it should be then named otherwise to avoid confusion
Jacques
Le 05/04/2017 à 19:32, Mike a écrit :
Pierre, here is an example from the demo data:
accounting_OrganizationData.xml: <PartyRole partyId="RECEIVING"
roleTypeId="INTERNAL_ORGANIZATIO"/>
The default of ID (20 chrs) is so small that you can't even properly spell
"INTERNAL_ORGANIZATION"... I work with databases every day, and I would be
so limited if I had to work with such small primary IDs.
The thing is you don't want to not limit yourself when you first build a
database. The jira is interesting, and GUIDs are a good example.
Personally, I use postgresql, using the "localpostnew" type... Removed from
trunk for some reason.. It has unlimited primary ID sizes (ok, 2.1G), which
allows me to create any sort of primary key I want.
<field-type-def type="id" sql-type="TEXT" java-type="String"/>
<field-type-def type="id-long" sql-type="TEXT" java-type="String"/>
<field-type-def type="id-vlong" sql-type="TEXT" java-type="String"/>
If you think that type=TEXT is slow or less efficient.. Here is what
postgres says about type "TEXT"..
https://www.postgresql.org/docs/9.3/static/datatype-character.html
*Tip:* There is no performance difference among these three types, apart
from increased storage space when using the blank-padded type, and a few
extra CPU cycles to check the length when storing into a length-constrained
column. While character(n) has performance advantages in some other
database systems, there is no such advantage inPostgreSQL; in fact
character(n) is usually the slowest of the three because of its additional
storage costs. In most situations text or character varying should be used
instead.
Mysql has a similar type... I personally haven't tested it.
On Wed, Apr 5, 2017 at 10:06 AM, Pierre Smits <[email protected]>
wrote:
HI Mike, all,
Re 2: Talk about adjustment of default key size
Why is that absurd? You believe it is too long/too short?
Following JIRA issue may be of interest:
https://issues.apache.org/jira/browse/OFBIZ-8343
Best regards,
Pierre Smits
ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services
OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/
On Wed, Apr 5, 2017 at 5:10 PM, Mike <[email protected]> wrote:
Nice videos. Regarding the mysql setup, you may want to include two
items:
1) Make sure mysql is setup as UTF8, discussed earlier in this mail
group.
Requires tweaking:
framework/entity/config/entityengine.xml
/etc/mysql/my.cnf
2) Talk about adjusting the default sizes of primary keys (ID). The
default is an absurd 20 characters:
framework/entity/fieldtype/fieldtypemysql.xml
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/>
<field-type-def type="id-long" sql-type="VARCHAR(60)"
java-type="String"/>
<field-type-def type="id-vlong" sql-type="VARCHAR(250)"
java-type="String"/>
On Wed, Apr 5, 2017 at 6:03 AM, Pranay Pandey <
[email protected]> wrote:
Thanks so much Deepak!
Best regards,
Pranay Pandey
On Wed, Apr 5, 2017 at 5:51 PM, Deepak Dixit
<deepak.dixit@hotwaxsystems.
com
wrote:
Hi Team,
Here are some more videos from Pranay
- Setup OFBiz in IntelliJ IDEA IDE - Release 16.11 and Trunk
<https://youtu.be/mxToh2rX7NY>
- Setup OFBiz with MySQL <https://youtu.be/Lzmv0DCC5N4>
Thanks Pranay for your effort.
Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
On Wed, Mar 22, 2017 at 7:07 PM, akash jain <[email protected]>
wrote:
Nice videos, thanks Pranay!
Thanks and Regards
--
Akash Jain
On Thu, Mar 9, 2017 at 6:18 PM, Deepak Dixit
<deepak.dixit@hotwaxsystems.
com
wrote:
Hi Everyone,
Pranay has created two video tutorials, these have been published
on
our
OFBiz YouTube channel <https://www.youtube.com/user/ofbiz>:
1 - Apache OFBiz Mailing Lists <https://www.youtube.com/
watch?v=bIS2kftvsq4>
2 - OFBiz Beginners Tutorial - Basic Setup Release16.11
<https://youtu.be/efkB_aN-ODw>
Thanks Pranay for these helpful videos.
Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
