Welcome, Guest
Username: Password: Remember me

TOPIC: [ADDED] Field size for text field in DB desgin

Field size for text field in DB desgin 02 Oct 2015 07:22 #13555

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
Hi,

Currently I am developing some component to help students log their progress.
I am adding functionilty to add a snapshot, which is a filtered list of records, saved as json.

In another component which reads ships from a webservice I alos come across this missing feature:

When adding a text of json field, the DB is created as TEXT.
But as you can imagine, a lot of text or a long list of jsonobejcts is larger then the 64 Kilobytes of of TEXT field.
In MySQL there are also the MEDIUMTEXT (16MB) and LONGTEXT (4 GB)
Also for creating a long blog entry TEXT might be too small.

Is is possible to create a feature when adding a text of json field, the mysql field type can be configured?
Like in the properties dialog in the builder, where you set if the field is required and such.

I do it now in an update post install script, but I'd rather have a little as possible customizing.
The administrator has disabled public write access.

Field size for text field in DB desgin 15 Oct 2015 14:08 #13601

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
Can you give this a check admin?
The administrator has disabled public write access.

Field size for text field in DB desgin 25 Jul 2016 20:38 #14331

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
Hi Admin,

I would like to propose this as a new feature :)
The administrator has disabled public write access.

Field size for text field in DB desgin 26 Jul 2016 20:28 #14335

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
  • Karma: 140
This is easy to do.
Coding is now a piece of cake
The administrator has disabled public write access.

Field size for text field in DB desgin 29 Aug 2016 11:13 #14495

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
  • Karma: 140
Coding is now a piece of cake
The administrator has disabled public write access.

Field size for text field in DB desgin 29 Aug 2016 11:18 #14496

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
Nice, thnx!
The administrator has disabled public write access.
Time to create page: 0.094 seconds

Get Started