I was hoping someone could lend me some advice. Long story short, it took the client I am writing a website for close to a month to learn how to use FTP. And she wants to do updates to a database by herself and upload it to the website.
She will not work with anything but an Excel style spreadsheet. So, here is my question. The database (or dat file) has about 20,000 records and around 15 fields each. Do you think working with a dat file (or flat file) would be that much more inefficient than working with a mySQL database? My parsing flat files knowledge is not so hot, but, it would probably only take a couple hours to learn.
My reasoning is, it takes two steps to upload if we are using the dat file and parsing that. It would most likely take her months to figure out how to use the csv to mySQL conversion tool that we had planned on. This is even if I write detailed instructions. Writing a web interface is out of the question due to time contraints and funding. Thank you for any advice!
Unfortunately, the conversion tool is actually closed source and encrypted. The more I think about this, Xenatino, you are mirroring my sentiments. We are going to have to do the mySQL database, it's just not feasible with the flat file.
It really all depends. Even very large files can be parsed efficiently, though there's a lot of people that don't do it right, read it in or parse it inefficiently, or even read all the data into memory before it's parsed (yikes). The same can be done with the database, and how the data is stored, how it's called/read in, how it's parsed, etc. MySQL should be faster, if it's done right, and can better deal with the data as it might grow. It should only take a few minutes for a coder to do.
Well Ive been in this situation before .I think your DB is prety huge.
It is better to use database be it MySQL or Postgres for this purpose.
When you store records in DBs, they are stored as binaries which are going to be way smaller in size and faster than your flat file, not to mention the added flexibility.
What you can do with Cpanel ------------------> |||||
What you can do with Cpanel XP+CpanelAPP -------> ||||||||||||||||||||||||||||||||||||||||
Roy, thanks for the reply. I'm looking into creating a custom form for Access to link to the remote database. I will probably be using the ODBC connector that ringnebula mentioned above. Having a problem with it right now, but, it looks like a solid solution. Thanks again guys for the replies.