AmigaNet / amigasource

The Amigasource web directory
0 stars 0 forks source link

Baseline - Review database tables #6

Open amigasource4000 opened 11 months ago

amigasource4000 commented 11 months ago

--perform initial review of tables, variables and relationships to establish a proper basline , relationships and to plan for future growth -- the second most important baseline task

amigasource4000 commented 11 months ago

really need your help with this one. i know i didn't do a good job in planning the tables, their relationships or their naming conventions!!

BenOvermyer commented 11 months ago

One of the things I'll be doing is getting rid of a lot of unnecessary wording in the column names.

For example, instead of table t_links having a column t_link_name, we'll have a table links having a column name. It's a little thing, but will help in the long run.

amigasource4000 commented 11 months ago

Good to go. If you noticed issue 6 is TOTALLY about going over the tables. They are messy, wordy and to not built properly for the current tasks or future growth!

You obviously noticed this so feel free to change whatever you need. Still at some point, after you come back, i would love to just spend 30 min discussing them.

On a side note i did my weekly update to the site and I hit 690 links. To make 1000 for the year i need to up my weekly new links count from 20 to 25.

I CANNOT wait till im no longer having to edit raw html and manually checking to see if i have already added this link or not. Oh and the same goes to updating my weekly ramblings!! Lol

On Sep 28, 2023, at 8:35 AM, Ben Overmyer @.***> wrote:



One of the things I'll be doing is getting rid of a lot of unnecessary wording in the column names.

For example, instead of table t_links having a column t_link_name, we'll have a table links having a column name. It's a little thing, but will help in the long run.

— Reply to this email directly, view it on GitHubhttps://github.com/AmigaNet/amigasource/issues/6#issuecomment-1739073496, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCXAQBTMRCR6IEYSHRBQZLLX4VVI5ANCNFSM6AAAAAA5CPE2AU. You are receiving this because you authored the thread.Message ID: @.***>

amigasource4000 commented 11 months ago

Well holy crap. . . You DID notice issue 6 because I JUST NOTICED that is email is actually part of the discussion thread under the issue on GitHub. Lol. Still learning.

But in my shitty defense im only seeing this email on my phone and didn’t notice the small print at the bottom . Lol

On Sep 29, 2023, at 1:58 AM, webmaster amigasource.com @.***> wrote:

 Good to go. If you noticed issue 6 is TOTALLY about going over the tables. They are messy, wordy and to not built properly for the current tasks or future growth!

You obviously noticed this so feel free to change whatever you need. Still at some point, after you come back, i would love to just spend 30 min discussing them.

On a side note i did my weekly update to the site and I hit 690 links. To make 1000 for the year i need to up my weekly new links count from 20 to 25.

I CANNOT wait till im no longer having to edit raw html and manually checking to see if i have already added this link or not. Oh and the same goes to updating my weekly ramblings!! Lol

On Sep 28, 2023, at 8:35 AM, Ben Overmyer @.***> wrote:



One of the things I'll be doing is getting rid of a lot of unnecessary wording in the column names.

For example, instead of table t_links having a column t_link_name, we'll have a table links having a column name. It's a little thing, but will help in the long run.

— Reply to this email directly, view it on GitHubhttps://github.com/AmigaNet/amigasource/issues/6#issuecomment-1739073496, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCXAQBTMRCR6IEYSHRBQZLLX4VVI5ANCNFSM6AAAAAA5CPE2AU. You are receiving this because you authored the thread.Message ID: @.***>

amigasource4000 commented 11 months ago

Well holy crap. . . You DID notice issue 6 because I JUST NOTICED that is email is actually part of the discussion thread under the issue on GitHub. Lol. Still learning.

But in my shitty defense im only seeing this email on my phone and didn’t notice the small print at the bottom . Lol

On Sep 28, 2023, at 8:35 AM, Ben Overmyer @.***> wrote:



One of the things I'll be doing is getting rid of a lot of unnecessary wording in the column names.

For example, instead of table t_links having a column t_link_name, we'll have a table links having a column name. It's a little thing, but will help in the long run.

— Reply to this email directly, view it on GitHubhttps://github.com/AmigaNet/amigasource/issues/6#issuecomment-1739073496, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCXAQBTMRCR6IEYSHRBQZLLX4VVI5ANCNFSM6AAAAAA5CPE2AU. You are receiving this because you authored the thread.Message ID: @.***>