mysql - SQL different table or store as text in same table -


i have dilemma can't seem put rest.

on page have list of objects. each of objects slider - aribnb - https://www.airbnb.com/s/london--united-kingdom?source=ds

in db store information object (it has other info except slides), i'm thinking, easiest store url slides block of text. 

url       | other_field ----------------------- url1,url2 | other stuff

then handle there in either front end or backend converting them array etc.

the second approach create separate table i'd store each url , id of object url belongs on separate row 

url  | obj_id ------------- url1 | id1 url2 | id1 url3 | id2 .............

. i'd group_concat( distinct x) , return them me block of text. i'd same thing splitting them up.

long story short, store them field in initial table or in separate table, each being it's own row. advantages , disadvantages either approach? me seems easier have them text in same table, i'm inexperienced in this, need advice.

edit: final usable format json slides being either array, or text split array @ appropriate time.

the answer is... depends. if think of urls notes in block of text, maybe makes sense store them in 1 field. make sure set field length large enough.

however, if think ever might need treat url relational entity... need go second route. mean that? well, if in future need add requirement store not url short description of it? maybe need add active date tell when last time url checked valid. maybe able find objects share common url. i'm not saying these should requirements; i'm saying don't know future requirements be. if you're block of text , block of text, sure... put in varchar(max) field. down road though requirements built on, you'll tempted try hack more stuff blob of text, make things more difficult going forward.

sometimes it's appropriate break normal form speed or simplicity, want sparingly , forethought future possible.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more