Good idea to store pictures using database?

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)
 
Last edited:

huffie

Senior Member
Joined
Mar 9, 2007
Messages
1,199
Reaction score
2
Why don't you save your images based on date and time? (e.g yyyyMMdd_HHmm.jpg) and you can do sorting based on filename? then your main folder would be YYYY->MM (sub-folder) ? would this be practical?
 

davidktw

Arch-Supremacy Member
Joined
Apr 15, 2010
Messages
13,550
Reaction score
1,302
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
It is not very clear what your search criteria is, you mentioned that it is timings, but how does the search criteria works ?

Do you specify a range or a specific date time ?
You have mentioned a picture may be linked to multiple timings, but does multiple pictures also link to one particular timing ?
You quoted a stock market price chart as an example of your picture. Does it mean the picture is dynamic in nature ?

Images are normally not store in database because it will be difficult to administrate compared to filesystem. Database can store images as binaries but it will not be the best use of database.

There are problems like how do you want to administrate the database data which I would call them metadata of your pictures and how do you want to administrate your pictures. How do you want to create the references between them ?

As like what the post above have suggested, you can use folders, but you will most likely also need to use symbolic or hard links if you have multiple images link from multiple references.

Trust me when I say in the directory tree listing below, there is only 1 file, despite. It was first created in 2020/1/3 to mean 3rd Jan 2020.
Then a symbolic link is created in 202o/2/2 to mean 2nd of Feb 2020 that link the same file.
The 3rd one is in 2021/1/1 meaning 1st of Jan 2021. A hard link is created to link to the same file as the one in 2020/1/3.
What it really means in the 3rd case is both the hard links are point the same file, while the symbolic links is just a reference.

In a unix environment, data blocks of a file is never shown. It is identified using what we called inode.
So when you look at the inode column below, you will see both the hard links are point to the same data file of inode 210127335

Bash:
    inode Permissions Size User     Date Modified Name
210124379 drwxr-xr-x     - davidktw  9 Dec 01:13  .
210127301 drwxr-xr-x     - davidktw  9 Dec 01:13  ├── 2020
210127306 drwxr-xr-x     - davidktw  9 Dec 01:13  │  ├── 1
210127318 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  ├── 1
210127319 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  ├── 2
210127320 drwxr-xr-x     - davidktw  9 Dec 01:14  │  │  └── 3
210127335 .rw-r--r--     0 davidktw  9 Dec 01:14  │  │     └── image.jpg   (HARDLINK)
210127307 drwxr-xr-x     - davidktw  9 Dec 01:13  │  ├── 2
210127324 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  ├── 1
210127325 drwxr-xr-x     - davidktw  9 Dec 01:14  │  │  ├── 2
210127336 lrwxr-xr-x    19 davidktw  9 Dec 01:14  │  │  │  └── image.jpg -> ../../1/3/image.jpg (SYMBOLIC LINK)
210127326 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  └── 3
210127308 drwxr-xr-x     - davidktw  9 Dec 01:13  │  └── 3
210127321 drwxr-xr-x     - davidktw  9 Dec 01:13  │     ├── 1
210127322 drwxr-xr-x     - davidktw  9 Dec 01:13  │     ├── 2
210127323 drwxr-xr-x     - davidktw  9 Dec 01:13  │     └── 3
210127302 drwxr-xr-x     - davidktw  9 Dec 01:13  └── 2021
210127303 drwxr-xr-x     - davidktw  9 Dec 01:13     ├── 1
210127309 drwxr-xr-x     - davidktw  9 Dec 01:15     │  ├── 1
210127335 .rw-r--r--     0 davidktw  9 Dec 01:14     │  │  └── image.jpg    (HARDLINK)
210127310 drwxr-xr-x     - davidktw  9 Dec 01:13     │  ├── 2
210127311 drwxr-xr-x     - davidktw  9 Dec 01:13     │  └── 3
210127304 drwxr-xr-x     - davidktw  9 Dec 01:13     ├── 2
210127315 drwxr-xr-x     - davidktw  9 Dec 01:13     │  ├── 1
210127316 drwxr-xr-x     - davidktw  9 Dec 01:13     │  ├── 2
210127317 drwxr-xr-x     - davidktw  9 Dec 01:13     │  └── 3
210127305 drwxr-xr-x     - davidktw  9 Dec 01:13     └── 3
210127312 drwxr-xr-x     - davidktw  9 Dec 01:13        ├── 1
210127313 drwxr-xr-x     - davidktw  9 Dec 01:13        ├── 2
210127314 drwxr-xr-x     - davidktw  9 Dec 01:13        └── 3

