threepach
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
- my client had to pay more to active MySQL
- database was a simple product list
- it was easy to convert product list from existing Excel file to CSV
- 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 ...
|
Reply
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. 
Reply
threepach
Feb 19 2008, 08:30 PM
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. jlhaslip, Thank you very much, i'm going to have a look Mylittlecms and Cutenews. now i got the bigger image i wanted. Cheeeers 
Reply
Similar Topics
Keywords : php, simple, csv, list, database,
- A List Of Animals And Their Meaning
Like the title says (1)
Need Help With My Database [resolved]
retrive data as a link (6) This is the situation: I have a database where you can add bands ( theire albums, genre other
info) For the album part they can add for each album the songs. So what do i want: When i show
the results there only shoul display the bandname which should be a link to the more detailed info
like albums biography etc. How do I do that. Is there a name for this and are there any
tutorials. thx in advance....
Is The Database System Gone Again? [resolved]
Errors on PHPMyAdmin again (12) I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
current setting of session.save_path is correct
(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
Database Or Pdf
Best way to list books on my site (1) Hi all, I am not sure if this is the right place to post but I'm sure you'll tell
me if it's not. My problem is this: I have a website where I sell books and it's one of
those simpleton sites where I don't need to know code, I just click icons etc Anyway, I can
upload images to the server and need to have them in different resolutions and link from a thumbnail
to the larger picture. What I am trying to say is I have about 6000 books to display on my
website which is impractical as it takes me about 10 mins to load 1 copy. What is the ....
Recommended List Of Money Making Sites
A list of 10 sites from which easy money can be made (0) I just want to let everyone know I have updated my list of money making websites and in my opinion
the 10 listed are the most reliable and honest money making sites that are free to join available.
Please review this blog and let me know what you think http://makeeasymoney247.blogspot.com ....
Please Can You Review My Blog
List of recommended sites for making money online (3) I am currently in the process of constructing a list of the best sites through which to make money
online and would like people to take a look at the sites I have added so far. I am obviously still a
long way of completing it but just wondering whether people think it is a good site / idea
http://makeeasymoney247.blogspot.com Also if you have not yet signed up to ClixSense I would
highly recommend it. You can join for free but you are better of paying the small $10 yearly
membership fee as this will bring you a ton more paid adverts - more than any other site I ....
A Simple Preg_replace Help Please.
(1) Hello.. Im looking for some help. I want to use preg_replace function to replace the following type
of code tags. CODE <code lang="php"></code> <code
lang="javascript"></code> <code lang="css"></code>
My question is that, in the above code tags, language (lang) is not always same, how can i use
preg_replace with the above code tags to place them with something. Any help will be very much
appreciated. thanks.....
Simple Is Beter - The Future Of Computers?
In the future, what will computers be like? (3) -Computers - The future - Who knows - I often wonder what the average home
computer will be like in ten or twenty years time; They seem to get larger, and have more functions,
be faster, and have more RAM ect. People always look for speed when buying a computer - But is this
really the way forward? If you have formatted your hard drive, then re-installed your operating
system; you will have noticed, that things run very smooth, very fast, and with few or no error
messages. But as soon as you have installed all your devices, media software, some games m....
Arrays And List Boxes
VB6 Codes needed (2) Hello Guys, I am working on an application. It is such that there are 2 list boxes or combo boxes.
One is Labeled Departure and the other is labeled Destination. The boxes contain various states in
America and each state has its unique feature of distances. The difference of the distances has to
be reflected on a label. Where I need help is a code to execute the contents of the array into
values For instance: Option Explicit Private Type Stateinfo statedeparture as integer
stateDestination as integer TotalDistance as integer End Type Dim StateDistance ....
Phpmyadmin
Create new database: No Privileges (6) i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
install it the error is like this Creating Database Tables No database selected there a mysql
database is made, but i can not use it for othere stuff... plz note that this is Free script and not
for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
but i am not sure if the script not working or it can be the server may be down on mysql...? ....
How To Make An Ultimate Game List.
If you're making a site on video games or such. (0) Hello. I am BuBBaG. You can call me Bubba for short. I'm going to show you how to make an
Ultimate Game List. First off, we need to make a database, we are going to call this database
`my_db`, leave out the `'s. Inside that database we will need to create a table
called `ugl'(Ultimate Game List, duh). To make the table, simply enter this in the Syntax.
CODE CREATE TABLE ugl ( System char(50), Game char(50), ) In the
above code, it is stating we are creating a table called ugl, with two columns, System, and Gam....
Posts To Mailing List Are Blocked
Every post to the mailing list returns a Delivery failure notice. (1) The mailing list appears to be intact but every attempt to post to it receives a Delivery failure
notice. Here are 2 examples from 2 different emails. QUOTE
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ---------------------------------EXAMPLE
NOTICE #1--------------------------------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> This is an automatically generated Delivery
Status Notification Delivery to the following recipient failed permanently:
future@renaissance.trap17.com Technical details of permanent failure: PERM_FAILURE: Gm....
Simple Javascript And Password System
How to protect your pages with password (6) The quickest way to get a password protection system up and running is to use a Prompt box in
JavaScript that has a title like "Enter your Email Address". Only you and the relevant users know
what the password should be, could even be one each, that can be sorted out at the next page then
pass the "input" directly through the url by changing the .href, like
http://www.iSource.net.nz/users/?leTmeIn= The page that then processes this should also check for
the referring page, and three fails from an IP if you like the php (the next page): CODE
<?php // processdo....
Can Anyone List Some Good Urls For Photoshop Brushes?
(5) I've been dying to find some good brushes. But all the ones I can find are on deviantart.com but
they aren't exactly what I'm looking for. I'm looking for different types of brushes
like brand types, peace signs, flowers and stars. Do you guys know any other good sites where I can
find these brushes? Thank You So Much! If you want, you can help post some sites for other
types of brushes that you enjoy using!....
List Of Free Directories To Submit Your Websites
(7) Hi: Submission in free directories is a world-known way to increase ranking and traffic. But most
of you don't know a good source of that list of directories. Here is a great source of free
directories list . Just start submission in those directories in your free time, and see you
ranking.......
Database With Mysql++
getting mySQL++ to work with trap17 (7) Hi, I'm trying to build an online game and figured the easiest way to do the server list would
be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
website and I always get an abnormal program termination; however, it will work with the mySQL on my
own machine. The code is below: CODE #include <iostream> #include <iomanip>
#include <mysql++> #include "pass.h"//holds my password (i program at
school) int main(void) { Connection con("t3jem3_test","....
157 Of The Best Free Software On The Net
Freeware Software List (7) I nearly had a heart attack when I saw this e-magazine (PC Magazine) on a website that will remain
nameless just because of the nature of this website. Anyway with my wonderful pdf extracting skills
I cut the pages down, and if all goes well the links to the original article should still work. So
what kind of software are we talking about well I put it like this you might already have them,
software covers Operating Systems, Antivirus/Anti-Malware, Firewalls, Security, Finance, Office,
Calendar/PIMs, Backup/Sync, App Launchers, Utilities, Downloads, Interface Enhanceme....
A List Of Great Movies!
(160) Ok, muy favorite movies are: Butterfly Effect Pirates of the Caribbean (The curse of the Black
Pearl) Titan AE....
Dialup Users Double Your Connection Speed
with simple modem command tweek (6) I found this instruction on the net and I'm wondering this actually "speeds up" a dial up
connection? QUOTE Suffering from 52 kbps internet connection? Follow these simple steps and
double your internet connection speed: Connect to the internet Click Start and select control
panel Click Phone and Modem Select Modems tab and then click Properties Click the Advanced tab
and in the extra initialization commands type AT&FX Click Ok and disconnect from the internet
Connect to the internet again and enjoy your 115 kbps connection! Source http....
What Is God?
simple question, hard to answer! (52) Yeah this is the only thing I'd like to know! Is he a big old man with a beard somewhere
above us (interstingly what is UP on one side of the earth is DOWN on the other side of it - so
where is God then if we point up there?)??? Is he inside of us? Are we all a part of god? Is God
present in everything that surrounds us? Isn't it interesting that GOD is very close to GOOD?
Maybe it is a metaphore for being and doing GOOD things?? That is something we have inside of us -
every normal human being has this feeling for what is good and bad and is tryin' to f....
Watermark Your Image With Simple Php Script
found it on the net (34) This script was found on the net http://tips-scripts.com/?tip=watermark#tip B&T's Tips &
Scripts site. Just in case the site may not show, I will include the code here: List of things
needed: 1. your image in any format 2. watermark image--in gif format with transparent background 3.
script below with name (i.e. watermark.php) CODE <?php // this script creates a watermarked
image from an image file - can be a .jpg .gif or .png file // where watermark.gif is a mostly
transparent gif image with the watermark - goes in the same directory as this script // ....
Simple C File Handling In Action
Small code snipet which covers most of basic file handling and navigat (3) Yesterday I suddenly got a lot of work. The same work we try to push off, yes you are right all
formalities to get the code review incorporated and update all source code files with code review
headers. Imagine if you need to open 300 files one by one and append code review headers at the
end. Since most files are reviewed in groups of 20 to 30 files. We require one header to be placed
in say 20 to 30 files. To simplify I went back to my class assignment days and wrote this small c
utility to open all files passed on command line and open attach code review headers an....
Connect To Remote Oracle Database With Toad
i'm lost (6) Hey gang, long time no see, my bad! Anyway, I got me a question. Does anybody know how to
connect to a remote oracle database using toad? When I read the docs for toad I get the impression
that I have to have a local oracle installation in order to use toad, but that just seems silly. I
guess I'm stuck at the point of trying to figure out how to tell toad where to look for all of
the configuration information it needs for the connection if I don't have any "Oracle Home"
directories. :crosses fingers: Peace!....
A List Of Awesome Free Fps'
(first person shooters) (29) Ok, so here's an awsome list of some free first person shooters that AREN'T CRAP. These are
actually made by the pros. these are for all PC OSes. Wolfenstein - enemy territory Nexuiz
America's Army- special forces Counter Strike edit: I'm dumb. Legends ....
Mysql Database Size
related to the free database space (6) hi all! this is my first post /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> and i have a doubt, how much mysql space i am allowed to use... i mean how
much is available for my free account....
Import From Excel File Into Mysql Database
(7) Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the....
Msgbox
Here is a simple way and lists of MsgBoxes. (17) Here are lists of MsgBoxes: Syntax: MsgBox Prompt, MsgBoxStyle, Title, HelpFile MsgBox "Uh,
text!", , "Uh, Title!" MsgBox "Uh, text!", vbCritical, "Uh, Title!" MsgBox "Uh,
text!", vbExclamation, "Uh, Title!" MsgBox "Uh, text!", vbInformation, "Uh, Title!"
MsgBox "Uh, text!", vbOKCancel, "Uh, Title!" MsgBox "Uh, text!", vbQuestion, "Uh,
Title!" MsgBox "Uh, text!", vbYesNo, "Uh, Title!" MsgBox "Uh, text!", vbYesNoCancel,
"Uh, Title!" MsgBox "Uh, text!", vbRetryCancel, "Uh, Title!" MsgBox "Uh, text....
List GMail Giveaway
(58) The following are people who are willing to giveaway their invites. If you need them, you can refer
to this list:
OrionLeingod = stoneddevil(at)gmail(dot)com
Random = boomba.is(at)gmail(dot)com
rmdort = rmdort(at)GMail(dot)com
TWIXMIX = ryan.nielson(at)GMail(dot)com
chakhei =
peter4all(at)rediffmail(dot)com or PM him
Afula = ivgenib(at)GMail(dot)com
Bandit =
bandit.mafiot(at)GMail(dot)com
Emilin =emi.babe AT gmail DOT com
nate9000 = nate9000 (AT) gmail
(DOT) com
gowron = paul(at)magielse(d0t)com
Darthbob = therealdarthbob AT gmail DOT com
TheStand
= Bren....
need a good and simple php-nuke tutorial
(17) hello everybody
i'm new to php-nuke , after installing it on my server i can't understand how the
structure of the system works ,i have been looking at some tutorials about php-nuke but some of them
were written like i know the system and what they are explainning is like a reminder of some kind
can some one help me to find good and simple php-nuke tutorial.
thanx....
Php Mod Rewrite Tutorial
Simple tutorial (3) REQUIRED: Internet server (Apache 1.3.33 recomended), php, basic skills with .htaccess Mod
rewrite is cool Apache option, it helps you to make your site URLs simple and clean... also it is
perfect for search engines... This is mod rewrite, it replaces : CODE
site.com/index.php?include=files?ID=45 with: CODE site.com/files/45 so lets get startet,
open notepad, enter this in it: CODE RewriteEngine On // - you are starting rewrite mod
:) RewriteBase / // - you set the rewrite base RewriteRule
^(.+)/([0-9]+)/?$ in....
Looking for php, simple, csv, list, database,
|
|
Searching Video's for php, simple, csv, list, database,
|
advertisement
|
|
Jul 25, 2008
