Sean
|
| Posted: 05/21/2001, 8:36 PM |
|
Hello everyone,
I'm just playing around with CodeCharge trial right now evaluating
it for purchase. It looks greatso far except for one thing. Maybe I'm just
an idiot and don't know how to do it or it isn't supported but why doesn't
CC generate the DB tables and fields based on the code. This product would
be awesome if I could design something say like bugtracking or whatever and
hit generate and not only would the code be generated but a .sql or .mysql
script to run that would create the tables and fields I need to get my
generated code working. Does this work now or is this something that will
work in the next release? If so then sign me up! If not does anyone know
of any products that create the php code and the corresponding mysql scripts
for the code?
Thanks in advance,
Sean
|
|
|
 |
CodeCharge
|
| Posted: 05/22/2001, 5:04 AM |
|
I don't believe that what you're asking is possible, at least yet.
Database design is a manual task, requires intelligence and many people
would design similar database differently.
Someone needs to specify the names of fields, decide how many tables should
be used and for what purpose, and how they corelate. A program cannot
automatically determine for example that a list of SubCategories should be
included in the Category table, or in it's own SubCategory table, or
possibly not be included in a table at all, just be mixed up directly with
the products in Item table.
If you specify all the tables and field names, then you'll end up designing
the database, which you just tried to avoid.
I recommend using Microsoft Access to quickly create your tables and then
use it as the base of your system. This could take less then an hour for the
bug tracking system. You can also use various tools to convert MS Access to
MySQL once you're finished.
"Sean" <sean.buck@investia.com> wrote in message
news:9ecms0$24i$1@mail.tankhill.com...
> Hello everyone,
> I'm just playing around with CodeCharge trial right now
evaluating
> it for purchase. It looks greatso far except for one thing. Maybe I'm
just
> an idiot and don't know how to do it or it isn't supported but why doesn't
> CC generate the DB tables and fields based on the code. This product
would
> be awesome if I could design something say like bugtracking or whatever
and
> hit generate and not only would the code be generated but a .sql or .mysql
> script to run that would create the tables and fields I need to get my
> generated code working. Does this work now or is this something that will
> work in the next release? If so then sign me up! If not does anyone know
> of any products that create the php code and the corresponding mysql
scripts
> for the code?
>
> Thanks in advance,
> Sean
>
>
|
|
|
|
Roger
|
| Posted: 05/22/2001, 6:17 AM |
|
What do you recommend for Access to MySQL?
--
Rgds
Roger Tng
"CodeCharge" <support@codecharge.com> wrote in message
news:9edkkd$rk6$1@mail.tankhill.com...
> I don't believe that what you're asking is possible, at least yet.
> Database design is a manual task, requires intelligence and many people
> would design similar database differently.
> Someone needs to specify the names of fields, decide how many tables
should
> be used and for what purpose, and how they corelate. A program cannot
> automatically determine for example that a list of SubCategories should be
> included in the Category table, or in it's own SubCategory table, or
> possibly not be included in a table at all, just be mixed up directly with
> the products in Item table.
> If you specify all the tables and field names, then you'll end up
designing
> the database, which you just tried to avoid.
>
> I recommend using Microsoft Access to quickly create your tables and then
> use it as the base of your system. This could take less then an hour for
the
> bug tracking system. You can also use various tools to convert MS Access
to
> MySQL once you're finished.
>
>
>
> "Sean" <sean.buck@investia.com> wrote in message
>news:9ecms0$24i$1@mail.tankhill.com...
> > Hello everyone,
> > I'm just playing around with CodeCharge trial right now
> evaluating
> > it for purchase. It looks greatso far except for one thing. Maybe I'm
> just
> > an idiot and don't know how to do it or it isn't supported but why
doesn't
> > CC generate the DB tables and fields based on the code. This product
> would
> > be awesome if I could design something say like bugtracking or whatever
> and
> > hit generate and not only would the code be generated but a .sql or
..mysql
> > script to run that would create the tables and fields I need to get my
> > generated code working. Does this work now or is this something that
will
> > work in the next release? If so then sign me up! If not does anyone
know
> > of any products that create the php code and the corresponding mysql
> scripts
> > for the code?
> >
> > Thanks in advance,
> > Sean
> >
> >
>
>
|
|
|
|
CodeCharge
|
| Posted: 05/22/2001, 4:27 PM |
|
Some of our users use DBTools at http://dbtools.vila.bol.com.br/
We will be also releasing MS Access 2 MySQL converter in a couple of weeks.
"Roger" <roger@web4sme.net> wrote in message
news:9edosg$k2$1@mail.tankhill.com...
> What do you recommend for Access to MySQL?
>
> --
> Rgds
> Roger Tng
>
> "CodeCharge" <support@codecharge.com> wrote in message
>news:9edkkd$rk6$1@mail.tankhill.com...
> > I don't believe that what you're asking is possible, at least yet.
> > Database design is a manual task, requires intelligence and many people
> > would design similar database differently.
> > Someone needs to specify the names of fields, decide how many tables
> should
> > be used and for what purpose, and how they corelate. A program cannot
> > automatically determine for example that a list of SubCategories should
be
> > included in the Category table, or in it's own SubCategory table, or
> > possibly not be included in a table at all, just be mixed up directly
with
> > the products in Item table.
> > If you specify all the tables and field names, then you'll end up
> designing
> > the database, which you just tried to avoid.
> >
> > I recommend using Microsoft Access to quickly create your tables and
then
> > use it as the base of your system. This could take less then an hour for
> the
> > bug tracking system. You can also use various tools to convert MS Access
> to
> > MySQL once you're finished.
> >
> >
> >
> > "Sean" <sean.buck@investia.com> wrote in message
> >news:9ecms0$24i$1@mail.tankhill.com...
> > > Hello everyone,
> > > I'm just playing around with CodeCharge trial right now
> > evaluating
> > > it for purchase. It looks greatso far except for one thing. Maybe
I'm
> > just
> > > an idiot and don't know how to do it or it isn't supported but why
> doesn't
> > > CC generate the DB tables and fields based on the code. This product
> > would
> > > be awesome if I could design something say like bugtracking or
whatever
> > and
> > > hit generate and not only would the code be generated but a .sql or
> .mysql
> > > script to run that would create the tables and fields I need to get my
> > > generated code working. Does this work now or is this something that
> will
> > > work in the next release? If so then sign me up! If not does anyone
> know
> > > of any products that create the php code and the corresponding mysql
> > scripts
> > > for the code?
> > >
> > > Thanks in advance,
> > > Sean
> > >
> > >
> >
> >
>
>
|
|
|
|
|