What I have shared is a filesystem technique which you can create references that satisfy your logic requirement, without the need of a database.

If you would like to know how I create the directories
Bash:
mkdir 2020 2021
find . -type d -mindepth 1 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 3 | xargs -n 1 mkdir"
find . -type d -mindepth 2 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 3 | xargs -n 1 mkdir"

# if you want to create the full year calendar directories
mkdir 2020 2021
find . -type d -mindepth 1 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 12 | xargs -n 1 mkdir"
find . -type d -mindepth 2 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 31 | xargs -n 1 mkdir"
# remove the extra directories yourself, say there is no days 29, 30, and 31 in 2020 and 2021, but there will be 29 Feb 2024.

If you choose this approach, do you need to create all the way up to hours and mins and seconds if that is what you want ?
The answer is no, you just need to create the directories and references when you need and have separate logic to know if
such kind of references exist

Say if you need all the way up to seconds and you have 2 references to the same image.jpg
31st Jan 2020 22:39:40
28th Feb 2021 10:00:00

Bash:
$ exa --tree --long --inode --level 7
210124379 drwxr-xr-x - davidktw  9 Dec 01:45 .
210327579 drwxr-xr-x - davidktw  9 Dec 01:45 ├── 2020
210327580 drwxr-xr-x - davidktw  9 Dec 01:45 │  └── 1
210327581 drwxr-xr-x - davidktw  9 Dec 01:45 │     └── 31
210327582 drwxr-xr-x - davidktw  9 Dec 01:45 │        └── 22
210327583 drwxr-xr-x - davidktw  9 Dec 01:45 │           └── 39
210327584 drwxr-xr-x - davidktw  9 Dec 01:45 │              └── 40
210327588 .rw-r--r-- 0 davidktw  9 Dec 01:45 │                 └── image.jpg
210327589 drwxr-xr-x - davidktw  9 Dec 01:45 └── 2021
210327590 drwxr-xr-x - davidktw  9 Dec 01:45    └── 2
210327591 drwxr-xr-x - davidktw  9 Dec 01:45       └── 28
210327592 drwxr-xr-x - davidktw  9 Dec 01:45          └── 10
210327593 drwxr-xr-x - davidktw  9 Dec 01:45             └── 00
210327594 drwxr-xr-x - davidktw  9 Dec 01:46                └── 00
210327588 .rw-r--r-- 0 davidktw  9 Dec 01:45                   └── image.jpg

Have fun
:)
 
Last edited:

xiaonajia

Senior Member
Joined
Mar 11, 2018
Messages
1,029
Reaction score
1
Why don't you save your images based on date and time? (e.g yyyyMMdd_HHmm.jpg) and you can do sorting based on filename? then your main folder would be YYYY->MM (sub-folder) ? would this be practical?
Each picture can only have 1 name, but there are multiple timings linked to each picture.

So if I wish to link multiple timings to 1 picture, then I have to basically duplicate that picture just to give it another name and that would not be a good use of space? Or did I misunderstand how it's supposed to be implemented?
It is not very clear what your search criteria is, you mentioned that it is timings, but how does the search criteria works ?

Do you specify a range or a specific date time ?
You have mentioned a picture may be linked to multiple timings, but does multiple pictures also link to one particular timing ?
You quoted a stock market price chart as an example of your picture. Does it mean the picture is dynamic in nature ?

Images are normally not store in database because it will be difficult to administrate compared to filesystem. Database can store images as binaries but it will not be the best use of database.

There are problems like how do you want to administrate the database data which I would call them metadata of your pictures and how do you want to administrate your pictures. How do you want to create the references between them ?

As like what the post above have suggested, you can use folders, but you will most likely also need to use symbolic or hard links if you have multiple images link from multiple references.

Trust me when I say in the directory tree listing below, there is only 1 file, despite. It was first created in 2020/1/3 to mean 3rd Jan 2020.
Then a symbolic link is created in 202o/2/2 to mean 2nd of Feb 2020 that link the same file.
The 3rd one is in 2021/1/1 meaning 1st of Jan 2021. A hard link is created to link to the same file as the one in 2020/1/3.
What it really means in the 3rd case is both the hard links are point the same file, while the symbolic links is just a reference.

