yeah man it's real real easy. You can also use MS Access to
make a database as well for testing purposes. I wouldnt use MS
Access in full production because it's slow and it can only handle
one client at a time. But for testing purposes I use it all the
time, just because it's easy. And I can make sure all my tables are
in lined and my relationships are good, then I just reprogram it
into MySQL or PostGreSQL. It's easy.
As far as how to go about doing it. Log in to your CF Admin,
think it's something like
http://localhost:8500/CFIDE/administrator/index.cfm
Go down the menu on the left side til you see something like
databases or datasources or something like that, can't remember on
the top of my head, i just push the button. Then click add. It's
very very basic and simple.
If your doing a MySQL one, you gotta download the MySQL stuff
from their site. They got the driver or whatever it's called on
there, think it's like 15 to 30 megs. Then DL the Admin software
after you set up your local host mysql server. Then it's ready to
go. As well if you're really really new. There's software out there
that's free that can redo an MS Access database into MySQL and plug
it right into your mysql database with little or no effort. The
free ones that I have found only handle 10 records, so just dont
plug in a lot of info into your tables on access. But I really only
use access just to test my relationships and make sure it all
works, so it works good for me.
Sometimes they're will be a few bugs, usually in the bolean
values and I'll have to go in and manually edit that, as well as in
my source code for my web apps. But as far as code, you can always
use the CFqueryparam or whatever it's called, I just usually don't
unless I'm not 100% positive what database format I'm sending my
completed program too. Usually this is a good idea when dealing
with clients that don't know anything about their hosting provider.
O yeah, also dealing with MySQL, I've found some of the
software that comes with it, I just didn't like it. There's a
program that I really enjoy called navicat, its like 40 bucks, but
the free version should be more than fine for you if you're just
getting started. I'm big fan of navicat, but I don't have any
experience with the other software available out there. Navicat is
just a program that makes it easier to inspect the tables and
records and what not. Make sure all my boolean values and data are
correct before I make a dump file.
7
Replies
AdChoices