xiaonajia
Senior Member
- Joined
- Mar 11, 2018
- Messages
- 1,029
- Reaction score
- 1
I would like to organise some pictures using database. The picture is basically a graph with time component to it. As an example, you may think of a stock price chart for the day/session. I would like to make a record for different timings with same price chart picture. So for a picture may be linked to multiple timings, 12pm ,1pm.
I read online that you can store the pictures in a folder and reference the file path. But I have thousands of photos to store and record so its quite troublesome to type the file path. Is there an easier way to drag and drop pictures or to implement this?
Currently I am using microsoft access.
If there's a better way to implement this, please let me know. Don't have to use database if it can achieve what I want. Part of the reason why i thought of database is I can tag the photos and search them up by querying those that I need
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Example:
We have 2 pictures.
- Price chart of AAPL for 8 December 2021
- Price chart of TSLA for 7 December 2021
For each picture, it will be marked/have a record in DB.
- For AAPL,
from 10 am to 10.30 am, it is on an "uptrend"
from 10:45am to 11:30am, it is "sideways"
From 12pm to 3pm, it is on an "downtrend"
-For TSLA,
from 11am to 12pm, it is on "uptrend".
From 2pm to 3pm, it is on "downtrend".
The search criteria can be:
- show all pictures from 10am to 11am
- show all pictures from 10am to 11am with "uptrend"
- show AAPL from 10am to 11am (If this is chosen, then the preference is to have pictures that have "events" linked to it to show up.
Thus, records for AAPL from 10 am to 10.30 am and from 10:45am to 11:30am will show up, even though from 10:45am to 11:30am is not fully within the defined search range. Pretty sure this is just an SQL statement problem)
I read online that you can store the pictures in a folder and reference the file path. But I have thousands of photos to store and record so its quite troublesome to type the file path. Is there an easier way to drag and drop pictures or to implement this?
Currently I am using microsoft access.
If there's a better way to implement this, please let me know. Don't have to use database if it can achieve what I want. Part of the reason why i thought of database is I can tag the photos and search them up by querying those that I need
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Example:
We have 2 pictures.
- Price chart of AAPL for 8 December 2021
- Price chart of TSLA for 7 December 2021
For each picture, it will be marked/have a record in DB.
- For AAPL,
from 10 am to 10.30 am, it is on an "uptrend"
from 10:45am to 11:30am, it is "sideways"
From 12pm to 3pm, it is on an "downtrend"
-For TSLA,
from 11am to 12pm, it is on "uptrend".
From 2pm to 3pm, it is on "downtrend".
The search criteria can be:
- show all pictures from 10am to 11am
- show all pictures from 10am to 11am with "uptrend"
- show AAPL from 10am to 11am (If this is chosen, then the preference is to have pictures that have "events" linked to it to show up.
Thus, records for AAPL from 10 am to 10.30 am and from 10:45am to 11:30am will show up, even though from 10:45am to 11:30am is not fully within the defined search range. Pretty sure this is just an SQL statement problem)
Last edited: