Need to store images in SQL Server, but how?

Question

In order to store images in a SQL Server database, I am working with a naive table. The table's columns are: ImageID, X, Y, value.

Table sample data:

[1 1 1 255] %first image, pixel (1,1)
[1 1 2 100] %first image, pixel (1,2)
[1 2 1 100] %first image, pixel (2,1)
[1 2 2 0]
[2 1 1 100] %second image, pixel (1,1)
[2 1 2 10]

I choose this specific way for storing images for executing queries such as:

select count(value) 
from myTable 
where myTable.x = 10 and myTable.y = 15 and myTable.value > 10

The problem is that I am running out of storage - the table is getting too big. Do you have any suggestion for saving images more efficiently while maintaining the ability to executes queries like the mentioned above?

Thanks.

you may consider looking into this post - stackoverflow.com/questions/416881/… — Wasi Ahmad
– Wasi Ahmad, Commented Dec 15, 2016 at 20:18
why are you storing images in DB, is there a specific reason? — FailedUnitTest
– FailedUnitTest, Commented Dec 15, 2016 at 20:37
I choose this specific way for storing images for executing queries as mentiond above — Ido Zoref
– Ido Zoref, Commented Dec 15, 2016 at 20:38

Community · Accepted Answer · 2017-05-23 10:30:41Z

3

I really feel that a database is the wrong way to handle this problem. I would have, perhaps, a database of image locations and a server side component that can read the images from some sort of local store (i.e. a directory) and run something like ImageMagik to determine if a particular pixel in each image is a particular color. This post might give you some ideas in that direction.

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Dec 15, 2016 at 20:17

stdunbar

17.6k12 gold badges40 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to store images in SQL Server, but how?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related