Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Php With Simple Csv List As Database, What Do U Think?
threepach
post Feb 18 2008, 01:01 PM
Post #1


Newbie [Level 3]
***

Group: [HOSTED]
Posts: 42
Joined: 17-February 08
Member No.: 58,025



I've designed a php website and i used simple CSV file as my database because of few reasons
  1. my client had to pay more to active MySQL
  2. database was a simple product list
  3. it was easy to convert product list from existing Excel file to CSV
  4. it is easy to make any changes

so i have few files to convert to CSV if i wanna update the website.

I know it's less secure specially if it's an online business (which is not).

question is : what are disadvantages?
is that slower than MySQL?
is there more possibility of occurring bug?
is that less professional?
or ...
Go to the top of the page
 
+Quote Post
jlhaslip
post Feb 18 2008, 06:51 PM
Post #2


A computer once beat me at chess, but it was no match for me at kick boxing.
Group Icon

Group: [MODERATOR]
Posts: 3,753
Joined: 24-July 05
From: In Trouble Again... still?
Member No.: 9,787
Spam Patrol



"Flat-file" Databases were used for a long time by lots of people to do lots of things. They work.
For a small application you won't have much trouble and the speed won't be an issue. Flat file access is 'sequential', meaning you need to read from the start of the file to find the 'data you are looking for , whereas Databases are 'indexed', so read access starts at the data record you have the index for.
As long as the product lists are not too large, or the requests for data are small, you will be okay.
There are several Packages out there that might fill your needs. Check out Mylittlecms and Cutenews. Both of them run on Flat files, and might help you out. Check out their coding to see how they do stuff.
As the site gets larger, and busier, you might need to bite the bullet and convert to a Database. On the otherhand, you might actually enjoy all the coding that you will need to do. smile.gif
Go to the top of the page
 
+Quote Post
threepach
post Feb 19 2008, 08:30 PM
Post #3


Newbie [Level 3]
***

Group: [HOSTED]
Posts: 42
Joined: 17-February 08
Member No.: 58,025



QUOTE(jlhaslip @ Feb 18 2008, 06:51 PM) *
"Flat-file" Databases were used for a long time by lots of people to do lots of things. They work.
For a small application you won't have much trouble and the speed won't be an issue. Flat file access is 'sequential', meaning you need to read from the start of the file to find the 'data you are looking for , whereas Databases are 'indexed', so read access starts at the data record you have the index for.
As long as the product lists are not too large, or the requests for data are small, you will be okay.
There are several Packages out there that might fill your needs. Check out Mylittlecms and Cutenews. Both of them run on Flat files, and might help you out. Check out their coding to see how they do stuff.
As the site gets larger, and busier, you might need to bite the bullet and convert to a Database. On the otherhand, you might actually enjoy all the coding that you will need to do. smile.gif



jlhaslip, Thank you very much, i'm going to have a look Mylittlecms and Cutenews. now i got the bigger image i wanted.
Cheeeers rolleyes.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Free Classified Ads--no Hype(3)
  2. Php Simple Login Tutorial(63)
  3. Getting List Of Directories And Files Using Php(6)
  4. need a good and simple php-nuke tutorial(16)
  5. Super Smash Brothers 3(43)
  6. Import From Excel File Into Mysql Database(5)
  7. A List Of Awesome Free Fps'(21)
  8. Need Help With Using Css(11)
  9. Can You Add Images Into A Mysql Database?(20)
  10. Simple C File Handling In Action(2)
  11. Truefusion Shoutbox(31)
  12. What Is God?(49)
  13. Proxy List(29)
  14. Pci Simple Communications Controller / Multimedia Audio Controller(5)
  15. A List Of Great Movies!(158)
  1. Free Sms Site(4)
  2. Making Money Online(7)
  3. A List Of Great Free Software(9)
  4. How Often Do You Use Css?(7)
  5. Database With Mysql++(5)
  6. Transferring From Old Server To New Server "database And Forum" [resolved](5)
  7. Index In A Mysql Database(3)
  8. List Of Free Directories To Submit Your Websites(2)
  9. Can Anyone List Some Good Urls For Photoshop Brushes?(2)
  10. Html Ascii Codes - A Complete List(3)
  11. Simple Javascript And Password System(5)
  12. Verifying Your Email Address(0)
  13. Ms-access Database Question(3)


 



- Lo-Fi Version Time is now: 16th May 2008 - 10:19 AM