V
V
Vyacheslav_Shilov2019-04-02 16:41:19
SQLite
Vyacheslav_Shilov, 2019-04-02 16:41:19

Is it possible to create a table in SQLite containing columns for text and images?

Is it possible to create a table in SQLite containing columns for text and images? Or is it better to write two databases separately. I just did not come across tutorials teaching how to create a table where everything is together. Wherever they teach, they create either only for text or only for images. I need everything together, and if it's unlikely, I don't want to risk time. The user will need to select pictures from the gallery

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman Mirilaczvili, 2019-04-02
@2ord

It is possible . A BLOB column can store any binary object. TEXT - text.
But you don't need to store images in the DBMS. This is an antipattern.
https://habr.com/ru/post/81862/
https://habr.com/ru/post/45966/
https://stackoverflow.com/questions/561447/store-p...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question