In a unix environment, data blocks of a file is never shown. It is identified using what we called inode.
So when you look at the inode column below, you will see both the hard links are point to the same data file of inode 210127335

Bash:
    inode Permissions Size User     Date Modified Name
210124379 drwxr-xr-x     - davidktw  9 Dec 01:13  .
210127301 drwxr-xr-x     - davidktw  9 Dec 01:13  ├── 2020
210127306 drwxr-xr-x     - davidktw  9 Dec 01:13  │  ├── 1
210127318 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  ├── 1
210127319 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  ├── 2
210127320 drwxr-xr-x     - davidktw  9 Dec 01:14  │  │  └── 3
210127335 .rw-r--r--     0 davidktw  9 Dec 01:14  │  │     └── image.jpg   (HARDLINK)
210127307 drwxr-xr-x     - davidktw  9 Dec 01:13  │  ├── 2
210127324 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  ├── 1
210127325 drwxr-xr-x     - davidktw  9 Dec 01:14  │  │  ├── 2
210127336 lrwxr-xr-x    19 davidktw  9 Dec 01:14  │  │  │  └── image.jpg -> ../../1/3/image.jpg (SYMBOLIC LINK)
210127326 drwxr-xr-x     - davidktw  9 Dec 01:13  │  │  └── 3
210127308 drwxr-xr-x     - davidktw  9 Dec 01:13  │  └── 3
210127321 drwxr-xr-x     - davidktw  9 Dec 01:13  │     ├── 1
210127322 drwxr-xr-x     - davidktw  9 Dec 01:13  │     ├── 2
210127323 drwxr-xr-x     - davidktw  9 Dec 01:13  │     └── 3
210127302 drwxr-xr-x     - davidktw  9 Dec 01:13  └── 2021
210127303 drwxr-xr-x     - davidktw  9 Dec 01:13     ├── 1
210127309 drwxr-xr-x     - davidktw  9 Dec 01:15     │  ├── 1
210127335 .rw-r--r--     0 davidktw  9 Dec 01:14     │  │  └── image.jpg    (HARDLINK)
210127310 drwxr-xr-x     - davidktw  9 Dec 01:13     │  ├── 2
210127311 drwxr-xr-x     - davidktw  9 Dec 01:13     │  └── 3
210127304 drwxr-xr-x     - davidktw  9 Dec 01:13     ├── 2
210127315 drwxr-xr-x     - davidktw  9 Dec 01:13     │  ├── 1
210127316 drwxr-xr-x     - davidktw  9 Dec 01:13     │  ├── 2
210127317 drwxr-xr-x     - davidktw  9 Dec 01:13     │  └── 3
210127305 drwxr-xr-x     - davidktw  9 Dec 01:13     └── 3
210127312 drwxr-xr-x     - davidktw  9 Dec 01:13        ├── 1
210127313 drwxr-xr-x     - davidktw  9 Dec 01:13        ├── 2
210127314 drwxr-xr-x     - davidktw  9 Dec 01:13        └── 3

What I have shared is a filesystem technique which you can create references that satisfy your logic requirement, without the need of a database.

If you would like to know how I create the directories
Bash:
mkdir 2020 2021
find . -type d -mindepth 1 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 3 | xargs -n 1 mkdir"
find . -type d -mindepth 2 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 3 | xargs -n 1 mkdir"

# if you want to create the full year calendar directories
mkdir 2020 2021
find . -type d -mindepth 1 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 12 | xargs -n 1 mkdir"
find . -type d -mindepth 2 | xargs -n 1 -I{} bash -c "pushd {}; seq 1 31 | xargs -n 1 mkdir"
# remove the extra directories yourself, say there is no days 29, 30, and 31 in 2020 and 2021, but there will be 29 Feb 2024.

If you choose this approach, do you need to create all the way up to hours and mins and seconds if that is what you want ?
The answer is no, you just need to create the directories and references when you need and have separate logic to know if
such kind of references exist

Say if you need all the way up to seconds and you have 2 references to the same image.jpg
31st Jan 2020 22:39:40
28th Feb 2021 10:00:00

Bash:
$ exa --tree --long --inode --level 7
210124379 drwxr-xr-x - davidktw  9 Dec 01:45 .
210327579 drwxr-xr-x - davidktw  9 Dec 01:45 ├── 2020
210327580 drwxr-xr-x - davidktw  9 Dec 01:45 │  └── 1
210327581 drwxr-xr-x - davidktw  9 Dec 01:45 │     └── 31
210327582 drwxr-xr-x - davidktw  9 Dec 01:45 │        └── 22
210327583 drwxr-xr-x - davidktw  9 Dec 01:45 │           └── 39
210327584 drwxr-xr-x - davidktw  9 Dec 01:45 │              └── 40
210327588 .rw-r--r-- 0 davidktw  9 Dec 01:45 │                 └── image.jpg
210327589 drwxr-xr-x - davidktw  9 Dec 01:45 └── 2021
210327590 drwxr-xr-x - davidktw  9 Dec 01:45    └── 2
210327591 drwxr-xr-x - davidktw  9 Dec 01:45       └── 28
210327592 drwxr-xr-x - davidktw  9 Dec 01:45          └── 10
210327593 drwxr-xr-x - davidktw  9 Dec 01:45             └── 00
210327594 drwxr-xr-x - davidktw  9 Dec 01:46                └── 00
210327588 .rw-r--r-- 0 davidktw  9 Dec 01:45                   └── image.jpg

Have fun
:)
Do you specify a range or a specific date time ?
I will specify a time range, eg 10am to 11am. Then the query will turn up records that have "events" happening during that time. These "events" will have a time tag to them. Each picture will have multiple timings/"events".

You have mentioned a picture may be linked to multiple timings, but does multiple pictures also link to one particular timing ?
It's possible for multiple pictures to be linked to 1 particular timing but not necessary. If it is linked to particular timing, it's a coincidence

You quoted a stock market price chart as an example of your picture. Does it mean the picture is dynamic in nature ?

The picture is a still picture. So you may think of each picture as end of day stock market price chart.

How do you want to create the references between them ?
Honestly, I don't know the best way to do this, which is why I'm here :p
Here's a video that can somewhat explain my design thought.


If you choose this approach, do you need to create all the way up to hours and mins and seconds if that is what you want ?
The answer is no, you just need to create the directories and references when you need and have separate logic to know if
such kind of references exist

I'm kind of new to this filesystem method but it does seems to fit what I want,
I guess my question is how do you search through it easily with different criterias as a DB allow you to write SQL statements to fit what you query? (Some examples of possible search criteria are mentioned in main post)

I will need to take some time to learn it as it looks complicated and tedious. Thanks for mentioning it!

Note: I have included in the main post, an example of what I have and want. I had originally wanted to use Excel to implement this as I'm more familiar with it but seems like pictures in excel is a pain to do.
 
Last edited:

Trader11

Banned
Joined
Oct 14, 2018
Messages
15,697
Reaction score
5,235
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 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 with "uptrend"
Why are we helping to do your finance tech job?
 

xiaonajia

Senior Member
Joined
Mar 11, 2018
Messages
1,029
Reaction score
1
Why are we helping to do your finance tech job?
I'm not quite sure what provokes this comment. Is it because I use price chart as an example? I use it because it illustrates what I have in mind, for that purpose only, an example.

I am asking for advice on what's the best way to do this. As you may infer, my technical knowledge is low (Eg who stores pictures in database) I would be fired from my job immediately

I will still be doing the implementation myself and fyi, it's just a personal project, not work related or deadline driven.
 
Last edited:

davidktw

Arch-Supremacy Member
Joined
Apr 15, 2010
Messages
13,550
Reaction score
1,302
Each picture can only have 1 name, but there are multiple timings linked to each picture.

So if I wish to link multiple timings to 1 picture, then I have to basically duplicate that picture just to give it another name and that would not be a good use of space? Or did I misunderstand how it's supposed to be implemented?

Do you specify a range or a specific date time ?
I will specify a time range, eg 10am to 11am. Then the query will turn up records that have "events" happening during that time. These "events" will have a time tag to them. Each picture will have multiple timings/"events".

You have mentioned a picture may be linked to multiple timings, but does multiple pictures also link to one particular timing ?
It's possible for multiple pictures to be linked to 1 particular timing but not necessary. If it is linked to particular timing, it's a coincidence

You quoted a stock market price chart as an example of your picture. Does it mean the picture is dynamic in nature ?

The picture is a still picture. So you may think of each picture as end of day stock market price chart.

How do you want to create the references between them ?
Honestly, I don't know the best way to do this, which is why I'm here :p
Here's a video that can somewhat explain my design thought.


If you choose this approach, do you need to create all the way up to hours and mins and seconds if that is what you want ?
The answer is no, you just need to create the directories and references when you need and have separate logic to know if
such kind of references exist

