Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What datatype is best for storing articles in SQL database?

Tags:

sql

php

mysql

I'm creating a custom CMS for my site, and I'm going to store articles (Text and images per article) in a mysql database. what datatype is best suited for that task?

like image 326
siaooo Avatar asked Feb 09 '12 14:02

siaooo


People also ask

Which data type is most suitable for storing documents in MySQL?

Which data type is more suitable for storing “documents” in Mysql? Explanation: Longtext has largest range.

Can we store documents in SQL?

Unstructured files can be stored in the VARBINARY or IMAGE column of a SQL Server table. This approach is effective to maintain transactional consistency and reduces the file management complexity, but when the client application reads data from the SQL table, it uses SQL memory which leads to poor performance.

Which is better VARCHAR or text in MySQL?

In most circumstances, VARCHAR provides better performance, it's more flexible, and can be fully indexed. If you need to store longer strings, use MEDIUMTEXT or LONGTEXT, but be aware that very large amounts of data can be stored in columns of these types.


1 Answers

You shouldn't try to store text and images in a single field, and in this circumstance you probably shouldn't store images in your database at all.

The best solution for this would be to use some kind of markup system in your articles - at it's simplest this could be a filtered subset of html - that is stored as plain text in your database and then parsed in the browser in some way. Obviously if you use filtered html you would not need to write any special code to parse it, but taking this approach does raise possible security issues.

Other options to investigate include Markdown (the system used by this site) as well as BBCode (mainly used by online forums), as well as many others.

To summarise - don't store images and text in one field. Store text, and interpret that text to load images and other media in your articles as appropriate.

like image 106
Hecksa Avatar answered Oct 18 '22 12:10

Hecksa