Possible to make a DB when CSV's have no relation

  • (2 Pages)
  • +
  • 1
  • 2

22 Replies - 2205 Views - Last Post: 06 August 2017 - 12:53 AM Rate Topic: -----

#16 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13485
  • View blog
  • Posts: 53,847
  • Joined: 12-June 08

Re: Possible to make a DB when CSV's have no relation

Posted 02 August 2017 - 06:54 AM

Wait.. do you need to know that X data came from Y CSV and imported by M user, or do you just want all the data tossed into one bucket?
Was This Post Helpful? 0
  • +
  • -

#17 hokletrian  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 24-July 17

Re: Possible to make a DB when CSV's have no relation

Posted 02 August 2017 - 07:11 AM

I do all the importing automatically through some cron jobs and scripts, so after the users own csv table is established it is linked to the cron which automatically imports data into it. But at the moment its unnecessary because the user cant be "linked" to the table.. I guess tossing it into one bucket if that works? The whole point is basically so users can see their data displayed on their profile page which the monitoring units are spitting out . :surrender:
Was This Post Helpful? 0
  • +
  • -

#18 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13485
  • View blog
  • Posts: 53,847
  • Joined: 12-June 08

Re: Possible to make a DB when CSV's have no relation

Posted 02 August 2017 - 07:19 AM

Dude.. just.. ugh.

Yes - the user needs to be able to know what they uploaded and recall that, or no it does not matter who uploaded what is it goes in one bucket? Basically does there need to be a darn relationship between a specific CSV's worth of data and a user's id?
Was This Post Helpful? 0
  • +
  • -

#19 hokletrian  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 24-July 17

Re: Possible to make a DB when CSV's have no relation

Posted 02 August 2017 - 05:56 PM

Sorry man, yes there does ahah..
Was This Post Helpful? 0
  • +
  • -

#20 ndc85430  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 588
  • View blog
  • Posts: 2,477
  • Joined: 13-June 14

Re: Possible to make a DB when CSV's have no relation

Posted 03 August 2017 - 12:14 AM

Ok, so what's wrong with doing that, with, e.g. the association table that I mentioned?
Was This Post Helpful? 0
  • +
  • -

#21 hokletrian  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 24-July 17

Re: Possible to make a DB when CSV's have no relation

Posted 03 August 2017 - 05:30 PM

View Postndc85430, on 03 August 2017 - 12:14 AM, said:

Ok, so what's wrong with doing that, with, e.g. the association table that I mentioned?



The association table will only associate a user per record/row?
Was This Post Helpful? 0
  • +
  • -

#22 ndc85430  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 588
  • View blog
  • Posts: 2,477
  • Joined: 13-June 14

Re: Possible to make a DB when CSV's have no relation

Posted 03 August 2017 - 10:25 PM

Oh, I see. Do you need to access/modify individual pieces of data in a CSV file, or just access the file as a whole given a user? If the latter, then you could of course store each file in a column of type TEXT or BLOB (assuming the data was within the maximum allowed size for those types). However, I'm not sure what using a database would really give you if you were going to do that. Why not just store the files on a file system?

This post has been edited by ndc85430: 03 August 2017 - 10:28 PM

Was This Post Helpful? 0
  • +
  • -

#23 hokletrian  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 19
  • Joined: 24-July 17

Re: Possible to make a DB when CSV's have no relation

Posted 06 August 2017 - 12:53 AM

View Postndc85430, on 03 August 2017 - 10:25 PM, said:

Oh, I see. Do you need to access/modify individual pieces of data in a CSV file, or just access the file as a whole given a user? If the latter, then you could of course store each file in a column of type TEXT or BLOB (assuming the data was within the maximum allowed size for those types). However, I'm not sure what using a database would really give you if you were going to do that. Why not just store the files on a file system?



Thanks for the help mate. Yea i thought the file system would pretty much be the only way.. If the file system contained millions of CSV's would there be performance issues when opening them in graphs/charts you reckon ?
Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2