I'm kind of new to this filesystem method but it does seems to fit what I want,
I guess my question is how do you search through it easily with different criterias as a DB allow you to write SQL statements to fit what you query? (Some examples of possible search criteria are mentioned in main post)

I will need to take some time to learn it as it looks complicated and tedious. Thanks for mentioning it!

Note: I have included in the main post, an example of what I have and want. I had originally wanted to use Excel to implement this as I'm more familiar with it but seems like pictures in excel is a pain to do.

The filesystem method that I have provided is just an approach if you decide not to use a database, but with some new information, I will recommend that you implement this assignment with a RDMBS like MySQL.

The very usual approach is simply store your meta information in the database and the image file outside of the database. Hence you could have an events table in the following form

SQL:
CREATE TABLE events (
  id INTEGER PRIMARY KEY,
  dt DATETIME NOT NULL,
  image_ref VARCHAR(2000) NOT NULL
);

You just need to have an administrative web console (assuming you are building a web application), to create the reference. Your web console should allow you to list images in a directory where all the image assets are stored. Then you can create new entries in the events table to create the reference.

This way when you have multiple references to the images, you can issue a query similar to the following to get all images that fall within a date time range

SQL:
SELECT image_ref FROM events WHERE dt >= '2020-01-01 00:00:00' and dt <= '2020-10-01 00:00:00';

-- if you need unique images, here is a slightly different query
SELECT DISTINCT(image_ref) FROM events WHERE dt >= '2020-01-01 00:00:00' and dt <= '2020-10-01 00:00:00';
 

davidktw

Arch-Supremacy Member
Joined
Apr 15, 2010
Messages
13,550
Reaction score
1,302
This is just for fun for the filesystem approach that I have provided earlier.

Here is an example of a couple of images stored in the respective directories in the form of
YYYY/MM/DD/image_filename

Bash:
$ tree
.
|-- 1997
|   `-- 01
|       `-- 01
|           `-- image.jpg
|-- 2020
|   `-- 01
|       `-- 31
|           `-- image.jpg
|-- 2021
|   `-- 02
|       `-- 02
|           `-- image.jpg
|-- 2023
|   `-- 12
|       `-- 29
|           `-- image.jpg
`-- fallbetween.sh

Ignore the fallbetween.sh script. It's the testing script use to select files that fall between 2 dates (inclusively)

Below is the command to use the fallbetween.sh script conjunction with find command as such
Bash:
$ find . -mindepth 4 -type f -exec ./fallbetween.sh 2020/01/30 2022/01/01 {} \; -print
./2020/01/31/image.jpg
./2021/02/02/image.jpg

In the above, you notice the find command have the following option
./fallbetween.sh 2020/01/30 2022/01/01 {}
The {} will be substitute with each file path found namely
./2023/12/29/image.jpg ./2020/01/31/image.jpg ./1997/01/01/image.jpg ./2021/02/02/image.jpg

The fallbetween.sh script will take in all 3 arguments <START_DATE> <END_DATE> <FILEPATH>
and determine if the FILEPATH should be allowed to be printed, hence meaning selected.

Below is the contents of the fallbetween.sh script
Bash:
#!/usr/bin/env bash

START=`date +'%s' --date $1`
END=`date +'%s' --date $2`
ACTUAL=$(date +'%s' --date `echo $3 | grep -Po '\d{4}/\d{2}/\d{2}'`)
[ $ACTUAL -ge $START -a $ACTUAL -le $END ] && exit 0 || exit 1

There are of course a lot of ways to solve this problem. The above is what I decided to do with just shell scripts and interesting use of a filesystem to store your data.
Basically I'm just demonstrating the technique of problem solving using readily available tools already found in probably all unices today.

The tools are
  • filesystem
  • mkdir
  • bash
  • find
  • date
  • grep
All the tools above are common. However the technique to go above solving it may consider be abit fancy depending on your perspective.
Have fun coding.
:)
 
Last edited:

xiaonajia

Senior Member
Joined
Mar 11, 2018
Messages
1,029
Reaction score
1
hey davidtw, thanks for replying

Currently I'm slowly building up the DB in my free time as it's been awhile since I touched DB stuff

I will refer to the posts for guidance if I encounter any problems

Thanks again!
 
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ Forums. Forum members and moderators are responsible for their own posts. Please refer to our Community Guidelines and Standards and Terms and Conditions for more information.
Top