IPB

Welcome Guest ( Log In | Register )



Tags
This content has not been tagged yet
 
Reply to this topicStart new topic

Php With Simple Csv List As Database, What Do U Think?


threepach
no avatar
Newbie [Level 3]
***
Group: [HOSTED]
Posts: 42
Joined: 17-February 08
Member No.: 58,025



Post #1 post Feb 18 2008, 01:01 PM
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
no avatar
Insert Custom Title Here
*******************
Group: [MODERATOR]
Posts: 4,934
Joined: 24-July 05
From: Linux, DOS and Windows…the good, the bad and the ugly
Member No.: 9,787
Spam Patrol
myCENT:5.30



Post #2 post 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
Go to the top of the page
+Quote Post
threepach
no avatar
Newbie [Level 3]
***
Group: [HOSTED]
Posts: 42
Joined: 17-February 08
Member No.: 58,025



Post #3 post Feb 19 2008, 08:30 PM
QUOTE(jlhaslip @ Feb 18 2008, 06:51 PM) [snapback]374773[/snapback]
"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

    Topic Title Replies Topic Starter Views Last Action
No new   14 Spudd 1,212 25th September 2009 - 08:24 PM
Last post by: Spudd
No New Posts   12 BooZker 3,030 8th July 2006 - 07:50 AM
Last post by: BooZker
No New Posts   13 chinfo 8,738 2nd August 2004 - 03:12 AM
Last post by: X3r0X
No New Posts   7 Raptrex 13,227 27th August 2004 - 11:16 PM
Last post by: Spectre
No new   16 Saint_Michael 18,606 20th August 2009 - 06:09 PM
Last post by: ENDY_JASMI
No New Posts   8 j-s 5,492 30th September 2004 - 12:39 PM
Last post by: Zenchi
No New Posts   2 Raptrex 3,392 1st October 2004 - 05:53 AM
Last post by: serverph
No New Posts   4 brandrocker 611 27th December 2008 - 12:16 PM
Last post by: OpaQue
No New Posts   2 NeXDesigns 3,939 23rd October 2004 - 08:47 PM
Last post by: pweb
No New Posts 4 NuHoaXuLa 2,917 8th February 2009 - 10:58 AM
Last post by: Quatrux
No New Posts   2 Final)arkJon 3,695 31st October 2004 - 11:59 AM
Last post by: OpaQue
No New Posts   0 lawmatchmaker 729 23rd June 2006 - 07:46 AM
Last post by: lawmatchmaker
No new   26 hulunes 8,462 28th December 2004 - 07:18 PM
Last post by: splehati
No New Posts   4 logophobia 2,993 8th February 2009 - 11:01 AM
Last post by: Quatrux
No New Posts 2 rowita 4,318 16th April 2009 - 11:35 AM
Last post by: amrik09


 



RSS Open Discussion Time is now: 22nd November 2009 - 02:54 AM

Web Hosting Powered by ComputingHost.com.