Login

MySQL "Text" Type Model Field

Author:
blackbrrr
Posted:
May 27, 2008
Language:
Python
Version:
.96
Tags:
text db field mysql database custom-field models
Score:
1 (after 1 ratings)

Custom field for using MySQL's text type.

text is more compact than the longtext field that Django assigns for models.TextField (2^16 vs. 2^32, respectively)

1
2
3
4
5
from django.db import models

class NormalTextField(models.Field):		
	def db_type(self):
		return 'text'

More like this

  1. Type checking templatetag filters by marcorogers 5 years, 6 months ago
  2. FCKEditor replace all vLargeTextField in admin by aronchi 6 years, 10 months ago
  3. JSONField by Jasber 6 years, 3 months ago
  4. Custom model field for mysql time type. by xuqingkuang 5 years, 10 months ago
  5. Many 2 Many Admin Ordering with Mysql by visik7 2 years ago

Comments

romain-hardouin (on August 6, 2008):

Hi,

Always use ''.replace() instead of re.sub() when the value to find is not a pattern. Replace method is roughly ten times faster.

In your snippet :

value = sub("\n", "", value)

Becomes

value.replace('\n', '')

with regards :-)

#

Please login first before commenting.