[Gambas-user] mysql float behaviour

nando nando_f at ...951...
Wed Jun 27 18:16:21 CEST 2012


Primary keys are supposed to be unique unrelated to the actual data
such as an INT with auto increment so there will never, ever be duplicates.

If you use actual data (like a name) you CAN get duplicates
and you are breaking the design theory.
If you think you'll never get a duplicate, you will.

In theory, and practice, your primary key ought not be real data
but rather an arbitrary think like INT.

Make a field called id as an INT primary auto increment.
Then make your other real data as an INDEX as you want.

What you're suggesting is not correct.

Follow this practice: I assure no grief !


---------- Original Message -----------
From: Bruce <bbruen at ...2308...>
To: mailing list for gambas users <gambas-user at lists.sourceforge.net>
Sent: Wed, 27 Jun 2012 22:02:29 +0930
Subject: Re: [Gambas-user] mysql float behaviour

> On Wed, 2012-06-27 at 04:25 -0700, Bill-Lancaster wrote:
> > Thank you Benoît - it worked fine.
> > Where can I find more info re this '&1' ?
> 
> Hi Bill,
> 
> It's in the help at gb.db.Connection.Subst
> 
> You're right.
>         Connection.Find ( Table As String [ , Request As String,
>         Arguments As , ... ] ) As Result
> doesn't really explain it well.
> 
> regards
> Bruce
> 
> (p.s. I'm going to be a bit "rdms-ist" here.  If you are looking for a
> proper rdbms without weird problems, do yourself a favour, bypass MySQL
> and use postgresql.  Why? Because for example, if you are ever in the
> case when your natural primary key may include things like names such
> as 
> 	"van der Plum-O'Brien-MacDonald III, Sioban"
> 
> then mysql will drive you nuts. :-) Seriously, the effort to learn
> postgresql is worth it. Here is a "oldish" site that highlights my
> feelings http://ask.metafilter.com/92162/MySQL-vs-PostgreSQL and in
> particular one that is referenced there, if you have a couple of million
> brain cells to spare,
> http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems  )
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
------- End of Original Message -------





More information about the User mailing list