On 9/16/11, Always Learning cen...@u61.u22.net wrote:
C1
c1ref
c1customer (code)
c1quantity (integers only)
c1price (in cents)
c1discount (2 decimal places held as integers)
c1catalogue (code)
c1date
Emmanuel Noobadmin wrote:
On 9/16/11, Always Learning cen...@u61.u22.net wrote:
C1
c1ref
c1customer (code)
c1quantity (integers only)
snip
then do a query:
select c1quantity, c1price, c1discount from c1 where c1customer =
'joebloggs' and c1date like '10%'
On 09/15/11 12:51 PM, Always Learning wrote:
that data is normalized, there is no redundant data in any of those
tables, they are connected by the relations defined via the references
('foreign keys').
I would not design my orders database exactly like you have.
once again, you completely
Golly Gosh, here we go again.
On Fri, 2011-09-16 at 11:10 -0700, John R Pierce wrote:
On 09/15/11 12:51 PM, Always Learning wrote:
I would not design my orders database exactly like you have.
once again, you completely miss the point, and go off on a tangent
explaining how YOU do
On Fri, Sep 16, 2011 at 09:18:24PM +0100, Always Learning wrote:
The point is I write programmes for pleasure. Naturally as an always
learning individual, I appraise others' methods and when they seem
advantageous and relevant I am likely to use them.
The point is that absolutely none of
Always Learning wrote:
On Fri, 2011-09-16 at 11:10 -0700, John R Pierce wrote:
On 09/15/11 12:51 PM, Always Learning wrote:
snip
When IBM introduced its Structured Query Language many years ago, it
seemed like a helpful facility for end-users who could, using SQL,
access they own data fairly
John R. Dennison wrote:
On Fri, Sep 16, 2011 at 09:18:24PM +0100, Always Learning wrote:
The point is I write programmes for pleasure. Naturally as an always
learning individual, I appraise others' methods and when they seem
advantageous and relevant I am likely to use them.
The point is
On Fri, 2011-09-16 at 16:28 -0400, m.r...@5-cent.us wrote:
As a point of information, it *was* intended for -managers- to get
reports themselves, rather than waiting weeks, or months, for a program to
be written.
Another cure for the software backlog. Heh. Heh. Heh
I'm thinking of
On Thu, 15 Sep 2011, Always Learning wrote:
Golly. I grew-up in real computers. Relational databases are simply
database structures, linking records. There is no reason to use joins
and views IF the database is carefully planned. Joins and views are
another overhead. Rule Number 01 in
On Thu, 15 Sep 2011, Always Learning wrote:
One day, if I have time, I want to programme a complete commercial
accounts systems using HTML, PHP and MySQL. Its a piece of cake to do
well (meaning easily) but a little time consuming. The only difficulty I
can think of is printing things
On Thu, 15 Sep 2011, Keith Roberts wrote:
To: CentOS mailing list centos@centos.org
From: Keith Roberts ke...@karsites.net
Subject: Re: [CentOS] Upgrade from 5.6 = 5.7
On Thu, 15 Sep 2011, Always Learning wrote:
One day, if I have time, I want to programme a complete commercial
accounts
On Thu, 2011-09-15 at 10:35 +0100, John Hodrien wrote:
On Thu, 15 Sep 2011, Always Learning wrote:
Golly. I grew-up in real computers. Relational databases are simply
database structures, linking records. There is no reason to use joins
and views IF the database is carefully planned.
On Thu, 2011-09-15 at 04:07 +0100, Always Learning wrote:
On Wed, 2011-09-14 at 19:17 -0700, Craig White wrote:
... snip interesting posting
WebApps are clearly the future - it's hard to justify specialized
server/client applications (installation, limited choice of clients,
On Thursday, September 15, 2011 08:21 PM, Always Learning wrote:
The integrity of the data can be divided into two aspects: ensuring the
data remains constant (unaltered) while stored, which is the
responsibility of the operation system and the database software, and
the data's integrity from
On Thursday, September 15, 2011 09:08 AM, John R Pierce wrote:
On 09/14/11 6:03 PM, Thomas Dukes wrote:
One day, if I have time, I want to programme a complete
commercial accounts systems using HTML, PHP and MySQL. Its a
piece of cake to do well (meaning easily) but a little time
On Thu, 2011-09-15 at 05:16 -0700, Craig White wrote:
Gmagic/Imagick are somewhat incapable of doing graphing at all.
Have you ever really looked ? What about GmagickDraw::point and similar
items ?
You would likely use a flash or google charts implementation these days
to generate graphs
On Thu, 2011-09-15 at 20:41 +0800, Christopher Chan wrote:
On Thursday, September 15, 2011 08:21 PM, Always Learning wrote:
The integrity of the data can be divided into two aspects: ensuring the
data remains constant (unaltered) while stored, which is the
responsibility of the
Always Learning wrote:
What did you expect ? Its not Windoze ;-)
Hrm. In an effort to pull this thread back onto topic, instead of a my
IBM DB2 database is better than your mysql junk anyday thread, let's
look back at various known issues over each release cycle;
5.1 -
On Thu, 15 Sep 2011, Always Learning wrote:
On Thu, 2011-09-15 at 05:16 -0700, Craig White wrote:
Gmagic/Imagick are somewhat incapable of doing graphing at all.
Have you ever really looked ? What about GmagickDraw::point and similar
items ?
I think the risk of the KISS approach is that
This whole thing has gone wildly OT, so I'll check out on this post.
On Thu, 15 Sep 2011, Always Learning wrote:
Hopefully that is always possible - retrieving EXACTLY what was stored
in the database. Why would one want the database to manipulate (change)
data ? Is that a solution for lazy
Top note: I missed this whole thread, being on the east coast of the US,
and it came in overnight.
Always Learning wrote:
On Thu, 2011-09-15 at 05:16 -0700, Craig White wrote:
snip
You would likely use a flash or google charts implementation these days
to generate graphs as there are all
John Hodrien wrote:
On Thu, 15 Sep 2011, Always Learning wrote:
On Thu, 2011-09-15 at 05:16 -0700, Craig White wrote:
Gmagic/Imagick are somewhat incapable of doing graphing at all.
Have you ever really looked ? What about GmagickDraw::point and similar
items ?
I think the risk of the
On Thu, 2011-09-15 at 14:42 +0100, John Hodrien wrote:
I think the risk of the KISS approach is that you tend to reimplement
everything, because everything everyone else has done is overcomplicated.
I share coding within systems (because it means just a single
alternation each time) and have
In article b0189c04b5d9a25bd50d4ceacf479b79.squir...@mail.5-cent.us,
m.r...@5-cent.us wrote:
John Hodrien wrote:
On Thu, 15 Sep 2011, Always Learning wrote:
On Thu, 2011-09-15 at 05:16 -0700, Craig White wrote:
Gmagic/Imagick are somewhat incapable of doing graphing at all.
Have you
On Thu, 2011-09-15 at 14:30 +, Tony Mountifield wrote:
More to the point would be: Judging something *solely* on its
simplicity is an overly simplistic approach. -- Kiel Hodges. This
appears to me to be the trap that Paul Always Learning has fallen
into.
Judge my systems on their:-
In article 1316097747.32765.118.ca...@m6.u226.com,
Always Learning cen...@u61.u22.net wrote:
On Thu, 2011-09-15 at 14:30 +, Tony Mountifield wrote:
More to the point would be: Judging something *solely* on its
simplicity is an overly simplistic approach. -- Kiel Hodges. This
appears
Tony Mountifield wrote:
In article b0189c04b5d9a25bd50d4ceacf479b79.squir...@mail.5-cent.us,
m.r...@5-cent.us wrote:
John Hodrien wrote:
On Thu, 15 Sep 2011, Always Learning wrote:
On Thu, 2011-09-15 at 05:16 -0700, Craig White wrote:
Gmagic/Imagick are somewhat incapable of doing
On 9/15/11, Always Learning cen...@u61.u22.net wrote:
I have written 20+ complete systems using these and found them to be
fast and very effective. Everyone who has seen my HTML, CSS, PHP, MySQL
systems has been favourably impressed (me too!). MySQL is a fast
database system. Never ever used a
On 9/15/11, Always Learning cen...@u61.u22.net wrote:
Next you'll be saying you don't use triggers and constraints either.
Not consciously. Never heard of them.
You should take a look at constraints, they are good for ensuring
certain types of data integrity. For example, it would make the
Emmanuel Noobadmin wrote:
On 9/15/11, Always Learning cen...@u61.u22.net wrote:
I have written 20+ complete systems using these and found them to be
fast and very effective. Everyone who has seen my HTML, CSS, PHP, MySQL
systems has been favourably impressed (me too!). MySQL is a fast
On Fri, 2011-09-16 at 00:56 +0800, Emmanuel Noobadmin wrote:
So how do you retrieve data that are kept in different tables? Or do
you simply replicate the same data in every single table that needs
it?
No unnecessary replication because it wastes space and needs multiple
updates. A customer
Emmanuel Noobadmin wrote:
On 9/15/11, Always Learning cen...@u61.u22.net wrote:
snip
Simplicity and good design makes applications fast.
For some apps, fast is king. For some, data security and integrity is
ultimate. Would you want your banking transactions to run faster by
stripping out
On 9/16/11, m.r...@5-cent.us m.r...@5-cent.us wrote:
I've done a lot of what we used to call embedded SQL, and when I did do a
join, it was *not* an explicit join. I've also used right or left once?
twice? ever? But then, I carefully design and code my queries.
So it's more like a series of
On 9/16/11, m.r...@5-cent.us m.r...@5-cent.us wrote:
You *need* both. Take too long, and the user will go somewhere else.
Of course :D
I remember hearing about another division, a bunch of years ago, when I
worked at the Scummy Mortgage Co. (name available upon request, offline),
where the
On 9/16/11, Always Learning cen...@u61.u22.net wrote:
Data is generally stored once. However because of legal requirements a
customer's invoicing name and address and delivery address will be
copied from the customer file and permanently stored in an invoice's
header record. This means when
On 09/14/11 8:36 PM, Always Learning wrote:
And, if you've never used a SQL join, you don't know the first thing
about*relational* databases, you've been using SQL as though it was a
simple flat table ISAM, DBase-style circa 1983. Might as well use
BerkeleyDB for that, its even
On Fri, 2011-09-16 at 01:10 +0800, Emmanuel Noobadmin wrote:
On 9/15/11, Always Learning cen...@u61.u22.net wrote:
Next you'll be saying you don't use triggers and constraints either.
Not consciously. Never heard of them.
You should take a look at constraints, they are good for
On Thu, 2011-09-15 at 13:17 -0400, m.r...@5-cent.us wrote:
In other words, it was a failure. But then, that's another reason I
have always wanted, during the design phase, to talk to the actual end
users, *not* to the Manager Who Knew, I Mean, Everything.
The end-users definitely know what
On 9/16/11, Always Learning cen...@u61.u22.net wrote:
Before anyone can add data for customer 9865, the existing customer
record is displayed on the screen. This helps the user to be sure he/she
has got the correct customer. A customer not found message means the
record does not exist.
On Fri, 2011-09-16 at 01:41 +0800, Emmanuel Noobadmin wrote:
On 9/16/11, Always Learning cen...@u61.u22.net wrote:
select w1note from w1 where w1date = '$s5date'
This looks rather similar to what I am doing nowadays instead of
massive queries with sub-selects. Glad to see I'm not
On Thu, 15 Sep 2011, Always Learning wrote:
*snip*
Sometimes well-paid contract work can make the contractor feel like a
prostitute. Does one object to utter stupidity and walk-out or abandon
one's principals and stay ?
I gues it depends on how much the hourly rate is ;)
Kind Regards,
On Fri, 2011-09-16 at 01:58 +0800, Emmanuel Noobadmin wrote:
On 9/16/11, Always Learning cen...@u61.u22.net wrote:
But wouldn't an added layer of safety be better?
Yes of course.
After all, there could be race conditions where two or more users could
cause the application to pass the
On Thu, 2011-09-15 at 10:42 -0700, John R Pierce wrote:
lets come up with a really simplistic example here.
table: customers{id, name, address}
table: catalogitem(id,description,price}
table: customerorder{id,customer references customers(id),date}
table: orderlineitem{orderid references
On Thu, Sep 15, 2011 at 08:51:23PM +0100, Always Learning wrote:
On Thu, 2011-09-15 at 10:42 -0700, John R Pierce wrote:
lets come up with a really simplistic example here.
table: customers{id, name, address}
table: catalogitem(id,description,price}
table: customerorder{id,customer
SUCCESS!! Everything working, even the 'roll your own' apps!!
Thanks!!
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
On Wed, 2011-09-14 at 19:05 -0400, Thomas Dukes wrote:
SUCCESS!! Everything working, even the 'roll your own' apps!!
What did you expect ? Its not Windoze ;-)
___
CentOS mailing list
CentOS@centos.org
-Original Message-
From: centos-boun...@centos.org
[mailto:centos-boun...@centos.org] On Behalf Of Always Learning
Sent: Wednesday, September 14, 2011 7:07 PM
To: CentOS mailing list
Subject: Re: [CentOS] Upgrade from 5.6 = 5.7
On Wed, 2011-09-14 at 19:05 -0400, Thomas Dukes
On Wed, 2011-09-14 at 20:12 -0400, Thomas Dukes wrote:
You know, 'Always Learning' is the perfect username! I'm 56 yrs. old and I
learn something everyday on this list. Been doing the Linux thing since the
mid-90's.
Blush, blush, I'm older.Been on Linux, properly, since 1 June 2010 and
-Original Message-
From: centos-boun...@centos.org
[mailto:centos-boun...@centos.org] On Behalf Of Always Learning
Sent: Wednesday, September 14, 2011 8:44 PM
To: CentOS mailing list
Subject: Re: [CentOS] Upgrade from 5.6 = 5.7
On Wed, 2011-09-14 at 20:12 -0400, Thomas Dukes
On 09/14/11 6:03 PM, Thomas Dukes wrote:
One day, if I have time, I want to programme a complete
commercial accounts systems using HTML, PHP and MySQL. Its a
piece of cake to do well (meaning easily) but a little time
consuming. The only difficulty I can think of is printing
things
On Wed, 2011-09-14 at 18:08 -0700, John R Pierce wrote:
an accounting system thats in plain HTML would be incredibly clunky to
use. you really want to do this in ajax/jquery or whatever so its more
interactive
No thank you. HTML, CSS, PHP and MySQL are my chosen tools for my
systems.
I
On Wed, 2011-09-14 at 18:08 -0700, John R Pierce wrote:
On 09/14/11 6:03 PM, Thomas Dukes wrote:
One day, if I have time, I want to programme a complete
commercial accounts systems using HTML, PHP and MySQL. Its a
piece of cake to do well (meaning easily) but a little time
-Original Message-
From: centos-boun...@centos.org
[mailto:centos-boun...@centos.org] On Behalf Of Always Learning
Sent: Wednesday, September 14, 2011 9:40 PM
To: CentOS mailing list
Subject: Re: [CentOS] Upgrade from 5.6 = 5.7
On Wed, 2011-09-14 at 18:08 -0700, John R
On 09/14/11 6:39 PM, Always Learning wrote:
Ajax/Jquery is someone else's parametrised programming language. It adds
complexity and overhead to what is fundamentally a very basic task. Ajax
etc. seem to appeal to people who are not good (or natural) programmers.
Ajax etc. is like programming
On Wed, 2011-09-14 at 19:17 -0700, Craig White wrote:
... snip interesting posting
WebApps are clearly the future - it's hard to justify specialized
server/client applications (installation, limited choice of clients,
maintenance, licensing) and it seems that the future will offer 2
On Wed, 2011-09-14 at 19:32 -0700, John R Pierce wrote:
On 09/14/11 6:39 PM, Always Learning wrote:
Ajax/Jquery is someone else's parametrised programming language. It adds
complexity and overhead to what is fundamentally a very basic task. Ajax
etc. seem to appeal to people who are not
56 matches
Mail list logo