K
K
kaato2015-10-16 17:42:18
MySQL
kaato, 2015-10-16 17:42:18

Which database to choose for a small service?

You need to choose a database for a small service, entirely tied to images.

Answer the question

In order to leave comments, you need to log in

4 answer(s)
D
Dimonchik, 2015-10-16
@kaato

the one that you know
up to 1 million records without complex queries will be pulled by sqlite, besides, there are Mongo analogues for tige SQLite, but
for experience, Postgres or MySQL is better

K
Konstantin Kitmanov, 2015-10-16
@k12th

File systems do an excellent job of storing and returning images, there is not much point in shoving blobs into the database. So any database, but you can think about the choice of FS.

T
Tlito, 2015-10-16
@tlito

selection criteria are determined. small service is not a criterion. criterion - free, the fastest, does not require resources, and so on.
with such questions, your criterion is the most understandable. so muscle

A
Andrey Raboy, 2015-10-16
@raba

you don't try to store images in the database, only links to them in the file system.
id
name
file - something like $_SERVER['DOCUMENT_ROOT']/images/my.jpg
file_min - $_SERVER['DOCUMENT_ROOT']/images/my_min.jpg
size
type
description
etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question